[sqlite] What does output from integrity check mean and how can I prevent this?

2015-12-21 Thread Simon Slavin
On 21 Dec 2015, at 5:04am, Andy KU7T wrote: > How could this be happening? Disk failure, power failure, etc? Those things seem the most likely in the circumstances but there are some other possibilities: > How can this be detected at run time (can

[sqlite] What does output from integrity check mean and how can I prevent this?

2015-12-21 Thread Andy KU7T
Hi, Using sqlite dbs for my program (official .NET sqlite.interop.dll, v. 1.0.92.0). Have not had any db integrity issues until today. One user send me a db, I ran Sqlite Expert professionals's integrity checker and got this: *** in database main *** On tree page 2 cell 14: 2nd reference to