Debian Codegraph @

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

raw
1 #
2 # Test option wsrep_ignore_apply_errors
3 #
4
5 --source include/have_perfschema.inc
6 --source include/galera_cluster.inc
7 --source include/force_restart.inc
8
9 #
10 # Ignore reconciling DDL errors on node_2
11 #
12
13 --connection node_2
14 SET GLOBAL wsrep_ignore_apply_errors = 1;
15
16 # Drop table that does not exist
17 --connection node_1
18 SET GLOBAL wsrep_on = OFF;
19 CREATE TABLE t1 (f1 INTEGER);
20 SET GLOBAL wsrep_on = ON;
21 --source include/wait_until_ready.inc
22 DROP TABLE t1;
23
24 --connection node_2
25 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t1';
26 --source include/wait_condition.inc
27 SHOW TABLES;
28
29 # Drop schema that does not exist
30 --connection node_1
31 SET GLOBAL wsrep_on = OFF;
32 CREATE SCHEMA s1;
33 SET GLOBAL wsrep_on = ON;
34 --source include/wait_until_ready.inc
35 DROP SCHEMA s1;
36
37 --connection node_2
38 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME LIKE 's1';
39 --source include/wait_condition.inc
40 SHOW SCHEMAS;
41
42 # Drop index that does not exist using DROP INDEX
43 --connection node_1
44 CREATE TABLE t1 (f1 INTEGER);
45 SET GLOBAL wsrep_on = OFF;
46 CREATE INDEX idx1 ON t1 (f1);
47 SET GLOBAL wsrep_on = ON;
48 --source include/wait_until_ready.inc
49 DROP INDEX idx1 ON t1;
50
51 --connection node_2
52 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t1';
53 --source include/wait_condition.inc
54 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES WHERE NAME LIKE 'idx1';
55 --source include/wait_condition.inc
56 SHOW CREATE TABLE t1;
57 DROP TABLE t1;
58
59 # Drop index that does not exist using ALTER TABLE
60 --connection node_1
61 CREATE TABLE t1 (f1 INTEGER);
62 SET GLOBAL wsrep_on = OFF;
63 CREATE INDEX idx1 ON t1 (f1);
64 SET GLOBAL wsrep_on = ON;
65 --source include/wait_until_ready.inc
66 ALTER TABLE t1 DROP INDEX idx1;
67
68 --connection node_2
69 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t1';
70 --source include/wait_condition.inc
71 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES WHERE NAME LIKE 'idx1';
72 --source include/wait_condition.inc
73 SHOW CREATE TABLE t1;
74 DROP TABLE t1;
75
76 # Drop column that does not exist
77 --connection node_1
78 CREATE TABLE t1 (f1 INTEGER);
79 SET GLOBAL wsrep_on = OFF;
80 ALTER TABLE t1 ADD COLUMN f2 INTEGER;
81 SET GLOBAL wsrep_on = ON;
82 --source include/wait_until_ready.inc
83 ALTER TABLE t1 DROP COLUMN f2;
84
85 --connection node_2
86 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t1';
87 --source include/wait_condition.inc
88 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS WHERE NAME LIKE 'f2';
89 --source include/wait_condition.inc
90
91 SHOW CREATE TABLE t1;
92 DROP TABLE t1;
93
94
95 #
96 # Ignore reconciling DML errors on node_2
97 #
98
99 --connection node_2
100 SET GLOBAL wsrep_ignore_apply_errors = 2;
101
102 # Delete row that does not exist
103 --connection node_1
104 CREATE TABLE t1 (f1 INTEGER);
105 SET GLOBAL wsrep_on = OFF;
106 INSERT INTO t1 VALUES (1);
107 SET GLOBAL wsrep_on = ON;
108 --source include/wait_until_ready.inc
109 DELETE FROM t1 WHERE f1 = 1;
110 SELECT COUNT(*) AS expect_0 FROM t1;
111
112 --connection node_2
113 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t1';
114 --source include/wait_condition.inc
115 --let $wait_condition = SELECT COUNT(*) = 0 FROM t1;
116 --source include/wait_condition.inc
117 SELECT COUNT(*) AS expect_0 FROM t1;
118 DROP TABLE t1;
119
120 # Delete row that does not exist in a multi statement transaction
121 --connection node_1
122 CREATE TABLE t1 (f1 INTEGER);
123 INSERT INTO t1 VALUES (2);
124 SET GLOBAL wsrep_on = OFF;
125 INSERT INTO t1 VALUES (1);
126 SET GLOBAL wsrep_on = ON;
127 --source include/wait_until_ready.inc
128 START TRANSACTION;
129 INSERT INTO t1 VALUES (3);
130 DELETE FROM t1 WHERE f1 = 1;
131 DELETE FROM t1 WHERE f1 = 2;
132 COMMIT;
133 SELECT COUNT(*) AS expect_1 FROM t1;
134
135 --connection node_2
136 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t1';
137 --source include/wait_condition.inc
138 --let $wait_condition = SELECT COUNT(*) = 1 FROM t1;
139 --source include/wait_condition.inc
140 SELECT COUNT(*) AS expect_1 FROM t1;
141 DROP TABLE t1;
142
143 #
144 # Multi-row delete where only one row does not exist
145 #
146
147 --connection node_1
148 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
149 INSERT INTO t1 VALUES (1),(2),(3),(4),(5);
150 --connection node_2
151 --let $wait_condition = SELECT COUNT(*) = 5 FROM t1;
152 --source include/wait_condition.inc
153
154 SET SESSION wsrep_on = OFF;
155 DELETE FROM t1 WHERE f1 = 3;
156 SET SESSION wsrep_on = ON;
157 --source include/wait_until_ready.inc
158
159 --connection node_1
160 DELETE FROM t1;
161 SELECT COUNT(*) AS expect_0 FROM t1;
162
163 --connection node_2
164 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t1';
165 --source include/wait_condition.inc
166 --let $wait_condition = SELECT COUNT(*) = 0 FROM t1;
167 --source include/wait_condition.inc
168 SELECT VARIABLE_VALUE expect_Primary FROM performance_schema.global_status WHERE VARIABLE_NAME = 'wsrep_cluster_status';
169 SELECT COUNT(*) AS expect_0 FROM t1;
170 DROP TABLE t1;
171
172 #
173 # Multi-statement delete where only one row does not exist
174 #
175
176 --connection node_1
177 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
178 INSERT INTO t1 VALUES (1),(2),(3),(4),(5);
179 --connection node_2
180 --let $wait_condition = SELECT COUNT(*) = 5 FROM t1;
181 --source include/wait_condition.inc
182
183 SET SESSION wsrep_on = OFF;
184 DELETE FROM t1 WHERE f1 = 3;
185 SET SESSION wsrep_on = ON;
186 --source include/wait_until_ready.inc
187
188 --connection node_1
189 SET AUTOCOMMIT=OFF;
190 START TRANSACTION;
191 DELETE FROM t1 WHERE f1 = 1;
192 DELETE FROM t1 WHERE f1 = 2;
193 DELETE FROM t1 WHERE f1 = 3;
194 DELETE FROM t1 WHERE f1 = 4;
195 DELETE FROM t1 WHERE f1 = 5;
196 COMMIT;
197 SET AUTOCOMMIT=ON;
198 SELECT COUNT(*) AS expect_0 FROM t1;
199
200 --connection node_2
201 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t1';
202 --source include/wait_condition.inc
203 --let $wait_condition = SELECT COUNT(*) = 0 FROM t1;
204 --source include/wait_condition.inc
205 SELECT VARIABLE_VALUE expect_Primary FROM performance_schema.global_status WHERE VARIABLE_NAME = 'wsrep_cluster_status';
206 SELECT COUNT(*) AS expect_0 FROM t1;
207 DROP TABLE t1;
208
209 #
210 # Multi-table delete
211 #
212
213 --connection node_1
214 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
215 INSERT INTO t1 VALUES (1),(2),(3);
216 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
217 INSERT INTO t2 VALUES (1),(2),(3);
218
219 --connection node_2
220 --let $wait_condition = SELECT COUNT(*) = 3 FROM t2;
221 --source include/wait_condition.inc
222
223 SET SESSION wsrep_on = OFF;
224 DELETE FROM t2 WHERE f1 = 2;
225 DELETE FROM t1 WHERE f1 = 3;
226 SET SESSION wsrep_on = ON;
227 --source include/wait_until_ready.inc
228
229 --connection node_1
230 DELETE t1, t2 FROM t1 JOIN t2 WHERE t1.f1 = t2.f1;
231 SELECT COUNT(*) expect_0 FROM t1;
232
233 --connection node_2
234 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t1';
235 --source include/wait_condition.inc
236 --let $wait_condition = SELECT COUNT(*) = 0 FROM t1;
237 --source include/wait_condition.inc
238 SELECT VARIABLE_VALUE = 'Primary' FROM performance_schema.global_status WHERE VARIABLE_NAME = 'wsrep_cluster_status';
239 SELECT COUNT(*) expect_0 FROM t1;
240 DROP TABLE t1,t2;
241
242 #
243 # Foreign keys
244 #
245
246 --connection node_1
247 CREATE TABLE parent (id INT NOT NULL, PRIMARY KEY (id)) ENGINE=INNODB;
248 INSERT INTO parent VALUES (1),(2),(3);
249 CREATE TABLE child (id INT, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE CASCADE) ENGINE=INNODB;
250 INSERT INTO child VALUES (1,1),(2,2),(3,3);
251
252 --connection node_2
253 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/parent';
254 --source include/wait_condition.inc
255 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/child';
256 --source include/wait_condition.inc
257 --let $wait_condition = SELECT COUNT(*) = 3 FROM child;
258 --source include/wait_condition.inc
259
260 SET SESSION wsrep_on = OFF;
261 DELETE FROM child WHERE parent_id = 2;
262 SET SESSION wsrep_on = ON;
263 --source include/wait_until_ready.inc
264
265 --connection node_1
266 DELETE FROM parent;
267 SELECT COUNT(*) AS expect_0 FROM parent;
268 SELECT COUNT(*) AS expect_0 FROM child;
269
270 --connection node_2
271 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/parent';
272 --source include/wait_condition.inc
273 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/child';
274 --source include/wait_condition.inc
275 --let $wait_condition = SELECT COUNT(*) = 0 FROM child;
276 --source include/wait_condition.inc
277 SELECT VARIABLE_VALUE = 'Primary' FROM performance_schema.global_status WHERE VARIABLE_NAME = 'wsrep_cluster_status';
278 SELECT COUNT(*) AS expect_0 FROM parent;
279 SELECT COUNT(*) AS expect_0 FROM child;
280 DROP TABLE child, parent;
281
282 #
283 # Ignore all DDL errors on node_2
284 #
285
286 --connection node_2
287 SET GLOBAL wsrep_ignore_apply_errors = 4;
288
289 # Create a table that already exists
290 --connection node_2
291 SET GLOBAL wsrep_on = OFF;
292 CREATE TABLE t1 (f1 INTEGER);
293 SET GLOBAL wsrep_on = ON;
294 --source include/wait_until_ready.inc
295
296 --connection node_1
297 CREATE TABLE t1 (f1 INTEGER, f2 INTEGER);
298 DROP TABLE t1;
299
300 --connection node_2
301 set session wsrep_sync_wait=0;
302 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'
303 --source include/wait_condition.inc
304 --error ER_NO_SUCH_TABLE
305 SELECT * FROM t1;
306 SET GLOBAL wsrep_ignore_apply_errors = 10;
307
308 CALL mtr.add_suppression("Can't find record in ");
309 CALL mtr.add_suppression("Slave SQL: Could not execute Delete_rows event");
310 CALL mtr.add_suppression("Slave SQL: Error 'Unknown table 'test\\.t1'' on query\\. Default database: 'test'\\. Query: 'DROP TABLE t1', Error_code: 1051");
311 CALL mtr.add_suppression("Slave SQL: Error 'Can't drop database 's1'; database doesn't exist' on query\\. Default database: 'test'\\. Query: 'DROP SCHEMA s1', Error_code: 1008");
312 CALL mtr.add_suppression("Slave SQL: Error 'Can't DROP 'idx1'; check that column/key exists' on query\\. Default database: 'test'\\. Query: 'DROP INDEX idx1 ON t1', Error_code: 1091");
313 CALL mtr.add_suppression("Slave SQL: Error 'Can't DROP 'idx1'; check that column/key exists' on query\\. Default database: 'test'\\. Query: 'ALTER TABLE t1 DROP INDEX idx1', Error_code: 1091");
314 CALL mtr.add_suppression("Slave SQL: Error 'Can't DROP 'f2'; check that column/key exists' on query\\. Default database: 'test'\\. Query: 'ALTER TABLE t1 DROP COLUMN f2', Error_code: 1091");
315 CALL mtr.add_suppression("Slave SQL: Error 'Table 't1' already exists' on query\\.");
316 CALL mtr.add_suppression("Inconsistency detected: Inconsistent by consensus on ");