Could you please do the following with dbmcli
db_cold
trace_on DEFAULT
util_connect
util_execute diagnose check pages on
db_warm
=> it should crash now as you described
trace_prot akbx
=> Please send me the following files from rundirectory in compressed form
knldiag, <YOUR DB NAME>.prt, dbm.utl, dm.prt
kind regards
Uwe
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Mittwoch, 5. November 2003 08:03
> To: [EMAIL PROTECTED]
> Subject: URGENT!! Recreating a bad index crashes the data base
>
>
> 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]
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
