Hello Ken, >I think the problem is not in the locking mode but rather: > > PRAGMA journal_mode = off; > >I'm not sure if rollbacks actually function with the journalling turned off.
According to the documentation, journal_mode=off disables rollback. >Can you try it without the above line? I had already looked at the issue again and now blieve that it is an inconsistency between journal_mode=off and locking_mode. I filed it as a bug report at http://www.sqlite.org/cvstrac/tktview?tn=3811 but it has not yet been addressed by the SQLite developers. >The logic implies that the rows in question should not exist since they are >rolledback. No. With journal_mode=off, rows in question SHOULD exist, but miraculously do when in exclusive mode. Ralf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
