[MapProxy] sqlite_timeout also for writing tiles?
Andreas Watermeyer
Andreas.Watermeyer at its-telco.de
Thu Jun 22 05:31:03 PDT 2017
Hi Oliver,
Ok great and thank you for your quick response!
Viele Grüße,
Andreas
________________________________
Von: Oliver Tonnhofer <olt at omniscale.de>
Gesendet: Donnerstag, 22. Juni 2017 13:23
An: Andreas Watermeyer
Cc: mapproxy at lists.osgeo.org
Betreff: Re: [MapProxy] sqlite_timeout also for writing tiles?
Hi,
the actual code is in
https://github.com/mapproxy/mapproxy/blob/master/mapproxy/cache/mbtiles.py
sqlite.py is an old experimental variant of the SQLite cache that
should have been removed a long time ago. I'll do that now. :)
wal and timeout should fix most locking issues (and bulk_meta_tiles if
you have a tile source).
Regards,
Oliver
--
Oliver Tonnhofer | Omniscale GmbH & Co KG | https://omniscale.com
OpenStreetMap WMS and tile services | https://maps.omniscale.com
> On 22.06.2017, at 11:38, Andreas Watermeyer <Andreas.Watermeyer at its-telco.de> wrote:
>
> Hi all,
>
> I was very excited to read about the configurable sqlite timeout and
> WAL mode. I found how to configure it:
> https://github.com/mapproxy/mapproxy/blob/master/mapproxy/config/spec.py
>
> But as I was searching for the information I also found out, that in
> https://github.com/mapproxy/mapproxy/blob/master/mapproxy/cache/sqlite.py
>
> there is still a connect to the sqlite with a hard-coded 3 seconds
> timeout, from "DatabaseStore" class, in line 341:
> self._db = sqlite3.connect(self.cache_path, timeout=3)
>
> I wonder if this is correct or if the timeout from the config has to
> be used here, too.
>
> In our project we have problems with high latency of I/O during
> writing of tiles, at certain times.
> Will the timeout from the config affect this issue or must the
> DatabaseStore be enhanced to adress this, too?
>
> Best regards, and keep on doing, I think MapProxy is a really great software!
> Andreas
> _______________________________________________
> MapProxy mailing list
> MapProxy at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapproxy
More information about the MapProxy
mailing list