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

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  Edit
Everyone can see this information.

Other bug subscribers