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

Re: FATAL: could not open relation xxx: No such file or directory

From: "Mikko Partio" <mpartio(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: FATAL: could not open relation xxx: No such file or directory
Date: 2008-04-17 15:59:21
Message-ID: 2ca799770804170859t39a5532x4629953e0ec3a600@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Thu, Apr 17, 2008 at 6:10 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "Mikko Partio" <mpartio(at)gmail(dot)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

In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2008-04-17 16:06:07
Subject: Re: FATAL: could not open relation xxx: No such file or directory
Previous:From: Tom LaneDate: 2008-04-17 15:41:31
Subject: Re: duplicate primary index in bayes db from SpamAssassin

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