Debian Codegraph @

mysql-test/suite/rpl/r/rpl_stm_mixed_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 ###################################################################################
7 # PREPARE EXECUTION
8 ###################################################################################
9 include/stop_slave.inc
10 SHOW CREATE TABLE mysql.slave_relay_log_info;
11 Table Create Table
12 slave_relay_log_info CREATE TABLE `slave_relay_log_info` (
13 `Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',
14 `Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the current relay log file.',
15 `Relay_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The relay log position of the last executed event.',
16 `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.',
17 `Master_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The master log position of the last executed event.',
18 `Sql_delay` int DEFAULT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',
19 `Number_of_workers` int unsigned DEFAULT NULL,
20 `Id` int unsigned DEFAULT NULL COMMENT 'Internal Id that uniquely identifies this record.',
21 `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',
22 `Privilege_checks_username` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'Username part of PRIVILEGE_CHECKS_USER.',
23 `Privilege_checks_hostname` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'Hostname part of PRIVILEGE_CHECKS_USER.',
24 `Require_row_format` tinyint(1) NOT NULL COMMENT 'Indicates whether the channel shall only accept row based events.',
25 `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',
26 `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',
27 `Assign_gtids_to_anonymous_transactions_value` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Indicates the UUID used while generating GTIDs for anonymous transactions',
28 PRIMARY KEY (`Channel_name`)
29 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Relay Log Information'
30 SHOW CREATE TABLE mysql.slave_worker_info;
31 Table Create Table
32 slave_worker_info CREATE TABLE `slave_worker_info` (
33 `Id` int unsigned NOT NULL,
34 `Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
35 `Relay_log_pos` bigint unsigned NOT NULL,
36 `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
37 `Master_log_pos` bigint unsigned NOT NULL,
38 `Checkpoint_relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
39 `Checkpoint_relay_log_pos` bigint unsigned NOT NULL,
40 `Checkpoint_master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
41 `Checkpoint_master_log_pos` bigint unsigned NOT NULL,
42 `Checkpoint_seqno` int unsigned NOT NULL,
43 `Checkpoint_group_size` int unsigned NOT NULL,
44 `Checkpoint_group_bitmap` blob NOT NULL,
45 `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',
46 PRIMARY KEY (`Channel_name`,`Id`)
47 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Worker Information'
48 ALTER TABLE mysql.slave_relay_log_info ENGINE= Innodb;
49 ALTER TABLE mysql.slave_worker_info ENGINE= Innodb;
50 SHOW CREATE TABLE mysql.slave_relay_log_info;
51 Table Create Table
52 slave_relay_log_info CREATE TABLE `slave_relay_log_info` (
53 `Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',
54 `Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the current relay log file.',
55 `Relay_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The relay log position of the last executed event.',
56 `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.',
57 `Master_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The master log position of the last executed event.',
58 `Sql_delay` int DEFAULT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',
59 `Number_of_workers` int unsigned DEFAULT NULL,
60 `Id` int unsigned DEFAULT NULL COMMENT 'Internal Id that uniquely identifies this record.',
61 `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',
62 `Privilege_checks_username` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'Username part of PRIVILEGE_CHECKS_USER.',
63 `Privilege_checks_hostname` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'Hostname part of PRIVILEGE_CHECKS_USER.',
64 `Require_row_format` tinyint(1) NOT NULL COMMENT 'Indicates whether the channel shall only accept row based events.',
65 `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',
66 `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',
67 `Assign_gtids_to_anonymous_transactions_value` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Indicates the UUID used while generating GTIDs for anonymous transactions',
68 PRIMARY KEY (`Channel_name`)
69 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Relay Log Information'
70 SHOW CREATE TABLE mysql.slave_worker_info;
71 Table Create Table
72 slave_worker_info CREATE TABLE `slave_worker_info` (
73 `Id` int unsigned NOT NULL,
74 `Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
75 `Relay_log_pos` bigint unsigned NOT NULL,
76 `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
77 `Master_log_pos` bigint unsigned NOT NULL,
78 `Checkpoint_relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
79 `Checkpoint_relay_log_pos` bigint unsigned NOT NULL,
80 `Checkpoint_master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
81 `Checkpoint_master_log_pos` bigint unsigned NOT NULL,
82 `Checkpoint_seqno` int unsigned NOT NULL,
83 `Checkpoint_group_size` int unsigned NOT NULL,
84 `Checkpoint_group_bitmap` blob NOT NULL,
85 `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',
86 PRIMARY KEY (`Channel_name`,`Id`)
87 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Worker Information'
88 include/start_slave.inc
89 rpl_mixing_engines.inc [commands=configure]
90 CREATE TABLE nt_1 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
91 CREATE TABLE nt_2 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
92 CREATE TABLE nt_3 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
93 CREATE TABLE nt_4 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
94 CREATE TABLE nt_5 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
95 CREATE TABLE nt_6 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
96 CREATE TABLE tt_1 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = Innodb;
97 CREATE TABLE tt_2 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = Innodb;
98 CREATE TABLE tt_3 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = Innodb;
99 CREATE TABLE tt_4 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = Innodb;
100 CREATE TABLE tt_5 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = Innodb;
101 CREATE TABLE tt_6 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = Innodb;
102 INSERT INTO nt_1(trans_id, stmt_id) VALUES(1,1);
103 INSERT INTO nt_2(trans_id, stmt_id) VALUES(1,1);
104 INSERT INTO nt_3(trans_id, stmt_id) VALUES(1,1);
105 INSERT INTO nt_4(trans_id, stmt_id) VALUES(1,1);
106 INSERT INTO nt_5(trans_id, stmt_id) VALUES(1,1);
107 INSERT INTO nt_6(trans_id, stmt_id) VALUES(1,1);
108 INSERT INTO tt_1(trans_id, stmt_id) VALUES(1,1);
109 INSERT INTO tt_2(trans_id, stmt_id) VALUES(1,1);
110 INSERT INTO tt_3(trans_id, stmt_id) VALUES(1,1);
111 INSERT INTO tt_4(trans_id, stmt_id) VALUES(1,1);
112 INSERT INTO tt_5(trans_id, stmt_id) VALUES(1,1);
113 INSERT INTO tt_6(trans_id, stmt_id) VALUES(1,1);
114 CREATE PROCEDURE pc_i_tt_5_suc (IN p_trans_id INTEGER, IN p_stmt_id INTEGER)
115 BEGIN
116 DECLARE in_stmt_id INTEGER;
117 SELECT max(stmt_id) INTO in_stmt_id FROM tt_5 WHERE trans_id= p_trans_id;
118 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
119 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
120 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
121 END|
122 CREATE PROCEDURE pc_i_nt_5_suc (IN p_trans_id INTEGER, IN p_stmt_id INTEGER)
123 BEGIN
124 DECLARE in_stmt_id INTEGER;
125 SELECT max(stmt_id) INTO in_stmt_id FROM nt_5 WHERE trans_id= p_trans_id;
126 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
127 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
128 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
129 END|
130 CREATE FUNCTION fc_i_tt_5_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
131 BEGIN
132 DECLARE in_stmt_id INTEGER;
133 SELECT max(stmt_id) INTO in_stmt_id FROM tt_5 WHERE trans_id= p_trans_id;
134 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
135 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
136 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
137 RETURN "fc_i_tt_5_suc";
138 END|
139 CREATE FUNCTION fc_i_nt_5_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
140 BEGIN
141 DECLARE in_stmt_id INTEGER;
142 SELECT max(stmt_id) INTO in_stmt_id FROM nt_5 WHERE trans_id= p_trans_id;
143 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
144 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
145 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
146 RETURN "fc_i_nt_5_suc";
147 END|
148 CREATE FUNCTION fc_i_nt_3_tt_3_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
149 BEGIN
150 DECLARE in_stmt_id INTEGER;
151 SELECT max(stmt_id) INTO in_stmt_id FROM nt_3 WHERE trans_id= p_trans_id;
152 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
153 INSERT INTO nt_3(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
154 SELECT max(stmt_id) INTO in_stmt_id FROM tt_3 WHERE trans_id= p_trans_id;
155 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
156 INSERT INTO tt_3(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
157 RETURN "fc_i_nt_3_tt_3_suc";
158 END|
159 CREATE TRIGGER tr_i_tt_3_to_nt_3 AFTER INSERT ON tt_3 FOR EACH ROW
160 BEGIN
161 DECLARE in_stmt_id INTEGER;
162 SELECT max(stmt_id) INTO in_stmt_id FROM nt_3 WHERE trans_id= NEW.trans_id;
163 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
164 INSERT INTO nt_3(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
165 INSERT INTO nt_3(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
166 END|
167 CREATE TRIGGER tr_i_nt_4_to_tt_4 AFTER INSERT ON nt_4 FOR EACH ROW
168 BEGIN
169 DECLARE in_stmt_id INTEGER;
170 SELECT max(stmt_id) INTO in_stmt_id FROM tt_4 WHERE trans_id= NEW.trans_id;
171 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
172 INSERT INTO tt_4(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
173 INSERT INTO tt_4(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
174 END|
175 CREATE TRIGGER tr_i_tt_5_to_tt_6 AFTER INSERT ON tt_5 FOR EACH ROW
176 BEGIN
177 DECLARE in_stmt_id INTEGER;
178 SELECT max(stmt_id) INTO in_stmt_id FROM tt_6 WHERE trans_id= NEW.trans_id;
179 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id, 1), 1) INTO in_stmt_id;
180 INSERT INTO tt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
181 INSERT INTO tt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
182 END|
183 CREATE TRIGGER tr_i_nt_5_to_nt_6 AFTER INSERT ON nt_5 FOR EACH ROW
184 BEGIN
185 DECLARE in_stmt_id INTEGER;
186 SELECT max(stmt_id) INTO in_stmt_id FROM nt_6 WHERE trans_id= NEW.trans_id;
187 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
188 INSERT INTO nt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
189 INSERT INTO nt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
190 END|
191 ###################################################################################
192 # EXECUTE CASES CRASHING THE XID
193 ###################################################################################
194
195
196
197 STOP REPLICA SQL_THREAD;
198 include/wait_for_slave_sql_to_stop.inc
199 SET GLOBAL debug="d,crash_after_apply";;
200 FAILURE d,crash_after_apply and OUTCOME O2
201 rpl_mixing_engines.inc [commands=T]
202 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
203 INSERT INTO tt_1(trans_id, stmt_id) VALUES (7, 1);
204 include/show_binlog_events.inc
205 Log_name Pos Event_type Server_id End_log_pos Info
206 master-bin.000001 # Query # # BEGIN
207 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (7, 1)
208 master-bin.000001 # Xid # # COMMIT /* XID */
209 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
210 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
211 include/show_binlog_events.inc
212 Log_name Pos Event_type Server_id End_log_pos Info
213 master-bin.000001 # Query # # BEGIN
214 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (7, 1)
215 master-bin.000001 # Xid # # COMMIT /* XID */
216 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
217
218 include/rpl_reconnect.inc
219 START REPLICA;
220 include/wait_for_slave_to_start.inc
221
222
223
224 STOP REPLICA SQL_THREAD;
225 include/wait_for_slave_sql_to_stop.inc
226 SET GLOBAL debug="d,crash_after_apply";;
227 FAILURE d,crash_after_apply and OUTCOME O2
228 rpl_mixing_engines.inc [commands=T-trig]
229 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
230 INSERT INTO tt_5(trans_id, stmt_id) VALUES (8, 1);
231 include/show_binlog_events.inc
232 Log_name Pos Event_type Server_id End_log_pos Info
233 master-bin.000001 # Query # # BEGIN
234 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (8, 1)
235 master-bin.000001 # Xid # # COMMIT /* XID */
236 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
237 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
238 include/show_binlog_events.inc
239 Log_name Pos Event_type Server_id End_log_pos Info
240 master-bin.000001 # Query # # BEGIN
241 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (8, 1)
242 master-bin.000001 # Xid # # COMMIT /* XID */
243 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
244
245 include/rpl_reconnect.inc
246 START REPLICA;
247 include/wait_for_slave_to_start.inc
248
249
250
251 STOP REPLICA SQL_THREAD;
252 include/wait_for_slave_sql_to_stop.inc
253 SET GLOBAL debug="d,crash_after_apply";;
254 FAILURE d,crash_after_apply and OUTCOME O2
255 rpl_mixing_engines.inc [commands=T-func]
256 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
257 SELECT fc_i_tt_5_suc (9, 1);
258 fc_i_tt_5_suc (9, 1)
259 fc_i_tt_5_suc
260 include/show_binlog_events.inc
261 Log_name Pos Event_type Server_id End_log_pos Info
262 master-bin.000001 # Query # # BEGIN
263 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(9,1)
264 master-bin.000001 # Xid # # COMMIT /* XID */
265 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
266 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
267 include/show_binlog_events.inc
268 Log_name Pos Event_type Server_id End_log_pos Info
269 master-bin.000001 # Query # # BEGIN
270 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(9,1)
271 master-bin.000001 # Xid # # COMMIT /* XID */
272 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
273
274 include/rpl_reconnect.inc
275 START REPLICA;
276 include/wait_for_slave_to_start.inc
277
278
279
280 STOP REPLICA SQL_THREAD;
281 include/wait_for_slave_sql_to_stop.inc
282 SET GLOBAL debug="d,crash_after_apply";;
283 FAILURE d,crash_after_apply and OUTCOME O2
284 rpl_mixing_engines.inc [commands=T-proc]
285 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
286 CALL pc_i_tt_5_suc (10, 1);
287 include/show_binlog_events.inc
288 Log_name Pos Event_type Server_id End_log_pos Info
289 master-bin.000001 # Query # # BEGIN
290 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',10), NAME_CONST('in_stmt_id',1))
291 master-bin.000001 # Xid # # COMMIT /* XID */
292 master-bin.000001 # Query # # BEGIN
293 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',10), NAME_CONST('in_stmt_id',1) + 1)
294 master-bin.000001 # Xid # # COMMIT /* XID */
295 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
296 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
297 include/show_binlog_events.inc
298 Log_name Pos Event_type Server_id End_log_pos Info
299 master-bin.000001 # Query # # BEGIN
300 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',10), NAME_CONST('in_stmt_id',1))
301 master-bin.000001 # Xid # # COMMIT /* XID */
302 master-bin.000001 # Query # # BEGIN
303 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',10), NAME_CONST('in_stmt_id',1) + 1)
304 master-bin.000001 # Xid # # COMMIT /* XID */
305 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
306
307 include/rpl_reconnect.inc
308 START REPLICA;
309 include/wait_for_slave_to_start.inc
310
311
312
313 STOP REPLICA SQL_THREAD;
314 include/wait_for_slave_sql_to_stop.inc
315 SET GLOBAL debug="d,crash_after_apply";;
316 FAILURE d,crash_after_apply and OUTCOME O2
317 rpl_mixing_engines.inc [commands=B T T-trig C]
318 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
319 BEGIN;
320 include/show_binlog_events.inc
321 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
322 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
323 INSERT INTO tt_1(trans_id, stmt_id) VALUES (11, 2);
324 include/show_binlog_events.inc
325 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
326 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
327 INSERT INTO tt_5(trans_id, stmt_id) VALUES (11, 4);
328 include/show_binlog_events.inc
329 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
330 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
331 COMMIT;
332 include/show_binlog_events.inc
333 Log_name Pos Event_type Server_id End_log_pos Info
334 master-bin.000001 # Query # # BEGIN
335 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (11, 2)
336 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (11, 4)
337 master-bin.000001 # Xid # # COMMIT /* XID */
338 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
339 -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-
340 include/show_binlog_events.inc
341 Log_name Pos Event_type Server_id End_log_pos Info
342 master-bin.000001 # Query # # BEGIN
343 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (11, 2)
344 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (11, 4)
345 master-bin.000001 # Xid # # COMMIT /* XID */
346 -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-
347
348 include/rpl_reconnect.inc
349 START REPLICA;
350 include/wait_for_slave_to_start.inc
351
352
353
354 STOP REPLICA SQL_THREAD;
355 include/wait_for_slave_sql_to_stop.inc
356 SET GLOBAL debug="d,crash_after_apply";;
357 FAILURE d,crash_after_apply and OUTCOME O2
358 rpl_mixing_engines.inc [commands=B T T-func C]
359 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
360 BEGIN;
361 include/show_binlog_events.inc
362 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
363 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
364 INSERT INTO tt_1(trans_id, stmt_id) VALUES (12, 2);
365 include/show_binlog_events.inc
366 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
367 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
368 SELECT fc_i_tt_5_suc (12, 4);
369 fc_i_tt_5_suc (12, 4)
370 fc_i_tt_5_suc
371 include/show_binlog_events.inc
372 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
373 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
374 COMMIT;
375 include/show_binlog_events.inc
376 Log_name Pos Event_type Server_id End_log_pos Info
377 master-bin.000001 # Query # # BEGIN
378 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (12, 2)
379 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(12,4)
380 master-bin.000001 # Xid # # COMMIT /* XID */
381 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
382 -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-
383 include/show_binlog_events.inc
384 Log_name Pos Event_type Server_id End_log_pos Info
385 master-bin.000001 # Query # # BEGIN
386 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (12, 2)
387 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(12,4)
388 master-bin.000001 # Xid # # COMMIT /* XID */
389 -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-
390
391 include/rpl_reconnect.inc
392 START REPLICA;
393 include/wait_for_slave_to_start.inc
394
395
396
397 STOP REPLICA SQL_THREAD;
398 include/wait_for_slave_sql_to_stop.inc
399 SET GLOBAL debug="d,crash_after_apply";;
400 FAILURE d,crash_after_apply and OUTCOME O2
401 rpl_mixing_engines.inc [commands=B T T-proc C]
402 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
403 BEGIN;
404 include/show_binlog_events.inc
405 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
406 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
407 INSERT INTO tt_1(trans_id, stmt_id) VALUES (13, 2);
408 include/show_binlog_events.inc
409 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
410 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
411 CALL pc_i_tt_5_suc (13, 4);
412 include/show_binlog_events.inc
413 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
414 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
415 COMMIT;
416 include/show_binlog_events.inc
417 Log_name Pos Event_type Server_id End_log_pos Info
418 master-bin.000001 # Query # # BEGIN
419 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (13, 2)
420 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',13), NAME_CONST('in_stmt_id',1))
421 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',13), NAME_CONST('in_stmt_id',1) + 1)
422 master-bin.000001 # Xid # # COMMIT /* XID */
423 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
424 -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-
425 include/show_binlog_events.inc
426 Log_name Pos Event_type Server_id End_log_pos Info
427 master-bin.000001 # Query # # BEGIN
428 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (13, 2)
429 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',13), NAME_CONST('in_stmt_id',1))
430 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',13), NAME_CONST('in_stmt_id',1) + 1)
431 master-bin.000001 # Xid # # COMMIT /* XID */
432 -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-
433
434 include/rpl_reconnect.inc
435 START REPLICA;
436 include/wait_for_slave_to_start.inc
437
438
439
440 STOP REPLICA SQL_THREAD;
441 include/wait_for_slave_sql_to_stop.inc
442 SET GLOBAL debug="d,crash_after_apply";;
443 FAILURE d,crash_after_apply and OUTCOME O2
444 rpl_mixing_engines.inc [commands=B T-trig T C]
445 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
446 BEGIN;
447 include/show_binlog_events.inc
448 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
449 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
450 INSERT INTO tt_5(trans_id, stmt_id) VALUES (14, 2);
451 include/show_binlog_events.inc
452 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
453 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
454 INSERT INTO tt_1(trans_id, stmt_id) VALUES (14, 4);
455 include/show_binlog_events.inc
456 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
457 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
458 COMMIT;
459 include/show_binlog_events.inc
460 Log_name Pos Event_type Server_id End_log_pos Info
461 master-bin.000001 # Query # # BEGIN
462 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (14, 2)
463 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (14, 4)
464 master-bin.000001 # Xid # # COMMIT /* XID */
465 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
466 -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-
467 include/show_binlog_events.inc
468 Log_name Pos Event_type Server_id End_log_pos Info
469 master-bin.000001 # Query # # BEGIN
470 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (14, 2)
471 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (14, 4)
472 master-bin.000001 # Xid # # COMMIT /* XID */
473 -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-
474
475 include/rpl_reconnect.inc
476 START REPLICA;
477 include/wait_for_slave_to_start.inc
478
479
480
481 STOP REPLICA SQL_THREAD;
482 include/wait_for_slave_sql_to_stop.inc
483 SET GLOBAL debug="d,crash_after_apply";;
484 FAILURE d,crash_after_apply and OUTCOME O2
485 rpl_mixing_engines.inc [commands=B T-func T C]
486 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
487 BEGIN;
488 include/show_binlog_events.inc
489 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
490 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
491 SELECT fc_i_tt_5_suc (15, 2);
492 fc_i_tt_5_suc (15, 2)
493 fc_i_tt_5_suc
494 include/show_binlog_events.inc
495 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
496 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
497 INSERT INTO tt_1(trans_id, stmt_id) VALUES (15, 4);
498 include/show_binlog_events.inc
499 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
500 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
501 COMMIT;
502 include/show_binlog_events.inc
503 Log_name Pos Event_type Server_id End_log_pos Info
504 master-bin.000001 # Query # # BEGIN
505 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(15,2)
506 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (15, 4)
507 master-bin.000001 # Xid # # COMMIT /* XID */
508 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
509 -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-
510 include/show_binlog_events.inc
511 Log_name Pos Event_type Server_id End_log_pos Info
512 master-bin.000001 # Query # # BEGIN
513 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(15,2)
514 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (15, 4)
515 master-bin.000001 # Xid # # COMMIT /* XID */
516 -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-
517
518 include/rpl_reconnect.inc
519 START REPLICA;
520 include/wait_for_slave_to_start.inc
521
522
523
524 STOP REPLICA SQL_THREAD;
525 include/wait_for_slave_sql_to_stop.inc
526 SET GLOBAL debug="d,crash_after_apply";;
527 FAILURE d,crash_after_apply and OUTCOME O2
528 rpl_mixing_engines.inc [commands=B T-proc T C]
529 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
530 BEGIN;
531 include/show_binlog_events.inc
532 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
533 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
534 CALL pc_i_tt_5_suc (16, 2);
535 include/show_binlog_events.inc
536 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
537 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
538 INSERT INTO tt_1(trans_id, stmt_id) VALUES (16, 4);
539 include/show_binlog_events.inc
540 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
541 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
542 COMMIT;
543 include/show_binlog_events.inc
544 Log_name Pos Event_type Server_id End_log_pos Info
545 master-bin.000001 # Query # # BEGIN
546 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',16), NAME_CONST('in_stmt_id',1))
547 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',16), NAME_CONST('in_stmt_id',1) + 1)
548 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (16, 4)
549 master-bin.000001 # Xid # # COMMIT /* XID */
550 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
551 -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-
552 include/show_binlog_events.inc
553 Log_name Pos Event_type Server_id End_log_pos Info
554 master-bin.000001 # Query # # BEGIN
555 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',16), NAME_CONST('in_stmt_id',1))
556 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',16), NAME_CONST('in_stmt_id',1) + 1)
557 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (16, 4)
558 master-bin.000001 # Xid # # COMMIT /* XID */
559 -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-
560
561 include/rpl_reconnect.inc
562 START REPLICA;
563 include/wait_for_slave_to_start.inc
564
565
566
567 STOP REPLICA SQL_THREAD;
568 include/wait_for_slave_sql_to_stop.inc
569 SET GLOBAL debug="d,crash_before_update_pos";;
570 FAILURE d,crash_before_update_pos and OUTCOME O1
571 rpl_mixing_engines.inc [commands=T]
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 (17, 1);
574 include/show_binlog_events.inc
575 Log_name Pos Event_type Server_id End_log_pos Info
576 master-bin.000001 # Query # # BEGIN
577 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (17, 1)
578 master-bin.000001 # Xid # # COMMIT /* XID */
579 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
580 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
581 include/show_binlog_events.inc
582 Log_name Pos Event_type Server_id End_log_pos Info
583 master-bin.000001 # Query # # BEGIN
584 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (17, 1)
585 master-bin.000001 # Xid # # COMMIT /* XID */
586 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
587
588 include/rpl_reconnect.inc
589 START REPLICA;
590 include/wait_for_slave_to_start.inc
591
592
593
594 STOP REPLICA SQL_THREAD;
595 include/wait_for_slave_sql_to_stop.inc
596 SET GLOBAL debug="d,crash_before_update_pos";;
597 FAILURE d,crash_before_update_pos and OUTCOME O1
598 rpl_mixing_engines.inc [commands=T-trig]
599 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
600 INSERT INTO tt_5(trans_id, stmt_id) VALUES (18, 1);
601 include/show_binlog_events.inc
602 Log_name Pos Event_type Server_id End_log_pos Info
603 master-bin.000001 # Query # # BEGIN
604 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (18, 1)
605 master-bin.000001 # Xid # # COMMIT /* XID */
606 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
607 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
608 include/show_binlog_events.inc
609 Log_name Pos Event_type Server_id End_log_pos Info
610 master-bin.000001 # Query # # BEGIN
611 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (18, 1)
612 master-bin.000001 # Xid # # COMMIT /* XID */
613 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
614
615 include/rpl_reconnect.inc
616 START REPLICA;
617 include/wait_for_slave_to_start.inc
618
619
620
621 STOP REPLICA SQL_THREAD;
622 include/wait_for_slave_sql_to_stop.inc
623 SET GLOBAL debug="d,crash_before_update_pos";;
624 FAILURE d,crash_before_update_pos and OUTCOME O1
625 rpl_mixing_engines.inc [commands=T-func]
626 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
627 SELECT fc_i_tt_5_suc (19, 1);
628 fc_i_tt_5_suc (19, 1)
629 fc_i_tt_5_suc
630 include/show_binlog_events.inc
631 Log_name Pos Event_type Server_id End_log_pos Info
632 master-bin.000001 # Query # # BEGIN
633 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(19,1)
634 master-bin.000001 # Xid # # COMMIT /* XID */
635 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
636 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
637 include/show_binlog_events.inc
638 Log_name Pos Event_type Server_id End_log_pos Info
639 master-bin.000001 # Query # # BEGIN
640 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(19,1)
641 master-bin.000001 # Xid # # COMMIT /* XID */
642 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
643
644 include/rpl_reconnect.inc
645 START REPLICA;
646 include/wait_for_slave_to_start.inc
647
648
649
650 STOP REPLICA SQL_THREAD;
651 include/wait_for_slave_sql_to_stop.inc
652 SET GLOBAL debug="d,crash_before_update_pos";;
653 FAILURE d,crash_before_update_pos and OUTCOME O1
654 rpl_mixing_engines.inc [commands=T-proc]
655 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
656 CALL pc_i_tt_5_suc (20, 1);
657 include/show_binlog_events.inc
658 Log_name Pos Event_type Server_id End_log_pos Info
659 master-bin.000001 # Query # # BEGIN
660 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',20), NAME_CONST('in_stmt_id',1))
661 master-bin.000001 # Xid # # COMMIT /* XID */
662 master-bin.000001 # Query # # BEGIN
663 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',20), NAME_CONST('in_stmt_id',1) + 1)
664 master-bin.000001 # Xid # # COMMIT /* XID */
665 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
666 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
667 include/show_binlog_events.inc
668 Log_name Pos Event_type Server_id End_log_pos Info
669 master-bin.000001 # Query # # BEGIN
670 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',20), NAME_CONST('in_stmt_id',1))
671 master-bin.000001 # Xid # # COMMIT /* XID */
672 master-bin.000001 # Query # # BEGIN
673 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',20), NAME_CONST('in_stmt_id',1) + 1)
674 master-bin.000001 # Xid # # COMMIT /* XID */
675 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
676
677 include/rpl_reconnect.inc
678 START REPLICA;
679 include/wait_for_slave_to_start.inc
680
681
682
683 STOP REPLICA SQL_THREAD;
684 include/wait_for_slave_sql_to_stop.inc
685 SET GLOBAL debug="d,crash_before_update_pos";;
686 FAILURE d,crash_before_update_pos and OUTCOME O1
687 rpl_mixing_engines.inc [commands=B T T-trig C]
688 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
689 BEGIN;
690 include/show_binlog_events.inc
691 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
692 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
693 INSERT INTO tt_1(trans_id, stmt_id) VALUES (21, 2);
694 include/show_binlog_events.inc
695 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
696 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
697 INSERT INTO tt_5(trans_id, stmt_id) VALUES (21, 4);
698 include/show_binlog_events.inc
699 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
700 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
701 COMMIT;
702 include/show_binlog_events.inc
703 Log_name Pos Event_type Server_id End_log_pos Info
704 master-bin.000001 # Query # # BEGIN
705 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (21, 2)
706 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (21, 4)
707 master-bin.000001 # Xid # # COMMIT /* XID */
708 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
709 -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-
710 include/show_binlog_events.inc
711 Log_name Pos Event_type Server_id End_log_pos Info
712 master-bin.000001 # Query # # BEGIN
713 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (21, 2)
714 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (21, 4)
715 master-bin.000001 # Xid # # COMMIT /* XID */
716 -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-
717
718 include/rpl_reconnect.inc
719 START REPLICA;
720 include/wait_for_slave_to_start.inc
721
722
723
724 STOP REPLICA SQL_THREAD;
725 include/wait_for_slave_sql_to_stop.inc
726 SET GLOBAL debug="d,crash_before_update_pos";;
727 FAILURE d,crash_before_update_pos and OUTCOME O1
728 rpl_mixing_engines.inc [commands=B T T-func C]
729 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
730 BEGIN;
731 include/show_binlog_events.inc
732 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
733 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
734 INSERT INTO tt_1(trans_id, stmt_id) VALUES (22, 2);
735 include/show_binlog_events.inc
736 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
737 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
738 SELECT fc_i_tt_5_suc (22, 4);
739 fc_i_tt_5_suc (22, 4)
740 fc_i_tt_5_suc
741 include/show_binlog_events.inc
742 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
743 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
744 COMMIT;
745 include/show_binlog_events.inc
746 Log_name Pos Event_type Server_id End_log_pos Info
747 master-bin.000001 # Query # # BEGIN
748 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (22, 2)
749 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(22,4)
750 master-bin.000001 # Xid # # COMMIT /* XID */
751 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
752 -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-
753 include/show_binlog_events.inc
754 Log_name Pos Event_type Server_id End_log_pos Info
755 master-bin.000001 # Query # # BEGIN
756 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (22, 2)
757 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(22,4)
758 master-bin.000001 # Xid # # COMMIT /* XID */
759 -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-
760
761 include/rpl_reconnect.inc
762 START REPLICA;
763 include/wait_for_slave_to_start.inc
764
765
766
767 STOP REPLICA SQL_THREAD;
768 include/wait_for_slave_sql_to_stop.inc
769 SET GLOBAL debug="d,crash_before_update_pos";;
770 FAILURE d,crash_before_update_pos and OUTCOME O1
771 rpl_mixing_engines.inc [commands=B T T-proc C]
772 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
773 BEGIN;
774 include/show_binlog_events.inc
775 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
776 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
777 INSERT INTO tt_1(trans_id, stmt_id) VALUES (23, 2);
778 include/show_binlog_events.inc
779 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
780 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
781 CALL pc_i_tt_5_suc (23, 4);
782 include/show_binlog_events.inc
783 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
784 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
785 COMMIT;
786 include/show_binlog_events.inc
787 Log_name Pos Event_type Server_id End_log_pos Info
788 master-bin.000001 # Query # # BEGIN
789 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (23, 2)
790 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',23), NAME_CONST('in_stmt_id',1))
791 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',23), NAME_CONST('in_stmt_id',1) + 1)
792 master-bin.000001 # Xid # # COMMIT /* XID */
793 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
794 -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-
795 include/show_binlog_events.inc
796 Log_name Pos Event_type Server_id End_log_pos Info
797 master-bin.000001 # Query # # BEGIN
798 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (23, 2)
799 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',23), NAME_CONST('in_stmt_id',1))
800 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',23), NAME_CONST('in_stmt_id',1) + 1)
801 master-bin.000001 # Xid # # COMMIT /* XID */
802 -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-
803
804 include/rpl_reconnect.inc
805 START REPLICA;
806 include/wait_for_slave_to_start.inc
807
808
809
810 STOP REPLICA SQL_THREAD;
811 include/wait_for_slave_sql_to_stop.inc
812 SET GLOBAL debug="d,crash_before_update_pos";;
813 FAILURE d,crash_before_update_pos and OUTCOME O1
814 rpl_mixing_engines.inc [commands=B T-trig T C]
815 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
816 BEGIN;
817 include/show_binlog_events.inc
818 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
819 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
820 INSERT INTO tt_5(trans_id, stmt_id) VALUES (24, 2);
821 include/show_binlog_events.inc
822 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
823 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
824 INSERT INTO tt_1(trans_id, stmt_id) VALUES (24, 4);
825 include/show_binlog_events.inc
826 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
827 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
828 COMMIT;
829 include/show_binlog_events.inc
830 Log_name Pos Event_type Server_id End_log_pos Info
831 master-bin.000001 # Query # # BEGIN
832 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (24, 2)
833 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (24, 4)
834 master-bin.000001 # Xid # # COMMIT /* XID */
835 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
836 -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-
837 include/show_binlog_events.inc
838 Log_name Pos Event_type Server_id End_log_pos Info
839 master-bin.000001 # Query # # BEGIN
840 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (24, 2)
841 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (24, 4)
842 master-bin.000001 # Xid # # COMMIT /* XID */
843 -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-
844
845 include/rpl_reconnect.inc
846 START REPLICA;
847 include/wait_for_slave_to_start.inc
848
849
850
851 STOP REPLICA SQL_THREAD;
852 include/wait_for_slave_sql_to_stop.inc
853 SET GLOBAL debug="d,crash_before_update_pos";;
854 FAILURE d,crash_before_update_pos and OUTCOME O1
855 rpl_mixing_engines.inc [commands=B T-func T C]
856 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
857 BEGIN;
858 include/show_binlog_events.inc
859 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
860 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
861 SELECT fc_i_tt_5_suc (25, 2);
862 fc_i_tt_5_suc (25, 2)
863 fc_i_tt_5_suc
864 include/show_binlog_events.inc
865 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
866 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
867 INSERT INTO tt_1(trans_id, stmt_id) VALUES (25, 4);
868 include/show_binlog_events.inc
869 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
870 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
871 COMMIT;
872 include/show_binlog_events.inc
873 Log_name Pos Event_type Server_id End_log_pos Info
874 master-bin.000001 # Query # # BEGIN
875 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(25,2)
876 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (25, 4)
877 master-bin.000001 # Xid # # COMMIT /* XID */
878 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
879 -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-
880 include/show_binlog_events.inc
881 Log_name Pos Event_type Server_id End_log_pos Info
882 master-bin.000001 # Query # # BEGIN
883 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(25,2)
884 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (25, 4)
885 master-bin.000001 # Xid # # COMMIT /* XID */
886 -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-
887
888 include/rpl_reconnect.inc
889 START REPLICA;
890 include/wait_for_slave_to_start.inc
891
892
893
894 STOP REPLICA SQL_THREAD;
895 include/wait_for_slave_sql_to_stop.inc
896 SET GLOBAL debug="d,crash_before_update_pos";;
897 FAILURE d,crash_before_update_pos and OUTCOME O1
898 rpl_mixing_engines.inc [commands=B T-proc T C]
899 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
900 BEGIN;
901 include/show_binlog_events.inc
902 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
903 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
904 CALL pc_i_tt_5_suc (26, 2);
905 include/show_binlog_events.inc
906 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
907 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
908 INSERT INTO tt_1(trans_id, stmt_id) VALUES (26, 4);
909 include/show_binlog_events.inc
910 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
911 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
912 COMMIT;
913 include/show_binlog_events.inc
914 Log_name Pos Event_type Server_id End_log_pos Info
915 master-bin.000001 # Query # # BEGIN
916 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',26), NAME_CONST('in_stmt_id',1))
917 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',26), NAME_CONST('in_stmt_id',1) + 1)
918 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (26, 4)
919 master-bin.000001 # Xid # # COMMIT /* XID */
920 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
921 -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-
922 include/show_binlog_events.inc
923 Log_name Pos Event_type Server_id End_log_pos Info
924 master-bin.000001 # Query # # BEGIN
925 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',26), NAME_CONST('in_stmt_id',1))
926 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',26), NAME_CONST('in_stmt_id',1) + 1)
927 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (26, 4)
928 master-bin.000001 # Xid # # COMMIT /* XID */
929 -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-
930
931 include/rpl_reconnect.inc
932 START REPLICA;
933 include/wait_for_slave_to_start.inc
934
935
936
937 STOP REPLICA SQL_THREAD;
938 include/wait_for_slave_sql_to_stop.inc
939 SET GLOBAL debug="d,crash_after_update_pos_before_apply";;
940 FAILURE d,crash_after_update_pos_before_apply and OUTCOME O1
941 rpl_mixing_engines.inc [commands=T]
942 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
943 INSERT INTO tt_1(trans_id, stmt_id) VALUES (27, 1);
944 include/show_binlog_events.inc
945 Log_name Pos Event_type Server_id End_log_pos Info
946 master-bin.000001 # Query # # BEGIN
947 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (27, 1)
948 master-bin.000001 # Xid # # COMMIT /* XID */
949 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
950 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
951 include/show_binlog_events.inc
952 Log_name Pos Event_type Server_id End_log_pos Info
953 master-bin.000001 # Query # # BEGIN
954 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (27, 1)
955 master-bin.000001 # Xid # # COMMIT /* XID */
956 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
957
958 include/rpl_reconnect.inc
959 START REPLICA;
960 include/wait_for_slave_to_start.inc
961
962
963
964 STOP REPLICA SQL_THREAD;
965 include/wait_for_slave_sql_to_stop.inc
966 SET GLOBAL debug="d,crash_after_update_pos_before_apply";;
967 FAILURE d,crash_after_update_pos_before_apply and OUTCOME O1
968 rpl_mixing_engines.inc [commands=T-trig]
969 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
970 INSERT INTO tt_5(trans_id, stmt_id) VALUES (28, 1);
971 include/show_binlog_events.inc
972 Log_name Pos Event_type Server_id End_log_pos Info
973 master-bin.000001 # Query # # BEGIN
974 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (28, 1)
975 master-bin.000001 # Xid # # COMMIT /* XID */
976 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
977 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
978 include/show_binlog_events.inc
979 Log_name Pos Event_type Server_id End_log_pos Info
980 master-bin.000001 # Query # # BEGIN
981 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (28, 1)
982 master-bin.000001 # Xid # # COMMIT /* XID */
983 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
984
985 include/rpl_reconnect.inc
986 START REPLICA;
987 include/wait_for_slave_to_start.inc
988
989
990
991 STOP REPLICA SQL_THREAD;
992 include/wait_for_slave_sql_to_stop.inc
993 SET GLOBAL debug="d,crash_after_update_pos_before_apply";;
994 FAILURE d,crash_after_update_pos_before_apply and OUTCOME O1
995 rpl_mixing_engines.inc [commands=T-func]
996 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
997 SELECT fc_i_tt_5_suc (29, 1);
998 fc_i_tt_5_suc (29, 1)
999 fc_i_tt_5_suc
1000 include/show_binlog_events.inc
1001 Log_name Pos Event_type Server_id End_log_pos Info
1002 master-bin.000001 # Query # # BEGIN
1003 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(29,1)
1004 master-bin.000001 # Xid # # COMMIT /* XID */
1005 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
1006 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -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 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(29,1)
1011 master-bin.000001 # Xid # # COMMIT /* XID */
1012 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
1013
1014 include/rpl_reconnect.inc
1015 START REPLICA;
1016 include/wait_for_slave_to_start.inc
1017
1018
1019
1020 STOP REPLICA SQL_THREAD;
1021 include/wait_for_slave_sql_to_stop.inc
1022 SET GLOBAL debug="d,crash_after_update_pos_before_apply";;
1023 FAILURE d,crash_after_update_pos_before_apply and OUTCOME O1
1024 rpl_mixing_engines.inc [commands=T-proc]
1025 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
1026 CALL pc_i_tt_5_suc (30, 1);
1027 include/show_binlog_events.inc
1028 Log_name Pos Event_type Server_id End_log_pos Info
1029 master-bin.000001 # Query # # BEGIN
1030 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',30), NAME_CONST('in_stmt_id',1))
1031 master-bin.000001 # Xid # # COMMIT /* XID */
1032 master-bin.000001 # Query # # BEGIN
1033 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',30), NAME_CONST('in_stmt_id',1) + 1)
1034 master-bin.000001 # Xid # # COMMIT /* XID */
1035 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
1036 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
1037 include/show_binlog_events.inc
1038 Log_name Pos Event_type Server_id End_log_pos Info
1039 master-bin.000001 # Query # # BEGIN
1040 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',30), NAME_CONST('in_stmt_id',1))
1041 master-bin.000001 # Xid # # COMMIT /* XID */
1042 master-bin.000001 # Query # # BEGIN
1043 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',30), NAME_CONST('in_stmt_id',1) + 1)
1044 master-bin.000001 # Xid # # COMMIT /* XID */
1045 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
1046
1047 include/rpl_reconnect.inc
1048 START REPLICA;
1049 include/wait_for_slave_to_start.inc
1050
1051
1052
1053 STOP REPLICA SQL_THREAD;
1054 include/wait_for_slave_sql_to_stop.inc
1055 SET GLOBAL debug="d,crash_after_update_pos_before_apply";;
1056 FAILURE d,crash_after_update_pos_before_apply and OUTCOME O1
1057 rpl_mixing_engines.inc [commands=B T T-trig C]
1058 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1059 BEGIN;
1060 include/show_binlog_events.inc
1061 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1062 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1063 INSERT INTO tt_1(trans_id, stmt_id) VALUES (31, 2);
1064 include/show_binlog_events.inc
1065 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1066 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
1067 INSERT INTO tt_5(trans_id, stmt_id) VALUES (31, 4);
1068 include/show_binlog_events.inc
1069 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
1070 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1071 COMMIT;
1072 include/show_binlog_events.inc
1073 Log_name Pos Event_type Server_id End_log_pos Info
1074 master-bin.000001 # Query # # BEGIN
1075 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (31, 2)
1076 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (31, 4)
1077 master-bin.000001 # Xid # # COMMIT /* XID */
1078 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1079 -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-
1080 include/show_binlog_events.inc
1081 Log_name Pos Event_type Server_id End_log_pos Info
1082 master-bin.000001 # Query # # BEGIN
1083 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (31, 2)
1084 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (31, 4)
1085 master-bin.000001 # Xid # # COMMIT /* XID */
1086 -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-
1087
1088 include/rpl_reconnect.inc
1089 START REPLICA;
1090 include/wait_for_slave_to_start.inc
1091
1092
1093
1094 STOP REPLICA SQL_THREAD;
1095 include/wait_for_slave_sql_to_stop.inc
1096 SET GLOBAL debug="d,crash_after_update_pos_before_apply";;
1097 FAILURE d,crash_after_update_pos_before_apply and OUTCOME O1
1098 rpl_mixing_engines.inc [commands=B T T-func C]
1099 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1100 BEGIN;
1101 include/show_binlog_events.inc
1102 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1103 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1104 INSERT INTO tt_1(trans_id, stmt_id) VALUES (32, 2);
1105 include/show_binlog_events.inc
1106 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1107 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
1108 SELECT fc_i_tt_5_suc (32, 4);
1109 fc_i_tt_5_suc (32, 4)
1110 fc_i_tt_5_suc
1111 include/show_binlog_events.inc
1112 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
1113 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1114 COMMIT;
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 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (32, 2)
1119 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(32,4)
1120 master-bin.000001 # Xid # # COMMIT /* XID */
1121 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1122 -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-
1123 include/show_binlog_events.inc
1124 Log_name Pos Event_type Server_id End_log_pos Info
1125 master-bin.000001 # Query # # BEGIN
1126 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (32, 2)
1127 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(32,4)
1128 master-bin.000001 # Xid # # COMMIT /* XID */
1129 -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-
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=B T T-proc C]
1142 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1143 BEGIN;
1144 include/show_binlog_events.inc
1145 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1146 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1147 INSERT INTO tt_1(trans_id, stmt_id) VALUES (33, 2);
1148 include/show_binlog_events.inc
1149 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1150 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
1151 CALL pc_i_tt_5_suc (33, 4);
1152 include/show_binlog_events.inc
1153 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
1154 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1155 COMMIT;
1156 include/show_binlog_events.inc
1157 Log_name Pos Event_type Server_id End_log_pos Info
1158 master-bin.000001 # Query # # BEGIN
1159 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (33, 2)
1160 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',33), NAME_CONST('in_stmt_id',1))
1161 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',33), NAME_CONST('in_stmt_id',1) + 1)
1162 master-bin.000001 # Xid # # COMMIT /* XID */
1163 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1164 -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-
1165 include/show_binlog_events.inc
1166 Log_name Pos Event_type Server_id End_log_pos Info
1167 master-bin.000001 # Query # # BEGIN
1168 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (33, 2)
1169 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',33), NAME_CONST('in_stmt_id',1))
1170 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',33), NAME_CONST('in_stmt_id',1) + 1)
1171 master-bin.000001 # Xid # # COMMIT /* XID */
1172 -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-
1173
1174 include/rpl_reconnect.inc
1175 START REPLICA;
1176 include/wait_for_slave_to_start.inc
1177
1178
1179
1180 STOP REPLICA SQL_THREAD;
1181 include/wait_for_slave_sql_to_stop.inc
1182 SET GLOBAL debug="d,crash_after_update_pos_before_apply";;
1183 FAILURE d,crash_after_update_pos_before_apply and OUTCOME O1
1184 rpl_mixing_engines.inc [commands=B T-trig T C]
1185 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1186 BEGIN;
1187 include/show_binlog_events.inc
1188 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1189 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
1190 INSERT INTO tt_5(trans_id, stmt_id) VALUES (34, 2);
1191 include/show_binlog_events.inc
1192 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
1193 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1194 INSERT INTO tt_1(trans_id, stmt_id) VALUES (34, 4);
1195 include/show_binlog_events.inc
1196 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1197 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1198 COMMIT;
1199 include/show_binlog_events.inc
1200 Log_name Pos Event_type Server_id End_log_pos Info
1201 master-bin.000001 # Query # # BEGIN
1202 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (34, 2)
1203 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (34, 4)
1204 master-bin.000001 # Xid # # COMMIT /* XID */
1205 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1206 -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-
1207 include/show_binlog_events.inc
1208 Log_name Pos Event_type Server_id End_log_pos Info
1209 master-bin.000001 # Query # # BEGIN
1210 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (34, 2)
1211 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (34, 4)
1212 master-bin.000001 # Xid # # COMMIT /* XID */
1213 -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-
1214
1215 include/rpl_reconnect.inc
1216 START REPLICA;
1217 include/wait_for_slave_to_start.inc
1218
1219
1220
1221 STOP REPLICA SQL_THREAD;
1222 include/wait_for_slave_sql_to_stop.inc
1223 SET GLOBAL debug="d,crash_after_update_pos_before_apply";;
1224 FAILURE d,crash_after_update_pos_before_apply and OUTCOME O1
1225 rpl_mixing_engines.inc [commands=B T-func T C]
1226 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1227 BEGIN;
1228 include/show_binlog_events.inc
1229 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1230 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
1231 SELECT fc_i_tt_5_suc (35, 2);
1232 fc_i_tt_5_suc (35, 2)
1233 fc_i_tt_5_suc
1234 include/show_binlog_events.inc
1235 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
1236 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1237 INSERT INTO tt_1(trans_id, stmt_id) VALUES (35, 4);
1238 include/show_binlog_events.inc
1239 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1240 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1241 COMMIT;
1242 include/show_binlog_events.inc
1243 Log_name Pos Event_type Server_id End_log_pos Info
1244 master-bin.000001 # Query # # BEGIN
1245 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(35,2)
1246 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (35, 4)
1247 master-bin.000001 # Xid # # COMMIT /* XID */
1248 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1249 -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-
1250 include/show_binlog_events.inc
1251 Log_name Pos Event_type Server_id End_log_pos Info
1252 master-bin.000001 # Query # # BEGIN
1253 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(35,2)
1254 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (35, 4)
1255 master-bin.000001 # Xid # # COMMIT /* XID */
1256 -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-
1257
1258 include/rpl_reconnect.inc
1259 START REPLICA;
1260 include/wait_for_slave_to_start.inc
1261
1262
1263
1264 STOP REPLICA SQL_THREAD;
1265 include/wait_for_slave_sql_to_stop.inc
1266 SET GLOBAL debug="d,crash_after_update_pos_before_apply";;
1267 FAILURE d,crash_after_update_pos_before_apply and OUTCOME O1
1268 rpl_mixing_engines.inc [commands=B T-proc T C]
1269 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1270 BEGIN;
1271 include/show_binlog_events.inc
1272 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1273 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
1274 CALL pc_i_tt_5_suc (36, 2);
1275 include/show_binlog_events.inc
1276 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
1277 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1278 INSERT INTO tt_1(trans_id, stmt_id) VALUES (36, 4);
1279 include/show_binlog_events.inc
1280 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1281 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1282 COMMIT;
1283 include/show_binlog_events.inc
1284 Log_name Pos Event_type Server_id End_log_pos Info
1285 master-bin.000001 # Query # # BEGIN
1286 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',36), NAME_CONST('in_stmt_id',1))
1287 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',36), NAME_CONST('in_stmt_id',1) + 1)
1288 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (36, 4)
1289 master-bin.000001 # Xid # # COMMIT /* XID */
1290 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1291 -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-
1292 include/show_binlog_events.inc
1293 Log_name Pos Event_type Server_id End_log_pos Info
1294 master-bin.000001 # Query # # BEGIN
1295 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',36), NAME_CONST('in_stmt_id',1))
1296 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',36), NAME_CONST('in_stmt_id',1) + 1)
1297 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (36, 4)
1298 master-bin.000001 # Xid # # COMMIT /* XID */
1299 -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-
1300
1301 include/rpl_reconnect.inc
1302 START REPLICA;
1303 include/wait_for_slave_to_start.inc
1304
1305
1306
1307 STOP REPLICA SQL_THREAD;
1308 include/wait_for_slave_sql_to_stop.inc
1309 SET GLOBAL debug="d,crash_after_commit_before_update_pos";;
1310 FAILURE d,crash_after_commit_before_update_pos and OUTCOME O2
1311 rpl_mixing_engines.inc [commands=T]
1312 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1313 INSERT INTO tt_1(trans_id, stmt_id) VALUES (37, 1);
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 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (37, 1)
1318 master-bin.000001 # Xid # # COMMIT /* XID */
1319 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1320 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1321 include/show_binlog_events.inc
1322 Log_name Pos Event_type Server_id End_log_pos Info
1323 master-bin.000001 # Query # # BEGIN
1324 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (37, 1)
1325 master-bin.000001 # Xid # # COMMIT /* XID */
1326 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1327
1328 include/rpl_reconnect.inc
1329 START REPLICA;
1330 include/wait_for_slave_to_start.inc
1331
1332
1333
1334 STOP REPLICA SQL_THREAD;
1335 include/wait_for_slave_sql_to_stop.inc
1336 SET GLOBAL debug="d,crash_after_commit_before_update_pos";;
1337 FAILURE d,crash_after_commit_before_update_pos and OUTCOME O2
1338 rpl_mixing_engines.inc [commands=T-trig]
1339 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
1340 INSERT INTO tt_5(trans_id, stmt_id) VALUES (38, 1);
1341 include/show_binlog_events.inc
1342 Log_name Pos Event_type Server_id End_log_pos Info
1343 master-bin.000001 # Query # # BEGIN
1344 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (38, 1)
1345 master-bin.000001 # Xid # # COMMIT /* XID */
1346 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
1347 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
1348 include/show_binlog_events.inc
1349 Log_name Pos Event_type Server_id End_log_pos Info
1350 master-bin.000001 # Query # # BEGIN
1351 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (38, 1)
1352 master-bin.000001 # Xid # # COMMIT /* XID */
1353 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
1354
1355 include/rpl_reconnect.inc
1356 START REPLICA;
1357 include/wait_for_slave_to_start.inc
1358
1359
1360
1361 STOP REPLICA SQL_THREAD;
1362 include/wait_for_slave_sql_to_stop.inc
1363 SET GLOBAL debug="d,crash_after_commit_before_update_pos";;
1364 FAILURE d,crash_after_commit_before_update_pos and OUTCOME O2
1365 rpl_mixing_engines.inc [commands=T-func]
1366 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
1367 SELECT fc_i_tt_5_suc (39, 1);
1368 fc_i_tt_5_suc (39, 1)
1369 fc_i_tt_5_suc
1370 include/show_binlog_events.inc
1371 Log_name Pos Event_type Server_id End_log_pos Info
1372 master-bin.000001 # Query # # BEGIN
1373 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(39,1)
1374 master-bin.000001 # Xid # # COMMIT /* XID */
1375 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
1376 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
1377 include/show_binlog_events.inc
1378 Log_name Pos Event_type Server_id End_log_pos Info
1379 master-bin.000001 # Query # # BEGIN
1380 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(39,1)
1381 master-bin.000001 # Xid # # COMMIT /* XID */
1382 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
1383
1384 include/rpl_reconnect.inc
1385 START REPLICA;
1386 include/wait_for_slave_to_start.inc
1387
1388
1389
1390 STOP REPLICA SQL_THREAD;
1391 include/wait_for_slave_sql_to_stop.inc
1392 SET GLOBAL debug="d,crash_after_commit_before_update_pos";;
1393 FAILURE d,crash_after_commit_before_update_pos and OUTCOME O2
1394 rpl_mixing_engines.inc [commands=T-proc]
1395 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
1396 CALL pc_i_tt_5_suc (40, 1);
1397 include/show_binlog_events.inc
1398 Log_name Pos Event_type Server_id End_log_pos Info
1399 master-bin.000001 # Query # # BEGIN
1400 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',40), NAME_CONST('in_stmt_id',1))
1401 master-bin.000001 # Xid # # COMMIT /* XID */
1402 master-bin.000001 # Query # # BEGIN
1403 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',40), NAME_CONST('in_stmt_id',1) + 1)
1404 master-bin.000001 # Xid # # COMMIT /* XID */
1405 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
1406 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
1407 include/show_binlog_events.inc
1408 Log_name Pos Event_type Server_id End_log_pos Info
1409 master-bin.000001 # Query # # BEGIN
1410 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',40), NAME_CONST('in_stmt_id',1))
1411 master-bin.000001 # Xid # # COMMIT /* XID */
1412 master-bin.000001 # Query # # BEGIN
1413 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',40), NAME_CONST('in_stmt_id',1) + 1)
1414 master-bin.000001 # Xid # # COMMIT /* XID */
1415 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
1416
1417 include/rpl_reconnect.inc
1418 START REPLICA;
1419 include/wait_for_slave_to_start.inc
1420
1421
1422
1423 STOP REPLICA SQL_THREAD;
1424 include/wait_for_slave_sql_to_stop.inc
1425 SET GLOBAL debug="d,crash_after_commit_before_update_pos";;
1426 FAILURE d,crash_after_commit_before_update_pos and OUTCOME O2
1427 rpl_mixing_engines.inc [commands=B T T-trig C]
1428 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1429 BEGIN;
1430 include/show_binlog_events.inc
1431 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1432 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1433 INSERT INTO tt_1(trans_id, stmt_id) VALUES (41, 2);
1434 include/show_binlog_events.inc
1435 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1436 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
1437 INSERT INTO tt_5(trans_id, stmt_id) VALUES (41, 4);
1438 include/show_binlog_events.inc
1439 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
1440 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1441 COMMIT;
1442 include/show_binlog_events.inc
1443 Log_name Pos Event_type Server_id End_log_pos Info
1444 master-bin.000001 # Query # # BEGIN
1445 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (41, 2)
1446 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (41, 4)
1447 master-bin.000001 # Xid # # COMMIT /* XID */
1448 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1449 -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-
1450 include/show_binlog_events.inc
1451 Log_name Pos Event_type Server_id End_log_pos Info
1452 master-bin.000001 # Query # # BEGIN
1453 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (41, 2)
1454 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (41, 4)
1455 master-bin.000001 # Xid # # COMMIT /* XID */
1456 -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-
1457
1458 include/rpl_reconnect.inc
1459 START REPLICA;
1460 include/wait_for_slave_to_start.inc
1461
1462
1463
1464 STOP REPLICA SQL_THREAD;
1465 include/wait_for_slave_sql_to_stop.inc
1466 SET GLOBAL debug="d,crash_after_commit_before_update_pos";;
1467 FAILURE d,crash_after_commit_before_update_pos and OUTCOME O2
1468 rpl_mixing_engines.inc [commands=B T T-func C]
1469 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1470 BEGIN;
1471 include/show_binlog_events.inc
1472 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1473 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1474 INSERT INTO tt_1(trans_id, stmt_id) VALUES (42, 2);
1475 include/show_binlog_events.inc
1476 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1477 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
1478 SELECT fc_i_tt_5_suc (42, 4);
1479 fc_i_tt_5_suc (42, 4)
1480 fc_i_tt_5_suc
1481 include/show_binlog_events.inc
1482 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
1483 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1484 COMMIT;
1485 include/show_binlog_events.inc
1486 Log_name Pos Event_type Server_id End_log_pos Info
1487 master-bin.000001 # Query # # BEGIN
1488 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (42, 2)
1489 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(42,4)
1490 master-bin.000001 # Xid # # COMMIT /* XID */
1491 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1492 -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-
1493 include/show_binlog_events.inc
1494 Log_name Pos Event_type Server_id End_log_pos Info
1495 master-bin.000001 # Query # # BEGIN
1496 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (42, 2)
1497 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(42,4)
1498 master-bin.000001 # Xid # # COMMIT /* XID */
1499 -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-
1500
1501 include/rpl_reconnect.inc
1502 START REPLICA;
1503 include/wait_for_slave_to_start.inc
1504
1505
1506
1507 STOP REPLICA SQL_THREAD;
1508 include/wait_for_slave_sql_to_stop.inc
1509 SET GLOBAL debug="d,crash_after_commit_before_update_pos";;
1510 FAILURE d,crash_after_commit_before_update_pos and OUTCOME O2
1511 rpl_mixing_engines.inc [commands=B T T-proc C]
1512 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1513 BEGIN;
1514 include/show_binlog_events.inc
1515 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1516 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1517 INSERT INTO tt_1(trans_id, stmt_id) VALUES (43, 2);
1518 include/show_binlog_events.inc
1519 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1520 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
1521 CALL pc_i_tt_5_suc (43, 4);
1522 include/show_binlog_events.inc
1523 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
1524 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1525 COMMIT;
1526 include/show_binlog_events.inc
1527 Log_name Pos Event_type Server_id End_log_pos Info
1528 master-bin.000001 # Query # # BEGIN
1529 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (43, 2)
1530 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',43), NAME_CONST('in_stmt_id',1))
1531 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',43), NAME_CONST('in_stmt_id',1) + 1)
1532 master-bin.000001 # Xid # # COMMIT /* XID */
1533 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1534 -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-
1535 include/show_binlog_events.inc
1536 Log_name Pos Event_type Server_id End_log_pos Info
1537 master-bin.000001 # Query # # BEGIN
1538 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (43, 2)
1539 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',43), NAME_CONST('in_stmt_id',1))
1540 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',43), NAME_CONST('in_stmt_id',1) + 1)
1541 master-bin.000001 # Xid # # COMMIT /* XID */
1542 -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-
1543
1544 include/rpl_reconnect.inc
1545 START REPLICA;
1546 include/wait_for_slave_to_start.inc
1547
1548
1549
1550 STOP REPLICA SQL_THREAD;
1551 include/wait_for_slave_sql_to_stop.inc
1552 SET GLOBAL debug="d,crash_after_commit_before_update_pos";;
1553 FAILURE d,crash_after_commit_before_update_pos and OUTCOME O2
1554 rpl_mixing_engines.inc [commands=B T-trig T C]
1555 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1556 BEGIN;
1557 include/show_binlog_events.inc
1558 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1559 -b-b-b-b-b-b-b-b-b-b-b- >> T-trig << -b-b-b-b-b-b-b-b-b-b-b-
1560 INSERT INTO tt_5(trans_id, stmt_id) VALUES (44, 2);
1561 include/show_binlog_events.inc
1562 -e-e-e-e-e-e-e-e-e-e-e- >> T-trig << -e-e-e-e-e-e-e-e-e-e-e-
1563 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1564 INSERT INTO tt_1(trans_id, stmt_id) VALUES (44, 4);
1565 include/show_binlog_events.inc
1566 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1567 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1568 COMMIT;
1569 include/show_binlog_events.inc
1570 Log_name Pos Event_type Server_id End_log_pos Info
1571 master-bin.000001 # Query # # BEGIN
1572 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (44, 2)
1573 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (44, 4)
1574 master-bin.000001 # Xid # # COMMIT /* XID */
1575 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1576 -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-
1577 include/show_binlog_events.inc
1578 Log_name Pos Event_type Server_id End_log_pos Info
1579 master-bin.000001 # Query # # BEGIN
1580 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES (44, 2)
1581 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (44, 4)
1582 master-bin.000001 # Xid # # COMMIT /* XID */
1583 -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-
1584
1585 include/rpl_reconnect.inc
1586 START REPLICA;
1587 include/wait_for_slave_to_start.inc
1588
1589
1590
1591 STOP REPLICA SQL_THREAD;
1592 include/wait_for_slave_sql_to_stop.inc
1593 SET GLOBAL debug="d,crash_after_commit_before_update_pos";;
1594 FAILURE d,crash_after_commit_before_update_pos and OUTCOME O2
1595 rpl_mixing_engines.inc [commands=B T-func T C]
1596 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1597 BEGIN;
1598 include/show_binlog_events.inc
1599 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1600 -b-b-b-b-b-b-b-b-b-b-b- >> T-func << -b-b-b-b-b-b-b-b-b-b-b-
1601 SELECT fc_i_tt_5_suc (45, 2);
1602 fc_i_tt_5_suc (45, 2)
1603 fc_i_tt_5_suc
1604 include/show_binlog_events.inc
1605 -e-e-e-e-e-e-e-e-e-e-e- >> T-func << -e-e-e-e-e-e-e-e-e-e-e-
1606 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1607 INSERT INTO tt_1(trans_id, stmt_id) VALUES (45, 4);
1608 include/show_binlog_events.inc
1609 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1610 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1611 COMMIT;
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 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(45,2)
1616 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (45, 4)
1617 master-bin.000001 # Xid # # COMMIT /* XID */
1618 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1619 -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-
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 # Query # # use `test`; SELECT `test`.`fc_i_tt_5_suc`(45,2)
1624 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (45, 4)
1625 master-bin.000001 # Xid # # COMMIT /* XID */
1626 -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-
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=B T-proc T C]
1639 -b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
1640 BEGIN;
1641 include/show_binlog_events.inc
1642 -e-e-e-e-e-e-e-e-e-e-e- >> B << -e-e-e-e-e-e-e-e-e-e-e-
1643 -b-b-b-b-b-b-b-b-b-b-b- >> T-proc << -b-b-b-b-b-b-b-b-b-b-b-
1644 CALL pc_i_tt_5_suc (46, 2);
1645 include/show_binlog_events.inc
1646 -e-e-e-e-e-e-e-e-e-e-e- >> T-proc << -e-e-e-e-e-e-e-e-e-e-e-
1647 -b-b-b-b-b-b-b-b-b-b-b- >> T << -b-b-b-b-b-b-b-b-b-b-b-
1648 INSERT INTO tt_1(trans_id, stmt_id) VALUES (46, 4);
1649 include/show_binlog_events.inc
1650 -e-e-e-e-e-e-e-e-e-e-e- >> T << -e-e-e-e-e-e-e-e-e-e-e-
1651 -b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
1652 COMMIT;
1653 include/show_binlog_events.inc
1654 Log_name Pos Event_type Server_id End_log_pos Info
1655 master-bin.000001 # Query # # BEGIN
1656 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',46), NAME_CONST('in_stmt_id',1))
1657 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',46), NAME_CONST('in_stmt_id',1) + 1)
1658 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (46, 4)
1659 master-bin.000001 # Xid # # COMMIT /* XID */
1660 -e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
1661 -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-
1662 include/show_binlog_events.inc
1663 Log_name Pos Event_type Server_id End_log_pos Info
1664 master-bin.000001 # Query # # BEGIN
1665 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',46), NAME_CONST('in_stmt_id',1))
1666 master-bin.000001 # Query # # use `test`; INSERT INTO tt_5(trans_id, stmt_id) VALUES ( NAME_CONST('p_trans_id',46), NAME_CONST('in_stmt_id',1) + 1)
1667 master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (46, 4)
1668 master-bin.000001 # Xid # # COMMIT /* XID */
1669 -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-
1670
1671 include/rpl_reconnect.inc
1672 START REPLICA;
1673 include/wait_for_slave_to_start.inc
1674 ###################################################################################
1675 # EXECUTE CASES CRASHING THE BEGIN/COMMIT
1676 ###################################################################################
1677
1678
1679
1680 STOP REPLICA SQL_THREAD;
1681 include/wait_for_slave_sql_to_stop.inc
1682 SET GLOBAL debug="d,crash_after_commit_and_update_pos";;
1683 FAILURE d,crash_after_commit_and_update_pos and OUTCOME O2
1684 rpl_mixing_engines.inc [commands=N]
1685 -b-b-b-b-b-b-b-b-b-b-b- >> N << -b-b-b-b-b-b-b-b-b-b-b-
1686 INSERT INTO nt_1(trans_id, stmt_id) VALUES (47, 1);
1687 include/show_binlog_events.inc
1688 Log_name Pos Event_type Server_id End_log_pos Info
1689 master-bin.000001 # Query # # BEGIN
1690 master-bin.000001 # Query # # use `test`; INSERT INTO nt_1(trans_id, stmt_id) VALUES (47, 1)
1691 master-bin.000001 # Query # # COMMIT
1692 -e-e-e-e-e-e-e-e-e-e-e- >> N << -e-e-e-e-e-e-e-e-e-e-e-
1693 -b-b-b-b-b-b-b-b-b-b-b- >> N << -b-b-b-b-b-b-b-b-b-b-b-
1694 include/show_binlog_events.inc
1695 Log_name Pos Event_type Server_id End_log_pos Info
1696 master-bin.000001 # Query # # BEGIN
1697 master-bin.000001 # Query # # use `test`; INSERT INTO nt_1(trans_id, stmt_id) VALUES (47, 1)
1698 master-bin.000001 # Query # # COMMIT
1699 -e-e-e-e-e-e-e-e-e-e-e- >> N << -e-e-e-e-e-e-e-e-e-e-e-
1700
1701 include/rpl_reconnect.inc
1702 START REPLICA;
1703 include/wait_for_slave_to_start.inc
1704
1705
1706
1707 STOP REPLICA SQL_THREAD;
1708 include/wait_for_slave_sql_to_stop.inc
1709 SET GLOBAL debug="d,crash_after_commit_and_update_pos";;
1710 FAILURE d,crash_after_commit_and_update_pos and OUTCOME O2
1711 rpl_mixing_engines.inc [commands=N-trig]
1712 -b-b-b-b-b-b-b-b-b-b-b- >> N-trig << -b-b-b-b-b-b-b-b-b-b-b-
1713 INSERT INTO nt_5(trans_id, stmt_id) VALUES (48, 1);
1714 include/show_binlog_events.inc
1715 Log_name Pos Event_type Server_id End_log_pos Info
1716 master-bin.000001 # Query # # BEGIN
1717 master-bin.000001 # Query # # use `test`; INSERT INTO nt_5(trans_id, stmt_id) VALUES (48, 1)
1718 master-bin.000001 # Query # # COMMIT
1719 -e-e-e-e-e-e-e-e-e-e-e- >> N-trig << -e-e-e-e-e-e-e-e-e-e-e-
1720 -b-b-b-b-b-b-b-b-b-b-b- >> N-trig << -b-b-b-b-b-b-b-b-b-b-b-
1721 include/show_binlog_events.inc
1722 Log_name Pos Event_type Server_id End_log_pos Info
1723 master-bin.000001 # Query # # BEGIN
1724 master-bin.000001 # Query # # use `test`; INSERT INTO nt_5(trans_id, stmt_id) VALUES (48, 1)
1725 master-bin.000001 # Query # # COMMIT
1726 -e-e-e-e-e-e-e-e-e-e-e- >> N-trig << -e-e-e-e-e-e-e-e-e-e-e-
1727
1728 include/rpl_reconnect.inc
1729 START REPLICA;
1730 include/wait_for_slave_to_start.inc
1731
1732
1733
1734 STOP REPLICA SQL_THREAD;
1735 include/wait_for_slave_sql_to_stop.inc
1736 SET GLOBAL debug="d,crash_after_commit_and_update_pos";;
1737 FAILURE d,crash_after_commit_and_update_pos and OUTCOME O2
1738 rpl_mixing_engines.inc [commands=N-func]
1739 -b-b-b-b-b-b-b-b-b-b-b- >> N-func << -b-b-b-b-b-b-b-b-b-b-b-
1740 SELECT fc_i_nt_5_suc (49, 1);
1741 fc_i_nt_5_suc (49, 1)
1742 fc_i_nt_5_suc
1743 include/show_binlog_events.inc
1744 Log_name Pos Event_type Server_id End_log_pos Info
1745 master-bin.000001 # Query # # BEGIN
1746 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_nt_5_suc`(49,1)
1747 master-bin.000001 # Query # # COMMIT
1748 -e-e-e-e-e-e-e-e-e-e-e- >> N-func << -e-e-e-e-e-e-e-e-e-e-e-
1749 -b-b-b-b-b-b-b-b-b-b-b- >> N-func << -b-b-b-b-b-b-b-b-b-b-b-
1750 include/show_binlog_events.inc
1751 Log_name Pos Event_type Server_id End_log_pos Info
1752 master-bin.000001 # Query # # BEGIN
1753 master-bin.000001 # Query # # use `test`; SELECT `test`.`fc_i_nt_5_suc`(49,1)
1754 master-bin.000001 # Query # # COMMIT
1755 -e-e-e-e-e-e-e-e-e-e-e- >> N-func << -e-e-e-e-e-e-e-e-e-e-e-
1756
1757 include/rpl_reconnect.inc
1758 START REPLICA;
1759 include/wait_for_slave_to_start.inc
1760 ###################################################################################
1761 # CHECK CONSISTENCY
1762 ###################################################################################
1763 include/sync_slave_sql_with_master.inc
1764 ###################################################################################
1765 # CLEAN
1766 ###################################################################################
1767 rpl_mixing_engines.inc [commands=clean]
1768 DROP TABLE tt_1;
1769 DROP TABLE tt_2;
1770 DROP TABLE tt_3;
1771 DROP TABLE tt_4;
1772 DROP TABLE tt_5;
1773 DROP TABLE tt_6;
1774 DROP TABLE nt_1;
1775 DROP TABLE nt_2;
1776 DROP TABLE nt_3;
1777 DROP TABLE nt_4;
1778 DROP TABLE nt_5;
1779 DROP TABLE nt_6;
1780 DROP PROCEDURE pc_i_tt_5_suc;
1781 DROP PROCEDURE pc_i_nt_5_suc;
1782 DROP FUNCTION fc_i_tt_5_suc;
1783 DROP FUNCTION fc_i_nt_5_suc;
1784 DROP FUNCTION fc_i_nt_3_tt_3_suc;
1785 include/rpl_end.inc