[MDEV-7673] CREATE TABLE SELECT fails on Galera cluster Created: 2015-03-05  Updated: 2015-03-11  Resolved: 2015-03-06

Status: Closed
Project: MariaDB Server
Component/s: wsrep
Affects Version/s: 10.0.16-galera
Fix Version/s: 5.5.43-galera, 10.0.17-galera

Type: Bug Priority: Major
Reporter: Nirbhay Choubey (Inactive) Assignee: Nirbhay Choubey (Inactive)
Resolution: Fixed Votes: 0
Labels: galera


 Description   

Execute the following command on one of the Galera nodes :

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

Error log:

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...



 Comments   
Comment by Nirbhay Choubey (Inactive) [ 2015-03-05 ]

Patch contributed by Andrew W Elble :
https://lists.launchpad.net/maria-developers/msg08237.html

Comment by Nirbhay Choubey (Inactive) [ 2015-03-06 ]

http://lists.askmonty.org/pipermail/commits/2015-March/007526.html

Comment by Jan Lindström (Inactive) [ 2015-03-06 ]

Ok to push!

Comment by Nirbhay Choubey (Inactive) [ 2015-03-06 ]

https://github.com/MariaDB/server/commit/d146605124a3d326f3769fd162e0af0a124266a9

Generated at Thu Feb 08 07:21:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.