Debian Codegraph @

mysql-test/suite/binlog/r/binlog_crash_safe_ddl.result

raw
1 include/gtid_utils.inc
2 CREATE TABLE t_1 (a int);
3 include/gtid_step_reset.inc
4 FLUSH LOGS;
5 *** Crash right after 'CREATE USER user1 IDENTIFIED WITH 'mysql_native_password'' has been prepared in the engine before being logged ***
6 SET @@SESSION.debug="+d,crash_commit_before_log";
7 CREATE USER user1 IDENTIFIED WITH 'mysql_native_password';
8 ERROR HY000: Lost connection to MySQL server during query
9 # restart
10 include/gtid_step_assert.inc [count=0, only_count=0]
11 FLUSH LOGS;
12 *** Crash right after 'CREATE USER user1 IDENTIFIED WITH 'mysql_native_password'' has been binary-logged before committed in the engine ***
13 SET @@SESSION.debug="+d,crash_commit_after_log";
14 CREATE USER user1 IDENTIFIED WITH 'mysql_native_password';
15 ERROR HY000: Lost connection to MySQL server during query
16 # restart
17 include/gtid_step_assert.inc [count=1, only_count=0]
18 include/gtid_step_reset.inc
19 FLUSH LOGS;
20 *** Crash right after 'GRANT SELECT ON *.* TO user1' has been prepared in the engine before being logged ***
21 SET @@SESSION.debug="+d,crash_commit_before_log";
22 GRANT SELECT ON *.* TO user1;
23 ERROR HY000: Lost connection to MySQL server during query
24 # restart
25 include/gtid_step_assert.inc [count=0, only_count=0]
26 FLUSH LOGS;
27 *** Crash right after 'GRANT SELECT ON *.* TO user1' has been binary-logged before committed in the engine ***
28 SET @@SESSION.debug="+d,crash_commit_after_log";
29 GRANT SELECT ON *.* TO user1;
30 ERROR HY000: Lost connection to MySQL server during query
31 # restart
32 include/gtid_step_assert.inc [count=1, only_count=0]
33 include/gtid_step_reset.inc
34 FLUSH LOGS;
35 *** Crash right after 'REVOKE SELECT ON *.* FROM user1' has been prepared in the engine before being logged ***
36 SET @@SESSION.debug="+d,crash_commit_before_log";
37 REVOKE SELECT ON *.* FROM user1;
38 ERROR HY000: Lost connection to MySQL server during query
39 # restart
40 include/gtid_step_assert.inc [count=0, only_count=0]
41 FLUSH LOGS;
42 *** Crash right after 'REVOKE SELECT ON *.* FROM user1' has been binary-logged before committed in the engine ***
43 SET @@SESSION.debug="+d,crash_commit_after_log";
44 REVOKE SELECT ON *.* FROM user1;
45 ERROR HY000: Lost connection to MySQL server during query
46 # restart
47 include/gtid_step_assert.inc [count=1, only_count=0]
48 include/gtid_step_reset.inc
49 FLUSH LOGS;
50 *** Crash right after 'ALTER USER user1 IDENTIFIED BY '123456'' has been prepared in the engine before being logged ***
51 SET @@SESSION.debug="+d,crash_commit_before_log";
52 ALTER USER user1 IDENTIFIED BY '123456';
53 ERROR HY000: Lost connection to MySQL server during query
54 # restart
55 include/gtid_step_assert.inc [count=0, only_count=0]
56 FLUSH LOGS;
57 *** Crash right after 'ALTER USER user1 IDENTIFIED BY '123456'' has been binary-logged before committed in the engine ***
58 SET @@SESSION.debug="+d,crash_commit_after_log";
59 ALTER USER user1 IDENTIFIED BY '123456';
60 ERROR HY000: Lost connection to MySQL server during query
61 # restart
62 include/gtid_step_assert.inc [count=1, only_count=0]
63 include/gtid_step_reset.inc
64 FLUSH LOGS;
65 *** Crash right after 'SET PASSWORD FOR user1='abcdef'' has been prepared in the engine before being logged ***
66 SET @@SESSION.debug="+d,crash_commit_before_log";
67 SET PASSWORD FOR user1='abcdef';
68 ERROR HY000: Lost connection to MySQL server during query
69 # restart
70 include/gtid_step_assert.inc [count=0, only_count=0]
71 FLUSH LOGS;
72 *** Crash right after 'SET PASSWORD FOR user1='abcdef'' has been binary-logged before committed in the engine ***
73 SET @@SESSION.debug="+d,crash_commit_after_log";
74 SET PASSWORD FOR user1='abcdef';
75 ERROR HY000: Lost connection to MySQL server during query
76 # restart
77 include/gtid_step_assert.inc [count=1, only_count=0]
78 include/gtid_step_reset.inc
79 FLUSH LOGS;
80 *** Crash right after 'RENAME USER user1 TO user2' has been prepared in the engine before being logged ***
81 SET @@SESSION.debug="+d,crash_commit_before_log";
82 RENAME USER user1 TO user2;
83 ERROR HY000: Lost connection to MySQL server during query
84 # restart
85 include/gtid_step_assert.inc [count=0, only_count=0]
86 FLUSH LOGS;
87 *** Crash right after 'RENAME USER user1 TO user2' has been binary-logged before committed in the engine ***
88 SET @@SESSION.debug="+d,crash_commit_after_log";
89 RENAME USER user1 TO user2;
90 ERROR HY000: Lost connection to MySQL server during query
91 # restart
92 include/gtid_step_assert.inc [count=1, only_count=0]
93 include/gtid_step_reset.inc
94 FLUSH LOGS;
95 *** Crash right after 'CREATE ROLE roleA,roleB' has been prepared in the engine before being logged ***
96 SET @@SESSION.debug="+d,crash_commit_before_log";
97 CREATE ROLE roleA,roleB;
98 ERROR HY000: Lost connection to MySQL server during query
99 # restart
100 include/gtid_step_assert.inc [count=0, only_count=0]
101 FLUSH LOGS;
102 *** Crash right after 'CREATE ROLE roleA,roleB' has been binary-logged before committed in the engine ***
103 SET @@SESSION.debug="+d,crash_commit_after_log";
104 CREATE ROLE roleA,roleB;
105 ERROR HY000: Lost connection to MySQL server during query
106 # restart
107 include/gtid_step_assert.inc [count=1, only_count=0]
108 include/gtid_step_reset.inc
109 FLUSH LOGS;
110 *** Crash right after 'GRANT roleA TO roleB' has been prepared in the engine before being logged ***
111 SET @@SESSION.debug="+d,crash_commit_before_log";
112 GRANT roleA TO roleB;
113 ERROR HY000: Lost connection to MySQL server during query
114 # restart
115 include/gtid_step_assert.inc [count=0, only_count=0]
116 FLUSH LOGS;
117 *** Crash right after 'GRANT roleA TO roleB' has been binary-logged before committed in the engine ***
118 SET @@SESSION.debug="+d,crash_commit_after_log";
119 GRANT roleA TO roleB;
120 ERROR HY000: Lost connection to MySQL server during query
121 # restart
122 include/gtid_step_assert.inc [count=1, only_count=0]
123 include/gtid_step_reset.inc
124 FLUSH LOGS;
125 *** Crash right after 'REVOKE roleA FROM roleB' has been prepared in the engine before being logged ***
126 SET @@SESSION.debug="+d,crash_commit_before_log";
127 REVOKE roleA FROM roleB;
128 ERROR HY000: Lost connection to MySQL server during query
129 # restart
130 include/gtid_step_assert.inc [count=0, only_count=0]
131 FLUSH LOGS;
132 *** Crash right after 'REVOKE roleA FROM roleB' has been binary-logged before committed in the engine ***
133 SET @@SESSION.debug="+d,crash_commit_after_log";
134 REVOKE roleA FROM roleB;
135 ERROR HY000: Lost connection to MySQL server during query
136 # restart
137 include/gtid_step_assert.inc [count=1, only_count=0]
138 include/gtid_step_reset.inc
139 FLUSH LOGS;
140 *** Crash right after 'GRANT roleA TO user2' has been prepared in the engine before being logged ***
141 SET @@SESSION.debug="+d,crash_commit_before_log";
142 GRANT roleA TO user2;
143 ERROR HY000: Lost connection to MySQL server during query
144 # restart
145 include/gtid_step_assert.inc [count=0, only_count=0]
146 FLUSH LOGS;
147 *** Crash right after 'GRANT roleA TO user2' has been binary-logged before committed in the engine ***
148 SET @@SESSION.debug="+d,crash_commit_after_log";
149 GRANT roleA TO user2;
150 ERROR HY000: Lost connection to MySQL server during query
151 # restart
152 include/gtid_step_assert.inc [count=1, only_count=0]
153 include/gtid_step_reset.inc
154 FLUSH LOGS;
155 *** Crash right after 'ALTER USER user2 DEFAULT ROLE roleA;' has been prepared in the engine before being logged ***
156 SET @@SESSION.debug="+d,crash_commit_before_log";
157 ALTER USER user2 DEFAULT ROLE roleA;;
158 ERROR HY000: Lost connection to MySQL server during query
159 # restart
160 include/gtid_step_assert.inc [count=0, only_count=0]
161 FLUSH LOGS;
162 *** Crash right after 'ALTER USER user2 DEFAULT ROLE roleA;' has been binary-logged before committed in the engine ***
163 SET @@SESSION.debug="+d,crash_commit_after_log";
164 ALTER USER user2 DEFAULT ROLE roleA;;
165 ERROR HY000: Lost connection to MySQL server during query
166 # restart
167 include/gtid_step_assert.inc [count=1, only_count=0]
168 include/gtid_step_reset.inc
169 FLUSH LOGS;
170 *** Crash right after 'DROP ROLE roleA,roleB' has been prepared in the engine before being logged ***
171 SET @@SESSION.debug="+d,crash_commit_before_log";
172 DROP ROLE roleA,roleB;
173 ERROR HY000: Lost connection to MySQL server during query
174 # restart
175 include/gtid_step_assert.inc [count=0, only_count=0]
176 FLUSH LOGS;
177 *** Crash right after 'DROP ROLE roleA,roleB' has been binary-logged before committed in the engine ***
178 SET @@SESSION.debug="+d,crash_commit_after_log";
179 DROP ROLE roleA,roleB;
180 ERROR HY000: Lost connection to MySQL server during query
181 # restart
182 include/gtid_step_assert.inc [count=1, only_count=0]
183 include/gtid_step_reset.inc
184 FLUSH LOGS;
185 *** Crash right after 'DROP USER user2' has been prepared in the engine before being logged ***
186 SET @@SESSION.debug="+d,crash_commit_before_log";
187 DROP USER user2;
188 ERROR HY000: Lost connection to MySQL server during query
189 # restart
190 include/gtid_step_assert.inc [count=0, only_count=0]
191 FLUSH LOGS;
192 *** Crash right after 'DROP USER user2' has been binary-logged before committed in the engine ***
193 SET @@SESSION.debug="+d,crash_commit_after_log";
194 DROP USER user2;
195 ERROR HY000: Lost connection to MySQL server during query
196 # restart
197 include/gtid_step_assert.inc [count=1, only_count=0]
198 PREPARE stmt FROM 'CREATE USER user3';
199 DEALLOCATE PREPARE stmt;
200 PREPARE stmt FROM 'DROP USER user3';
201 DEALLOCATE PREPARE stmt;
202 include/gtid_step_reset.inc
203 FLUSH LOGS;
204 *** Crash right after 'CREATE TRIGGER tr_0 BEFORE INSERT ON t_1 FOR EACH ROW SET @a:=1' has been prepared in the engine before being logged ***
205 SET @@SESSION.debug="+d,crash_commit_before_log";
206 CREATE TRIGGER tr_0 BEFORE INSERT ON t_1 FOR EACH ROW SET @a:=1;
207 ERROR HY000: Lost connection to MySQL server during query
208 # restart
209 include/gtid_step_assert.inc [count=0, only_count=0]
210 FLUSH LOGS;
211 *** Crash right after 'CREATE TRIGGER tr_0 BEFORE INSERT ON t_1 FOR EACH ROW SET @a:=1' has been binary-logged before committed in the engine ***
212 SET @@SESSION.debug="+d,crash_commit_after_log";
213 CREATE TRIGGER tr_0 BEFORE INSERT ON t_1 FOR EACH ROW SET @a:=1;
214 ERROR HY000: Lost connection to MySQL server during query
215 # restart
216 include/gtid_step_assert.inc [count=1, only_count=0]
217 include/gtid_step_reset.inc
218 FLUSH LOGS;
219 *** Crash right after 'DROP TRIGGER tr_0' has been prepared in the engine before being logged ***
220 SET @@SESSION.debug="+d,crash_commit_before_log";
221 DROP TRIGGER tr_0;
222 ERROR HY000: Lost connection to MySQL server during query
223 # restart
224 include/gtid_step_assert.inc [count=0, only_count=0]
225 FLUSH LOGS;
226 *** Crash right after 'DROP TRIGGER tr_0' has been binary-logged before committed in the engine ***
227 SET @@SESSION.debug="+d,crash_commit_after_log";
228 DROP TRIGGER tr_0;
229 ERROR HY000: Lost connection to MySQL server during query
230 # restart
231 include/gtid_step_assert.inc [count=1, only_count=0]
232 include/gtid_step_reset.inc
233 FLUSH LOGS;
234 *** Crash right after 'CREATE FUNCTION f_0() RETURNS INT RETURN 5;' has been prepared in the engine before being logged ***
235 SET @@SESSION.debug="+d,crash_commit_before_log";
236 CREATE FUNCTION f_0() RETURNS INT RETURN 5;;
237 ERROR HY000: Lost connection to MySQL server during query
238 # restart
239 include/gtid_step_assert.inc [count=0, only_count=0]
240 FLUSH LOGS;
241 *** Crash right after 'CREATE FUNCTION f_0() RETURNS INT RETURN 5;' has been binary-logged before committed in the engine ***
242 SET @@SESSION.debug="+d,crash_commit_after_log";
243 CREATE FUNCTION f_0() RETURNS INT RETURN 5;;
244 ERROR HY000: Lost connection to MySQL server during query
245 # restart
246 include/gtid_step_assert.inc [count=1, only_count=0]
247 include/gtid_step_reset.inc
248 FLUSH LOGS;
249 *** Crash right after 'ALTER FUNCTION f_0 COMMENT 'comment'' has been prepared in the engine before being logged ***
250 SET @@SESSION.debug="+d,crash_commit_before_log";
251 ALTER FUNCTION f_0 COMMENT 'comment';
252 ERROR HY000: Lost connection to MySQL server during query
253 # restart
254 include/gtid_step_assert.inc [count=0, only_count=0]
255 FLUSH LOGS;
256 *** Crash right after 'ALTER FUNCTION f_0 COMMENT 'comment'' has been binary-logged before committed in the engine ***
257 SET @@SESSION.debug="+d,crash_commit_after_log";
258 ALTER FUNCTION f_0 COMMENT 'comment';
259 ERROR HY000: Lost connection to MySQL server during query
260 # restart
261 include/gtid_step_assert.inc [count=1, only_count=0]
262 include/gtid_step_reset.inc
263 FLUSH LOGS;
264 *** Crash right after 'DROP FUNCTION f_0' has been prepared in the engine before being logged ***
265 SET @@SESSION.debug="+d,crash_commit_before_log";
266 DROP FUNCTION f_0;
267 ERROR HY000: Lost connection to MySQL server during query
268 # restart
269 include/gtid_step_assert.inc [count=0, only_count=0]
270 FLUSH LOGS;
271 *** Crash right after 'DROP FUNCTION f_0' has been binary-logged before committed in the engine ***
272 SET @@SESSION.debug="+d,crash_commit_after_log";
273 DROP FUNCTION f_0;
274 ERROR HY000: Lost connection to MySQL server during query
275 # restart
276 include/gtid_step_assert.inc [count=1, only_count=0]
277 include/gtid_step_reset.inc
278 FLUSH LOGS;
279 *** Crash right after 'CREATE PROCEDURE p_0() BEGIN END' has been prepared in the engine before being logged ***
280 SET @@SESSION.debug="+d,crash_commit_before_log";
281 CREATE PROCEDURE p_0() BEGIN END;
282 ERROR HY000: Lost connection to MySQL server during query
283 # restart
284 include/gtid_step_assert.inc [count=0, only_count=0]
285 FLUSH LOGS;
286 *** Crash right after 'CREATE PROCEDURE p_0() BEGIN END' has been binary-logged before committed in the engine ***
287 SET @@SESSION.debug="+d,crash_commit_after_log";
288 CREATE PROCEDURE p_0() BEGIN END;
289 ERROR HY000: Lost connection to MySQL server during query
290 # restart
291 include/gtid_step_assert.inc [count=1, only_count=0]
292 include/gtid_step_reset.inc
293 FLUSH LOGS;
294 *** Crash right after 'ALTER PROCEDURE p_0 COMMENT 'comment'' has been prepared in the engine before being logged ***
295 SET @@SESSION.debug="+d,crash_commit_before_log";
296 ALTER PROCEDURE p_0 COMMENT 'comment';
297 ERROR HY000: Lost connection to MySQL server during query
298 # restart
299 include/gtid_step_assert.inc [count=0, only_count=0]
300 FLUSH LOGS;
301 *** Crash right after 'ALTER PROCEDURE p_0 COMMENT 'comment'' has been binary-logged before committed in the engine ***
302 SET @@SESSION.debug="+d,crash_commit_after_log";
303 ALTER PROCEDURE p_0 COMMENT 'comment';
304 ERROR HY000: Lost connection to MySQL server during query
305 # restart
306 include/gtid_step_assert.inc [count=1, only_count=0]
307 include/gtid_step_reset.inc
308 FLUSH LOGS;
309 *** Crash right after 'DROP PROCEDURE p_0' has been prepared in the engine before being logged ***
310 SET @@SESSION.debug="+d,crash_commit_before_log";
311 DROP PROCEDURE p_0;
312 ERROR HY000: Lost connection to MySQL server during query
313 # restart
314 include/gtid_step_assert.inc [count=0, only_count=0]
315 FLUSH LOGS;
316 *** Crash right after 'DROP PROCEDURE p_0' has been binary-logged before committed in the engine ***
317 SET @@SESSION.debug="+d,crash_commit_after_log";
318 DROP PROCEDURE p_0;
319 ERROR HY000: Lost connection to MySQL server during query
320 # restart
321 include/gtid_step_assert.inc [count=1, only_count=0]
322 include/gtid_step_reset.inc
323 FLUSH LOGS;
324 *** Crash right after 'CREATE EVENT e_0 ON SCHEDULE EVERY 2 DAY DO SELECT 2' has been prepared in the engine before being logged ***
325 SET @@SESSION.debug="+d,crash_commit_before_log";
326 CREATE EVENT e_0 ON SCHEDULE EVERY 2 DAY DO SELECT 2;
327 ERROR HY000: Lost connection to MySQL server during query
328 # restart
329 include/gtid_step_assert.inc [count=0, only_count=0]
330 FLUSH LOGS;
331 *** Crash right after 'CREATE EVENT e_0 ON SCHEDULE EVERY 2 DAY DO SELECT 2' has been binary-logged before committed in the engine ***
332 SET @@SESSION.debug="+d,crash_commit_after_log";
333 CREATE EVENT e_0 ON SCHEDULE EVERY 2 DAY DO SELECT 2;
334 ERROR HY000: Lost connection to MySQL server during query
335 # restart
336 include/gtid_step_assert.inc [count=1, only_count=0]
337 include/gtid_step_reset.inc
338 FLUSH LOGS;
339 *** Crash right after 'ALTER EVENT e_0 ON SCHEDULE EVERY 2 day DO SELECT 1;' has been prepared in the engine before being logged ***
340 SET @@SESSION.debug="+d,crash_commit_before_log";
341 ALTER EVENT e_0 ON SCHEDULE EVERY 2 day DO SELECT 1;;
342 ERROR HY000: Lost connection to MySQL server during query
343 # restart
344 include/gtid_step_assert.inc [count=0, only_count=0]
345 FLUSH LOGS;
346 *** Crash right after 'ALTER EVENT e_0 ON SCHEDULE EVERY 2 day DO SELECT 1;' has been binary-logged before committed in the engine ***
347 SET @@SESSION.debug="+d,crash_commit_after_log";
348 ALTER EVENT e_0 ON SCHEDULE EVERY 2 day DO SELECT 1;;
349 ERROR HY000: Lost connection to MySQL server during query
350 # restart
351 include/gtid_step_assert.inc [count=1, only_count=0]
352 include/gtid_step_reset.inc
353 FLUSH LOGS;
354 *** Crash right after 'DROP EVENT e_0' has been prepared in the engine before being logged ***
355 SET @@SESSION.debug="+d,crash_commit_before_log";
356 DROP EVENT e_0;
357 ERROR HY000: Lost connection to MySQL server during query
358 # restart
359 include/gtid_step_assert.inc [count=0, only_count=0]
360 FLUSH LOGS;
361 *** Crash right after 'DROP EVENT e_0' has been binary-logged before committed in the engine ***
362 SET @@SESSION.debug="+d,crash_commit_after_log";
363 DROP EVENT e_0;
364 ERROR HY000: Lost connection to MySQL server during query
365 # restart
366 include/gtid_step_assert.inc [count=1, only_count=0]
367 include/gtid_step_reset.inc
368 FLUSH LOGS;
369 *** Crash right after 'CREATE VIEW v_0 AS SELECT * FROM t_1' has been prepared in the engine before being logged ***
370 SET @@SESSION.debug="+d,crash_commit_before_log";
371 CREATE VIEW v_0 AS SELECT * FROM t_1;
372 ERROR HY000: Lost connection to MySQL server during query
373 # restart
374 include/gtid_step_assert.inc [count=0, only_count=0]
375 FLUSH LOGS;
376 *** Crash right after 'CREATE VIEW v_0 AS SELECT * FROM t_1' has been binary-logged before committed in the engine ***
377 SET @@SESSION.debug="+d,crash_commit_after_log";
378 CREATE VIEW v_0 AS SELECT * FROM t_1;
379 ERROR HY000: Lost connection to MySQL server during query
380 # restart
381 include/gtid_step_assert.inc [count=1, only_count=0]
382 include/gtid_step_reset.inc
383 FLUSH LOGS;
384 *** Crash right after 'ALTER VIEW v_0 AS SELECT * FROM t_1' has been prepared in the engine before being logged ***
385 SET @@SESSION.debug="+d,crash_commit_before_log";
386 ALTER VIEW v_0 AS SELECT * FROM t_1;
387 ERROR HY000: Lost connection to MySQL server during query
388 # restart
389 include/gtid_step_assert.inc [count=0, only_count=0]
390 FLUSH LOGS;
391 *** Crash right after 'ALTER VIEW v_0 AS SELECT * FROM t_1' has been binary-logged before committed in the engine ***
392 SET @@SESSION.debug="+d,crash_commit_after_log";
393 ALTER VIEW v_0 AS SELECT * FROM t_1;
394 ERROR HY000: Lost connection to MySQL server during query
395 # restart
396 include/gtid_step_assert.inc [count=1, only_count=0]
397 include/gtid_step_reset.inc
398 FLUSH LOGS;
399 *** Crash right after 'DROP VIEW v_0' has been prepared in the engine before being logged ***
400 SET @@SESSION.debug="+d,crash_commit_before_log";
401 DROP VIEW v_0;
402 ERROR HY000: Lost connection to MySQL server during query
403 # restart
404 include/gtid_step_assert.inc [count=0, only_count=0]
405 FLUSH LOGS;
406 *** Crash right after 'DROP VIEW v_0' has been binary-logged before committed in the engine ***
407 SET @@SESSION.debug="+d,crash_commit_after_log";
408 DROP VIEW v_0;
409 ERROR HY000: Lost connection to MySQL server during query
410 # restart
411 include/gtid_step_assert.inc [count=1, only_count=0]
412 include/gtid_step_reset.inc
413 FLUSH LOGS;
414 *** Crash right after 'CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example_LIB'' has been prepared in the engine before being logged ***
415 SET @@SESSION.debug="+d,crash_commit_before_log";
416 CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example_LIB';
417 ERROR HY000: Lost connection to MySQL server during query
418 # restart
419 include/gtid_step_assert.inc [count=0, only_count=0]
420 FLUSH LOGS;
421 *** Crash right after 'CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example_LIB'' has been binary-logged before committed in the engine ***
422 SET @@SESSION.debug="+d,crash_commit_after_log";
423 CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example_LIB';
424 ERROR HY000: Lost connection to MySQL server during query
425 # restart
426 include/gtid_step_assert.inc [count=1, only_count=0]
427 include/gtid_step_reset.inc
428 FLUSH LOGS;
429 *** Crash right after 'DROP FUNCTION metaphon;' has been prepared in the engine before being logged ***
430 SET @@SESSION.debug="+d,crash_commit_before_log";
431 DROP FUNCTION metaphon;;
432 ERROR HY000: Lost connection to MySQL server during query
433 # restart
434 include/gtid_step_assert.inc [count=0, only_count=0]
435 FLUSH LOGS;
436 *** Crash right after 'DROP FUNCTION metaphon;' has been binary-logged before committed in the engine ***
437 SET @@SESSION.debug="+d,crash_commit_after_log";
438 DROP FUNCTION metaphon;;
439 ERROR HY000: Lost connection to MySQL server during query
440 # restart
441 include/gtid_step_assert.inc [count=1, only_count=0]
442 include/gtid_step_reset.inc
443 FLUSH LOGS;
444 *** Crash right after 'CREATE TABLE test.t1(a int)' has been prepared in the engine before being logged ***
445 SET @@SESSION.debug="+d,crash_commit_before_log";
446 CREATE TABLE test.t1(a int);
447 ERROR HY000: Lost connection to MySQL server during query
448 # restart
449 include/gtid_step_assert.inc [count=0, only_count=0]
450 FLUSH LOGS;
451 *** Crash right after 'CREATE TABLE test.t1(a int)' has been binary-logged before committed in the engine ***
452 SET @@SESSION.debug="+d,crash_commit_after_log";
453 CREATE TABLE test.t1(a int);
454 ERROR HY000: Lost connection to MySQL server during query
455 # restart
456 include/gtid_step_assert.inc [count=1, only_count=0]
457 include/gtid_step_reset.inc
458 FLUSH LOGS;
459 *** Crash right after 'ALTER TABLE test.t1 ADD COLUMN t1_new_col varchar(100);' has been prepared in the engine before being logged ***
460 SET @@SESSION.debug="+d,crash_commit_before_log";
461 ALTER TABLE test.t1 ADD COLUMN t1_new_col varchar(100);;
462 ERROR HY000: Lost connection to MySQL server during query
463 # restart
464 include/gtid_step_assert.inc [count=0, only_count=0]
465 FLUSH LOGS;
466 *** Crash right after 'ALTER TABLE test.t1 ADD COLUMN t1_new_col varchar(100);' has been binary-logged before committed in the engine ***
467 SET @@SESSION.debug="+d,crash_commit_after_log";
468 ALTER TABLE test.t1 ADD COLUMN t1_new_col varchar(100);;
469 ERROR HY000: Lost connection to MySQL server during query
470 # restart
471 include/gtid_step_assert.inc [count=1, only_count=0]
472 include/gtid_step_reset.inc
473 FLUSH LOGS;
474 *** Crash right after 'ALTER TABLE test.t1 ADD index new_t1_idx(t1_new_col);' has been prepared in the engine before being logged ***
475 SET @@SESSION.debug="+d,crash_commit_before_log";
476 ALTER TABLE test.t1 ADD index new_t1_idx(t1_new_col);;
477 ERROR HY000: Lost connection to MySQL server during query
478 # restart
479 include/gtid_step_assert.inc [count=0, only_count=0]
480 FLUSH LOGS;
481 *** Crash right after 'ALTER TABLE test.t1 ADD index new_t1_idx(t1_new_col);' has been binary-logged before committed in the engine ***
482 SET @@SESSION.debug="+d,crash_commit_after_log";
483 ALTER TABLE test.t1 ADD index new_t1_idx(t1_new_col);;
484 ERROR HY000: Lost connection to MySQL server during query
485 # restart
486 include/gtid_step_assert.inc [count=1, only_count=0]
487 include/gtid_step_reset.inc
488 FLUSH LOGS;
489 *** Crash right after 'ALTER TABLE test.t1 RENAME TO test.t2' has been prepared in the engine before being logged ***
490 SET @@SESSION.debug="+d,crash_commit_before_log";
491 ALTER TABLE test.t1 RENAME TO test.t2;
492 ERROR HY000: Lost connection to MySQL server during query
493 # restart
494 include/gtid_step_assert.inc [count=0, only_count=0]
495 FLUSH LOGS;
496 *** Crash right after 'ALTER TABLE test.t1 RENAME TO test.t2' has been binary-logged before committed in the engine ***
497 SET @@SESSION.debug="+d,crash_commit_after_log";
498 ALTER TABLE test.t1 RENAME TO test.t2;
499 ERROR HY000: Lost connection to MySQL server during query
500 # restart
501 include/gtid_step_assert.inc [count=1, only_count=0]
502 include/gtid_step_reset.inc
503 FLUSH LOGS;
504 *** Crash right after 'ALTER TABLE test.t2 DROP COLUMN a;' has been prepared in the engine before being logged ***
505 SET @@SESSION.debug="+d,crash_commit_before_log";
506 ALTER TABLE test.t2 DROP COLUMN a;;
507 ERROR HY000: Lost connection to MySQL server during query
508 # restart
509 include/gtid_step_assert.inc [count=0, only_count=0]
510 FLUSH LOGS;
511 *** Crash right after 'ALTER TABLE test.t2 DROP COLUMN a;' has been binary-logged before committed in the engine ***
512 SET @@SESSION.debug="+d,crash_commit_after_log";
513 ALTER TABLE test.t2 DROP COLUMN a;;
514 ERROR HY000: Lost connection to MySQL server during query
515 # restart
516 include/gtid_step_assert.inc [count=1, only_count=0]
517 include/gtid_step_reset.inc
518 FLUSH LOGS;
519 *** Crash right after 'TRUNCATE TABLE test.t2' has been prepared in the engine before being logged ***
520 SET @@SESSION.debug="+d,crash_commit_before_log";
521 TRUNCATE TABLE test.t2;
522 ERROR HY000: Lost connection to MySQL server during query
523 # restart
524 include/gtid_step_assert.inc [count=0, only_count=0]
525 FLUSH LOGS;
526 *** Crash right after 'TRUNCATE TABLE test.t2' has been binary-logged before committed in the engine ***
527 SET @@SESSION.debug="+d,crash_commit_after_log";
528 TRUNCATE TABLE test.t2;
529 ERROR HY000: Lost connection to MySQL server during query
530 # restart
531 include/gtid_step_assert.inc [count=1, only_count=0]
532 include/gtid_step_reset.inc
533 FLUSH LOGS;
534 *** Crash right after 'ALTER TABLE test.t2 ADD fulltext index full_t2_idx(t1_new_col);' has been prepared in the engine before being logged ***
535 SET @@SESSION.debug="+d,crash_commit_before_log";
536 ALTER TABLE test.t2 ADD fulltext index full_t2_idx(t1_new_col);;
537 ERROR HY000: Lost connection to MySQL server during query
538 # restart
539 include/gtid_step_assert.inc [count=0, only_count=0]
540 FLUSH LOGS;
541 *** Crash right after 'ALTER TABLE test.t2 ADD fulltext index full_t2_idx(t1_new_col);' has been binary-logged before committed in the engine ***
542 SET @@SESSION.debug="+d,crash_commit_after_log";
543 ALTER TABLE test.t2 ADD fulltext index full_t2_idx(t1_new_col);;
544 ERROR HY000: Lost connection to MySQL server during query
545 # restart
546 include/gtid_step_assert.inc [count=1, only_count=0]
547 include/gtid_step_reset.inc
548 FLUSH LOGS;
549 *** Crash right after 'ALTER TABLE test.t2 DROP index full_t2_idx;' has been prepared in the engine before being logged ***
550 SET @@SESSION.debug="+d,crash_commit_before_log";
551 ALTER TABLE test.t2 DROP index full_t2_idx;;
552 ERROR HY000: Lost connection to MySQL server during query
553 # restart
554 include/gtid_step_assert.inc [count=0, only_count=0]
555 FLUSH LOGS;
556 *** Crash right after 'ALTER TABLE test.t2 DROP index full_t2_idx;' has been binary-logged before committed in the engine ***
557 SET @@SESSION.debug="+d,crash_commit_after_log";
558 ALTER TABLE test.t2 DROP index full_t2_idx;;
559 ERROR HY000: Lost connection to MySQL server during query
560 # restart
561 include/gtid_step_assert.inc [count=1, only_count=0]
562 include/gtid_step_reset.inc
563 FLUSH LOGS;
564 *** Crash right after 'DROP TABLE test.t2' has been prepared in the engine before being logged ***
565 SET @@SESSION.debug="+d,crash_commit_before_log";
566 DROP TABLE test.t2;
567 ERROR HY000: Lost connection to MySQL server during query
568 # restart
569 include/gtid_step_assert.inc [count=0, only_count=0]
570 FLUSH LOGS;
571 *** Crash right after 'DROP TABLE test.t2' has been binary-logged before committed in the engine ***
572 SET @@SESSION.debug="+d,crash_commit_after_log";
573 DROP TABLE test.t2;
574 ERROR HY000: Lost connection to MySQL server during query
575 # restart
576 include/gtid_step_assert.inc [count=1, only_count=0]
577 include/gtid_step_reset.inc
578 FLUSH LOGS;
579 *** Crash right after 'CREATE TABLESPACE ts ADD DATAFILE 'ts_0.ibd'' has been prepared in the engine before being logged ***
580 SET @@SESSION.debug="+d,crash_commit_before_log";
581 CREATE TABLESPACE ts ADD DATAFILE 'ts_0.ibd';
582 ERROR HY000: Lost connection to MySQL server during query
583 # restart
584 include/gtid_step_assert.inc [count=0, only_count=0]
585 FLUSH LOGS;
586 *** Crash right after 'CREATE TABLESPACE ts ADD DATAFILE 'ts_0.ibd'' has been binary-logged before committed in the engine ***
587 SET @@SESSION.debug="+d,crash_commit_after_log";
588 CREATE TABLESPACE ts ADD DATAFILE 'ts_0.ibd';
589 ERROR HY000: Lost connection to MySQL server during query
590 # restart
591 include/gtid_step_assert.inc [count=1, only_count=0]
592 include/gtid_step_reset.inc
593 FLUSH LOGS;
594 *** Crash right after 'DROP TABLESPACE ts' has been prepared in the engine before being logged ***
595 SET @@SESSION.debug="+d,crash_commit_before_log";
596 DROP TABLESPACE ts;
597 ERROR HY000: Lost connection to MySQL server during query
598 # restart
599 include/gtid_step_assert.inc [count=0, only_count=0]
600 FLUSH LOGS;
601 *** Crash right after 'DROP TABLESPACE ts' has been binary-logged before committed in the engine ***
602 SET @@SESSION.debug="+d,crash_commit_after_log";
603 DROP TABLESPACE ts;
604 ERROR HY000: Lost connection to MySQL server during query
605 # restart
606 include/gtid_step_assert.inc [count=1, only_count=0]
607 include/gtid_step_reset.inc
608 FLUSH LOGS;
609 *** Crash right after 'CREATE TABLE test.t1(a int)' has been prepared in the engine before being logged ***
610 SET @@SESSION.debug="+d,crash_commit_before_log";
611 CREATE TABLE test.t1(a int);
612 ERROR HY000: Lost connection to MySQL server during query
613 # restart
614 include/gtid_step_assert.inc [count=0, only_count=0]
615 FLUSH LOGS;
616 *** Crash right after 'CREATE TABLE test.t1(a int)' has been binary-logged before committed in the engine ***
617 SET @@SESSION.debug="+d,crash_commit_after_log";
618 CREATE TABLE test.t1(a int);
619 ERROR HY000: Lost connection to MySQL server during query
620 # restart
621 include/gtid_step_assert.inc [count=1, only_count=0]
622 include/gtid_step_reset.inc
623 FLUSH LOGS;
624 *** Crash right after 'CREATE TABLE test.t2 AS SELECT * FROM t1;' has been prepared in the engine before being logged ***
625 SET @@SESSION.debug="+d,crash_commit_before_log";
626 CREATE TABLE test.t2 AS SELECT * FROM t1;;
627 ERROR HY000: Lost connection to MySQL server during query
628 # restart
629 include/gtid_step_assert.inc [count=0, only_count=0]
630 FLUSH LOGS;
631 *** Crash right after 'CREATE TABLE test.t2 AS SELECT * FROM t1;' has been binary-logged before committed in the engine ***
632 SET @@SESSION.debug="+d,crash_commit_after_log";
633 CREATE TABLE test.t2 AS SELECT * FROM t1;;
634 ERROR HY000: Lost connection to MySQL server during query
635 # restart
636 include/gtid_step_assert.inc [count=1, only_count=0]
637 include/gtid_step_reset.inc
638 FLUSH LOGS;
639 *** Crash right after 'DROP TABLE test.t1' has been prepared in the engine before being logged ***
640 SET @@SESSION.debug="+d,crash_commit_before_log";
641 DROP TABLE test.t1;
642 ERROR HY000: Lost connection to MySQL server during query
643 # restart
644 include/gtid_step_assert.inc [count=0, only_count=0]
645 FLUSH LOGS;
646 *** Crash right after 'DROP TABLE test.t1' has been binary-logged before committed in the engine ***
647 SET @@SESSION.debug="+d,crash_commit_after_log";
648 DROP TABLE test.t1;
649 ERROR HY000: Lost connection to MySQL server during query
650 # restart
651 include/gtid_step_assert.inc [count=1, only_count=0]
652 include/gtid_step_reset.inc
653 FLUSH LOGS;
654 *** Crash right after 'DROP TABLE test.t2' has been prepared in the engine before being logged ***
655 SET @@SESSION.debug="+d,crash_commit_before_log";
656 DROP TABLE test.t2;
657 ERROR HY000: Lost connection to MySQL server during query
658 # restart
659 include/gtid_step_assert.inc [count=0, only_count=0]
660 FLUSH LOGS;
661 *** Crash right after 'DROP TABLE test.t2' has been binary-logged before committed in the engine ***
662 SET @@SESSION.debug="+d,crash_commit_after_log";
663 DROP TABLE test.t2;
664 ERROR HY000: Lost connection to MySQL server during query
665 # restart
666 include/gtid_step_assert.inc [count=1, only_count=0]
667 RESET MASTER;
668 include/gtid_step_reset.inc
669 include/gtid_step_assert.inc [count=1, only_count=1]
670 include/gtid_step_reset.inc
671 FLUSH LOGS;
672 *** Crash right after 'DROP USER user1' has been prepared in the engine before being logged ***
673 SET @@SESSION.debug="+d,crash_commit_before_log";
674 DROP USER user1;
675 ERROR HY000: Lost connection to MySQL server during query
676 # restart
677 include/gtid_step_assert.inc [count=0, only_count=1]
678 FLUSH LOGS;
679 *** Crash right after 'DROP USER user1' has been binary-logged before committed in the engine ***
680 SET @@SESSION.debug="+d,crash_commit_after_log";
681 DROP USER user1;
682 ERROR HY000: Lost connection to MySQL server during query
683 # restart
684 include/gtid_step_assert.inc [count=1, only_count=1]
685 DROP TABLE t_1;
686 include/gtid_utils_end.inc