Mysql Lock wait timeout exceeded; try restarting transaction

Must Check Innodb lock wait timeout. 

show variables like 'innodb_lock_wait_timeout';

Result:

You can set variable innodb_lock_wait_timeout=100 for lock time to 100 sec.

set innodb_lock_wait_timeout=100