[postgis-tickets] [PostGIS] #1580: proj4 cache corrupted by projection error ?

[PostGIS]

#1580: proj4 cache corrupted by projection error ?
-----------------------+----------------------------------------------------
  Reporter:  strk      |       Owner:  pramsey      
      Type:  defect    |      Status:  closed       
  Priority:  critical  |   Milestone:  PostGIS 2.0.0
 Component:  postgis   |     Version:  trunk        
Resolution:  fixed     |    Keywords:               
-----------------------+----------------------------------------------------
Changes (by caleb):

 * cc: caleb (added)


Comment:

 I believe I'm having this same issue. First I get an error like:


 {{{
 SELECT SUM(count*ST_X(cluster_point))/SUM(count) as center_x,
  SUM(count*ST_Y(cluster_point))/SUM(count) as center_y,
  SUM(count) as count FROM "clusters" WHERE (zoom = 9 AND
 ST_INTERSECTS(polygon,ST_TRANSFORM(ST_SETSRID(ST_MakeBox2D(ST_POINT(26.816068571769904,89.99999737698666),
  ST_POINT(29.507718962394904,89.9999974989205)),4326),900913))) GROUP BY
 grid_point
 PG::Error: ERROR:  transform: couldn't project point (26.8161 90 0):
 tolerance condition error (-20)
 }}}


 Then, all following transformations throw an error like:


 {{{
 PG::Error: ERROR: AddToPROJ4SRSCache: couldn't parse proj4 string:
 '+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0
 +units=m +k=1.0 +nadgrids=@null +no_defs': tolerance condition error
 }}}


 Only solution seems to be to restart the PostgreSQL server.

 This is occurring with PostGIS 1.5. Assuming this is the same, and the
 above fix is the resolution: which stable version did this fix made it
 into?

 Thanks!

 --
 Caleb

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1580#comment:3>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.