 | | | A fatal error caused EMERGENCY SHUTDOWN | A fatal error caused EMERGENCY SHUTDOWN 2007-01-26 - By P?tzold Heinrich
Back
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
|
|
|