--ignore-tables does not work correctly

Bug #1304062 reported by Louzbeck
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Fix Released
Medium
Frank Cizmich

Bug Description

Hello, just wanted to let you know about this small issue.
Thanks! percona toolkit is very handy indeed :)

root@xxxxxxx:~# pt-table-checksum --version
pt-table-checksum 2.2.7

(mysql Ver 14.14 Distrib 5.5.34)

When using --ignore-tables options in the following manner:

pt-table-checksum --ignore-tables db1.tbl1,db2.tbl1,db3.tbl1

pt-table-checksum does not ignore *all* the "tbl1" tables correctly and only ignores *one* of them.

I realized this because I wanted to ignore: db1.tbl1,db2.tbl1,db3.tbl1
but keep db4.tbl1 in the pt-table-checksum run.

Happens with and without option --replicate-check-only

PTDEBUG shows:

# SchemaIterator:7243 29577 Filter ignore-tables value: db1 tbl1
# SchemaIterator:7243 29577 Filter ignore-tables value: db2 tbl1
# SchemaIterator:7243 29577 Filter ignore-tables value: percona checksums
# SchemaIterator:7243 29577 Filter ignore-tables value: db3 tbl1
# SchemaIterator:7247 29577 Filter ignore-engines value: mrg_myisam
# SchemaIterator:7247 29577 Filter ignore-engines value: federated
# SchemaIterator:7267 29577 Schema object filters: $VAR1 = {
# 'ignore-engines' => {
# federated => 1,
# mrg_myisam => 1
# },
# 'ignore-tables' => {
# checksums => 'percona',
# tbl1 => 'db3'
# }
# };
#
# SchemaIterator:7513 29577 Table tbl1 is in --ignore-tables list
# pt_table_checksum:9470 29577 Exit status 16 oktorun 1
# Cxn:3656 29577 Destroying cxn

Related branches

Changed in percona-toolkit:
assignee: nobody → Frank Cizmich (frank-cizmich)
importance: Undecided → Medium
status: New → In Progress
milestone: none → 2.2.8
summary: - pt-table-checksum (2.2.7) --ignore-tables does not ignore tables
- correctly
+ --ignore-tables does not work correctly
tags: added: filters schema-iter
removed: pt-table-checksum
Changed in percona-toolkit:
status: In Progress → Fix Committed
Changed in percona-toolkit:
status: Fix Committed → Fix Released
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-645

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.