Error: Canceling Statement Due to Conflict With Recovery

Issue

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.

Environment

Connector: PostgreSQL

Resolution

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.

Cause

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.