Subject Re: [firebird-support] Re: FB2.1 frequently Index corruption in DB
Author Vlad Khorsun
>> >> > how resolve this problem ?
>> >>
>> >> Rebuild the corresponding index
>>
>> > No any help : can comment me do it when some user work with this table ?
>>
>> ALTER INDEX ... ACTIVE; COMMIT;
>>
>> While index is builds users can read from table but can't modify it

>> PS Do you want to say that your database works in 24x7 mode ?
>>
> Hi vlad
>
>
> YES , Absolutely 24X7 , DB

It is imposible. With *any* DBMS\OS.

> first i can understand what table BUT i have multiple index for this
> table then can not understand what index(s) of this table have problem...

You have index id in error mesage. Query RDB$INDICES for index name

> then how use ALTER INDEX ... ACTIVE; COMMIT ?

Does you read any docs ? After obtaining index name run isql, attach to your
database and issue statement

ALTER INDEX <index name> ACTIVE;

it will rebuild the index.

Regards,
Vlad