pt-table-sync Issues

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?

Comments

  • carlos.salguerocarlos.salguero Percona Toolkit Developer Percona
    Hello
    Could you run it again adding PTDEBUG=1 in front of the command to get the debug output?

    Thanks
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.