83 lines
2.6 KiB
Plaintext
83 lines
2.6 KiB
Plaintext
call mtr.add_suppression("The consensus follower is not allowed to to do current operation.");
|
|
create table t(id int);
|
|
insert into t values(0);
|
|
show master status;
|
|
File Position Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set
|
|
master-bin.000001 # #
|
|
select * from mysql.gtid_executed;
|
|
source_uuid interval_start interval_end
|
|
# 4 4
|
|
show master status;
|
|
File Position Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set
|
|
master-bin.000001 # #
|
|
select * from mysql.gtid_executed;
|
|
source_uuid interval_start interval_end
|
|
# 1 1
|
|
# 2 2
|
|
# 3 3
|
|
# 4 4
|
|
# 5 5
|
|
# 6 6
|
|
flush logs;
|
|
select * from mysql.gtid_executed;
|
|
source_uuid interval_start interval_end
|
|
# 1 6
|
|
drop table t;
|
|
create table t(id int);
|
|
insert into t values(0);
|
|
call dbms_consensus.change_leader("127.0.0.1:PAXOS_PORT_3");
|
|
insert into t values(1);
|
|
show master status;
|
|
File Position Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set
|
|
master-bin.000001 # #
|
|
call dbms_consensus.change_leader("127.0.0.1:PAXOS_PORT_1");;
|
|
show master status;
|
|
File Position Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set
|
|
master-bin.000002 # #
|
|
drop table t;
|
|
create table t(id int);
|
|
insert into t values(0);
|
|
set debug='+d,crash_commit_before';
|
|
insert into t values(1);
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
show master status;
|
|
File Position Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set
|
|
master-bin.000002 # #
|
|
drop table t;
|
|
create table t(c text);
|
|
insert into t values('kongzhi');
|
|
set global max_binlog_size=4096;
|
|
set debug="+d,simulate_leader_degrade_slow";
|
|
call dbms_consensus.change_leader("127.0.0.1:PAXOS_PORT_2");;
|
|
insert into t values(repeat('1', 1024));
|
|
insert into t values(repeat('1', 1024));
|
|
insert into t values(repeat('1', 1024));
|
|
show master status;
|
|
File Position Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set
|
|
master-bin.000001 # #
|
|
show master status;
|
|
File Position Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set
|
|
master-bin.000003 # #
|
|
show master status;
|
|
File Position Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set
|
|
master-bin.000003 # #
|
|
set global max_binlog_size=(1024 * 1024 * 1024);
|
|
drop table t;
|
|
call dbms_consensus.change_leader("127.0.0.1:PAXOS_PORT_1");
|
|
create table t(id int);
|
|
insert into t values(0);
|
|
show master status;
|
|
File Position Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set
|
|
master-bin.000003 # #
|
|
set global debug="+d, skip_consensus_fifo_cache";
|
|
set global debug="+d, crash_before_large_trx_commit_early";
|
|
insert into t values(1);
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
show master status;
|
|
File Position Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set
|
|
master-bin.000003 # #
|
|
flush logs;
|
|
insert into t values(2);
|
|
0
|
|
drop table t;
|