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

Re: ERROR: could not open relation with OID 2836

From: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
To: Rodrigo Gonzalez <rjgonzale(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: could not open relation with OID 2836
Date: 2008-06-26 17:13:26
Message-ID: 3BAE326E-6F52-4131-A629-2DEE23237551@solfertje.student.utwente.nl (view raw or flat)
Thread:
Lists: pgsql-general
On Jun 26, 2008, at 5:41 AM, Rodrigo Gonzalez wrote:

> Tom Lane wrote:
>> Rodrigo Gonzalez <rjgonzale(at)gmail(dot)com> writes:
>>> Craig Ringer wrote:
>>>> What platform are you using?
>>
>>> It's running under CentOS 4.4 using ext3, no RAID or LVM.
>>> Server is quad xeon 64 bits 3 GHz
>>
>> Ugh, I'd have liked to think RHEL4/Centos4 would be more reliable  
>> than
>> that :-(.  Still, you might have an issue with trying to use hardware
>> that's not supported by RHEL4, especially if it's not a very recent
>> version of RHEL4.  Did you check compatibility charts before  
>> purchasing?
>> https://hardware.redhat.com/
>>
>> 			regards, tom lane
>
> It had been working with pgsql 8.1 and 8.2 for 2 years without  
> problems.
> Suspicious is that problems started next day I've upgraded to 8.3.
>
> I've tried reinstalling 8.3 from scratch and again, next morning, oid
> 2836 is missing...

Ok, throwing a few "random" questions in your direction:

What procedure did you use to do those upgrades? Maybe something went  
wrong there? I'm assuming you upgraded using dump/restore, or  
postgres would have complained about the version of the data files at  
startup, but maybe you did something unusual.

Are you sure there's only one version of postgres running?

Are all your libraries up to date, no old versions hanging around  
where they should have been replaced?

Do you have any stored procedures in C? If so, do you perhaps use  
malloc/free instead of the ones Postgres provides (reasoning you may  
be freeing a reference to the toast table somehow)?

Is that data-file on a mirror where one part of the mirror may be  
mirroring a bad sector over the good one on the other drive(s)?


I may be talking nonsense, I'm no Tom Lane, but I know a fair share  
about postgres ;)
Regards,

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4863ce3b243481261463208!



In response to

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2008-06-26 17:18:46
Subject: Re: new RETURNING clause and Pg.pm
Previous:From: Dean RasheedDate: 2008-06-26 17:11:02
Subject: Re: what are rules for?

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