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
