From d4184cffc2726d234b379871a8459822c13a8d43 Mon Sep 17 00:00:00 2001
From: David-Sarah Hopwood <david-sarah@jacaranda.org>
Date: Thu, 6 Dec 2012 04:06:13 +0000
Subject: [PATCH] Use "PRAGMA synchronous = OFF" for dbutil.
Signed-off-by: David-Sarah Hopwood <david-sarah@jacaranda.org>
---
src/allmydata/util/dbutil.py | 8 ++++++++
1 file changed, 8 insertions(+)
diff --git a/src/allmydata/util/dbutil.py b/src/allmydata/util/dbutil.py
index c811fdfa..fc12d4c0 100644
--- a/src/allmydata/util/dbutil.py
+++ b/src/allmydata/util/dbutil.py
@@ -31,6 +31,14 @@ def get_db(dbfile, stderr=sys.stderr,
# The default is unspecified according to <http://www.sqlite.org/foreignkeys.html#fk_enable>.
c.execute("PRAGMA foreign_keys = ON;")
+ # This is necessary to pass tests for the time being, since using
+ # synchronous = NORMAL causes failures that are apparently due to a
+ # file descriptor leak, and the default synchronous = FULL causes the
+ # tests to time out. For discussion see
+ # https://tahoe-lafs.org/pipermail/tahoe-dev/2012-December/007877.html
+ #c.execute("PRAGMA journal_mode = WAL;")
+ c.execute("PRAGMA synchronous = OFF;")
+
if must_create:
c.executescript(schema)
c.execute("INSERT INTO version (version) VALUES (?)", (target_version,))
--
2.45.2