pt-upgrade fails to aggregate queries based on fingerprint

Bug #1421405 reported by Frank Cizmich
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Fix Released
High
Frank Cizmich

Bug Description

Running pt-upgrade against a log with many identical (or similar) queries produces repeated sections with the same fingerprint.

Also, reported number of row diffs is wrong:
"Reporting class because there are 1000 row diffs."

PT 2.2.13

sample command:

perl pt-upgrade --type rawlog host1 host2 /tmp/raw.log

sample output (summarized for brevity)

########################################################################
# Query class E3B134C63BD31D85
########################################################################

Reporting class because there are 1000 row diffs.

Total queries 3
Unique queries 3
Discarded queries 0

select * from test.test;

##
## Row diffs: 3
##

-- 1.

@ row 1
< 8771687,B
> 15269,NULL

.....

########################################################################
# Query class E3B134C63BD31D85
########################################################################

Reporting class because there are 1000 row diffs.

Total queries 4
Unique queries 4
Discarded queries 0

select * from test.test;

##
## Row diffs: 3
##

-- 1.

@ row 1
< 8771687,B
> 15269,NULL

....

########################################################################
# Query class E3B134C63BD31D85
########################################################################

Reporting class because there are 1000 row diffs.

Total queries 5
Unique queries 5
Discarded queries 0

select * from test.test;

##
## Row diffs: 3
##

etc
.....
..

Tags: pt-upgrade

Related branches

description: updated
tags: added: pt-upgrade
Changed in percona-toolkit:
importance: Undecided → High
status: New → In Progress
assignee: nobody → Frank Cizmich (frank-cizmich)
milestone: none → 2.2.14
description: updated
Changed in percona-toolkit:
status: In Progress → Fix Committed
Revision history for this message
Frank Cizmich (frank-cizmich) wrote :

Fixed by skipping already reported classes. Also fixed erroneous number of diffs report.

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: https://jira.percona.com/browse/PT-386

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.