LP #1036372: pt-query-digest throws numerous "Pipeline process 5 (iteration) caused an error" messages

Description

**Reported in Launchpad by Peter Bense last update 13-10-2012 16:54:32

This happens with

pt-query-digest 2.0.2

When running the command:

sudo pt-query-digest mysql_tmpfile.tmp --since 7d --limit 10 --order-by Query_time:cnt --review D=DBA_TOOL,t=QUERY_REVIEW --table-access --user root

... I get hundreds of messages printed to the console stating:

Pipeline process 5 (iteration) caused an error: Use of uninitialized value $_ in concatenation (.) or string at /usr/local/bin/pt-query-digest line 13478.

My shell script which drives this process first copies, uncompresses and concatenates lot of log files

These files:

rw-r---- 1 root root 54M 2012-08-13 18:33 mysqlslow.log.7
rw-r---- 1 root root 14M 2012-08-13 18:33 mysqlslow.log.1
rw-r---- 1 root root 21M 2012-08-13 18:33 mysqlslow.log.2
rw-r---- 1 root root 41M 2012-08-13 18:33 mysqlslow.log.3
rw-r---- 1 root root 47M 2012-08-13 18:33 mysqlslow.log.4
rw-r---- 1 root root 33M 2012-08-13 18:33 mysqlslow.log.5
rw-r---- 1 root root 33M 2012-08-13 18:33 mysqlslow.log.6
rw-r---- 1 root root 20M 2012-08-13 18:33 mysqlslow.log

Get concatenated to:

rw-rw-rw 1 root root 261M 2012-08-13 18:33 mysql_tmpfile.tmp

Environment

None

Smart Checklist

Activity

Show:

lpjirasync January 24, 2018 at 6:52 PM

**Comment from Launchpad by: Daniel Nichter on: 13-10-2012 16:54:18

Peter, if the problem persists with the latest version of pt-query-digest, please reply and we'll re-open this bug. Thanks.

lpjirasync January 24, 2018 at 6:52 PM

**Comment from Launchpad by: Daniel Nichter on: 16-08-2012 15:54:30

Peter, can you try the latest version: http://www.percona.com/downloads/percona-toolkit/2.1.3/ This may be fixed already.

Not a Bug

Details

Assignee

Reporter

Priority

Smart Checklist

Created January 24, 2018 at 6:52 PM
Updated February 3, 2018 at 10:13 PM
Resolved January 24, 2018 at 6:52 PM