Subject Re: FB2.1 frequently Index corruption in
Author mnavahan
--- In firebird-support@yahoogroups.com, "Vlad Khorsun" <hvlad@...> wrote:
>
> >>> 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)
> >>
> >> Index ID and relation ID
> >
> > Different IDs for table ACC$PREDOC (133 and 134) look very suspicious
> > to me. May be the author often drop and recreate the table?..
>
> After recreate relation can't obtain id less that was before...
>
> Regards,
> Vlad
>


Hi vlad

absolutely YES do it and after it have error
in one *hardline* work three month ago i remove dependency to this table first drop it and recreate it & load all data from script
to table *no any change* in problem


best regards