From: | H(dot)Harada <umi(dot)tanuki(at)gmail(dot)com> |
---|---|
To: | Geoffrey <lists(at)serioustechnology(dot)com> |
Cc: | "PostgreSQL List" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: ERROR: relation with OID 1322527 does not exist |
Date: | 2008-02-20 06:16:52 |
Message-ID: | e08cc0400802192216y1851e7f0g4d44e3a260a2f533@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2008/2/20, Geoffrey <lists(at)serioustechnology(dot)com>:
> We've just started seeing these errors. Research I've done seems to
> indicate that it's related to temp tables. Question is, we didn't start
> seeing these errors until we started using slony to replicate our data.
>
> The errors only showed up shortly after the initial replication of the
> data was complete. That is, once the replication server 'caught up'
> with the production server.
>
I've ever seen the same error. At that time I didn't use slony but
replicated some postgresql servers by an application layer. It seemed
that not only temp table but regular relations are dropped and created
quickly when the error occurred.
There could be a chance to drop information about relations or
themselves between SELECT catching relation OID and begining scan the
relation actually.
I have no solution for this until now. But just for your information.
Hitoshi Harada
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2008-02-20 06:56:37 | Re: |
Previous Message | Chris | 2008-02-20 06:05:49 | Re: Regex query not using index |