Subject Re: Index corrupt
Author hanszorn2000
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 07:18 PM 27/08/2007, Hans wrote:
> >In one of my databases I get this message (after a gfix):
> >'Index 7 is corrupt on page 354716 in table...'
> >Now in my (still existing) optimism I suppose this could be cured by
> >dropping the index and recreating it. I can not find anything about
> >this anywhere... Am I right here?
> >
> >And if this is the case, how do I find 'index 7'? Normally, indexes
> >are referred to by names, constraints etc, is there a translation to
> >these?
>
> As to the stupidity or otherwise of such a message emitting from a
> utility that's meant to help you, you're welcome to judge for
> yourself. If you tell me what version of Firebird you're using I'll
> post a bug report in the tracker...or you could do it yourself if
you prefer.
>
> ./heLen
>

Helen,

The version of Firebird here is 1.5, or WI-V6.3.3.4870 Firebird 1.5 to
be more specific. I would appreciate it if you would post a bug report
about this, thanks.

In the meantime, can you give me a reassuring answer to the first part
of my posting: can I get rid of these problems by re-creating indexes,
supposing I know which one?

Hans