[MDEV-35748] Attempting to create a CONNECT engine Table results in non-InnoDB sequences in Galera cluster error - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.11.9
Fix Version/s: 10.5.29, 10.6.22, 10.11.12, 11.4.6
Component/s: Galera, Storage Engine - Connect, wsrep
Labels:
- regression

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

MDEV-35924 Create CONNECT-engine-table => "doesn't yet support 'non-InnoDB sequences in Galera cluster'"

Closed

Activity

Ascending order - Click to sort in descending order

Stephan Vos created issue - 2025-01-02 13:31

Stephan Vos made changes - 2025-01-02 13:40

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

Sergei Golubchik made changes - 2025-01-02 17:20

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

Sergei Golubchik made changes - 2025-01-02 17:20

Component/s

wsrep [ 11500 ]

Sergei Golubchik made changes - 2025-01-02 17:20

Fix Version/s

10.11 [ 27614 ]

Sergei Golubchik made changes - 2025-01-02 17:20

Labels

regression

Sergei Golubchik made changes - 2025-01-02 17:20

Assignee

Jan Lindström [ JIRAUSER53125 ]

Jan Lindström made changes - 2025-01-14 09:17

Status

Open [ 1 ]

In Progress [ 3 ]

Jan Lindström made changes - 2025-01-16 09:52

Assignee	Jan Lindström [ JIRAUSER53125 ]	Julius Goryavsky [ sysprg ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Julius Goryavsky made changes - 2025-02-03 00:04

Status

In Review [ 10002 ]

Stalled [ 10000 ]

Julius Goryavsky made changes - 2025-02-03 00:05

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 ]

Julius Goryavsky made changes - 2025-02-03 03:34

Fix Version/s		10.6.22 [ 29997 ]
Fix Version/s		10.11.12 [ 29998 ]
Fix Version/s		11.4.6 [ 29999 ]

Sergei Golubchik made changes - 2025-02-03 20:06

Link

This issue is duplicated by ~~MDEV-35924~~ [ ~~MDEV-35924~~ ]

People

Assignee:: Julius Goryavsky

Reporter:: Stephan Vos

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2025-01-02 13:31

Updated:: 2025-03-10 08:46

Resolved:: 2025-02-03 00:05

Git Integration

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