Add-on cannot write to SQLite DB on CIFS for `Media` usage

Configuration
1

  1. I have a CIFS network storage mounted for Media usage.

  2. I thought it would be nice to also use it to store the media’s meta data.

  3. But all my add-ons have trouble writing a SQLite DB to it. Example errors are like

time="2023-10-25T04:51:58Z" level=error msg="Error disabling foreign_keys" error="database is locked"
time="2023-10-25T04:52:13Z" level=fatal msg="Database could not be opened!" error="database is locked"

  1. The errors go away if I get the add-on to store to a container’s FS instead, aka the configuration for the add-on is good.

  2. Any idea what I can do to allow it?