pt-table-sync table filter fails when database has same name

Bug #1474140 reported by Frank Cizmich
This bug affects 3 people
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to
In Progress
Frank Cizmich

Bug Description

(originally reported by David Ducos)

sample command:

pt-table-sync --print --verbose -d stats -t stats --no-foreign-key-checks --no-check-master --no-check-slave --where="date='2015-07-12'" h=host1 h=host2

To reproduce simply create database "stats" with a table "stats" and also another table (must have more than one table for the bug to manifest.)

excerpt of PTDEBUG output:

# SchemaIterator:7864 473 Table stats is only allowed in database HASH(0x1637b630)
# SchemaIterator:7738 473 Found 0 tables in database stats

Changed in percona-toolkit:
status: New → In Progress
importance: Undecided → Medium
assignee: nobody → Frank Cizmich (frank-cizmich)
tags: added: option-parsing pt-table-sync
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to:

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers