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

[Nicolas Ribot]

With geos-master (3.10.0dev-CAPI-1.15.0), the buffer query from json
polygon works and returns a valid polygon, but makevalid on empty geoms
still crashes PG

Nicolas

On Tue, 26 Jan 2021 at 12:01, Nicolas Ribot <nicolas.ribot at gmail.com> wrote:

> 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/491ebf69/attachment.html>