Web lists-archives.com

Binary log in 5.6




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