Error getting SHOW ENGINE INNODB STATUS: Use of uninitialized value $ts in pattern match (m//) at /usr/bin/pt-deadlock-logger line 4879.

[Peter Valdemar Mørch]

When running this command, I see warnings from perl like below:

# pt-deadlock-logger -u$USER -p$PASS -h $HOST
Error getting SHOW ENGINE INNODB STATUS: Use of uninitialized value $ts in pattern match (m//) at /usr/bin/pt-deadlock-logger line 4879.

The reason is that SHOW ENGINE INNODB STATUS has this output:

2016-06-06 14:40:21 0x7f71192a1700 INNODB MONITOR OUTPUT

That doesn't match the regex in line 4436:

my $s = qr/((?:\d{6}|\d{4}-\d\d-\d\d) .\d:\d\d:\d\d)(?: [A-Fa-f0-9]+)?/; # InnoDB timestamp

Changing that (adding the 'x') to :

my $s = qr/((?:\d{6}|\d{4}-\d\d-\d\d) .\d:\d\d:\d\d)(?: [A-Fa-fx0-9]+)?/; # InnoDB timestamp

And I start getting output like:

server ts thread txn_id txn_time user hostname ip db tbl idx lock_type lock_mode wait_hold victim query
capmon-mysql 2016-06-06T14:20:25 204184 0 1 foo bar 1.2.3.4 xxxx yyyy PRIMARY RECORD S w 1 INSERT INTO bla bla bla

That looks better...

# dpkg-query -W | grep percona
percona-toolkit 2.2.16-1
# mysql --version
mysql Ver 14.14 Distrib 5.7.9, for Linux (x86_64) using EditLine wrapper

[Shahriyar Rzayev (rzayev-sehriyar)]

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