Skip site navigation (1) Skip section navigation (2)

Re: [Slony1-general] Re: dangling lock information?

From: "David Parker" <dparker(at)tazznetworks(dot)com>
To: "Hannu Krosing" <hannu(at)skype(dot)net>,"Andreas Pflug" <pgadmin(at)pse-consulting(dot)de>
Cc: <slony1-general(at)gborg(dot)postgresql(dot)org>,"PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [Slony1-general] Re: dangling lock information?
Date: 2005-08-30 12:12:53
Message-ID: 07FDEE0ED7455A48AC42AC2070EDFF7CAC87DC@corpsrv2.tazznetworks.com (view raw or flat)
Thread:
Lists: pgsql-hackers
The slony log trigger saves execution plans, so any given connection
that has been used with a slony schema installed will have cached OIDs
referring to the sl_log_1 table. When you drop the schema, those OIDs
obviously go away. When you re-create the schema, and try to use the old
connection, it still has the old plan cached in it, so the OIDs in the
plan are out of sync with what actually exists in the database.

This is the behavior I've observed in our environment, anyway. The
problem always shows up when slony is RE-installed under an outstanding
connection.

- DAP 

-----Original Message-----
From: slony1-general-bounces(at)gborg(dot)postgresql(dot)org
[mailto:slony1-general-bounces(at)gborg(dot)postgresql(dot)org] On Behalf Of Hannu
Krosing
Sent: Tuesday, August 30, 2005 7:28 AM
To: Andreas Pflug
Cc: slony1-general(at)gborg(dot)postgresql(dot)org; PostgreSQL-development
Subject: [Slony1-general] Re: [HACKERS] dangling lock information?

On E, 2005-08-29 at 13:09 +0200, Andreas Pflug wrote:
> Hannu Krosing wrote:
> 
> >On P, 2005-08-28 at 22:23 +0200, Andreas Pflug wrote:
> >  
> >
> >>I'm currently testing pgAdmin support for slony, on pgsql CVS HEAD, 
> >>and encounter strange problems from time to time.
> >>After dropping and recreating the slony schema, all changes 
> >>committed and all backends in <IDLE> state, I'm getting "relation 
> >>with OID xxx does not exist" when I'm trying to add a path.
> >>This seems to be triggered inside slony functions when a
> >>    LOCK _test.pg_config IN EXCLUSIVE MODE is performed.
> >>The problem is gone as soon as I close the connection I've been 
> >>using for prior schema changes, and use a fresh connection.
> >>
> >>Does this description ring a bell for somebody?
> >>    
> >>
> >
> >seems like the usual "pl/pgsql caches query plans and relation 
> >referenced inside the cached plan is gone" thing
> >  
> >
> Kind of, but the complete schema including procedures was dropped, so 
> apparently after recreation the old plans were reused?!?

In that case this should probably be asked at slony list.

Added to CC.

--
Hannu Krosing <hannu(at)skype(dot)net>

_______________________________________________
Slony1-general mailing list
Slony1-general(at)gborg(dot)postgresql(dot)org
http://gborg.postgresql.org/mailman/listinfo/slony1-general

Responses

pgsql-hackers by date

Next:From: Kris JurkaDate: 2005-08-30 12:19:21
Subject: Re: Intermittent stats test failures on buildfarm
Previous:From: esolsonaDate: 2005-08-30 11:45:29
Subject: PG_DUMp

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group