I encountered an error
MySQL Error: Lock wait timeout exceeded; try restarting transaction
MySQL Error No: 1205

For this very statement an entry in the binlog was filed

...
# Query_time: 52  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
...

Why is there an entry in the binlog if the statement failed?
If it is in the binlog it will be replicated to a slave and on the slave
it will succeed (maybe).

Does this mean that a Lock wait timeout exceeded potentially drive the
slave out of sync?
-- 
Kind Regards, Markus Falb

Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to