[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Postgis 3.1.0 st_makevalid crashes the PostgreSQL Server
From: Paul Ramsey <pramsey () cleverelephant ! ca>
Date: 2021-01-27 20:23:15
Message-ID: CACowWR0oatBsJCcp_zEsAkfrP=AQB75x41JgVxHyXE=eK5G+Xw () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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.
On Tue, Jan 26, 2021 at 3:37 AM Nicolas Ribot <nicolas.ribot@gmail.com>
wrote:
> 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
>
> Nicolas
>
> On Tue, 26 Jan 2021 at 12:01, Nicolas Ribot <nicolas.ribot@gmail.com>
> wrote:
>
>> Hi,
>>
>> I could also reproduce it on MacOS
>> (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)
>>
>> The buffer operation returns an empty polygon.
>> Running these queries crashes the backend (server process (PID 93524) was
>> terminated by signal 6: Abort trap: 6):
>>
>> select st_makeValid(st_multi('POLYGON EMPTY'::geometry));
>> select st_makeValid('GEOMETRYCOLLECTION EMPTY'::geometry);
>> select st_makeValid('MULTIPOLYGON EMPTY'::geometry);
>>
>> Nicolas
>>
>> On Mon, 25 Jan 2021 at 11:52, Fatih Sazan <fatihsazan01@gmail.com> wrote:
>>
>>> my postgis verison details:
>>> SELECT postgis_full_version();
>>>
>>> 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)
>>>
>>> Bjornar Skinnes <bjornar_skinnes@trimble.com>, 25 Oca 2021 Pzt, 11:40
>>> tarihinde şunu yazdı:
>>>
>>>> postgis/postgis:latest image today. So I also could reproduce this
>>>> error. fyi.
>>>> 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
>>>>
>>>> man. 25. jan. 2021 kl. 09:35 skrev Sandro Santilli <strk@kbt.io>:
>>>>
>>>>> On Mon, Jan 25, 2021 at 10:19:42AM +0300, Fatih Sazan wrote:
>>>>> > When I run my code running on PostGIS version 2.5, I don't get an
>>>>> error but
>>>>> > when I run it on 3.1 it the server gives an error and enters the
>>>>> recovery
>>>>> > mode every time.
>>>>>
>>>>> > Operating System: CentOS Linux 8
>>>>> > CPE OS Name: cpe:/o:centos:centos:8
>>>>> > Kernel: Linux 4.18.0-193.28.1.el8_2.x86_64
>>>>> > Architecture: x86-64
>>>>> >
>>>>> > postgresql-13
>>>>> > extension : postgis vers. 3.1.0
>>>>>
>>>>> This should be fixed by upgrading GEOS.
>>>>> What version of GEOS are you using ?
>>>>> It should be reported by:
>>>>>
>>>>> SELECT postgis_full_version();
>>>>>
>>>>> --strk;
>>>>> _______________________________________________
>>>>> postgis-users mailing list
>>>>> postgis-users@lists.osgeo.org
>>>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>>>>
>>>> _______________________________________________
>>>> postgis-users mailing list
>>>> postgis-users@lists.osgeo.org
>>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users@lists.osgeo.org
>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>>
>> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
[Attachment #5 (text/html)]
<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">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>
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic