Detecting corrupted index

[jda]

Hi Ruslan,

I have found that my databases using an older version of Valentina 
(don't remember which, 3.x) often have problems develop with the 
index (it's a very large index). I'm using diagnose to detect 
problems, and when it comes back positive I suggest the use repair 
(clone) the database, which is kind of a pain.

If I could detect that only the index was the problem I could just 
force a reindex and the user wouldn't be aware that there ever was a 
problem. The question is, how to do this?

I could have Valentina write the diagnose report to a temporary file 
and read the file. But I'd have to be sure that the *only* thing 
wrong was an index problem. I would prefer that this be automatic 
(e.g. a diagnose that didn't give back a text file in English, but 
rather something more machine friendly), but since that's not 
possible, what you you, or anyone, recommend? What should I look for 
in the text of this file that would tell me:

1. The db is OK *except*
2. There is some problem with one or more indexes (so Reindex).

Jon