[postgis-users] Bugreport

[Paul Ramsey]

For what it's worth there's no segfault on a modern GEOS (3.9+).  

> On Feb 2, 2022, at 2:47 AM, Paul van der Linden <paul.doskabouter at gmail.com> wrote:
> 
> Tried to find a place where I could post a bug-report, but got a bit lost in old pages, creating accounts etc, so I'll post it here.
> 
> Versions used:
> POSTGIS="3.1.4 ded6c34" [EXTENSION] PGSQL="140" GEOS="3.8.0-CAPI-1.13.1 " PROJ="6.3.1" LIBXML="2.9.10" LIBJSON="0.13.1" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)"
> on 
> PostgreSQL 14.0 (Ubuntu 14.0-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, 64-bit
> running on a 16-core, 64GB ubuntu machine.
> 
> executing 
> SELECT st_symdifference( 
> 'GEOMETRYCOLLECTION(MULTIPOLYGON(((-160.39682019999998 -78.0554637,-160.3577281 -78.0479844,-160.3200025 -78.0409262,-160.3120508200423 -78.03947725173413,-160.3120508200423 -78.06208209231708,-160.43057628551648 -78.06208209231708,-160.39682019999998 -78.0554637))))'::geometry, 
> 'GEOMETRYCOLLECTION(MULTIPOLYGON(((-160.5322256 -78.0589866,-160.51549109999996 -78.0555734,-160.495622 -78.0516242,-160.4757661 -78.0476737,-160.4543442 -78.0435137,-160.4329373 -78.0393522,-160.41161840000004 -78.0352959,-160.3903141 -78.0312379,-160.3706962 -78.0276019,-160.3510903 -78.0239645,-160.3184447 -78.018167,-160.3120508200423 -78.01720778534151,-160.3120508200423 -78.06208209231708,-160.5474153765027 -78.06208209231708,-160.5322256 -78.0589866))))'::geometry 
> ) 
> 
> gives me a segfault in postgres:
> segfault at 0 ip 00007fa2d420e38b sp 00007fffb95d7f00 error 4 in libgeos-3.8.0.so[7fa2d41d9000+ef000]
> running the query with multipolygons instead of geometrycollection is going ok, running the query with different multipolygons inside geometrycollection also runs ok.
> 
> Would like to test on newer postgis versions but I don't have the courage to update it right now.
> apt list postgis -a gives me:
> 
> postgis/focal-pgdg 3.2.0+dfsg-1.pgdg20.04+1 amd64 [upgradable from: 3.1.4+dfsg-3.pgdg20.04+1]
> postgis/now 3.1.4+dfsg-3.pgdg20.04+1 amd64 [installed,upgradable to: 3.2.0+dfsg-1.pgdg20.04+1]
> postgis/focal 3.0.0+dfsg-6ubuntu4 amd64
> 
> And I'm not sure if it is safe to do the upgrade through apt (wouldn't it uninstall 3.1.4 and break my database in the process?)
> 
> Paul
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users