Package: postgresql-15
Version: 15.5-0+deb12u1
Severity: normal
X-Debbugs-Cc: linuxhi...@gmail.com
Dear Maintainer,
I've stumbled over a reproduceable backend crash on arm64 running the following
query on my smartmeter table,
please see the following post on pgsql-general for more details:
https://www.postgresql.org/message-id/CAFvQSYRatUx%2Bj3yeVf%3DAVRdDpXBoUNSHrxjcS02kwKQR2dODNg%40mail.gmail.com
the crash seems to be caused by a bug in llvm-14 (which debian's postgresql
release is built against), this was suggested by upstream.
disabling the jit solved the crash, also the same query+schema works fine using
ubuntu 23 which ships 15.4 + llvm-15.
the query:
SELECT floor(extract(epoch from ts)/60)*60 AS "time", AVG(spannungL1)
as l1, AVG(spannungL2) as l2, AVG(spannungL3) as l3 FROM smartmeter
WHERE ts BETWEEN '2023-12-01T13:01:30.514Z' AND
'2023-12-25T19:01:30.514Z' GROUP BY time order by time;SELECT
floor(extract(epoch from ts)/60)*60 AS "time", AVG(spannungL1)
as l1, AVG(spannungL2) as l2, AVG(spannungL3) as l3 FROM smartmeter
WHERE ts BETWEEN '2023-12-01T13:01:30.514Z' AND
'2023-12-25T19:01:30.514Z' GROUP BY time order by time;
it would be therefore be great if postgresql-15 could be built against llvm >=
15, as those are shipped with debian anyway.
*** Reporter, please consider answering these questions, where appropriate ***
* What led up to the situation?
* What exactly did you do (or not do) that was effective (or
ineffective)?
* What was the outcome of this action?
* What outcome did you expect instead?
*** End of the template - remove these template lines ***
-- System Information:
Debian Release: 12.2
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'stable')
Architecture: arm64 (aarch64)
Foreign Architectures: armhf
Kernel: Linux 6.1.0-rpi7-rpi-v8 (SMP w/4 CPU threads; PREEMPT)
Kernel taint flags: TAINT_CRAP
Locale: LANG=de_AT.UTF-8, LC_CTYPE=de_AT.UTF-8 (charmap=UTF-8) (ignored: LC_ALL
set to de_AT.UTF-8), LANGUAGE=de_AT.UTF-8
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages postgresql-15 depends on:
ii debconf [debconf-2.0] 1.5.82
ii libc6 2.36-9+rpt2+deb12u3
ii libgcc-s1 12.2.0-14
ii libgssapi-krb5-2 1.20.1-2+deb12u1
ii libicu72 72.1-3
ii libldap-2.5-0 2.5.13+dfsg-5
ii libllvm14 1:14.0.6-12
ii liblz4-1 1.9.4-1
ii libpam0g 1.5.2-6+rpt2+deb12u1
ii libpq5 15.5-0+deb12u1
ii libselinux13.4-1+b6
ii libssl33.0.11-1~deb12u2+rpt1
ii libstdc++6 12.2.0-14
ii libsystemd0252.17-1~deb12u1
ii libuuid1 2.38.1-5+b1
ii libxml22.9.14+dfsg-1.3~deb12u1
ii libxslt1.1 1.1.35-1
ii libzstd1 1.5.4+dfsg2-5
ii locales2.36-9+rpt2+deb12u3
ii postgresql-client-15 15.5-0+deb12u1
ii postgresql-common 248
ii ssl-cert 1.1.2
ii tzdata 2023c-5
ii zlib1g 1:1.2.13.dfsg-1
Versions of packages postgresql-15 recommends:
ii sysstat 12.6.1-1
postgresql-15 suggests no packages.
-- debconf information:
postgresql-15/postrm_purge_data: true