Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id C135B2E005A for ; Tue, 29 Apr 2008 02:30:06 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 29089-08 for ; Tue, 29 Apr 2008 02:29:54 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.28]) by developer.postgresql.org (Postfix) with ESMTP id 0C50E2E0052 for ; Tue, 29 Apr 2008 02:05:19 -0300 (ADT) Received: by yw-out-2324.google.com with SMTP id 5so1594170ywb.73 for ; Mon, 28 Apr 2008 22:05:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=F13C46uJfSoVQ2J0rjugONP7MxW7fm0KOeQDW0GRsM8=; b=XWJQ1Z92HULtreM4phYX0SAHYHQC3PWa7SSwAQpJlUuTjOqPhGXyc19GrX7crZ+4x0cabQwofBzwScZdc/xoqeAEVNru9M0b4fp+E5DG4ygW1HTbwUxibs/pu5SDgA6Ni2A0KzOeCz4P5vkOQSlkySuxQfKT4aG2zvaIZHVpmJw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=S8cna2TXj589Kl/C1YoVYIx8KZxY+3rjp9K8fZgzJzhEOZ2eKRHT8pkBJ3+NBA45FeLgSeM5jy5XF3FRoaA8HP+TQW90mVbQFETfwCttHhFdMVZUprDQ4IMXwf5ePqY7QO2qmxgdeo5auwsbl5EDxXMuWdejzFWU32P3ZFhKaNA= Received: by 10.150.49.1 with SMTP id w1mr4680251ybw.24.1209445511331; Mon, 28 Apr 2008 22:05:11 -0700 (PDT) Received: by 10.150.53.20 with HTTP; Mon, 28 Apr 2008 22:05:11 -0700 (PDT) Message-ID: <4544e0330804282205odfcac5al6bca78bd27c8751b@mail.gmail.com> Date: Tue, 29 Apr 2008 00:05:11 -0500 From: "Peter Koczan" To: "pgsql-admin@postgresql.org" Subject: Bus error in postgres 8.3 MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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: 200804/273 X-Sequence-Number: 29037 Hi all, I'm looking to push 8.3 out this week, but I'm running into a particularly nasty bus error. I'm not sure what's causing it as it appears to be transient (or at least somewhat random), but I do know that it bites on connection time and takes down the entire server with it. 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). If anyone has any idea what's going on and could clue me in, that would be excellent. Peter P.S. Here's the syslog transcript of the crash. Apr 28 23:02:02 mitchell postgres[3442]: [3-1] LOG: connection received: host=mitchell.cs.wisc.edu port=37588 Apr 28 23:02:02 mitchell postgres[3442]: [4-1] LOG: connection authorized: user=postgres database=template1 Apr 28 23:02:02 mitchell postgres[3442]: [5-1] LOG: disconnection: session time: 0:00:00.239 user=postgres database=template1 host=mitchell.cs.wisc.edu port=37588 Apr 28 23:02:02 mitchell postgres[3444]: [3-1] LOG: connection received: host=mitchell.cs.wisc.edu port=37589 Apr 28 23:02:02 mitchell postgres[3444]: [4-1] LOG: connection authorized: user=postgres database=564testdb Apr 28 23:02:02 mitchell postgres[461]: [3-1] LOG: server process (PID 3444) was terminated by signal 7: Bus error Apr 28 23:02:02 mitchell postgres[461]: [4-1] LOG: terminating any other active server processes Apr 28 23:02:02 mitchell postgres[461]: [5-1] LOG: all server processes terminated; reinitializing Apr 28 23:02:02 mitchell postgres[3447]: [6-1] LOG: connection received: host=mitchell.cs.wisc.edu port=37590 Apr 28 23:02:02 mitchell postgres[3447]: [7-1] FATAL: the database system is in recovery mode Apr 28 23:02:02 mitchell postgres[3448]: [6-1] LOG: connection received: host=mitchell.cs.wisc.edu port=37591 Apr 28 23:02:02 mitchell postgres[3448]: [7-1] FATAL: the database system is in recovery mode Apr 28 23:02:23 mitchell postgres[461]: [6-1] LOG: startup process (PID 3446) was terminated by signal 7: Bus error Apr 28 23:02:23 mitchell postgres[461]: [7-1] LOG: aborting startup due to startup process failure Apr 28 23:22:15 mitchell postgres[3702]: [1-1] LOG: could not load root certificate file "root.crt": No such file or directory Apr 28 23:22:15 mitchell postgres[3702]: [1-2] DETAIL: Will not verify client certificates. Apr 28 23:22:15 mitchell postgres[3703]: [2-1] LOG: database system was interrupted; last known up at 2008-04-28 07:02:32 CDT Apr 28 23:22:15 mitchell postgres[3703]: [3-1] LOG: database system was not properly shut down; automatic recovery in progress Apr 28 23:22:15 mitchell postgres[3703]: [4-1] LOG: record with zero length at 6/915320A0