sqlite over NFS (locking)

[Jesse Keating]

On Fri, 05 Oct 2007 13:39:26 -0600
Orion Poplawski <orion at cora.nwra.com> wrote:

> I just recently got bitten by issues accessing sqlite databases over
> NFS (trying to run pungi on Fedora devel and putting the output on
> our F7 fileserver).  Now, http://www.sqlite.org/faq.html#q5
> explicitly states that one should avoid this:
> 
> But use caution: this locking mechanism might not work correctly if
> the database file is kept on an NFS filesystem. This is because
> fcntl() file locking is broken on many NFS implementations. You
> should avoid putting SQLite database files on NFS if multiple
> processes might try to access the file at the same time.
> 
> 
> Now, is NFS fctl() locking really broken going from Fedora devel to 
> Fedora 7?  rpc.statd is running.  Filesystem is exported "sync".

I don't have an answer to this question, but I can surely agree that
trying to compose to a NFS dir did not work for me.  I discussed this
at length with Seth Vidal and others when I tried (shortly after -d
support became available in createrepo) and I think the general
consensus there was that createrepo should just avoid these situations
and instead use a local file system working dir to create the database
and then copy up the database to the destination directory when
finished.

However I never pursued this and failed to file any RFE bugs about it.
Now would probably be a good time for somebody to do that...  (:

-- 
Jesse Keating
Fedora -- All my bits are free, are yours?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/fedora-devel-list/attachments/20071005/af874650/attachment.sig>