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?
Thanks,
/jordan
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
