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

Re: dangling lock information?

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Hannu Krosing <hannu(at)skype(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: dangling lock information?
Date: 2005-08-29 11:09:35
Message-ID: 4312ECEF.1020101@pse-consulting.de (view raw or flat)
Thread:
Lists: pgsql-hackers
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?!?

Regards,
Andreas


In response to

Responses

pgsql-hackers by date

Next:From: Knut P LehreDate: 2005-08-29 11:30:34
Subject: Re: SSL client crt verification
Previous:From: Jochem van DietenDate: 2005-08-29 10:10:06
Subject: Re: Call for 7.5 feature completion

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