Emergency

Announcement

Collapse
No announcement yet.

pt-table-checksum false positives?

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

  • pt-table-checksum false positives?

    We are running the latest version of Percona Toolkit 2.2.7 on MySQL 5.1 with row based replication. Here is an example command that I am using:

    pt-table-checksum -u user-p pass -h master_ip_addr --set-vars innodb_lock_wait_timeout=50 --nocheck-plan --no-check-binlog-format --chunk-size-limit 100.0 --chunk-time 10.0 --nocheck-replication-filters --replicate percona.checksums > /path/to/checksum_output.log 2> /path/to/checksum_errors.log || pt-table-checksum -u user -p pass -h master_ip_addr --set-vars innodb_lock_wait_timeout=50 --replicate-check-only > /path/to/checksum_results_report.log

    The issue I am running into is that in the first command (using --replicate to compute the actual checksums), I see 1's appear in the DIFFS column for various tables. However, when I run --replicate-check-only command after the checksum command, it reports no DIFFS. This seems contradictory. I then checked percona.checksums table in the database for some of the tables in question and the CRC is identical on master and slave. In addition, there are no row mismatches between master and slave. Therefore, I'm left to wonder, why did the checksum output report a 1 in the DIFF column?

    Has anyone else run into this or know of why this would occur?


    Thanks

  • #2
    I have the same problem using MD5. Same version of PT with Percona MySQL 5.6.

    Comment


    • #3
      Please use the latest version of the tool. If you have the problem again, please paste the full command, command output and related data from slave server's percona.checksums table.

      Comment


      • #4
        It's been a while but recently false positives have come back:
        My versions are:
        Server version: 5.6.17-66.0-log Percona Server (GPL), Release 66.0, Revision 608
        and
        percona-toolkit-2.2.12-1.noarch

        my command is the following:
        pt-table-checksum --config /etc/percona_tools/etc/ivy-checksums.conf

        attached two files:
        ivy-checksums.conf
        and my and checksums table.

        Comment


        • #5
          ivy-checksums.conf zipped...

          Comment


          • #6
            https://dl.dropboxusercontent.com/u/8584526/files.zip database + config file

            Comment

            Working...
            X