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
On Wed, Dec 27, 2023 at 5:17 AM Clemens Eisserer 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
Hi Tom,
> 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
Clemens Eisserer writes:
> Program received signal SIGSEGV, Segmentation fault.
> 0x007fe5e6a9f0 in ?? () from /lib/aarch64-linux-gnu/libLLVM-14.so.1
> (gdb) bt full
> #0 0x007fe5e6a9f0 in ?? () from /lib/aarch64-linux-gnu/libLLVM-14.so.1
> No symbol table info available.
> #1 0x007f
On 12/25/23 13:51, Clemens Eisserer wrote:
Hi Adrian,
How did you upgrade?
A fresh install based on "Raspberry Pi OS Lite" image provided (based
on debian bookworm) with pgdump_all & plsql -f.
Did you install the 32 or 64 bit version from here?:
https://www.raspberrypi.com/software/opera
> Does that install Postgres as part of the image or did you get it from
> somewhere else?
I installed it via "apt-get install postgresql" and it downloaded
postgresql-15_15.5-0+deb12u1_arm64.deb - which seems to be the current
package shipped with debian bookworm for arm64:
https://packages.debia
On 12/25/23 13:51, Clemens Eisserer wrote:
Hi Adrian,
How did you upgrade?
A fresh install based on "Raspberry Pi OS Lite" image provided (based
Does that install Postgres as part of the image or did you get it from
somewhere else?
on debian bookworm) with pgdump_all & plsql -f.
--
Hi Adrian,
> How did you upgrade?
A fresh install based on "Raspberry Pi OS Lite" image provided (based
on debian bookworm) with pgdump_all & plsql -f.
On 12/25/23 13:01, Clemens Eisserer wrote:
Hi,
I've just updated my raspberry pi 3 from postgresql-13.3 on
bullseye/armv6 to postgresq-15.5 on debian-bookworm/armv8.
How did you upgrade?
--
Adrian Klaver
adrian.kla...@aklaver.com
Hi,
I've just updated my raspberry pi 3 from postgresql-13.3 on
bullseye/armv6 to postgresq-15.5 on debian-bookworm/armv8.
However after the upgrade, I experience reproducable crashes quering
the following table:
CREATE TABLE public.smartmeter (
leistungsfaktor real,
momentanleistung integ
10 matches
Mail list logo
