| 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 |