Issues
3 of 3
LP #1187410: pt-align omits lines if not all columns are present
General
Escalation
General
Escalation
Description
Environment
None
Smart Checklist
Details
Assignee
UnassignedUnassignedReporter
lpjirasynclpjirasync(Deactivated)Priority
LowLabels
Details
Details
Assignee
Unassigned
UnassignedReporter
lpjirasync
lpjirasync(Deactivated)Priority
Labels
Smart Checklist
Smart Checklist
Smart Checklist
Created January 24, 2018 at 7:34 PM
Updated December 21, 2019 at 2:32 PM
Activity
Kai Wagner
updated the workflowApril 27, 2023 at 6:00 AMPercona Open Source Software Default Workflow V1.8
Percona Open Source Software Default Workflow V1.7
Roma Novikov
updated the workflowMay 17, 2021 at 6:44 PMPercona Open Source Software Default Workflow V1.7
Percona Open Source Software Default Workflow V1.8
Peter Schwaller
changed the statusDecember 21, 2019 at 2:32 PMOpen
On Hold
Eduardo Casarero
updated the workflowOctober 2, 2019 at 6:45 PMPercona Open Source Software Default Workflow V1.6
Percona Open Source Software Default Workflow V1.7
Eduardo Casarero
updated the workflowDecember 31, 2018 at 3:13 PMPercona Open Source Software Default Workflow V1.5
Percona Open Source Software Default Workflow V1.6
Eduardo Casarero
made 2 changesJune 25, 2018 at 7:46 PM
Status
In Triage
Open
Workflow
Percona Open Source Software Default Workflow V1.3
Percona Open Source Software Default Workflow V1.5
lpjirasync
made 5 changesJanuary 24, 2018 at 7:34 PM
Status
New
In Triage
Priority
Medium
Low
Launchpad URL
None
https://bugs.launchpad.net/percona-toolkit/+bug/1187410
lpjirasync
created the IssueJanuary 24, 2018 at 7:34 PM
**Reported in Launchpad by Fernando Ipar last update 20-06-2013 17:12:08
If not all input lines have the same # of columns, pt-align omits some. This makes the tool unusable with output from other tools like pt-table-checksum:
localhost ~ $ pt-table-checksum --no-check-binlog-format --ignore-databases percona --replicate-check-only --resume --quiet h=localhost| pt-align
TABLE CHUNK CNT_DIFF CRC_DIFF CHUNK_INDEX LOWER_BOUNDARY UPPER_BOUNDARY
schema1.entities 1 0 1 PRIMARY 2 115990
schema1.entities_wishlist 4 -1 1 idx_entities_id 165532 233284
schema1.entities_status_history 81 0 1 PRIMARY 7812042 7829225
localhost ~ $ pt-table-checksum --no-check-binlog-format --ignore-databases percona --replicate-check-only --resume --quiet h=localhost
Differences on data2.bookdownloader.com
TABLE CHUNK CNT_DIFF CRC_DIFF CHUNK_INDEX LOWER_BOUNDARY UPPER_BOUNDARY
cacti.host 1 0 1
cacti.poller_time 1 0 1
cacti.settings 1 0 1
schema1.entities 1 0 1 PRIMARY 2 115990
schema1.entities_wishlist 4 -1 1 idx_entities_id 165532 233284
schema1.entities_status_history 81 0 1 PRIMARY 7812042 7829225
I think this should be fixed so that either:
for all input lines, there is an output line, or
a warning is printed that some lines were omitted