Debian Codegraph @

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

raw
1 call mtr.add_suppression("Can.t init tc log");
2 call mtr.add_suppression("Aborting");
3 RESET MASTER;
4 SET @@global.sync_binlog=1;
5 CREATE TABLE t (f INT) ENGINE=INNODB;
6 CREATE TABLE t2 (f INT) ENGINE=INNODB;
7 CREATE TABLE t4 (f INT) ENGINE=INNODB;
8 CREATE TABLE tm (f INT) ENGINE=Aria;
9 # Case A.
10 connect master1,localhost,root,,;
11 connect master2,localhost,root,,;
12 connect master3,localhost,root,,;
13 connect master4,localhost,root,,;
14 connection default;
15 INSERT INTO t VALUES (10);
16 INSERT INTO tm VALUES (10);
17 connection master1;
18 SET DEBUG_SYNC= "commit_before_get_LOCK_commit_ordered SIGNAL master1_ready WAIT_FOR signal_never_arrives";
19 INSERT INTO t VALUES (20);
20 connection master2;
21 SET DEBUG_SYNC= "now WAIT_FOR master1_ready";
22 SET DEBUG_SYNC= "commit_before_get_LOCK_after_binlog_sync SIGNAL master2_ready";
23 DELETE FROM t2 WHERE f = 0 /* no such record */;
24 connection master3;
25 SET DEBUG_SYNC= "now WAIT_FOR master2_ready";
26 SELECT @@global.gtid_binlog_pos as 'Before the crash';
27 Before the crash
28 0-1-8
29 connection master4;
30 SET DEBUG_SYNC= "ha_commit_trans_before_log_and_order SIGNAL master4_ready WAIT_FOR signal_never_arrives";
31 INSERT INTO t4 VALUES (13);
32 connection master3;
33 SET DEBUG_SYNC= "now WAIT_FOR master4_ready";
34 SELECT @@global.gtid_binlog_pos as 'Before the crash and never logged trx';
35 Before the crash and never logged trx
36 0-1-8
37 connection default;
38 # Kill the server
39 disconnect master1;
40 disconnect master2;
41 disconnect master3;
42 disconnect master4;
43 # restart: --init-rpl-role=SLAVE --sync-binlog=1 --log-warnings=3
44 FOUND 1 /Successfully truncated.*to remove transactions starting from GTID 0-1-7/ in mysqld.1.err
45 Pre-crash binlog file content:
46 include/show_binlog_events.inc
47 Log_name Pos Event_type Server_id End_log_pos Info
48 master-bin.000001 # Gtid # # GTID #-#-#
49 master-bin.000001 # Query # # use `test`; CREATE TABLE t (f INT) ENGINE=INNODB
50 master-bin.000001 # Gtid # # GTID #-#-#
51 master-bin.000001 # Query # # use `test`; CREATE TABLE t2 (f INT) ENGINE=INNODB
52 master-bin.000001 # Gtid # # GTID #-#-#
53 master-bin.000001 # Query # # use `test`; CREATE TABLE t4 (f INT) ENGINE=INNODB
54 master-bin.000001 # Gtid # # GTID #-#-#
55 master-bin.000001 # Query # # use `test`; CREATE TABLE tm (f INT) ENGINE=Aria
56 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
57 master-bin.000001 # Query # # use `test`; INSERT INTO t VALUES (10)
58 master-bin.000001 # Xid # # COMMIT /* XID */
59 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
60 master-bin.000001 # Query # # use `test`; INSERT INTO tm VALUES (10)
61 master-bin.000001 # Query # # COMMIT
62 SELECT @@global.gtid_binlog_pos as 'After the crash';
63 After the crash
64 0-1-6
65 "One row should be present in table 't'"
66 SELECT * FROM t;
67 f
68 10
69 "No row should be present in table 't4'"
70 SELECT * FROM t4;
71 f
72 DELETE FROM t;
73 # Case B.
74 connect master1,localhost,root,,;
75 connect master2,localhost,root,,;
76 connect master3,localhost,root,,;
77 connect master4,localhost,root,,;
78 connection default;
79 INSERT INTO t VALUES (10);
80 INSERT INTO tm VALUES (10);
81 connection master1;
82 SET DEBUG_SYNC= "commit_before_get_LOCK_commit_ordered SIGNAL master1_ready WAIT_FOR signal_never_arrives";
83 DELETE FROM t2 WHERE f = 0;
84 connection master2;
85 SET DEBUG_SYNC= "now WAIT_FOR master1_ready";
86 SET DEBUG_SYNC= "commit_before_get_LOCK_after_binlog_sync SIGNAL master2_ready";
87 INSERT INTO t VALUES (20);
88 connection master3;
89 SET DEBUG_SYNC= "now WAIT_FOR master2_ready";
90 SELECT @@global.gtid_binlog_pos as 'Before the crash';
91 Before the crash
92 0-1-11
93 connection master4;
94 SET DEBUG_SYNC= "ha_commit_trans_before_log_and_order SIGNAL master4_ready WAIT_FOR signal_never_arrives";
95 INSERT INTO t4 VALUES (13);
96 connection master3;
97 SET DEBUG_SYNC= "now WAIT_FOR master4_ready";
98 SELECT @@global.gtid_binlog_pos as 'Before the crash and never logged trx';
99 Before the crash and never logged trx
100 0-1-11
101 connection default;
102 # Kill the server
103 disconnect master1;
104 disconnect master2;
105 disconnect master3;
106 disconnect master4;
107 # restart: --init-rpl-role=SLAVE --sync-binlog=1 --log-warnings=3
108 FOUND 1 /Successfully truncated.*to remove transactions starting from GTID 0-1-11/ in mysqld.1.err
109 Pre-crash binlog file content:
110 include/show_binlog_events.inc
111 Log_name Pos Event_type Server_id End_log_pos Info
112 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
113 master-bin.000002 # Query # # use `test`; DELETE FROM t
114 master-bin.000002 # Xid # # COMMIT /* XID */
115 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
116 master-bin.000002 # Query # # use `test`; INSERT INTO t VALUES (10)
117 master-bin.000002 # Xid # # COMMIT /* XID */
118 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
119 master-bin.000002 # Query # # use `test`; INSERT INTO tm VALUES (10)
120 master-bin.000002 # Query # # COMMIT
121 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
122 master-bin.000002 # Query # # use `test`; DELETE FROM t2 WHERE f = 0
123 master-bin.000002 # Query # # COMMIT
124 SELECT @@global.gtid_binlog_pos as 'After the crash';
125 After the crash
126 0-1-10
127 "One row should be present in table 't'"
128 SELECT * FROM t;
129 f
130 10
131 "No row should be present in table 't4'"
132 SELECT * FROM t4;
133 f
134 DELETE FROM t;
135 # Case C.
136 CREATE PROCEDURE sp_blank_xa()
137 BEGIN
138 XA START 'blank';
139 DELETE FROM t2 WHERE f = 0 /* no such record */;
140 XA END 'blank';
141 XA PREPARE 'blank';
142 END|
143 connect master1,localhost,root,,;
144 connect master2,localhost,root,,;
145 connect master3,localhost,root,,;
146 connect master4,localhost,root,,;
147 connection default;
148 INSERT INTO t VALUES (10);
149 INSERT INTO tm VALUES (10);
150 connection master1;
151 SET DEBUG_SYNC= "commit_before_get_LOCK_commit_ordered SIGNAL master1_ready WAIT_FOR signal_never_arrives";
152 INSERT INTO t VALUES (20);
153 connection master2;
154 SET DEBUG_SYNC= "now WAIT_FOR master1_ready";
155 SET DEBUG_SYNC= "commit_before_get_LOCK_after_binlog_sync SIGNAL master2_ready";
156 CALL sp_blank_xa;
157 connection master3;
158 SET DEBUG_SYNC= "now WAIT_FOR master2_ready";
159 SELECT @@global.gtid_binlog_pos as 'Before the crash';
160 Before the crash
161 0-1-16
162 connection master4;
163 SET DEBUG_SYNC= "ha_commit_trans_before_log_and_order SIGNAL master4_ready WAIT_FOR signal_never_arrives";
164 INSERT INTO t4 VALUES (13);
165 connection master3;
166 SET DEBUG_SYNC= "now WAIT_FOR master4_ready";
167 SELECT @@global.gtid_binlog_pos as 'Before the crash and never logged trx';
168 Before the crash and never logged trx
169 0-1-16
170 connection default;
171 # Kill the server
172 disconnect master1;
173 disconnect master2;
174 disconnect master3;
175 disconnect master4;
176 # restart: --init-rpl-role=SLAVE --sync-binlog=1 --log-warnings=3
177 FOUND 1 /Successfully truncated.*to remove transactions starting from GTID 0-1-15/ in mysqld.1.err
178 Pre-crash binlog file content:
179 include/show_binlog_events.inc
180 Log_name Pos Event_type Server_id End_log_pos Info
181 master-bin.000003 # Gtid # # BEGIN GTID #-#-#
182 master-bin.000003 # Query # # use `test`; DELETE FROM t
183 master-bin.000003 # Xid # # COMMIT /* XID */
184 master-bin.000003 # Gtid # # GTID #-#-#
185 master-bin.000003 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_blank_xa`()
186 BEGIN
187 XA START 'blank';
188 DELETE FROM t2 WHERE f = 0 /* no such record */;
189 XA END 'blank';
190 XA PREPARE 'blank';
191 END
192 master-bin.000003 # Gtid # # BEGIN GTID #-#-#
193 master-bin.000003 # Query # # use `test`; INSERT INTO t VALUES (10)
194 master-bin.000003 # Xid # # COMMIT /* XID */
195 master-bin.000003 # Gtid # # BEGIN GTID #-#-#
196 master-bin.000003 # Query # # use `test`; INSERT INTO tm VALUES (10)
197 master-bin.000003 # Query # # COMMIT
198 SELECT @@global.gtid_binlog_pos as 'After the crash';
199 After the crash
200 0-1-14
201 "One row should be present in table 't'"
202 SELECT * FROM t;
203 f
204 10
205 "No row should be present in table 't4'"
206 SELECT * FROM t4;
207 f
208 DELETE FROM t;
209 DROP PROCEDURE sp_blank_xa;
210 # Case D.
211 CREATE PROCEDURE sp_xa()
212 BEGIN
213 XA START 'xid';
214 DELETE FROM t WHERE f = 10;
215 XA END 'xid';
216 XA PREPARE 'xid';
217 END|
218 connect master1,localhost,root,,;
219 connect master2,localhost,root,,;
220 connect master3,localhost,root,,;
221 connect master4,localhost,root,,;
222 connection default;
223 INSERT INTO t VALUES (10);
224 INSERT INTO tm VALUES (10);
225 connection master1;
226 SET DEBUG_SYNC= "commit_before_get_LOCK_commit_ordered SIGNAL master1_ready WAIT_FOR signal_never_arrives";
227 CALL sp_xa;
228 connection master2;
229 SET DEBUG_SYNC= "now WAIT_FOR master1_ready";
230 SET DEBUG_SYNC= "commit_before_get_LOCK_after_binlog_sync SIGNAL master2_ready";
231 INSERT INTO t2 VALUES (20);
232 connection master3;
233 SET DEBUG_SYNC= "now WAIT_FOR master2_ready";
234 SELECT @@global.gtid_binlog_pos as 'Before the crash';
235 Before the crash
236 0-1-21
237 connection master4;
238 SET DEBUG_SYNC= "ha_commit_trans_before_log_and_order SIGNAL master4_ready WAIT_FOR signal_never_arrives";
239 INSERT INTO t4 VALUES (13);
240 connection master3;
241 SET DEBUG_SYNC= "now WAIT_FOR master4_ready";
242 SELECT @@global.gtid_binlog_pos as 'Before the crash and never logged trx';
243 Before the crash and never logged trx
244 0-1-21
245 connection default;
246 # Kill the server
247 disconnect master1;
248 disconnect master2;
249 disconnect master3;
250 disconnect master4;
251 # restart: --init-rpl-role=SLAVE --sync-binlog=1 --log-warnings=3
252 FOUND 1 /Successfully truncated.*to remove transactions starting from GTID 0-1-21/ in mysqld.1.err
253 Pre-crash binlog file content:
254 include/show_binlog_events.inc
255 Log_name Pos Event_type Server_id End_log_pos Info
256 master-bin.000004 # Gtid # # BEGIN GTID #-#-#
257 master-bin.000004 # Query # # use `test`; DELETE FROM t
258 master-bin.000004 # Xid # # COMMIT /* XID */
259 master-bin.000004 # Gtid # # GTID #-#-#
260 master-bin.000004 # Query # # use `test`; DROP PROCEDURE sp_blank_xa
261 master-bin.000004 # Gtid # # GTID #-#-#
262 master-bin.000004 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_xa`()
263 BEGIN
264 XA START 'xid';
265 DELETE FROM t WHERE f = 10;
266 XA END 'xid';
267 XA PREPARE 'xid';
268 END
269 master-bin.000004 # Gtid # # BEGIN GTID #-#-#
270 master-bin.000004 # Query # # use `test`; INSERT INTO t VALUES (10)
271 master-bin.000004 # Xid # # COMMIT /* XID */
272 master-bin.000004 # Gtid # # BEGIN GTID #-#-#
273 master-bin.000004 # Query # # use `test`; INSERT INTO tm VALUES (10)
274 master-bin.000004 # Query # # COMMIT
275 master-bin.000004 # Gtid # # XA START X'786964',X'',1 GTID #-#-#
276 master-bin.000004 # Query # # use `test`; DELETE FROM t WHERE f = 10
277 master-bin.000004 # Query # # XA END X'786964',X'',1
278 master-bin.000004 # XA_prepare # # XA PREPARE X'786964',X'',1
279 SELECT @@global.gtid_binlog_pos as 'After the crash';
280 After the crash
281 0-1-20
282 "One row should be present in table 't'"
283 SELECT * FROM t;
284 f
285 10
286 "No row should be present in table 't4'"
287 SELECT * FROM t4;
288 f
289 DELETE FROM t;
290 DROP PROCEDURE sp_xa;
291 # Cleanup
292 DROP TABLE t,t2,tm;
293 SET @@global.sync_binlog= default;
294 # End of the tests