On 6 Oct 2009, at 6:19pm, Reusche, Andrew wrote: > We experienced another "corruption" issue with the DB. Details below. > When we tried to write to this DB, we received the "malformed image" > error. Sorry I don't have the exact text. We have now received 4 > problems with the database in 1000 installs since early July.
You mean you have installations at 1000 sites ? Were the four failures all for the same site ? Can you list all the PRAGMAs your software uses -- in other words everything you do besides allow SQLite to use default settings for everything. > The > installs each reboot 2-3 times per day, and run every single day. Can I ask the reason for the frequent reboots ? Are the computers properly shut-down for the reboots or might they be rebooted when they're in the middle of something ? > Is > this the typical failure rate you would expect to see? The typical failure rate for calls to the SQLite library is zero. SQLite is an integral part of Mac OS X, every iPhone, every copy of Acrobat Reader, FireFox, McAfee anti-virus software and Skype. If there was a widespread corruption problem in SQLite databases, someone would probably have asked about it here. You may have a hardware problem, or a problem with some other level of your installation besides SQLite. For instance, hard disk firmware, or the OS, or faulty RAM. Obivously, it's not possible to prove this. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
