Hi, don't be afraid about the following knldiag output: > 43 Converte The dynamic data pageno 119093 on block 1/5899 is deleted. <
This means that the permanent page number 119093 on data volume 1 on offset 5899 was removed from the converter and could be used in the future, because the page number isn't used anymore. This situation could happen if a drop table or drop index terminates with an error, for example "-9026 Bad Data Page". Regards, Torsten SAP DB, SAP Labs Berlin -----Original Message----- From: Thorn Roby [mailto:[EMAIL PROTECTED] Sent: Dienstag, 17. Februar 2004 01:51 To: Strahl, Torsten; [EMAIL PROTECTED] Subject: Re: How to repair a corrupted data page? Strahl, Torsten wrote: >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? > > > Thanks for your response. Dropping and recreating the index on the 7.3 system, followed by a migration backup, results in a successful restore to the 7.5 system. Both are Solaris SPARC systems. The database size is 1.2 GB. However, before the "Check Successful" message in the log I get hundreds of messages like this which I haven't seen before: 43 Converte The dynamic data pageno 119093 on block 1/5899 is deleted. Is this OK? -- 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]
