pt-table-checksum Error checksumming table <table>: I need a vals argument at /usr/bin/pt-table-checksum line 6192
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
New
|
Undecided
|
Frank Cizmich |
Bug Description
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/
Error raised:
05-12T16:43:26 Error checksumming table db1.table1: I need a vals argument at /usr/bin/
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*/
# OobNibbleIterat
# OobNibbleIterat
# OobNibbleIterat
# OobNibbleIterat
# OobNibbleIterat
# OobNibbleIterat
# OobNibbleIterat
# OobNibbleIterat
# OobNibbleIterat
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/
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
.
.
Changed in percona-toolkit: | |
status: | New → Incomplete |
Hello jacot64,
Can you please try again with a more recent version of Percona Toolkit? www.percona. com/downloads/ percona- toolkit/
I've found similar bugs reported in old versions but they have been fixed apparently.
You can download latest here: http://
If you still have trouble try --no-check-plan like you did originally.