[OpenAFS] sqlite on AFS will not work, even with whole-file

Brandon Simmons brandon.m.simmons@gmail.com
Tue, 13 Apr 2010 15:36:45 -0400

On Sun, Apr 11, 2010 at 11:13 PM, Adam Megacz <adam@megacz.com> wrote:
> Brandon Simmons <brandon.m.simmons@gmail.com> writes:
>> Thanks for the response. It seems like whole-file locking in sqlite
>> would be a good choice for me in any case,
>> In a situation where the whole-file locking scheme is used, would AFS
>> be an acceptable choice? Would it be better than NFS?
> I had the same idea, and tried it. =A0It does not work. =A0Your databases
> will get corrupted. =A0I never figured out why, although I did confirm
> that sqlite was in fact requesting only whole-file locks.
> It would be nice if it worked, though. =A0There are a lot of applications
> out there where writes to the database are extremely rare, so
> invalidating all the clients' caches is not a problem.

A couple questions: I assume you were on a linux network? Also, how
exactly did you
ensure that you were using whole-file locking? I'm still not even
clear, after reading the
Sqlite docs and the responses here, how to do that.