2 ms·
Are you running it in WAL mode? I've had applications (not on NFS, but with multiple processes accessing the same SQLite database file at once) which throw occ
by simonw 4y ago
Are you running it in WAL mode?
I've had applications (not on NFS, but with multiple processes accessing the same SQLite database file at once) which throw occasional I/O errors in default journal mode but didn't throw errors at all once I switched into WAL mode.
https://til.simonwillison.net/sqlite/enabling-wal-mode https://til.simonwillison.net/sqlite/enabling-wal-mode
- kayson 4y agoI think most of the apps use WAL nowadays (at least from what I remember when I looked into this a while back) but I'll have to check again! Thanks.
- formerly_proven 4y agoWAL mode requires shared memory (unless you disable concurrency through exclusive locking) and therefore doesn't work on network shares.
- simonw 4y agoGreat point.