Syncs are delayed or failed due to the delay in internal database

Incident Report for Fivetran

Resolved

Description:
Many connection syncs are delayed or failed due to the delay in internal database and throws the below exception
"(FATAL: query_wait_timeout)|(reason: Rescheduling to recover more quickly)"

Timeline:
This issue began at 2025-04-03T10:17:00.00Z UTC and was resolved on 2025-04-03T10:32:00.00Z UTC.

Cause:
A heavyweight DDL query locked the Redshift table for approximately 13 minutes, causing all other queries involving that Redshift table to become stuck and leaving their database connections in the Server Side Pooler. Since the Server Side Pooler ran out of available connections, all other queries also became stuck.

Resolution:
A fix has been applied and this has been resolved now.
Posted Apr 03, 2025 - 05:00 UTC