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

[Brandon Simmons]

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.

Thanks,
Brandon
http://coder.bsimmons.name/blog/