Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 CHAR(1));
5 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
6 connection node_1a;
7 SET SESSION wsrep_sync_wait = 0;
8 connection node_1;
9 CREATE PROCEDURE proc_update_insert()
10 BEGIN
11 UPDATE t1 SET f2 = 'b';
12 INSERT INTO t1 VALUES (4, 'd');
13 END|
14 INSERT INTO t1 VALUES (1, 'a'), (3, 'a');
15 SET SESSION wsrep_sync_wait = 0;
16 connection node_1a;
17 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
18 connection node_2;
19 INSERT INTO t1 VALUES (2, 'c');
20 connection node_1a;
21 SET SESSION wsrep_on = 0;
22 SET SESSION wsrep_on = 1;
23 SET GLOBAL wsrep_provider_options = 'dbug=';
24 SET GLOBAL wsrep_provider_options = 'dbug=d,after_replicate_sync';
25 connection node_1;
26 CALL proc_update_insert;
27 connection node_1a;
28 SET SESSION wsrep_on = 0;
29 SET SESSION wsrep_on = 1;
30 SET GLOBAL wsrep_provider_options = 'dbug=';
31 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
32 SET GLOBAL wsrep_provider_options = 'signal=after_replicate_sync';
33 connection node_1;
34 SET SESSION wsrep_sync_wait = default;
35 SELECT * FROM t1;
36 f1 f2
37 1 b
38 2 c
39 3 b
40 4 d
41 wsrep_local_replays
42 1
43 DELETE FROM t1;
44 connection node_1;
45 CREATE PROCEDURE proc_update_insert_with_exit_handler()
46 BEGIN
47 DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN END;
48 UPDATE t1 SET f2 = 'b';
49 INSERT INTO t1 VALUES (4, 'd');
50 END|
51 INSERT INTO t1 VALUES (1, 'a'), (3, 'a');
52 SET SESSION wsrep_sync_wait = 0;
53 connection node_1a;
54 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
55 connection node_2;
56 INSERT INTO t1 VALUES (2, 'c');
57 connection node_1a;
58 SET SESSION wsrep_on = 0;
59 SET SESSION wsrep_on = 1;
60 SET GLOBAL wsrep_provider_options = 'dbug=';
61 SET GLOBAL wsrep_provider_options = 'dbug=d,after_replicate_sync';
62 connection node_1;
63 CALL proc_update_insert_with_exit_handler;
64 connection node_1a;
65 SET SESSION wsrep_on = 0;
66 SET SESSION wsrep_on = 1;
67 SET GLOBAL wsrep_provider_options = 'dbug=';
68 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
69 SET GLOBAL wsrep_provider_options = 'signal=after_replicate_sync';
70 connection node_1;
71 SET SESSION wsrep_sync_wait = default;
72 SELECT * FROM t1;
73 f1 f2
74 1 b
75 2 c
76 3 b
77 4 d
78 wsrep_local_replays
79 1
80 DELETE FROM t1;
81 connection node_1;
82 CREATE PROCEDURE proc_update_insert_with_continue_handler()
83 BEGIN
84 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
85 UPDATE t1 SET f2 = 'b';
86 INSERT INTO t1 VALUES (4, 'd');
87 END|
88 INSERT INTO t1 VALUES (1, 'a'), (3, 'a');
89 SET SESSION wsrep_sync_wait = 0;
90 connection node_1a;
91 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
92 connection node_2;
93 INSERT INTO t1 VALUES (2, 'c');
94 connection node_1a;
95 SET SESSION wsrep_on = 0;
96 SET SESSION wsrep_on = 1;
97 SET GLOBAL wsrep_provider_options = 'dbug=';
98 SET GLOBAL wsrep_provider_options = 'dbug=d,after_replicate_sync';
99 connection node_1;
100 CALL proc_update_insert_with_continue_handler;
101 connection node_1a;
102 SET SESSION wsrep_on = 0;
103 SET SESSION wsrep_on = 1;
104 SET GLOBAL wsrep_provider_options = 'dbug=';
105 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
106 SET GLOBAL wsrep_provider_options = 'signal=after_replicate_sync';
107 connection node_1;
108 SET SESSION wsrep_sync_wait = default;
109 SELECT * FROM t1;
110 f1 f2
111 1 b
112 2 c
113 3 b
114 4 d
115 wsrep_local_replays
116 1
117 DELETE FROM t1;
118 connection node_1;
119 CREATE PROCEDURE proc_update_insert_transaction()
120 BEGIN
121 START TRANSACTION;
122 UPDATE t1 SET f2 = 'b';
123 INSERT INTO t1 VALUES (4, 'd');
124 COMMIT;
125 END|
126 INSERT INTO t1 VALUES (1, 'a'), (3, 'a');
127 SET SESSION wsrep_sync_wait = 0;
128 connection node_1a;
129 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
130 connection node_2;
131 INSERT INTO t1 VALUES (2, 'c');
132 connection node_1a;
133 SET SESSION wsrep_on = 0;
134 SET SESSION wsrep_on = 1;
135 SET GLOBAL wsrep_provider_options = 'dbug=';
136 SET GLOBAL wsrep_provider_options = 'dbug=d,after_replicate_sync';
137 connection node_1;
138 CALL proc_update_insert_transaction;
139 connection node_1a;
140 SET SESSION wsrep_on = 0;
141 SET SESSION wsrep_on = 1;
142 SET GLOBAL wsrep_provider_options = 'dbug=';
143 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
144 SET GLOBAL wsrep_provider_options = 'signal=after_replicate_sync';
145 connection node_1;
146 SET SESSION wsrep_sync_wait = default;
147 SELECT * FROM t1;
148 f1 f2
149 1 b
150 2 c
151 3 b
152 4 d
153 wsrep_local_replays
154 1
155 DELETE FROM t1;
156 connection node_1;
157 CREATE PROCEDURE proc_update_insert_transaction_with_continue_handler()
158 BEGIN
159 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
160 START TRANSACTION;
161 UPDATE t1 SET f2 = 'b';
162 INSERT INTO t1 VALUES (4, 'd');
163 COMMIT;
164 END|
165 INSERT INTO t1 VALUES (1, 'a'), (3, 'a');
166 SET SESSION wsrep_sync_wait = 0;
167 connection node_1a;
168 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
169 connection node_2;
170 INSERT INTO t1 VALUES (2, 'c');
171 connection node_1a;
172 SET SESSION wsrep_on = 0;
173 SET SESSION wsrep_on = 1;
174 SET GLOBAL wsrep_provider_options = 'dbug=';
175 SET GLOBAL wsrep_provider_options = 'dbug=d,after_replicate_sync';
176 connection node_1;
177 CALL proc_update_insert_transaction_with_continue_handler;
178 connection node_1a;
179 SET SESSION wsrep_on = 0;
180 SET SESSION wsrep_on = 1;
181 SET GLOBAL wsrep_provider_options = 'dbug=';
182 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
183 SET GLOBAL wsrep_provider_options = 'signal=after_replicate_sync';
184 connection node_1;
185 SET SESSION wsrep_sync_wait = default;
186 SELECT * FROM t1;
187 f1 f2
188 1 b
189 2 c
190 3 b
191 4 d
192 wsrep_local_replays
193 1
194 DELETE FROM t1;
195 connection node_1;
196 CREATE PROCEDURE proc_update_insert_transaction_with_exit_handler()
197 BEGIN
198 DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN END;
199 START TRANSACTION;
200 UPDATE t1 SET f2 = 'b';
201 INSERT INTO t1 VALUES (4, 'd');
202 COMMIT;
203 END|
204 INSERT INTO t1 VALUES (1, 'a'), (3, 'a');
205 SET SESSION wsrep_sync_wait = 0;
206 connection node_1a;
207 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
208 connection node_2;
209 INSERT INTO t1 VALUES (2, 'c');
210 connection node_1a;
211 SET SESSION wsrep_on = 0;
212 SET SESSION wsrep_on = 1;
213 SET GLOBAL wsrep_provider_options = 'dbug=';
214 SET GLOBAL wsrep_provider_options = 'dbug=d,after_replicate_sync';
215 connection node_1;
216 CALL proc_update_insert_transaction_with_exit_handler;
217 connection node_1a;
218 SET SESSION wsrep_on = 0;
219 SET SESSION wsrep_on = 1;
220 SET GLOBAL wsrep_provider_options = 'dbug=';
221 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
222 SET GLOBAL wsrep_provider_options = 'signal=after_replicate_sync';
223 connection node_1;
224 SET SESSION wsrep_sync_wait = default;
225 SELECT * FROM t1;
226 f1 f2
227 1 b
228 2 c
229 3 b
230 4 d
231 wsrep_local_replays
232 1
233 DELETE FROM t1;
234 connection node_1;
235 CREATE PROCEDURE proc_insert_insert_conflict()
236 BEGIN
237 INSERT INTO t1 VALUES (2, 'd');
238 INSERT INTO t1 VALUES (4, 'd');
239 END|
240 INSERT INTO t1 VALUES (1, 'a'), (3, 'a');
241 SET SESSION wsrep_sync_wait = 0;
242 connection node_1a;
243 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
244 connection node_2;
245 INSERT INTO t1 VALUES (2, 'c');
246 connection node_1a;
247 SET SESSION wsrep_on = 0;
248 SET SESSION wsrep_on = 1;
249 SET GLOBAL wsrep_provider_options = 'dbug=';
250 SET GLOBAL wsrep_provider_options = 'dbug=d,after_replicate_sync';
251 connection node_1;
252 CALL proc_insert_insert_conflict;
253 connection node_1a;
254 SET SESSION wsrep_on = 0;
255 SET SESSION wsrep_on = 1;
256 SET GLOBAL wsrep_provider_options = 'dbug=';
257 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
258 SET GLOBAL wsrep_provider_options = 'signal=after_replicate_sync';
259 connection node_1;
260 Got one of the listed errors
261 SET SESSION wsrep_sync_wait = default;
262 SELECT * FROM t1;
263 f1 f2
264 1 a
265 2 c
266 3 a
267 wsrep_local_replays
268 1
269 DELETE FROM t1;
270 connection node_1;
271 CREATE PROCEDURE proc_insert_insert_conflict_with_exit_handler()
272 BEGIN
273 DECLARE EXIT HANDLER FOR SQLEXCEPTION SELECT "Conflict exit handler";
274 INSERT INTO t1 VALUES (2, 'd');
275 INSERT INTO t1 VALUES (4, 'd');
276 END|
277 INSERT INTO t1 VALUES (1, 'a'), (3, 'a');
278 SET SESSION wsrep_sync_wait = 0;
279 connection node_1a;
280 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
281 connection node_2;
282 INSERT INTO t1 VALUES (2, 'c');
283 connection node_1a;
284 SET SESSION wsrep_on = 0;
285 SET SESSION wsrep_on = 1;
286 SET GLOBAL wsrep_provider_options = 'dbug=';
287 SET GLOBAL wsrep_provider_options = 'dbug=d,after_replicate_sync';
288 connection node_1;
289 CALL proc_insert_insert_conflict_with_exit_handler;
290 connection node_1a;
291 SET SESSION wsrep_on = 0;
292 SET SESSION wsrep_on = 1;
293 SET GLOBAL wsrep_provider_options = 'dbug=';
294 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
295 SET GLOBAL wsrep_provider_options = 'signal=after_replicate_sync';
296 connection node_1;
297 Conflict exit handler
298 Conflict exit handler
299 SET SESSION wsrep_sync_wait = default;
300 SELECT * FROM t1;
301 f1 f2
302 1 a
303 2 c
304 3 a
305 wsrep_local_replays
306 1
307 DELETE FROM t1;
308 connection node_1;
309 CREATE PROCEDURE proc_insert_insert_conflict_with_continue_handler()
310 BEGIN
311 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SELECT "Conflict continue handler";
312 INSERT INTO t1 VALUES (2, 'd');
313 INSERT INTO t1 VALUES (4, 'd');
314 END|
315 INSERT INTO t1 VALUES (1, 'a'), (3, 'a');
316 SET SESSION wsrep_sync_wait = 0;
317 connection node_1a;
318 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
319 connection node_2;
320 INSERT INTO t1 VALUES (2, 'c');
321 connection node_1a;
322 SET SESSION wsrep_on = 0;
323 SET SESSION wsrep_on = 1;
324 SET GLOBAL wsrep_provider_options = 'dbug=';
325 SET GLOBAL wsrep_provider_options = 'dbug=d,after_replicate_sync';
326 connection node_1;
327 CALL proc_insert_insert_conflict_with_continue_handler;
328 connection node_1a;
329 SET SESSION wsrep_on = 0;
330 SET SESSION wsrep_on = 1;
331 SET GLOBAL wsrep_provider_options = 'dbug=';
332 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
333 SET GLOBAL wsrep_provider_options = 'signal=after_replicate_sync';
334 connection node_1;
335 Conflict continue handler
336 Conflict continue handler
337 SET SESSION wsrep_sync_wait = default;
338 SELECT * FROM t1;
339 f1 f2
340 1 a
341 2 c
342 3 a
343 4 d
344 wsrep_local_replays
345 1
346 DELETE FROM t1;
347 DROP PROCEDURE proc_update_insert;
348 DROP PROCEDURE proc_update_insert_with_continue_handler;
349 DROP PROCEDURE proc_update_insert_with_exit_handler;
350 DROP PROCEDURE proc_update_insert_transaction;
351 DROP PROCEDURE proc_update_insert_transaction_with_continue_handler;
352 DROP PROCEDURE proc_update_insert_transaction_with_exit_handler;
353 DROP PROCEDURE proc_insert_insert_conflict;
354 DROP PROCEDURE proc_insert_insert_conflict_with_exit_handler;
355 DROP PROCEDURE proc_insert_insert_conflict_with_continue_handler;
356 DROP TABLE t1;