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

Attempting to create a CONNECT engine Table results in non-InnoDB sequences in Galera cluster error

Details

    Description

      The following fails with seemingly completely unrelated error on a 10.11.9 Galera Cluster:

      CREATE OR REPLACE TABLE hub.`mmc_players_test` (
      		 
        `mmc_serialNumber` varchar(10) DEFAULT NULL,
      		 
        `network_name` varchar(50) DEFAULT NULL,
      		 
        `player_desc` varchar(200) DEFAULT NULL,
      		 
        `group_name` varchar(50) DEFAULT NULL,
      		 
        `venue_name` varchar(100) DEFAULT NULL,
      		 
        `venue_desc` varchar(200) DEFAULT NULL,
      		 
        `layout_name` varchar(50) DEFAULT NULL,
      		 
        `layout_desc` varchar(200) DEFAULT NULL
      		 
      ) ENGINE=CONNECT table_type=mysql CONNECTION='mysql://aaa:bbb@x.x.x.x/mc_media/v_mmc_players';

      [42000][1235] This version of MariaDB doesn't yet support 'non-InnoDB sequences in Galera cluster'

      PLUGIN_VERSION=1.7
      PLUGIN_TYPE_VERSION=101109.0
      PLUGIN_AUTH_VERSION=1.07.0003

      The above create CONNECT table statements works correctly on a 10.6.15 Galera Cluster.
      PLUGIN_VERSION=1.7
      PLUGIN_TYPE_VERSION=100615.0
      PLUGIN_AUTH_VERSION=1.07.0003

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35924 Create CONNECT-engine-table => "doesn't yet support 'non-InnoDB sequences in Galera cluster'"

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            stephanvos Stephan Vos created issue -
            stephanvos Stephan Vos made changes -
            Field Original Value New Value
            Summary Attempting to create a CONNECT engine results in non-InnoDB sequences in Galera cluster error Attempting to create a CONNECT engine Table results in non-InnoDB sequences in Galera cluster error
            serg Sergei Golubchik made changes -
            Description The following fails with seemingly completely unrelated error on a 10.11.9 Galera Cluster:

            CREATE OR REPLACE TABLE hub.`mmc_players_test` (
              `mmc_serialNumber` varchar(10) DEFAULT NULL,
              `network_name` varchar(50) DEFAULT NULL,
              `player_desc` varchar(200) DEFAULT NULL,
              `group_name` varchar(50) DEFAULT NULL,
              `venue_name` varchar(100) DEFAULT NULL,
              `venue_desc` varchar(200) DEFAULT NULL,
              `layout_name` varchar(50) DEFAULT NULL,
              `layout_desc` varchar(200) DEFAULT NULL
            ) ENGINE=CONNECT table_type=mysql CONNECTION='mysql://aaa:bbb@x.x.x.x/mc_media/v_mmc_players';

            {color:red}*[42000][1235] This version of MariaDB doesn't yet support 'non-InnoDB sequences in Galera cluster'*{color}

            PLUGIN_VERSION=1.7
            PLUGIN_TYPE_VERSION=101109.0
            PLUGIN_AUTH_VERSION=1.07.0003

            The above create CONNECT table statements works correctly on a 10.6.15 Galera Cluster.
            PLUGIN_VERSION=1.7
            PLUGIN_TYPE_VERSION=100615.0
            PLUGIN_AUTH_VERSION=1.07.0003

            		The following fails with seemingly completely unrelated error on a 10.11.9 Galera Cluster:
            {code:sql}
            CREATE OR REPLACE TABLE hub.`mmc_players_test` (
              `mmc_serialNumber` varchar(10) DEFAULT NULL,
              `network_name` varchar(50) DEFAULT NULL,
              `player_desc` varchar(200) DEFAULT NULL,
              `group_name` varchar(50) DEFAULT NULL,
              `venue_name` varchar(100) DEFAULT NULL,
              `venue_desc` varchar(200) DEFAULT NULL,
              `layout_name` varchar(50) DEFAULT NULL,
              `layout_desc` varchar(200) DEFAULT NULL
            ) ENGINE=CONNECT table_type=mysql CONNECTION='mysql://aaa:bbb@x.x.x.x/mc_media/v_mmc_players';
            {code}
            {color:red}*[42000][1235] This version of MariaDB doesn't yet support 'non-InnoDB sequences in Galera cluster'*{color}

            PLUGIN_VERSION=1.7
            PLUGIN_TYPE_VERSION=101109.0
            PLUGIN_AUTH_VERSION=1.07.0003

            The above create CONNECT table statements works correctly on a 10.6.15 Galera Cluster.
            PLUGIN_VERSION=1.7
            PLUGIN_TYPE_VERSION=100615.0
            PLUGIN_AUTH_VERSION=1.07.0003

            serg Sergei Golubchik made changes -
            Component/s wsrep [ 11500 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.11 [ 27614 ]
            serg Sergei Golubchik made changes -
            Labels regression
            serg Sergei Golubchik made changes -
            Assignee Jan Lindström [ JIRAUSER53125 ]
            janlindstrom Jan Lindström made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            janlindstrom Jan Lindström made changes -
            Assignee Jan Lindström [ JIRAUSER53125 ] Julius Goryavsky [ sysprg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            sysprg Julius Goryavsky made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            sysprg Julius Goryavsky made changes -
            Component/s Galera [ 10124 ]
            Fix Version/s 10.5.29 [ 29996 ]
            Fix Version/s 10.11 [ 27614 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            sysprg Julius Goryavsky made changes -
            Fix Version/s 10.6.22 [ 29997 ]
            Fix Version/s 10.11.12 [ 29998 ]
            Fix Version/s 11.4.6 [ 29999 ]
            serg Sergei Golubchik made changes -

            People

              sysprg Julius Goryavsky
              stephanvos Stephan Vos
              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.