Re: BUG #16690: database connection aborted with a signal 9 when query is run on MacOS Catalina

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mark(dot)phillips(at)mophilly(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16690: database connection aborted with a signal 9 when query is run on MacOS Catalina
Date: 2020-10-29 20:58:32
Message-ID: 37797.1604005112@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2020-10-29 21:02:00 Re: BUG #16690: database connection aborted with a signal 9 when query is run on MacOS Catalina
Previous Message David G. Johnston 2020-10-29 20:54:16 Re: BUG #16690: database connection aborted with a signal 9 when query is run on MacOS Catalina