My track record of giving helpful advice here is not great, but this
does not sound like an NFS problem to me.
Your example made it look like everyone is logging into the server, and
running the SQLite executable located there, rather than running an
executable located on their own machine and all accessing the db file on
the server. These are very different things.
If I am right, then something else is happening, such as somehow using
different files, or something else deleting or otherwise modifying the
file between accesses.
HTH,
Gerry
On 9/22/2013 8:34 AM, olivier Ménard wrote:
The os in use is Linux Ubuntu, so i suppose the protocol NFS too.
If i have well understood :
in theory, multiple access should work with sqlite, but in practice, it doesn't
because of the os : the mechanism of locking doesn't work ?
I supose it won't change anything but Is it possible to improve the mechanism
If everyone writes an explicit
BEGIN IMMEDIATE (or EXCLUSIVE ?)
INSERT ...
END
Thanks for all the answers.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users