Subject | Re: [firebird-support] Re: FB2.1 frequently Index corruption in DB |
---|---|
Author | Vlad Khorsun |
Post date | 2009-05-25T08:52:12Z |
>> >> > how resolve this problem ?It is imposible. With *any* DBMS\OS.
>> >>
>> >> 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
> first i can understand what table BUT i have multiple index for thisYou have index id in error mesage. Query RDB$INDICES for index name
> table then can not understand what index(s) of this table have problem...
> 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