Error getting SHOW ENGINE INNODB STATUS: Use of uninitialized value $ts in pattern match (m//) at /usr/bin/pt-deadlock-logger line 4879.
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
New
|
Undecided
|
Unassigned |
Bug Description
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/
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/((?:
Changing that (adding the 'x') to :
my $s = qr/((?:
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
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PT-1352