--ignore-tables does not work correctly

Bug #1304062 reported by Louzbeck on 2014-04-07
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Toolkit
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

lp:~percona-toolkit-dev/percona-toolkit/ptc-ignore-tables-bug-1304062
Merged into lp:percona-toolkit at revision 599
Daniel Nichter: Approve on 2014-05-27
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
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers