Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 2463A133740B for ; Thu, 9 Dec 2010 23:25:17 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 76643-02 for ; Fri, 10 Dec 2010 03:25:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 73011133655C for ; Thu, 9 Dec 2010 23:25:09 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id oBA3P3hu012696; Thu, 9 Dec 2010 22:25:04 -0500 (EST) To: Samuel Stearns cc: "pgsql-admin@postgresql.org" Subject: Re: Postgres Crash In-reply-to: <68B59BEDCD36854AADBDF17E91B2937A07844CD029@EXCHMAIL.staff.internode.com.au> References: <68B59BEDCD36854AADBDF17E91B2937A07844CD029@EXCHMAIL.staff.internode.com.au> Comments: In-reply-to Samuel Stearns message dated "Fri, 10 Dec 2010 13:47:49 +1030" Date: Thu, 09 Dec 2010 22:25:03 -0500 Message-ID: <12695.1291951503@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_FRT_STOCK2=0.01, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/60 X-Sequence-Number: 36289 Samuel Stearns writes: > Environment: > Solaris 10 > Postgres 8.3.12 > Postgres crashed and left 26 postmaster processes active in it's wake. Killed the children and re-started postgres successfully. Messages from the log: > Dec 10 11:52:15 udrv postgres[771]: [ID 748848 local0.info] [6-1] host=,user=,db= LOG: setsockopt(TCP_NODELAY) failed: Invalid argument > Dec 10 11:52:20 udrv postgres[2183]: [ID 748848 local0.error] [1-1] host=,user=,db= FATAL: pre-existing shared memory block (key 5432001, ID 0) is still in use > Dec 10 11:52:20 udrv postgres[2183]: [ID 748848 local0.error] [1-2] host=,user=,db= HINT: If you're sure there are no old server processes still running, remove the shared memory block with the > Dec 10 11:52:20 udrv postgres[2183]: [ID 748848 local0.error] [1-3] command "ipcclean", "ipcrm", or just delete the file "postmaster.pid". > With the 'FATAL' and 'HINT' lines repeating. > Any ideas what occurred here? Nope. The log entries above are from the restart attempt, and give no information about the crash. If you have any log entries from before that, or have a core file that would yield a backtrace, maybe we could draw some conclusions from that info. regards, tom lane