[postgis-devel] Postgres dies on ST_MakeValid

Fri Mar 30 09:59:43 PDT 2018

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20180330/3312b22b/attachment.html>