I have an SQLite 3 database for which the "pragma integrity check" returns:
integrity_check *** in database main *** On tree page 17 cell 0: 2nd reference to page 164 Page 50 is never used Page 53 is never used Page 57 is never used Page 58 is never used Page 59 is never used Page 60 is never used ...long list of similar rows... Page 202 is never used Page 203 is never used Page 204 is never used Page 205 is never used ok The final word says "OK", so it seems the database is not corrupt, but what do the previous lines mean ? Despite the "OK", is there something wrong in my DB ? Will the unused pages listed in the output be automatically reused in the future ? Should I take some action to recover the database ? I'm using Sqlite 3.2.7 on a Windows platform. Can anybody help ? Thanks, bye
