RSU-related-failure

Scenario 1 - failed
==========

On node 1:
create table t1(i int) engine=innodb;
insert into t1 values(1);
insert into t1 values(2);
insert into t1 values(3);

On node 2:
SET GLOBAL wsrep_OSU_method='RSU';
SET GLOBAL wsrep_cluster_address="gcomm://";
alter table t1 add j int;

On node 1:
delete from t1 where i >= 2;
select * from t1;

On node 2:
SET GLOBAL wsrep_cluster_address="gcomm://127.0.0.1:4000";
select * from t1;


Scenario 2 - failed
==========

On node 1:
create table t1(i int) engine=innodb;
insert into t1 values(1);
insert into t1 values(2);
insert into t1 values(3);

On node 2:
SET GLOBAL wsrep_OSU_method='RSU';
SET GLOBAL wsrep_cluster_address="gcomm://";
alter table t1 add j int;

On node 1:
delete from t1 where i > 2;
select * from t1;

On node 2:
SET GLOBAL wsrep_cluster_address="gcomm://127.0.0.1:4000";
select * from t1;


Scenario 3 - failed
==========

On node 1:
create table t1(i int) engine=innodb;
insert into t1 values(1);
insert into t1 values(2);
insert into t1 values(3);

On node 2:
SET GLOBAL wsrep_OSU_method='RSU';
SET GLOBAL wsrep_cluster_address="gcomm://";
alter table t1 add j int;

On node 1:
delete from t1 where i = 2;
select * from t1;

On node 2:
SET GLOBAL wsrep_cluster_address="gcomm://127.0.0.1:4000";
select * from t1;


Scenario 4 - failed
==========

On node 1:
create table t1(i int) engine=innodb;
insert into t1 values(1);
insert into t1 values(2);
insert into t1 values(3);

On node 2:
SET GLOBAL wsrep_cluster_address="gcomm://";
alter table t1 add j int;

On node 1:
delete from t1 where i = 2;
select * from t1;

On node 2:
SET GLOBAL wsrep_cluster_address="gcomm://127.0.0.1:4000";
select * from t1;


Scenario 5 - passed
==========

On node 1:
create table t1(i int) engine=innodb;
insert into t1 values(1);
insert into t1 values(2);
insert into t1 values(3);

On node 2:
SET SESSION wsrep_OSU_method='RSU';
alter table t1 add j int;

On node 1:
delete from t1 where i >= 2;
select * from t1;

On node 2:
select * from t1;