My Oracle Support Banner

Postgressql capture abends with ERROR OGG-04036 Positioning Sequence ID Is Out Of Order (Doc ID 2738142.1)

Last updated on DECEMBER 24, 2020

Applies to:

Oracle GoldenGate - Version 19.1.0.0.2 and later
Information in this document applies to any platform.
After cluster fail over on RDS, the extract fails with below error

ERROR OGG-04036 Positioning sequence ID is out of order, old sequence ID is 00000nnn/a666a555aa, new sequence ID is 00000nnn/b666b555bb

Customer has to alter the extract to old lsn and restart each time

Symptoms

Environment is PostgreSQL on RDS. The extracts were running fine after install.
The OGG-04036 errors started after a cluster fail over on Aurora RDS

Below db connection errors noticed right before the extract abend

"ERROR OGG-25380 Could not send the feedback packet.Error message:server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request"

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


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