>All recent occurrences of the problem where on local hard disks / SSD >disks. It even affects the small configuration databases my application >maintains in SQLite, with the FULL synch mode for maximum safety. These >also use WAL / shared_cache but are only updated a couple of times per >minute and have to endure much less stress by concurrent multi-thread >read/write.
Why are you using shared cache, especially with WAL? Are your devices memory constrained? --- Theory is when you know everything but nothing works. Practice is when everything works but no one knows why. Sometimes theory and practice are combined: nothing works and no one knows why.