mirror of
https://github.com/MariaDB/server.git
synced 2026-01-03 10:05:44 +01:00
36b2696d6c
Test case changes only. If DDL is made using RSU in only one node, then all objects need also be dropped using RSU. Additionally, added wait_conditions in second test case to verify that DDL and DML has happened to second node before accessing them. Also run MDEV-30764 separately and force restart before test using --force-restart and different config because it does kill whole cluster and this could disturb next test case run by same worker.
49 lines
1.5 KiB
Text
49 lines
1.5 KiB
Text
--source include/galera_cluster.inc
|
|
--source include/have_sequence.inc
|
|
|
|
--connection node_2
|
|
SET AUTOCOMMIT=0;
|
|
SET SESSION wsrep_OSU_method='RSU';
|
|
CREATE TABLE t (i int primary key, j int) ENGINE=InnoDB;
|
|
CREATE TEMPORARY SEQUENCE seq2 NOCACHE ENGINE=InnoDB;
|
|
COMMIT;
|
|
CREATE SEQUENCE seq1 NOCACHE ENGINE=InnoDB;
|
|
COMMIT;
|
|
DROP TABLE t;
|
|
DROP SEQUENCE seq2;
|
|
DROP SEQUENCE seq1;
|
|
SET SESSION wsrep_OSU_method='TOI';
|
|
|
|
--connection node_1
|
|
--let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
|
|
--source include/wait_condition.inc
|
|
SET GLOBAL wsrep_OSU_method='TOI';
|
|
CREATE TABLE t (i int primary key, j int) ENGINE=InnoDB;
|
|
SET AUTOCOMMIT=0;
|
|
INSERT INTO t VALUES (3,0);
|
|
CREATE TEMPORARY SEQUENCE seq1 NOCACHE ENGINE=InnoDB;
|
|
COMMIT;
|
|
INSERT INTO t VALUES (4,0);
|
|
CREATE SEQUENCE seq2 NOCACHE ENGINE=InnoDB;
|
|
COMMIT;
|
|
|
|
--connection node_2
|
|
SET SESSION wsrep_sync_wait=0;
|
|
--let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
|
|
--source include/wait_condition.inc
|
|
--let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't'
|
|
--source include/wait_condition.inc
|
|
--let $wait_condition = SELECT COUNT(*) = 2 FROM t
|
|
--source include/wait_condition.inc
|
|
|
|
SELECT * FROM t;
|
|
--error ER_NO_SUCH_TABLE
|
|
SHOW CREATE TABLE seq1;
|
|
SHOW CREATE TABLE seq2;
|
|
|
|
--connection node_1
|
|
DROP TABLE t;
|
|
DROP SEQUENCE seq1;
|
|
DROP SEQUENCE seq2;
|
|
|
|
--source include/galera_end.inc
|