Debian Codegraph @

mysql-test/suite/innodb/r/group_commit_crash_no_optimize_thread.result

raw
1 CREATE TABLE t1(a CHAR(255),
2 b CHAR(255),
3 c CHAR(255),
4 d CHAR(255),
5 id INT,
6 PRIMARY KEY(id)) ENGINE=InnoDB;
7 create table t2 like t1;
8 create procedure setcrash(IN i INT)
9 begin
10 CASE i
11 WHEN 1 THEN SET SESSION debug_dbug="d,crash_commit_after_prepare";
12 WHEN 2 THEN SET SESSION debug_dbug="d,crash_commit_after_log";
13 WHEN 3 THEN SET SESSION debug_dbug="d,crash_commit_before_unlog";
14 WHEN 4 THEN SET SESSION debug_dbug="d,crash_commit_after";
15 WHEN 5 THEN SET SESSION debug_dbug="d,crash_commit_before";
16 ELSE BEGIN END;
17 END CASE;
18 end //
19 FLUSH TABLES;
20 INSERT INTO t2(a, b, c, d, id) VALUES ('a', 'b', 'c', 'd', 1+9);
21 INSERT INTO t2(a, b, c, d, id) VALUES ('a', 'b', 'c', 'd', 1+8);
22 INSERT INTO t2(a, b, c, d, id) VALUES ('a', 'b', 'c', 'd', 1+7);
23 INSERT INTO t2(a, b, c, d, id) VALUES ('a', 'b', 'c', 'd', 1+6);
24 INSERT INTO t2(a, b, c, d, id) VALUES ('a', 'b', 'c', 'd', 1+5);
25 INSERT INTO t2(a, b, c, d, id) VALUES ('a', 'b', 'c', 'd', 1+4);
26 INSERT INTO t2(a, b, c, d, id) VALUES ('a', 'b', 'c', 'd', 1+3);
27 INSERT INTO t2(a, b, c, d, id) VALUES ('a', 'b', 'c', 'd', 1+2);
28 INSERT INTO t2(a, b, c, d, id) VALUES ('a', 'b', 'c', 'd', 1+1);
29 INSERT INTO t2(a, b, c, d, id) VALUES ('a', 'b', 'c', 'd', 1+0);
30 SET binlog_format= mixed;
31 RESET MASTER;
32 START TRANSACTION;
33 insert into t1 select * from t2;
34 call setcrash(5);
35 COMMIT;
36 Got one of the listed errors
37 SELECT * FROM t1 ORDER BY id;
38 a b c d id
39 SHOW BINLOG EVENTS LIMIT 4,1;
40 Log_name Pos Event_type Server_id End_log_pos Info
41 delete from t1;
42 SET binlog_format= mixed;
43 RESET MASTER;
44 START TRANSACTION;
45 insert into t1 select * from t2;
46 call setcrash(4);
47 COMMIT;
48 Got one of the listed errors
49 SELECT * FROM t1 ORDER BY id;
50 a b c d id
51 a b c d 1
52 a b c d 2
53 a b c d 3
54 a b c d 4
55 a b c d 5
56 a b c d 6
57 a b c d 7
58 a b c d 8
59 a b c d 9
60 a b c d 10
61 SHOW BINLOG EVENTS LIMIT 4,1;
62 Log_name Pos Event_type Server_id End_log_pos Info
63 master-bin.000001 # Query 1 # use `test`; insert into t1 select * from t2
64 delete from t1;
65 SET binlog_format= mixed;
66 RESET MASTER;
67 START TRANSACTION;
68 insert into t1 select * from t2;
69 call setcrash(3);
70 COMMIT;
71 Got one of the listed errors
72 SELECT * FROM t1 ORDER BY id;
73 a b c d id
74 a b c d 1
75 a b c d 2
76 a b c d 3
77 a b c d 4
78 a b c d 5
79 a b c d 6
80 a b c d 7
81 a b c d 8
82 a b c d 9
83 a b c d 10
84 SHOW BINLOG EVENTS LIMIT 4,1;
85 Log_name Pos Event_type Server_id End_log_pos Info
86 master-bin.000001 # Query 1 # use `test`; insert into t1 select * from t2
87 delete from t1;
88 SET binlog_format= mixed;
89 RESET MASTER;
90 START TRANSACTION;
91 insert into t1 select * from t2;
92 call setcrash(2);
93 COMMIT;
94 Got one of the listed errors
95 SELECT * FROM t1 ORDER BY id;
96 a b c d id
97 a b c d 1
98 a b c d 2
99 a b c d 3
100 a b c d 4
101 a b c d 5
102 a b c d 6
103 a b c d 7
104 a b c d 8
105 a b c d 9
106 a b c d 10
107 SHOW BINLOG EVENTS LIMIT 4,1;
108 Log_name Pos Event_type Server_id End_log_pos Info
109 master-bin.000001 # Query 1 # use `test`; insert into t1 select * from t2
110 delete from t1;
111 SET binlog_format= mixed;
112 RESET MASTER;
113 START TRANSACTION;
114 insert into t1 select * from t2;
115 call setcrash(1);
116 COMMIT;
117 Got one of the listed errors
118 SELECT * FROM t1 ORDER BY id;
119 a b c d id
120 SHOW BINLOG EVENTS LIMIT 4,1;
121 Log_name Pos Event_type Server_id End_log_pos Info
122 delete from t1;
123 DROP TABLE t1;
124 DROP TABLE t2;
125 DROP PROCEDURE setcrash;