Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8166

Adding index on new table from select crashes Galera cluster

    XMLWordPrintable

    Details

      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.

        Attachments

        1. my.cnf
          2 kB
        2. server.1.log
          2 kB
        3. server.2.log
          5 kB
        4. server.3.log
          4 kB

          Activity

            People

            Assignee:
            nirbhay_c Nirbhay Choubey (Inactive)
            Reporter:
            kotnik Nikola Kotur
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: