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@xxxxxxxxx>: > > On Wed, Dec 27, 2023 at 5:17 AM Clemens Eisserer <linuxhippy@xxxxxxxxx> 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. )
