bugMapOSMatic - Bugs: bug #28522, Impossible to render...

 
 

bug #28522: Impossible to render "Saint-Martin-d'Hères, Isère, Rhône-Alpes, France" or Chambéry and several other cities

Submitter:  David Mentré <dmentre>
Submitted:  Fri 08 Jan 2010 10:58:00 AM UTC
   
 
Category:  ocitysmap Severity:  3 - Normal
Priority:  * 5 - Normal Status:  Works For Me
Privacy:  Public Assigned to:  mpetazzoni
Open/Closed:  Closed Release:  None
* Mandatory Fields

Add a New Comment Rich Markup
   

Fri 29 Oct 2010 08:15:22 PM UTC, comment #5: 

I can't reproduce this anymore on http://dev.maposmatic.org : http://dev.maposmatic.org/jobs/31

If the problem still exists for other cities, please re-open.

- Maxime

Maxime Petazzoni <mpetazzoni>
Group administrator
Tue 11 May 2010 03:01:10 PM UTC, comment #4: 

So, do we agree that this not a MapOSMatic issue, but a data issue only? If so, can we close this bug?

Maxime Petazzoni <mpetazzoni>
Group administrator
Wed 27 Jan 2010 02:14:44 PM UTC, comment #3: 

Constraints that geometries should fulfil in the database:
  http://www.postgis.org/documentation/manual-1.4/ch04.html#OGC_Validity

David Mentré <dmentre>
Group administrator
Fri 08 Jan 2010 11:31:45 AM UTC, comment #2: 
Thomas Petazzoni <tpetazzoni>
Group administrator
Fri 08 Jan 2010 11:01:43 AM UTC, comment #1: 

Checked locally, here's the error:

<pre>
INFO:maposmatic:[job 22] starting rendering, title 'Saint-Martin-d'Hères, Isère, Rhône-Alpes, France'
NOTICE:  TopologyException: side location conflict 640596 5.65051e+06
ERROR:maposmatic:Failure in rendering child process:
Traceback (most recent call last):
  File "/home/sam/src/python/maposmatic/maposmatic/www/../scripts/maposmaticd", line 78, in render_job
    retval = render_job_process(job)
  File "/home/sam/src/python/maposmatic/maposmatic/www/../scripts/maposmaticd", line 48, in render_job_process
    language=job.map_language)
  File "/home/sam/src/python/maposmatic/ocitysmap/ocitysmap/street_index.py", line 322, in _init_
    self.amenities = self.get_amenities_by_osmid(db, self.osmid)
  File "/home/sam/src/python/maposmatic/ocitysmap/ocitysmap/street_index.py", line 860, in get_amenities_by_osmid
    osm_id=osmid))
  File "/usr/lib/python2.5/site-packages/pgdb.py", line 259, in execute
    self.executemany(operation, (params,))
  File "/usr/lib/python2.5/site-packages/pgdb.py", line 289, in executemany
    raise DatabaseError("error '%s' in '%s'" % (msg, sql))
DatabaseError: error 'ERROR:  GEOS intersects() threw an error!
' in 'select 'Public buildings', name, textcat_all(x || ',' || y || ';')
                              from (select distinct amenity, name, x, y, planet_osm_point.osm_id
                                    from planet_osm_point join map_areas
                                    on st_intersects(way, st_transform(geom, 900913))
                                    left join cities_area_by_osmid on cities_area_by_osmid.osm_id=-80349
                                    where amenity = 'townhall' and
                                    case when cities_area_by_osmid.area is null
                                    then
                                      true
                                    else
                                      st_intersects(way, cities_area_by_osmid.area)
                                    end
                                  union
                                    select distinct amenity, name, x, y, planet_osm_polygon.osm_id
                                    from planet_osm_polygon join map_areas
                                    on st_intersects(way, st_transform(geom, 900913))
                                    left join cities_area_by_osmid on cities_area_by_osmid.osm_id=-80349
                                    where amenity = 'townhall' and
                                    case when cities_area_by_osmid.area is null
                                    then
                                      true
                                    else
                                      st_intersects(way, cities_area_by_osmid.area)
                                    end)
                              as foo
                              group by amenity, osm_id, name
                              order by amenity, name
                              '

INFO:maposmatic:[job 22] rendering failed with 1
</pre>

Maxime Petazzoni <mpetazzoni>
Group administrator
Fri 08 Jan 2010 10:58:00 AM UTC, original submission:  

http://maposmatic.org/jobs/7028

The jobs fails after about 1min, so probably an issue when querying the database (to be confirmed).

David Mentré <dmentre>
Group administrator

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by tpetazzoni (Posted a comment)
  • -email is unavailable- added by mpetazzoni (Posted a comment)
  • -email is unavailable- added by dmentre (Submitted the item)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only logged-in users can vote.

     

    Follow 6 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2010-10-29 mpetazzoni Open/ClosedOpen Closed
    2010-10-29 mpetazzoni StatusIn Progress Works For Me
        Assigned todmentre mpetazzoni
    2010-02-03 dmentre StatusNeed Info In Progress
    2010-02-03 dmentre Assigned toNone dmentre
    2010-01-08 tpetazzoni SummaryImpossible to render &quot;Saint-Martin-d\'Hères, Isère, Rhône-Alpes, France&quot; Impossible to render "Saint-Martin-d'Hères, Isère, Rhône-Alpes, France" or Chambéry and several other cities

    Back to the top

    Powered by Savane 3.13-f8d8.
    Corresponding source code