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 |
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 |