Edit on GitHub
Error: Canceling Statement Due to Conflict With Recoverylink
Issuelink
The connector fails with the following error:
ERROR: canceling statement due to conflict with recovery Detail: User query might have needed to see row versions that must be removed.
Environmentlink
All PostgreSQL connectors
Resolutionlink
To resolve this issue, set the hot_standby_feedback
parameter to ON
on the replica we're attempting to query. See PostgreSQL's replication documentation for more information.
Causelink
This issue occurs when we're unable to execute our query on your replica because the query references records that have been deleted from your primary database.
Setting the hot_standby_feedback
parameter allows replicas to report missing rows to the primary or upstream database while allowing queries on the replica to complete.