109 lines
3.7 KiB
Plaintext
109 lines
3.7 KiB
Plaintext
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="";
|