Re: ERROR: could not open relation with OID 2836 - Mailing list pgsql-general

From Rodrigo Gonzalez
Subject Re: ERROR: could not open relation with OID 2836
Date
Msg-id 486303A7.3020505@gmail.com
Whole thread Raw
In response to Re: ERROR: could not open relation with OID 2836  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Rodrigo Gonzalez
Date:
Subject: Re: ERROR: could not open relation with OID 2836
Next
From: "Scott Marlowe"
Date:
Subject: Re: Serialized Access