Re: "Lock wait timeout exceeded" time out on insert.
Posted by:
Rick James
Date: December 27, 2011 09:56AM
> Do you mean that if a lock wait occurs that the whole transaction should be rolled back and tried again at that level?
All I see is one INSERT. Are you thinking there is more to the "whole transaction"?
> The first insert that fails is a part of a group of actions that needs to be in a transaction, it just never gets to the next actions cause of the Lock Wait.
Let's dissect this. Why is it blocking? What is the other query that is conflicting? Why is that other query hanging on for 50 seconds (and probably more)?
Are all these queries hitting the same table?
Are the INSERTs single-row, or multi-row?
SHOW CREATE TABLE
If multi-row, sort the rows on PRIMARY KEY or UNIQUE key.
Subject
Views
Written By
Posted
8674
December 09, 2011 07:31AM
4186
December 10, 2011 04:11PM
2553
December 11, 2011 09:44AM
2617
December 13, 2011 05:38AM
1995
December 14, 2011 12:07PM
2291
December 15, 2011 08:13AM
2149
December 16, 2011 05:09PM
2220
December 25, 2011 01:35AM
1805
December 25, 2011 11:17PM
2003
December 26, 2011 05:40AM
Re: "Lock wait timeout exceeded" time out on insert.
1912
December 27, 2011 09:56AM
2003
January 05, 2012 12:57PM
1845
January 08, 2012 12:52PM
1720
January 26, 2012 05:27AM
1702
January 27, 2012 08:57PM
2203
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.