Issues

Select view

Select search mode

 

LP #1187410: pt-align omits lines if not all columns are present

Description

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

Environment

None

Smart Checklist

Details

Assignee

Reporter

Priority

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 AM
Percona 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 PM
Percona 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 PM
Open
On Hold
Eduardo Casarero
updated the workflowOctober 2, 2019 at 6:45 PM
Percona 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 PM
Percona Open Source Software Default Workflow V1.5
Percona Open Source Software Default Workflow V1.6
Eduardo Casarero
made 2 changes
June 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 changes
January 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

Flag notifications