Jordan Hayes wrote: > I had a power failure yesterday and an active database of mine is now > trashed. The output of "pragma integrity_check" includes lots of > > rowid NNNN missing from index MyIndexName > > and > > wrong # of entries in index OtherIndexName > > messages. > > Plus this: > > On tree page 4 cell 17: 2nd reference > On tree page 4 cell 17: Child page depth differs > On tree page 4 cell 18: Child page depth differs > > Is there something simple I can do to fix this? It seems like it would > be useful to have a command that would drop-and-regenerate an index; I > looked in the documentation and couldn't find one. So I dropped them by > hand and rebuilt them and now all those errors go away, but I'm still > left with the last three. > > Am I just out of luck? >
I'm curious how you got to this point. If the power failed during a transaction there should have been a rollback journal file beside the database file which the sqlite library would discover and use to undo all the changes in the partially complete transaction the next time that database was opened. Did you perhaps delete the journal file before starting sqlite or your application after the power failure? I'm sorry I can't help you with recovering your database, except to suggest going back to your last backup, and redoing the changes since then. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
