Skip navigation links

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


Advanced Search

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

Thanks for answering Rick,


> Suggest you turn on the "general log" until the problem occurs again
NW: The issue is that because it is a production server and providing other services I can't afford to run out of disk space. But for some reason it nearly always seems to happen between 1pm and 6pm, so I will have some windows to work with. I have got this all set up and will turn on when I think it is likely to happen.

> You are using Java, correct?
NW: Yes


So hopefully I will be able to get back to you once I have caught the information I need.

Thanks again,

Nick

Options: ReplyQuote


Subject Views Written By Posted
"Lock wait timeout exceeded" time out on insert. 6029 Nic Whale 12/09/2011 07:31AM
Re: "Lock wait timeout exceeded" time out on insert. 2849 Rick James 12/10/2011 04:11PM
Re: "Lock wait timeout exceeded" time out on insert. 1654 Nic Whale 12/11/2011 09:44AM
Re: "Lock wait timeout exceeded" time out on insert. 1740 Nic Whale 12/13/2011 05:38AM
Re: "Lock wait timeout exceeded" time out on insert. 1320 Rick James 12/14/2011 12:07PM
Re: "Lock wait timeout exceeded" time out on insert. 1500 Nic Whale 12/15/2011 08:13AM
Re: "Lock wait timeout exceeded" time out on insert. 1465 Rick James 12/16/2011 05:09PM
Re: "Lock wait timeout exceeded" time out on insert. 1425 Nic Whale 12/25/2011 01:35AM
Re: "Lock wait timeout exceeded" time out on insert. 1161 Rick James 12/25/2011 11:17PM
Re: "Lock wait timeout exceeded" time out on insert. 1308 Nic Whale 12/26/2011 05:40AM
Re: "Lock wait timeout exceeded" time out on insert. 1286 Rick James 12/27/2011 09:56AM
Re: "Lock wait timeout exceeded" time out on insert. 1199 Nic Whale 01/05/2012 12:57PM
Re: "Lock wait timeout exceeded" time out on insert. 1156 Rick James 01/08/2012 12:52PM
Re: "Lock wait timeout exceeded" time out on insert. 1037 Nic Whale 01/26/2012 05:27AM
Re: "Lock wait timeout exceeded" time out on insert. 1112 Rick James 01/27/2012 08:57PM
Re: "Lock wait timeout exceeded" time out on insert. 1408 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.