MySQL Forums
Forum List  »  InnoDB

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: "Lock wait timeout exceeded" time out on insert.
1912
December 27, 2011 09:56AM


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.