[OSM-dev] Mapnik/Python keeps crashing

[Jon Burgess]

On Tue, 2010-11-02 at 17:23 -0400, Matthew Wechsler wrote:
> I am having issues rendering tiles from Mapnik for an OSM world map
> tile server I am creating. I am using Mapnik 0.7.1 on Windows Server
> 2008 1TB Raid5.
> When I use generate_tiles.py everything starts out ok but then after a
> few minutes it keeps crashing.
> 
> Here is the command line output:
> 
> Exception in thread Thread-3:
> Traceback (most recent call last):
>   File "C:\Python25\lib\threading.py", line 486, in __bootstrap_inner
>     self.run()
>   File "C:\Python25\lib\threading.py", line 446, in run
>     self.__target(*self.__args, **self.__kwargs)
>   File "C:\mapnik-0.7.1\generate_tiles_planet.py", line 109, in loop
>     self.render_tile(tile_uri, x, y, z)
>   File "C:\mapnik-0.7.1\generate_tiles_planet.py", line 91, in render_tile
>     mapnik.render(self.m, im)
> RuntimeError: PSQL error
> Full sql was: 'SELECT AsBinary("way") AS geom from
>       (select way from planet_osm_line where route='ferry' ) as routes
>        WHERE "way" && SetSRID('BOX3D(1721973.37320845
> -8609866.866042253,2348145.508920615 -7983694.730330086)'::box3d,
> 900913)'

> Any ideas?

I think multi-threading problems on Windows have been reported before
but no one has been in a position to debug the exact cause. 

I recently received a modified version of the generate_tiles.py script
contributed by Bertrand Gervais which uses the python multiprocess
module which should avoid any threading issues. I have just added this
into SVN:

http://trac.openstreetmap.org/browser/applications/rendering/mapnik/generate_tiles_multiprocess.py

Could you give this a try?

    Jon