[postgis-users] Bugreport

[Paul van der Linden]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220202/0eb0bffd/attachment.html>