Re: Concurrency in an RDB

On Dec 14, 9:38 am, "NENASHI, Tegiri" <tnmai..._at_gmail.com> wrote:
> "Cimode" <cim..._at_hotmail.com> wrote innews:1166113032.469596.104340_at_n67g2000cwd.googlegroups.com:
>
> > There is NO direct relationship between locks and deadlocks.
>
> It is not true. Locks can cause dead locks:
>
> Process1: ->lock Resource1--work 2 minutes -> lock Resource2 -> wait for
> Process2 ->dead lock
> Process2: ->lock Resource2--work 1 minute -> lock Resource1 -> wait for
> Process1 ->dead lock
>

Yours was more informative, but mine was funnier.

Actually, come to think of it, "no direct relationship between locks and deadlocks" was the funny one.

Marshall Received on Thu Dec 14 2006 - 20:16:04 CET