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 2ca799770804170859t39a5532x4629953e0ec3a600@mail.gmail.com
Whole thread Raw
In response to Re: FATAL: could not open relation xxx: No such file or directory  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: FATAL: could not open relation xxx: No such file or directory  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: FATAL: could not open relation xxx: No such file or directory  ("Mikko Partio" <mpartio@gmail.com>)
Re: FATAL: could not open relation xxx: No such file or directory  (Michael Monnerie <michael.monnerie@it-management.at>)
List pgsql-admin


On Thu, Apr 17, 2008 at 6:10 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Mikko Partio" <mpartio@gmail.com> writes:
> Seems like the whole db is falling apart.

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.

Regards

Mikko

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: duplicate primary index in bayes db from SpamAssassin
Next
From: Tom Lane
Date:
Subject: Re: FATAL: could not open relation xxx: No such file or directory