Hello, the command "select * from domain.show_bad_index" shows me one index as bad.
Trying to recreate the index with "sql_recreateindex" the database crashes with following output in knldiag.err: ... 2003-10-30 12:13:11 31554 ERR 53326 B*TREE Illegal Entry Pos: 79 2003-10-30 12:13:11 31554 ERR 53000 B*TREE CurrRecIndex:: 6 2003-10-30 12:13:11 31554 ERR 53000 B*TREE bd600Check: 174051 2003-10-30 12:13:11 31554 ERR 53000 B*TREE Action Code: 24 2003-10-30 12:13:11 31554 ERR 53000 B*TREE bd600Check; 174051 2003-10-30 12:13:12 31554 ERR 11599 BTRACE ----> Emergency Stack Back Trace <-- ... 2003-10-30 12:13:12 31554 ERR 11196 DBCRASH vabort:Emergency Shutdown, Task: 30 Switching the database to "cold" state works, but trying to "warm" the database, the database crashes with the same error. After migrating from 7.3.0.29 to 7.4.3.27 and trying to recreate the index same happens. Verifying the database with 7.4.3.27 gives the following output: ... 2003-11-05 08:01:04 3283 ERR 53019 CHECK BASE ERROR: file_not_accessibl 2003-11-05 08:01:04 3283 ERR 53019 CHECK ROOT PAGE NO: 174051 ... Any hint? Regards Rainer -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
