Re: "Lock wait timeout exceeded" time out on insert.

[Nic Whale]

Thanks Rick for a quick holiday season reply.

I do not understand sure what is wrong with this?

1. 09:10:23: Transaction start
2. 09:10:23: Try to do insert.
3. 09:11:14: Insert lock wait time outs and is recorded.
4. 09:11:14: Try to do insert a 2nd time.
5. 09:12:05: Insert lock wait time outs a 2nd time and is recorded.
6. 09:12:05: Try to do insert a 3rd time.
7. 09:12:56: Insert lock wait time outs a 3rd time and is recorded.
8. 09:12:56: Try to do insert a 4th time.
9. 09:13:47: Insert lock wait time outs 4th and final time and is recorded.
10.09:13:48: Rollback cause failed 4 times.

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.

Do you mean that if a lock wait occurs that the whole transaction should be rolled back and tried again at that level? That is, do not worry about trying again within the transaction? Note, that at the moment most cases only need to retry once or twice and it does succeed.

Thanks again,

Nick