Debian Codegraph @

mysql-test/suite/galera/r/wsrep_mode_strict_replication.result

raw
1 connection node_2;
2 connection node_1;
3 call mtr.add_suppression("WSREP: ALTER TABLE isolation failure");
4 connection node_1;
5 SET GLOBAL binlog_format='ROW';
6 create table before_t1(a int, count int, b int, key(b)) engine=Aria;
7 INSERT INTO before_t1 values (1,1,1);
8 SET @@global.wsrep_mode=STRICT_REPLICATION;
9 select @@global.wsrep_mode;
10 @@global.wsrep_mode
11 STRICT_REPLICATION
12 connection node_2;
13 SET @@global.wsrep_mode=STRICT_REPLICATION;
14 select @@global.wsrep_mode;
15 @@global.wsrep_mode
16 STRICT_REPLICATION
17 connection node_1;
18 CREATE TABLE t1(a int) engine=Aria;
19 ERROR HY000: Galera replication not supported
20 SHOW WARNINGS;
21 Level Code Message
22 Error 4165 Galera replication not supported
23 Warning 1031 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine Aria not supported.
24 connection node_2;
25 SHOW CREATE TABLE t1;
26 ERROR 42S02: Table 'test.t1' doesn't exist
27 connection node_1;
28 CREATE TABLE t2(a int not null primary key) engine=InnoDB;
29 ALTER TABLE t2 engine=MyISAM;
30 ERROR HY000: Galera replication not supported
31 SHOW WARNINGS;
32 Level Code Message
33 Error 4165 Galera replication not supported
34 Warning 1031 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MyISAM not supported.
35 Error 4165 Galera replication not supported
36 Warning 1031 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MyISAM not supported.
37 SHOW CREATE TABLE t2;
38 Table Create Table
39 t2 CREATE TABLE `t2` (
40 `a` int(11) NOT NULL,
41 PRIMARY KEY (`a`)
42 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
43 connection node_2;
44 SHOW CREATE TABLE t2;
45 Table Create Table
46 t2 CREATE TABLE `t2` (
47 `a` int(11) NOT NULL,
48 PRIMARY KEY (`a`)
49 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
50 connection node_1;
51 TRUNCATE TABLE before_t1;
52 ERROR HY000: Galera replication not supported
53 SELECT * FROM before_t1;
54 a count b
55 1 1 1
56 connection node_2;
57 SET SESSION wsrep_sync_wait=15;
58 SELECT @@wsrep_sync_wait;
59 @@wsrep_sync_wait
60 15
61 SELECT * FROM before_t1;
62 a count b
63 connection node_1;
64 CREATE VIEW x1 AS SELECT * FROM before_t1;
65 ERROR HY000: Galera replication not supported
66 SHOW CREATE VIEW x1;
67 ERROR 42S02: Table 'test.x1' doesn't exist
68 connection node_2;
69 SHOW CREATE VIEW x1;
70 ERROR 42S02: Table 'test.x1' doesn't exist
71 connection node_1;
72 CREATE DEFINER=`root`@`localhost` TRIGGER increment_before_t1
73 AFTER INSERT ON before_t1 FOR EACH ROW
74 UPDATE before_t1 SET before_t1.count = before_t1.count+1;
75 ERROR HY000: Galera replication not supported
76 SHOW CREATE TRIGGER increment_before_t1;
77 ERROR HY000: Trigger does not exist
78 connection node_2;
79 SHOW CREATE TRIGGER increment_before_t1;
80 ERROR HY000: Trigger does not exist
81 connection node_1;
82 CREATE INDEX xx2 ON before_t1(a);
83 ERROR HY000: Galera replication not supported
84 SHOW CREATE TABLE before_t1;
85 Table Create Table
86 before_t1 CREATE TABLE `before_t1` (
87 `a` int(11) DEFAULT NULL,
88 `count` int(11) DEFAULT NULL,
89 `b` int(11) DEFAULT NULL,
90 KEY `b` (`b`)
91 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
92 connection node_2;
93 SHOW CREATE TABLE before_t1;
94 Table Create Table
95 before_t1 CREATE TABLE `before_t1` (
96 `a` int(11) DEFAULT NULL,
97 `count` int(11) DEFAULT NULL,
98 `b` int(11) DEFAULT NULL,
99 KEY `b` (`b`)
100 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
101 connection node_1;
102 DROP INDEX b ON before_t1;
103 ERROR HY000: Galera replication not supported
104 SHOW CREATE TABLE before_t1;
105 Table Create Table
106 before_t1 CREATE TABLE `before_t1` (
107 `a` int(11) DEFAULT NULL,
108 `count` int(11) DEFAULT NULL,
109 `b` int(11) DEFAULT NULL,
110 KEY `b` (`b`)
111 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
112 connection node_2;
113 SHOW CREATE TABLE before_t1;
114 Table Create Table
115 before_t1 CREATE TABLE `before_t1` (
116 `a` int(11) DEFAULT NULL,
117 `count` int(11) DEFAULT NULL,
118 `b` int(11) DEFAULT NULL,
119 KEY `b` (`b`)
120 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
121 connection node_1;
122 ALTER TABLE before_t1 ADD COLUMN f int;
123 ERROR HY000: Galera replication not supported
124 SHOW CREATE TABLE before_t1;
125 Table Create Table
126 before_t1 CREATE TABLE `before_t1` (
127 `a` int(11) DEFAULT NULL,
128 `count` int(11) DEFAULT NULL,
129 `b` int(11) DEFAULT NULL,
130 KEY `b` (`b`)
131 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
132 connection node_2;
133 SHOW CREATE TABLE before_t1;
134 Table Create Table
135 before_t1 CREATE TABLE `before_t1` (
136 `a` int(11) DEFAULT NULL,
137 `count` int(11) DEFAULT NULL,
138 `b` int(11) DEFAULT NULL,
139 KEY `b` (`b`)
140 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
141 connection node_1;
142 RENAME TABLE before_t1 to after_t1;
143 ERROR HY000: Galera replication not supported
144 SHOW CREATE TABLE before_t1;
145 Table Create Table
146 before_t1 CREATE TABLE `before_t1` (
147 `a` int(11) DEFAULT NULL,
148 `count` int(11) DEFAULT NULL,
149 `b` int(11) DEFAULT NULL,
150 KEY `b` (`b`)
151 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
152 SHOW CREATE TABLE after_t1;
153 ERROR 42S02: Table 'test.after_t1' doesn't exist
154 connection node_2;
155 SHOW CREATE TABLE before_t1;
156 Table Create Table
157 before_t1 CREATE TABLE `before_t1` (
158 `a` int(11) DEFAULT NULL,
159 `count` int(11) DEFAULT NULL,
160 `b` int(11) DEFAULT NULL,
161 KEY `b` (`b`)
162 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
163 SHOW CREATE TABLE after_t1;
164 ERROR 42S02: Table 'test.after_t1' doesn't exist
165 connection node_1;
166 DROP TABLE before_t1;
167 ERROR HY000: Galera replication not supported
168 SHOW CREATE TABLE before_t1;
169 Table Create Table
170 before_t1 CREATE TABLE `before_t1` (
171 `a` int(11) DEFAULT NULL,
172 `count` int(11) DEFAULT NULL,
173 `b` int(11) DEFAULT NULL,
174 KEY `b` (`b`)
175 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
176 connection node_2;
177 SHOW CREATE TABLE before_t1;
178 Table Create Table
179 before_t1 CREATE TABLE `before_t1` (
180 `a` int(11) DEFAULT NULL,
181 `count` int(11) DEFAULT NULL,
182 `b` int(11) DEFAULT NULL,
183 KEY `b` (`b`)
184 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
185 connection node_1;
186 set @@global.wsrep_mode=default;
187 select @@global.wsrep_mode;
188 @@global.wsrep_mode
189
190 connection node_2;
191 set @@global.wsrep_mode=default;
192 select @@global.wsrep_mode;
193 @@global.wsrep_mode
194
195 DROP TABLE t2;
196 DROP TABLE before_t1;