server crash on raspberry pi for large queries

From: Matthew Clark <mclark(at)drmatthewclark(dot)com>
To: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: server crash on raspberry pi for large queries
Date: 2024-08-20 00:45:30
Message-ID: 2123352386.9759142.1724114730509@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sindhu S 2024-08-20 03:37:18 Re: Report Postgres Bug - Unlogged table sequence
Previous Message Andrei Lepikhov 2024-08-19 19:16:22 Re: BUG #18576: Using EXPLAIN (VERBOSE) in information_schema.element_types returns ERROR: failed to find plan for