Announcement

Announcement Module
Collapse
No announcement yet.

pt-table-checksum doesn't list which slave the diffs were found on

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-table-checksum doesn't list which slave the diffs were found on

    We often have 2 or more slaves that are checked by pt-table-checksum, but the report that is generated doesn't tell us which slave the "diff" is found on. For example:


    TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
    12-06T10:47:05 0 1 5 1 0 0.326 pt_test.pt_test
    12-06T10:47:06 0 1 1 1 0 0.376 sbtest.mytable
    12-06T10:47:07 0 1 2 1 0 0.405 smithstest.table1

    In the output above the first to diffs were found on the first slave, and the last one was found on the second slave. This would be a real problem if someone had dozens of slaves. Seems like there should be an additional column that listed the slave that the diff was found on?

  • #2
    Hi,

    Try to run pt-table-checksum with --replicate-check-only option. Check this link. http://www.percona.com/doc/percona-t...-checksum.html

    If --replicate-check-only is specified, only checksum differences on detected replicas are printed. The output is different: one paragraph per replica, one checksum difference per line, and values are separated by spaces:

    Code:
    Differences on h=127.0.0.1,P=12346
    TABLE CHUNK CNT_DIFF CRC_DIFF CHUNK_INDEX LOWER_BOUNDARY UPPER_BOUNDARY
    db1.tbl1 1 0 1 PRIMARY 1 100 db1.tbl1 6 0 1 PRIMARY 501 600
    
    Differences on h=127.0.0.1,P=12347
    TABLE CHUNK CNT_DIFF CRC_DIFF CHUNK_INDEX LOWER_BOUNDARY UPPER_BOUNDARY
    db1.tbl1 1 0 1 PRIMARY 1 100 db2.tbl2 9 5 0 PRIMARY 101 200
    Last edited by niljoshi; 12-10-2013, 11:41 PM.

    Comment

    Working...
    X