Hello Readers, I'm having problems with SapDB 7.4.3. I found out that all recent backups were aborted with "Bad FBM" and "Bad Page" errors. There are also 5 Bad Indexes in the DBMGUI, but I was unaible to repair them via the DBMGUI.
The following Indexes were listed as "Bad Indexes": WA_INODE_INDEX_1 WEBDAV_PROPERTY_X1 XML_DOCUMENTCLASS_1 WA_INODE_INDEX_2 WEBDAV_PROPERTY_X2 The database crashed, and now I can't get it back online. When I try to get it back online the kernel crashes: 2005-10-30 10:40:44 --- Starting GMT 2005-10-30 09:40:44 7.4.3 Build 032-121-068-842 2005-10-30 10:40:55 3321 ERR 22 Log OldestNotSaved not found on log 2005-10-30 10:40:55 3321 ERR 67 Log RestartArchiveLog: InconsistentLogInfoPage 2005-10-30 10:40:55 3321 ERR 11196 DBCRASH vabort:Emergency Shutdown, vkb560.cpp: 591 2005-10-30 10:40:55 3321 ERR 11599 BTRACE ----> Emergency Stack Back Trace <---- 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (0):0x8491782 [0x45a5bc2c](0x0,0x0,0x5000000c,0x0) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (2):0x8495709 [0x45a5bc4c](0x402356a0,0x0,0x87e4f00,0x8583e9d) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (4):0x85d5977 [0x45a5bc7c](0x40230001,0x24f,0x45a5bcac,0x85d58fd) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (6):0x832519c [0x45a5bcac](0x45a5bcd8,0x0,0x0,0x8) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (8):0x8361b36 [0x45a5bcec](0x25,0x45a6355e,0x45a5bd7c,0x8459c5c) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (10):0x82eff6a [0x45a5bdbc](0x45a6353c,0x475e5924,0x475e592c,0xffffffff) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (12):0x811c5c5 [0x45a5be0c](0x45a628e0,0x45a626ac,0x45a5be6c,0x811c4cb) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (14):0x819b93f [0x45a5be3c](0x45a626ac,0x45a5be6a,0x45a5ff10,0x45a6299b) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (16):0x8199798 [0x45a5be6c](0x45a626ac,0x34,0x0,0x8896500) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (18):0x819a776 [0x45a5be9c](0x45a626ac,0x45a5ff10,0x45a6008c,0x0) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (20):0x820bcd6 [0x45a600bc](0x45a626ac,0x45a600fc,0x45a600ef,0x45a600fc) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (22):0x82ceb6f [0x45a6010c](0x45a626ac,0x45a6014a,0x45a6013c,0x84aaf64) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (24):0x82ceed1 [0x45a601ac](0x45a626ac,0x46eff098,0x45a6353c,0x0) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (26):0x82cf48f [0x45a601dc](0x45a626ac,0x0,0x45a622a2,0x45a60223) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (28):0x810521b [0x45a6226c](0x45a626ac,0x45a622a2,0x45a622a2,0x45a622a3) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (30):0x8105581 [0x45a63ccc](0x45a63e0c,0x1,0x4020faac,0x4020f628) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (32):0x84732d0 [0x45a63cfc](0x45a63e0c,0x2,0xffffffff,0x25) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (34):0x8105532 [0x45a63d7c](0x45a63e0c,0x45a63dac,0x45a63dcc,0x84ab478) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (36):0x84b4a74 [0x45a63e6c](0x50017304,0x4020cc28,0x4020cc10,0x45a63e90) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (38):0x84b513d [0x45a63e8c](0x50017304,0x4020cc10,0x45a63ebc,0x84b5117) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (40):0x84c403b [0x45a63ebc](0x50017304,0x4020cc10,0x45a63eec,0x84c3fbb) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE (42):0x40028e31 [0x45a63eec](0x4020cbd8,0x0,0x88d20d8,0x0) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE ----> Module List <---- 2005-10-30 10:40:55 3321 ERR 11599 BTRACE |.text Start |.text End | Module File Name 2005-10-30 10:40:55 3321 ERR 11599 BTRACE | 0x08048000 | 0x086f4000 | /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE | 0x40000000 | 0x40016000 | /lib/ld-2.3.3.so 2005-10-30 10:40:55 3321 ERR 11599 BTRACE | 0x40023000 | 0x40031000 | /lib/i686/libpthread.so.0 2005-10-30 10:40:55 3321 ERR 11599 BTRACE | 0x40076000 | 0x40078000 | /lib/libdl.so.2 2005-10-30 10:40:55 3321 ERR 11599 BTRACE | 0x4007a000 | 0x400b4000 | /usr/lib/libstdc++-3-libc6.2-2-2.10.0.so 2005-10-30 10:40:55 3321 ERR 11599 BTRACE | 0x400c7000 | 0x400e8000 | /lib/i686/libm.so.6 2005-10-30 10:40:55 3321 ERR 11599 BTRACE | 0x400ea000 | 0x401f8000 | /lib/i686/libc.so.6 2005-10-30 10:40:55 3321 ERR 11599 BTRACE | 0x401f8000 | 0x401f9000 | /lib/i686/libc.so.6 2005-10-30 10:40:55 3321 ERR 11599 BTRACE | 0x4030c000 | 0x40314000 | /lib/libnss_files.so.2 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 2005-10-30 10:40:55 3321 ERR 11599 BTRACE ----> Symbolic Stack Back Trace <---- 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 0: 0x08491782 eo670_CTraceStack +0x0012 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a5bc2c] (0x0,0x0,0x5000000c,0x0) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 1: 0x08495709 vabort +0x0019 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a5bc4c] (0x402356a0,0x0,0x87e4f00,0x8583e9d) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 2: 0x085d5977 RTE_Crash__FRC20SAPDBErr_MessageList +0x00f7 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a5bc7c] (0x40230001,0x24f,0x45a5bcac,0x85d58fd) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 3: 0x0832519c kb560InitLogForRestart +0x014c 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a5bcac] (0x45a5bcd8,0x0,0x0,0x8) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 4: 0x08361b36 k81local_restart +0x0236 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a5bcec] (0x25,0x45a6355e,0x45a5bd7c,0x8459c5c) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 5: 0x082eff6a k05cold_functions +0x01ba 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a5bdbc] (0x45a6353c,0x475e5924,0x475e592c,0xffffffff) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 6: 0x0811c5c5 a06_c_send_mess_buf +0x0061 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a5be0c] (0x45a628e0,0x45a626ac,0x45a5be6c,0x811c4cb) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 7: 0x0819b93f ak36send_mess_buf_cold +0x0017 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a5be3c] (0x45a626ac,0x45a5be6a,0x45a5ff10,0x45a6299b) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 8: 0x08199798 ak36restart +0x0130 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a5be6c] (0x45a626ac,0x34,0x0,0x8896500) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 9: 0x0819a776 a36_call_semantic +0x038e 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a5be9c] (0x45a626ac,0x45a5ff10,0x45a6008c,0x0) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 10: 0x0820bcd6 a30_init_utility +0x03a6 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a600bc] (0x45a626ac,0x45a600fc,0x45a600ef,0x45a600fc) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 11: 0x082ceb6f ak94utility +0x027f 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a6010c] (0x45a626ac,0x45a6014a,0x45a6013c,0x84aaf64) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 12: 0x082ceed1 ak94one_command +0x00d1 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a601ac] (0x45a626ac,0x46eff098,0x45a6353c,0x0) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 13: 0x082cf48f a94_service_commands +0x0237 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a601dc] (0x45a626ac,0x0,0x45a622a2,0x45a60223) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 14: 0x0810521b ak91run_user_process +0x011f 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a6226c] (0x45a626ac,0x45a622a2,0x45a622a2,0x45a622a3) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 15: 0x08105581 a91mainprogam_with_allocator +0x0035 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a63ccc] (0x45a63e0c,0x1,0x4020faac,0x4020f628) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 16: 0x084732d0 gg941CreateAllocatorAndCallMainprog +0x01c0 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a63cfc] (0x45a63e0c,0x2,0xffffffff,0x25) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 17: 0x08105532 a91mainprogram +0x008e 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a63d7c] (0x45a63e0c,0x45a63dac,0x45a63dcc,0x84ab478) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 18: 0x084b4a74 en88_CallKernelTaskMain__FP9TASK_TYPE +0x0148 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a63e6c] (0x50017304,0x4020cc28,0x4020cc10,0x45a63e90) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE 19: 0x084b513d en88_RunPthreadTask +0x0035 2005-10-30 10:40:55 3321 ERR 11599 BTRACE /opt/sapdb/depend/pgm/kernel 2005-10-30 10:40:55 3321 ERR 11599 BTRACE Frameinfo [0x45a63e8c] (0x50017304,0x4020cc10,0x45a63ebc,0x84b5117) 2005-10-30 10:40:55 3321 ERR 11599 BTRACE ----> End of Stack Back Trace <---- 2005-10-30 10:40:55 3321 ERR 11196 DBCRASH vabort:Emergency Shutdown, Task: 37 Any ideas on how to get the database back online or to recover the data? Is there a way to force a backup without checking for bad pages? Kind regards, Michael -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
