Flaky sync with Postgres destination in Airbyte Cloud setup

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

The user is experiencing flaky sync with a Postgres destination in Airbyte Cloud setup, with many failed attempts due to a circular reference error. They are unsure if this behavior is expected or if there is an issue with their setup.


Question

Hey all, Airbyte newbie here! I’ve setup a connector in Cloud with Postgres as the destination. However, running the sync results in a lot of attempts in the logs, with almost all of them failing with errors something like [CIRCULAR REFERENCE: org.postgresql.util.PSQLException: ERROR: prepared statement "S_1" already exists]

Sometimes the sync seems to eventually finish successfully, sometimes I give up and cancel the sync after some dozen attempts.

Mostly wondering, is this (flaky sync, just takes a bunch of attempts) something that’s expected, or is it possible that something in my setup is incorrect?


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["flaky-sync", "postgres-destination", "airbyte-cloud", "circular-reference-error"]
2

For context, I’m prototyping an integration-heavy new product, and eventually looking to offload all the data syncs (on behalf of the users of my product) to “powered by airbyte”. Besides the flaky sync, everything seems to work perfectly