sqlcache: passe better connection option
authorPierre-Yves David <pierre-yves.david@octobus.net>
Mon, 27 Aug 2018 00:18:06 +0200
changeset 4004 e47cdbb48ac7
parent 4003 518e04284921
child 4005 d85556dd18b5
sqlcache: passe better connection option These new options should help with handling transaction consistency and database access on high load.
hgext3rd/evolve/obsdiscovery.py
hgext3rd/evolve/stablerangecache.py
--- 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