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: [application/pgp-signature] OpenPGP digital signature signature.asc
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
