SQLite Forum

Timeline
Login

2 forum posts by user sprhawk

2020-06-13
04:12 Reply: unable to open a database file in a btrfs readonly snapshot filesystem (artifact: adb6213308 user: sprhawk)

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.

2020-06-12
11:15 Post: unable to open a database file in a btrfs readonly snapshot filesystem (artifact: 988f8698f8 user: sprhawk)

I'm opening a database file in a btrfs readonly snapshot filesystem, using latest sqlite3(SQLite version 3.32.2 2020-06-04 12:58:43), inside cli, execute .schema, it reported "unable to open database file".

When I copy that file out, sqlite3 can access it without problem.

I tried to open in readonly mode (sqlite3 -readonly db), it didn't work either.