enforce_storage_engine=Innodb not compatible with wsrep_replicate_myisam
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
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
|
Raghavendra D Prabhu |
Bug Description
We're running a PXC cluster with enforce_
This worked great in 5.6.21. Tables created as myISAM were transparently converted to InnoDB and properly replicated to the whole cluster.
But in 5.6.22, replication fails and the cluster is stopped.
Steps to reproduce:
1. Configure PXC replication on 5.6.22 w/ these additional options:
enforce_
sqlmode=
2. Create MyISAM table.
3. Put data in the table
4. Crash
Sample logs:
from node 1:
2015-03-23 17:11:32 1926 [Note] WSREP: Cannot replicate MyISAM DDL for [redacted: schema.table_name] with wsrep_replicate
2015-03-23 17:11:34 1926 [Note] WSREP: forgetting 1ec1728d (ssl://[redacted])
2015-03-23 17:11:34 1926 [Note] WSREP: (e3ab5450, 'ssl://
isted, skipping
from node 2:
2015-03-23 17:11:33 1915 [Warning] WSREP: BF applier failed to open_and_
2015-03-23 17:11:33 1915 [ERROR] Slave SQL: Error executing row event: 'Table '[redacted: schema.table_name]' doesn't exist', Error_code: 1146
2015-03-23 17:11:33 1915 [Warning] WSREP: RBR event 3 Write_rows apply warning: 1146, 317
2015-03-23 17:11:33 1915 [Warning] WSREP: Failed to apply app buffer: seqno: 317, status: 1
at galera/
Retrying 2th time
summary: |
- Regression: bug-1402338-5.5 breaks replication with - enforce_storage_engine=Innodb + Regression: enforce_storage_engine=Innodb not compatible with + wsrep_replicate_myisam |
summary: |
- Regression: enforce_storage_engine=Innodb not compatible with - wsrep_replicate_myisam + enforce_storage_engine=Innodb not compatible with wsrep_replicate_myisam |
Oops, here's the link to the bug mentioned in the title: /code.launchpad .net/~percona- core/percona- xtradb- cluster/ bug-1402338- 5.5/+merge/ 245523
https:/