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
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 |