mirror of
https://github.com/MariaDB/server.git
synced 2025-02-23 13:53:10 +01:00
9389428380
Problem was incorrect handling of partitioned tables, because db_type == DB_TYPE_PARTITION_DB wsrep_should_replicate_ddl incorrectly marked DDL as not replicatable. However, in partitioned tables we should check implementing storage engine from table->file->partition_ht() if available because if partition handler is InnoDB all DDL should be allowed even with wsrep_strict_ddl. For other storage engines DDL should not be allowed and error should be issued. This is 10.6 version of the fix. Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
196 lines
6.1 KiB
Text
196 lines
6.1 KiB
Text
connection node_2;
|
|
connection node_1;
|
|
call mtr.add_suppression("WSREP: ALTER TABLE isolation failure");
|
|
connection node_1;
|
|
SET GLOBAL binlog_format='ROW';
|
|
create table before_t1(a int, count int, b int, key(b)) engine=Aria;
|
|
INSERT INTO before_t1 values (1,1,1);
|
|
SET @@global.wsrep_mode=STRICT_REPLICATION;
|
|
select @@global.wsrep_mode;
|
|
@@global.wsrep_mode
|
|
STRICT_REPLICATION
|
|
connection node_2;
|
|
SET @@global.wsrep_mode=STRICT_REPLICATION;
|
|
select @@global.wsrep_mode;
|
|
@@global.wsrep_mode
|
|
STRICT_REPLICATION
|
|
connection node_1;
|
|
CREATE TABLE t1(a int) engine=Aria;
|
|
ERROR HY000: Galera replication not supported
|
|
SHOW WARNINGS;
|
|
Level Code Message
|
|
Error 4165 Galera replication not supported
|
|
Warning 1031 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine Aria not supported.
|
|
connection node_2;
|
|
SHOW CREATE TABLE t1;
|
|
ERROR 42S02: Table 'test.t1' doesn't exist
|
|
connection node_1;
|
|
CREATE TABLE t2(a int not null primary key) engine=InnoDB;
|
|
ALTER TABLE t2 engine=MyISAM;
|
|
ERROR HY000: Galera replication not supported
|
|
SHOW WARNINGS;
|
|
Level Code Message
|
|
Error 4165 Galera replication not supported
|
|
Warning 1031 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MyISAM not supported.
|
|
Error 4165 Galera replication not supported
|
|
Warning 1031 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MyISAM not supported.
|
|
SHOW CREATE TABLE t2;
|
|
Table Create Table
|
|
t2 CREATE TABLE `t2` (
|
|
`a` int(11) NOT NULL,
|
|
PRIMARY KEY (`a`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
|
|
connection node_2;
|
|
SHOW CREATE TABLE t2;
|
|
Table Create Table
|
|
t2 CREATE TABLE `t2` (
|
|
`a` int(11) NOT NULL,
|
|
PRIMARY KEY (`a`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
|
|
connection node_1;
|
|
TRUNCATE TABLE before_t1;
|
|
ERROR HY000: Galera replication not supported
|
|
SELECT * FROM before_t1;
|
|
a count b
|
|
1 1 1
|
|
connection node_2;
|
|
SET SESSION wsrep_sync_wait=15;
|
|
SELECT @@wsrep_sync_wait;
|
|
@@wsrep_sync_wait
|
|
15
|
|
SELECT * FROM before_t1;
|
|
a count b
|
|
connection node_1;
|
|
CREATE VIEW x1 AS SELECT * FROM before_t1;
|
|
ERROR HY000: Galera replication not supported
|
|
SHOW CREATE VIEW x1;
|
|
ERROR 42S02: Table 'test.x1' doesn't exist
|
|
connection node_2;
|
|
SHOW CREATE VIEW x1;
|
|
ERROR 42S02: Table 'test.x1' doesn't exist
|
|
connection node_1;
|
|
CREATE DEFINER=`root`@`localhost` TRIGGER increment_before_t1
|
|
AFTER INSERT ON before_t1 FOR EACH ROW
|
|
UPDATE before_t1 SET before_t1.count = before_t1.count+1;
|
|
ERROR HY000: Galera replication not supported
|
|
SHOW CREATE TRIGGER increment_before_t1;
|
|
ERROR HY000: Trigger does not exist
|
|
connection node_2;
|
|
SHOW CREATE TRIGGER increment_before_t1;
|
|
ERROR HY000: Trigger does not exist
|
|
connection node_1;
|
|
CREATE INDEX xx2 ON before_t1(a);
|
|
ERROR HY000: Galera replication not supported
|
|
SHOW CREATE TABLE before_t1;
|
|
Table Create Table
|
|
before_t1 CREATE TABLE `before_t1` (
|
|
`a` int(11) DEFAULT NULL,
|
|
`count` int(11) DEFAULT NULL,
|
|
`b` int(11) DEFAULT NULL,
|
|
KEY `b` (`b`)
|
|
) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1
|
|
connection node_2;
|
|
SHOW CREATE TABLE before_t1;
|
|
Table Create Table
|
|
before_t1 CREATE TABLE `before_t1` (
|
|
`a` int(11) DEFAULT NULL,
|
|
`count` int(11) DEFAULT NULL,
|
|
`b` int(11) DEFAULT NULL,
|
|
KEY `b` (`b`)
|
|
) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1
|
|
connection node_1;
|
|
DROP INDEX b ON before_t1;
|
|
ERROR HY000: Galera replication not supported
|
|
SHOW CREATE TABLE before_t1;
|
|
Table Create Table
|
|
before_t1 CREATE TABLE `before_t1` (
|
|
`a` int(11) DEFAULT NULL,
|
|
`count` int(11) DEFAULT NULL,
|
|
`b` int(11) DEFAULT NULL,
|
|
KEY `b` (`b`)
|
|
) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1
|
|
connection node_2;
|
|
SHOW CREATE TABLE before_t1;
|
|
Table Create Table
|
|
before_t1 CREATE TABLE `before_t1` (
|
|
`a` int(11) DEFAULT NULL,
|
|
`count` int(11) DEFAULT NULL,
|
|
`b` int(11) DEFAULT NULL,
|
|
KEY `b` (`b`)
|
|
) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1
|
|
connection node_1;
|
|
ALTER TABLE before_t1 ADD COLUMN f int;
|
|
ERROR HY000: Galera replication not supported
|
|
SHOW CREATE TABLE before_t1;
|
|
Table Create Table
|
|
before_t1 CREATE TABLE `before_t1` (
|
|
`a` int(11) DEFAULT NULL,
|
|
`count` int(11) DEFAULT NULL,
|
|
`b` int(11) DEFAULT NULL,
|
|
KEY `b` (`b`)
|
|
) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1
|
|
connection node_2;
|
|
SHOW CREATE TABLE before_t1;
|
|
Table Create Table
|
|
before_t1 CREATE TABLE `before_t1` (
|
|
`a` int(11) DEFAULT NULL,
|
|
`count` int(11) DEFAULT NULL,
|
|
`b` int(11) DEFAULT NULL,
|
|
KEY `b` (`b`)
|
|
) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1
|
|
connection node_1;
|
|
RENAME TABLE before_t1 to after_t1;
|
|
ERROR HY000: Galera replication not supported
|
|
SHOW CREATE TABLE before_t1;
|
|
Table Create Table
|
|
before_t1 CREATE TABLE `before_t1` (
|
|
`a` int(11) DEFAULT NULL,
|
|
`count` int(11) DEFAULT NULL,
|
|
`b` int(11) DEFAULT NULL,
|
|
KEY `b` (`b`)
|
|
) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1
|
|
SHOW CREATE TABLE after_t1;
|
|
ERROR 42S02: Table 'test.after_t1' doesn't exist
|
|
connection node_2;
|
|
SHOW CREATE TABLE before_t1;
|
|
Table Create Table
|
|
before_t1 CREATE TABLE `before_t1` (
|
|
`a` int(11) DEFAULT NULL,
|
|
`count` int(11) DEFAULT NULL,
|
|
`b` int(11) DEFAULT NULL,
|
|
KEY `b` (`b`)
|
|
) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1
|
|
SHOW CREATE TABLE after_t1;
|
|
ERROR 42S02: Table 'test.after_t1' doesn't exist
|
|
connection node_1;
|
|
DROP TABLE before_t1;
|
|
ERROR HY000: Galera replication not supported
|
|
SHOW CREATE TABLE before_t1;
|
|
Table Create Table
|
|
before_t1 CREATE TABLE `before_t1` (
|
|
`a` int(11) DEFAULT NULL,
|
|
`count` int(11) DEFAULT NULL,
|
|
`b` int(11) DEFAULT NULL,
|
|
KEY `b` (`b`)
|
|
) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1
|
|
connection node_2;
|
|
SHOW CREATE TABLE before_t1;
|
|
Table Create Table
|
|
before_t1 CREATE TABLE `before_t1` (
|
|
`a` int(11) DEFAULT NULL,
|
|
`count` int(11) DEFAULT NULL,
|
|
`b` int(11) DEFAULT NULL,
|
|
KEY `b` (`b`)
|
|
) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1
|
|
connection node_1;
|
|
set @@global.wsrep_mode=default;
|
|
select @@global.wsrep_mode;
|
|
@@global.wsrep_mode
|
|
|
|
connection node_2;
|
|
set @@global.wsrep_mode=default;
|
|
select @@global.wsrep_mode;
|
|
@@global.wsrep_mode
|
|
|
|
DROP TABLE t2;
|
|
DROP TABLE before_t1;
|