Received: from localhost (unknown [200.46.204.184])
	by developer.postgresql.org (Postfix) with ESMTP id E43172E0076
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Thu, 17 Apr 2008 13:07:35 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 80031-07
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Thu, 17 Apr 2008 13:07:29 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from el-out-1112.google.com (el-out-1112.google.com
 [209.85.162.178])
	by developer.postgresql.org (Postfix) with ESMTP id 173162E005B
	for <pgsql-admin@postgresql.org>; Thu, 17 Apr 2008 13:07:29 -0300 (ADT)
Received: by el-out-1112.google.com with SMTP id j27so80504elf.23
	for <pgsql-admin@postgresql.org>; Thu, 17 Apr 2008 09:07:29 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	bh=MtzmuArK7Cz3q00QAsRvdT2NqFmeRJsWdN+T9WMi7UI=;
	b=uMHEQl6khjyNzqMnY1FkIfifoXFcfRyU9IMhTrv1cE8kvPyhIzaJJsEcRIZQDEa3SRZEbaLf8rxM9pr7e+90NvIfDoRINvwvjHvbqYMOTvpLcwtl89ibOr4RmDto7urAseRilW/sd5UwW8bfgs202+I+JY4lakkhmgqN4yABm9o=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=UTGFN/f7QBPlTf4bx2e3xJRfGWTQTLRd8gFLXVCnxi9wCdncQ3C8zQlYf0EVUL5ehEvK8Qy1Z6NS3I8BS4N/t//eFWpFt5po4cWH2fU/6TFbNll05NVbE8/FTXv8eZjexlIHh2eM5NiaHGZvKdHV/eWxYuwKY6LJvJn5lV8c0jQ=
Received: by 10.114.124.12 with SMTP id w12mr1631466wac.210.1208448448594;
	Thu, 17 Apr 2008 09:07:28 -0700 (PDT)
Received: by 10.114.102.14 with HTTP; Thu, 17 Apr 2008 09:07:28 -0700 (PDT)
Message-ID: <2ca799770804170907y2f94d97cua896b9741204023b@mail.gmail.com>
Date: Thu, 17 Apr 2008 19:07:28 +0300
From: "Mikko Partio" <mpartio@gmail.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Subject: Re: FATAL: could not open relation xxx: No such file or directory
Cc: "Pavan Deolasee" <pavan.deolasee@gmail.com>, pgsql-admin@postgresql.org
In-Reply-To: <2ca799770804170859t39a5532x4629953e0ec3a600@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_1724_29092940.1208448448582"
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>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200804/176
X-Sequence-Number: 28940

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

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

>
>
> 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.
>

Oh yeah and the kernel version is 2.6.18-53.1.14.el5.

Regards

Mikko

------=_Part_1724_29092940.1208448448582
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 6:59 PM, Mikko Partio &lt;<a href="mailto:mpartio@gmail.com">mpartio@gmail.com</a>&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 6:10 PM, Tom Lane &lt;<a href="mailto:tgl@sss.pgh.pa.us" target="_blank">tgl@sss.pgh.pa.us</a>&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@gmail.com" target="_blank">mpartio@gmail.com</a>&gt; writes:<br>
&gt; Seems like the whole db is falling apart.<br>
<br>
</div>I think you&#39;ve got really serious filesystem-level problems. &nbsp;Have you<br>
tried running any hardware diagnostics? &nbsp;Are you sure you&#39;re using a<br>
stable kernel version?</blockquote></div></div><div><br>I run fsck on the filesystem (gfs) -- no problems found. The disks are from a san and the diagnostic programs say there&#39;s nothing wrong. I also have other db clusters running on different filesystems (also gfs) and I have never had any problems with them.</div>
</div></blockquote><div><br>Oh yeah and the kernel version is 2.6.18-53.1.14.el5.<br><br>Regards<br><br>Mikko<br></div></div>

------=_Part_1724_29092940.1208448448582--