Yes, it turns out that synchronous=OFF was set, AND the machine/OS is crashing daily. Not a good combination. Will correct the synchronous setting.
Thanks Doug > > From: [EMAIL PROTECTED] > Date: 2007/04/09 Mon AM 11:52:17 EDT > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Possible database corruption? > > <[EMAIL PROTECTED]> wrote: > > > > I'm _guessing_ this is a file corruption issue (trying to find > > out if there was a power outage, etc). I _think_ (still verifying) > > that "PRAGMA synchronous = OFF;" was set, so if it is corrupted, > > I'll have to accept that it was my fault. > > > > Is there anything I can do to fix this or prevent it (other than > > changing PRAGMA synchronous) in the future? > > > > If you have synchronous=OFF and you lose power during or > shortly after a commit, your database will get corrupted. > Why? Because some but not all of the changes you made will > have made it to the disk while others where still lingering > in the operating systems write cache. > > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
