"Kalle Klovn" <[EMAIL PROTECTED]> wrote: > Yesterday I received the > SQLITE_CORRUPT error message. This happened on a test system so it is not > that bad, but I am now very nervous about this happening in my production > system. Is this a common problem with sqlite?
I get very few reports of database corruption and SQLite is widely deployed. So, no, this is not a common problem. There is a bug in version 3.2.1 that can cause corruption if you try to vacuum a database that is larger than 1GiB and the vacuum fails, for example due to a power failure. You should upgrade to 3.3.8 if you can. Other causes of database corruption are listed at http://www.sqlite.org/lockingv3.html under the heading "6.0 How To Corrupt Your Database Files". -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
