I have not seen this error in a while with MySQL replication, " Lock wait timeout exceeded; try restarting transaction"
Check the slave status
show slave status \G; and noticed the following.
Slave_IO_Running: Yes
Slave_SQL_Running: No
Slave_IO_Running: Yes
Slave_SQL_Running: No
Last_SQL_Errno: 1205
Last_SQL_Error: Lock wait timeout exceeded; try restarting transaction
Solution
Stopped the Slave
stop slave;
Restarted the Slave
start slave;
Check the status and all is well
