]> Sergey Matveev's repositories - public-inbox.git/commit
over+msgmap: respect WAL journal_mode if set
authorEric Wong <e@yhbt.net>
Tue, 25 Aug 2020 03:02:47 +0000 (03:02 +0000)
committerEric Wong <e@yhbt.net>
Wed, 26 Aug 2020 06:10:52 +0000 (06:10 +0000)
commit5f6a0d2342323541e44ff2f1e7329053d0263800
treeec2243f42f3aebcacd08be07bc1b2dd06267092a
parent793dcb03635e167143c9df6897999f4698a5133c
over+msgmap: respect WAL journal_mode if set

WAL actually seems to have ideal locking characteristics given
concurrency problems I'm experiencing with --reindex running
in parallel with expensive read-only SQLite queries:
<https://public-inbox.org/meta/20200825001204.GA840@dcvr/>

Unfortunately, we cannot blindly use WAL while preserving
compatibility with existing setups nor our guarantees that
read-only daemons are indeed "read-only".

However, respect an user's the choice to set WAL on their
own if they're comfortable with giving -nntpd/-httpd/-imapd
processes write permission to the directory storing SQLite DBs.
lib/PublicInbox/Msgmap.pm
lib/PublicInbox/Over.pm
lib/PublicInbox/OverIdx.pm
t/over.t