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?