Pt-deadlock stopped working with 'Use of uninitialized value $query_text'

MySQL & MariaDB
1

Suddenly (possibly after upgrade)
my percone-deadlock logger returns

Error getting SHOW ENGINE INNODB STATUS: Use of uninitialized value $query_text in substitution (s///) at /usr/bin/pt-deadlock-logger line 4949.

percona-toolkit/noble,now 3.2.1-1 all [installed]
MariaDB 10.11.11

the line 4949 seams fine:

4949 $query_text =~ s/\s+$//;
4950 $query_text =~ s/\s+/ /g;

2

Hi @poltpolt,
Please search our public bugs tracker for a similar issue. If you don’t find anything, please open a new issue. Include a repeatable test case so our developers can reproduce the issue to fix the bug.

3

Did you upgrade MariaDB or did you upgrade Percona Toolkit? If you upgraded the toolkit, try downgrading to previous version. If it works on older version, please include that in your report.

4

downgrading is not as simple as the whole upgrade to Ubuntu Server 24.04 has been done.

5

Which upgrade did you perform?

6

i did dist-upgrade to upgrade from Ubuntu server 24.04, this upgraded mariadb and percona-toolkit.

Percona toolkit is in version 3.2.1-1 from official ubuntu repo added by percona-relaase utility
and this pt-deadlock-logger --user=ptuser --password=“.perconarandompasswordonlyforlocals.” --host=“localhost”
Error getting SHOW ENGINE INNODB STATUS: Use of uninitialized value $query_text in substitution (s///) at /usr/bin/pt-deadlock-logger line 4949.returns
pt-deadlock-logger --user=ptuser --password=".perconarandompasswordonlyforlocals." --host="localhost"
Error getting SHOW ENGINE INNODB STATUS: Use of uninitialized value $query_text in substitution (s///) at /usr/bin/pt-deadlock-logger line 4949.

so i did apt purge percona-toolkit, downloaded the latest percona-toolkit package from https://www.percona.com/percona-toolkit
so now i have installed percona-toolit-3.7.0-2 that is the latest available there for ubuntu 24.04
and i get
polrus@wi:~$ pt-deadlock-logger --version
pt-deadlock-logger 3.7.0
polrus@wi:~$ pt-deadlock-logger --user=ptuser --password=“.perconarandompasswordonlyforlocals.” --host=“localhost”
Error getting SHOW ENGINE INNODB STATUS: Use of uninitialized value $query_text in substitution (s///) at /usr/bin/pt-deadlock-logger line 5051.

in 5050 the error might be related to the fact that i use MariaDB and
my ( $query_text ) = $body =~ m/\nMySQL thread id .*\n((?s).*)/;
will never be found

so i change it to
my ( $query_text ) = $body =~ m/\nMariaDB thread id .*\n((?s).*)/;

but now i get
Error getting SHOW ENGINE INNODB STATUS: Argument “” isn’t numeric in numeric comparison (<=>) at /usr/bin/pt-deadlock-logger line 5200.

There seams to be some bug with percona-toolkit jira bugtracker - I keep getting error jira error suggesting to notify admin but i don’t have access to that

7

update to mariadb 11.8 solved the problem