Tuesday, September 11, 2012

MySQL Replication Error: Error_code: 1205; handler error HA_ERR_LOCK_WAIT_TIMEOUT


Environment: MySQL Replication Slave Server
Error:
Could not execute Update_rows event on table
; Lock wait timeout exceeded; try restarting transaction, Error_code: 1205; handler error HA_ERR_LOCK_WAIT_TIMEOUT; the event's master log mysql-bin.003169, end_log_pos 1006784578

Solution:
Shall you face any issue as above when you execute mysql>show slave status;
the solution is as simple as following
shell> stop slave;
shell> start slave;