Version: 1.0 (KOffice 1.5.0) (using KDE 3.5.2-1.2.fc4.kde, Fedora Core release 4 (Stentz)) Compiler: Target: i386-redhat-linux OS: Linux (i686) release 2.6.16-1.2096_FC4smp In Kexi, I cannot create a database under /home which on my system is mounted from NFS. When I try, the error dialog states, "Unspecified error encountered." I suspect it's because my NFS doesn't support file locking. However, I can create a Kexi database in /tmp which is a local directory.
Thanks for raising this issue. I know this but not everyone. As you may know, Kexi files are built using SQLite libraries. See what SQLite creators say: http://www.sqlite.org/faq.html#q7 "But use caution: this locking mechanism might not work correctly if the database file is kept on an NFS filesystem." I am sure we'll need to mentione this in our manual. BTW, To be able to connect to the same sqlite (here: kexi) db some people recommend to implement a small server that acts as a dumb proxy for multiple clients, so real file is accessed only by one process. This is already on our TODO. For instance, see this dicussion: http://groups.google.com/group/comp.lang.tcl/browse_frm/thread/acfb27d701be3de/2481b12b9457808d?tvc=1&q=sqlite+nfs#2481b12b9457808d
In my case, I don't care at all about locking. I know I am the only one using the database.
So maybe an option for complete disabling file locking is needed. This may be another thing I'd need to change in the original SQLite implementation. Possible, as we, predicting we WANT to have control over out SQLite backend, we have a copy of it's source code within Kexi. Summing up, I tend to set resolution to "LATER".
Changed to wish.
Proper link to the SQLite FAQ is: http://www.sqlite.org/faq.html#q5