Can't use an undefined value as an ARRAY reference at pt-table-checksum line 2206
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
Medium
|
Daniel Nichter | ||
2.0 |
Fix Released
|
Medium
|
Daniel Nichter | ||
2.1 |
Fix Released
|
Medium
|
Daniel Nichter |
Bug Description
Command line : /usr/bin/
Tool Version: pt-table-checksum 2.1.1
MySQL Version of all servers involved: MySQL 5.1.59
I've hit this odd quirk with pt-table-checksum. It seems to be failing to checksum a particular table for some reason:
05-05T16:31:07 Cannot checksum table rt3.GroupMembers: Can't use an undefined value as an ARRAY reference at /usr/bin/
mysql> show create table GroupMembers\G
*******
Table: GroupMembers
Create Table: CREATE TABLE `GroupMembers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`GroupId` int(11) NOT NULL DEFAULT '0',
`MemberId` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `GroupMembers1` (`GroupId`
UNIQUE KEY `SHREDDER_GM1` (`MemberId`
) ENGINE=InnoDB AUTO_INCREMENT=
1 row in set (0.00 sec)
There doesn't appear to be anything sensitive about the data, so I've attached it to this ticket, if that's of any use.
Related branches
- Daniel Nichter: Approve
-
Diff: 204 lines (+144/-4)5 files modifiedbin/pt-table-checksum (+5/-1)
lib/NibbleIterator.pm (+9/-1)
t/lib/NibbleIterator.t (+28/-2)
t/pt-table-checksum/bugs.t (+84/-0)
t/pt-table-checksum/samples/undef-arrayref-bug-995274.sql (+18/-0)
- Daniel Nichter: Approve
-
Diff: 204 lines (+144/-4)5 files modifiedbin/pt-table-checksum (+5/-1)
lib/NibbleIterator.pm (+9/-1)
t/lib/NibbleIterator.t (+28/-2)
t/pt-table-checksum/bugs.t (+84/-0)
t/pt-table-checksum/samples/undef-arrayref-bug-995274.sql (+18/-0)
Changed in percona-toolkit: | |
status: | Triaged → In Progress |
Changed in percona-toolkit: | |
assignee: | nobody → Daniel Nichter (daniel-nichter) |
summary: |
- Can't use an undefined value as an ARRAY reference at /usr/bin/pt-table- - checksum line 2206 + Can't use an undefined value as an ARRAY reference at pt-table-checksum + line 2206 |
Attached is a PTDEBUG output of just that table:
PTDEBUG=1 /usr/bin/ pt-table- checksum -q --databases rt3 --tables GroupMembers > debug 2>&