Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 65A052E0050 for ; Fri, 2 May 2008 06:00:14 -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 29900-10 for ; Fri, 2 May 2008 06:00:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from out4.smtp.messagingengine.com (out4.smtp.messagingengine.com [66.111.4.28]) by developer.postgresql.org (Postfix) with ESMTP id 497D72E0056 for ; Fri, 2 May 2008 06:00:06 -0300 (ADT) Received: from compute1.internal (compute1.internal [10.202.2.41]) by out1.messagingengine.com (Postfix) with ESMTP id 1A6F8104BBA; Fri, 2 May 2008 05:00:02 -0400 (EDT) Received: from heartbeat1.messagingengine.com ([10.202.2.160]) by compute1.internal (MEProxy); Fri, 02 May 2008 05:00:02 -0400 X-Sasl-enc: 7iTe9eQiXPwN2vO6/gneu7/ttNOcFzUoydZAqqGqNwnU 1209718801 Received: from [10.128.0.117] (unknown [218.30.180.194]) by mail.messagingengine.com (Postfix) with ESMTPSA id 337AC7D19; Fri, 2 May 2008 04:59:59 -0400 (EDT) Message-ID: <481AD7F1.3030708@fastmail.net> Date: Fri, 02 May 2008 16:59:29 +0800 From: Darren Reed User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: Filip Svendsen CC: Tom Lane , Peter Koczan , "pgsql-admin@postgresql.org" Subject: Re: Bus error in postgres 8.3 References: <4544e0330804282205odfcac5al6bca78bd27c8751b@mail.gmail.com> <25410.1209448864@sss.pgh.pa.us> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200805/27 X-Sequence-Number: 29111 Filip Svendsen wrote: > On Tue, Apr 29, 2008 at 8:01 AM, Tom Lane wrote: > >> "Peter Koczan" writes: >> > I'm going to try to force a crash on my test server to see if I can >> > find out anything more. Does anyone know how to get useful debugging >> > info at the time of the crash? I don't think I have things set to dump >> > core anywhere, but that and/or stack traces would be nice (especially >> > for child processes). >> >> Make sure the postmaster is started under ulimit -c unlimited. >> On a depressingly large fraction of modern platforms, daemons are >> started with ulimit -c 0 by default :-(. Try putting "ulimit -c unlimited" >> into your PG init script and restarting. >> >> regards, tom lane >> > > Do you think a too low limit on user processes could be causing the problem? > > We have had similar crashes (server process terminated with Bus > Error). This is running 8.2.5 on OS X (Tiger, intel), with about > 130-140 connections, but the process count limit is 1000. Any reason > why the process limit should be vastly higher than the number of > connections? > "ulimit -c unlimited" sets the core dump size to be unlimited, not the connection count. That would be related to "ulimit -n" (descriptor count.) Darren