[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: Philip Martin <philip.martin_at_wandisco.com>
Date: Mon, 20 Jun 2011 16:33:22 +0100

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.

r1137660 changed the rep-cache update to optimise for the common case
when the reps are not already present. It means that most of the time
the update will only use INSERT statements and no SELECT statements. It
has is an unintended side-effect: it appears to make the SQLITE_BUSY
timeout apply before I see the 'database is locked' error, and if I
release the lock during that timeout the error doesn't get raised.

-- 
Philip
Received on 2011-06-20 17:33:58 CEST

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