Re: ERROR: could not open relation with OID 2836

Поиск
Список
Период
Сортировка
От Rodrigo Gonzalez
Тема Re: ERROR: could not open relation with OID 2836
Дата
Msg-id 486303A7.3020505@gmail.com
обсуждение исходный текст
Ответ на Re: ERROR: could not open relation with OID 2836  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane wrote:
> Rodrigo Gonzalez <rjgonzale@gmail.com> writes:
>> PgSQL is returning that error when I open pgdmin and when I run some
>> queries related to pg_buffercache. Also pg_dump cannot dump the DB.
>> PgSQL version is 8.3.3 and happened one day after loading the DB there.
>
> That raises a lot of questions about the trustworthiness of the platform
> you're using (hardware, kernel, etc).  In 8.3, 2836 is pg_proc's TOAST
> table and should certainly never get deleted.  I think you have
> filesystem or hardware issues.
>
>             regards, tom lane

Can be related to oom killer? I noticed today that it was invoked twice.

I am making other server to move the DB finally there, but would want to
know if the problem is hardware or not to be prepared for future...

Best regards

Rodrigo Gonzalez

В списке pgsql-general по дате отправления:

Предыдущее
От: Rodrigo Gonzalez
Дата:
Сообщение: Re: ERROR: could not open relation with OID 2836
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Serialized Access