[MapProxy] sqlite cache - OperationError no such table: tiles
Travis Kirstine
traviskirstine at gmail.com
Tue Dec 23 07:36:44 PST 2014
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/482920dc/attachment.html>
More information about the MapProxy
mailing list