Debian Codegraph @

mysql-test/suite/maria/rollback.result

raw
1 reset master;
2 call mtr.add_suppression("Table was marked as crashed");
3 call mtr.add_suppression("Checking table: .*");
4 create table t1 (a int primary key auto_increment, b int) engine=aria transactional= 1;
5 create table t2 (a int primary key auto_increment, b int) engine=aria transactional= 0;
6 create sequence s1 cache=2 engine=aria;
7 insert into t1 (b) values (1),(2),(3),(4);
8 insert into t2 (b) values (1),(2),(3),(4);
9 select NEXT VALUE for s1,seq from seq_1_to_4;
10 NEXT VALUE for s1 seq
11 1 1
12 2 2
13 3 3
14 4 4
15 begin;
16 insert into t1 (b) values (5),(6);
17 insert into t1 (b) values (7),(8);
18 insert into t2 (b) values (5),(6);
19 insert into t2 (b) values (7),(8);
20 commit;
21 begin;
22 insert into t1 (b) values (10),(11),(12);
23 update t1 set b=100 where a=2;
24 delete from t1 where a between 3 and 4;
25 insert into t2 (b) values (10),(11),(12);
26 update t2 set b=100 where a=2;
27 delete from t2 where a between 3 and 4;
28 select NEXT VALUE for s1,seq from seq_1_to_4;
29 NEXT VALUE for s1 seq
30 5 1
31 6 2
32 7 3
33 8 4
34 # Kill and restart
35 select * from t1 order by a;
36 a b
37 1 1
38 2 100
39 5 5
40 6 6
41 7 7
42 8 8
43 9 10
44 10 11
45 11 12
46 select * from t2 order by a;
47 a b
48 1 1
49 2 100
50 5 5
51 6 6
52 7 7
53 8 8
54 9 10
55 10 11
56 11 12
57 Warnings:
58 Error 145 Got error '145 "Table was marked as crashed and should be repaired"' for './test/t2'
59 Warning 1034 1 client is using or hasn't closed the table properly
60 Note 1034 Table is fixed
61 insert into t1 (b) values (100),(200);
62 insert into t2 (b) values (100),(200);
63 select * from t1 order by a;
64 a b
65 1 1
66 2 100
67 5 5
68 6 6
69 7 7
70 8 8
71 9 10
72 10 11
73 11 12
74 12 100
75 13 200
76 select * from t2 order by a;
77 a b
78 1 1
79 2 100
80 5 5
81 6 6
82 7 7
83 8 8
84 9 10
85 10 11
86 11 12
87 12 100
88 13 200
89 select NEXT VALUE for s1,seq from seq_1_to_4;
90 NEXT VALUE for s1 seq
91 9 1
92 10 2
93 11 3
94 12 4
95 Warnings:
96 Error 145 Got error '145 "Table was marked as crashed and should be repaired"' for './test/s1'
97 Warning 1034 1 client is using or hasn't closed the table properly
98 Note 1034 Table is fixed
99 drop table t1,t2;
100 drop sequence s1;
101 include/show_binlog_events.inc
102 Log_name Pos Event_type Server_id End_log_pos Info
103 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
104 master-bin.000001 # Query # # use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_utf8mb4'Table was marked as crashed' COLLATE 'utf8mb4_uca1400_ai_ci'))
105 master-bin.000001 # Query # # COMMIT
106 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
107 master-bin.000001 # Query # # use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_utf8mb4'Checking table: .*' COLLATE 'utf8mb4_uca1400_ai_ci'))
108 master-bin.000001 # Query # # COMMIT
109 master-bin.000001 # Gtid # # GTID #-#-#
110 master-bin.000001 # Query # # use `test`; create table t1 (a int primary key auto_increment, b int) engine=aria transactional= 1
111 master-bin.000001 # Gtid # # GTID #-#-#
112 master-bin.000001 # Query # # use `test`; create table t2 (a int primary key auto_increment, b int) engine=aria transactional= 0
113 master-bin.000001 # Gtid # # GTID #-#-#
114 master-bin.000001 # Query # # use `test`; create sequence s1 cache=2 engine=aria
115 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
116 master-bin.000001 # Intvar # # INSERT_ID=1
117 master-bin.000001 # Query # # use `test`; insert into t1 (b) values (1),(2),(3),(4)
118 master-bin.000001 # Query # # COMMIT
119 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
120 master-bin.000001 # Intvar # # INSERT_ID=1
121 master-bin.000001 # Query # # use `test`; insert into t2 (b) values (1),(2),(3),(4)
122 master-bin.000001 # Query # # COMMIT
123 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
124 master-bin.000001 # Annotate_rows # # select NEXT VALUE for s1,seq from seq_1_to_4
125 master-bin.000001 # Table_map # # table_id: # (test.s1)
126 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
127 master-bin.000001 # Query # # COMMIT
128 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
129 master-bin.000001 # Intvar # # INSERT_ID=5
130 master-bin.000001 # Query # # use `test`; insert into t1 (b) values (5),(6)
131 master-bin.000001 # Query # # COMMIT
132 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
133 master-bin.000001 # Intvar # # INSERT_ID=7
134 master-bin.000001 # Query # # use `test`; insert into t1 (b) values (7),(8)
135 master-bin.000001 # Query # # COMMIT
136 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
137 master-bin.000001 # Intvar # # INSERT_ID=5
138 master-bin.000001 # Query # # use `test`; insert into t2 (b) values (5),(6)
139 master-bin.000001 # Query # # COMMIT
140 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
141 master-bin.000001 # Intvar # # INSERT_ID=7
142 master-bin.000001 # Query # # use `test`; insert into t2 (b) values (7),(8)
143 master-bin.000001 # Query # # COMMIT
144 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
145 master-bin.000001 # Intvar # # INSERT_ID=9
146 master-bin.000001 # Query # # use `test`; insert into t1 (b) values (10),(11),(12)
147 master-bin.000001 # Query # # COMMIT
148 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
149 master-bin.000001 # Query # # use `test`; update t1 set b=100 where a=2
150 master-bin.000001 # Query # # COMMIT
151 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
152 master-bin.000001 # Query # # use `test`; delete from t1 where a between 3 and 4
153 master-bin.000001 # Query # # COMMIT
154 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
155 master-bin.000001 # Intvar # # INSERT_ID=9
156 master-bin.000001 # Query # # use `test`; insert into t2 (b) values (10),(11),(12)
157 master-bin.000001 # Query # # COMMIT
158 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
159 master-bin.000001 # Query # # use `test`; update t2 set b=100 where a=2
160 master-bin.000001 # Query # # COMMIT
161 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
162 master-bin.000001 # Query # # use `test`; delete from t2 where a between 3 and 4
163 master-bin.000001 # Query # # COMMIT
164 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
165 master-bin.000001 # Annotate_rows # # select NEXT VALUE for s1,seq from seq_1_to_4
166 master-bin.000001 # Table_map # # table_id: # (test.s1)
167 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
168 master-bin.000001 # Query # # COMMIT
169 include/show_binlog_events.inc
170 Log_name Pos Event_type Server_id End_log_pos Info
171 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
172 master-bin.000002 # Intvar # # INSERT_ID=12
173 master-bin.000002 # Query # # use `test`; insert into t1 (b) values (100),(200)
174 master-bin.000002 # Query # # COMMIT
175 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
176 master-bin.000002 # Intvar # # INSERT_ID=12
177 master-bin.000002 # Query # # use `test`; insert into t2 (b) values (100),(200)
178 master-bin.000002 # Query # # COMMIT
179 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
180 master-bin.000002 # Annotate_rows # # select NEXT VALUE for s1,seq from seq_1_to_4
181 master-bin.000002 # Table_map # # table_id: # (test.s1)
182 master-bin.000002 # Write_rows_v1 # # table_id: # flags: STMT_END_F
183 master-bin.000002 # Query # # COMMIT
184 master-bin.000002 # Gtid # # GTID #-#-#
185 master-bin.000002 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */
186 master-bin.000002 # Gtid # # GTID #-#-#
187 master-bin.000002 # Query # # use `test`; DROP SEQUENCE `s1` /* generated by server */