Cao Ancoinc wrote:

>
> The following is extracted from the log ...
> Index 10 is corrupt (missing entries) in table ORDTRN (144)
> Index 13 is corrupt (missing entries) in table ORDTRN (144)
> Index 14 is corrupt (missing entries) in table ORDTRN (144)
> Index 15 is corrupt (missing entries) in table ORDTRN (144)
>
> 1. The index name I find in RDB$INDICES using
> RDB$INDEX_NAME ,RDB$RELATION_NAME ,RDB$INDEX_ID
> Am I looking in the right system table to locate the index name?

Yes. Internally, indexes for a table are numbered. YOurlooking for
indexes 10, 13, 14, and 15 for the table ORDTRN.

> 2. Are the entries missing in the index or in ORDTRN?

Present in the table and missing in the index.

> 3. Does (144) mean the number of missing entries

No, it's the number of the error message.

> 4. Any ideas on why this should be happening on the db and how to minimise
> the risk of this happening in the future.

It shouldn't. The next steps are to figure out what entries
are missing, whether the same rows are missing in all indexes,
and what is interesting about those rows. There's a bug lurking
there somewhere, unless you're running with forced writes off
and have just been lucky enough to avoid more serious problems.
Check IBFirstAid from ibsurgeon.com It may give you some more
hints.


Regards,


Ann