Debian Codegraph @

mysql-test/suite/galera/t/galera_disallow_local_gtid.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_aria.inc
3 #
4 # Nodes can have GTIDs for local transactions in the following scenarios:
5 #
6 # A DDL statement is executed with wsrep_OSU_method=RSU set.
7 # A DML statement writes to a non-InnoDB table.
8 # A DML statement writes to an InnoDB table with wsrep_on=OFF set.
9 #
10 call mtr.add_suppression("WSREP: ALTER TABLE isolation failure");
11 #
12 # A DDL statement is executed with wsrep_OSU_method=RSU set.
13 #
14 --connection node_1
15 CREATE TABLE tab(a int not null primary key) engine=InnoDB;
16 CREATE TABLE tab1(a int not null primary key) engine=MyISAM;
17 CREATE TABLE tab2(a int not null primary key) engine=Aria;
18 CREATE TABLE tab3(a int not null primary key) engine=MEMORY;
19
20 SET GLOBAL wsrep_mode = DISALLOW_LOCAL_GTID;
21 SET SESSION wsrep_OSU_method='RSU';
22
23 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
24 ALTER TABLE tab FORCE;
25
26 SET SESSiON sql_log_bin=0;
27 ALTER TABLE tab FORCE;
28 SET SESSION wsrep_OSU_method='TOI';
29 #
30 # A DML statement writes to an InnoDB table with wsrep_on=OFF set.
31 #
32 SET SESSION sql_log_bin=1;
33 SET SESSION wsrep_on=OFF;
34 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
35 INSERT INTO tab VALUES (1);
36 SET SESSiON sql_log_bin=0;
37 INSERT INTO tab VALUES (1);
38 SET SESSiON sql_log_bin=1;
39 SET SESSION wsrep_on=ON;
40 INSERT INTO tab VALUES (2);
41
42 SELECT * FROM tab;
43 --connection node_2
44 SELECT * FROM tab;
45 #
46 # A DML statement writes to a non-InnoDB table.
47 #
48 --connection node_1
49 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
50 INSERT INTO tab1 VALUES(1);
51 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
52 INSERT INTO tab2 VALUES(1);
53 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
54 INSERT INTO tab3 VALUES(1);
55 #
56 # Set MyISAM and Aria replication on using TOI
57 #
58 SET GLOBAL wsrep_mode = "DISALLOW_LOCAL_GTID,REPLICATE_MYISAM,REPLICATE_ARIA";
59 INSERT INTO tab1 VALUES(2);
60 INSERT INTO tab2 VALUES(2);
61 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
62 INSERT INTO tab3 VALUES(2);
63 SET SESSiON sql_log_bin=0;
64 INSERT INTO tab1 VALUES(3);
65 INSERT INTO tab2 VALUES(3);
66 INSERT INTO tab3 VALUES(3);
67 SET SESSION sql_log_bin=1;
68 SET SESSION wsrep_on=OFF;
69 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
70 INSERT INTO tab1 VALUES(4);
71 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
72 INSERT INTO tab2 VALUES(4);
73 --error ER_GALERA_REPLICATION_NOT_SUPPORTED
74 INSERT INTO tab3 VALUES(4);
75 SET SESSiON sql_log_bin=0;
76 INSERT INTO tab1 VALUES(5);
77 INSERT INTO tab2 VALUES(5);
78 INSERT INTO tab3 VALUES(5);
79 SET SESSION wsrep_on=ON;
80 INSERT INTO tab1 VALUES(6);
81 INSERT INTO tab2 VALUES(6);
82 INSERT INTO tab3 VALUES(6);
83
84 SELECT * FROM tab1;
85 SELECT * FROM tab2;
86 SELECT * FROM tab3;
87
88 --connection node_2
89 SELECT * FROM tab1;
90 SELECT * FROM tab2;
91 SELECT * FROM tab3;
92
93 --connection node_1
94 --disable_query_log
95 SET SESSION sql_log_bin=DEFAULT;
96 SET GLOBAL wsrep_mode=DEFAULT;
97 set GLOBAL wsrep_OSU_method=DEFAULT;
98 --enable_query_log
99
100 DROP TABLE tab;
101 DROP TABLE tab1;
102 DROP TABLE tab2;
103 DROP TABLE tab3;