SQLite version 3.7.6.3 is now available on the SQLite website
http://www.sqlite.org/
http://www.sqlite.org/download.html
Version 3.7.6.3 is a patch release that fixes an obscure but nasty bug in
WAL-mode. Upgrading is recommended for all users. The bug is present in all
prior releases of SQLite that support WAL.
In prior releases of SQLite, if you set PRAGMA journal_mode=WAL, and if you set
PRAGMA cache_size=N where N is very small (less than 10) and if you do a
multi-statement transaction where the last SQLite statement prior to COMMIT is
a SELECT statement that requires all of your cache memory to complete, then
your COMMIT might be silently converted into a ROLLBACK. The database does not
corrupt, but any changes you made to the database during the transaction will
be lost.
Since cache_size defaults to 2000, applications that never mess with cache_size
(which is to say, the vast majority of applications) should never have a
problem. But sometimes developers working on low-memory devices try to crank
down cache_size in an effort to save memory. If you are one of those
developers, you should probably think seriously about upgrading.
Additional information:
http://www.sqlite.org/src/info/2d1a5c67df
http://www.sqlite.org/news.html
The patch needed to fix this problem in any 3.7.x release of SQLite can be seen
here:
http://www.sqlite.org/src/fdiff?v1=b7fe4b8e51d51a06&v2=4b2358556c88660a
Please respond to the sqlite-users mailing list ([email protected]) or
directly to me if you encounter any problems. Thanks.
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
