Re: BUG #8515: Random 'relation "..." does not exist' - Mailing list pgsql-bugs

From Greg Stark
Subject Re: BUG #8515: Random 'relation "..." does not exist'
Date
Msg-id CAM-w4HPqPbJHrCvO0PhSXSVWWawBrbBE=gS-K61zESHu6b4PPg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #8515: Random 'relation "..." does not exist'  (John R Pierce <pierce@hogranch.com>)
List pgsql-bugs
Try
SHOW search_path;

On both the good and bad connection. Is it possible you have some code
setting it and leaving it set incorrectly?

--
greg
On 12 Oct 2013 23:17, "John R Pierce" <pierce@hogranch.com> wrote:

> On 10/9/2013 10:35 AM, nbuduroi@gmail.com wrote:
>
>> Basically, at some point a query, update or insert will not work and
>> complain about a table not existing, but that table was used without any
>> issue previously. Closing the running connection to the database and
>> reconnecting make that error disappear. Two concurrent connections (one
>> from
>> a console and another from the app) could be contradicting themselves, one
>> giving the error and the other not.
>>
>
>
> that sounds like a hardware/platform problem to me more than anything.
> maybe in memory cache is getting corrupted or something?
>
>
>
> --
> john r pierce                                      37N 122W
> somewhere on the middle of the left coast
>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-bugs<http://www.postgresql.org/mailpref/pgsql-bugs>
>

pgsql-bugs by date:

Previous
From: John R Pierce
Date:
Subject: Re: BUG #8515: Random 'relation "..." does not exist'
Next
From: Benjamin Wassermann
Date:
Subject: Re: BUG #8461: PostgreSQL 9.3 pg_dump heap corruptions