Inconsistent data using CDC incremental sync configuration with postgresql

[redaq]

Hi We have airbyte open source version 0.50.7 deployed on Kubernetes. Our sources are Azure Managed PostgreSQL databases and destination is also a postgresql database. We configured CDC incremental sync and it does sync as configured. However, we observed that the data in the destination is not the same as the source data after incremental syncs. Right now the data syncs every hour. I'm wondering if there are suggestions on where we should check to see why the incremental sync is not working as expected? I'm attaching two log files here.

Thanks!