ServerTune

Browse by category

Search    |    Advanced search

ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

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.

innodb_lock_wait_timeout = 120

For more information about this and other my.cnf variables, go to: Startup Options and System Variables

 
 
Add comment
 
Views: 4179
 
Votes: 0
 
Comments: 0
 

Other articles in this Category

RSS