Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 8EFE0B5DBD9 for ; Tue, 4 Oct 2011 16:41:47 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 59042-03 for ; Tue, 4 Oct 2011 19:41:40 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from joeconway.com (wsip-72-214-29-243.sd.sd.cox.net [72.214.29.243]) by mail.postgresql.org (Postfix) with ESMTP id 50BB3B5DC42 for ; Tue, 4 Oct 2011 16:41:39 -0300 (ADT) Received: from www.joeconway.com (account jconway [192.168.4.40] verified) by joeconway.com (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 11427116; Tue, 04 Oct 2011 12:41:38 -0700 Message-ID: <4E8B6172.3000904@joeconway.com> Date: Tue, 04 Oct 2011 12:41:38 -0700 From: Joe Conway User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.8.0.12) Gecko/20071019 Fedora/1.5.0.12-3.fc6 pango-text Thunderbird/1.5.0.12 Mnenhy/0.7.5.666 MIME-Version: 1.0 To: Robert Burgholzer CC: "Burgholzer, Robert (DEQ)" , Scott Marlowe , pgsql-admin@postgresql.org Subject: Re: diagnosing a db crash - server exit code 2 References: <4E7CDCA6.6060803@joeconway.com> <4E7CF42E.2050904@joeconway.com> <4E84AB05.1050106@joeconway.com> <4E89F0CF.9080807@joeconway.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.918 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RDNS_DYNAMIC=0.982 X-Spam-Level: X-Archive-Number: 201110/19 X-Sequence-Number: 38471 On 10/04/2011 12:29 PM, Robert Burgholzer wrote: > So, now I am starting to think that I did something erroneous when > restarting the PG server, because after the most recent crash on my dev > server, it is now seemingly uncrashable. Which makes me think it is > FIXED by the upgrade to 0.13 - which is awesome. Though I was pretty > certain that I had restarted the PG process - but it is possible that I > missed it of course. Are you pre-loading plr? > FWIW, I used the following command: > pg_ctl -D /var/lib/pgsql/data restart -l logfile > > I have run the test query 1,000 times in a loop on my dev server without > a crash now, and it managed to crash the live server in a test after > about 20 invocations earlier today. > > So, thanks to everyone, I will chalk this up as a great learning > experience, I have managed to get my stack traces and so forth, so that > is awesome. Your patience and willingness to help has been awesome. Sounds good -- let us know if the problem resurfaces. Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, & 24x7 Support