Possible segfault in PostgreSQL 17 / PostGIS 3.5.0

Fredrik Widlert fredrik.widlert at digpro.se
Wed Oct 9 08:49:26 PDT 2024


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
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/bcd04e27/attachment.htm>


More information about the postgis-devel mailing list