Replication_Error: Error_code : 1205; handler error HA_ERR_LOCK_WAIT_TIMEOUT;

Hi,

Recently I have faced an issue in Master Slave replication.Unfortunately slave stops it replication and it throws an error as,

[ERROR] Slave SQL: Could not execute Update_rows event on table DBname.tablename; Lock wait timeout exceeded; try restarting transaction,

Error_code: 1205; handler error HA_ERR_LOCK_WAIT_TIMEOUT; the event's master log mysql-bin.******, end_log_pos *******, Error_code: 1205

To clear the error. I did,

show slave status\G
stop slave;
start slave;

Now error has gone and replication runs successfully.

It happens at sometime when a query takes long time to execute.


Thank you...