Quick Question: I’m using overwrite-delete-stale with aws->postgres. I’m noticing an EC2 instance in the database with the state as running. This instance no longer exists. I don’t see any errors in the logs regarding the table sync.
Anyone have any idea as to what could be the issue?
How long does your sync take? Could the instance have been terminated after the beginning of the sync?
so in the logs I see the sync completed for that table and account*
Are you able to compare the time at which the EC2 instance was terminated and when the CQ sync began, as well as when the aws_ec2_instances table completed? (Make sure you are looking at the correct region and account.)
Responding in case someone else encounters this, it was because the jobs kept failing due to the pk of aws_route53resolver_resolver_rules being non-unique. So stale data was never cleaned up.