Ok, so upon further investigation, I'm not losing file handles (Thanks Simon!). What's actually happening is I'm getting a SQLITE_NOMEM when I run the queries in Process A (after Process B finished and checkpoints).
In Process A (the desktop app), I have 2 connections. This error is only happening in one of those connections! The plot thickens... -- AJ On Monday, 18 March, 2013 at 10:51 PM, Simon Slavin wrote: > > On 19 Mar 2013, at 2:36am, Alykhan Jetha <[email protected] > (mailto:[email protected])> wrote: > > > Just to be clear. > > Is it true that I can have one and only one connection per thread? > > > > > I don't think so. There are plenty of single-process single-thread apps which > open multiple SQLite connections. > > I thought it was kind-of the other way around: don't have multiple threads > trying to use the same connection at the same time. As long as you observe > thread safety as described here: > > <http://www.sqlite.org/threadsafe.html> > > you can have any number of connections open. > > In checking that URL I just found this interesting discussion of SQLite and > threads: > > <http://dev.yorhel.nl/doc/sqlaccess#Thread-local_connections> > > It is way above my head, and I have no idea if it's useful or even correct, > but it does use some of the right words. > > Simon. > _______________________________________________ > sqlite-users mailing list > [email protected] (mailto:[email protected]) > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
