Re: Bug#326648: libsqlite3-0: database handles can't be shared among threads any more

[Florian Weimer <fw@deneb.enyo.de>]

* Francesco P. Lovergine:

>> SQLite databases (and Subversion repositories) are intended to be
>> opened concurrently by multiple processes.

> To be more clear: programs which use ordinary file locking to
> syncronize threads need to be fixed.

I've looked at the SQLite code and it does this.  At the same time, it
has to implement recursive locks (which can be entered multiple times
by the same locker, hence it embeds a locker ID (the value returned by
phtread_self) in the lock data structure.  This causes the problem
Adeodato described.

I don't know how to better implement locking for SQLite, given the
constraints.