From: Matthew Clark <mclark@drmatthewclark.com>
To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: server crash on raspberry pi for large queries
Date: Tue, 20 Aug 2024 00:45:30 +0000 (UTC)
Message-ID: <2123352386.9759142.1724114730509@mail.yahoo.com> (raw)
References: <2123352386.9759142.1724114730509.ref@mail.yahoo.com>
postgres version: PostgreSQL 15.8 (Raspbian 15.8-0+deb12u1) on arm-unknown-linux-gnueabihf, compiled by gcc (Raspbian 12.2.0-14+rpi1)OS: Linux pi 6.6.31+rpt-rpi-v6 #1 Raspbian 1:6.6.31-1+rpt1 (2024-05-29) armv6l GNU/Linux
CPU: (/proc/cpuinfo)
name : ARMv6-compatible processor rev 7 (v6l)
BogoMIPS : 697.95
Features : half thumb fastmult vfp edsp java tls
CPU implementer : 0x41
CPU architecture: 7
CPU variant : 0x0
CPU part : 0xb76
CPU revision : 7
Hardware : BCM2835
Revision : 000e
Serial : 00000000d75e7c8b
Model : Raspberry Pi Model B Rev 2
issue: when issuing a large query , e.g. "Select count(*) from temperature" on a table with > 150M rows the system crashes.
example error: LOG: server process (PID 20037) was terminated by signal 4: Illegal instruction no more diagnostic information is generated.
Workaround : this stops happening when jit_above_cost is set to -1 in postgresql.conf After changing this setting the problem stops.
This was reported in the past for MacOS, and the same workaround was reported to work in that case.
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: mclark@drmatthewclark.com, pgsql-bugs@lists.postgresql.org
Subject: Re: server crash on raspberry pi for large queries
In-Reply-To: <2123352386.9759142.1724114730509@mail.yahoo.com>
* 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