>Date: Sun, 13 Feb 2011 22:14:29 -0500 >From: Pavel Ivanov <paiva...@gmail.com> > >> I do a transaction on connection 1 using BEGIN IMMEDIATE, some rows updated, >> COMMIT. >> Then, when I attempt same sequence on connection 2, when I do first call to >>step >> to execute begin transaction and it never returns. > >Do you check result code from COMMIT and is it successful? My guess is >you have some SELECT statements which are not reset or finalized >before COMMIT. And your COMMIT in such situation should return >SQLITE_BUSY. If that's true then second BEGIN IMMEDIATE just can't >finish because another writing transaction is not finished yet. > >Pavel
Thanks, Pavel. My wrapper class for SQLite prevents a COMMIT with an outstanding statement. You are however correct, it was a prior failed COMMIT. It just happen on the one place in my code where I do not check return from COMMIT. It was a "constraint failure". Thanks also to others who have offered suggestion. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
