Mysql:lock wait timeout exceeded; Try restarting transaction

Http://www.byywee.com/page/M0/S467/467000.html
In theory, the simple statement is not to cause this error, it is possible to create a resource contention with other transactions, to check the MySQL process has to see if there is no operation of the same transaction process, if not, modify the MySQL configuration. The reason is that when you use the InnoDB table type,
Default parameter: Innodb_lock_wait_timeout the time to set the lock wait is 50s,
Because some locks wait more than this time, so error.

You can take this time longer, or optimize the stored procedure, and the transaction avoids the long waiting time.

My.ini file:
#innodb_lock_wait_timeout = 50
-》
Innodb_lock_wait_timeout = 500

Restart the MySQL service in effect.

Mysql:lock wait timeout exceeded; Try restarting transaction