Re: ERROR: could not open relation with OID 2836

From: Rodrigo Gonzalez <rjgonzale(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: could not open relation with OID 2836
Date: 2008-06-26 02:49:11
Message-ID: 486303A7.3020505@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:
> Rodrigo Gonzalez <rjgonzale(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-06-26 02:55:15 Re: Serialized Access
Previous Message Rodrigo Gonzalez 2008-06-26 02:47:52 Re: ERROR: could not open relation with OID 2836