pt-query-digest crashes if processlist has extra columns

[Usu]

# pt-query-digest --processlist localhost,u=username,p=password --print --no-report
Pipeline process 2 (Processlist) caused an error: Can't use string ("1319806283") as a HASH ref while "strict refs" in use at /usr/bin/pt-query-digest line 2289.
Pipeline process 2 (Processlist) caused an error: Can't use string ("1319806283") as a HASH ref while "strict refs" in use at /usr/bin/pt-query-digest line 2289.
[...]

# pt-query-digest --version
pt-query-digest 1.0.1

# mysqld --version
mysqld Ver 5.5.16-55-log for Linux on x86_64 (Percona Server (GPL), Release 22.0)

OS: Ubuntu 10.04.3 LTS

I hope you can look into this.

Thanks,
Andrea

[Baron Schwartz (baron-xaprb)]

If you can reproduce the problem, would you please run the tool with
MKDEBUG=1 and capture the entry in the processlist (or whatever seems
to be the problem) to help us reproduce it?

[Usu (andreausu)]

Hi,

thanks for the quick reply, I pasted here the output: http://pastebin.com/fwWDip8V
And here is the result of a manual run of 'SHOW FULL PROCESSLIST': http://pastebin.com/LsfF5W1k

The error isn't random at all, it occurs every single time I try to run the script.

Thanks again,
Andrea

[Daniel Nichter (daniel-nichter)]

Related: https://bugs.launchpad.net/percona-toolkit/+bug/821703

[Baron Schwartz (baron-xaprb)]

I am nervous about Pastebin containing the information needed for diagnosis.

[Maciej Dobrzanski (mushu)]

pt-query-digest 2.1.1 is also affected (Gentoo/Perl 5.12.4)

[Brian Fraser (fraserbn)]

This was caused by SHOW FULL PROCESSLIST having more than the basic 8 columns. For now, this has been fixed by ignoring those extras; However, in the future we may support some flavors, like Percona Server's TIME_MS, ROWS_EXAMINED, ROWS_SENT, and ROWS_READ.

[Shahriyar Rzayev (rzayev-sehriyar)]

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