Dne 14.06.2010 10:05, Maya Opperman napsal(a):

>
> Hi Ann,
>
> >> It has happened at a few of our sites. We mostly pick it up at year
> end,
> >> since the system does not allow you to proceed to the new year, if it
> >> thinks there is an imbalance.
>
> >That's not good. Are you actually backing up and restoring on every
> >night, or was the original problem that when you found a problem,
> >you couldn't fix it overnight?
>
> At the sites where we know it is a regular problem, we now get them to
> do a backup-restore once a week. They are retail stores, so they use the
> system every day, including Saturday.
>
> >Are there any unusual characteristics of the bad indexes - e.g.
> >single key, compound, ascending/descending, unique? Key types -
> >character, number?
>
> This is the result of running a DB validation:
>
> Summary of validation errors
>
> Number of index page errors : 477
>
> IBE: Validation completed.
>
> How do I see what those 477 indexes are?
>

It's not necessarily 477 different indexes but "only" 477 index pages.
That pages can belong to just 1 index. Check Firebird.log for more
details. I guess the name of an index that page belongs to is mentioned
there.

Milan


[Non-text portions of this message have been removed]