On Thu, Sep 30, 2010 at 3:02 PM, Erik Fears <str...@strtok.net> wrote:
> Each thread has its own handle (implemented using boost's thread local > storage). > > I had a bug a few days ago I fixed where I was leaking sqlite3_stmt objects > in the reader thread. If I don't finalize a sqlite3_stmt, would it leave a > transaction uncommitted? > It could. The answer depends on the details of the SQL statement. But if you were leaving statements unfinalized and you were getting behavior consistent with holding a transaction open, I'm guessing that was your problem. > > --erik > > On Wed, Sep 29, 2010 at 2:35 PM, Simon Slavin <slav...@bigfraud.org> > wrote: > > > > > On 29 Sep 2010, at 8:20pm, Erik Fears wrote: > > > > > -C++ with 3 threads. One of them a write thread, one a main reader > > thread, > > > and one a diagnostic reader thread > > > > Does each thread open the database independently, or are you passing the > > same handle from one to another ? > > > > Simon. > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users