--- In firebird-support@yahoogroups.com, Vlad Khorsun <hvlad@...> wrote:

>
> >> >> > 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
>

Hi vlad
two errors :

Database: H:\MI4\MI4_2.FDB
Index 1 is corrupt on page 53072 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1648
in table ACC$PREDOC (134)


Database: H:\MI4\MI4_2.FDB
Index 1 has orphan child page at page 51974 in table ACC$PREDOC (133)


what mean (1) and (133)