Guess the mailing list stripped the attachment, I've uploaded it here: http://www.monetra.com/~brad/integrity_check.txt.bz2
Brad House wrote: > I'm just investigating an issue now. This is the first ever > incident of a corrupt database we've had on a few thousand > installations, though most of our installations are on > SQLite 3.4, our latest release is now using 3.5.8. > We have deployments on just about every OS... > > The OS that experienced the corruption was Windows XP-E > (embedded). > > The error message SQLite is returning is: > database or disk is full > > But I am told there are 45G free on the partition that > the database file resides. > > We do use SQLite in a multithreaded environment, and it > is compiled with Threadsafe. Infact, we modify the > amagalmation and put: > #define SQLITE_THREADSAFE 1 > At the top of the file just to make sure. > We also use 'sqlite3_enable_shared_cache(1)'. I don't > think it really provides that much benefit to us though > as we are more commit-heavy, so I can disable it if > it might be a point of concern. > > I've attached the output of PRAGMA integrity_check; > (which looks pretty bad)... > > I can make the database available if necessary. > > Thanks for any insight. > -Brad > > > ------------------------------------------------------------------------ > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
