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


_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

Reply via email to