Subject Frequntly "index page error"
Author mnavahan
Hi All

i have one database develop it over 4 years old long ...
from two years ago to now i frequntly have index page error in validation only for one table ass$predoc (i have over 450 active tale in this case)
only backup restore resolve my problem but after 1 to 6 days period see this again !

in firebird log :

COMPUTER1 Wed Apr 29 20:04:06 2009
Database: MI4
Index 1 is corrupt on page 41733 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1648
in table ACC$PREDOC (130)



note always this problem only one table : ACC$PREDO

maximum number of user : 45

my server : firebird 2.1.2 classic server
page size : 4096
buffers : 8192 : 32768 KB
sweep interval :0
ods ver : 11.1
forced write : yes
all other configuration is default !

HW: dual xeon 5130 in 4 SAS raid Hard
Ram : 6GB
power : we have good ups then np power fail !
win : win2003 ent.



i dont understand why this error occurs
the firebird is really stable ?
have any way trace this type of error ?
how reolsve this for ever ?