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

LP #1218216: pt-query-digest Pipeline process (aggregate fingerprint) caused an error due to "SET @@session.collation_database=DEFAULT/*!*/;" lines on binlog

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by Lluis Carreras last update 30-10-2013 17:37:34

      Using the pt-query-digest tool from Percona percona-toolkit-2.2.4 on Debian Linux 2.6.26-2-686
      with a binlog (binlog v 4) of 1 million lines from a MySQL server 5.1.54 it showed several errors like the following one

      Pipeline process 11 (aggregate fingerprint) caused an error: Argument "default" isn't numeric in numeric gt (>) at (eval 38) line 6, <> line 6.

      After showing 100 of this errors the pt-query-digest stopped, also with the option --continue-on-error

      After debugging I found out that the errors were due to the following line that there was in the binlog
      SET @@session.collation_database=DEFAULT/!/;

      I'm attaching a short version of the binlog that causes just one error where I finally found that line in the binlog that caused the pt-query-digest error

        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: