pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: github.stheine@heine7.de
Subject: BUG #18503: Reproducible 'Segmentation fault' in 16.3 on ARM64
Date: Tue, 11 Jun 2024 09:59:39 +0000
Message-ID: <18503-6e0f5ab2f9c319c1@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      18503
Logged by:          Stefan Heine
Email address:      github.stheine@heine7.de
PostgreSQL version: 16.3
Operating system:   Ubuntu 24.04, Debian bookworm
Description:        

This is a followup of
https://www.postgresql.org/message-id/flat/18471-4e01d7601cedf1b0%40postgresql.org
and maybe related to
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1059476

The query described in
https://www.postgresql.org/message-id/flat/18471-4e01d7601cedf1b0%40postgresql.org
is causing a reproducible 'Segmentation fault'.
I have tried various versions of postgresql on different OS versions, trying
to find one that works fine, but this happens in 14.8, 14.12, 16.3 on Debian
bookworm.
It also happens in 16.3 on Ubuntu 24.04 when installing the standard
OS-provided version of postgresql.
I also tried installing the 16.3 on Ubuntu 24.04 from
https://wiki.postgresql.org/wiki/Apt, and it's still failing.

The issue is clearly related to jit, since it only reproduces if jit is
enabled and forced to kick in (jit_above_cost = 1, jit_inline_above_cost =
1,
jit_optimize_above_cost = 1). disabling jit makes the query run fine.

in https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1059476 there was a
similar issue, that pointed to llvm v14, but the postgresql version from
https://wiki.postgresql.org/wiki/Apt mentions `libllvm17t64`, so this seems
to include a newer version and still aborts.

That situation is clearly reproducible, so we can help troubleshooting in
case you want to look into details.



view thread (7+ messages)  latest in thread

Message-ID: <18503-6e0f5ab2f9c319c1@postgresql.org>
Permalink:  ../18503-6e0f5ab2f9c319c1@postgresql.org/
Also on:    postgresql.org/message-id/18503-6e0f5ab2f9c319c1@postgresql.org

 · 

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: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, github.stheine@heine7.de
  Subject: Re: BUG #18503: Reproducible 'Segmentation fault' in 16.3 on ARM64
  In-Reply-To: <18503-6e0f5ab2f9c319c1@postgresql.org>

* 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