Would WAL mode prevent this?
Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Richard Hipp [d...@sqlite.org] Sent: Thursday, April 26, 2012 2:44 PM To: General Discussion of SQLite Database Cc: ian Subject: EXT :Re: [sqlite] SQLite 3.7.11 behavioral change from 3.7.10 with concurrency -- bug?? A rollback deletes content out from under other queries. So if you have a query pending in thread 1 and thread 2 tries to rollback, there are two options: (A) The rollback fails (B) The pending query is aborted. It used to be that we did (A). (If you had checked the return codes from your "ROLLBACK TRANSACTION" statement you would have been seeing it fail.) The latest code does (B) instead. Your software depends upon behavior (A). Other users prefer behavior (B). I don't know how to make everyone happy.... -- D. Richard Hipp d...@sqlite.org _______________________________________________ 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
