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

Bug #1218216 reported by Lluis Carreras on 2013-08-29
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to

Bug Description

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

Changed in percona-toolkit:
status: New → Confirmed
tags: added: binlog crash

Percona now uses JIRA for bug reports so this bug report is migrated to:

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers