[Maposmatic-dev] Rendering failure for job 5109

[Thomas Petazzoni]

Hello,

Job 5109 on the production server was a rendering request for Chambéry,
Savoie. The rendering failed, as shown in
<http://www.maposmatic.org/jobs/5109>.

In the maposmaticd logs, I've found the following failure (not analyzed
yet) :

[job 5109] starting rendering, title 'Chamb<C3><A9>ry, Savoie, 
Rh<C3><B4>ne-Alpes, France'
Failure in rendering child process:
Traceback (most recent call last):
  File 
"/home/maposmatic/apache/maposmatic-prod/maposmatic/scripts/maposmaticd", line 
78, in render_job
    retval = render_job_process(job)
  File 
"/home/maposmatic/apache/maposmatic-prod/maposmatic/scripts/maposmaticd", line 
48, in render_job_process
    language=job.map_language)
  File 
"/home/maposmatic/apache/maposmatic-prod/ocitysmap/ocitysmap/street_index.py", 
line 308, in __init__
    self.amenities = self.get_amenities_by_osmid(db, self.osmid)
  File 
"/home/maposmatic/apache/maposmatic-prod/ocitysmap/ocitysmap/street_index.py", 
line 846, in get_amenities_by_osmid
    osm_id=osmid))
  File "/usr/lib/python2.6/dist-packages/pgdb.py", line 259, in execute
    self.executemany(operation, (params,))
  File "/usr/lib/python2.6/dist-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 '<C3><89>ducation', name, textcat_all(x || ',' || y || ';')
                              from (select distinct amenity, name, x, y, 
planet_osm_point.osm_id
                                    from planet_osm_point join prod_map_areas
                                    on st_intersects(way, st_transform(geom, 
900913))
                                    left join cities_area_by_osmid on 
cities_area_by_osmid.osm_id=-74386
                                    where amenity = 'school' 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 prod_map_areas
                                    on st_intersects(way, st_transform(geom, 
900913))
                                    left join cities_area_by_osmid on 
cities_area_by_osmid.osm_id=-74386
                                    where amenity = 'school' 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
                              '

[job 5109] rendering failed with 1

If someone understands the issue, don't hesitate to let me know,

Thomas
-- 
Thomas Petazzoni                         http://thomas.enix.org
Promouvoir et défendre le Logiciel Libre http://www.april.org
Logiciels Libres à Toulouse              http://www.toulibre.org

signature.asc
Description: PGP signature