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

Re: svn commit: r1185242 - /subversion/trunk/subversion/libsvn_subr/sqlite.c

From: Philip Martin <philip.martin_at_wandisco.com>
Date: Tue, 18 Oct 2011 11:09:32 +0100

rhuijben_at_apache.org writes:

> Author: rhuijben
> Date: Mon Oct 17 15:13:35 2011
> New Revision: 1185242
>
> URL: http://svn.apache.org/viewvc?rev=1185242&view=rev
> Log:
> Remove the SQLITE_OPEN_SHAREDCACHE flag from opening SQLite databases.
> VisualSVN and AnkhSVN users are reporting errors caused by the limitations of
> the shared caching in SQLite.
>
> The current implementation temporarily doesn't allow certain operations that
> are allowed concurrently if the usual via-file sharing is used. Until this is
> fixed in SQLite I think we should stop using this flag.
> The common errors are 'database table is locked' and 'schema has changed'.
>
> VisualSVN already disabled this flag in their build (reported by Ivan) and I
> will have to do the same thing in SharpSvn and as far as I know this are
> currently the two most prominent multithreaded subversion library users
> that would benefit if this flag always worked correctly.

It also affects every multithreaded Unix server when accessing the
rep-cache db. Does this affect the performance?

-- 
Philip
Received on 2011-10-18 12:10:12 CEST

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