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

enforce_storage_engine doesn't block table creation on other nodes (galera cluster)

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1.7
    • 10.1.8
    • Galera
    • ubuntu server 15.04 64bits

    Description

      I set enforce_storage_engine to InnoDB and disable Myisam replication on all nodes of my cluster.

      When I try to create a Myisam table on a node, I logically get this error : Unknown storage engine 'MyISAM' and the table isn't created on this node.
      But it has been created on all other nodes! In the end, this table exists on every nodes of the cluster but one.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          ronan Ronan GORAIN created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Assignee Nirbhay Choubey [ nirbhay_c ]
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Status Open [ 1 ] Confirmed [ 10101 ]
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Status Confirmed [ 10101 ] In Progress [ 3 ]
          nirbhay_c Nirbhay Choubey (Inactive) added a comment -

          Patch attached.

          nirbhay_c Nirbhay Choubey (Inactive) added a comment - Patch attached.
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Assignee Nirbhay Choubey [ nirbhay_c ] Jan Lindström [ jplindst ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          jplindst Jan Lindström (Inactive) added a comment -

          Ok to push.

          jplindst Jan Lindström (Inactive) added a comment - Ok to push.
          jplindst Jan Lindström (Inactive) made changes -
          Assignee Jan Lindström [ jplindst ] Nirbhay Choubey [ nirbhay_c ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          serg Sergei Golubchik added a comment -

          nirbhay_c, why a failed CREATE TABLE statement is replicated at all?

          serg Sergei Golubchik added a comment - nirbhay_c , why a failed CREATE TABLE statement is replicated at all?
          nirbhay_c Nirbhay Choubey (Inactive) added a comment -

          serg because, Galera replicates DDL during parsing (WSREP_TO_ISOLATION_BEGIN).

          nirbhay_c Nirbhay Choubey (Inactive) added a comment - serg because, Galera replicates DDL during parsing (WSREP_TO_ISOLATION_BEGIN).
          serg Sergei Golubchik added a comment -

          nirbhay_c, and what happens if the table cannot be created? Like, table already exists, table exists in the InnoDB tablespace, unsupported combination of values for table options, whatever.

          serg Sergei Golubchik added a comment - nirbhay_c , and what happens if the table cannot be created? Like, table already exists, table exists in the InnoDB tablespace, unsupported combination of values for table options, whatever.
          nirbhay_c Nirbhay Choubey (Inactive) added a comment -

          serg In that case, the DDL is expected to fail on all the nodes.

          nirbhay_c Nirbhay Choubey (Inactive) added a comment - serg In that case, the DDL is expected to fail on all the nodes.
          nirbhay_c Nirbhay Choubey (Inactive) added a comment -

          https://github.com/MariaDB/server/commit/38f3b99d469ab90f07287577d05e48928de720d4

          nirbhay_c Nirbhay Choubey (Inactive) added a comment - https://github.com/MariaDB/server/commit/38f3b99d469ab90f07287577d05e48928de720d4
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Fix Version/s 10.1.8 [ 19605 ]
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 71723 ] MariaDB v4 [ 149635 ]

          People

            nirbhay_c Nirbhay Choubey (Inactive)
            ronan Ronan GORAIN
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.