On Tue, Jun 08, 2010 at 12:32:22PM +0100, Nick Shaw scratched on the wall: > Daniel Stutzbach wrote: > > Are there any other known ways that the database might become corrupt? > > My list of possible causes would be: > 1) File/Disk corruption by the OS. On Windows, this can happen if the > system suffers a power loss in the middle of a write, most noticeable > when you're writing a large amount of data to a file (I realise it > shouldn't happen, but I've seen it a number of times, especially on > embedded XP devices);
In theory, the journal file should protect against this, but that assumes the system flushes and syncs its I/O correctly. I'm not sure I'd trust an embedded XP device to do that, especially on flash storage. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
