Got a very strange situation, where I receive two similar DELETE statement in the same binary log position, due to which replication slave is stopped due to following error:
Could not execute DELETE rows event on table db1.xyz.; Can't find record in 'xyz' , error code:1032. Following entry is found in the binary log: # at 28651234 #150423 12:21:03 server id 5170 end_log_pos 28651303 CRC32 0x0b496431 Delete_rows: table id 73 flags: STMT_END_F ### DELETE FROM `db1`.`xyz` ### WHERE ### @1=1040103520 ### @2='new' ### DELETE FROM `db1`.`xyz` ### WHERE ### @1=1040103520 ### @2='new' But, above record do exist in db1.xyz table on slave. Still, replication error on slave says: can't find record. Any idea on this. Best Regards, Geetanjali Mehra Senior Database Administrator
