Hi,
the error you get from the database structure check means that
you have a corrupted secondary tree (index) which is identified
by the root page number 34659. At least one of the index records
has a corrupted key length. You should check your hardware and after
that drop and re-create the index.
But there is something mysterious about it, because the internal
file name is '030600000000000002CD000000000000'. This means that
the file is an old style (< release 7.4) single index. All these
files should be migrated with the 7.4 calatog migration. Therefore
I suppose that you run in trouble if you want to drop the index.
Do you have the old 7.3 database instance on your computer, so that
you can start it and execute the following query as superdba("dba")?
Select * from roots where root = 34659
The result should be the "external" name of the index. You could take
the index name to drop and re-create it. After that you should create
a new backup for the 7.4/7.5 database migration.
If the old 7.3 database isn't available we have a big problem, because
at this time we have no possibility to drop such unsupported indexes,
i.e. the next steps depends on your answer to my first question (above)!
What is see size of the 7.3 database backup and which kind of OS do you use?
BTW.
With 7.4/7.5 we improve the functionality of check data, so that we check
the database in more detail. I suppose that the index is still corrupted
in 7.3 too!
Regards,
Torsten
SAP Labs Berlin
-----Original Message-----
From: Thorn Roby [mailto:[EMAIL PROTECTED]
Sent: Freitag, 13. Februar 2004 18:56
To: [EMAIL PROTECTED]
Subject: How to repair a corrupted data page?
After performing a migration backup from a 7.3 database to 7.5 (or 7.4)
I get these errors on a Check Database:
2004-02-12 17:41:23 13 ERR 53370 B*TREE Illegal key len length: 123
2004-02-12 17:41:23 13 ERR 53370 B*TREE Corrupted data page: 284
2004-02-12 17:41:23 13 ERR 53000 B*TREE
030600000000000002CD000000000000
2004-02-12 17:41:23 13 ERR 53000 B*TREE ROOT 34659
2004-02-12 17:41:23 13 ERR 53250 B*TREE BAD INDEX 34659 (ROOT)
2004-02-12 17:41:23 12 ERR 53019 CHECK Base error: file_not_accessibl
2004-02-12 17:41:23 12 ERR 53019 CHECK Root pageNo: 34659
2004-02-12 17:48:54 12 ERR 53000 CHECK Check data finished
unsuccessfully
There is no error on a Check Database of the original database.
Is there any way to examine the data page in a useful way? Is it
possible to rewrite it from the content of the original database?
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
