-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Pavel Ivanov wrote: > I believe the problem here can be either in buggy file locking via NFS
The issue is two fold. One is that SQLite still does locking operations even if you open read only (which may not be expected by some users but is necessary). The second is that file locking on NFS is pretty much always buggy. Back when I developed file servers it was hard to not crash NFS lock daemons! Even if file locking was done correctly and reliably it would still require round trips to the server for all the locking operations and various interactions with the client side attribute and data caches. Each new NFS version has improved the situation but we don't know exactly version is in use and if it is 100% correctly implemented. NFS implementations sell themselves on performance not locking correctness :-) Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkrjttYACgkQmOOfHg372QQaGgCdEqWM59zLzb61gwvzHueef2uP FqkAnRr1NQVTNtJrRCZ4t3dp48ywpAC7 =hNmR -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
