[postgis-devel] Postgres dies on ST_MakeValid

Fri Mar 30 12:18:29 PDT 2018

Hi,

This was caused by a GEOSNode usage in LWGEOM_GEOS_nodeLines by me.
Unfortunately GEOSNode is not robust enough for this.

Tom, please try updating PostGIS from latest svn, this issue should be
resolved.

Follow-up GEOS ticket:
https://trac.osgeo.org/geos/ticket/864#ticket

пт, 30 мар. 2018 г. в 21:11, Paul Ramsey <pramsey at cleverelephant.ca>:

> 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
> _______________________________________________
> 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/3fb8d126/attachment.html>