Error syncing user_data table from Postgres to Bigquery

[slack-user-airbyte]

Summary

Error occurred while syncing user_data table from Postgres to Bigquery, with a specific error message related to column ‘xmin’ not existing.

Question

Postgres -> Bigquery

All tables are synced but one (user_data) which stayed in the status “Incomplete” eventhough all rows have been transferred to bigquery.

Message:
io.airbyte.cdk.integrations.source.relationaldb.state.FailedRecordIteratorException: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: column "xmin" does not exist Position: 555

---

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

_{["postgres", "bigquery", "sync", "user-data", "error", "column-xmin"]}

[slack-user-airbyte]

How does your configuration for airbyte user looks like? Are you able to query the xmin from these table when using airbyte user?

select xmin from user_data