pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





view thread (5+ messages)  latest in thread

Message-ID: <37797.1604005112@sss.pgh.pa.us>
Permalink:  ../37797.1604005112@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/37797.1604005112@sss.pgh.pa.us

 · 

reply

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