[odb-users] Timeout and Concurrency issues

[Boris Kolpackov]

Hi Erez,

Erez Pics <picserez at gmail.com> writes:

> On windows things seem to work fine but on Mac we get many timeout
> exceptions [...]

My guess would be the SQLite library you are using on MacOS is built
without multi-threading support (which is the case for the default
SQLite library that comes with the system). Quoting the INSTALL file
from libodb-sqlite:

"If you plan to access an SQLite database from multiple threads, then
 you will need SQLite version 3.5.0 or later built with the unlock
 notify feature (SQLITE_ENABLE_UNLOCK_NOTIFY) enabled."

So you need to build a private copy of SQLite with 
SQLITE_ENABLE_UNLOCK_NOTIFY:

./configure CFLAGS="-O3 -DSQLITE_ENABLE_UNLOCK_NOTIFY=1"

Then use it to re-build libodb-sqlite and your application.

Boris