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

[jacot64]

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:
.
.
# 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*/
# OobNibbleIterator:4462 8343 Finish explain_first_lb_sth
# OobNibbleIterator:4462 8343 Finish nibble_sth
# OobNibbleIterator:4462 8343 Finish ub_sth
# OobNibbleIterator:4462 8343 Finish past_lower_sth
# OobNibbleIterator:4462 8343 Finish explain_past_lower_sth
# OobNibbleIterator:4462 8343 Finish explain_past_upper_sth
# OobNibbleIterator:4462 8343 Finish explain_nibble_sth
# OobNibbleIterator:4462 8343 Finish explain_ub_sth
# 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
.
.

[Frank Cizmich (frank-cizmich)]

Hello jacot64,

Can you please try again with a more recent version of Percona Toolkit?
I've found similar bugs reported in old versions but they have been fixed apparently.
You can download latest here: http://www.percona.com/downloads/percona-toolkit/
If you still have trouble try --no-check-plan like you did originally.

[monty solomon (monty+launchpad)]

This error still happens when running pt-table-checksum version 3.0.3

Error checksumming table db_33.table: I need a vals argument at pt-table-checksum line 8838.

Error checksumming table db_36.table: I need a vals argument at pt-table-checksum line 8838.

[monty solomon (monty+launchpad)]

It happened for some more tables

08-01T08:00:07 Error checksumming table db_31.table: I need a vals argument at pt-table-checksum line 8838.

08-01T09:36:54 Error checksumming table db_32.table: I need a vals argument at pt-table-checksum line 8838.

08-01T11:01:26 Error checksumming table db_33.table: I need a vals argument at pt-table-checksum line 8838.

08-01T15:40:04 Error checksumming table db_36.table: I need a vals argument at pt-table-checksum line 8838.

08-01T17:18:46 Error checksumming table db_37.table: I need a vals argument at pt-table-checksum line 8838.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1282