Why is my connector using the XMIN update method not syncing data?
If you are using XMIN as your incremental sync method, and the source database has a transaction that is taking a long time to commit, this will cause the connector to “stall” and wait for the transaction to complete before syncing the updates.
You can use the following queries to troubleshoot the source database and look for ongoing transactions:
SELECT * FROM pg_replication_slots; SELECT * FROM pg_stat_activity; SELECT * FROM pg_prepared_xacts; SELECT * FROM pg_prepared_statements;
This can help identify the oldest running transactions in your environment. Once these transactions complete or are terminated, the XMIN horizon can advance, which allows incremental syncs to continue.