[MDEV-8166] Adding index on new table from select crashes Galera cluster Created: 2015-05-15  Updated: 2015-06-18  Resolved: 2015-05-17

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.0.17-galera, 5.5.43
Fix Version/s: 5.5.44-galera, 10.0.20-galera

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

Attachments: File my.cnf     Text File server.1.log     Text File server.2.log     Text File server.3.log    

 Description   

This is reproducible everytime. Doing a CREATE from SELECT, and then adding INDEX on column results in crashing of all other servers in Galera cluster.

I have attached my.cnf MariaDB configuration, and the test setup is simple consiting of three servers. Execute this on one of the servers:

CREATE DATABASE foobar;
 
USE foobar;
 
 
 
CREATE TABLE foo (
 
  timestamp int(11) NOT NULL DEFAULT '0'
 
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 
 
INSERT INTO foo (timestamp) VALUES (1), (2), (3);
 
 
 
CREATE TABLE bar (timestamp INT) SELECT timestamp FROM foo; ALTER TABLE bar ADD INDEX tind (timestamp);

And all the rest of the servers will crash. I have attached relevant log files. Take a look at server.2.log or server.3.log.

Some widely used software (ie Drupal's Views Data Export module) uses this statements, which is how we encountered this bug.

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

https://github.com/MariaDB/server/commit/0bfae356d4f774c939a5642cd19ee6bfc682b8e7.patch

Comment by Nikola Kotur [ 2015-05-18 ]

Thank you, Nirbhay!

Comment by Nikola Kotur [ 2015-05-19 ]

I don't see this in ChangeLog for MariaDB 10.0.19-galera. Will you release it in the next version?

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

Hi kotnik, The bug report came in a bit late. Yes, the patch has already been pushed
to the trees and will be released with version 5.5.44-galera and 10.0.20-galera.

Comment by Nikola Kotur [ 2015-06-17 ]

Hi Nirbhay.

I see MariaDB 5.4.44 has been released, but not MaraDB Galera. Any news on when that might happen?

Please, do let me know, this is very critical for us.

Thank you.

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

Hi kotnik!
Galera server normally releases a couple of weeks after the corresponding vanilla server release. Fix
for this issue has already been pushed and should be available with the next galera server release.

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

Hopefully, it should release sometime next week.

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