Re: [Monotone-devel] mtn: error: sqlite error: database is locked

[Zack Weinberg]

On Dec 25, 2007 6:32 PM, Alvaro Herrera <address@hidden> wrote:
> Zack Weinberg wrote:
> > On Dec 25, 2007 1:37 PM, Alvaro Herrera <address@hidden> wrote:
> > > Wow.  This is so much a lot of work for something that the database
> > > system should be doing on its own!
> >
> > I don't see how you could possibly think that.  Most of the problem is
> > that Monotone isn't telling the database when it only needs read-only
> > access; no matter what database we were using, we'd have to fix that.
>
> Why would the database care?  If the appropriate constraints are in
> place, the database itself would alert Monotone when an operation it is
> attempting would conflict with another ongoing operation.

In the present state of the code, Monotone wraps every access to the
database in an EXCLUSIVE transaction.  The work you are dismissing as
unnecessary-if-only-we-used-a-different-backend is the work needed to
make it not do that.

zw