TRUNCATE TEMPORARY table is replicated
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL patches by Codership | Status tracked in 5.6 | |||||
5.5 |
Fix Released
|
High
|
Teemu Ollakka | |||
5.6 |
Fix Released
|
High
|
Teemu Ollakka | |||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC | Status tracked in 5.6 | |||||
5.5 |
Fix Released
|
Undecided
|
Raghavendra D Prabhu | |||
5.6 |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
TEMPORARY tables are not replicated, but any DDL on those tables are, which generates error messages on the other nodes.
130621 14:53:10 [Warning] WSREP: Ignoring error for TO isolated action: source: 193e9e28-
130621 14:53:10 [ERROR] Slave SQL: Error 'Table 'moodle.
130621 14:53:10 [Warning] WSREP: RBR event 1 Query apply warning: 1, 938472
130621 14:53:10 [Warning] WSREP: Ignoring error for TO isolated action: source: 193e9e28-
Ideally, DDL applied to a TEMPORARY TABLE would not get replicated at all.
tags: | added: ddl |
DDL needs to be filtered here as well, like for lp:1177263