[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