pt-query-digest Pipeline process (aggregate fingerprint) caused an error due to "SET @@session.collation_database=DEFAULT/*!*/;" lines on binlog
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
Using the pt-query-digest tool from Percona percona-
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.
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: https:/ /jira.percona. com/browse/ PT-1144