From: Tom Lane <tgl@sss.pgh.pa.us>
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
Date: Thu, 29 Oct 2020 16:58:32 -0400
Message-ID: <37797.1604005112@sss.pgh.pa.us> (raw)
In-Reply-To: <16690-d798fde357528d24@postgresql.org>
References: <16690-d798fde357528d24@postgresql.org>
PG Bug reporting form <noreply@postgresql.org> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, mark.phillips@mophilly.com, 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: <37797.1604005112@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox