Postgres Pro
Downloads
Home   >   mailing lists

Thread: PROBABLE BUG

PROBABLE BUG

From
matty
Date:
Hello,
I have noticed that when I execute this query, the DB (postgresql) is
crashed.

select
trunc(st_area(ST_MakeValid(st_GeometryFromText(st_astext('01030000000100000=
00D0000002659559057004241C8275DD4EC815241F8F059C15F004241FC4DCD26F181524154=
4B80CB6500424163EB5BACEF81524156457A656B004241B9FF0442EE815241621A61EF78004=
241D628B9D1EA815241AD8C00AF7600424178214275E98152410BC0168971004241CBE9BE7E=
E6815241598F35D5700042413466F817E6815241FE0CCFA85A0042416D921D01EC8152410C2=
979605B0042419E0F28D0EB8152416842EEC558004241850BB777ED81524129595590570042=
41C7275DD4EC8152412659559057004241C8275DD4EC815241'))))::numeric,
0) as area,
trunc(st_perimeter(ST_MakeValid(st_GeometryFromText(st_astext('010300000001=
0000000D0000002659559057004241C8275DD4EC815241F8F059C15F004241FC4DCD26F1815=
241544B80CB6500424163EB5BACEF81524156457A656B004241B9FF0442EE815241621A61EF=
78004241D628B9D1EA815241AD8C00AF7600424178214275E98152410BC0168971004241CBE=
9BE7EE6815241598F35D5700042413466F817E6815241FE0CCFA85A0042416D921D01EC8152=
410C2979605B0042419E0F28D0EB8152416842EEC558004241850BB777ED815241295955905=
7004241C7275DD4EC8152412659559057004241C8275DD4EC815241'))))::numeric,
0) as perimeter


I have installed the follows applications:

select version();
PostgreSQL 9.2.3, compiled by Visual C++ build 1600, 32-bit

select  postgis_lib_version();
2.0.1

select postgis_proj_version();
Rel. 4.8.0, 6 March 2012

select postgis_geos_version();
3.3.5-CAPI-1.7.5

I think that it is very dangerous because it's necessary just a select
query to deny the service.

Appearance news
thank you very much, Mattia Torelli

Re: PROBABLE BUG

From
Jaime Casanova
Date:
On Mon, Jul 29, 2013 at 4:11 AM, matty <torellim3@gmail.com> wrote:
> Hello,
> I have noticed that when I execute this query, the DB (postgresql) is
> crashed.
>

I executed this query without problem. This are the versions i have, i
will recommend you to upgrade those that differ from yours and retry
(specially geos, i remember we saw a problem with it recently).

anyway, this is obviously a bug that should be better reported in the
postgis mailing lists, not here. so, if after upgrading those
libraries you still have the problem report it to this list:
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users or
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel

select version();
                                                   version
---------------------------------------------------------------------------=
-----------------------------------
 PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC)
4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit
(1 row)

select  postgis_lib_version();
 postgis_lib_version
---------------------
 2.0.3
(1 row)

select postgis_proj_version();
   postgis_proj_version
--------------------------
 Rel. 4.8.0, 6 March 2012
(1 row)

select postgis_geos_version();
 postgis_geos_version
----------------------
 3.3.8-CAPI-1.7.8
(1 row)


--=20
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitaci=F3n
Phone: +593 4 5107566         Cell: +593 987171157