Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1013

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

    XMLWordPrintable

    Details

      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

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: