How can I reset a connection airbyte in version `0...
# ask-ai
c
How can I reset a connection airbyte in version
0.61.0
I can find any button anywhere to reset the connection. I need to reset the connection because of this error:
Copy code
Failure in source: Saved offset is before replication slot's confirmed lsn. Please reset the connection, and then increase WAL retention and/or increase sync frequency to prevent this from happening in the future. See <https://docs.airbyte.com/integrations/sources/postgres/postgres-troubleshooting#under-cdc-incremental-mode-there-are-still-full-refresh-syncs> for more details.
u
Based on the information provided in the knowledge sources, I don't have specific instructions for resetting a connection in Airbyte version 0.61.0. However, I can provide some insights and suggestions based on the error message you're encountering: 1. The error you're seeing is a known issue with Postgres CDC (Change Data Capture) incremental syncs in Airbyte. It occurs when the Write-Ahead Logs (WAL) needed for the incremental sync have been removed by Postgres [Source](https://docs.airbyte.com/integrations/sources/postgres/postgres-troubleshooting#under-cdc-incremental-mode-there-are-still-full-refresh-syncs). 2. While the error message suggests resetting the connection, one user reported solving this issue by deleting and recreating the connection entirely [Source](https://github.com/airbytehq/airbyte/issues/46571). 3. To prevent this issue from happening in the future, you can try the following: - Sync your data source more frequently. - Increase the
wal_keep_size
in your Postgres configuration. This will require more disk space but can help retain more WAL files [Source](https://docs.airbyte.com/integrations/sources/postgres/postgres-troubleshooting#under-cdc-incremental-mode-there-are-still-full-refresh-syncs). 4. If you're unable to find a reset button in your current Airbyte version, you might need to delete and recreate the connection as mentioned earlier. 5. It's also worth checking if there's an updated version of Airbyte available, as newer versions might have additional features or fixes for this issue. If these suggestions don't resolve your issue, you may want to consult Airbyte's official documentation or reach out to their support for version-specific instructions on resetting connections.