[sqlite] SQLite in multi-thread application

[ALBERT Aurélien]

Hi,

I'm using SQLite v3.8.8.3 in my muli-threaded application.

SQLite is configured so these asserts are satisfied :

        assert(sqlite3_threadsafe() > 0);
        assert(sqlite3_config(SQLITE_CONFIG_MULTITHREAD) == SQLITE_OK);

I have multiple connections to the same database file :
-       1 single connection is used by only a single thread
-       1 single thread use only 1 connection
-       All threads (about 4-8 threads) can read simultaneously
-       Using a mutex, only a single thread can write to the database (but 
reads can happen during this time)

But I have sometimes "Database is locked" errors.

Did I miss something in my configuration ?
Did I miss something in my mutex protection ?

Thanks for your help !