[#MDEV-27861] Creating partitioned tables should not be allowed with wsrep_osu_method=TOI and wsrep_strict

[MDEV-27861] Creating partitioned tables should not be allowed with wsrep_osu_method=TOI and wsrep_strict_ddl=ON Created: 2022-02-16 Updated: 2023-07-27
Status:	In Review
Project:	MariaDB Server
Component/s:	Galera, Partitioning, wsrep
Affects Version/s:	10.5.2
Fix Version/s:	10.5

Type:

Bug

Priority:

Major

Reporter:

Nicolas Bigler

Assignee:

Julius Goryavsky

Resolution:

Unresolved

Votes:

Labels:

None

Description

When a galera cluster is configured with wsrep_osu_method=TOI and wsrep_strict_ddl=ON it's not possible to alter or delete partitioned tables (You will get the error message ERROR 4165 (HY000): DDL-statement is forbidden as table storage engine does not support Galera replication.

However it's still possible to create partitioned tables with those settings.
This should be disallowed, as it doesn't make sense to have partitioned tables, when you can't alter them (eg when you want to run a reorganize of the table).

Comments

Comment by Jan Lindström [ 2023-07-17 ]

nicolas.bigler Based on documentation "If set, reject DDL on affected tables not supporting Galera replication", thus it should not effect InnoDB but it seems to do so in ALTER. This is a bug.

Comment by Jan Lindström [ 2023-07-27 ]

10.5 : https://github.com/MariaDB/server/pull/2716
10.6+: https://github.com/MariaDB/server/pull/2717

Generated at Thu Feb 08 09:56:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.

[MDEV-27861] Creating partitioned tables should not be allowed with wsrep_osu_method=TOI and wsrep_strict_ddl=ON Created: 2022-02-16 Updated: 2023-07-27