Browse by category
Search | Advanced search
This error message is related to the variable innodb_lock_wait_timeout which can be found in MySQL configuration file, my.cnf.
The default value for innodb_lock_wait_timeout is 50 seconds. A transaction that tries to access a row that is locked by another InnoDB transaction will hang for at most this many seconds before issuing that error message.
To resolve this issue, you might want to increase the timeout from 50 seconds to 120 seconds and then restart MySQL.
For more information about this and other my.cnf variables, go to: Startup Options and System Variables