pt-query-digest skips queries

Bug #1195456 reported by Ryan Lowe
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Confirmed
Undecided
Unassigned

Bug Description

Having run pt-query-digest 2.2 against a slow query log, I get the following (anonymized) output:

# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== =============== ======= ======== ===== =========
# 1 0x9547A60B17EFDFF2 3942.7586 22.1% 2585 1.5252 0.00 SELECT x
# 2 0x3CA33B6583A85AC0 2033.2187 11.4% 1958 1.0384 0.68 SELECT x y
...
# 19 0x12CD1C170E457B81 195.6057 1.1% 1 195.6057 0.00 SELECT z
# 20 0x51363D8AFB1D6F90 186.3636 1.0% 1376 0.1354 0.00 SELECT a
# 22 0xE524E76CF9719105 144.7776 0.8% 27 5.3621 0.03 SELECT x y
# 24 0x9D4430B7270E6646 128.3290 0.7% 46 2.7898 1.65 SELECT x b
...
# 82 0x40A235ECA8139B12 18.0485 0.1% 126 0.1432 1.16 SELECT x y
# MISC 0xMISC 3377.6036 18.9% 5170806 0.0007 0.0 <787 ITEMS>

Notice 19-24 where it skips 21 and 23. They also do not appear later in the report. What gives?

Revision history for this message
Daniel Nichter (daniel-nichter) wrote :

--review?

tags: added: pt-query-digest
Revision history for this message
Ryan Lowe (ryan-a-lowe) wrote :

nope :-(

Revision history for this message
Daniel Nichter (daniel-nichter) wrote :

No idea atm why this would happen, either some bug or some code I have forgotten about.

Ryan: has this ever happened before? I don't recall any similar bug reports.

tags: added: wrong-output
Changed in percona-toolkit:
status: New → Confirmed
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-1129

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.