[GRASS-user] Trouble with SQLite on NFS

[Blumentrath, Stefan]

Hi,

Recently I started having trouble with SQLite on NFS. SQLite databases appear to be always locked, even the very moment when they are created (e.g. through v.out.ogr). Not sure what the reason might be as several things were changed at once: OS / package update, changed mounting routine...

There are voices saying that SQLite should not be used on NFS at all: http://stackoverflow.com/questions/9907429/locking-sqlite-file-on-nfs-filesystem-possible
And it seems that many (if not all) operative systems (Ubuntu, RedHat, Windows...) are having trouble with file-locking on NFS, see: https://www.sqlite.org/faq.html#q5

Mounting the share with "nolock"-option makes it possible to create SQLite DBs on NFS, but I am afraid that this could have unpredictable side effects!?. It would be a pity if we could not use SQLite on NFS reliably...

I tried if I can work around this, by moving temporary files to the local file system (as described here: https://trac.osgeo.org/grass/ticket/2185). But that does not seem to have any effect. How can I check if TMPDIR and GRASS_TMPDIR_MAPSET are taken into account?

Thanks for helping in advance...

Kind regards,
Stefan


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20151217/e1cb6cb1/attachment-0001.html>