From: Tom Lane <tgl@sss.pgh.pa.us>
To: oserov@clickup.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17727: A query crashes server process: ... was terminated by signal 7: Bus error / Segmentation Fault
Date: Wed, 21 Dec 2022 14:44:08 -0500
Message-ID: <1583845.1671651848@sss.pgh.pa.us> (raw)
In-Reply-To: <17727-c9a10259e190c8b1@postgresql.org>
References: <17727-c9a10259e190c8b1@postgresql.org>
PG Bug reporting form <noreply@postgresql.org> writes:
> I have a query that consistently results in server crash and "server process
> ... was terminated by signal 7: Bus error" running on any replica or master
> of the DB. I also have a more generic query that also crashes other
> masters/replicas in prod environment but with 'Segmentation Fault'. I can't
> reproduce the same crash in other non-prod environments. I am unable to
> provide repro steps that could reproduce this error on a local machine and
> looking for more guidance how to debug/mitigate this error.
If you can provide a stack trace from the crash, that might be enough
to diagnose it.
https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
However ... the first thing I'd probably try is turning off JIT.
We've heard some reports suggesting that that causes trouble on
ARM machines.
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, oserov@clickup.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17727: A query crashes server process: ... was terminated by signal 7: Bus error / Segmentation Fault
In-Reply-To: <1583845.1671651848@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