Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 5A5289FB465 for ; Tue, 26 Sep 2006 19:21:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 11618-07 for ; Tue, 26 Sep 2006 22:21:45 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.239]) by postgresql.org (Postfix) with ESMTP id F23169FB463 for ; Tue, 26 Sep 2006 19:21:44 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id t13so2446005wxc for ; Tue, 26 Sep 2006 15:21:43 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=TTL6hM6GmtLfpYIg/FJMr2e3duHvJCbeA6pkHynpKXAnRHYioWtgBpgE/MyxmL34qLl0uUVPU9BU6puKOqWg23hs4ihDnHN0owztX00eZdeX/xo2kg1yCgIofJa7sdDjanqSQVUBdLx9RO2mXqg0u77XypKTlbdKIHxUPBvOZyo= Received: by 10.70.29.14 with SMTP id c14mr8695wxc; Tue, 26 Sep 2006 15:21:43 -0700 (PDT) Received: by 10.70.71.18 with HTTP; Tue, 26 Sep 2006 15:21:43 -0700 (PDT) Message-ID: Date: Tue, 26 Sep 2006 15:21:43 -0700 From: "Talha Khan" To: "Gregory S. Williamson" Subject: Re: Runtime error: could not open segment 1 of relation ... Cc: pgsql-admin@postgresql.org In-Reply-To: <71E37EF6B7DCC1499CEA0316A256832802B3E60A@loki.wc.globexplorer.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_20968_8664798.1159309303101" References: <71E37EF6B7DCC1499CEA0316A256832802B3E60A@loki.wc.globexplorer.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.2 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/315 X-Sequence-Number: 23229 ------=_Part_20968_8664798.1159309303101 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi Greg, Is it possible that the server was shutdown using -mi switch? cuz immediate shutdown ends causing these problems. Regards Talha Khan On 9/26/06, Gregory S. Williamson wrote: > > This morning one of our production servers (8.1.1, Linux) threw a number > of errors like these (different final number; first two [1663/43801] are > all the same]: > > 2006-09-26 10:02:15.124 PDT 1387333718 ERROR: could not open segment 1 of > relation 1663/43801/7274801 (target block 478216192): No such file or > directory > 2006-09-26 10:02:52.991 PDT 1387340456 ERROR: could not open segment 1 of > relation 1663/43801/7274801 (target block 478216192): No such file or > directory > 2006-09-26 10:02:53.002 PDT 1387340458 ERROR: could not open segment 1 of > relation 1663/43801/7274801 (target block 478216192): No such file or > directory > > The server never really recovered -- it kept running but was horribly > slow. Rebooting seems to have cured the problem, but I am wondering what I > made look into, etc. > > The server in question is really a read-only beast with several hundred > connections, typically, 4 gigs of RAM, and has not misbehaved before. > > Any suggestions would be welcome! (Although I fear I know the answer -- > disk issues.) > > Thanks, > > Greg Williamson > DBA > GlobeXplorer LLC > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > ------=_Part_20968_8664798.1159309303101 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hi Greg,
 
Is it possible that the server was shutdown using -mi switch?
 
cuz immediate shutdown ends causing these problems.
 
Regards
Talha Khan

 
On 9/26/06, Gregory S. Williamson <gsw@globexplorer.com> wrote:
This morning one of our production servers (8.1.1, Linux) threw a number of  errors like these (different final number; first two [1663/43801] are all the same]:

2006-09-26 10:02:15.124 PDT 1387333718 ERROR:  could not open segment 1 of relation 1663/43801/7274801 (target block 478216192): No such file or directory
2006-09-26 10:02:52.991 PDT 1387340456 ERROR:  could not open segment 1 of relation 1663/43801/7274801 (target block 478216192): No such file or directory
2006-09-26 10:02:53.002 PDT 1387340458 ERROR:  could not open segment 1 of relation 1663/43801/7274801 (target block 478216192): No such file or directory

The server never really recovered -- it kept running but was horribly slow. Rebooting seems to have cured the problem, but I am wondering what I made look into, etc.

The server in question is really a read-only beast with several hundred connections, typically, 4 gigs of RAM, and has not misbehaved before.

Any suggestions would be welcome! (Although I fear I know the answer -- disk issues.)

Thanks,

Greg Williamson
DBA
GlobeXplorer LLC

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

------=_Part_20968_8664798.1159309303101--