A fatal error caused EMERGENCY SHUTDOWN

Pätzold Heinrich <[email protected]>
Newsgroups gmane.comp.db.maxdb
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.