Edit on GitHub
The Connector Is Not Releasing the WALlink
Issuelink
The connector is not releasing the WAL.
Environmentlink
Connector: PostgreSQL
Resolutionlink
Option 1: Drop and recreate the replication slotlink
- Pause the connector.
- Delete the replication slot in the source.
- Allow the database to the checkpoint.
- Create a new replication slot.
- Click the Setup tab.
- Click the Edit connection details link.
- Click Re-sync All Historical Data on the setup page.
- Unpause the connector.
Option 2: Allow the sync to continuelink
- Check to see how much disk space is available.
- Add more space if needed.
- Allow the existing sync to continue to run.
Causelink
The incremental sync is taking longer to read and update changes in the destination. This can cause the WAL to build up and consume a lot of disk space.
This could be because of one of the following reasons:
- There are a lot of tables selected in the connector to sync.
- There is a high rate of change in the database.
- The WAL slot is not advancing.