Re: BUG #8515: Random 'relation "..." does not exist'

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: BUG #8515: Random 'relation "..." does not exist'
Дата
Msg-id CAM-w4HPqPbJHrCvO0PhSXSVWWawBrbBE=gS-K61zESHu6b4PPg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #8515: Random 'relation "..." does not exist'  (John R Pierce <pierce@hogranch.com>)
Список 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 по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: BUG #8515: Random 'relation "..." does not exist'
Следующее
От: Benjamin Wassermann
Дата:
Сообщение: Re: BUG #8461: PostgreSQL 9.3 pg_dump heap corruptions