I recently - again - encountered a situation where sqlite databases on NFS shares would break:
Since firefox/thunderbird also use sqlite internally, my home is on NFS and they most assuredly don't break under heavy usage, I started investigating.
At first, I thought that SQLITE_ENABLE_LOCKING_STYLE=1 could enable locking method detection and that enabling it might help.
But looking at the code of both sqlite and mozilla, that doesn't appear to be what's going on - all code around SQLITE_ENABLE_LOCKING_STYLE is also conditional on __APPLE__ or other non-linux os specific environments.
This looked promising:
But I don't have the storage.nfs_filesystem preference set, and firefox still works correctly out of my NFS home, whereas clementine regularly corrupts its database.
Ah well, I'll try to dig deeper another time; perhaps someone with more information about what's going on here could drop a few pointers.
For the time being, symlinking the clementine database to a local filesystem works around the issue.
Upstream asked you: "Can you try with the latest version (1.2.1)?"
As mentioned above, please check if the problem persists in latest versions and feel free to reopen the bug.