stop slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
CREATE TABLE `t1` ( `nid` int(11) NOT NULL default '0',
`nom` char(4) default NULL,
`prenom` char(4) default NULL,
PRIMARY KEY  (`nid`)) 
ENGINE=ndbcluster DEFAULT CHARSET=latin1;
INSERT INTO t1 VALUES(1,"XYZ1","ABC1");
select * from t1 order by nid;
nid	nom	prenom
1	XYZ1	ABC1
select * from t1 order by nid;
nid	nom	prenom
1	XYZ1	ABC1
delete from t1;
INSERT INTO t1 VALUES(1,"XYZ2","ABC2");
select * from t1 order by nid;
nid	nom	prenom
1	XYZ2	ABC2
select * from t1 order by nid;
nid	nom	prenom
1	XYZ2	ABC2
DROP table t1;
CREATE TABLE `t1` ( `nid` int(11) NOT NULL default '0',
`nom` char(4) default NULL,
`prenom` char(4) default NULL)
ENGINE=ndbcluster DEFAULT CHARSET=latin1;
INSERT INTO t1 VALUES(1,"XYZ1","ABC1"),(2,"AAA","BBB"),(3,"CCC","DDD");
select * from t1 order by nid;
nid	nom	prenom
1	XYZ1	ABC1
2	AAA	BBB
3	CCC	DDD
select * from t1 order by nid;
nid	nom	prenom
1	XYZ1	ABC1
2	AAA	BBB
3	CCC	DDD
delete from t1 where nid = 2;
INSERT INTO t1 VALUES(4,"EEE","FFF");
select * from t1 order by nid;
nid	nom	prenom
1	XYZ1	ABC1
3	CCC	DDD
4	EEE	FFF
select * from t1 order by nid;
nid	nom	prenom
1	XYZ1	ABC1
3	CCC	DDD
4	EEE	FFF
UPDATE t1 set nid=nid+1;
UPDATE t1 set nom="CCP" where nid = 4;
select * from t1 order by nid;
nid	nom	prenom
2	XYZ1	ABC1
4	CCP	DDD
5	EEE	FFF
select * from t1 order by nid;
nid	nom	prenom
2	XYZ1	ABC1
4	CCP	DDD
5	EEE	FFF
DROP table t1;
CREATE TABLE `t1` ( `nid` int(11) NOT NULL default '0',
`nom` char(4) default NULL,
`prenom` char(4) default NULL,
PRIMARY KEY USING HASH (`nid`)) 
ENGINE=ndbcluster DEFAULT CHARSET=latin1;
INSERT INTO t1 VALUES(1,"XYZ1","ABC1");
**** On Slave ****
BEGIN;
UPDATE t1 SET `nom`="LOCK" WHERE `nid`=1;
set GLOBAL slave_transaction_retries=1;
**** On Master ****
UPDATE t1 SET `nom`="DEAD" WHERE `nid`=1;
**** On Slave ****
SHOW SLAVE STATUS;;
Slave_IO_State	<Slave_IO_State>
Master_Host	127.0.0.1
Master_User	root
Master_Port	MASTER_PORT
Connect_Retry	1
Master_Log_File	master-bin.000001
Read_Master_Log_Pos	<Read_Master_Log_Pos>
Relay_Log_File	<Relay_Log_File>
Relay_Log_Pos	<Relay_Log_Pos>
Relay_Master_Log_File	master-bin.000001
Slave_IO_Running	Yes
Slave_SQL_Running	No
Replicate_Do_DB	
Replicate_Ignore_DB	
Replicate_Do_Table	
Replicate_Ignore_Table	<Replicate_Ignore_Table>
Replicate_Wild_Do_Table	
Replicate_Wild_Ignore_Table	
Last_Errno	146
Last_Error	Error in Write_rows event: error during transaction execution on table test.t1
Skip_Counter	0
Exec_Master_Log_Pos	<Exec_Master_Log_Pos>
Relay_Log_Space	<Relay_Log_Space>
Until_Condition	None
Until_Log_File	
Until_Log_Pos	0
Master_SSL_Allowed	No
Master_SSL_CA_File	
Master_SSL_CA_Path	
Master_SSL_Cert	
Master_SSL_Cipher	
Master_SSL_Key	
Seconds_Behind_Master	<Seconds_Behind_Master>
set GLOBAL slave_transaction_retries=10;
START SLAVE;
select * from t1 order by nid;
nid	nom	prenom
1	LOCK	ABC1
COMMIT;
select * from t1 order by nid;
nid	nom	prenom
1	DEAD	ABC1
DROP TABLE t1;