pt-upgrade fails to aggregate queries based on fingerprint

Bug #1421405 reported by Frank Cizmich on 2015-02-12
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
.....
..

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
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

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

Other bug subscribers