Mysql Error: 1205 :Lock wait timeout exceeded; try restarting transaction

mysql > show engine innodb status\G;

mysql > show variables like 'innodb_lock_wait_timeout';

 

 

##enlarge innodb_lock_wait_timeout

mysql>set @@GLOBAL.innodb_lock_wait_timeout=500;

## Enable general log

mysql> show variables like 'general_log';

mysql>set @@GLOBAL.general_log=ON;