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

Derrick Brashear shadow@gmail.com
Mon, 12 Apr 2010 00:34:23 -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.

do you happen to know what the corruption looked like (blocks of
zeroes, just not readable, something else)

--=20
Derrick