After upgrading from 12.0-U2 to 12.0-U3 I got issues with sqlite3 databases stored on a dataset shared via NFS.
When I list the tables for example:
If I copy the file from the NFS storage to a local hard drive it works as expected.
After some searching I found it might be related to file locking.
If I run this on a file on the NFS share it gets stuck:
However, from another server running FreeNAS-11.3-U5 it doesn't get stuck. I don't have the possibility to check on a 12.0-U2 system.
Any advice? Should I rollback to 12-U2?
When I list the tables for example:
Code:
sqlite> .tables Error: disk I/O error sqlite>
If I copy the file from the NFS storage to a local hard drive it works as expected.
After some searching I found it might be related to file locking.
If I run this on a file on the NFS share it gets stuck:
$ flock testfile touch testfile
However, from another server running FreeNAS-11.3-U5 it doesn't get stuck. I don't have the possibility to check on a 12.0-U2 system.
Any advice? Should I rollback to 12-U2?