Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 73F3A632D74 for ; Mon, 29 Mar 2010 16:26:41 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 38817-06 for ; Mon, 29 Mar 2010 19:26:26 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-yw0-f184.google.com (mail-yw0-f184.google.com [209.85.211.184]) by mail.postgresql.org (Postfix) with ESMTP id 8C9AD6324E2 for ; Mon, 29 Mar 2010 16:26:29 -0300 (ADT) Received: by ywh14 with SMTP id 14so3524595ywh.15 for ; Mon, 29 Mar 2010 12:26:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :from:date:received:message-id:subject:to:cc:content-type; bh=zcQ1cD5XFGYEGsM4q/Fu6TjKBWsiVF7ZmMcrfCCgJ20=; b=tTI6OTd6gNM+ZYJyeKhE9EqVkhYgODsBP5kGkAQHUCBwz/IJOOCw6kDylnaFOTpJFz zjDToPIOC7BDnThGJCdHCPzQmpDKWkMu0L1lD6Y1rFCpUQazIXCCDLphNiRg2WUDbUMR LY4lumdjBKjuNT/FZ/4VWGOLMRfGPVzr9cPp8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; b=Dq6GDN5FVctVtgfBMgoRYMHgUFBtwC8PBKNr4kZ3lVlV4Oroj27JnsWnPE2IdT4S1W 4rBjieePvITDy2Rfx9wH0K+mo/jadrOeaOBzScRJ2LFyhL5Ez3cqRjWMps8sM4NR6Y/K q9PZC8VTcX3gYDyC5ZrHdkf+yNqkNnhj8tcPs= MIME-Version: 1.0 Received: by 10.90.78.7 with HTTP; Mon, 29 Mar 2010 12:26:08 -0700 (PDT) In-Reply-To: <719e433b1c118d4d8de72f171199678a.squirrel@mail.brad.office.comodo.net> References: <201003281841.41865.mike.williams@comodo.com> <25082.1269800427@sss.pgh.pa.us> <3c7898fc579b37bfec2f5ff971df7532.squirrel@mail.brad.office.comodo.net> <4588.1269805790@sss.pgh.pa.us> <719e433b1c118d4d8de72f171199678a.squirrel@mail.brad.office.comodo.net> From: Alex Hunsaker Date: Mon, 29 Mar 2010 13:26:08 -0600 Received: by 10.91.55.25 with SMTP id h25mr3878383agk.61.1269890788411; Mon, 29 Mar 2010 12:26:28 -0700 (PDT) Message-ID: <34d269d41003291226n4bdc8f57t96132a22df64dea1@mail.gmail.com> Subject: Re: ERROR: could not open segment 1 of relation 1663/743352/743420 (target block 6407642): No such file or directory To: Mike Williams Cc: Tom Lane , pgsql-admin@postgresql.org Content-Type: text/plain; charset=UTF-8 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.455 tagged_above=-10 required=5 tests=AWL=0.144, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/232 X-Sequence-Number: 34031 On Sun, Mar 28, 2010 at 16:27, Mike Williams wrote: > Test are para-virt VMs with "regular" kernels, production are real > machines with hardened kernels (grsec+pax). Ive seen this error on a few boxes around here, using a non grsec kernel fixes it. I never bothered to report it because I cant reproduce it and it goes away without grsec. (2.6.30-32 IIRC, have not tired the latest 33). Interestingly I have the *exact* same hardware and setup (kernel/userspace/postgres etc) on a test machine that I've never been able to trigger it on.