failed to sync v3 source aws_xxxxxxxxxxxx: write client returned error (insert): plugin returned error: failed to execute batch with pgerror: severity: ERROR, code: 40P01, message: deadlock detected, detail :Process 27979 waits for ShareLock on transaction 107350228; blocked by process 27985.
Process 27985 waits for AccessExclusiveLock on tuple (418,3) of relation 281674810 of database 16400; blocked by process 27997.
Process 27997 waits for ShareLock on transaction 107350194; blocked by process 27979., hint: See server log for query details., position: 0, internal_position: 0, internal_query: , where: while inserting index tuple (73,6) in relation “aws_route53resolver_resolver_rules”, schema_name: , table_name: , column_name: , data_type_name: , constraint_name: , file: deadlock.c, line: 1149, routine: DeadLockReport: ERROR: deadlock detected (SQLSTATE 40P01)
Hi @Prabhanjali welcome to the community 
Can you share your configuration YAML spec and CLI version? The latter you can find by running cloudquery --version
Hi @erez
AWS version - 23.1.0
CLI version - v5.20.5
Postgres version - v7.1.2
Hi @erez
I’m getting this issue with this table only, all other tables are working fine. should I need to do something? It’s important for us to stay in these versions itself. Can you give me any fix without altering the versions?
Ho @Prabhanjali which Postgres Database version are you using? I recommend updating to the latest one as it might contain bug fixes related to this issue.
Also, the versions you’re using are quite outdated, I recommend updating at least the CLI and Postgres plugin to latest versions
Hey @erez all other tables are compatible and only this is incompatible and we are running into issues. can you let us know what are the best things that we can do other than updating the versions??
we aren’t happy to update the versions and break anything in production now