My Oracle Support Banner

MYSQL Extract Shows Incorrect 'Lag At Chkpt' In Goldengate 18.1 (Doc ID 2499299.1)

Last updated on FEBRUARY 20, 2020

Applies to:

Oracle GoldenGate - Version 18.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Using Goldengate 18.1 version for remote extraction on mysql. When the table does not have a DML operation, the Lag at Chkpt displayed on the extract process will continue to increase.
After inserting  data into the source, Lag at Chkpt will immediately become 0.

Below is detail:

Program       Status           Group       Lag at Chkpt  Time Since Chkpt
EXTRACT     RUNNING        EXT1              00:02:25      00:00:04    ---> Lag at Chkpt is 2+ minutes
 
>>>>> insert a record into the test table ABC.TAB1 , the lag becomes 0

Program        Status      Group       Lag at Chkpt  Time Since Chkpt
EXTRACT     RUNNING     EXT1             00:00:04      00:00:00        ---> Lag at Chkpt become to 0

GG version is:

OGG version: Version 18.1.0.0.0 OGGCORE_18.1.0.0.0_PLATFORMS_180928.0432
Database version: Server version: 5.7.20-log MySQL Community Server (GPL)

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.