[arch-dev-public] [signoff] sqlite3-3.6.12-1

Andreas Radke a.radke at arcor.de
Wed Apr 1 15:03:51 EDT 2009

another bugfix upstream release. please signoff.


SQLite version 3.6.12 is now available on the SQLite website


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 at hwaci.com

More information about the arch-dev-public mailing list