Re: How to release acquired locks

In article <44emua$ln8_at_bcrkh13.bnr.ca>, Loren Budd <Loren_Budd_at_nt.com> wrote:
>>Actually I am talking about deadlocks. When two sessions try to
>>update the same row in a table one session is blocked indefinitely.
>>This is a deadlock condition not a blocked condition as you allude to!
>

ooops...I stand corrected! It would be nice though if you could set some timeout parameter so that you don't wait indefinitely.

>Paul,
>
> This is NOT a deadlock situation - what you are describing is blocking,
>where one session must wait until another finishes before it can complete it's
>transaction. When 2 sessions try to update the same row, one of them actually
>IS updating it and the other is waiting to update it. With blocking,
>eventually the blocked transaction will get it's kick at the cat depending on
>when the blocking transaction decides to finish. With a deadlock, neither
>transaction will EVER finish because they are both waiting for resources the
>other possesses.
>
>LB
>
Received on Mon Oct 02 1995 - 00:00:00 CET