Re: Deadlock situation using foreign keys (reproduceable) - Mailing list pgsql-hackers

From Stephan Szabo
Subject Re: Deadlock situation using foreign keys (reproduceable)
Date
Msg-id 20020825204307.W55041-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: Deadlock situation using foreign keys (reproduceable)  (Thomas O'Dowd <tom@nooper.com>)
Responses Re: Deadlock situation using foreign keys (reproduceable)  (Thomas O'Dowd <tom@nooper.com>)
List pgsql-hackers
On 26 Aug 2002, Thomas O'Dowd wrote:

> Hi all,
>
> I've been having a lot of trouble with deadlocks in 7.2.1 because of
> foreign keys. I dug out a couple of messages from the list archives
> which cover this topic.
>
> One particular message indicates a fix was being worked on.
> --------
> Date: Thu, 11 Apr 2002 09:03:06 -0700 (PDT)
> From: Stephan Szabo
>
> Please see past disussions on the fact that the lock grabbed is too
> strong.  I'm going to (when I get time to work on it) try out a lower
> strength lock that Alex Hayward made a patch for that should
> limit/prevent these cases.  Thanks for sending a nice simple test case
> to try against :)
> ----------
>
> My question is if this is now resolved for 7.3? I'm trying to figure out
> what I can do with my 7.2.1 problems... Has anyone got a back-ported
> patch, perhaps against 7.2.2?

It's actually not resolved because my attempts at the lower strength lock
opened up holes and fixing those opened up new deadlock situations, and
I ran out of time in the 7.3 cycle to try to make it work.



pgsql-hackers by date:

Previous
From: Thomas O'Dowd
Date:
Subject: Re: Deadlock situation using foreign keys (reproduceable)
Next
From: Tatsuo Ishii
Date:
Subject: Re: PostgreSQL 7.2.2 and docs