[OSM-talk] Mapnik+OSM and TileCache

[Christopher Schmidt]

On Mon, Nov 27, 2006 at 12:44:34AM +0100, Thomas Walraet wrote:
> Christopher Schmidt a ?crit :
> > 
> > http://labs.metacarta.com/wms-c/demo.html?lat=51.51777&lon=-0.10979&zoom=9&layers=00B00000F
> > 
> > Just-in-time (cache as you drag) OSM, based on the 11-20-06 planet.
> 
> 
> Very nice !
> 
> 
> A little bug report : Some tiles are rendered blank from time to times.
> http://labs.metacarta.com/wms-c/demo.html?lat=48.9869&lon=2.70305&zoom=15&layers=00B00000F

Yes. This is the result of mapnik not closing postgresql connections.
After a while, these build up, and eventually, postgresql will start
refusing additional clients. I've upped the limits as far as I can, and
tweaked the apache config to not have this happen as much as possible,
but it will still happen occasionally. Unfortunately, I don't know where
this bug is exactly, and I don't have the C++ knkowledge to fix it in
mapnik. Until it is fixed, this will occasionally happen.

I'll be working on a way to clear out the cache for a given area soon.
(Soon is on the days/week, not hour, scale.)

Regards,
-- 
Christopher Schmidt
MetaCarta