Tools can't parse index names containing newlines

Bug #1093972 reported by Jervin R
14
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Triaged
Undecided
Unassigned

Bug Description

Support a table definition t:

CREATE TABLE `t` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `c` char(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_with_
newline` (`c`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Running pt-table-checksum produces:

[revin@forge rsandbox_5_5_270]$ pt-table-checksum --replicate=percona.checksums --tables test.t --user=msandbox --password=msandbox h=127.1,P=55270
Use of uninitialized value $cols in pattern match (m//) at /home/revin/bin/pt-table-checksum line 4044.

[revin@forge rsandbox_5_5_270]$ pt-table-checksum --version
pt-table-checksum 2.1.7

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

The customer for whom this issue arose fixed the problem on their side by renaming the index. Index names with newlines are very rare imo, so it's not something we're going to fix soon. Maybe it can be fixed for 3.0.

tags: added: all-tools ident-parsing percona-28456
removed: i28456
summary: - pt-table-checksum Error With a newline on Index Definition
+ Tools can't parse index names containing newlines
Changed in percona-toolkit:
status: New → Triaged
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-1059

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

Duplicates of this bug

Other bug subscribers

Remote bug watches

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