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

------=_Part_6952_734968.1208838884151
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Thu, Apr 17, 2008 at 7:08 PM, Mikko Partio <mpartio@[EMAIL PROTECTED]
> wrote:

>
>
> On Thu, Apr 17, 2008 at 7:06 PM, Tom Lane <tgl@[EMAIL PROTECTED]
> wrote:
>
> > "Mikko Partio" <mpartio@[EMAIL PROTECTED]
> writes:
> > > On Thu, Apr 17, 2008 at 6:10 PM, Tom Lane <tgl@[EMAIL PROTECTED]
> 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

------=_Part_6952_734968.1208838884151
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<br><br><div class="gmail_quote">On Thu, Apr 17, 2008 at 7:08 PM, Mikko
Partio &lt;<a href="mailto:mpartio@[EMAIL PROTECTED]
">mpartio@[EMAIL PROTECTED]
>&gt;
wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br><br><div class="gmail_quote"><div><div></div><div class="Wj3C7c">On
Thu, Apr 17, 2008 at 7:06 PM, Tom Lane &lt;<a
href="mailto:tgl@[EMAIL PROTECTED]
" target="_blank">tgl@[EMAIL PROTECTED]
>&gt;
wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">

<div>&quot;Mikko Partio&quot; &lt;<a href="mailto:mpartio@[EMAIL PROTECTED]
"
target="_blank">mpartio@[EMAIL PROTECTED]
>&gt; writes:<br>
&gt; On Thu, Apr 17, 2008 at 6:10 PM, Tom Lane &lt;<a
href="mailto:tgl@[EMAIL PROTECTED]
" target="_blank">tgl@[EMAIL PROTECTED]
>&gt;
wrote:<br>
</div><div>&gt;&gt; I think you&#39;ve got really serious filesystem-level
problems. &nbsp;Have you<br>
&gt;&gt; tried running any hardware diagnostics? &nbsp;Are you sure
you&#39;re using a<br>
&gt;&gt; stable kernel version?<br>
<br>
&gt; I run fsck on the filesystem (gfs) -- no problems found. The disks
are from<br>
&gt; a san and the diagnostic programs say there&#39;s nothing wrong. I
also have<br>
&gt; other db clusters running on different filesystems (also gfs) and I
have<br>
&gt; never had any problems with them.<br>
<br>
</div>Some RAM checks wouldn&#39;t be out of place
either.</blockquote></div></div></div></blockquote><div><br><br>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&#39;s not so easy to replicate. Any
other pointers where to look at? Your help is well appreciated.<br>
<br>Regards<br><br>Mikko<br></div></div><br>

------=_Part_6952_734968.1208838884151--