PostgreSQL 17 Segmentation Fault

From: Cameron Vogt <cvogt(at)automaticcontrols(dot)net>
To: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: PostgreSQL 17 Segmentation Fault
Date: 2024-10-02 17:16:45
Message-ID: DM6PR16MB314588EDCBF487F0C1EF7BCEAB702@DM6PR16MB3145.namprd16.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I recently upgraded a database from PostgreSQL 11.22 to 17.0. One of my queries which ran fine in PostgreSQL 11 is now causing a segmentation fault in 17. The log file contains this message: "server process (PID 7635) was terminated by signal 11: Segmentation fault","Failed process was running: SELECT DISTINCT ON (""tasks"".""gid""). I tried to delete pieces of the query and rerun it to see if I could determine which part is causing the fault. I attached the minimal query I came up with. If I try to delete any random piece out of the minimal query, it suddenly works again (even just a single line like line #2). I have no idea what is going on with it, but I think it is a bug.

Cameron Vogt | Software Developer

Direct:314-756-2302<tel:314-756-2302> | Cell: 636-388-2050<tel:636-388-2050>
cvogt(at)automaticcontrols(dot)net

1585 Fencorp Drive<https://www.google.com/maps/dir/38.5384448,-90.43968/Automatic+Controls+Equipment+Systems,+Inc.+Fenton,+MO+63026/@38.5371308,-90.448053,16z/data=!3m1!4b1!4m9!4m8!1m1!4e1!1m5!1m1!1s0x87d8cfa7d0262fa3:0x8de9b691c07a1768!2m2!1d-90.4476712!2d38.5358207>
<https://www.google.com/maps/dir/38.5384448,-90.43968/Automatic+Controls+Equipment+Systems,+Inc.+Fenton,+MO+63026/@38.5371308,-90.448053,16z/data=!3m1!4b1!4m9!4m8!1m1!4e1!1m5!1m1!1s0x87d8cfa7d0262fa3:0x8de9b691c07a1768!2m2!1d-90.4476712!2d38.5358207>Fenton, Missouri 63026<https://www.google.com/maps/dir/38.5384448,-90.43968/Automatic+Controls+Equipment+Systems,+Inc.+Fenton,+MO+63026/@38.5371308,-90.448053,16z/data=!3m1!4b1!4m9!4m8!1m1!4e1!1m5!1m1!1s0x87d8cfa7d0262fa3:0x8de9b691c07a1768!2m2!1d-90.4476712!2d38.5358207>
[cid:aces_66e9dd1e-ddf8-4d47-aa75-b72eea6ea7eb.png]
[cid:supportlink_28817f99-b936-4867-8557-910a1c601d21.png]<https://automaticcontrols.net/request-support/>

Attachment Content-Type Size
seg_fault.sql application/octet-stream 3.4 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sean Massey 2024-10-02 20:08:14 Re: PostgreSQL 17 Segmentation Fault
Previous Message Ariel Tejera 2024-10-02 15:55:15 Re: Linux OOM killer