pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mikko Partio <mpartio@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Pavan Deolasee <pavan.deolasee@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: FATAL: could not open relation xxx: No such file or directory
Date: Tue, 22 Apr 2008 07:34:44 +0300
Message-ID: <2ca799770804212134x2398fe22u2f1a732d5e04c50b@mail.gmail.com> (raw)
In-Reply-To: <2ca799770804170908t26cf4237qee7af185b70a29c2@mail.gmail.com>
References: <2ca799770804090647m759b72f9gf2d49b4bf7cc8bdf@mail.gmail.com>
	<2ca799770804142336q6422af38me80054c82699d1e2@mail.gmail.com>
	<2ca799770804170308m367eaea2nc7899198c0b260e0@mail.gmail.com>
	<2e78013d0804170336j4299161bm3f280fc9b930b474@mail.gmail.com>
	<2ca799770804170344o65291ce3pa56a2694f7a15bc5@mail.gmail.com>
	<20021.1208445022@sss.pgh.pa.us>
	<2ca799770804170859t39a5532x4629953e0ec3a600@mail.gmail.com>
	<20825.1208448367@sss.pgh.pa.us>
	<2ca799770804170908t26cf4237qee7af185b70a29c2@mail.gmail.com>

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

view thread (14+ messages)  latest in thread

Message-ID: <2ca799770804212134x2398fe22u2f1a732d5e04c50b@mail.gmail.com>
Permalink:  ../2ca799770804212134x2398fe22u2f1a732d5e04c50b@mail.gmail.com/
Also on:    postgresql.org/message-id/2ca799770804212134x2398fe22u2f1a732d5e04c50b@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: mpartio@gmail.com, tgl@sss.pgh.pa.us, pavan.deolasee@gmail.com
  Subject: Re: FATAL: could not open relation xxx: No such file or directory
  In-Reply-To: <2ca799770804212134x2398fe22u2f1a732d5e04c50b@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox