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

CREATE TABLE SELECT fails on Galera cluster

    XMLWordPrintable

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

      Attachments

        Activity

          People

            nirbhay_c Nirbhay Choubey (Inactive)
            nirbhay_c Nirbhay Choubey (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.