Hello Michael, "bad fbm" oder "bad page" errors usually tell you that you have disk or controller problems. The backtrace tells you that your log volume is inconsistent/destroyed too which might have the same reason. In this case you can only recover an older data backup and recover your log backups. Of course after you have eliminated your hardware problems.
The bad indexes have probably nothing to do with the serious problems above. Indexes are set to bad if they are re-created during redo/restart if something aborted the database kernel before. Kind regards Uwe >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Sunday, October 30, 2005 11:05 AM >To: maxdb@lists.mysql.com >Subject: SapDB 7.4.3. Bad Indexes in System Tables > >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] > >
smime.p7s
Description: S/MIME cryptographic signature
