Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_crash_safe.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 call mtr.add_suppression('Attempting backtrace');
7 call mtr.add_suppression("Recovery from source pos .* and file master-bin.000001");
8 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
9 call mtr.add_suppression("allocated tablespace .*, old maximum was .*");
10 ###################################################################################
11 # PREPARE EXECUTION
12 ###################################################################################
13 include/stop_slave.inc
14 SHOW CREATE TABLE mysql.slave_relay_log_info;
15 Table Create Table
16 slave_relay_log_info CREATE TABLE `slave_relay_log_info` (
17 `Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',
18 `Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the current relay log file.',
19 `Relay_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The relay log position of the last executed event.',
20 `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the master binary log file from which the events in the relay log file were read.',
21 `Master_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The master log position of the last executed event.',
22 `Sql_delay` int DEFAULT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',
23 `Number_of_workers` int unsigned DEFAULT NULL,
24 `Id` int unsigned DEFAULT NULL COMMENT 'Internal Id that uniquely identifies this record.',
25 `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
26 `Privilege_checks_username` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'Username part of PRIVILEGE_CHECKS_USER.',
27 `Privilege_checks_hostname` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'Hostname part of PRIVILEGE_CHECKS_USER.',
28 `Require_row_format` tinyint(1) NOT NULL COMMENT 'Indicates whether the channel shall only accept row based events.',
29 `Require_table_primary_key_check` enum('STREAM','ON','OFF','GENERATE') NOT NULL DEFAULT 'STREAM' COMMENT 'Indicates what is the channel policy regarding tables without primary keys on create and alter table queries',
30 `Assign_gtids_to_anonymous_transactions_type` enum('OFF','LOCAL','UUID') NOT NULL DEFAULT 'OFF' COMMENT 'Indicates whether the channel will generate a new GTID for anonymous transactions. OFF means that anonymous transactions will remain anonymous. LOCAL means that anonymous transactions will be assigned a newly generated GTID based on server_uuid. UUID indicates that anonymous transactions will be assigned a newly generated GTID based on Assign_gtids_to_anonymous_transactions_value',
31 `Assign_gtids_to_anonymous_transactions_value` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Indicates the UUID used while generating GTIDs for anonymous transactions',
32 PRIMARY KEY (`Channel_name`)
33 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Relay Log Information'
34 SHOW CREATE TABLE mysql.slave_worker_info;
35 Table Create Table
36 slave_worker_info CREATE TABLE `slave_worker_info` (
37 `Id` int unsigned NOT NULL,
38 `Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
39 `Relay_log_pos` bigint unsigned NOT NULL,
40 `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
41 `Master_log_pos` bigint unsigned NOT NULL,
42 `Checkpoint_relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
43 `Checkpoint_relay_log_pos` bigint unsigned NOT NULL,
44 `Checkpoint_master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
45 `Checkpoint_master_log_pos` bigint unsigned NOT NULL,
46 `Checkpoint_seqno` int unsigned NOT NULL,
47 `Checkpoint_group_size` int unsigned NOT NULL,
48 `Checkpoint_group_bitmap` blob NOT NULL,
49 `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
50 PRIMARY KEY (`Channel_name`,`Id`)
51 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Worker Information'
52 ALTER TABLE mysql.slave_relay_log_info ENGINE= Innodb;
53 ALTER TABLE mysql.slave_worker_info ENGINE= Innodb;
54 SHOW CREATE TABLE mysql.slave_relay_log_info;
55 Table Create Table
56 slave_relay_log_info CREATE TABLE `slave_relay_log_info` (
57 `Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',
58 `Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the current relay log file.',
59 `Relay_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The relay log position of the last executed event.',
60 `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the master binary log file from which the events in the relay log file were read.',
61 `Master_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The master log position of the last executed event.',
62 `Sql_delay` int DEFAULT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',
63 `Number_of_workers` int unsigned DEFAULT NULL,
64 `Id` int unsigned DEFAULT NULL COMMENT 'Internal Id that uniquely identifies this record.',
65 `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
66 `Privilege_checks_username` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'Username part of PRIVILEGE_CHECKS_USER.',
67 `Privilege_checks_hostname` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'Hostname part of PRIVILEGE_CHECKS_USER.',
68 `Require_row_format` tinyint(1) NOT NULL COMMENT 'Indicates whether the channel shall only accept row based events.',
69 `Require_table_primary_key_check` enum('STREAM','ON','OFF','GENERATE') NOT NULL DEFAULT 'STREAM' COMMENT 'Indicates what is the channel policy regarding tables without primary keys on create and alter table queries',
70 `Assign_gtids_to_anonymous_transactions_type` enum('OFF','LOCAL','UUID') NOT NULL DEFAULT 'OFF' COMMENT 'Indicates whether the channel will generate a new GTID for anonymous transactions. OFF means that anonymous transactions will remain anonymous. LOCAL means that anonymous transactions will be assigned a newly generated GTID based on server_uuid. UUID indicates that anonymous transactions will be assigned a newly generated GTID based on Assign_gtids_to_anonymous_transactions_value',
71 `Assign_gtids_to_anonymous_transactions_value` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Indicates the UUID used while generating GTIDs for anonymous transactions',
72 PRIMARY KEY (`Channel_name`)
73 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Relay Log Information'
74 SHOW CREATE TABLE mysql.slave_worker_info;
75 Table Create Table
76 slave_worker_info CREATE TABLE `slave_worker_info` (
77 `Id` int unsigned NOT NULL,
78 `Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
79 `Relay_log_pos` bigint unsigned NOT NULL,
80 `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
81 `Master_log_pos` bigint unsigned NOT NULL,
82 `Checkpoint_relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
83 `Checkpoint_relay_log_pos` bigint unsigned NOT NULL,
84 `Checkpoint_master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
85 `Checkpoint_master_log_pos` bigint unsigned NOT NULL,
86 `Checkpoint_seqno` int unsigned NOT NULL,
87 `Checkpoint_group_size` int unsigned NOT NULL,
88 `Checkpoint_group_bitmap` blob NOT NULL,
89 `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
90 PRIMARY KEY (`Channel_name`,`Id`)
91 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Worker Information'
92 include/start_slave.inc
93 rpl_mixing_engines.inc [commands=configure]
94 CREATE TABLE nt_1 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
95 CREATE TABLE nt_2 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
96 CREATE TABLE nt_3 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
97 CREATE TABLE nt_4 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
98 CREATE TABLE nt_5 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
99 CREATE TABLE nt_6 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
100 CREATE TABLE tt_1 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = Innodb;
101 CREATE TABLE tt_2 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = Innodb;
102 CREATE TABLE tt_3 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = Innodb;
103 CREATE TABLE tt_4 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = Innodb;
104 CREATE TABLE tt_5 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = Innodb;
105 CREATE TABLE tt_6 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = Innodb;
106 INSERT INTO nt_1(trans_id, stmt_id) VALUES(1,1);
107 INSERT INTO nt_2(trans_id, stmt_id) VALUES(1,1);
108 INSERT INTO nt_3(trans_id, stmt_id) VALUES(1,1);
109 INSERT INTO nt_4(trans_id, stmt_id) VALUES(1,1);
110 INSERT INTO nt_5(trans_id, stmt_id) VALUES(1,1);
111 INSERT INTO nt_6(trans_id, stmt_id) VALUES(1,1);
112 INSERT INTO tt_1(trans_id, stmt_id) VALUES(1,1);
113 INSERT INTO tt_2(trans_id, stmt_id) VALUES(1,1);
114 INSERT INTO tt_3(trans_id, stmt_id) VALUES(1,1);
115 INSERT INTO tt_4(trans_id, stmt_id) VALUES(1,1);
116 INSERT INTO tt_5(trans_id, stmt_id) VALUES(1,1);
117 INSERT INTO tt_6(trans_id, stmt_id) VALUES(1,1);
118 CREATE PROCEDURE pc_i_tt_5_suc (IN p_trans_id INTEGER, IN p_stmt_id INTEGER)
119 BEGIN
120 DECLARE in_stmt_id INTEGER;
121 SELECT max(stmt_id) INTO in_stmt_id FROM tt_5 WHERE trans_id= p_trans_id;
122 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
123 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
124 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
125 END|
126 CREATE PROCEDURE pc_i_nt_5_suc (IN p_trans_id INTEGER, IN p_stmt_id INTEGER)
127 BEGIN
128 DECLARE in_stmt_id INTEGER;
129 SELECT max(stmt_id) INTO in_stmt_id FROM nt_5 WHERE trans_id= p_trans_id;
130 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
131 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
132 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
133 END|
134 CREATE FUNCTION fc_i_tt_5_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
135 BEGIN
136 DECLARE in_stmt_id INTEGER;
137 SELECT max(stmt_id) INTO in_stmt_id FROM tt_5 WHERE trans_id= p_trans_id;
138 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
139 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
140 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
141 RETURN "fc_i_tt_5_suc";
142 END|
143 CREATE FUNCTION fc_i_nt_5_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
144 BEGIN
145 DECLARE in_stmt_id INTEGER;
146 SELECT max(stmt_id) INTO in_stmt_id FROM nt_5 WHERE trans_id= p_trans_id;
147 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
148 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
149 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
150 RETURN "fc_i_nt_5_suc";
151 END|
152 CREATE FUNCTION fc_i_nt_3_tt_3_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
153 BEGIN
154 DECLARE in_stmt_id INTEGER;
155 SELECT max(stmt_id) INTO in_stmt_id FROM nt_3 WHERE trans_id= p_trans_id;
156 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
157 INSERT INTO nt_3(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
158 SELECT max(stmt_id) INTO in_stmt_id FROM tt_3 WHERE trans_id= p_trans_id;
159 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
160 INSERT INTO tt_3(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
161 RETURN "fc_i_nt_3_tt_3_suc";
162 END|
163 CREATE TRIGGER tr_i_tt_3_to_nt_3 AFTER INSERT ON tt_3 FOR EACH ROW
164 BEGIN
165 DECLARE in_stmt_id INTEGER;
166 SELECT max(stmt_id) INTO in_stmt_id FROM nt_3 WHERE trans_id= NEW.trans_id;
167 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
168 INSERT INTO nt_3(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
169 INSERT INTO nt_3(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
170 END|
171 CREATE TRIGGER tr_i_nt_4_to_tt_4 AFTER INSERT ON nt_4 FOR EACH ROW
172 BEGIN
173 DECLARE in_stmt_id INTEGER;
174 SELECT max(stmt_id) INTO in_stmt_id FROM tt_4 WHERE trans_id= NEW.trans_id;
175 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
176 INSERT INTO tt_4(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
177 INSERT INTO tt_4(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
178 END|
179 CREATE TRIGGER tr_i_tt_5_to_tt_6 AFTER INSERT ON tt_5 FOR EACH ROW
180 BEGIN
181 DECLARE in_stmt_id INTEGER;
182 SELECT max(stmt_id) INTO in_stmt_id FROM tt_6 WHERE trans_id= NEW.trans_id;
183 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id, 1), 1) INTO in_stmt_id;
184 INSERT INTO tt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
185 INSERT INTO tt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
186 END|
187 CREATE TRIGGER tr_i_nt_5_to_nt_6 AFTER INSERT ON nt_5 FOR EACH ROW
188 BEGIN
189 DECLARE in_stmt_id INTEGER;
190 SELECT max(stmt_id) INTO in_stmt_id FROM nt_6 WHERE trans_id= NEW.trans_id;
191 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
192 INSERT INTO nt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
193 INSERT INTO nt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
194 END|
195 ###################################################################################
196 # EXECUTE CASES CRASHING THE XID
197 ###################################################################################
198
199
200
201 STOP REPLICA SQL_THREAD;
202 include/wait_for_slave_sql_to_stop.inc
203 SET GLOBAL debug="d,crash_after_apply";;
204 FAILURE d,crash_after_apply and OUTCOME O2
205 rpl_mixing_engines.inc [commands=T]
206 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
207 INSERT INTO tt_1(trans_id, stmt_id) VALUES (7, 1);
208 include/show_binlog_events.inc
209 Log_name Pos Event_type Server_id End_log_pos Info
210 master-bin.000001 # Query # # BEGIN
211 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
212 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
213 master-bin.000001 # Xid # # COMMIT /* XID */
214 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
215 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
216 include/show_binlog_events.inc
217 Log_name Pos Event_type Server_id End_log_pos Info
218 master-bin.000001 # Query # # BEGIN
219 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
220 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
221 master-bin.000001 # Xid # # COMMIT /* XID */
222 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
223
224 include/rpl_reconnect.inc
225 START REPLICA;
226 include/wait_for_slave_to_start.inc
227
228
229
230 STOP REPLICA SQL_THREAD;
231 include/wait_for_slave_sql_to_stop.inc
232 SET GLOBAL debug="d,crash_after_apply";;
233 FAILURE d,crash_after_apply and OUTCOME O2
234 rpl_mixing_engines.inc [commands=T-trig]
235 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
236 INSERT INTO tt_5(trans_id, stmt_id) VALUES (8, 1);
237 include/show_binlog_events.inc
238 Log_name Pos Event_type Server_id End_log_pos Info
239 master-bin.000001 # Query # # BEGIN
240 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
241 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
242 master-bin.000001 # Write_rows # # table_id: #
243 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
244 master-bin.000001 # Xid # # COMMIT /* XID */
245 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
246 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
247 include/show_binlog_events.inc
248 Log_name Pos Event_type Server_id End_log_pos Info
249 master-bin.000001 # Query # # BEGIN
250 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
251 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
252 master-bin.000001 # Write_rows # # table_id: #
253 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
254 master-bin.000001 # Xid # # COMMIT /* XID */
255 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
256
257 include/rpl_reconnect.inc
258 START REPLICA;
259 include/wait_for_slave_to_start.inc
260
261
262
263 STOP REPLICA SQL_THREAD;
264 include/wait_for_slave_sql_to_stop.inc
265 SET GLOBAL debug="d,crash_after_apply";;
266 FAILURE d,crash_after_apply and OUTCOME O2
267 rpl_mixing_engines.inc [commands=T-func]
268 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
269 SELECT fc_i_tt_5_suc (9, 1);
270 fc_i_tt_5_suc (9, 1)
271 fc_i_tt_5_suc
272 include/show_binlog_events.inc
273 Log_name Pos Event_type Server_id End_log_pos Info
274 master-bin.000001 # Query # # BEGIN
275 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
276 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
277 master-bin.000001 # Write_rows # # table_id: #
278 master-bin.000001 # Write_rows # # table_id: #
279 master-bin.000001 # Write_rows # # table_id: #
280 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
281 master-bin.000001 # Xid # # COMMIT /* XID */
282 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
283 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
284 include/show_binlog_events.inc
285 Log_name Pos Event_type Server_id End_log_pos Info
286 master-bin.000001 # Query # # BEGIN
287 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
288 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
289 master-bin.000001 # Write_rows # # table_id: #
290 master-bin.000001 # Write_rows # # table_id: #
291 master-bin.000001 # Write_rows # # table_id: #
292 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
293 master-bin.000001 # Xid # # COMMIT /* XID */
294 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
295
296 include/rpl_reconnect.inc
297 START REPLICA;
298 include/wait_for_slave_to_start.inc
299
300
301
302 STOP REPLICA SQL_THREAD;
303 include/wait_for_slave_sql_to_stop.inc
304 SET GLOBAL debug="d,crash_after_apply";;
305 FAILURE d,crash_after_apply and OUTCOME O2
306 rpl_mixing_engines.inc [commands=T-proc]
307 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
308 CALL pc_i_tt_5_suc (10, 1);
309 include/show_binlog_events.inc
310 Log_name Pos Event_type Server_id End_log_pos Info
311 master-bin.000001 # Query # # BEGIN
312 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
313 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
314 master-bin.000001 # Write_rows # # table_id: #
315 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
316 master-bin.000001 # Xid # # COMMIT /* XID */
317 master-bin.000001 # Query # # BEGIN
318 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
319 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
320 master-bin.000001 # Write_rows # # table_id: #
321 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
322 master-bin.000001 # Xid # # COMMIT /* XID */
323 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
324 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
325 include/show_binlog_events.inc
326 Log_name Pos Event_type Server_id End_log_pos Info
327 master-bin.000001 # Query # # BEGIN
328 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
329 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
330 master-bin.000001 # Write_rows # # table_id: #
331 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
332 master-bin.000001 # Xid # # COMMIT /* XID */
333 master-bin.000001 # Query # # BEGIN
334 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
335 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
336 master-bin.000001 # Write_rows # # table_id: #
337 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
338 master-bin.000001 # Xid # # COMMIT /* XID */
339 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
340
341 include/rpl_reconnect.inc
342 START REPLICA;
343 include/wait_for_slave_to_start.inc
344
345
346
347 STOP REPLICA SQL_THREAD;
348 include/wait_for_slave_sql_to_stop.inc
349 SET GLOBAL debug="d,crash_after_apply";;
350 FAILURE d,crash_after_apply and OUTCOME O2
351 rpl_mixing_engines.inc [commands=B T T-trig C]
352 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
353 BEGIN;
354 include/show_binlog_events.inc
355 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
356 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
357 INSERT INTO tt_1(trans_id, stmt_id) VALUES (11, 2);
358 include/show_binlog_events.inc
359 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
360 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
361 INSERT INTO tt_5(trans_id, stmt_id) VALUES (11, 4);
362 include/show_binlog_events.inc
363 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
364 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
365 COMMIT;
366 include/show_binlog_events.inc
367 Log_name Pos Event_type Server_id End_log_pos Info
368 master-bin.000001 # Query # # BEGIN
369 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
370 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
371 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
372 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
373 master-bin.000001 # Write_rows # # table_id: #
374 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
375 master-bin.000001 # Xid # # COMMIT /* XID */
376 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
377 -b-b-b-b-b-b-b-b-b-b-b- >> B T T-trig C << -b-b-b-b-b-b-b-b-b-b-b-
378 include/show_binlog_events.inc
379 Log_name Pos Event_type Server_id End_log_pos Info
380 master-bin.000001 # Query # # BEGIN
381 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
382 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
383 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
384 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
385 master-bin.000001 # Write_rows # # table_id: #
386 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
387 master-bin.000001 # Xid # # COMMIT /* XID */
388 -e-e-e-e-e-e-e-e-e-e-e- >> B T T-trig C << -e-e-e-e-e-e-e-e-e-e-e-
389
390 include/rpl_reconnect.inc
391 START REPLICA;
392 include/wait_for_slave_to_start.inc
393
394
395
396 STOP REPLICA SQL_THREAD;
397 include/wait_for_slave_sql_to_stop.inc
398 SET GLOBAL debug="d,crash_after_apply";;
399 FAILURE d,crash_after_apply and OUTCOME O2
400 rpl_mixing_engines.inc [commands=B T T-func C]
401 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
402 BEGIN;
403 include/show_binlog_events.inc
404 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
405 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
406 INSERT INTO tt_1(trans_id, stmt_id) VALUES (12, 2);
407 include/show_binlog_events.inc
408 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
409 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
410 SELECT fc_i_tt_5_suc (12, 4);
411 fc_i_tt_5_suc (12, 4)
412 fc_i_tt_5_suc
413 include/show_binlog_events.inc
414 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
415 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
416 COMMIT;
417 include/show_binlog_events.inc
418 Log_name Pos Event_type Server_id End_log_pos Info
419 master-bin.000001 # Query # # BEGIN
420 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
421 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
422 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
423 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
424 master-bin.000001 # Write_rows # # table_id: #
425 master-bin.000001 # Write_rows # # table_id: #
426 master-bin.000001 # Write_rows # # table_id: #
427 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
428 master-bin.000001 # Xid # # COMMIT /* XID */
429 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
430 -b-b-b-b-b-b-b-b-b-b-b- >> B T T-func C << -b-b-b-b-b-b-b-b-b-b-b-
431 include/show_binlog_events.inc
432 Log_name Pos Event_type Server_id End_log_pos Info
433 master-bin.000001 # Query # # BEGIN
434 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
435 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
436 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
437 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
438 master-bin.000001 # Write_rows # # table_id: #
439 master-bin.000001 # Write_rows # # table_id: #
440 master-bin.000001 # Write_rows # # table_id: #
441 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
442 master-bin.000001 # Xid # # COMMIT /* XID */
443 -e-e-e-e-e-e-e-e-e-e-e- >> B T T-func C << -e-e-e-e-e-e-e-e-e-e-e-
444
445 include/rpl_reconnect.inc
446 START REPLICA;
447 include/wait_for_slave_to_start.inc
448
449
450
451 STOP REPLICA SQL_THREAD;
452 include/wait_for_slave_sql_to_stop.inc
453 SET GLOBAL debug="d,crash_after_apply";;
454 FAILURE d,crash_after_apply and OUTCOME O2
455 rpl_mixing_engines.inc [commands=B T T-proc C]
456 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
457 BEGIN;
458 include/show_binlog_events.inc
459 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
460 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
461 INSERT INTO tt_1(trans_id, stmt_id) VALUES (13, 2);
462 include/show_binlog_events.inc
463 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
464 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
465 CALL pc_i_tt_5_suc (13, 4);
466 include/show_binlog_events.inc
467 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
468 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
469 COMMIT;
470 include/show_binlog_events.inc
471 Log_name Pos Event_type Server_id End_log_pos Info
472 master-bin.000001 # Query # # BEGIN
473 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
474 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
475 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
476 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
477 master-bin.000001 # Write_rows # # table_id: #
478 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
479 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
480 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
481 master-bin.000001 # Write_rows # # table_id: #
482 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
483 master-bin.000001 # Xid # # COMMIT /* XID */
484 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
485 -b-b-b-b-b-b-b-b-b-b-b- >> B T T-proc C << -b-b-b-b-b-b-b-b-b-b-b-
486 include/show_binlog_events.inc
487 Log_name Pos Event_type Server_id End_log_pos Info
488 master-bin.000001 # Query # # BEGIN
489 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
490 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
491 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
492 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
493 master-bin.000001 # Write_rows # # table_id: #
494 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
495 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
496 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
497 master-bin.000001 # Write_rows # # table_id: #
498 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
499 master-bin.000001 # Xid # # COMMIT /* XID */
500 -e-e-e-e-e-e-e-e-e-e-e- >> B T T-proc C << -e-e-e-e-e-e-e-e-e-e-e-
501
502 include/rpl_reconnect.inc
503 START REPLICA;
504 include/wait_for_slave_to_start.inc
505
506
507
508 STOP REPLICA SQL_THREAD;
509 include/wait_for_slave_sql_to_stop.inc
510 SET GLOBAL debug="d,crash_after_apply";;
511 FAILURE d,crash_after_apply and OUTCOME O2
512 rpl_mixing_engines.inc [commands=B T-trig T C]
513 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
514 BEGIN;
515 include/show_binlog_events.inc
516 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
517 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
518 INSERT INTO tt_5(trans_id, stmt_id) VALUES (14, 2);
519 include/show_binlog_events.inc
520 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
521 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
522 INSERT INTO tt_1(trans_id, stmt_id) VALUES (14, 4);
523 include/show_binlog_events.inc
524 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
525 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
526 COMMIT;
527 include/show_binlog_events.inc
528 Log_name Pos Event_type Server_id End_log_pos Info
529 master-bin.000001 # Query # # BEGIN
530 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
531 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
532 master-bin.000001 # Write_rows # # table_id: #
533 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
534 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
535 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
536 master-bin.000001 # Xid # # COMMIT /* XID */
537 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
538 -b-b-b-b-b-b-b-b-b-b-b- >> B T-trig T C << -b-b-b-b-b-b-b-b-b-b-b-
539 include/show_binlog_events.inc
540 Log_name Pos Event_type Server_id End_log_pos Info
541 master-bin.000001 # Query # # BEGIN
542 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
543 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
544 master-bin.000001 # Write_rows # # table_id: #
545 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
546 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
547 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
548 master-bin.000001 # Xid # # COMMIT /* XID */
549 -e-e-e-e-e-e-e-e-e-e-e- >> B T-trig T C << -e-e-e-e-e-e-e-e-e-e-e-
550
551 include/rpl_reconnect.inc
552 START REPLICA;
553 include/wait_for_slave_to_start.inc
554
555
556
557 STOP REPLICA SQL_THREAD;
558 include/wait_for_slave_sql_to_stop.inc
559 SET GLOBAL debug="d,crash_after_apply";;
560 FAILURE d,crash_after_apply and OUTCOME O2
561 rpl_mixing_engines.inc [commands=B T-func T C]
562 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
563 BEGIN;
564 include/show_binlog_events.inc
565 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
566 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
567 SELECT fc_i_tt_5_suc (15, 2);
568 fc_i_tt_5_suc (15, 2)
569 fc_i_tt_5_suc
570 include/show_binlog_events.inc
571 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
572 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
573 INSERT INTO tt_1(trans_id, stmt_id) VALUES (15, 4);
574 include/show_binlog_events.inc
575 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
576 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
577 COMMIT;
578 include/show_binlog_events.inc
579 Log_name Pos Event_type Server_id End_log_pos Info
580 master-bin.000001 # Query # # BEGIN
581 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
582 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
583 master-bin.000001 # Write_rows # # table_id: #
584 master-bin.000001 # Write_rows # # table_id: #
585 master-bin.000001 # Write_rows # # table_id: #
586 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
587 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
588 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
589 master-bin.000001 # Xid # # COMMIT /* XID */
590 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
591 -b-b-b-b-b-b-b-b-b-b-b- >> B T-func T C << -b-b-b-b-b-b-b-b-b-b-b-
592 include/show_binlog_events.inc
593 Log_name Pos Event_type Server_id End_log_pos Info
594 master-bin.000001 # Query # # BEGIN
595 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
596 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
597 master-bin.000001 # Write_rows # # table_id: #
598 master-bin.000001 # Write_rows # # table_id: #
599 master-bin.000001 # Write_rows # # table_id: #
600 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
601 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
602 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
603 master-bin.000001 # Xid # # COMMIT /* XID */
604 -e-e-e-e-e-e-e-e-e-e-e- >> B T-func T C << -e-e-e-e-e-e-e-e-e-e-e-
605
606 include/rpl_reconnect.inc
607 START REPLICA;
608 include/wait_for_slave_to_start.inc
609
610
611
612 STOP REPLICA SQL_THREAD;
613 include/wait_for_slave_sql_to_stop.inc
614 SET GLOBAL debug="d,crash_after_apply";;
615 FAILURE d,crash_after_apply and OUTCOME O2
616 rpl_mixing_engines.inc [commands=B T-proc T C]
617 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
618 BEGIN;
619 include/show_binlog_events.inc
620 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
621 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
622 CALL pc_i_tt_5_suc (16, 2);
623 include/show_binlog_events.inc
624 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
625 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
626 INSERT INTO tt_1(trans_id, stmt_id) VALUES (16, 4);
627 include/show_binlog_events.inc
628 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
629 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
630 COMMIT;
631 include/show_binlog_events.inc
632 Log_name Pos Event_type Server_id End_log_pos Info
633 master-bin.000001 # Query # # BEGIN
634 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
635 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
636 master-bin.000001 # Write_rows # # table_id: #
637 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
638 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
639 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
640 master-bin.000001 # Write_rows # # table_id: #
641 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
642 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
643 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
644 master-bin.000001 # Xid # # COMMIT /* XID */
645 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
646 -b-b-b-b-b-b-b-b-b-b-b- >> B T-proc T C << -b-b-b-b-b-b-b-b-b-b-b-
647 include/show_binlog_events.inc
648 Log_name Pos Event_type Server_id End_log_pos Info
649 master-bin.000001 # Query # # BEGIN
650 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
651 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
652 master-bin.000001 # Write_rows # # table_id: #
653 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
654 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
655 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
656 master-bin.000001 # Write_rows # # table_id: #
657 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
658 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
659 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
660 master-bin.000001 # Xid # # COMMIT /* XID */
661 -e-e-e-e-e-e-e-e-e-e-e- >> B T-proc T C << -e-e-e-e-e-e-e-e-e-e-e-
662
663 include/rpl_reconnect.inc
664 START REPLICA;
665 include/wait_for_slave_to_start.inc
666
667
668
669 STOP REPLICA SQL_THREAD;
670 include/wait_for_slave_sql_to_stop.inc
671 SET GLOBAL debug="d,crash_before_update_pos";;
672 FAILURE d,crash_before_update_pos and OUTCOME O1
673 rpl_mixing_engines.inc [commands=T]
674 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
675 INSERT INTO tt_1(trans_id, stmt_id) VALUES (17, 1);
676 include/show_binlog_events.inc
677 Log_name Pos Event_type Server_id End_log_pos Info
678 master-bin.000001 # Query # # BEGIN
679 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
680 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
681 master-bin.000001 # Xid # # COMMIT /* XID */
682 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
683 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
684 include/show_binlog_events.inc
685 Log_name Pos Event_type Server_id End_log_pos Info
686 master-bin.000001 # Query # # BEGIN
687 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
688 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
689 master-bin.000001 # Xid # # COMMIT /* XID */
690 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
691
692 include/rpl_reconnect.inc
693 START REPLICA;
694 include/wait_for_slave_to_start.inc
695
696
697
698 STOP REPLICA SQL_THREAD;
699 include/wait_for_slave_sql_to_stop.inc
700 SET GLOBAL debug="d,crash_before_update_pos";;
701 FAILURE d,crash_before_update_pos and OUTCOME O1
702 rpl_mixing_engines.inc [commands=T-trig]
703 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
704 INSERT INTO tt_5(trans_id, stmt_id) VALUES (18, 1);
705 include/show_binlog_events.inc
706 Log_name Pos Event_type Server_id End_log_pos Info
707 master-bin.000001 # Query # # BEGIN
708 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
709 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
710 master-bin.000001 # Write_rows # # table_id: #
711 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
712 master-bin.000001 # Xid # # COMMIT /* XID */
713 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
714 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
715 include/show_binlog_events.inc
716 Log_name Pos Event_type Server_id End_log_pos Info
717 master-bin.000001 # Query # # BEGIN
718 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
719 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
720 master-bin.000001 # Write_rows # # table_id: #
721 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
722 master-bin.000001 # Xid # # COMMIT /* XID */
723 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
724
725 include/rpl_reconnect.inc
726 START REPLICA;
727 include/wait_for_slave_to_start.inc
728
729
730
731 STOP REPLICA SQL_THREAD;
732 include/wait_for_slave_sql_to_stop.inc
733 SET GLOBAL debug="d,crash_before_update_pos";;
734 FAILURE d,crash_before_update_pos and OUTCOME O1
735 rpl_mixing_engines.inc [commands=T-func]
736 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
737 SELECT fc_i_tt_5_suc (19, 1);
738 fc_i_tt_5_suc (19, 1)
739 fc_i_tt_5_suc
740 include/show_binlog_events.inc
741 Log_name Pos Event_type Server_id End_log_pos Info
742 master-bin.000001 # Query # # BEGIN
743 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
744 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
745 master-bin.000001 # Write_rows # # table_id: #
746 master-bin.000001 # Write_rows # # table_id: #
747 master-bin.000001 # Write_rows # # table_id: #
748 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
749 master-bin.000001 # Xid # # COMMIT /* XID */
750 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
751 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
752 include/show_binlog_events.inc
753 Log_name Pos Event_type Server_id End_log_pos Info
754 master-bin.000001 # Query # # BEGIN
755 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
756 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
757 master-bin.000001 # Write_rows # # table_id: #
758 master-bin.000001 # Write_rows # # table_id: #
759 master-bin.000001 # Write_rows # # table_id: #
760 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
761 master-bin.000001 # Xid # # COMMIT /* XID */
762 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
763
764 include/rpl_reconnect.inc
765 START REPLICA;
766 include/wait_for_slave_to_start.inc
767
768
769
770 STOP REPLICA SQL_THREAD;
771 include/wait_for_slave_sql_to_stop.inc
772 SET GLOBAL debug="d,crash_before_update_pos";;
773 FAILURE d,crash_before_update_pos and OUTCOME O1
774 rpl_mixing_engines.inc [commands=T-proc]
775 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
776 CALL pc_i_tt_5_suc (20, 1);
777 include/show_binlog_events.inc
778 Log_name Pos Event_type Server_id End_log_pos Info
779 master-bin.000001 # Query # # BEGIN
780 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
781 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
782 master-bin.000001 # Write_rows # # table_id: #
783 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
784 master-bin.000001 # Xid # # COMMIT /* XID */
785 master-bin.000001 # Query # # BEGIN
786 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
787 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
788 master-bin.000001 # Write_rows # # table_id: #
789 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
790 master-bin.000001 # Xid # # COMMIT /* XID */
791 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
792 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
793 include/show_binlog_events.inc
794 Log_name Pos Event_type Server_id End_log_pos Info
795 master-bin.000001 # Query # # BEGIN
796 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
797 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
798 master-bin.000001 # Write_rows # # table_id: #
799 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
800 master-bin.000001 # Xid # # COMMIT /* XID */
801 master-bin.000001 # Query # # BEGIN
802 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
803 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
804 master-bin.000001 # Write_rows # # table_id: #
805 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
806 master-bin.000001 # Xid # # COMMIT /* XID */
807 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
808
809 include/rpl_reconnect.inc
810 START REPLICA;
811 include/wait_for_slave_to_start.inc
812
813
814
815 STOP REPLICA SQL_THREAD;
816 include/wait_for_slave_sql_to_stop.inc
817 SET GLOBAL debug="d,crash_before_update_pos";;
818 FAILURE d,crash_before_update_pos and OUTCOME O1
819 rpl_mixing_engines.inc [commands=B T T-trig C]
820 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
821 BEGIN;
822 include/show_binlog_events.inc
823 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
824 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
825 INSERT INTO tt_1(trans_id, stmt_id) VALUES (21, 2);
826 include/show_binlog_events.inc
827 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
828 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
829 INSERT INTO tt_5(trans_id, stmt_id) VALUES (21, 4);
830 include/show_binlog_events.inc
831 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
832 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
833 COMMIT;
834 include/show_binlog_events.inc
835 Log_name Pos Event_type Server_id End_log_pos Info
836 master-bin.000001 # Query # # BEGIN
837 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
838 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
839 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
840 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
841 master-bin.000001 # Write_rows # # table_id: #
842 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
843 master-bin.000001 # Xid # # COMMIT /* XID */
844 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
845 -b-b-b-b-b-b-b-b-b-b-b- >> B T T-trig C << -b-b-b-b-b-b-b-b-b-b-b-
846 include/show_binlog_events.inc
847 Log_name Pos Event_type Server_id End_log_pos Info
848 master-bin.000001 # Query # # BEGIN
849 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
850 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
851 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
852 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
853 master-bin.000001 # Write_rows # # table_id: #
854 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
855 master-bin.000001 # Xid # # COMMIT /* XID */
856 -e-e-e-e-e-e-e-e-e-e-e- >> B T T-trig C << -e-e-e-e-e-e-e-e-e-e-e-
857
858 include/rpl_reconnect.inc
859 START REPLICA;
860 include/wait_for_slave_to_start.inc
861
862
863
864 STOP REPLICA SQL_THREAD;
865 include/wait_for_slave_sql_to_stop.inc
866 SET GLOBAL debug="d,crash_before_update_pos";;
867 FAILURE d,crash_before_update_pos and OUTCOME O1
868 rpl_mixing_engines.inc [commands=B T T-func C]
869 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
870 BEGIN;
871 include/show_binlog_events.inc
872 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
873 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
874 INSERT INTO tt_1(trans_id, stmt_id) VALUES (22, 2);
875 include/show_binlog_events.inc
876 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
877 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
878 SELECT fc_i_tt_5_suc (22, 4);
879 fc_i_tt_5_suc (22, 4)
880 fc_i_tt_5_suc
881 include/show_binlog_events.inc
882 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
883 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
884 COMMIT;
885 include/show_binlog_events.inc
886 Log_name Pos Event_type Server_id End_log_pos Info
887 master-bin.000001 # Query # # BEGIN
888 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
889 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
890 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
891 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
892 master-bin.000001 # Write_rows # # table_id: #
893 master-bin.000001 # Write_rows # # table_id: #
894 master-bin.000001 # Write_rows # # table_id: #
895 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
896 master-bin.000001 # Xid # # COMMIT /* XID */
897 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
898 -b-b-b-b-b-b-b-b-b-b-b- >> B T T-func C << -b-b-b-b-b-b-b-b-b-b-b-
899 include/show_binlog_events.inc
900 Log_name Pos Event_type Server_id End_log_pos Info
901 master-bin.000001 # Query # # BEGIN
902 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
903 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
904 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
905 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
906 master-bin.000001 # Write_rows # # table_id: #
907 master-bin.000001 # Write_rows # # table_id: #
908 master-bin.000001 # Write_rows # # table_id: #
909 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
910 master-bin.000001 # Xid # # COMMIT /* XID */
911 -e-e-e-e-e-e-e-e-e-e-e- >> B T T-func C << -e-e-e-e-e-e-e-e-e-e-e-
912
913 include/rpl_reconnect.inc
914 START REPLICA;
915 include/wait_for_slave_to_start.inc
916
917
918
919 STOP REPLICA SQL_THREAD;
920 include/wait_for_slave_sql_to_stop.inc
921 SET GLOBAL debug="d,crash_before_update_pos";;
922 FAILURE d,crash_before_update_pos and OUTCOME O1
923 rpl_mixing_engines.inc [commands=B T T-proc C]
924 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
925 BEGIN;
926 include/show_binlog_events.inc
927 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
928 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
929 INSERT INTO tt_1(trans_id, stmt_id) VALUES (23, 2);
930 include/show_binlog_events.inc
931 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
932 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
933 CALL pc_i_tt_5_suc (23, 4);
934 include/show_binlog_events.inc
935 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
936 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
937 COMMIT;
938 include/show_binlog_events.inc
939 Log_name Pos Event_type Server_id End_log_pos Info
940 master-bin.000001 # Query # # BEGIN
941 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
942 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
943 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
944 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
945 master-bin.000001 # Write_rows # # table_id: #
946 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
947 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
948 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
949 master-bin.000001 # Write_rows # # table_id: #
950 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
951 master-bin.000001 # Xid # # COMMIT /* XID */
952 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
953 -b-b-b-b-b-b-b-b-b-b-b- >> B T T-proc C << -b-b-b-b-b-b-b-b-b-b-b-
954 include/show_binlog_events.inc
955 Log_name Pos Event_type Server_id End_log_pos Info
956 master-bin.000001 # Query # # BEGIN
957 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
958 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
959 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
960 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
961 master-bin.000001 # Write_rows # # table_id: #
962 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
963 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
964 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
965 master-bin.000001 # Write_rows # # table_id: #
966 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
967 master-bin.000001 # Xid # # COMMIT /* XID */
968 -e-e-e-e-e-e-e-e-e-e-e- >> B T T-proc C << -e-e-e-e-e-e-e-e-e-e-e-
969
970 include/rpl_reconnect.inc
971 START REPLICA;
972 include/wait_for_slave_to_start.inc
973
974
975
976 STOP REPLICA SQL_THREAD;
977 include/wait_for_slave_sql_to_stop.inc
978 SET GLOBAL debug="d,crash_before_update_pos";;
979 FAILURE d,crash_before_update_pos and OUTCOME O1
980 rpl_mixing_engines.inc [commands=B T-trig T C]
981 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
982 BEGIN;
983 include/show_binlog_events.inc
984 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
985 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
986 INSERT INTO tt_5(trans_id, stmt_id) VALUES (24, 2);
987 include/show_binlog_events.inc
988 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
989 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
990 INSERT INTO tt_1(trans_id, stmt_id) VALUES (24, 4);
991 include/show_binlog_events.inc
992 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
993 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
994 COMMIT;
995 include/show_binlog_events.inc
996 Log_name Pos Event_type Server_id End_log_pos Info
997 master-bin.000001 # Query # # BEGIN
998 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
999 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1000 master-bin.000001 # Write_rows # # table_id: #
1001 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1002 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1003 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1004 master-bin.000001 # Xid # # COMMIT /* XID */
1005 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1006 -b-b-b-b-b-b-b-b-b-b-b- >> B T-trig T C << -b-b-b-b-b-b-b-b-b-b-b-
1007 include/show_binlog_events.inc
1008 Log_name Pos Event_type Server_id End_log_pos Info
1009 master-bin.000001 # Query # # BEGIN
1010 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1011 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1012 master-bin.000001 # Write_rows # # table_id: #
1013 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1014 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1015 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1016 master-bin.000001 # Xid # # COMMIT /* XID */
1017 -e-e-e-e-e-e-e-e-e-e-e- >> B T-trig T C << -e-e-e-e-e-e-e-e-e-e-e-
1018
1019 include/rpl_reconnect.inc
1020 START REPLICA;
1021 include/wait_for_slave_to_start.inc
1022
1023
1024
1025 STOP REPLICA SQL_THREAD;
1026 include/wait_for_slave_sql_to_stop.inc
1027 SET GLOBAL debug="d,crash_before_update_pos";;
1028 FAILURE d,crash_before_update_pos and OUTCOME O1
1029 rpl_mixing_engines.inc [commands=B T-func T C]
1030 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1031 BEGIN;
1032 include/show_binlog_events.inc
1033 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1034 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
1035 SELECT fc_i_tt_5_suc (25, 2);
1036 fc_i_tt_5_suc (25, 2)
1037 fc_i_tt_5_suc
1038 include/show_binlog_events.inc
1039 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
1040 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1041 INSERT INTO tt_1(trans_id, stmt_id) VALUES (25, 4);
1042 include/show_binlog_events.inc
1043 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1044 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1045 COMMIT;
1046 include/show_binlog_events.inc
1047 Log_name Pos Event_type Server_id End_log_pos Info
1048 master-bin.000001 # Query # # BEGIN
1049 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1050 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1051 master-bin.000001 # Write_rows # # table_id: #
1052 master-bin.000001 # Write_rows # # table_id: #
1053 master-bin.000001 # Write_rows # # table_id: #
1054 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1055 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1056 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1057 master-bin.000001 # Xid # # COMMIT /* XID */
1058 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1059 -b-b-b-b-b-b-b-b-b-b-b- >> B T-func T C << -b-b-b-b-b-b-b-b-b-b-b-
1060 include/show_binlog_events.inc
1061 Log_name Pos Event_type Server_id End_log_pos Info
1062 master-bin.000001 # Query # # BEGIN
1063 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1064 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1065 master-bin.000001 # Write_rows # # table_id: #
1066 master-bin.000001 # Write_rows # # table_id: #
1067 master-bin.000001 # Write_rows # # table_id: #
1068 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1069 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1070 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1071 master-bin.000001 # Xid # # COMMIT /* XID */
1072 -e-e-e-e-e-e-e-e-e-e-e- >> B T-func T C << -e-e-e-e-e-e-e-e-e-e-e-
1073
1074 include/rpl_reconnect.inc
1075 START REPLICA;
1076 include/wait_for_slave_to_start.inc
1077
1078
1079
1080 STOP REPLICA SQL_THREAD;
1081 include/wait_for_slave_sql_to_stop.inc
1082 SET GLOBAL debug="d,crash_before_update_pos";;
1083 FAILURE d,crash_before_update_pos and OUTCOME O1
1084 rpl_mixing_engines.inc [commands=B T-proc T C]
1085 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1086 BEGIN;
1087 include/show_binlog_events.inc
1088 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1089 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
1090 CALL pc_i_tt_5_suc (26, 2);
1091 include/show_binlog_events.inc
1092 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
1093 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1094 INSERT INTO tt_1(trans_id, stmt_id) VALUES (26, 4);
1095 include/show_binlog_events.inc
1096 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1097 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1098 COMMIT;
1099 include/show_binlog_events.inc
1100 Log_name Pos Event_type Server_id End_log_pos Info
1101 master-bin.000001 # Query # # BEGIN
1102 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1103 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1104 master-bin.000001 # Write_rows # # table_id: #
1105 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1106 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1107 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1108 master-bin.000001 # Write_rows # # table_id: #
1109 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1110 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1111 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1112 master-bin.000001 # Xid # # COMMIT /* XID */
1113 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1114 -b-b-b-b-b-b-b-b-b-b-b- >> B T-proc T C << -b-b-b-b-b-b-b-b-b-b-b-
1115 include/show_binlog_events.inc
1116 Log_name Pos Event_type Server_id End_log_pos Info
1117 master-bin.000001 # Query # # BEGIN
1118 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1119 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1120 master-bin.000001 # Write_rows # # table_id: #
1121 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1122 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1123 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1124 master-bin.000001 # Write_rows # # table_id: #
1125 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1126 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1127 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1128 master-bin.000001 # Xid # # COMMIT /* XID */
1129 -e-e-e-e-e-e-e-e-e-e-e- >> B T-proc T C << -e-e-e-e-e-e-e-e-e-e-e-
1130
1131 include/rpl_reconnect.inc
1132 START REPLICA;
1133 include/wait_for_slave_to_start.inc
1134
1135
1136
1137 STOP REPLICA SQL_THREAD;
1138 include/wait_for_slave_sql_to_stop.inc
1139 SET GLOBAL debug="d,crash_after_update_pos_before_apply";;
1140 FAILURE d,crash_after_update_pos_before_apply and OUTCOME O1
1141 rpl_mixing_engines.inc [commands=T]
1142 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1143 INSERT INTO tt_1(trans_id, stmt_id) VALUES (27, 1);
1144 include/show_binlog_events.inc
1145 Log_name Pos Event_type Server_id End_log_pos Info
1146 master-bin.000001 # Query # # BEGIN
1147 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1148 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1149 master-bin.000001 # Xid # # COMMIT /* XID */
1150 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1151 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1152 include/show_binlog_events.inc
1153 Log_name Pos Event_type Server_id End_log_pos Info
1154 master-bin.000001 # Query # # BEGIN
1155 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1156 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1157 master-bin.000001 # Xid # # COMMIT /* XID */
1158 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1159
1160 include/rpl_reconnect.inc
1161 START REPLICA;
1162 include/wait_for_slave_to_start.inc
1163
1164
1165
1166 STOP REPLICA SQL_THREAD;
1167 include/wait_for_slave_sql_to_stop.inc
1168 SET GLOBAL debug="d,crash_after_update_pos_before_apply";;
1169 FAILURE d,crash_after_update_pos_before_apply and OUTCOME O1
1170 rpl_mixing_engines.inc [commands=T-trig]
1171 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
1172 INSERT INTO tt_5(trans_id, stmt_id) VALUES (28, 1);
1173 include/show_binlog_events.inc
1174 Log_name Pos Event_type Server_id End_log_pos Info
1175 master-bin.000001 # Query # # BEGIN
1176 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1177 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1178 master-bin.000001 # Write_rows # # table_id: #
1179 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1180 master-bin.000001 # Xid # # COMMIT /* XID */
1181 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
1182 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
1183 include/show_binlog_events.inc
1184 Log_name Pos Event_type Server_id End_log_pos Info
1185 master-bin.000001 # Query # # BEGIN
1186 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1187 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1188 master-bin.000001 # Write_rows # # table_id: #
1189 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1190 master-bin.000001 # Xid # # COMMIT /* XID */
1191 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
1192
1193 include/rpl_reconnect.inc
1194 START REPLICA;
1195 include/wait_for_slave_to_start.inc
1196
1197
1198
1199 STOP REPLICA SQL_THREAD;
1200 include/wait_for_slave_sql_to_stop.inc
1201 SET GLOBAL debug="d,crash_after_update_pos_before_apply";;
1202 FAILURE d,crash_after_update_pos_before_apply and OUTCOME O1
1203 rpl_mixing_engines.inc [commands=T-func]
1204 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
1205 SELECT fc_i_tt_5_suc (29, 1);
1206 fc_i_tt_5_suc (29, 1)
1207 fc_i_tt_5_suc
1208 include/show_binlog_events.inc
1209 Log_name Pos Event_type Server_id End_log_pos Info
1210 master-bin.000001 # Query # # BEGIN
1211 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1212 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1213 master-bin.000001 # Write_rows # # table_id: #
1214 master-bin.000001 # Write_rows # # table_id: #
1215 master-bin.000001 # Write_rows # # table_id: #
1216 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1217 master-bin.000001 # Xid # # COMMIT /* XID */
1218 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
1219 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
1220 include/show_binlog_events.inc
1221 Log_name Pos Event_type Server_id End_log_pos Info
1222 master-bin.000001 # Query # # BEGIN
1223 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1224 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1225 master-bin.000001 # Write_rows # # table_id: #
1226 master-bin.000001 # Write_rows # # table_id: #
1227 master-bin.000001 # Write_rows # # table_id: #
1228 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1229 master-bin.000001 # Xid # # COMMIT /* XID */
1230 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
1231
1232 include/rpl_reconnect.inc
1233 START REPLICA;
1234 include/wait_for_slave_to_start.inc
1235
1236
1237
1238 STOP REPLICA SQL_THREAD;
1239 include/wait_for_slave_sql_to_stop.inc
1240 SET GLOBAL debug="d,crash_after_update_pos_before_apply";;
1241 FAILURE d,crash_after_update_pos_before_apply and OUTCOME O1
1242 rpl_mixing_engines.inc [commands=T-proc]
1243 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
1244 CALL pc_i_tt_5_suc (30, 1);
1245 include/show_binlog_events.inc
1246 Log_name Pos Event_type Server_id End_log_pos Info
1247 master-bin.000001 # Query # # BEGIN
1248 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1249 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1250 master-bin.000001 # Write_rows # # table_id: #
1251 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1252 master-bin.000001 # Xid # # COMMIT /* XID */
1253 master-bin.000001 # Query # # BEGIN
1254 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1255 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1256 master-bin.000001 # Write_rows # # table_id: #
1257 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1258 master-bin.000001 # Xid # # COMMIT /* XID */
1259 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
1260 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
1261 include/show_binlog_events.inc
1262 Log_name Pos Event_type Server_id End_log_pos Info
1263 master-bin.000001 # Query # # BEGIN
1264 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1265 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1266 master-bin.000001 # Write_rows # # table_id: #
1267 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1268 master-bin.000001 # Xid # # COMMIT /* XID */
1269 master-bin.000001 # Query # # BEGIN
1270 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1271 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1272 master-bin.000001 # Write_rows # # table_id: #
1273 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1274 master-bin.000001 # Xid # # COMMIT /* XID */
1275 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
1276
1277 include/rpl_reconnect.inc
1278 START REPLICA;
1279 include/wait_for_slave_to_start.inc
1280
1281
1282
1283 STOP REPLICA SQL_THREAD;
1284 include/wait_for_slave_sql_to_stop.inc
1285 SET GLOBAL debug="d,crash_after_update_pos_before_apply";;
1286 FAILURE d,crash_after_update_pos_before_apply and OUTCOME O1
1287 rpl_mixing_engines.inc [commands=B T T-trig C]
1288 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1289 BEGIN;
1290 include/show_binlog_events.inc
1291 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1292 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1293 INSERT INTO tt_1(trans_id, stmt_id) VALUES (31, 2);
1294 include/show_binlog_events.inc
1295 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1296 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
1297 INSERT INTO tt_5(trans_id, stmt_id) VALUES (31, 4);
1298 include/show_binlog_events.inc
1299 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
1300 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1301 COMMIT;
1302 include/show_binlog_events.inc
1303 Log_name Pos Event_type Server_id End_log_pos Info
1304 master-bin.000001 # Query # # BEGIN
1305 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1306 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1307 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1308 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1309 master-bin.000001 # Write_rows # # table_id: #
1310 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1311 master-bin.000001 # Xid # # COMMIT /* XID */
1312 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1313 -b-b-b-b-b-b-b-b-b-b-b- >> B T T-trig C << -b-b-b-b-b-b-b-b-b-b-b-
1314 include/show_binlog_events.inc
1315 Log_name Pos Event_type Server_id End_log_pos Info
1316 master-bin.000001 # Query # # BEGIN
1317 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1318 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1319 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1320 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1321 master-bin.000001 # Write_rows # # table_id: #
1322 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1323 master-bin.000001 # Xid # # COMMIT /* XID */
1324 -e-e-e-e-e-e-e-e-e-e-e- >> B T T-trig C << -e-e-e-e-e-e-e-e-e-e-e-
1325
1326 include/rpl_reconnect.inc
1327 START REPLICA;
1328 include/wait_for_slave_to_start.inc
1329
1330
1331
1332 STOP REPLICA SQL_THREAD;
1333 include/wait_for_slave_sql_to_stop.inc
1334 SET GLOBAL debug="d,crash_after_update_pos_before_apply";;
1335 FAILURE d,crash_after_update_pos_before_apply and OUTCOME O1
1336 rpl_mixing_engines.inc [commands=B T T-func C]
1337 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1338 BEGIN;
1339 include/show_binlog_events.inc
1340 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1341 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1342 INSERT INTO tt_1(trans_id, stmt_id) VALUES (32, 2);
1343 include/show_binlog_events.inc
1344 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1345 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
1346 SELECT fc_i_tt_5_suc (32, 4);
1347 fc_i_tt_5_suc (32, 4)
1348 fc_i_tt_5_suc
1349 include/show_binlog_events.inc
1350 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
1351 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1352 COMMIT;
1353 include/show_binlog_events.inc
1354 Log_name Pos Event_type Server_id End_log_pos Info
1355 master-bin.000001 # Query # # BEGIN
1356 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1357 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1358 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1359 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1360 master-bin.000001 # Write_rows # # table_id: #
1361 master-bin.000001 # Write_rows # # table_id: #
1362 master-bin.000001 # Write_rows # # table_id: #
1363 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1364 master-bin.000001 # Xid # # COMMIT /* XID */
1365 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1366 -b-b-b-b-b-b-b-b-b-b-b- >> B T T-func C << -b-b-b-b-b-b-b-b-b-b-b-
1367 include/show_binlog_events.inc
1368 Log_name Pos Event_type Server_id End_log_pos Info
1369 master-bin.000001 # Query # # BEGIN
1370 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1371 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1372 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1373 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1374 master-bin.000001 # Write_rows # # table_id: #
1375 master-bin.000001 # Write_rows # # table_id: #
1376 master-bin.000001 # Write_rows # # table_id: #
1377 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1378 master-bin.000001 # Xid # # COMMIT /* XID */
1379 -e-e-e-e-e-e-e-e-e-e-e- >> B T T-func C << -e-e-e-e-e-e-e-e-e-e-e-
1380
1381 include/rpl_reconnect.inc
1382 START REPLICA;
1383 include/wait_for_slave_to_start.inc
1384
1385
1386
1387 STOP REPLICA SQL_THREAD;
1388 include/wait_for_slave_sql_to_stop.inc
1389 SET GLOBAL debug="d,crash_after_update_pos_before_apply";;
1390 FAILURE d,crash_after_update_pos_before_apply and OUTCOME O1
1391 rpl_mixing_engines.inc [commands=B T T-proc C]
1392 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1393 BEGIN;
1394 include/show_binlog_events.inc
1395 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1396 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1397 INSERT INTO tt_1(trans_id, stmt_id) VALUES (33, 2);
1398 include/show_binlog_events.inc
1399 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1400 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
1401 CALL pc_i_tt_5_suc (33, 4);
1402 include/show_binlog_events.inc
1403 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
1404 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1405 COMMIT;
1406 include/show_binlog_events.inc
1407 Log_name Pos Event_type Server_id End_log_pos Info
1408 master-bin.000001 # Query # # BEGIN
1409 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1410 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1411 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1412 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1413 master-bin.000001 # Write_rows # # table_id: #
1414 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1415 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1416 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1417 master-bin.000001 # Write_rows # # table_id: #
1418 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1419 master-bin.000001 # Xid # # COMMIT /* XID */
1420 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1421 -b-b-b-b-b-b-b-b-b-b-b- >> B T T-proc C << -b-b-b-b-b-b-b-b-b-b-b-
1422 include/show_binlog_events.inc
1423 Log_name Pos Event_type Server_id End_log_pos Info
1424 master-bin.000001 # Query # # BEGIN
1425 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1426 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1427 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1428 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1429 master-bin.000001 # Write_rows # # table_id: #
1430 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1431 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1432 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1433 master-bin.000001 # Write_rows # # table_id: #
1434 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1435 master-bin.000001 # Xid # # COMMIT /* XID */
1436 -e-e-e-e-e-e-e-e-e-e-e- >> B T T-proc C << -e-e-e-e-e-e-e-e-e-e-e-
1437
1438 include/rpl_reconnect.inc
1439 START REPLICA;
1440 include/wait_for_slave_to_start.inc
1441
1442
1443
1444 STOP REPLICA SQL_THREAD;
1445 include/wait_for_slave_sql_to_stop.inc
1446 SET GLOBAL debug="d,crash_after_update_pos_before_apply";;
1447 FAILURE d,crash_after_update_pos_before_apply and OUTCOME O1
1448 rpl_mixing_engines.inc [commands=B T-trig T C]
1449 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1450 BEGIN;
1451 include/show_binlog_events.inc
1452 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1453 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
1454 INSERT INTO tt_5(trans_id, stmt_id) VALUES (34, 2);
1455 include/show_binlog_events.inc
1456 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
1457 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1458 INSERT INTO tt_1(trans_id, stmt_id) VALUES (34, 4);
1459 include/show_binlog_events.inc
1460 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1461 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1462 COMMIT;
1463 include/show_binlog_events.inc
1464 Log_name Pos Event_type Server_id End_log_pos Info
1465 master-bin.000001 # Query # # BEGIN
1466 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1467 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1468 master-bin.000001 # Write_rows # # table_id: #
1469 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1470 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1471 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1472 master-bin.000001 # Xid # # COMMIT /* XID */
1473 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1474 -b-b-b-b-b-b-b-b-b-b-b- >> B T-trig T C << -b-b-b-b-b-b-b-b-b-b-b-
1475 include/show_binlog_events.inc
1476 Log_name Pos Event_type Server_id End_log_pos Info
1477 master-bin.000001 # Query # # BEGIN
1478 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1479 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1480 master-bin.000001 # Write_rows # # table_id: #
1481 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1482 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1483 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1484 master-bin.000001 # Xid # # COMMIT /* XID */
1485 -e-e-e-e-e-e-e-e-e-e-e- >> B T-trig T C << -e-e-e-e-e-e-e-e-e-e-e-
1486
1487 include/rpl_reconnect.inc
1488 START REPLICA;
1489 include/wait_for_slave_to_start.inc
1490
1491
1492
1493 STOP REPLICA SQL_THREAD;
1494 include/wait_for_slave_sql_to_stop.inc
1495 SET GLOBAL debug="d,crash_after_update_pos_before_apply";;
1496 FAILURE d,crash_after_update_pos_before_apply and OUTCOME O1
1497 rpl_mixing_engines.inc [commands=B T-func T C]
1498 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1499 BEGIN;
1500 include/show_binlog_events.inc
1501 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1502 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
1503 SELECT fc_i_tt_5_suc (35, 2);
1504 fc_i_tt_5_suc (35, 2)
1505 fc_i_tt_5_suc
1506 include/show_binlog_events.inc
1507 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
1508 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1509 INSERT INTO tt_1(trans_id, stmt_id) VALUES (35, 4);
1510 include/show_binlog_events.inc
1511 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1512 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1513 COMMIT;
1514 include/show_binlog_events.inc
1515 Log_name Pos Event_type Server_id End_log_pos Info
1516 master-bin.000001 # Query # # BEGIN
1517 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1518 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1519 master-bin.000001 # Write_rows # # table_id: #
1520 master-bin.000001 # Write_rows # # table_id: #
1521 master-bin.000001 # Write_rows # # table_id: #
1522 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1523 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1524 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1525 master-bin.000001 # Xid # # COMMIT /* XID */
1526 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1527 -b-b-b-b-b-b-b-b-b-b-b- >> B T-func T C << -b-b-b-b-b-b-b-b-b-b-b-
1528 include/show_binlog_events.inc
1529 Log_name Pos Event_type Server_id End_log_pos Info
1530 master-bin.000001 # Query # # BEGIN
1531 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1532 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1533 master-bin.000001 # Write_rows # # table_id: #
1534 master-bin.000001 # Write_rows # # table_id: #
1535 master-bin.000001 # Write_rows # # table_id: #
1536 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1537 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1538 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1539 master-bin.000001 # Xid # # COMMIT /* XID */
1540 -e-e-e-e-e-e-e-e-e-e-e- >> B T-func T C << -e-e-e-e-e-e-e-e-e-e-e-
1541
1542 include/rpl_reconnect.inc
1543 START REPLICA;
1544 include/wait_for_slave_to_start.inc
1545
1546
1547
1548 STOP REPLICA SQL_THREAD;
1549 include/wait_for_slave_sql_to_stop.inc
1550 SET GLOBAL debug="d,crash_after_update_pos_before_apply";;
1551 FAILURE d,crash_after_update_pos_before_apply and OUTCOME O1
1552 rpl_mixing_engines.inc [commands=B T-proc T C]
1553 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1554 BEGIN;
1555 include/show_binlog_events.inc
1556 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1557 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
1558 CALL pc_i_tt_5_suc (36, 2);
1559 include/show_binlog_events.inc
1560 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
1561 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1562 INSERT INTO tt_1(trans_id, stmt_id) VALUES (36, 4);
1563 include/show_binlog_events.inc
1564 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1565 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1566 COMMIT;
1567 include/show_binlog_events.inc
1568 Log_name Pos Event_type Server_id End_log_pos Info
1569 master-bin.000001 # Query # # BEGIN
1570 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1571 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1572 master-bin.000001 # Write_rows # # table_id: #
1573 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1574 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1575 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1576 master-bin.000001 # Write_rows # # table_id: #
1577 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1578 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1579 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1580 master-bin.000001 # Xid # # COMMIT /* XID */
1581 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1582 -b-b-b-b-b-b-b-b-b-b-b- >> B T-proc T C << -b-b-b-b-b-b-b-b-b-b-b-
1583 include/show_binlog_events.inc
1584 Log_name Pos Event_type Server_id End_log_pos Info
1585 master-bin.000001 # Query # # BEGIN
1586 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1587 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1588 master-bin.000001 # Write_rows # # table_id: #
1589 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1590 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1591 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1592 master-bin.000001 # Write_rows # # table_id: #
1593 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1594 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1595 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1596 master-bin.000001 # Xid # # COMMIT /* XID */
1597 -e-e-e-e-e-e-e-e-e-e-e- >> B T-proc T C << -e-e-e-e-e-e-e-e-e-e-e-
1598
1599 include/rpl_reconnect.inc
1600 START REPLICA;
1601 include/wait_for_slave_to_start.inc
1602
1603
1604
1605 STOP REPLICA SQL_THREAD;
1606 include/wait_for_slave_sql_to_stop.inc
1607 SET GLOBAL debug="d,crash_after_commit_before_update_pos";;
1608 FAILURE d,crash_after_commit_before_update_pos and OUTCOME O2
1609 rpl_mixing_engines.inc [commands=T]
1610 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1611 INSERT INTO tt_1(trans_id, stmt_id) VALUES (37, 1);
1612 include/show_binlog_events.inc
1613 Log_name Pos Event_type Server_id End_log_pos Info
1614 master-bin.000001 # Query # # BEGIN
1615 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1616 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1617 master-bin.000001 # Xid # # COMMIT /* XID */
1618 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1619 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1620 include/show_binlog_events.inc
1621 Log_name Pos Event_type Server_id End_log_pos Info
1622 master-bin.000001 # Query # # BEGIN
1623 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1624 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1625 master-bin.000001 # Xid # # COMMIT /* XID */
1626 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1627
1628 include/rpl_reconnect.inc
1629 START REPLICA;
1630 include/wait_for_slave_to_start.inc
1631
1632
1633
1634 STOP REPLICA SQL_THREAD;
1635 include/wait_for_slave_sql_to_stop.inc
1636 SET GLOBAL debug="d,crash_after_commit_before_update_pos";;
1637 FAILURE d,crash_after_commit_before_update_pos and OUTCOME O2
1638 rpl_mixing_engines.inc [commands=T-trig]
1639 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
1640 INSERT INTO tt_5(trans_id, stmt_id) VALUES (38, 1);
1641 include/show_binlog_events.inc
1642 Log_name Pos Event_type Server_id End_log_pos Info
1643 master-bin.000001 # Query # # BEGIN
1644 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1645 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1646 master-bin.000001 # Write_rows # # table_id: #
1647 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1648 master-bin.000001 # Xid # # COMMIT /* XID */
1649 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
1650 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
1651 include/show_binlog_events.inc
1652 Log_name Pos Event_type Server_id End_log_pos Info
1653 master-bin.000001 # Query # # BEGIN
1654 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1655 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1656 master-bin.000001 # Write_rows # # table_id: #
1657 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1658 master-bin.000001 # Xid # # COMMIT /* XID */
1659 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
1660
1661 include/rpl_reconnect.inc
1662 START REPLICA;
1663 include/wait_for_slave_to_start.inc
1664
1665
1666
1667 STOP REPLICA SQL_THREAD;
1668 include/wait_for_slave_sql_to_stop.inc
1669 SET GLOBAL debug="d,crash_after_commit_before_update_pos";;
1670 FAILURE d,crash_after_commit_before_update_pos and OUTCOME O2
1671 rpl_mixing_engines.inc [commands=T-func]
1672 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
1673 SELECT fc_i_tt_5_suc (39, 1);
1674 fc_i_tt_5_suc (39, 1)
1675 fc_i_tt_5_suc
1676 include/show_binlog_events.inc
1677 Log_name Pos Event_type Server_id End_log_pos Info
1678 master-bin.000001 # Query # # BEGIN
1679 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1680 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1681 master-bin.000001 # Write_rows # # table_id: #
1682 master-bin.000001 # Write_rows # # table_id: #
1683 master-bin.000001 # Write_rows # # table_id: #
1684 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1685 master-bin.000001 # Xid # # COMMIT /* XID */
1686 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
1687 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
1688 include/show_binlog_events.inc
1689 Log_name Pos Event_type Server_id End_log_pos Info
1690 master-bin.000001 # Query # # BEGIN
1691 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1692 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1693 master-bin.000001 # Write_rows # # table_id: #
1694 master-bin.000001 # Write_rows # # table_id: #
1695 master-bin.000001 # Write_rows # # table_id: #
1696 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1697 master-bin.000001 # Xid # # COMMIT /* XID */
1698 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
1699
1700 include/rpl_reconnect.inc
1701 START REPLICA;
1702 include/wait_for_slave_to_start.inc
1703
1704
1705
1706 STOP REPLICA SQL_THREAD;
1707 include/wait_for_slave_sql_to_stop.inc
1708 SET GLOBAL debug="d,crash_after_commit_before_update_pos";;
1709 FAILURE d,crash_after_commit_before_update_pos and OUTCOME O2
1710 rpl_mixing_engines.inc [commands=T-proc]
1711 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
1712 CALL pc_i_tt_5_suc (40, 1);
1713 include/show_binlog_events.inc
1714 Log_name Pos Event_type Server_id End_log_pos Info
1715 master-bin.000001 # Query # # BEGIN
1716 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1717 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1718 master-bin.000001 # Write_rows # # table_id: #
1719 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1720 master-bin.000001 # Xid # # COMMIT /* XID */
1721 master-bin.000001 # Query # # BEGIN
1722 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1723 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1724 master-bin.000001 # Write_rows # # table_id: #
1725 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1726 master-bin.000001 # Xid # # COMMIT /* XID */
1727 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
1728 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
1729 include/show_binlog_events.inc
1730 Log_name Pos Event_type Server_id End_log_pos Info
1731 master-bin.000001 # Query # # BEGIN
1732 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1733 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1734 master-bin.000001 # Write_rows # # table_id: #
1735 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1736 master-bin.000001 # Xid # # COMMIT /* XID */
1737 master-bin.000001 # Query # # BEGIN
1738 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1739 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1740 master-bin.000001 # Write_rows # # table_id: #
1741 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1742 master-bin.000001 # Xid # # COMMIT /* XID */
1743 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
1744
1745 include/rpl_reconnect.inc
1746 START REPLICA;
1747 include/wait_for_slave_to_start.inc
1748
1749
1750
1751 STOP REPLICA SQL_THREAD;
1752 include/wait_for_slave_sql_to_stop.inc
1753 SET GLOBAL debug="d,crash_after_commit_before_update_pos";;
1754 FAILURE d,crash_after_commit_before_update_pos and OUTCOME O2
1755 rpl_mixing_engines.inc [commands=B T T-trig C]
1756 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1757 BEGIN;
1758 include/show_binlog_events.inc
1759 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1760 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1761 INSERT INTO tt_1(trans_id, stmt_id) VALUES (41, 2);
1762 include/show_binlog_events.inc
1763 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1764 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
1765 INSERT INTO tt_5(trans_id, stmt_id) VALUES (41, 4);
1766 include/show_binlog_events.inc
1767 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
1768 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1769 COMMIT;
1770 include/show_binlog_events.inc
1771 Log_name Pos Event_type Server_id End_log_pos Info
1772 master-bin.000001 # Query # # BEGIN
1773 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1774 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1775 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1776 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1777 master-bin.000001 # Write_rows # # table_id: #
1778 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1779 master-bin.000001 # Xid # # COMMIT /* XID */
1780 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1781 -b-b-b-b-b-b-b-b-b-b-b- >> B T T-trig C << -b-b-b-b-b-b-b-b-b-b-b-
1782 include/show_binlog_events.inc
1783 Log_name Pos Event_type Server_id End_log_pos Info
1784 master-bin.000001 # Query # # BEGIN
1785 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1786 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1787 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1788 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1789 master-bin.000001 # Write_rows # # table_id: #
1790 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1791 master-bin.000001 # Xid # # COMMIT /* XID */
1792 -e-e-e-e-e-e-e-e-e-e-e- >> B T T-trig C << -e-e-e-e-e-e-e-e-e-e-e-
1793
1794 include/rpl_reconnect.inc
1795 START REPLICA;
1796 include/wait_for_slave_to_start.inc
1797
1798
1799
1800 STOP REPLICA SQL_THREAD;
1801 include/wait_for_slave_sql_to_stop.inc
1802 SET GLOBAL debug="d,crash_after_commit_before_update_pos";;
1803 FAILURE d,crash_after_commit_before_update_pos and OUTCOME O2
1804 rpl_mixing_engines.inc [commands=B T T-func C]
1805 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1806 BEGIN;
1807 include/show_binlog_events.inc
1808 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1809 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1810 INSERT INTO tt_1(trans_id, stmt_id) VALUES (42, 2);
1811 include/show_binlog_events.inc
1812 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1813 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
1814 SELECT fc_i_tt_5_suc (42, 4);
1815 fc_i_tt_5_suc (42, 4)
1816 fc_i_tt_5_suc
1817 include/show_binlog_events.inc
1818 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
1819 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1820 COMMIT;
1821 include/show_binlog_events.inc
1822 Log_name Pos Event_type Server_id End_log_pos Info
1823 master-bin.000001 # Query # # BEGIN
1824 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1825 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1826 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1827 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1828 master-bin.000001 # Write_rows # # table_id: #
1829 master-bin.000001 # Write_rows # # table_id: #
1830 master-bin.000001 # Write_rows # # table_id: #
1831 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1832 master-bin.000001 # Xid # # COMMIT /* XID */
1833 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1834 -b-b-b-b-b-b-b-b-b-b-b- >> B T T-func C << -b-b-b-b-b-b-b-b-b-b-b-
1835 include/show_binlog_events.inc
1836 Log_name Pos Event_type Server_id End_log_pos Info
1837 master-bin.000001 # Query # # BEGIN
1838 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1839 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1840 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1841 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1842 master-bin.000001 # Write_rows # # table_id: #
1843 master-bin.000001 # Write_rows # # table_id: #
1844 master-bin.000001 # Write_rows # # table_id: #
1845 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1846 master-bin.000001 # Xid # # COMMIT /* XID */
1847 -e-e-e-e-e-e-e-e-e-e-e- >> B T T-func C << -e-e-e-e-e-e-e-e-e-e-e-
1848
1849 include/rpl_reconnect.inc
1850 START REPLICA;
1851 include/wait_for_slave_to_start.inc
1852
1853
1854
1855 STOP REPLICA SQL_THREAD;
1856 include/wait_for_slave_sql_to_stop.inc
1857 SET GLOBAL debug="d,crash_after_commit_before_update_pos";;
1858 FAILURE d,crash_after_commit_before_update_pos and OUTCOME O2
1859 rpl_mixing_engines.inc [commands=B T T-proc C]
1860 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1861 BEGIN;
1862 include/show_binlog_events.inc
1863 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1864 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1865 INSERT INTO tt_1(trans_id, stmt_id) VALUES (43, 2);
1866 include/show_binlog_events.inc
1867 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1868 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
1869 CALL pc_i_tt_5_suc (43, 4);
1870 include/show_binlog_events.inc
1871 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
1872 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1873 COMMIT;
1874 include/show_binlog_events.inc
1875 Log_name Pos Event_type Server_id End_log_pos Info
1876 master-bin.000001 # Query # # BEGIN
1877 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1878 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1879 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1880 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1881 master-bin.000001 # Write_rows # # table_id: #
1882 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1883 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1884 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1885 master-bin.000001 # Write_rows # # table_id: #
1886 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1887 master-bin.000001 # Xid # # COMMIT /* XID */
1888 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1889 -b-b-b-b-b-b-b-b-b-b-b- >> B T T-proc C << -b-b-b-b-b-b-b-b-b-b-b-
1890 include/show_binlog_events.inc
1891 Log_name Pos Event_type Server_id End_log_pos Info
1892 master-bin.000001 # Query # # BEGIN
1893 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1894 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1895 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1896 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1897 master-bin.000001 # Write_rows # # table_id: #
1898 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1899 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1900 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1901 master-bin.000001 # Write_rows # # table_id: #
1902 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1903 master-bin.000001 # Xid # # COMMIT /* XID */
1904 -e-e-e-e-e-e-e-e-e-e-e- >> B T T-proc C << -e-e-e-e-e-e-e-e-e-e-e-
1905
1906 include/rpl_reconnect.inc
1907 START REPLICA;
1908 include/wait_for_slave_to_start.inc
1909
1910
1911
1912 STOP REPLICA SQL_THREAD;
1913 include/wait_for_slave_sql_to_stop.inc
1914 SET GLOBAL debug="d,crash_after_commit_before_update_pos";;
1915 FAILURE d,crash_after_commit_before_update_pos and OUTCOME O2
1916 rpl_mixing_engines.inc [commands=B T-trig T C]
1917 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1918 BEGIN;
1919 include/show_binlog_events.inc
1920 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1921 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
1922 INSERT INTO tt_5(trans_id, stmt_id) VALUES (44, 2);
1923 include/show_binlog_events.inc
1924 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
1925 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1926 INSERT INTO tt_1(trans_id, stmt_id) VALUES (44, 4);
1927 include/show_binlog_events.inc
1928 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1929 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1930 COMMIT;
1931 include/show_binlog_events.inc
1932 Log_name Pos Event_type Server_id End_log_pos Info
1933 master-bin.000001 # Query # # BEGIN
1934 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1935 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1936 master-bin.000001 # Write_rows # # table_id: #
1937 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1938 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1939 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1940 master-bin.000001 # Xid # # COMMIT /* XID */
1941 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1942 -b-b-b-b-b-b-b-b-b-b-b- >> B T-trig T C << -b-b-b-b-b-b-b-b-b-b-b-
1943 include/show_binlog_events.inc
1944 Log_name Pos Event_type Server_id End_log_pos Info
1945 master-bin.000001 # Query # # BEGIN
1946 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1947 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1948 master-bin.000001 # Write_rows # # table_id: #
1949 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1950 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1951 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1952 master-bin.000001 # Xid # # COMMIT /* XID */
1953 -e-e-e-e-e-e-e-e-e-e-e- >> B T-trig T C << -e-e-e-e-e-e-e-e-e-e-e-
1954
1955 include/rpl_reconnect.inc
1956 START REPLICA;
1957 include/wait_for_slave_to_start.inc
1958
1959
1960
1961 STOP REPLICA SQL_THREAD;
1962 include/wait_for_slave_sql_to_stop.inc
1963 SET GLOBAL debug="d,crash_after_commit_before_update_pos";;
1964 FAILURE d,crash_after_commit_before_update_pos and OUTCOME O2
1965 rpl_mixing_engines.inc [commands=B T-func T C]
1966 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1967 BEGIN;
1968 include/show_binlog_events.inc
1969 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1970 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
1971 SELECT fc_i_tt_5_suc (45, 2);
1972 fc_i_tt_5_suc (45, 2)
1973 fc_i_tt_5_suc
1974 include/show_binlog_events.inc
1975 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
1976 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1977 INSERT INTO tt_1(trans_id, stmt_id) VALUES (45, 4);
1978 include/show_binlog_events.inc
1979 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1980 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1981 COMMIT;
1982 include/show_binlog_events.inc
1983 Log_name Pos Event_type Server_id End_log_pos Info
1984 master-bin.000001 # Query # # BEGIN
1985 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
1986 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
1987 master-bin.000001 # Write_rows # # table_id: #
1988 master-bin.000001 # Write_rows # # table_id: #
1989 master-bin.000001 # Write_rows # # table_id: #
1990 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1991 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
1992 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1993 master-bin.000001 # Xid # # COMMIT /* XID */
1994 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1995 -b-b-b-b-b-b-b-b-b-b-b- >> B T-func T C << -b-b-b-b-b-b-b-b-b-b-b-
1996 include/show_binlog_events.inc
1997 Log_name Pos Event_type Server_id End_log_pos Info
1998 master-bin.000001 # Query # # BEGIN
1999 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
2000 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
2001 master-bin.000001 # Write_rows # # table_id: #
2002 master-bin.000001 # Write_rows # # table_id: #
2003 master-bin.000001 # Write_rows # # table_id: #
2004 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
2005 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
2006 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
2007 master-bin.000001 # Xid # # COMMIT /* XID */
2008 -e-e-e-e-e-e-e-e-e-e-e- >> B T-func T C << -e-e-e-e-e-e-e-e-e-e-e-
2009
2010 include/rpl_reconnect.inc
2011 START REPLICA;
2012 include/wait_for_slave_to_start.inc
2013
2014
2015
2016 STOP REPLICA SQL_THREAD;
2017 include/wait_for_slave_sql_to_stop.inc
2018 SET GLOBAL debug="d,crash_after_commit_before_update_pos";;
2019 FAILURE d,crash_after_commit_before_update_pos and OUTCOME O2
2020 rpl_mixing_engines.inc [commands=B T-proc T C]
2021 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
2022 BEGIN;
2023 include/show_binlog_events.inc
2024 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
2025 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
2026 CALL pc_i_tt_5_suc (46, 2);
2027 include/show_binlog_events.inc
2028 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
2029 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
2030 INSERT INTO tt_1(trans_id, stmt_id) VALUES (46, 4);
2031 include/show_binlog_events.inc
2032 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
2033 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
2034 COMMIT;
2035 include/show_binlog_events.inc
2036 Log_name Pos Event_type Server_id End_log_pos Info
2037 master-bin.000001 # Query # # BEGIN
2038 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
2039 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
2040 master-bin.000001 # Write_rows # # table_id: #
2041 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
2042 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
2043 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
2044 master-bin.000001 # Write_rows # # table_id: #
2045 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
2046 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
2047 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
2048 master-bin.000001 # Xid # # COMMIT /* XID */
2049 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
2050 -b-b-b-b-b-b-b-b-b-b-b- >> B T-proc T C << -b-b-b-b-b-b-b-b-b-b-b-
2051 include/show_binlog_events.inc
2052 Log_name Pos Event_type Server_id End_log_pos Info
2053 master-bin.000001 # Query # # BEGIN
2054 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
2055 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
2056 master-bin.000001 # Write_rows # # table_id: #
2057 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
2058 master-bin.000001 # Table_map # # table_id: # (test.tt_5)
2059 master-bin.000001 # Table_map # # table_id: # (test.tt_6)
2060 master-bin.000001 # Write_rows # # table_id: #
2061 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
2062 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
2063 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
2064 master-bin.000001 # Xid # # COMMIT /* XID */
2065 -e-e-e-e-e-e-e-e-e-e-e- >> B T-proc T C << -e-e-e-e-e-e-e-e-e-e-e-
2066
2067 include/rpl_reconnect.inc
2068 START REPLICA;
2069 include/wait_for_slave_to_start.inc
2070 ###################################################################################
2071 # EXECUTE CASES CRASHING THE BEGIN/COMMIT
2072 ###################################################################################
2073
2074
2075
2076 STOP REPLICA SQL_THREAD;
2077 include/wait_for_slave_sql_to_stop.inc
2078 SET GLOBAL debug="d,crash_after_commit_and_update_pos";;
2079 FAILURE d,crash_after_commit_and_update_pos and OUTCOME O2
2080 rpl_mixing_engines.inc [commands=N]
2081 -b-b-b-b-b-b-b-b-b-b-b- >> N << -b-b-b-b-b-b-b-b-b-b-b-
2082 INSERT INTO nt_1(trans_id, stmt_id) VALUES (47, 1);
2083 include/show_binlog_events.inc
2084 Log_name Pos Event_type Server_id End_log_pos Info
2085 master-bin.000001 # Query # # BEGIN
2086 master-bin.000001 # Table_map # # table_id: # (test.nt_1)
2087 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
2088 master-bin.000001 # Query # # COMMIT
2089 -e-e-e-e-e-e-e-e-e-e-e- >> N << -e-e-e-e-e-e-e-e-e-e-e-
2090 -b-b-b-b-b-b-b-b-b-b-b- >> N << -b-b-b-b-b-b-b-b-b-b-b-
2091 include/show_binlog_events.inc
2092 Log_name Pos Event_type Server_id End_log_pos Info
2093 master-bin.000001 # Query # # BEGIN
2094 master-bin.000001 # Table_map # # table_id: # (test.nt_1)
2095 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
2096 master-bin.000001 # Query # # COMMIT
2097 -e-e-e-e-e-e-e-e-e-e-e- >> N << -e-e-e-e-e-e-e-e-e-e-e-
2098
2099 include/rpl_reconnect.inc
2100 START REPLICA;
2101 include/wait_for_slave_to_start.inc
2102
2103
2104
2105 STOP REPLICA SQL_THREAD;
2106 include/wait_for_slave_sql_to_stop.inc
2107 SET GLOBAL debug="d,crash_after_commit_and_update_pos";;
2108 FAILURE d,crash_after_commit_and_update_pos and OUTCOME O2
2109 rpl_mixing_engines.inc [commands=N-trig]
2110 -b-b-b-b-b-b-b-b-b-b-b- >> N-trig << -b-b-b-b-b-b-b-b-b-b-b-
2111 INSERT INTO nt_5(trans_id, stmt_id) VALUES (48, 1);
2112 include/show_binlog_events.inc
2113 Log_name Pos Event_type Server_id End_log_pos Info
2114 master-bin.000001 # Query # # BEGIN
2115 master-bin.000001 # Table_map # # table_id: # (test.nt_5)
2116 master-bin.000001 # Table_map # # table_id: # (test.nt_6)
2117 master-bin.000001 # Write_rows # # table_id: #
2118 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
2119 master-bin.000001 # Query # # COMMIT
2120 -e-e-e-e-e-e-e-e-e-e-e- >> N-trig << -e-e-e-e-e-e-e-e-e-e-e-
2121 -b-b-b-b-b-b-b-b-b-b-b- >> N-trig << -b-b-b-b-b-b-b-b-b-b-b-
2122 include/show_binlog_events.inc
2123 Log_name Pos Event_type Server_id End_log_pos Info
2124 master-bin.000001 # Query # # BEGIN
2125 master-bin.000001 # Table_map # # table_id: # (test.nt_5)
2126 master-bin.000001 # Table_map # # table_id: # (test.nt_6)
2127 master-bin.000001 # Write_rows # # table_id: #
2128 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
2129 master-bin.000001 # Query # # COMMIT
2130 -e-e-e-e-e-e-e-e-e-e-e- >> N-trig << -e-e-e-e-e-e-e-e-e-e-e-
2131
2132 include/rpl_reconnect.inc
2133 START REPLICA;
2134 include/wait_for_slave_to_start.inc
2135
2136
2137
2138 STOP REPLICA SQL_THREAD;
2139 include/wait_for_slave_sql_to_stop.inc
2140 SET GLOBAL debug="d,crash_after_commit_and_update_pos";;
2141 FAILURE d,crash_after_commit_and_update_pos and OUTCOME O2
2142 rpl_mixing_engines.inc [commands=N-func]
2143 -b-b-b-b-b-b-b-b-b-b-b- >> N-func << -b-b-b-b-b-b-b-b-b-b-b-
2144 SELECT fc_i_nt_5_suc (49, 1);
2145 fc_i_nt_5_suc (49, 1)
2146 fc_i_nt_5_suc
2147 include/show_binlog_events.inc
2148 Log_name Pos Event_type Server_id End_log_pos Info
2149 master-bin.000001 # Query # # BEGIN
2150 master-bin.000001 # Table_map # # table_id: # (test.nt_5)
2151 master-bin.000001 # Table_map # # table_id: # (test.nt_6)
2152 master-bin.000001 # Write_rows # # table_id: #
2153 master-bin.000001 # Write_rows # # table_id: #
2154 master-bin.000001 # Write_rows # # table_id: #
2155 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
2156 master-bin.000001 # Query # # COMMIT
2157 -e-e-e-e-e-e-e-e-e-e-e- >> N-func << -e-e-e-e-e-e-e-e-e-e-e-
2158 -b-b-b-b-b-b-b-b-b-b-b- >> N-func << -b-b-b-b-b-b-b-b-b-b-b-
2159 include/show_binlog_events.inc
2160 Log_name Pos Event_type Server_id End_log_pos Info
2161 master-bin.000001 # Query # # BEGIN
2162 master-bin.000001 # Table_map # # table_id: # (test.nt_5)
2163 master-bin.000001 # Table_map # # table_id: # (test.nt_6)
2164 master-bin.000001 # Write_rows # # table_id: #
2165 master-bin.000001 # Write_rows # # table_id: #
2166 master-bin.000001 # Write_rows # # table_id: #
2167 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
2168 master-bin.000001 # Query # # COMMIT
2169 -e-e-e-e-e-e-e-e-e-e-e- >> N-func << -e-e-e-e-e-e-e-e-e-e-e-
2170
2171 include/rpl_reconnect.inc
2172 START REPLICA;
2173 include/wait_for_slave_to_start.inc
2174 ###################################################################################
2175 # CHECK CONSISTENCY
2176 ###################################################################################
2177 include/sync_slave_sql_with_master.inc
2178 ###################################################################################
2179 # CLEAN
2180 ###################################################################################
2181 rpl_mixing_engines.inc [commands=clean]
2182 DROP TABLE tt_1;
2183 DROP TABLE tt_2;
2184 DROP TABLE tt_3;
2185 DROP TABLE tt_4;
2186 DROP TABLE tt_5;
2187 DROP TABLE tt_6;
2188 DROP TABLE nt_1;
2189 DROP TABLE nt_2;
2190 DROP TABLE nt_3;
2191 DROP TABLE nt_4;
2192 DROP TABLE nt_5;
2193 DROP TABLE nt_6;
2194 DROP PROCEDURE pc_i_tt_5_suc;
2195 DROP PROCEDURE pc_i_nt_5_suc;
2196 DROP FUNCTION fc_i_tt_5_suc;
2197 DROP FUNCTION fc_i_nt_5_suc;
2198 DROP FUNCTION fc_i_nt_3_tt_3_suc;
2199 include/rpl_end.inc