Re: FATAL: could not open relation xxx: No such file or directory - Mailing list pgsql-admin

From Mikko Partio
Subject Re: FATAL: could not open relation xxx: No such file or directory
Date
Msg-id 2ca799770804212134x2398fe22u2f1a732d5e04c50b@mail.gmail.com
Whole thread Raw
In response to Re: FATAL: could not open relation xxx: No such file or directory  ("Mikko Partio" <mpartio@gmail.com>)
List pgsql-admin


On Thu, Apr 17, 2008 at 7:08 PM, Mikko Partio <mpartio@gmail.com> wrote:


On Thu, Apr 17, 2008 at 7:06 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Mikko Partio" <mpartio@gmail.com> writes:
> On Thu, Apr 17, 2008 at 6:10 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I think you've got really serious filesystem-level problems.  Have you
>> tried running any hardware diagnostics?  Are you sure you're using a
>> stable kernel version?

> I run fsck on the filesystem (gfs) -- no problems found. The disks are from
> a san and the diagnostic programs say there's nothing wrong. I also have
> other db clusters running on different filesystems (also gfs) and I have
> never had any problems with them.

Some RAM checks wouldn't be out of place either.


Memtest86+ has now been running for 20+ hours and no errors has been found. I was also unable to reproduce this problem, but it only happened after a few days of constant activity anyway so I guess it's not so easy to replicate. Any other pointers where to look at? Your help is well appreciated.

Regards

Mikko

pgsql-admin by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: Some additions to pg_filedump...
Next
From: Michael Monnerie
Date:
Subject: Re: FATAL: could not open relation xxx: No such file or directory