MySQL中执行update SQL时，报错：1205, 'Lock wait timeout？

MySQL中执行update SQL时，报错：1205, 'Lock wait timeout，是什么原因导致的？

1205, 'Lock wait timeout exceeded; try restarting transaction'

SET AUTOCOMMIT = 0; UPDATE .... COMMIT;

And you disconnect the client ( ip failover, ... ) after the autocommit was set to 0, but before the commit statement is reached, the transaction hangs there indefinitely. When the SQL thread for the replication want to write the updates ( that are now handled on the second mysql server ), it wait for the locks to be released, and fails 10 times after 50 seconds each, causing mysql replication to halt.