SQLite Forum

unable to open a database file in a btrfs readonly snapshot filesystem
Thanks both of you @sqweek and @ddevienne. 

It is in WAL mode, not Persistent mode.
The database file is retrieved from a device, having no -shm or -wal file. 

I do see those -shm, and -wal files alongside db file under a readwrite snapshot after I opened it.