pt-duplicate-key-checker --key-types=k doesn't work

Bug #969669 reported by Swany on 2012-03-30
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

Bug Description

[root@poseidon extracted]# pt-duplicate-key-checker --version
pt-duplicate-key-checker 2.0.3

Try to use key checks instead of fk checks:
[root@poseidon extracted]# pt-duplicate-key-checker --key-types=k
Can't use an undefined value as a HASH reference at /usr/bin/pt-duplicate-key-checker line 3658.

From PTDEBUG:
# SchemaIterator:3360 27373 Getting next schema object from dbh DBI::db=HASH(0x18ae3070)
# MySQLDump:696 27373 /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := REPLACE(REPLACE(@@SQL_MODE, 'ANSI_QUOTES', ''), ',,', ','), @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */
# MySQLDump:684 27373 DBI::db=HASH(0x18ae3070) USE `mysql`
# MySQLDump:701 27373 SHOW CREATE TABLE `mysql`.`general_log`
# MySQLDump:711 27373 /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */
# MySQLDump:715 27373 This table is a base table
# TableParser:409 27373 Storage engine: CSV
# TableParser:230 27373 Table cols: `event_time`, `user_host`, `thread_id`, `server_id`, `command_type`, `argument`
# TableParser:409 27373 Storage engine: CSV
# SchemaIterator:3289 27373 Next schema object: mysql general_log
# TableParser:409 27373 Storage engine: CSV
# TableParser:409 27373 Storage engine: CSV
Can't use an undefined value as a HASH reference at /usr/bin/pt-duplicate-key-checker line 3658.

Related branches

tags: added: crash pt-duplicate-key-checker wrong-option
Changed in percona-toolkit:
status: New → Triaged
summary: - pt-duplicate-key-checker does not work with the --key-types=k does not
- work option
+ pt-duplicate-key-checker --key-types=k doesn't work
Changed in percona-toolkit:
milestone: none → 2.1.3
Changed in percona-toolkit:
importance: Undecided → Medium
Changed in percona-toolkit:
assignee: nobody → Daniel Nichter (daniel-nichter)
status: Triaged → In Progress
Changed in percona-toolkit:
status: In Progress → Fix Committed
Changed in percona-toolkit:
status: Fix Committed → Fix Released

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

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

Other bug subscribers