Possible segfault in PostgreSQL 17 / PostGIS 3.5.0

[Paul Ramsey]

Confirmed here. Love a good crasher.
https://trac.osgeo.org/postgis/ticket/5793#ticket

P

> On Oct 9, 2024, at 8:49 AM, Fredrik Widlert <fredrik.widlert at digpro.se> wrote:
> 
> Hi, I think I've found a segfault in PostGIS 3.5.0 and PostGIS 3.4.3 when running on PostgreSQL 17.
> 
> We have a relatively complicated query that used to work on PostgreSQL 16 with PostGIS 3.4.0 but now gives the error.
> Instead of providing the full query, I've minimized it to a trivial version below that still gives the error.
> 
> Tested on:
> * PostgreSQL 17 / PostGIS 3.4.3 installed through apt on Ubuntu 20.04
> * PostgreSQL 17 / PostGIS 3.5.0 installed from source on Ubuntu 24.04
> 
> 
> postgres=# select version();
>                                              version
> --------------------------------------------------------------------------------------------------
>  PostgreSQL 17.0 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.2.0-23ubuntu4) 13.2.0, 64-bit
> 
> postgres=# select postgis_full_version();
> 
> POSTGIS="3.5.0 d2c3ca4" [EXTENSION] PGSQL="170" GEOS="3.12.1-CAPI-1.18.1" PROJ="9.4.0
> NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org <https://cdn.proj.org/> USER_WRITABLE_DIRECTORY=/home/postgres/.local/share/proj DATABASE_PATH=/usr/share/proj/proj.db"
> (compiled against PROJ 9.12.1) LIBXML="2.9.14" LIBJSON="0.17" LIBPROTOBUF="1.4.1" WAGYU="0.5.0 (Internal)"
> (1 row)
> 
> 
> Test case:
> ========
> create extension postgis;
> 
> create table tab (shape geography(GeometryZ,4326));
> 
> select st_buffer(st_collect(array_agg (tab.shape)::geometry[])::geography, 10.0) from tab;
> ========
> 
> Result:
> 
> postgres=# select st_buffer(st_collect(array_agg (tab.shape)::geometry[])::geography, 10.0) from tab;
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
> The connection to the server was lost. Attempting reset: Failed.
> 
> Can others reproduce the same problem or did I do something wrong on my installations?
> /Fredrik

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20241009/3e34fcc0/attachment.htm>