On 2021-4-30 01:50 , Ken Cunningham wrote:
On 2021-04-29, at 8:32 AM, Joshua Root wrote:
It appears that SQLite version 3.35.5 as installed by the sqlite3 port deletes
a database's -wal and -shm files at least some of the time when closing. SQLite
version 3.28.0 as shipped as /usr/bin/sqlite3 on Catalina does not. The
existence of these files is necessary to read a WAL mode database in a
directory that you don't have write permission on.
- Josh
FYI, probably not the port itself I think as I did see the same error on Ubuntu
20.04 building MacPorts there against their default install of sqlite3.
Used this recipe:
https://trac.macports.org/wiki/InstallingMacPortsOnUbuntuLinux
I've reported the issue on the SQLite forum.
- Josh
