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

Creating a table using engine "SPHINX" in a Galera cluster results in an error (1235)

Details

    Description

      When I create a new table using the SPHINX engine I get the error "SQL Error (1235): This version of MariaDB doesn't yet support 'non-InnoDB sequences in Galera cluster'". It looks like this still works in MariaDB Server 10.4.33, but not in 10.4.34 and also not in the latest 11.4 version (currently 11.4.5).

      After some searching I think it is related to this Jira issue and this Git commit.

      To reproduce the issue, please run this SQL script on a MariaDB Server in a Galera cluster.

      CREATE TABLE IF NOT EXISTS `sphinx_foo` (
      		 
      	`id` BIGINT( 10 ) DEFAULT NULL ,
      		 
      	`weight` INT( 11 ) DEFAULT NULL ,
      		 
      	`query` VARCHAR( 3072 ) NOT NULL ,
      		 
      	KEY `query` ( `query` ( 1024 ) )
      		 
      ) ENGINE=SPHINX CONNECTION='sphinx://127.0.0.1:9312/foo' DEFAULT CHARSET=UTF8;

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25089 Assertion `error.len > 0' failed in wsrep_status_t galera::ReplicatorSMM::handle_apply_error(galera::TrxHandleSlave&, const wsrep_buf_t&, const string&)

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          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

            People

              janlindstrom Jan Lindström
              arjenpost Arjen Post
              Votes:
              2 Vote for this issue
              Watchers:
              6 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.