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

          Transition Time In Source Status Execution Times
          Nirbhay Choubey (Inactive) made transition -
          Open Confirmed
          		6d 14h 3m 1
          Nirbhay Choubey (Inactive) made transition -
          Confirmed In Progress
          		1d 3h 51m 1
          Nirbhay Choubey (Inactive) made transition -
          In Progress In Review
          		1h 19m 1
          Jan Lindström (Inactive) made transition -
          In Review Stalled
          		3h 38m 1
          Nirbhay Choubey (Inactive) made transition -
          Stalled Closed
          		19h 10m 1

          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.