changeset 4004:e47cdbb48ac7

sqlcache: passe better connection option These new options should help with handling transaction consistency and database access on high load.
author Pierre-Yves David <pierre-yves.david@octobus.net>
date Mon, 27 Aug 2018 00:18:06 +0200
parents 518e04284921
children d85556dd18b5
files hgext3rd/evolve/obsdiscovery.py hgext3rd/evolve/stablerangecache.py
diffstat 2 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/hgext3rd/evolve/obsdiscovery.py	Sun Aug 26 20:55:26 2018 +0200
+++ b/hgext3rd/evolve/obsdiscovery.py	Mon Aug 27 00:18:06 2018 +0200
@@ -529,7 +529,7 @@
             util.makedirs(self._vfs.dirname(self._path))
         except OSError:
             return None
-        con = sqlite3.connect(self._path)
+        con = sqlite3.connect(self._path, timeout=30, isolation_level="IMMEDIATE")
         con.text_factory = str
         return con
 
--- a/hgext3rd/evolve/stablerangecache.py	Sun Aug 26 20:55:26 2018 +0200
+++ b/hgext3rd/evolve/stablerangecache.py	Mon Aug 27 00:18:06 2018 +0200
@@ -193,7 +193,7 @@
             util.makedirs(self._vfs.dirname(self._path))
         except OSError:
             return None
-        con = sqlite3.connect(self._path)
+        con = sqlite3.connect(self._path, timeout=30, isolation_level="IMMEDIATE")
         con.text_factory = str
         return con