Can't use an undefined value as an ARRAY reference at pt-table-checksum line 2206

Bug #995274 reported by Paul Graydon
10
This bug affects 2 people
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/pt-table-checksum -q
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/pt-table-checksum line 2206.

mysql> show create table GroupMembers\G
*************************** 1. row ***************************
       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`,`MemberId`),
  UNIQUE KEY `SHREDDER_GM1` (`MemberId`,`GroupId`)
) ENGINE=InnoDB AUTO_INCREMENT=944016 DEFAULT CHARSET=utf8
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

Revision history for this message
Paul Graydon (twirrim) wrote :
Revision history for this message
Paul Graydon (twirrim) wrote :

Attached is a PTDEBUG output of just that table:

PTDEBUG=1 /usr/bin/pt-table-checksum -q --databases rt3 --tables GroupMembers > debug 2>&

Revision history for this message
Daniel Nichter (daniel-nichter) wrote :

This is probably the same as bug 987393, but I'll keep this one open until I know that for sure.

tags: added: crash pt-table-checksum
Changed in percona-toolkit:
status: New → Triaged
milestone: none → 2.1.2
importance: Undecided → Medium
Changed in percona-toolkit:
status: Triaged → In Progress
Revision history for this message
Daniel Nichter (daniel-nichter) wrote :

This bug is not related to bug 987393; this bug is about case-sensitivity. The tool (TableParser::parse()) lower-cases index names when it parses the table def but not when it gets an index name back from MySQL EXPLAIN.

tags: added: case-sensitivity
Revision history for this message
Daniel Nichter (daniel-nichter) wrote :

I need to finish and merge bug 978432 first because it modifies the same code (NibbleIterator).

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
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.