pt-align omits lines if not all columns are present

Bug #1187410 reported by Fernando Ipar
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Triaged
Undecided
Unassigned

Bug Description

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

Tags: pt-align
tags: added: pt-align
Changed in percona-toolkit:
status: New → Triaged
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-1119

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.