OGG PostgreSQL: Extract - Positioning Sequence ID Is Out Of Order :OGG-04036
(Doc ID 3001816.1)
Last updated on JULY 30, 2024
Applies to:
Oracle GoldenGate - Version 21.9.0.0.0 and laterLinux x86-64
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
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 |
Cause |
Solution |
References |