pt-query-digest --processlist may crash

[Daniel Nichter]

Imported from http://code.google.com/p/maatkit/issues/detail?id=1289

Quoting original:

./mk-query-digest --processlist h=localhost --print --no-report >> slow.log
Pipeline process 2 (Processlist) caused an error: Use of uninitialized value in anonymous hash ({}) at ./mk-query-digest line 2259.

 2255 else {
 2256 MKDEBUG && _d('New cxn', $curr->[ID]);
 2257 if ( $curr->[INFO] && defined $curr->[TIME] ) {
 2258 MKDEBUG && _d('Saving query of new cxn, state', $curr->[STATE]);
 2259 push @new_cxn, [
 2260 @$curr, # proc info
 2261 int($query_start), # START
 2262 $etime, # ETIME
 2263 $time, # FSEEN
 2264 { $curr->[STATE] => 0 }, # PROFILE
 2265 ];
 2266 }
 2267 }
 2268 } # CURRENTLY_ACTIVE_CXN

[Steve Caldwell (scaldwell)]

Via process of elimination, I believe this bug was introduced in release 7332. I had to use an earlier version in order to get mk-query-digest working.

[Daniel Nichter (daniel-nichter)]

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

[Adam (akenney-k)]

I wanted to add an upvote for this one. I'm seeing the same error when I try to use pt-query-digest (from Percona Toolkit 2.0) on a debian lenny machine. Thanks!

[Shahriyar Rzayev (rzayev-sehriyar)]

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