PostgreSQL Error: Current Transaction ID Has Moved Backwards

Question

The following error message appears:

Current transaction ID has moved backwards.

Environment

Connector: PostgreSQL

Answer

A historical re-sync is required.

Cause

When the transaction ID has moved backward, this usually means that we have been connected to a different database instance. This could be from master to replica, from one replica to another, or if a database has moved to a new server.

We will be indefinitely waiting for the transaction ID to catch up. As a result, a re-sync is required.