pt-query-digest cannot parse binlogs from 5.6

Bug #1335960 reported by Kenny Gryp
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to
Fix Released
Frank Cizmich

Bug Description

The Binlog format in MySQL 5.6 has changed.

It looks something like this now:

#140528 13:25:58 server id 30 end_log_pos 902 CRC32 0x06479cb4 Xid = 27499090796
# at 902

The CRC32 is new.

Attached you can find a simple patch to fix the BinaryLogParser in pt-query-digest. It does not work with 5.5. I just quickly needed --type binlog to work.

Related branches

Revision history for this message
Kenny Gryp (gryp) wrote :
Changed in percona-toolkit:
status: New → In Progress
importance: Undecided → High
assignee: nobody → Frank Cizmich (frank-cizmich)
milestone: none → 2.2.9
Changed in percona-toolkit:
status: In Progress → Fix Committed
Revision history for this message
Frank Cizmich (frank-cizmich) wrote :

Basically fixed as in Kenny's patch, except we made the CRC32 part optional in the regexp, so it's backwards compatible.

Changed in percona-toolkit:
status: Fix Committed → Fix Released
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.