Ticket #1028 (closed defect: fixed)

Opened 2 years ago

Last modified 18 months ago

ST_AsSVG kills whole postgres server when fails

Reported by: cumobiworx Owned by: colivier
Priority: medium Milestone: PostGIS 1.4.3
Component: postgis Version: 1.5.X
Keywords: Cc:

Description

To verify, try the following statement:

select ST_AsSVG(geomfromtext('GEOMETRYCOLLECTION(POLYGON((10.099877929668 48.862883054592,10.181369018541 48.856106812965,10.268353271476 48.852944252927,10.332458496101 48.864689897427,10.382411956792 48.892266788693,10.407646179203 48.911254853059,10.420349121097 48.93748354518,10.429618835452 48.96366788587,10.435455322268 48.985783173727,10.418289184574 49.004766242422,10.387390136724 49.027527294485,10.353744506842 49.053222191579,10.20981245042 49.07656037895,10.107079124464 49.085499093636,9.9949962616126 49.072793268945,9.9163993835595 49.038370025831,9.9240005493217 48.991083619683,9.9584289550641 48.925258336798,10.025720214827 48.892274642324,10.099877929668 48.862883054592)))', 4326))

it will fail though it shouldn't (the Geometry is valid), and it will kill postgres. This happens on Postgres 8.4 w/ postgis 1.4 and also on Postgres 9.0 and Postgis 1.5

Change History

Changed 2 years ago by colivier

  • owner changed from pramsey to colivier

Could reproduce it on 2.0 branch

Changed 2 years ago by pramsey

Could reproduce or couldn't? My test on 2.0 on OSX worked fine. On 1.5, I got a backend crash.

Changed 2 years ago by pramsey

See also #1038?

Changed 18 months ago by pramsey

  • status changed from new to closed
  • resolution set to fixed

Fixed in 1.5 at r8245 and trunk at r8246

Note: See TracTickets for help on using tickets.