[DBD-SQLite] SQLite 3.7.0 now in SVN - new bugs to fix

Darren Duncan darren at darrenduncan.net
Thu Jul 22 02:54:08 GMT 2010


Today the next major version of SQLite was released, and below the dashed line 
is a copy of D. Richard Hipp's release announcement.

I have committed that version into the DBD::SQLite Subversion repository, so 
when you svn-up you should have that version.

 From my own testing, the simple substitution of 3.7.0 for the previous 
broke a couple of our tests:

t/08_busy.t                            (Wstat: 512 Tests: 23 Failed: 2)
   Failed tests:  11, 22
   Non-zero exit status: 2
t/28_schemachange.t                    (Wstat: 512 Tests: 9 Failed: 2)
   Failed tests:  7-8
   Non-zero exit status: 2

... and these cite 'disk I/O error' as the problem.

I did not debug the problem aside from that I tested both with the Subversion 
head plus the latest CPAN release 1.30_03; for both, the above 2 errors occur 
with 3.7.0 and not with the prior SQLite version.

Separately, Subversion head had a few other failures in "make test" on my system 
while the pristine 1.30_03 had no errors; those would just be related to 
DBD::SQLite changes.

Given the major changes in 3.7.0, I recommend cutting a new CPAN developer 
release 1.30_04 as soon as all the tests pass.

For my part, I can at least try testing on another system or 2 in case for some 
reason the new failures are specific to my first machine, though if anyone else 
can reproduce the above test failures then that won't be necessary.

-- Darren Duncan


SQLite version 3.7.0 is now available on the website


The most important change in version 3.7.0 is that SQLite now supports 
write-ahead logs as an optional method for transaction control, for improved 
performance and concurrency.  Additional information can be found here:


We are actually already using the write-ahead logging feature on the SQLite 
website itself, in the Fossil DVCS that tracks all changes to the SQLite source 
tree. (Yes, the SQLite write-ahead log code is stored in an SQLite write-ahead 
log database - how's that for recursion!)


The added concurrency of the write-ahead log journaling mode allows multiple 
users to be doing extended read operations, such as checking out historical 
versions of the SQLite code or looking at extended timelines simultaneously with 
developers making new checkins, adding or editing tickets, or actually 
rebuilding the entire 10-year source code database.  The write-ahead log code 
has performed very well so far for us.

Version 3.7.0 also marks the official cut-over to our new SQLite logo and a new 
color scheme for the website.  We hope you like the new look.

The 114-day time span since the previous release (version is the 
longest span between consecutive releases in the 10-year history of SQLite. 
Much of that time was spent testing and stressing the new write-ahead log 
feature.  This is probably the most thoroughly tested release of SQLite that we 
have every produced.  And so even though the write-ahead logging feature is 
entirely new, we are very hopeful that the 3.7.0 release will prove to be stable 
and robust and ready for production use.

Of course, if you do happen to run into problems, please let me know at once. 

D. Richard Hipp
drh at sqlite.org

More information about the DBD-SQLite mailing list