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

CREATE TABLE SELECT fails on Galera cluster

    Details

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

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            nirbhay_c Nirbhay Choubey added a comment -

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

            Show
            nirbhay_c Nirbhay Choubey added a comment - Patch contributed by Andrew W Elble : https://lists.launchpad.net/maria-developers/msg08237.html
            Show
            nirbhay_c Nirbhay Choubey added a comment - http://lists.askmonty.org/pipermail/commits/2015-March/007526.html
            Hide
            jplindst Jan Lindström added a comment -

            Ok to push!

            Show
            jplindst Jan Lindström added a comment - Ok to push!
            Show
            nirbhay_c Nirbhay Choubey added a comment - https://github.com/MariaDB/server/commit/d146605124a3d326f3769fd162e0af0a124266a9

              People

              • Assignee:
                nirbhay_c Nirbhay Choubey
                Reporter:
                nirbhay_c Nirbhay Choubey
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: