SYSERROR -9008 BD Illegal record

89 Views

Performing a database structure check result in an error message:

2009-02-24 18:54:33 0x106C 53022 B*TREE Check Table: 5602 (Root)

2009-02-24 18:54:33 0x106C 53022 B*TREE Check Table: 81004 (Root)

2009-02-24 18:54:51 0x106C ERR 53370 B*TREE Sum record len <> bottom: 8180

2009-02-24 18:54:51 0x106C ERR 53370 B*TREE Corrupted data page: 20278

2009-02-24 18:54:51 0x106C ERR 53272 B*TREE Parent data pageNo: 2521

2009-02-24 18:54:51 0x106C ERR 53000 B*TREE 0D000000000000001C2C000000000000

2009-02-24 18:54:51 0x106C ERR 53000 B*TREE Table Root 2085

2009-02-24 18:54:51 0x1690 ERR 53019 CHECK Base error: illegal_record

2009-02-24 18:54:51 0x1690 ERR 53019 CHECK Root pageNo: 2085

2009-02-24 18:54:51 0x106C 53022 B*TREE Check Table: 15180 (Root)

...

How can we identify and repair the illegal record?

select * from roots where root in ( 2085, 2521 81004)

returns anything.

Up to now we have no problems with this. Database works fine.

The problem seems to exist already some time, because the backups we checked

also seem to have this problem.

(Version is now 7.6.06 - but the error is already in the backups taken with the previous release)

Any help appreciated,

regards

Bernhard Schiefer