Skip navigation links

MySQL Forums :: General :: Lock wait timeout exceeded; try restarting transaction


Advanced Search

Re: Lock wait timeout exceeded; try restarting transaction
Posted by: Rick James ()
Date: February 15, 2012 11:06PM

Hmmm.... need to dig further... Please provide these when the problem is happening:

SHOW ENGINE INNODB STATUS;

SHOW PROCESSLIST;

That seems to be the same UPDATE -- is there a loop trying to get the transaction finished? Perhaps there should be a limit of how many times you try?

Options: ReplyQuote


Subject Written By Posted
Lock wait timeout exceeded; try restarting transaction Harshdeep Khatri 02/13/2012 12:30AM
Re: Lock wait timeout exceeded; try restarting transaction Harshdeep Khatri 02/13/2012 10:50PM
Re: Lock wait timeout exceeded; try restarting transaction Rick James 02/14/2012 09:08PM
Re: Lock wait timeout exceeded; try restarting transaction Harshdeep Khatri 02/14/2012 11:02PM
Re: Lock wait timeout exceeded; try restarting transaction Harshdeep Khatri 02/14/2012 11:59PM
Re: Lock wait timeout exceeded; try restarting transaction Rick James 02/15/2012 11:06PM
Re: Lock wait timeout exceeded; try restarting transaction Harshdeep Khatri 02/23/2012 04:42PM
Re: Lock wait timeout exceeded; try restarting transaction Rick James 02/24/2012 07:03AM
Re: Lock wait timeout exceeded; try restarting transaction Harshdeep Khatri 03/12/2012 06:20AM
Re: Lock wait timeout exceeded; try restarting transaction Harshdeep Khatri 03/12/2012 06:17AM
Re: Lock wait timeout exceeded; try restarting transaction Rick James 03/13/2012 08:36PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.