<div dir="ltr">+1<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jan 27, 2021 at 12:45 PM Paul Ramsey <<a href="mailto:pramsey@cleverelephant.ca">pramsey@cleverelephant.ca</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Given that we're carrying a crasher in 3.1.0, I'd like to propose release of 3.1.1 right away.</div><div><br></div><div>+1<br></div><div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">---------- Forwarded message ---------<br>From: <b class="gmail_sendername" dir="auto">Paul Ramsey</b> <span dir="auto"><<a href="mailto:pramsey@cleverelephant.ca" target="_blank">pramsey@cleverelephant.ca</a>></span><br>Date: Wed, Jan 27, 2021 at 12:23 PM<br>Subject: Re: [postgis-users] Postgis 3.1.0 st_makevalid crashes the PostgreSQL Server<br>To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>><br></div><br><br><div dir="ltr">My installation of master on both PostGIS and GEOS does not crash, but rolling back to PostGIS 3.1.0 and GEOS master crashes. I think we should push out a minor PostGIS release ASAP. <br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jan 26, 2021 at 3:37 AM Nicolas Ribot <<a href="mailto:nicolas.ribot@gmail.com" target="_blank">nicolas.ribot@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>With geos-master (3.10.0dev-CAPI-1.15.0), the buffer query from json polygon works and returns a valid polygon, but makevalid on empty geoms still crashes PG</div><div><br></div><div>Nicolas<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, 26 Jan 2021 at 12:01, Nicolas Ribot <<a href="mailto:nicolas.ribot@gmail.com" target="_blank">nicolas.ribot@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Hi,</div><div><br></div><div>I could also reproduce it on MacOS <br></div><div>(<span style="font-family:monospace">POSTGIS="3.1.0 5e2af69" [EXTENSION] PGSQL="130" GEOS="3.9.0-CAPI-1.16.2" SFCGAL="1.3.9" PROJ="7.2.0" GDAL="GDAL 3.2.0, released 2020/10/26" LIBXML="2.9.4" LIBJSON="0.15" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)" TOPOLOGY RASTER</span>) <br></div><div><br></div><div>The buffer operation returns an empty polygon.</div><div></div><div>Running these queries crashes the backend (server process (PID 93524) was terminated by signal 6: Abort trap: 6):</div><div><br></div><div><span style="font-family:monospace">select st_makeValid(st_multi('POLYGON EMPTY'::geometry));<br>select st_makeValid('GEOMETRYCOLLECTION EMPTY'::geometry);<br>select st_makeValid('MULTIPOLYGON EMPTY'::geometry);</span></div><div><br></div><div>Nicolas<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, 25 Jan 2021 at 11:52, Fatih Sazan <<a href="mailto:fatihsazan01@gmail.com" target="_blank">fatihsazan01@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>my postgis verison details:</div><div>SELECT postgis_full_version(); </div><div> <br></div>POSTGIS="3.1.0 5e2af69" [EXTENSION] PGSQL="130" GEOS="3.9.0-CAPI-1.16.2" PROJ="7.2.1" LIBXML="2.9.7" LIBJSON="0.13.1" LIBPROTOBUF="1.3.0" WAGYU="0.5.0 (Internal)" (core procs from "3.1.0alpha2 b6f415d" need upgrade) TOPOLOGY (topology procs from "3.1.0alpha2 b6f415d" need upgrade)<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Bjornar Skinnes <<a href="mailto:bjornar_skinnes@trimble.com" target="_blank">bjornar_skinnes@trimble.com</a>>, 25 Oca 2021 Pzt, 11:40 tarihinde şunu yazdı:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">postgis/postgis:latest image today. So I also could reproduce this error. fyi.<div><div>POSTGIS="3.1.0 5e2af69" [EXTENSION] PGSQL="130" GEOS="3.7.1-CAPI-1.11.1 27a5e771" PROJ="Rel. 5.2.0, September 15th, 2018" LIBXML="2.9.4" LIBJSON="0.12.1" LIBPROTOBUF="1.3.1" WAGYU="0.5.0 (Internal)" TOPOLOGY<br></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">man. 25. jan. 2021 kl. 09:35 skrev Sandro Santilli <<a href="mailto:strk@kbt.io" target="_blank">strk@kbt.io</a>>:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Mon, Jan 25, 2021 at 10:19:42AM +0300, Fatih Sazan wrote:<br>
> When I run my code running on PostGIS version 2.5, I don't get an error but<br>
> when I run it on 3.1 it the server gives an error and enters the recovery<br>
> mode every time.<br>
<br>
> Operating System: CentOS Linux 8<br>
> CPE OS Name: cpe:/o:centos:centos:8<br>
> Kernel: Linux 4.18.0-193.28.1.el8_2.x86_64<br>
> Architecture: x86-64<br>
> <br>
> postgresql-13<br>
> extension : postgis vers. 3.1.0<br>
<br>
This should be fixed by upgrading GEOS.<br>
What version of GEOS are you using ?<br>
It should be reported by:<br>
<br>
SELECT postgis_full_version();<br>
<br>
--strk;<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</blockquote></div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</blockquote></div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</blockquote></div>
</blockquote></div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</blockquote></div>
</div></div></div>
_______________________________________________<br>
postgis-devel mailing list<br>
<a href="mailto:postgis-devel@lists.osgeo.org" target="_blank">postgis-devel@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-devel" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-devel</a><br>
</blockquote></div>