[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: SQLite locking and FSFS rep-sharing

From: Mark Phippard <markphip_at_gmail.com>
Date: Mon, 20 Jun 2011 07:28:50 -0400

On Mon, Jun 20, 2011 at 7:01 AM, Philip Martin
<philip.martin_at_wandisco.com> wrote:
> Philip Martin <philip.martin_at_wandisco.com> writes:
>
>> The second commit doesn't wait for the 10 second SQLite busy timeout, it
>> gives the 'database is locked' error immediately.
>>
>> Should we be doing more to support concurrent writes here?  An explicit
>> loop in the post-commit?  A different SQLite configuration?
>
> A change from 1.6 is that 1.7 uses sqlite for packed revprops.  It turns
> out that the packed revprop database doesn't have this problem because
> access to it is protected by the FSFS repository lock.
>
> We could change the rep-sharing database access to take the FSFS
> repository lock.  Read access to the database already occurs at a point
> when the lock is held.

Would that open us back up to this problem?

http://subversion.tigris.org/issues/show_bug.cgi?id=3506

-- 
Thanks
Mark Phippard
http://markphip.blogspot.com/
Received on 2011-06-20 13:29:21 CEST

This is an archived mail posted to the Subversion Dev mailing list.