Hi Thomas,
In case it is helpful for analyzing whats causing the cash, I've
uploaded the db dump I experience the crash on to:
https://drive.google.com/file/d/1H9Y3FaoBafakHwXhpT3s8NNQ1UNJLpJY/view?usp=sharing
The only steps I had to do to trigger the crash were:
- Start with fresh rasperry pi os bookworm 64-bit image
- install postgresql (packages are pulled from debian and also match
debian's md5 sums so I guess there should be no difference caused by
using raspberry pi os base image)
- import the linked db export with psql -f (I had to generate de_AT locale first
- execute the query
Best regards, Clemens
Am Di., 26. Dez. 2023 um 23:16 Uhr schrieb Thomas Munro
<thomas.munro@gmail.com>:
>
> On Wed, Dec 27, 2023 at 5:17 AM Clemens Eisserer <linuxhippy@gmail.com> wrote:
> > > FWIW, since this crash is inside LLVM you could presumably dodge the bug
> > > by setting "jit" to off.
> >
> > Thanks, this indeed solved the crash.
> > Just to make sure this crash doesn't have anything to do with my
> > setup/config (I'd changed quite a few settings in postgresql.conf),
> > I gave it a try on a fresh bookworm install and it also crashed immeditaly.
> >
> > > As for an actual fix, perhaps a newer version of LLVM is needed?
> > > I don't see a problem testing this query on my RPI with Ubuntu 23.10
> > > (LLVM 16).
> >
> > I also gave Ubuntu 23.10 a try (15.4 built with llvm-15) and it worked
> > as expected, explain analyze even mentioned the JIT was active.
>
> I can't reproduce this on LLVM 14 on an aarch64 Mac FWIW (after
> setting jit_*_cost to 0, as required since the table is empty).
>
> > I've filed a debian bug report with a link to this discussion and a
> > plea to build postgresql against llvm >= 15:
> > https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1059476
>
> I doubt they'll change that, and in any case we'll need to get to the
> bottom of this. Perhaps an assertion build of LLVM will fail in some
> illuminating internal assertion? Unfortunately it's a non-trivial
> business to get a debug build of LLVM going (it takes oodles of disk
> and CPU and a few confusing-to-me steps)...
>
> . o O ( It would be wonderful if assertion-enabled packages were
> readily available for a common platform like Debian. I've finally
> been spurred on to reach out to the maintainer of apt.llvm.org to ask
> about that. It'd also be very handy for automated next-version
> monitoring. )