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 1kYF0I-0008Oq-C8 for pgsql-bugs@arkaria.postgresql.org; Thu, 29 Oct 2020 20:58:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kYF0H-000863-5h for pgsql-bugs@arkaria.postgresql.org; Thu, 29 Oct 2020 20:58:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kYF0G-00085w-Vb for pgsql-bugs@lists.postgresql.org; Thu, 29 Oct 2020 20:58:36 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kYF0E-0000WZ-KI for pgsql-bugs@lists.postgresql.org; Thu, 29 Oct 2020 20:58:36 +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 09TKwWa1037798; Thu, 29 Oct 2020 16:58:32 -0400 From: Tom Lane To: mark.phillips@mophilly.com cc: pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16690: database connection aborted with a signal 9 when query is run on MacOS Catalina In-reply-to: <16690-d798fde357528d24@postgresql.org> References: <16690-d798fde357528d24@postgresql.org> Comments: In-reply-to PG Bug reporting form message dated "Thu, 29 Oct 2020 20:31:46 -0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <37796.1604005112.1@sss.pgh.pa.us> Date: Thu, 29 Oct 2020 16:58:32 -0400 Message-ID: <37797.1604005112@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PG Bug reporting form writes: > The following query works on... > Windows 10 Education Build 1909 18363.1139 PostgreSQL 12.1, compiled by > Visual C++ build 1914, 64-bit > Mojave 10.14.6 PostgreSQL 12.1 on x86_64-apple-darwin, compiled by Apple > LLVM version 6.0 (clang-600.0.54) (based on LLVM 3.5svn), 64-bit > but causes a database connection to be aborted (signal 9) when run on... > Catalina 10.15.6 PostgreSQL 12.1 on x86_64-apple-darwin, compiled by Apple > LLVM version 6.0 (clang-600.0.54) (based on LLVM 3.5svn), 64-bit Not a lot we can do with that level of detail. Can you provide a self-contained test case? (That is, besides the query, we need the table definitions and some possibly-dummy data. Ideally, provide a SQL script that provokes the crash starting from an empty database.) It'd also be quite useful to know what build options you used. Notably, I'm wondering about whether you enabled JIT (--with-llvm). regards, tom lane