MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: "Lock wait timeout exceeded" time out on insert.
Posted by: Rick James
Date: December 16, 2011 05:09PM

Do you ever COMMIT? I see none in the snippets of code. The locks for those SELECTs will be held until a COMMIT, ROLLBACK, or a timeout. With autocommit=0, you must eventually use COMMIT.

If it is not too big, please provide the entire general log, starting 51 seconds before the problem. (assuming you have innodb_lock_wait_timeout=50)

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
"Lock wait timeout exceeded" time out on insert.
8684
Nic Whale
December 09, 2011 07:31AM
Re: "Lock wait timeout exceeded" time out on insert.
4189
Rick James
December 10, 2011 04:11PM
Re: "Lock wait timeout exceeded" time out on insert.
2555
Nic Whale
December 11, 2011 09:44AM
Re: "Lock wait timeout exceeded" time out on insert.
2617
Nic Whale
December 13, 2011 05:38AM
Re: "Lock wait timeout exceeded" time out on insert.
1999
Rick James
December 14, 2011 12:07PM
Re: "Lock wait timeout exceeded" time out on insert.
2292
Nic Whale
December 15, 2011 08:13AM
Re: "Lock wait timeout exceeded" time out on insert.
2150
Rick James
December 16, 2011 05:09PM
Re: "Lock wait timeout exceeded" time out on insert.
2224
Nic Whale
December 25, 2011 01:35AM
Re: "Lock wait timeout exceeded" time out on insert.
1805
Rick James
December 25, 2011 11:17PM
Re: "Lock wait timeout exceeded" time out on insert.
2006
Nic Whale
December 26, 2011 05:40AM
Re: "Lock wait timeout exceeded" time out on insert.
1913
Rick James
December 27, 2011 09:56AM
Re: "Lock wait timeout exceeded" time out on insert.
2007
Nic Whale
January 05, 2012 12:57PM
Re: "Lock wait timeout exceeded" time out on insert.
1848
Rick James
January 08, 2012 12:52PM
Re: "Lock wait timeout exceeded" time out on insert.
1722
Nic Whale
January 26, 2012 05:27AM
Re: "Lock wait timeout exceeded" time out on insert.
1704
Rick James
January 27, 2012 08:57PM
Re: "Lock wait timeout exceeded" time out on insert.
2207
Nic Whale
March 11, 2012 01:17AM


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.