Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group