pt-fingerprint does not parse binary data correctly

Bug #1606153 reported by Karthik Appigatla
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
New
Undecided
Unassigned

Bug Description

[root@kappigatla kappigatla]# pt-fingerprint --version
pt-fingerprint 2.2.17

[root@kappigatla kappigatla]# pt-fingerprint --query="INSERT IGNORE test (guid, time, server, service, tier, topic, count, begin_timestamp, end_timestamp, update_time, size_in_bytes) VALUES (_binary'1y?^_VU<84>??X<81>??.?\\', 1469433660359, 'localhost', 'frontpage', 'test', 'ActionEvent', 131, 1469433000000, 1469433600000, 1469433666056, 0)"
insert ignore test (guid, time, server, service, tier, topic, count, begin_timestamp, end_timestamp, update_time, size_in_bytes) values (_binary?localhost?frontpage?test?actionevent', ?, ?, ?, ?, ?)

Ideally the output should be
insert ignore test (guid, time, server, service, tier, topic, count, begin_timestamp, end_timestamp, update_time, size_in_bytes) values (_binary?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

We are getting the correct output with other binary data
Example:
[root@kappigatla kappigatla]# pt-fingerprint --query="INSERT IGNORE test (guid, time, server, service, tier, topic, count, begin_timestamp, end_timestamp, update_time, size_in_bytes) VALUES (_binary'1G?9??\Z? F?<81><9B>???', 1469433660359, 'localhost', 'frontpage', 'test', 'ActionEvent', 131, 1469433000000, 1469433600000, 1469433666056, 0)"
insert ignore test (guid, time, server, service, tier, topic, count, begin_timestamp, end_timestamp, update_time, size_in_bytes) values (_binary?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

This also affects the pt-query-digest report.

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1374

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.