Re: BUG #5107: Lock never released - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5107: Lock never released
Date
Msg-id 7532.1255097816@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5107: Lock never released  ("Christian DUPONT" <christian.dupont@cegelec.com>)
List pgsql-bugs
"Christian DUPONT" <christian.dupont@cegelec.com> writes:
> I use slony 1 v 1.2.14.
> After an unexpected stop, several tables remained locked :

Is it possible that the locks are being held by a prepared transaction?
Next time it happens, look into the pg_prepared_xacts status view.

If it's not that, it seems like this must be a Slony issue, not a
problem with Postgres proper.  You'll probably get better results
if you ask about it on the Slony mailing lists.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Christian DUPONT"
Date:
Subject: BUG #5107: Lock never released
Next
From: Peter Eisentraut
Date:
Subject: Re: BUG #5106: Relationship between two tables