3 ms·

> NFS will lead to all kinds of nasty problems Really important caveat, cause dear [whatever you pray to] will it ever blow up in your face on NFS storage. I w

> NFS will lead to all kinds of nasty problems Really important caveat, cause dear [whatever you pray to] will it ever blow up in your face on NFS storage. I worked at a company that tried to store production-deployed code as state in a globally-reachable SVN repo on NFS… someone(s) at each location had write access, and every so often the underlying SQLite3 file would go ping in a catastrophic manner. Love SQLite, ludicrously underrated and ridiculously flexible, and the problems we had started way before that was deployed, but yeah stay away from a file system without reliably atomic locking.

chasil 2y ago
You cannot use WAL mode over NFS. All connections are required to map shared memory for WAL to work, which precludes network file sharing in general.
- yawpitch 2y ago
  Right, should have mentioned this was in the pre-WAL mode days. SVN repos were never intended for wanton and masochistic abuse anything like we were doing.
somat 2y ago
sqlite on nfs from several processes on the same host should work. I think... Perhaps... maybe... (but why then are you using nfs?) It is just where it is unable to use the shared memory lock system that it starts corrupting. At least I hope, I don't use much sqlite myself, but I like having a nfs home directory and a lot of applications use sqlite. I once worked at a place where they were using a database(unidata) that would error out if it detected it was being run on nfs. so they got around this problem by... running it on... smb. Sigh... I was like, you guys know why it does not want to run on nfs right.... smb will have the same problems, the database is just not explicitly looking for smb. if you ever write from both systems it will blow up the database and you have a very good chance to get incorrect data on reads. but the database team liked it and just dealt with the fires as they started. so it stuck.

chasil 2y ago

You cannot use WAL mode over NFS. All connections are required to map shared memory for WAL to work, which precludes network file sharing in general.

yawpitch 2y ago
Right, should have mentioned this was in the pre-WAL mode days. SVN repos were never intended for wanton and masochistic abuse anything like we were doing.

somat 2y ago

sqlite on nfs from several processes on the same host should work. I think... Perhaps... maybe... (but why then are you using nfs?) It is just where it is unable to use the shared memory lock system that it starts corrupting. At least I hope, I don't use much sqlite myself, but I like having a nfs home directory and a lot of applications use sqlite. I once worked at a place where they were using a database(unidata) that would error out if it detected it was being run on nfs. so they got around this problem by... running it on... smb. Sigh... I was like, you guys know why it does not want to run on nfs right.... smb will have the same problems, the database is just not explicitly looking for smb. if you ever write from both systems it will blow up the database and you have a very good chance to get incorrect data on reads. but the database team liked it and just dealt with the fires as they started. so it stuck.