[MapProxy] MBTiles cleanup error

[Denis Rykov]

I've found ugly workaround:

for ((i = 0 ; i < 20 ; i++ )); do mapproxy-seed -f mapproxy.yaml -s
seed.yaml -c 1 --cleanup cleanup1; done


On Fri, Jul 17, 2015 at 10:28 AM, Denis Rykov <rykovd at gmail.com> wrote:

> Trying to perform cleanup task for MBTiles cache and get:
>
> Traceback (most recent call last):
>>   File "/home/dr/mapproxy/bin/mapproxy-seed", line 9, in <module>
>>     load_entry_point('MapProxy==1.8.0', 'console_scripts',
>> 'mapproxy-seed')()
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/script.py",
>> line 248, in main
>>     return SeedScript()()
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/script.py",
>> line 184, in __call__
>>     skip_geoms_for_last_levels=options.geom_levels)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/cleanup.py",
>> line 41, in cleanup
>>     progress_logger=progress_logger)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/cleanup.py",
>> line 93, in tilewalker_cleanup
>>     tile_walker.walk()
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/seeder.py",
>> line 289, in walk
>>     self._walk(bbox, self.task.levels)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/seeder.py",
>> line 339, in _walk
>>     all_subtiles=all_subtiles)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/seeder.py",
>> line 339, in _walk
>>     all_subtiles=all_subtiles)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/seeder.py",
>> line 339, in _walk
>>     all_subtiles=all_subtiles)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/seeder.py",
>> line 339, in _walk
>>     all_subtiles=all_subtiles)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/seeder.py",
>> line 339, in _walk
>>     all_subtiles=all_subtiles)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/seeder.py",
>> line 339, in _walk
>>     all_subtiles=all_subtiles)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/seeder.py",
>> line 339, in _walk
>>     all_subtiles=all_subtiles)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/seeder.py",
>> line 339, in _walk
>>     all_subtiles=all_subtiles)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/seeder.py",
>> line 339, in _walk
>>     all_subtiles=all_subtiles)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/seeder.py",
>> line 339, in _walk
>>     all_subtiles=all_subtiles)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/seeder.py",
>> line 339, in _walk
>>     all_subtiles=all_subtiles)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/seeder.py",
>> line 339, in _walk
>>     all_subtiles=all_subtiles)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/seeder.py",
>> line 339, in _walk
>>     all_subtiles=all_subtiles)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/seeder.py",
>> line 339, in _walk
>>     all_subtiles=all_subtiles)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/seeder.py",
>> line 339, in _walk
>>     all_subtiles=all_subtiles)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/seeder.py",
>> line 339, in _walk
>>     all_subtiles=all_subtiles)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/seed/seeder.py",
>> line 357, in _walk
>>     self.tile_mgr.is_stale(t)]
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/cache/tile.py",
>> line 169, in is_stale
>>     if self.cache.is_cached(tile):
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/cache/mbtiles.py",
>> line 293, in is_cached
>>     return self._get_level(tile.coord[2]).is_cached(tile)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/cache/mbtiles.py",
>> line 132, in is_cached
>>     return self.load_tile(tile)
>>   File
>> "/home/dr/mapproxy/local/lib/python2.7/site-packages/mapproxy/cache/mbtiles.py",
>> line 167, in load_tile
>>     zoom_level = ?''', tile.coord)
>> sqlite3.OperationalError: database is locked
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapproxy/attachments/20150717/aa78f46e/attachment.html>