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
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!