Unable to open sqlite database on shared folder

[jlm]

When attempting to open an sqlite database on a shared folder it fails with "Error: disk I/O error"

If I copy that same database from the shared folder locally to the VM then the open succeeds.

jlmcgraw@mate1604:~$ sqlite3 /media/sf_Shared_Folder/Recordings.db 
 SQLite version 3.14.1 2016-08-11 18:53:32
 Enter ".help" for usage hints.
 sqlite> .tables
 
 Error: disk I/O error
 sqlite> .q

jlmcgraw@mate1604:~$ cp /media/sf_Shared_Folder/Recordings.db .

jlmcgraw@mate1604:~$ sqlite3 Recordings.db 
 SQLite version 3.14.1 2016-08-11 18:53:32
 Enter ".help" for usage hints.

 sqlite> .tables
 ZDATABASEPROPERTY  ZRECORDING         Z_MODELCACHE     
 ZENTITYREVISION    Z_METADATA         Z_PRIMARYKEY     

 sqlite> .q

[jlm]

Strace snippet just after the ".tables" command

[alexdc]

Same behaviour regarding sqlite3 with Windows 10 - 64 bits host on Intel i7

sqlite3 toto.db
SQLite version 3.8.7.1 2014-10-29 13:59:56
Enter ".help" for usage hints.
sqlite> .restore toto.bck
Error: disk I/O error

Guest: Linux 3.16.0-6-amd64 #1 SMP Debian 3.16.57-2 (2018-07-14) x86_64 GNU/Linux
Virtualbox 5.2.18

[Socratis]

VirtualBox's Shared Folders present a really simplified file system implementation, just enough to read/write files from/to the guest. Many applications can error when using Shared Folders, because they expect advanced features, for example file locking, access controls, etc., which don't exist as a concept for Shared Folders.

For cases like that you should be using true network shares, such as NFS or SMB shares.

If anything, this ticket is not about a bug, this is an enhancement request.