PostgreSQL Error: fivetran_replication_slot Has Last Tracked LSN

Issue

The following error appears:

fivetran_prod_replication_slot has last tracked LSN of PostgresLsn{XXX/XXXXXXX} which is ahead of PostgresLsn{XXX/XXXXXXX}?

Environment

Connector: PostgreSQL (using WAL)

Resolution

Trigger a .

Alternatively, you can provide the Fivetran Support team with a restart LSN. From there, the team can reset the connector for you. This will avoid the re-sync, though it may introduce data integrity concerns in your destination.

Cause

This error means that the last-synced WAL log 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.