another bugfix upstream release. please signoff. -Andy SQLite version 3.6.12 is now available on the SQLite website http://www.sqlite.org/ During release testing for 3.6.12, we stumbled over a critical bug that has existed in SQLite since version 3.4.0. This bug will cause corruption of in-memory databases if an incremental vacuum is rolled back. The corruption is virtually guaranteed if you rollback an incremental vacuum in an in-memory database. Presumably not many people are doing that or we would have seen this sooner. As far as we are aware, incremental vacuum works correctly for on-disk databases. We will continue to study this issue over the next weeks and release additional patches if we find new problems. A manual code review uncovered another bug in the lookaside memory allocator which can result in a segfault when shared cache is enabled. At the very least, users of shared cache should disable lookaside memory. A better solution is to update to version 3.6.12. New features added to version 3.6.12 include the sqlite3_unlock_notify() interface and the reverse_unordered_selects PRAGMA. Additional information about both is available on the website. Because of the incremental vacuum and lookaside memory allocator issues identified above, we recommend that everyone update to SQLite version 3.6.12. D. Richard Hipp drh@hwaci.com