Hi all, we work with maxdb V. 7.6.00.34. A job deleting records from a table causes the following messages in knldiag.err:
2007-01-21 07:08:58 0x7C4 ERR 53000 B*TREE IdxOrder.SubNode invalid; 897451 2007-01-21 07:08:58 0x7C4 ERR 3 Admin Database state: OFFLINE 2007-01-21 07:08:58 0x7C4 ERR 2 Admin + A fatal error caused EMERGENCY SHUTDOWN. core is written 2007-01-21 07:08:58 0x7C4 ERR 18196 DBCRASH vabort:Emergency Shutdown, Kernel_Administration.cpp: 612 2007-01-21 07:08:58 0xC20 ERR 19999 BTRACE Using 'imagehlp.dll' version: 4.0.5 2007-01-21 07:08:58 0xC20 ERR 19999 BTRACE SymbolSearchPath: l:\sapdb\indep_data\wrk\OFBIZ;L:\SAPDB\DEPEND\pgm;L:\SAPDB\DEPEND\symbols;L:\SAPDB\DEPEND\symbol 2007-01-21 07:08:58 0xC20 ERR 19999 BTRACE s;L:\SAPDB\DEPEND\sap;C:\WINNT;L:\SAPDB\DEPEND\sap\ 2007-01-21 07:08:58 0xC20 ERR 19999 BTRACE ----> Register Dump <---- 2007-01-21 07:08:58 0xC20 ERR 19999 BTRACE Eax=0x0a72b7fc Ebx=0x00000000 Ecx=0x00000000 Edx=0x00aab864 Esi=0x00000000 Edi=0x7fdedfb8 2007-01-21 07:08:58 0xC20 ERR 19999 BTRACE Eip=0x7c4ea4e1 Esp=0x0a72b7f4 Ebp=0x0a72b84c 2007-01-21 07:08:58 0xC20 ERR 19999 BTRACE Cs=0x001b Ss=0x0023 Ds=0x0023 Es=0x0023 Fs=0x0038 Gs=0x0000 Efl=0x0246 2007-01-21 07:08:58 0xC20 ERR 19999 BTRACE ----> Module List <---- 2007-01-21 07:08:58 0xC20 ERR 19999 BTRACE |.text Start |.text End | Module File Name 2007-01-21 07:08:58 0xC20 ERR 19999 BTRACE | 0x00400000 | 0x00b79000 | L:\SAPDB\DEPEND\pgm\kernel.exe And this is the SQL-Statement: Delete from SERVER_HIT where VISIT_ID in (select VISIT_ID from VISIT where FROM_DATE < subdate(timestamp,60) May be there are indices on this table out of order. If anyone can help, please don't hesitate. Thanks in advance Heinrich
