Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kZeBf-0006dn-Ev for pgsql-admin@arkaria.postgresql.org; Mon, 02 Nov 2020 18:04:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kZeBe-0003OG-E1 for pgsql-admin@arkaria.postgresql.org; Mon, 02 Nov 2020 18:04:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kZeBe-0003O9-6H for pgsql-admin@lists.postgresql.org; Mon, 02 Nov 2020 18:04:10 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kZeBb-00065y-RD for pgsql-admin@postgresql.org; Mon, 02 Nov 2020 18:04:09 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 0A2I46ZV686893; Mon, 2 Nov 2020 13:04:06 -0500 From: Tom Lane To: S Bob cc: Peter Geoghegan , pgsql-admin Subject: Re: How to analyze a core dump In-reply-to: <293bf7b3-9fe0-e49e-eaee-031aaf11066f@quadratum-braccas.com> References: <328ba050-4a99-d4ea-0f65-6b268c0e8b89@quadratum-braccas.com> <293bf7b3-9fe0-e49e-eaee-031aaf11066f@quadratum-braccas.com> Comments: In-reply-to S Bob message dated "Mon, 02 Nov 2020 10:04:28 -0700" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <686891.1604340246.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Mon, 02 Nov 2020 13:04:06 -0500 Message-ID: <686892.1604340246@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk S Bob writes: > On 11/2/20 9:55 AM, Peter Geoghegan wrote: >> Is signal 10 SIGBUS on your platform? Perhaps check the relevant man >> page on your platform -- "man signal.7" works for me here. >> What CPU architecture and operating system are you using? > 32 bit, Solaris 10 Solaris should be enough like other Unixen to presume that SIGBUS is 10. However, that doesn't get you far towards finding a root cause. Since you have a core file, maybe you could extract a stack trace from it? We have some suggestions at https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_Postgr= eSQL_backend_on_Linux/BSD although I'm afraid that's pretty gdb-specific, and Solaris probably has different debugging tools. What PG version are you running, exactly? regards, tom lane