flush local logs;
set global debug="+d,force_large_trx,force_large_trx_single_ev";
flush local logs;
set global debug="+d,force_large_trx,force_large_trx_single_ev";
flush local logs;
set global debug="+d,force_large_trx,force_large_trx_single_ev";
# --------- normal case ---------
use test;
create table t1 (id int);
insert into t1 values (1), (2), (3);
begin;
insert into t1 values (4);
insert into t1 values (5);
commit;
begin;
insert into t1 values (6);
insert into t1 values (7);
rollback;
consistent!!!!!!!
# --------- case 1 ---------
insert into t1 values (8);
set global debug="+d,crash_during_large_trx_binlog_flush";
insert into t1 values (9);
ERROR HY000: Lost connection to MySQL server during query
# restart
set global debug="+d,force_large_trx,force_large_trx_single_ev";
consistent!!!!!!!
# --------- case 2 ---------
insert into t1 values (10);
set global debug="+d,crash_before_large_trx_commit_early";
insert into t1 values (11);
ERROR HY000: Lost connection to MySQL server during query
# restart
set global debug="+d,force_large_trx,force_large_trx_single_ev";
consistent!!!!!!!
insert into t1 values (12);
set global debug="+d,crash_before_large_trx_commit_late";
insert into t1 values (13);
ERROR HY000: Lost connection to MySQL server during query
# restart
set global debug="+d,force_large_trx,force_large_trx_single_ev";
consistent!!!!!!!
# --------- case 3 ---------
insert into t1 values (14);
set global debug="+d,crash_before_update_pos";
insert into t1 values (15);
set global debug="+d,force_large_trx,force_large_trx_single_ev";
insert into t1 values (16);
consistent!!!!!!!
# --------- case 4 ---------
insert into t1 values (17);
set global debug="+d,crash_in_a_worker";
insert into t1 values (18);
set global debug="+d,force_large_trx,force_large_trx_single_ev";
insert into t1 values (19);
consistent!!!!!!!
# --------- case 5 ---------
insert into t1 values (20);
set global debug="+d,crash_after_commit_and_update_pos";
insert into t1 values (21);
set global debug="+d,force_large_trx,force_large_trx_single_ev";
insert into t1 values (22);
consistent!!!!!!!
# --------- case 6 ---------
insert into t1 values (23);
set global debug="+d,crash_after_update_pos_before_apply";
insert into t1 values (24);
set global debug="+d,force_large_trx,force_large_trx_single_ev";
insert into t1 values (25);
consistent!!!!!!!
# --------- case 7 ---------
insert into t1 values (26);
set global debug="+d,crash_after_apply";
insert into t1 values (27);
set global debug="+d,force_large_trx,force_large_trx_single_ev";
insert into t1 values (28);
consistent!!!!!!!
# --------- case 1.1 ---------
insert into t1 values (29);
set global debug="+d,crash_during_large_trx_binlog_flush_slow";
insert into t1 values (30);
ERROR HY000: Lost connection to MySQL server during query
# restart
set global debug="+d,force_large_trx,force_large_trx_single_ev";
consistent!!!!!!!
# --------- case 1.2 ---------
insert into t1 values (31);
set global debug="+d,crash_during_large_trx_binlog_flush2";
insert into t1 values (32);
ERROR HY000: Lost connection to MySQL server during query
# restart
set global debug="+d,force_large_trx,force_large_trx_single_ev";
consistent!!!!!!!
# --------- case large event ---------
insert into t1 values (100);
set global debug="+d,force_large_trx,force_large_trx_single_ev,force_large_event";
insert into t1 values (101);
ERROR HY000: Writing one row to the row-based binary log failed
set global debug="-d,force_large_event";
# --------- case flush ---------
SET debug_sync = "large_trx_sync_part WAIT_FOR continue";
insert into t1 values (102);
flush logs;
flush local logs;
ERROR HY000: The consensus follower is not allowed to to do current operation.
SET debug_sync = "now SIGNAL continue";
drop table t1;
set global debug="";