2010/1/3 Thomas Petazzoni
<address@hidden>
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