On 12/30/21 12:22, Matthew Miller wrote:
> So for a read-only filesystem, if the db has wal enabled, the
files have
> to exist. (it's possible to disable WAL mode by running the sqlite 'PRAGMA
> journal_mode=DELETE;' command when the partition is writable beforehand,
> but I didn't see how to alter the mode while it is readonly)
FWIW, Sqlite has guidance here:
Given that the "shared-memory file contains no persistent content", it
seems like "rpmdb.sqlite-shm" could be a symlink to
/dev/shm/rpmdb.sqlite-shm", or to some other tmpfs location.
Also:
https://www.sqlite.org/walformat.html#the_wal_index_or_shm_file