Edit on GitHub
PostgreSQL Error: fivetran_replication_slot Has Last Tracked LSNlink
Issuelink
The following error appears:
fivetran_prod_replication_slot has last tracked LSN of PostgresLsn{XXX/XXXXXXX} which is ahead of PostgresLsn{XXX/XXXXXXX}?
Environmentlink
Connector: PostgreSQL (using WAL)
Resolutionlink
Trigger a historical re-sync.
Alternatively, you can provide the Fivetran Support team with a restart LSN. From there, the team can reset the connector cursors for you. This will avoid the re-sync, though it may introduce data integrity concerns in your destination.
Causelink
This error means that the last-synced WAL entry no longer exists and Fivetran is unable to resume syncing incremental data from that point in the WAL. This can happen when a source database is migrated.