Subject Re: [firebird-support] Re: Frequently corruption in database
Author Vlad Horsun
> >> in log see some below text (by group remove some)
>
> INET/inet_error: read errno = 10054
> INET/inet_error: select in packet_receive errno = 10038

Something wrong with your network and\or client applications

> (Server) Sun Jul 15 20:12:54 2007
> Database: MI4
> Relation has 2 orphan backversions (6 in use) in table
> RDB$TRIGGERS (12)

You often do modify triggers and it seems you server was
crushed during garbage collection. Anyway this error is minor and
have no impact on database operations

> (Server) Sun Jul 15 20:12:56 2007
> Database: MI4
> Index 2 is corrupt on page 13105 level 1.
> File: ..\..\..\src\jrd\validation.cpp, line: 1658
> in table ACC$PREDOC (214)

> (Server) Sun Jul 15 20:12:56 2007
> Database: MI4
> Index 2 is corrupt on page 13105 level 1.
> File: ..\..\..\src\jrd\validation.cpp, line: 1648
> in table ACC$PREDOC (214)

> FARAPOX-BASESER (Server) Sun Jul 15 20:12:56 2007
> Database: MI4
> Index 2 is corrupt on page 13105 level 1.
> File: ..\..\..\src\jrd\validation.cpp, line: 1658
> in table ACC$PREDOC (214)

Errors above also minor and was fixed recently (in upcoming
FB 2.0.2 and FB 2.1 beta 2)

> (Server) Wed Jul 18 18:55:01 2007
> Database: E:\MIS\MI4_1.FDB
> Index 2 has orphan child page at page 1567 in table
> ACC$PREDOC (217)

Again nothing serious

> (Server) Wed Jul 18 18:55:01 2007
> Database: E:\MIS\MI4_1.FDB
> Pointer page (sequence 0) lost in table (275)

This one is really bad. Your table 275 completely unusable.
Does you have FW == OFF ?

Regards,
Vlad