PROBABLE BUG

From: matty <torellim3(at)gmail(dot)com>
To: security(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: PROBABLE BUG
Date: 2013-07-29 09:11:55
Message-ID: CADKgNvD_ike9d1SEfkrb4NEwyKPYpVQFBwfdDQ773Dvgi1Dvdw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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('0103000000010000000D0000002659559057004241C8275DD4EC815241F8F059C15F004241FC4DCD26F1815241544B80CB6500424163EB5BACEF81524156457A656B004241B9FF0442EE815241621A61EF78004241D628B9D1EA815241AD8C00AF7600424178214275E98152410BC0168971004241CBE9BE7EE6815241598F35D5700042413466F817E6815241FE0CCFA85A0042416D921D01EC8152410C2979605B0042419E0F28D0EB8152416842EEC558004241850BB777ED8152412959559057004241C7275DD4EC8152412659559057004241C8275DD4EC815241'))))::numeric,
0) as area,
trunc(st_perimeter(ST_MakeValid(st_GeometryFromText(st_astext('0103000000010000000D0000002659559057004241C8275DD4EC815241F8F059C15F004241FC4DCD26F1815241544B80CB6500424163EB5BACEF81524156457A656B004241B9FF0442EE815241621A61EF78004241D628B9D1EA815241AD8C00AF7600424178214275E98152410BC0168971004241CBE9BE7EE6815241598F35D5700042413466F817E6815241FE0CCFA85A0042416D921D01EC8152410C2979605B0042419E0F28D0EB8152416842EEC558004241850BB777ED8152412959559057004241C7275DD4EC8152412659559057004241C8275DD4EC815241'))))::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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ondrej Chaloupka 2013-07-29 13:33:44 Incorrect response code after XA recovery
Previous Message Michael Paquier 2013-07-29 07:46:44 Re: BUG #8336: pgAgent is not working