M.Kursad DARA wrote:
Hi folks,
I want to move my sqlite db's to another location and wants to mount on
nfs.
when i try to select some data from my sqlitedb on nfs i'm getting error
below:
SQL error: Database is locked.
What's is the solution.
Thanks.
ps : I googled but cant find exact solution.
Hi there.
The SQLite FAQ entry #5 at http://sqlite.org/faq.html#q5 has this to say:
SQLite uses reader/writer locks to control access to the database. [...]
*But use caution: this locking mechanism might not work correctly if the
database file is kept on an NFS filesystem.* This is because fcntl()
file locking is broken on many NFS implementations. You should avoid
putting SQLite database files on NFS if multiple processes might try to
access the file at the same time.
So, basically, it's a "don't do that" situation. Try using CIFS sharing.
You could search for more mentions of NFS on sqlite.org by using Google
this way:
http://www.google.com/search?q=nfs+site:sqlite.org
HTH
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users