From d4184cffc2726d234b379871a8459822c13a8d43 Mon Sep 17 00:00:00 2001 From: David-Sarah Hopwood Date: Thu, 6 Dec 2012 04:06:13 +0000 Subject: [PATCH] Use "PRAGMA synchronous = OFF" for dbutil. Signed-off-by: David-Sarah Hopwood --- 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 . 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