Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1054

LP #1087730: wrong detection off binlog_format STATEMENT

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by MF last update 07-12-2012 17:52:27

      after upgrade to 2.1.6, pt-table-checksum return error of binlog_format, but by conf and variables there isn't inconsistency.

      /usr/bin/pt-table-checksum ...
      db11 has binlog_format STATEMENT but replica db12 has binlog_format ROW. This could cause pt-table-checksum to break replication. If you understand the risks, specify --no-check-binlog-format to disable this check.

      mysqladmin variables |grep binlog_format
      rpm -qa |grep -i mysql |sort

      master db11

      binlog_format ROW

      MySQL-client-5.5.28-1.rhel5
      MySQL-devel-5.5.28-1.rhel5
      MySQL-server-5.5.28-1.rhel5
      MySQL-shared-5.5.28-1.rhel5
      MySQL-shared-compat-5.5.28-1.rhel5
      perl-DBD-MySQL-3.0007-2.el5

      slave db12

      binlog_format ROW

      MySQL-client-5.5.27-1.rhel5
      MySQL-devel-5.5.27-1.rhel5
      MySQL-server-5.5.27-1.rhel5
      MySQL-shared-5.5.27-1.rhel5
      MySQL-shared-compat-5.5.27-1.rhel5
      perl-DBD-MySQL-4.014-1.el5.rfx

      same for other slave with 5.5.28.

      /usr/bin/pt-table-checksum --version
      pt-table-checksum 2.1.7

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist