pt-kill matches does not support modifiers

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

Bug Description

This is pt-kill 2.2.14, likely apply to other tools as well - a feature request to support regex modifiers, at least case insensivite matching.

Unfortunately, after looking at the code, the match-info command does not support passing modifiers which seems to be a limitation of the tool.

   3572 sub _find_match_Info {
   3573 my ( $self, $query, $property ) = @_;
   3574 return defined $property && defined $query->{Info}
   3575 && $query->{Info} =~ m/$property/;
   3576 }

A potential workaround is to specify the permutations of the "SELECT" word in small and uppercase variants in the regex like below. Can you please test and let us know.

--match-info='^[Ss][Ee][Ll][Ee][Cc][Tt]'

Tags: i58590
Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote :

Indeed, the way $property is used modifiers (http://perldoc.perl.org/perlre.html#Modifiers) will not work as expected.

Changed in percona-toolkit:
status: New → Confirmed
tags: added: i58590
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-1292

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.