SQLite Forum

unable to open a database file in a btrfs readonly snapshot filesystem
I am running SQLite for years on a BTRFS on multiple Linux PC without a problem.
Never had an issue.  However, if the database is in use by a process that sets a lock you will get an error that something is amiss. Wait a while or kill the process and the problem is solved. Don't try to repair the database.
Linux BTRFS and corrupt files are a mystical phenomenon.