pt-query-digest inconsistent rank order
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Triaged
|
Low
|
Frank Cizmich |
Bug Description
This is a minor issue that only affects testing.
pt-query-digest (specifically the EventAggregator module) orders the top "worst" queries according to one or more pre-definable attribute values.
But when two values are equal, the sort algorithm sometimes inverts their order in different OSs.
This is innocuous to an end user, but causes false positives in the testing suite.
Sample output showing differences from testing run:
# < # 5 0xED69B13F3D0161D0 20661.0000 16.7% 1 20661.0000 0.00 UPDATE test?.tbl?
# < # 6 0x79BFEA84D0CED05F 20661.0000 16.7% 1 20661.0000 0.00 INSERT UPDATE test?.tbl?
# ---
# > # 5 0x79BFEA84D0CED05F 20661.0000 16.7% 1 20661.0000 0.00 INSERT UPDATE test?.tbl?
# > # 6 0xED69B13F3D0161D0 20661.0000 16.7% 1 20661.0000 0.00 UPDATE test?.tbl?
Simplest solution should be to tie-break using the query fingerprint.
Changed in percona-toolkit: | |
status: | New → Triaged |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PT-813