--source include/have_innodb.inc
--source include/master-slave.inc

create database slask;
create table slask.insert_error (id int, name varchar(255), primary key (id));
insert into slask.insert_error values (1, 'dude');
insert into slask.insert_error values (2, 'dude');
insert into slask.insert_error values (3, 'dude');
insert into slask.insert_error values (4, 'dude');
insert into slask.insert_error values (5, 'dude');
insert into slask.insert_error values (6, 'dude');
insert into slask.insert_error values (7, 'dude');
insert into slask.insert_error values (8, 'dude');
insert into slask.insert_error values (9, 'dude');
insert into slask.insert_error values (10, 'dude');

--sync_slave_with_master
delete from slask.insert_error where id = 7;

--connect(con1,localhost,root,,)
--connection master
XA START 'one'; 
insert ignore into slask.insert_error values (7, 'dude'); 
XA END 'one'; 
XA PREPARE 'one';

--connection con1
XA START 'two'; 
insert ignore into slask.insert_error values (7, 'dude'); 
XA END 'two'; 
XA PREPARE 'two';

--connection master
XA COMMIT 'one';

--connection con1
XA COMMIT 'two';

xa recover;

--connection slave
--sleep 65
--vertical_results
show slave status;
--horizontal_results
show processlist;

stop slave;
start slave;

--sleep 65
--vertical_results
show slave status;
--horizontal_results
show processlist;

select * from information_schema.innodb_lock_waits;
xa recover;

#--sync_slave_with_master
#--connection master
#drop database slask;
#--sync_slave_with_master