I've reproduced the issue using both SERIALIZED and MULTITHREADED modes. The issue here doesn't seem to have anything to do with the threading modes. The issue is related to shared caches, and waiting on a b-tree lock while holding the global SQLITE_MUTEX_STATIC_OPEN lock.
- Brian Vincent On Sat, Jul 9, 2016 at 5:33 AM Simon Slavin <slav...@bigfraud.org> wrote: > > On 9 Jul 2016, at 9:27am, Olivier Mascia <o...@integral.be> wrote: > > > I'm really interested in knowing wether you use the engine in SERIALIZED > or MULTITHREADED mode during this event reproduction? > > In other words, please read the last part of > > <https://www.sqlite.org/threadsafe.html> > > and try to reproduce your problem in "Multi-thread" mode. If the problem > still occurs, please try again in "Serialized" mode. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users