pt-table-checksum: Empy tables cause "undefined value as an ARRAY" errors
Bug #987393 reported by
Ben Hencke
This bug affects 1 person
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
Using pt-table-checksum 2.1.1
If a database contains some empty tables, they cause the following error:
04-23T09:27:01 Error checksumming table db.emptytable: Can't use an undefined value as an ARRAY reference at /usr/bin/
Related branches
lp:~percona-toolkit-dev/percona-toolkit/fix-empty-table-bug-987393
- Daniel Nichter: Approve
- Diff: 0 lines
lp:~percona-toolkit-dev/percona-toolkit/empty-table-bug-987393-2.0
- Daniel Nichter: Approve
-
Diff: 195 lines (+108/-6)5 files modifiedbin/pt-table-checksum (+27/-3)
lib/NibbleIterator.pm (+2/-1)
t/lib/OobNibbleIterator.t (+24/-1)
t/pt-table-checksum/bugs.t (+37/-1)
t/pt-table-checksum/samples/empty-table-bug-987393.sql (+18/-0)
I cannot reproduce this problem with 2.1.1 using 1 empty table, 3 empty tables, a mix of tables with data and empty tables.
Ben, can you tell me more about how you're able to reproduce this? I.e. SHOW CREATE TABLE for your empty table, if there are any other tables in the db, the command line to run the tool, etc.