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
