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

Bug #969669 reported by Swany
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
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-507

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.