Sorry, neglected the version yet again: 7.4.5. What happens is that we
have active connections accessing tables that are being replicated by
slony. Then somebody does an uninstall of slony, which removes the slony
trigger from those tables. Then we start getting the OID error.
If this should indeed not be an issue in 7.4.5, I will try to come up
with a test case independent of a slony install.
Thanks.
- DAP
>-----Original Message-----
>From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
>Sent: Thursday, May 26, 2005 4:30 PM
>To: David Parker
>Cc: postgres general
>Subject: Re: [GENERAL] another failover testing question
>
>"David Parker" <dparker@tazznetworks.com> writes:
>> Something that we end up doing sometimes in our failover testing is
>> removing slony replication from an "active" (data provider) server.
>> Because this involves removing triggers from tables, we end up with
>> currently connected clients getting a bunch of "OID 123 not found"
>> errors, where the OID is that of the recently removed trigger.
>
>> Is there any way short of cycling all client connections to have the
>> server processes clean that information out of their cache when an
>> object disappears like this from the database?
>
>AFAICS, there already *is* adequate interlocking for this.
>What PG version are you testing, and can you provide a
>self-contained test case?
>
> regards, tom lane
>
