sqlcache: passe better connection option stable
authorPierre-Yves David <pierre-yves.david@octobus.net>
Mon, 27 Aug 2018 00:18:06 +0200
branchstable
changeset 4017 c307ce1d9009
parent 4016 e058b3288770
child 4018 b3517f834f83
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
@@ -524,7 +524,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
@@ -194,7 +194,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