pt-online-schema-change is stuck when the table that is being altered is filtered out in the slave
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
pt-online-
Found 2 slaves:
kits-desktop -> SBslave1:20595
kits-desktop -> SBslave2:20596
Will check slave lag on:
kits-desktop -> SBslave1:20595
kits-desktop -> SBslave2:20596
Operation, tries, wait:
analyze_table, 10, 1
copy_rows, 10, 0.25
create_triggers, 10, 1
drop_triggers, 10, 1
swap_tables, 10, 1
update_
Altering `employees`
Creating new table...
Created new table employees.
Waiting forever for new table `employees`
Waiting for kits-desktop: 0% 00:00 remain
Waiting for kits-desktop: 0% 00:00 remain
Waiting for kits-desktop: 0% 00:00 remain
Waiting for kits-desktop: 0% 00:00 remain
Waiting for kits-desktop: 0% 00:00 remain
Waiting for kits-desktop: 0% 00:00 remain
Waiting for kits-desktop: 0% 00:00 remain
Waiting for kits-desktop: 0% 00:00 remain
Waiting for kits-desktop: 0% 00:00 remain
To reproduce, add a filter on the database of the slave's my.cnf config and restart:
replicate-
Then try running pt-online-
pt-online-
Changed in percona-toolkit: | |
status: | New → Confirmed |
tags: | added: i211081 |
What's the expected behavior?
The documentation says:
If the replicas are configured with any filtering options, you should be careful not to modify any databases or tables that exist on the master and not the replicas, because it could cause replication to fail. For more information on replication rules, see http:// dev.mysql. com/doc/ en/replication- rules.html.