[postgis-users] Postgis 3.1.0 st_makevalid crashes the PostgreSQL Server

[Nicolas Ribot]

Hi,

I could also reproduce it on MacOS
(POSTGIS="3.1.0 5e2af69" [EXTENSION] PGSQL="130" GEOS="3.9.0-CAPI-1.16.2"
SFCGAL="1.3.9" PROJ="7.2.0" GDAL="GDAL 3.2.0, released 2020/10/26"
LIBXML="2.9.4" LIBJSON="0.15" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)"
TOPOLOGY RASTER)

The buffer operation returns an empty polygon.
Running these queries crashes the backend (server process (PID 93524) was
terminated by signal 6: Abort trap: 6):

select st_makeValid(st_multi('POLYGON EMPTY'::geometry));
select st_makeValid('GEOMETRYCOLLECTION EMPTY'::geometry);
select st_makeValid('MULTIPOLYGON EMPTY'::geometry);

Nicolas

On Mon, 25 Jan 2021 at 11:52, Fatih Sazan <fatihsazan01 at gmail.com> wrote:

> my postgis verison details:
> SELECT postgis_full_version();
>
> POSTGIS="3.1.0 5e2af69" [EXTENSION] PGSQL="130" GEOS="3.9.0-CAPI-1.16.2"
> PROJ="7.2.1" LIBXML="2.9.7" LIBJSON="0.13.1" LIBPROTOBUF="1.3.0"
> WAGYU="0.5.0 (Internal)" (core procs from "3.1.0alpha2 b6f415d" need
> upgrade) TOPOLOGY (topology procs from "3.1.0alpha2 b6f415d" need upgrade)
>
> Bjornar Skinnes <bjornar_skinnes at trimble.com>, 25 Oca 2021 Pzt, 11:40
> tarihinde şunu yazdı:
>
>> postgis/postgis:latest image today.  So I also could reproduce this
>> error. fyi.
>> POSTGIS="3.1.0 5e2af69" [EXTENSION] PGSQL="130" GEOS="3.7.1-CAPI-1.11.1
>> 27a5e771" PROJ="Rel. 5.2.0, September 15th, 2018" LIBXML="2.9.4"
>> LIBJSON="0.12.1" LIBPROTOBUF="1.3.1" WAGYU="0.5.0 (Internal)" TOPOLOGY
>>
>> man. 25. jan. 2021 kl. 09:35 skrev Sandro Santilli <strk at kbt.io>:
>>
>>> On Mon, Jan 25, 2021 at 10:19:42AM +0300, Fatih Sazan wrote:
>>> > When I run my code running on PostGIS version 2.5, I don't get an
>>> error but
>>> > when I run it on 3.1 it the server gives an error and enters the
>>> recovery
>>> > mode every time.
>>>
>>> > Operating System: CentOS Linux 8
>>> > CPE OS Name: cpe:/o:centos:centos:8
>>> > Kernel: Linux 4.18.0-193.28.1.el8_2.x86_64
>>> > Architecture: x86-64
>>> >
>>> > postgresql-13
>>> > extension : postgis vers. 3.1.0
>>>
>>> This should be fixed by upgrading GEOS.
>>> What version of GEOS are you using ?
>>> It should be reported by:
>>>
>>>   SELECT postgis_full_version();
>>>
>>> --strk;
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at lists.osgeo.org
>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210126/852a8a67/attachment.html>