RE: A fatal error caused EMERGENCY SHUTDOWN

Hi,

may we ask for the trace back, usually to be found below the lines you sent out of the knldiag?

Elke
SAP Labs Berlin 

> -----Original Message-----
> From: Pätzold Heinrich 
> [mailto:[email protected]] 
> Sent: Freitag, 26. Januar 2007 11:14
> To: [email protected]
> Subject: A fatal error caused EMERGENCY SHUTDOWN
> 
> 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\DEP
END\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
> 
> 
> 
> 

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]