From b030bc698088aef9789763123de0f6dcd374cba4 Mon Sep 17 00:00:00 2001
From: drh <>
Date: Wed, 31 Jul 2024 22:26:04 +0000
Subject: [PATCH] testrunner.db should be in WAL mode for improved concurrency
 while running "watch sqlite3 test/testrunner.tcl status".

FossilOrigin-Name: f23ad0979865f3c11a3dbd0598ee7c4e2eabeaf1863d000fc0242e18890a4a11
---
 manifest            | 12 ++++++------
 manifest.uuid       |  2 +-
 test/testrunner.tcl |  3 ++-
 3 files changed, 9 insertions(+), 8 deletions(-)

diff --git a/manifest b/manifest
index c38dd8f848..282a025c06 100644
--- a/manifest
+++ b/manifest
@@ -1,5 +1,5 @@
-C Make\sthe\s#include\ssection\sof\stclsqlite.c\sthe\ssame\sas\stclsqlite.h.
-D 2024-07-31T22:25:25.378
+C testrunner.db\sshould\sbe\sin\sWAL\smode\sfor\simproved\sconcurrency\swhile\srunning\n"watch\ssqlite3\stest/testrunner.tcl\sstatus".
+D 2024-07-31T22:26:04.028
 F .fossil-settings/empty-dirs dbb81e8fc0401ac46a1491ab34a7f2c7c0452f2f06b54ebb845d024ca8283ef1
 F .fossil-settings/ignore-glob 35175cdfcf539b2318cb04a9901442804be81cd677d8b889fcc9149c21f239ea
 F LICENSE.md df5091916dbb40e6e9686186587125e1b2ff51f022cc334e886c19a0e9982724
@@ -1705,7 +1705,7 @@ F test/temptable2.test 76821347810ecc88203e6ef0dd6897b6036ac788e9dd3e6b04fd4d163
 F test/temptable3.test d11a0974e52b347e45ee54ef1923c91ed91e4637
 F test/temptrigger.test 38f0ca479b1822d3117069e014daabcaacefffcc
 F test/tester.tcl 640106bf8f7785d0ac67cda2837577eb9f2d936033bacedf9e705ca5451958ef
-F test/testrunner.tcl c1bd2910543a685a9cd44b70a69b1ca88b5cf9d2d5030bd57e17d9fbe3f1b6ce
+F test/testrunner.tcl 2d100e73245e5f423942b6c198176c699137ee65192ed872bd8c9d4ac2c779b3
 F test/testrunner_data.tcl c5ae2b1f9a99210b0600d002fb3af1fee350997cee9416551e83b93501360ebf
 F test/thread001.test a0985c117eab62c0c65526e9fa5d1360dd1cac5b03bde223902763274ce21899
 F test/thread002.test c24c83408e35ba5a952a3638b7ac03ccdf1ce4409289c54a050ac4c5f1de7502
@@ -2200,8 +2200,8 @@ F vsixtest/vsixtest.tcl 6195aba1f12a5e10efc2b8c0009532167be5e301abe5b31385638080
 F vsixtest/vsixtest.vcxproj.data 2ed517e100c66dc455b492e1a33350c1b20fbcdc
 F vsixtest/vsixtest.vcxproj.filters 37e51ffedcdb064aad6ff33b6148725226cd608e
 F vsixtest/vsixtest_TemporaryKey.pfx e5b1b036facdb453873e7084e1cae9102ccc67a0
-P 8327c5ed535c57c4082211a50bfb1c32ea5d5fe1cf71f37798d8b58e88948ac2
-R 20b530f4b4cc3303006640f07228cc1d
+P 2afadbeb124d6d7bb81d473379269014ebd8601f98f231e2218f54350a2e5fd3
+R 5fce834a5a2db65fecaa00b46e4798f7
 U drh
-Z 8814e0397816bd225e332f4bc053c4a6
+Z 15b14d3b91c5abdab729b01ed2691ec8
 # Remove this line to create a well-formed Fossil manifest.
diff --git a/manifest.uuid b/manifest.uuid
index c9a2ae7fd7..ddddcb7d72 100644
--- a/manifest.uuid
+++ b/manifest.uuid
@@ -1 +1 @@
-2afadbeb124d6d7bb81d473379269014ebd8601f98f231e2218f54350a2e5fd3
+f23ad0979865f3c11a3dbd0598ee7c4e2eabeaf1863d000fc0242e18890a4a11
diff --git a/test/testrunner.tcl b/test/testrunner.tcl
index 29be84e34e..b320528735 100644
--- a/test/testrunner.tcl
+++ b/test/testrunner.tcl
@@ -399,7 +399,7 @@ if {[llength $argv]==1
   }
 
   sqlite3 mydb $TRG(dbname)
-  mydb timeout 1000
+  mydb timeout 2000
   mydb eval BEGIN
 
   set cmdline [mydb one { SELECT value FROM config WHERE name='cmdline' }]
@@ -963,6 +963,7 @@ proc add_jobs_from_cmdline {patternlist} {
 proc make_new_testset {} {
   global TRG
 
+  trdb eval {PRAGMA journal_mode=WAL;}
   r_write_db {
     trdb eval $TRG(schema)
     set nJob $TRG(nJob)
-- 
2.39.5