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

LP #1454298: pt-table-checksum Error checksumming table <table>: I need a vals argument at /usr/bin/pt-table-checksum line 6192

Details

    • Bug
    • Status: Done
    • Low
    • Resolution: Cannot Reproduce
    • None
    • None
    • None

    Description

      **Reported in Launchpad by jacot64 last update 02-08-2017 19:13:01

      Hello,

      percona-toolkit package is installed on Debian Wheezy. pt-table-checksum is version 2.1.2.

      mysql version on both master and slave: mysql Ver 14.14 Distrib 5.5.43, for debian-linux-gnu (x86_64) using readline 6.2

      Here is the command line:
      root~# /usr/bin/pt-table-checksum -u<user> -p<pwd> --empty-replicate-table --nocheck-replication-filters --databases=db1,db2

      Error raised:

      05-12T16:43:26 Error checksumming table db1.table1: I need a vals argument at /usr/bin/pt-table-checksum line 6192.

      TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
      05-12T16:43:26 1 0 0 0 0 0.882 db1.table1
      05-12T16:43:27 0 1 8119 4 0 1.134 db2.table1
      05-12T16:43:27 0 0 9272 1 0 0.026 db2.table2
      05-12T16:43:28 0 0 290091 1 0 0.352 db2.table3
      .
      .

      Part of debugged output just before error:
      .
      .

      1. IndexLength:6183 8343 SELECT /!40001 SQL_NO_CACHE */ `localentity`, `peerentity`, `localid`, `deactivationdate` FROM `db1`.`table1` FORCE INDEX (`localentity_2`) WHERE `localentity` IS NOT NULL AND `peerentity` IS NOT NULL AND `localid` IS NOT NULL AND `deactivationdate` IS NOT NULL ORDER BY `localentity`, `peerentity`, `localid`, `deactivationdate` LIMIT 1 /*key_len/
      2. OobNibbleIterator:4462 8343 Finish explain_first_lb_sth
      3. OobNibbleIterator:4462 8343 Finish nibble_sth
      4. OobNibbleIterator:4462 8343 Finish ub_sth
      5. OobNibbleIterator:4462 8343 Finish past_lower_sth
      6. OobNibbleIterator:4462 8343 Finish explain_past_lower_sth
      7. OobNibbleIterator:4462 8343 Finish explain_past_upper_sth
      8. OobNibbleIterator:4462 8343 Finish explain_nibble_sth
      9. OobNibbleIterator:4462 8343 Finish explain_ub_sth
      10. OobNibbleIterator:4462 8343 Finish past_upper_sth

      When I tried with "--no-check-plan", the error become:

      05-12T17:01:27 Error checksumming table db1.table1: Cannot serialize multiple values with undef/NULL at /usr/bin/pt-table-checksum line 1619.

      TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
      05-12T16:43:26 1 0 0 0 0 0.882 db1.table1
      05-12T16:43:27 0 1 8119 4 0 1.134 db2.table1
      05-12T16:43:27 0 0 9272 1 0 0.026 db2.table2
      05-12T16:43:28 0 0 290091 1 0 0.352 db2.table3
      .
      .

      Attachments

        Activity

          People

            lalit.choudhary Lalit Choudhary
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist