OGG PostgreSQL: Extract - Positioning Sequence ID Is Out Of Order :OGG-04036 (Doc ID 3001816.1)

Last updated on JULY 30, 2024

Applies to:

Symptoms

Extract report:

Goldengate extract on postgres database ABEND with the following error message

2023-10-30T13:21:32.060+0000 ERROR OGG-04036 Oracle GoldenGate Capture for PostgreSQL, edevpg2.prm: Positioning sequence ID is out of order, old sequence ID is 00000049/28B1D380, new sequence ID is 00000049/12202300.
2023-10-30T13:21:32.157+0000 ERROR OGG-01668 Oracle GoldenGate Capture for PostgreSQL, edevpg2.prm: PROCESS ABENDING.

Aurora server Transaction Logs:

Errors in the Aurora server logs were observed at the time when OGG hit sequence ID out of order error. Following error was discovered in the transaction logs:

023-11-28 08:42:59 UTC:10.111.232.55(38142):gguser@dbsmaint:[2039]:ERROR: unexpected pageaddr 5E/9F3D4000 in log segment 000000010000005E00000028, offset 54345728
2023-11-28 08:42:59 UTC:10.111.232.55(38142):gguser@dbsmaint:[2039]:STATEMENT: START_REPLICATION SLOT "edevpg2_ab0c38030d4e4962" LOGICAL 5E/98A54F60 ("include-timestamp", "include-xids")
2023-11-28 08:43:00 UTC:10.111.232.55(38082):gguser@dbsmaint:[2323]:LOG: starting logical decoding for slot "edevpg2_ab0c38030d4e4962"
2023-11-28 08:43:00 UTC:10.111.232.55(38082):gguser@dbsmaint:[2323]:DETAIL: Streaming transactions committing after 5E/9F4BED38, reading WAL from 5E/740827F0.
2023-11-28 08:43:00 UTC:10.111.232.55(38082):gguser@dbsmaint:[2323]:STATEMENT: START_REPLICATION SLOT "edevpg2_ab0c38030d4e4962" LOGICAL 5E/9F4BED38 ("include-timestamp", "include-xids")
2023-11-28 08:43:00 UTC:10.111.232.55(38082):gguser@dbsmaint:[2323]:LOG: logical decoding found consistent point at 5E/740827F0
2023-11-28 08:43:00 UTC:10.111.232.55(38082):gguser@dbsmaint:[2323]:DETAIL: Logical decoding will begin using saved snapshot.
2023-11-28 08:43:00 UTC:10.111.232.55(38082):gguser@dbsmaint:[2323]:STATEMENT: START_REPLICATION SLOT "edevpg2_ab0c38030d4e4962" LOGICAL 5E/9F4BED38 ("include-timestamp", "include-xids")

Cause

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