Re: BUG #17727: A query crashes server process: ... was terminated by signal 7: Bus error / Segmentation Fault

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