I was able to access a computer which encountered these errors, about 10 minutes after they occurred. I ran "PRAGMA integrity_check" and it returned "ok". How/why would this have changed? I verified the user did not re-install our app or otherwise reconfigure the database.
Justin Esplin Applications Dev II Verisk Insurance Solutions - Xactware Phone: +1.801.932.8039 jlesp...@verisk.com http://www.verisk.com/insurance/ -----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Friday, September 15, 2017 4:43 AM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Cc: Sines, Matt <mwsi...@verisk.com> Subject: Re: [sqlite] Figuring out the Cause of SQLite Error 11: Corrupt Database On 9/14/17, Esplin, Justin <jlesp...@verisk.com> wrote: > > We are seeing a couple worrisome (and not very informative) messages > repeatedly in our logs: > > SQLite error (11): database corruption at line 55472 of > [cf538e2783] > > SQLite error (11): database corruption at line 55514 of [cf538e2783] > > I have been looking around the web for a few days to try and figure > out how to diagnose this, but have come up empty-handed. This is > occurring on various Windows machines, though they appear to > functional normally before, during and after these errors are written > to the logs. It was by chance that we stumbled across these errors in the > logs. > > Is there a way to know what the lines are that the error messages are > complaining about? Is there a chance that the corruption is of a > nominal variety or that it is able to automatically recover, which is > why it appears to continue to function normally? Both errors are badly formatted b-tree pages in the database file. These both indicate serious database corruption. You should be able to verify the corruption by running "PRAGMA quick_check". Is the database file located on a network filesystem? -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=birp9sjcGzT9DCP3EIAtLA&r=e6PxbQq9NdAJUZWHeJFpfhuVEDXWOo3XEghP1Z1arEs&m=mnCE15jLM9kRb8KAQTx351Gp9e63RWkXHyD_lTNVZnQ&s=xcQp6UKYF6Nj3TZlT_tEqPNPSLmPlX3WUZ0wtKyEvzc&e= ________________________________ This email is intended solely for the recipient. It may contain privileged, proprietary or confidential information or material. If you are not the intended recipient, please delete this email and any attachments and notify the sender of the error. ________________________________ Xactware's opt-in mailing list allows you to receive Xactware News that is of interest to you. Visit my.xactware.com today to join or to update your email preferences! _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
