<div dir="ltr">BTW this problem seems to be restricted to sqlite caches. Mbtiles seems to work fine.</div><div class="gmail_extra"><br><div class="gmail_quote">On 23 December 2014 at 10:36, Travis Kirstine <span dir="ltr"><<a href="mailto:traviskirstine@gmail.com" target="_blank">traviskirstine@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>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.</div><div><br></div><div>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 </div><div><br></div><div>Our mapproxy instance is set up using gunicorn with eventlet using a apache proxy</div><div><br></div><div># gunicorn upstart script</div><div>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<br></div><div><br></div><div><br></div><div>yaml cache / source</div><div><br></div><div>caches:</div><div><div> PIN_cache:</div><div> grids: [spherical_mercator]</div><div> sources: [PIN_mapserv]</div><div> meta_buffer: 150</div><div> meta_size: [4,4]</div><div> format: png8</div><div> link_single_color_images: true</div><div> minimize_meta_requests: true</div><div> cache:</div><div> type: sqlite</div><div> directory: /opt/mapproxy/test/sqllite/PIN</div></div><div><br></div><div>sources:</div><div><div> PIN_mapserv:</div><div> type: mapserver</div><div> concurrent_requests: 20</div><div> req:<br></div><div> map: /opt/mapserver/mapfile/vumap.map</div><div> layers: PIN</div><div> transparent: true</div><div> mapserver:</div><div> binary: /var/www/cgi-bin/mapserv</div><div> working_dir: /opt/mapserver/mapfile</div><div> supported_srs: [</div><div> 'EPSG:3857', 'EPSG:900913',</div><div> 'EPSG:4326', 'EPSG:4269',</div><div> 'EPSG:26915', 'EPSG:26916', 'EPSG:26917', 'EPSG:26918',</div><div> 'EPSG:32186', 'EPSG:32187', 'EPSG:32188', 'EPSG:32189',</div><div> 'EPSG:32190', 'EPSG:32191', 'EPSG:32192', 'EPSG:32193',</div><div> 'EPSG:32194', 'EPSG:32195', 'EPSG:32196',</div><div> 'EPSG:3161'</div><div> ]</div><div> coverage:</div><div> bbox: [-10592453.1057418, 5113361.84195586, -8275939.84644254, 7568890.88630739]</div><div> srs: 'EPSG:3857'</div></div><div><br></div><div><br></div><div>################<br></div><div><br></div><div>The traceback:<br></div><div><br></div><div><div>Traceback (most recent call last):</div><div> File "/usr/lib/python2.6/site-packages/mapproxy/wsgiapp.py", line 181, in __call__</div><div> resp = self.handlers[handler_name].handle(req)</div><div> File "/usr/lib/python2.6/site-packages/mapproxy/service/base.py", line 30, in handle</div><div> return handler(parsed_req)</div><div> File "/usr/lib/python2.6/site-packages/mapproxy/service/tile.py", line 81, in map</div><div> tile = layer.render(tile_request, use_profiles=tile_request.use_profiles, coverage=limit_to, decorate_img=decorate_img)</div><div> File "/usr/lib/python2.6/site-packages/mapproxy/service/tile.py", line 307, in render</div><div> dimensions=dimensions, with_metadata=True)</div><div> File "/usr/lib64/python2.6/contextlib.py", line 34, in __exit__</div><div> self.gen.throw(type, value, traceback)</div><div> File "/usr/lib/python2.6/site-packages/mapproxy/cache/tile.py", line 92, in session</div><div> yield</div><div> File "/usr/lib/python2.6/site-packages/mapproxy/service/tile.py", line 307, in render</div><div> dimensions=dimensions, with_metadata=True)</div><div> File "/usr/lib/python2.6/site-packages/mapproxy/cache/tile.py", line 101, in load_tile_coord</div><div> self.cache.load_tile(tile, with_metadata)</div><div> File "/usr/lib/python2.6/site-packages/mapproxy/cache/mbtiles.py", line 313, in load_tile</div><div> return self._get_level(tile.coord[2]).load_tile(tile, with_metadata=with_metadata)</div><div> File "/usr/lib/python2.6/site-packages/mapproxy/cache/mbtiles.py", line 170, in load_tile</div><div> zoom_level = ?''', tile.coord)</div><div>OperationalError: no such table: tiles</div></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div></div>
</blockquote></div><br></div>