Re: sqlite threadsafe

On 20/11/2007 17:31, David Glasser wrote:
> On Nov 19, 2007 4:59 PM, Dan Christian <dchristian@google.com> wrote:
>> Argh! Not this again. openssl has similar problems (under serf).
>>
>> On Nov 19, 2007 1:46 PM, David Glasser <glasser@davidglasser.net> wrote:
>>> Apparently SQLite requires you to compile it with -DSQLITE_THREADSAFE
>>> to be at all threadsafe. (There's a way to check at runtime
>>> (sqlite3_threadsafe()) if this is so, but that's an experimental API
>>> that may vanish.)
>> Don't let it vanish. Runtime checks are the only foolproof way to verify this.
>
> "Don't let it vanish" may be backwards, sadly, since the API doesn't
> seem to have shown up until 3.5 (and we're already having issues with
> Etch not supporting even 3.3.9 for an API).

Fedora 6 has 3.3.6, but it looks like it is threadsafe.

>>> Should we add something to INSTALL telling people they must build
>>> against a threadsafe SQLite if they are going to be using a thready
>>> server?
>> YES! And configure should verify this. Otherwise, it looks like
>> subversion is flaky.
>
> I don't think it can verify it unless we require 3.5.

If it is threadsafe, it links against libpthread, so that's one (nasty)
way of checking on linux at least:

# ldd /usr/lib/libsqlite3.so
        linux-gate.so.1 => (0x00110000)
        libpthread.so.0 => /lib/libpthread.so.0 (0x00a38000)
        libc.so.6 => /lib/libc.so.6 (0x008c7000)
        /lib/ld-linux.so.2 (0x80000000)

David.

-- 
The information contained in this e-mail and in any attachments is confidential and is designated solely for the attention of the intended recipient(s). If you are not an intended recipient, you must not use, disclose, copy, distribute or retain this e-mail or any part thereof. If you have received this e-mail in error, please notify the sender by return e-mail and delete all copies of this e-mail from your computer system(s).
Please direct any additional queries to: communications@s3group.com.
Thank You.
Silicon and Software Systems Limited. Registered in Ireland no. 378073.
Registered Office: Whelan House, South County Business Park, Leopardstown, Dublin 18
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org