Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 2D9152E005B for ; Thu, 17 Apr 2008 12:59:33 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 82864-03 for ; Thu, 17 Apr 2008 12:59:25 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rn-out-0910.google.com (rn-out-0910.google.com [64.233.170.184]) by developer.postgresql.org (Postfix) with ESMTP id 6FCBF2E006F for ; Thu, 17 Apr 2008 12:59:23 -0300 (ADT) Received: by rn-out-0910.google.com with SMTP id i24so91073rng.0 for ; Thu, 17 Apr 2008 08:59:22 -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=vrmj62euvbQa10wOes0OnNcFR3YC9W1aetv28ALN/1A=; b=ByHaqJ81dIMmy5BfkQxQT1MecYrEqPhWC1JLKrcUh6Wz1Q93rG2nFrJJxSrGWlAA/2PAQ8IRTi+m/gpYkbPPITErqQTfumSWyt1NjAp0qPxaUoZBoifDQip0KLNPWGBWthoF/53ZtNJ/9XHpJtOjdGPTm28+zu8q2XHtX4+bwZA= 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=d3kDIJY2gy1wxDnbcX+rXKofOV1M+gAaC1KEdHvV6Q/hU4xUArHDcGDZRaBc2aMTj5NSF7j8q9xjkQERUcKCYTUa2uFNT+E5Nx/sK79N00dSRyzdvePCA85ke0qcQ6CJ3e03izBYD9wzeR3h8n7XRGPMjhwVUpb4tGZ72keU4NY= Received: by 10.114.178.13 with SMTP id a13mr1629854waf.182.1208447961643; Thu, 17 Apr 2008 08:59:21 -0700 (PDT) Received: by 10.114.102.14 with HTTP; Thu, 17 Apr 2008 08:59:21 -0700 (PDT) Message-ID: <2ca799770804170859t39a5532x4629953e0ec3a600@mail.gmail.com> Date: Thu, 17 Apr 2008 18:59:21 +0300 From: "Mikko Partio" To: "Tom Lane" Subject: Re: FATAL: could not open relation xxx: No such file or directory Cc: "Pavan Deolasee" , pgsql-admin@postgresql.org In-Reply-To: <20021.1208445022@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1677_23368030.1208447961631" 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> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/174 X-Sequence-Number: 28938 ------=_Part_1677_23368030.1208447961631 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On Thu, Apr 17, 2008 at 6:10 PM, Tom Lane wrote: > "Mikko Partio" 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 ------=_Part_1677_23368030.1208447961631 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline

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

------=_Part_1677_23368030.1208447961631--