[postgis-devel] Postgres dies on ST_MakeValid

[Paul Ramsey]

Backend crash rather than an exception for me, on OSX. Thrills.
P.

On Fri, Mar 30, 2018 at 9:59 AM, Darafei "Komяpa" Praliaskouski
<me at komzpa.net> wrote:
> Reproduces locally.
>
> [local] gis at gis=# select postgis_full_version();
> POSTGIS="2.5.0dev r16485" [EXTENSION] PGSQL="100" GEOS="3.7.0dev-CAPI-1.11.0
> 0" SFCGAL="1.3.1" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.2.1,
> released 2017/06/23" LIBXML="2.9.4" LIBJSON="0.12.1" LIBPROTOBUF="1.2.1"
> RASTER
>
> Created https://trac.osgeo.org/postgis/ticket/4061#ticket, will look into
> it.
>
>
> пт, 30 мар. 2018 г. в 19:10, Brian M Hamlin <maplabs at light42.com>:
>>
>> this works for me:
>>
>> dbb=# select st_MakeValid(ST_GeomFromWKB('010200000011000000b20X9
>>
>> }366 at 7211A340235I34A316326t18}366 at 306g347323230I34Ay351&18}366 at 331316367323230I34A372~j274370}366 at 315314314LpI34A343245233304R}366 at R2703605?I34A315314314314Z~366 at 34324523330407I34A04V16-242}366 at 252361322M323H34A351&110306{366 at H341z247I34Ab20X9
>> }366 at 7211A340235I34A'));
>>
>>
>>           st_makevalid
>>
>>
>>
>> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>>
>> 01020000000900000062105839207DF640378941E09D491C41CED67431387DF640C667E7D398491C4179E92631387DF640D9CEF7D398491C41FA7E6ABCF87DF640CDCCCC4C70491C41E3A59BC4527DF64052B81E053F491C41CDCCCCCC5A7EF640E3A59BC407491C4104560E2DA27DF640AAF1D24DD3481C41E9263108C67BF64048E17A1437491C4162105839207DF640378941E09D491C41
>>
>>
>>  POSTGIS="2.4.3" PGSQL="100" GEOS="3.6.2-CAPI-1.10.2 4d2925d6"
>> SFCGAL="1.3.0" PROJ="Rel. 4.9.3, 15 August 2016" LIBXML="2.9.3"
>> LIBJSON="0.11.99" LIBPROTOBUF="1.2.1" (core procs from "2.4.3" need
>> upgrade) (sfcgal procs from "2.4.3" need upgrade)
>>
>>
>> --------------------------------------------------------------------------------------------------
>> On Fri, 30 Mar 2018 16:39:18 0200, Tom van Tilburg
>> <tom.van.tilburg at gmail.com> wrote:
>>
>> Postgres says:
>> "...pure virtual method called
>> terminate called without an active exception ..."
>> before dying
>>
>> Fresh postgis build:
>> "POSTGIS="2.5.0dev r16508" [EXTENSION] PGSQL="100"
>> GEOS="3.6.2-CAPI-1.10.2 4d2925d6" SFCGAL="1.3.1" PROJ="Rel. 4.9.3, 15
>> August 2016" GDAL="GDAL 2.2.3, released 2017/11/20" LIBXML="2.9.4"
>> LIBJSON="0.12.1" LIBPROTOBUF="1.2.1" RASTER (sfcgal procs from "2.5.0
>> (...)"
>>
>> I can only reproduce when outputting the binary geometry, WKT doesn't
>> give this problem:
>>
>> SELECT
>> ST_MakeValid(ST_MakePolygon(ST_GeomFromWKB('010200000011000000b20X9
>>
>> }366 at 7211A340235I34A316326t18}366 at 306g347323230I34Ay351&18}366 at 331316367323230I34A372~j274370}366 at 315314314LpI34A343245233304R}366 at R2703605?I34A315314314314Z~366 at 34324523330407I34A04V16-242}366 at 252361322M323H34A351&110306{366 at H341z247I34Ab20X9
>> }366 at 7211A340235I34A')))
>>
>> Output of ST_Isvalidreason gives "Self-intersection[92115.5120743143
>> 463462.206937431]"
>>
>> Best,
>>  Tom
>>
>> -------------------------
>>
>> _______________________________________________
>> postgis-devel mailing list
>> postgis-devel at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-devel
>>
>> --
>> Brian M Hamlin
>> OSGeo California
>> blog.light42.com
>>
>>
>>
>> _______________________________________________
>> postgis-devel mailing list
>> postgis-devel at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-devel
>
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel