Re: [sqlite] mutex assert_fail in btreeInvokeBusyHandler occasionally in a periodic DB update in 3.5.7, It's ok in 3.6.22(-DSQLITE_THREADSAFE=1)

2011-03-31 Thread Black, Michael (IS)
Since it apperas you're running your commit in a separate thread and are therefore muilti-threaded I do belive you need: SQLITE3_THREADSAFE=2 >From http://www.sqlite.org/compile.html#threadsafe To put it another way, SQLITE_THREADSAFE=1 sets the default threading mode to Serialized.

[sqlite] mutex assert_fail in btreeInvokeBusyHandler occasionally in a periodic DB update in 3.5.7, It's ok in 3.6.22(-DSQLITE_THREADSAFE=1)

2011-03-30 Thread ChingChang Hsiao
Please neglect the previous 2 emails. Sorry for the inconvenience. Version is 3.5.7 journal mode = DELETE SELECT sqlite_source_id(); 2011-01-28 17:03:50 ed759d5a9edb3bba5f48f243df47be29e3fe8cd7 -DSQLITE_THREADSAFE=1 in Makefile static int btreeInvokeBusyHandler(void *pArg){ BtShared *pBt =