--ignore-tables does not work correctly
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,
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,
but keep db4.tbl1 in the pt-table-checksum run.
Happens with and without option --replicate-
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_
# Cxn:3656 29577 Destroying cxn
Related branches
- Daniel Nichter: Approve
-
Diff: 206 lines (+36/-26)6 files modifiedbin/pt-duplicate-key-checker (+4/-5)
bin/pt-index-usage (+4/-5)
bin/pt-table-checksum (+4/-5)
bin/pt-table-sync (+4/-5)
lib/SchemaIterator.pm (+4/-5)
t/lib/SchemaIterator.t (+16/-1)
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