# pt-table-sync Issues

**URL:** <https://forums.percona.com/t/pt-table-sync-issues/7224>\
**Category:** Percona Toolkit\
**Created:** [September 30, 2019, 11:47am UTC](https://forums.percona.com/t/pt-table-sync-issues/7224 "2019-09-30T11:47:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![skinfrakiirid](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@skinfrakiirid](https://forums.percona.com/u/skinfrakiirid)\
**Post date:** [September 30, 2019, 11:47am UTC](https://forums.percona.com/t/pt-table-sync-issues/7224/1 "2019-09-30T11:47:21Z")

</div>

I am trying to run pt-table-sync on a database and table. I know data is out of sync by both a select statement and by pt-table-checksum. Here is what is happening:

pt-table-checksum --replicate=percona.checksums --ignore-databases mysql,information\_schema,performance\_schema,sys --no-check-binlog-format --host=master --user=user --password=password Checking if all tables can be checksummed … Starting checksum … TS ERRORS DIFFS ROWS DIFF\_ROWS CHUNKS SKIPPED TIME TABLE 09-30T09:14:43 0 0 15 0 1 0 3.982 datbase.table So when I run pt-table-sync in either dry run or execute the following happens:  
pt-table-sync --sync-to-master --dry-run h=slave,u=user,p=password, --databases=database, --tables=table # NOTE: --dry-run does not show if data needs to be synced because it # does not access, compare or sync data. --dry-run only shows # the work that would be done. # Syncing h=slave,p=…,u=user in dry-run mode, without accessing or comparing data # DELETE REPLACE INSERT UPDATE ALGORITHM START END EXIT DATABASE.TABLE # 0 0 0 0 Chunk 12:09:55 12:09:56 0 database.taable Just to double check, I run checksum again:  
pt-table-checksum --replicate=percona.checksums --ignore-databases mysql,information\_schema,performance\_schema,sys --no-check-binlog-format --host=master --user=user --password=password Checking if all tables can be checksummed … Starting checksum … TS ERRORS DIFFS ROWS DIFF\_ROWS CHUNKS SKIPPED TIME TABLE 09-30T09:14:43 0 0 15 0 1 0 3.982 database.tables Still seeing sync issues. How do I address this?

---

<div class="post-metadata">

**Author:** ![carlos.salguero](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/carlos.salguero/32/20_2.png) [@carlos.salguero](https://forums.percona.com/u/carlos.salguero)\
**Post date:** [October 1, 2019, 2:26pm UTC](https://forums.percona.com/t/pt-table-sync-issues/7224/2 "2019-10-01T14:26:16Z")

</div>

Hello  
Could you run it again adding PTDEBUG=1 in front of the command to get the debug output?

Thanks