Re: 2PC-induced lockup - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 2PC-induced lockup
Date
Msg-id 999.1184183727@sss.pgh.pa.us
Whole thread Raw
In response to Re: 2PC-induced lockup  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-hackers
Andrew Sullivan <ajs@crankycanuck.ca> writes:
> On Wed, Jul 11, 2007 at 06:15:12PM +0100, Heikki Linnakangas wrote:
>> It's effectively the same as manually issuing a ROLLBACK PREPARED.

> But how do you know which file to delete?

You don't.  In extremis you could probably throw together some
inspection tool that could look though the 2PC records to find out which
file mentioned an exclusive lock on pg_authid ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 2PC-induced lockup
Next
From: Peter Eisentraut
Date:
Subject: Re: 2PC-induced lockup