Thank you. After running VACUUM, "pragma integrity check" now simply returns "OK" (although some of the data in the DB appears to be corrupt).
Anyway it was just a test database and no important information was lost, I posted my message just to learn about the odd output from "pragma integrity check". Bye -----Messaggio originale----- Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Inviato: mercoledì 18 gennaio 2006 12.50 A: [email protected] Oggetto: Re: [sqlite] Is this SQLite database corrupted or not ? Zibetti Paolo <[EMAIL PROTECTED]> wrote: > 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 ? > You database is corrupt, but if all you see is "page never used" messages, a VACUUM will likely recover it. The extra "ok" a the end looks like a bug in the integrity_check pragma. -- D. Richard Hipp <[EMAIL PROTECTED]>
