34 lines
1.1 KiB
Plaintext
34 lines
1.1 KiB
Plaintext
flush local logs;
|
|
flush local logs;
|
|
flush local logs;
|
|
create table t1 (id int);
|
|
insert into t1 values(1);
|
|
call dbms_consensus.downgrade_follower("127.0.0.1:MYPORT_CONSENSUS_3");
|
|
call dbms_consensus.drop_learner("127.0.0.1:MYPORT_CONSENSUS_3");
|
|
insert into t1 values(1);
|
|
call dbms_consensus.change_leader("127.0.0.1:MYPORT_CONSENSUS_2");
|
|
insert into t1 values(1);
|
|
call dbms_consensus.change_leader("127.0.0.1:MYPORT_CONSENSUS_1");
|
|
create table t2 (id int, data longblob);
|
|
begin;
|
|
insert into t2 values(1, repeat('a', 300*1024));
|
|
insert into t2 values(1, repeat('a', 300*1024));
|
|
insert into t2 values(1, repeat('a', 300*1024));
|
|
insert into t2 values(1, repeat('a', 300*1024));
|
|
commit;
|
|
insert into t2 values(1, repeat('a', 3*1024*1024));
|
|
insert into t1 values(1);
|
|
call dbms_consensus.add_learner("127.0.0.1:MYPORT_CONSENSUS_3");
|
|
call dbms_consensus.upgrade_learner("127.0.0.1:MYPORT_CONSENSUS_3");
|
|
insert into t1 values(1);
|
|
set global consensus_flow_control="127.0.0.1:MYPORT_CONSENSUS_3 -2";
|
|
shutdown;
|
|
insert into t1 values(1);
|
|
set global consensus_flow_control="";
|
|
insert into t1 values(1);
|
|
77290
|
|
77290
|
|
77290
|
|
drop table t1;
|
|
drop table t2;
|