On Wed, Mar 9, 2011 at 5:01 AM, pkcpkc <catch_pra...@hotmail.com> wrote:
> > What would happen if the following situation occurs: > I begin a transaction and then do multiple sqlite execute statements. One > of > the execute statements fails and I try doing a rollback. Now when I try the > rollback the rollback also fails. Does it mean database is corrupted? > Or will it be rolled back automatically? > Why is the ROLLBACK failing? If I/O errors or out-of-memory errors prevent a rollback from happening, SQLite abandons its changes, leaving the rollback journal (or WAL file) on the disk, with the idea that the next process to come along will fix the problem. But this is a very unusual occurrence, since rollback does not often fail. > -- > View this message in context: > http://old.nabble.com/Failure-during-Rollback-statement-tp31104890p31104890.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > 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
