[MapProxy] sqlite cache - OperationError no such table: tiles

[Travis Kirstine]

BTW this problem seems to be restricted to sqlite caches.  Mbtiles seems to
work fine.

On 23 December 2014 at 10:36, Travis Kirstine <traviskirstine at gmail.com>
wrote:

> We are testing various types or caches and have noticed issues with sqlite
> caches when dynamically generating tile on the fly (light load - 1 user).
> The client will often get a 502 or 500 error.
>
> We have tried upgrading to v1.7.1 from 1.6 but the problem persists. Any
> Ideas what could be causing the error or suggestions
>
> Our mapproxy instance is set up using gunicorn with eventlet using a
> apache proxy
>
> # gunicorn upstart script
> exec /usr/bin/gunicorn --timeout 120 --log-level debug --access-logfile
> /etc/httpd/logs/gunicorn_access.log  --error-logfile
> /etc/httpd/logs/gunicorn_error.log -k eventlet -w 18 -b localhost:8181
> config:application
>
>
> yaml cache / source
>
> caches:
>   PIN_cache:
>     grids: [spherical_mercator]
>     sources: [PIN_mapserv]
>     meta_buffer: 150
>     meta_size: [4,4]
>     format: png8
>     link_single_color_images: true
>     minimize_meta_requests: true
>     cache:
>       type: sqlite
>       directory: /opt/mapproxy/test/sqllite/PIN
>
> sources:
>   PIN_mapserv:
>     type: mapserver
>     concurrent_requests: 20
>     req:
>       map: /opt/mapserver/mapfile/vumap.map
>       layers: PIN
>       transparent: true
>     mapserver:
>       binary: /var/www/cgi-bin/mapserv
>       working_dir: /opt/mapserver/mapfile
>     supported_srs: [
>       'EPSG:3857', 'EPSG:900913',
>       'EPSG:4326', 'EPSG:4269',
>       'EPSG:26915', 'EPSG:26916', 'EPSG:26917', 'EPSG:26918',
>       'EPSG:32186', 'EPSG:32187', 'EPSG:32188', 'EPSG:32189',
>       'EPSG:32190', 'EPSG:32191', 'EPSG:32192', 'EPSG:32193',
>       'EPSG:32194', 'EPSG:32195', 'EPSG:32196',
>       'EPSG:3161'
>     ]
>     coverage:
>       bbox: [-10592453.1057418, 5113361.84195586, -8275939.84644254,
> 7568890.88630739]
>       srs: 'EPSG:3857'
>
>
> ################
>
> The traceback:
>
> Traceback (most recent call last):
>   File "/usr/lib/python2.6/site-packages/mapproxy/wsgiapp.py", line 181,
> in __call__
>     resp = self.handlers[handler_name].handle(req)
>   File "/usr/lib/python2.6/site-packages/mapproxy/service/base.py", line
> 30, in handle
>     return handler(parsed_req)
>   File "/usr/lib/python2.6/site-packages/mapproxy/service/tile.py", line
> 81, in map
>     tile = layer.render(tile_request,
> use_profiles=tile_request.use_profiles, coverage=limit_to,
> decorate_img=decorate_img)
>   File "/usr/lib/python2.6/site-packages/mapproxy/service/tile.py", line
> 307, in render
>     dimensions=dimensions, with_metadata=True)
>   File "/usr/lib64/python2.6/contextlib.py", line 34, in __exit__
>     self.gen.throw(type, value, traceback)
>   File "/usr/lib/python2.6/site-packages/mapproxy/cache/tile.py", line 92,
> in session
>     yield
>   File "/usr/lib/python2.6/site-packages/mapproxy/service/tile.py", line
> 307, in render
>     dimensions=dimensions, with_metadata=True)
>   File "/usr/lib/python2.6/site-packages/mapproxy/cache/tile.py", line
> 101, in load_tile_coord
>     self.cache.load_tile(tile, with_metadata)
>   File "/usr/lib/python2.6/site-packages/mapproxy/cache/mbtiles.py", line
> 313, in load_tile
>     return self._get_level(tile.coord[2]).load_tile(tile,
> with_metadata=with_metadata)
>   File "/usr/lib/python2.6/site-packages/mapproxy/cache/mbtiles.py", line
> 170, in load_tile
>     zoom_level = ?''', tile.coord)
> OperationalError: no such table: tiles
>
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapproxy/attachments/20141223/27ca2e92/attachment.html>