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: maxdb@lists.mysql.com > 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]
