Skip navigation links

MySQL Forums :: InnoDB :: "Lock wait timeout exceeded" time out on insert.


Advanced Search

"Lock wait timeout exceeded" time out on insert.
Posted by: Nic Whale ()
Date: December 09, 2011 07:31AM

I logged a topic a while back that was similar behaviour : http://forums.mysql.com/read.php?22,422297,422297 .

I thought some of these issues could be fixed by the introduction of "innodb_autoinc_lock_mode" in V5.1 (Although Rick James said suggested politely I was wrong!). So I have upgraded to "V5.1.52 on Linux" and now have configured this new property as

"innodb_autoinc_lock_mode=2"

However every couple of days or so I get the following error:

"SQLException: Lock wait timeout exceeded; try restarting transaction SQLState: 41000 VendorError: 1205"

While trying do a basic insert, such as:

INSERT INTO table1( id, lastupdated ,title, status, type, creationdate, notes ,history,userid ,operativeid ,type2 ,startdate ,enddate ,noattachmentrequired, field1, field2, field3, field4, field5, field6 ,approvaldate ,archivaldate, boolean1, boolean2, boolean3 ,opuseridedited,accuseridedited ) values (0,'2011-12-07 12:38:37',NULL,0,2,'2011-12-07 12:38:37',NULL,'07/12/2011 12:38:email@mail.com:Op Wizard <br>',97027,96915,0,NULL,NULL,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-1,-1,-1,null,null);

This insert is not in a big transaction, but it is in a simple one. Also, there is not that much else happening on the database. While I cannot see exactly how many updates where happening around this time, I can see one insert was done about 3 mins prior to this error.

Any help or suggestions would be greatly appreciated.

Nick



Edited 1 time(s). Last edit at 12/11/2011 07:46AM by Nic Whale.

Options: ReplyQuote


Subject Views Written By Posted
"Lock wait timeout exceeded" time out on insert. 5540 Nic Whale 12/09/2011 07:31AM
Re: "Lock wait timeout exceeded" time out on insert. 2672 Rick James 12/10/2011 04:11PM
Re: "Lock wait timeout exceeded" time out on insert. 1520 Nic Whale 12/11/2011 09:44AM
Re: "Lock wait timeout exceeded" time out on insert. 1627 Nic Whale 12/13/2011 05:38AM
Re: "Lock wait timeout exceeded" time out on insert. 1254 Rick James 12/14/2011 12:07PM
Re: "Lock wait timeout exceeded" time out on insert. 1430 Nic Whale 12/15/2011 08:13AM
Re: "Lock wait timeout exceeded" time out on insert. 1340 Rick James 12/16/2011 05:09PM
Re: "Lock wait timeout exceeded" time out on insert. 1360 Nic Whale 12/25/2011 01:35AM
Re: "Lock wait timeout exceeded" time out on insert. 1075 Rick James 12/25/2011 11:17PM
Re: "Lock wait timeout exceeded" time out on insert. 1242 Nic Whale 12/26/2011 05:40AM
Re: "Lock wait timeout exceeded" time out on insert. 1208 Rick James 12/27/2011 09:56AM
Re: "Lock wait timeout exceeded" time out on insert. 1136 Nic Whale 01/05/2012 12:57PM
Re: "Lock wait timeout exceeded" time out on insert. 1076 Rick James 01/08/2012 12:52PM
Re: "Lock wait timeout exceeded" time out on insert. 971 Nic Whale 01/26/2012 05:27AM
Re: "Lock wait timeout exceeded" time out on insert. 1010 Rick James 01/27/2012 08:57PM
Re: "Lock wait timeout exceeded" time out on insert. 1312 Nic Whale 03/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.