Buy Percona ServicesBuy Now!

pt-table-sync Issues

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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?

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

    Thanks

    Comment

    Working...
    X