CREATE TABLE SELECT fails on Galera cluster

Description

Execute the following command on one of the Galera nodes :

1 CREATE TABLE t1 (i INT) ENGINE=INNODB DEFAULT CHARSET=utf8 SELECT 1 as i;

Error log:

1 2 3 4 5 6 7 8 9 10 150305 16:12:59 [Note] WSREP: 1.0 (my_node2): State transfer from 0.0 (my_node1) complete. 150305 16:12:59 [Note] WSREP: Member 1.0 (my_node2) synced with group. 150305 16:13:14 [Warning] WSREP: BF applier failed to open_and_lock_tables: 1146, fatal: 0 wsrep = (exec_mode: 1 conflict_state: 0 seqno: 1) 150305 16:13:14 [ERROR] Slave SQL: Error executing row event: 'Table 'test.t1' doesn't exist', Internal MariaDB error code: 1146 150305 16:13:14 [Warning] WSREP: RBR event 2 Write_rows_v1 apply warning: 1146, 1 150305 16:13:14 [Warning] WSREP: Failed to apply app buffer: seqno: 1, status: 1 at galera/src/trx_handle.cpp:apply():351 ... 150305 16:13:14 [ERROR] WSREP: Failed to apply trx 1 4 times 150305 16:13:14 [ERROR] WSREP: Node consistency compromized, aborting...

Environment

None

Status

Assignee

Nirbhay Choubey

Reporter

Nirbhay Choubey

Labels

External issue ID

None

External issue ID

None

Components

Fix versions

Affects versions

10.0.16-galera

Priority

Major
Configure