25 lines
508 B
Plaintext
25 lines
508 B
Plaintext
create table t1(id int);
|
|
xa begin 'xa1';
|
|
insert into t1 values (1000);
|
|
xa end 'xa1';
|
|
xa prepare 'xa1';
|
|
call dbms_consensus.change_leader("127.0.0.1:PAXOS_PORT_2");;
|
|
xa commit 'xa1';
|
|
xa recover;
|
|
formatID gtrid_length bqual_length data
|
|
select * from test.t1;
|
|
id
|
|
1000
|
|
xa recover;
|
|
formatID gtrid_length bqual_length data
|
|
select * from test.t1;
|
|
id
|
|
1000
|
|
call dbms_consensus.change_leader("127.0.0.1:PAXOS_PORT_1");;
|
|
xa recover;
|
|
formatID gtrid_length bqual_length data
|
|
select * from test.t1;
|
|
id
|
|
1000
|
|
drop table t1;
|