[MapProxy] sqlite_timeout also for writing tiles?

[Andreas Watermeyer]

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