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:
.
.
- 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
.
.