Subject Re: [firebird-support] Validation Issues - What do they mean, and how do I fix them?
Author Vlad Khorsun
> Upon doing a validation on my database using GFix thur Database Workbench it
> return these errors:
>
> Summary of validation errors
>
> Number of index page error : 5
>
> Check the server log file for details.
>
> So I checked the firebird.log and found the following. I can tell I have
> index issues on certain tables.
>
> 1) Can anyone tell me how to read these errors and what I need to do to fix
> them (Hopefully without losing any data)?

Just rebuild corresponding indices. Be ready that some of corrupted indices
will not be activated - if they are unique and data have duplicates. In later case
you need first remove duplicates and then rebuild index again.

> 2) Will a deactive/reactive index fix this issue?

Yes

> 3) Is there a way to reindex or rebuild these tables. If so how?

ALTER INDEX <index_name> ACTIVE and COMMIT

Run gfix -v -f again after index rebuild

Regards,
Vlad