[OSM-dev] Mapnik/Python keeps crashing

[Matthew Wechsler]

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)'


Exception in thread Thread-4:
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,"highway","railway" from
      (select way,highway,railway,
       case when tunnel in ('yes','true','1') then 'yes'::text else
tunnel end as tunnel
       from planet_osm_roads
       where highway is not null
          or railway is not null
       order by z_order
      ) as roads
       WHERE "way" && SetSRID('BOX3D(1721973.373208451
-8296780.798186168,2348145.508920614 -7670608.662474006)'::box3d,
900913)'



Here is the Python.exe crash message box:

Problem signature:
  Problem Event Name:	APPCRASH
  Application Name:	python.exe
  Application Version:	0.0.0.0
  Application Timestamp:	4950f175
  Fault Module Name:	postgis.input
  Fault Module Version:	0.0.0.0
  Fault Module Timestamp:	4ba7b361
  Exception Code:	c0000005
  Exception Offset:	0001a03e
  OS Version:	6.1.7600.2.0.0.274.10
  Locale ID:	1033
  Additional Information 1:	1ec0
  Additional Information 2:	1ec0fd70d07d060e5bfcf53c69ad1739
  Additional Information 3:	3040
  Additional Information 4:	30403390ed20f1b32c61f314c386b874

Read our privacy statement online:
  http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

If the online privacy statement is not available, please read our
privacy statement offline:
  C:\Windows\system32\en-US\erofflps.txt

Any ideas?