He Georg, please do the following: "dbmcli ... trace_prot akbx" this produces a trace file <DBNAME>.prt
Then please collect for me the following files: knldiag,knldiag.err,knldiag.old,dbm.utl,dbm.knl,dbm.prt,<DBNAME>.prt compress them and email it to me. Thank you Uwe > -----Original Message----- > From: Georg Thome [mailto:[EMAIL PROTECTED] > Sent: Dienstag, 27. Mai 2003 18:24 > To: [EMAIL PROTECTED] > Subject: Re: log restore / kernel > > > I now saw that the two machine have two different kernel versions > 2.4.16-4GB (the Backup-System) and 2.4.20 (the restore-system) > > could it be a reason ? > > > Hi, > > > > i'm trying to make a restore. I've got Sapdb 7.4.3 > installed on a linux > > system with software raid. > > Now I want to make a restore from one database which was on another > > machine but with the same configuration. > > What I did: > > - copied the backupfile and the logbackups to the new maschine > > - there a db already exists with the same devspace sizes > > - I executed "util_execute init config" > > - util_connect user,pwd > > - restore_start data DATA > > - util_release > > - util_connect user,pwd > > - restore_start logs LOG 001 > > ERROR > > > > even if I open a service session > > > service_connect > > > recover_check logs LOG 001 > > ERR > > -24988,ERR_SQL: sql error > > -9209,Message not available > > > > a medium_getall lists following: > > > > >medium_getall > > OK > > data /tmp/data FILE DATA 0 0 NO NO > > 20030527113518 20030527164051 > > logs /tmp/logs/logs FILE LOG 0 0 NO NO > > 20030527130007 20030527170112 > > logs20030525 /tmp/logs/logs20030525 FILE LOG 0 0 > > NO NO 20030527153626 20030527153626 > > > > I really don't know what I'm doing wrong and it is really > urgent. One of > > our guys made drop of all tables and we had a lot of data in it. > > > > TIA > > Georg > > > > I get as a result the knldiag: > > > > > -------------------------------------------------------------- > ------------------ > > > > Date Time TID Typ MsgID Label Message-Text > > > -------------------------------------------------------------- > ------------------ > > > > 2003-05-27 14:14:07 --- Starting > GMT 2003-05-27 > > 12:14:07 7.4.3 Build 017-123-039-277 > > 2003-05-27 14:41:31 1765 ERR 0 SAPDBErr Assertion of state > > Log_RedoReadTask::EndOfTransaction: InsertJob failed failed! > > 2003-05-27 14:41:31 1765 ERR 11196 DBCRASH > vabort:Emergency Shutdown, > > Log_RedoReadTask.cpp: 1128 > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE ----> > Emergency Stack Back > > Trace <---- > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE (0):0x8469b16 > > [0x4567c8d4](0x401dee28,0x4,0x4567c9f8,0x85a0993) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE (1):0x859dca7 > > [0x4567c934](0x401d0001,0x468,0x4567c964,0x859dc2d) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE (2):0x85e39f3 > > [0x4567c964](0x4567c9a0,0x0,0x0,0x4567c99b) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE (3):0x85e121d > > [0x4567c9b4](0x4644a028,0x23,0x4567d298,0x4567c9f8) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE (4):0x85e075e > > [0x4567ca14](0x4644a028,0x4567da48,0x0,0x85df2e2) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE (5):0x85de67f > > [0x4567cd34](0x4644a028,0x4567da48,0x4567cfd4,0x4567d298) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE (6):0x8357fee > > [0x4567d034](0x4644a028,0x4567da48,0x4567d0f4,0x8357aae) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE (7):0x8357d4c > > [0x4567d054](0x4567da48,0x3,0x1,0x4567d0bc) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE (8):0x8357a55 > > [0x4567d0f4](0x4567d144,0x0,0x4567d1b4,0x8357a4c) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE (9):0x8100070 > > [0x4567d1b4](0x4567da48,0x9,0x4567d244,0x85ac89b) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE (10):0x8100531 > > [0x4567d234](0x4567da48,0x9,0x4567d9b4,0x84482fb) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE (11):0x844830a > > [0x4567d264](0x4567da48,0x28,0x867bbc3,0x23) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE (12):0x81004d6 > > [0x4567d9b4](0x4567da48,0x4567d9e8,0x4567d9e4,0x4002b633) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE (13):0x8488862 > > [0x4567daa4](0x5000d2a0,0x401dd7d8,0x401dd7c0,0x40026ff0) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE (14):0x8488f65 > > [0x4567dac4](0x5000d2a0,0x401dd7d8,0x4567daf4,0x8488f3f) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE (15):0x8497c4b > > [0x4567daf4](0x5000d2a0,0x401dd7c0,0x4567db24,0x8497bcb) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE (16):0x40027f37 > > [0x4567db24](0x401dd788,0x0,0x4567dd28,0x40027e60) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE ----> Module List <---- > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE |.text Start > |.text End | > > Module File Name > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE | 0x08048000 | > 0x086ae000 | > > /opt/sapdb/depend/pgm/kernel > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE | 0x40000000 | > 0x40014000 | > > /lib/ld-2.2.4.so > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE | 0x40021000 | > 0x4002f000 | > > /lib/libpthread.so.0 > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE | 0x40037000 | > 0x40039000 | > > /lib/libdl.so.2 > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE | 0x4003b000 | > 0x40075000 | > > /usr/lib/libstdc++-3-libc6.2-2-2.10.0.so > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE | 0x40088000 | > 0x400a9000 | > > /lib/libm.so.6 > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE | 0x400aa000 | > 0x401c5000 | > > /lib/libc.so.6 > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE ----> Symbolic > Stack Back > > Trace <---- > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE 0: > 0x08469b16 vabort > > +0x0016 > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > /opt/sapdb/depend/pgm/kernel > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE Frameinfo > > [0x4567c8d4] (0x401dee28,0x4,0x4567c9f8,0x85a0993) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE 1: 0x0859dca7 > > RTE_Crash__FRC20SAPDBErr_MessageList +0x00f7 > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > /opt/sapdb/depend/pgm/kernel > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE Frameinfo > > [0x4567c934] (0x401d0001,0x468,0x4567c964,0x859dc2d) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE 2: 0x085e39f3 > > > EndOfTransaction__16Log_RedoReadTaskiR22SAPDBMem_IRawAllocator RP15Log_TransactionQ215Log_Transacti > > > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > > on10TransStateGt19SAPDB_Invalidatable2ZUiUim1sb +0x02d3 > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > /opt/sapdb/depend/pgm/kernel > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE Frameinfo > > [0x4567c964] (0x4567c9a0,0x0,0x0,0x4567c99b) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE 3: 0x085e121d > > > CloseOpenTransactions__16Log_RedoReadTaskR18tgg00_TransContext Gt19SAPDB_Invalidatable2ZUiUim1 > > +0x0 > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE 17d > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > /opt/sapdb/depend/pgm/kernel > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE Frameinfo > > [0x4567c9b4] (0x4644a028,0x23,0x4567d298,0x4567c9f8) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE 4: 0x085e075e > > > InternReadLogAndCreateRedoFile__16Log_RedoReadTaskR18tgg00_Tra nsContextR22Log_ArchiveLogIteratorR2 > > > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > > 2SAPDBMem_IRawAllocatorRt19SAPDB_Invalidatable2ZUiUim1b +0x14de > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > /opt/sapdb/depend/pgm/kernel > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE Frameinfo > > [0x4567ca14] (0x4644a028,0x4567da48,0x0,0x85df2e2) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE 5: 0x085de67f > > > ReadLogAndCreateRedoFiles__16Log_RedoReadTaskR18tgg00_TransCon > text +0x036f > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > /opt/sapdb/depend/pgm/kernel > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE Frameinfo > > [0x4567cd34] (0x4644a028,0x4567da48,0x4567cfd4,0x4567d298) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE 6: 0x08357fee > > kb921RedoLogReadTask +0x001a > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > /opt/sapdb/depend/pgm/kernel > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE Frameinfo > > [0x4567d034] (0x4644a028,0x4567da48,0x4567d0f4,0x8357aae) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE 7: 0x08357d4c > > kb92_server +0x02e8 > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > /opt/sapdb/depend/pgm/kernel > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE Frameinfo > > [0x4567d054] (0x4567da48,0x3,0x1,0x4567d0bc) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE 8: 0x08357a55 > > k92server_process +0x0165 > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > /opt/sapdb/depend/pgm/kernel > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE Frameinfo > > [0x4567d0f4] (0x4567d144,0x0,0x4567d1b4,0x8357a4c) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE 9: 0x08100070 > > ak91run_non_user_process +0x01b4 > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > /opt/sapdb/depend/pgm/kernel > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE Frameinfo > > [0x4567d1b4] (0x4567da48,0x9,0x4567d244,0x85ac89b) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE 10: 0x08100531 > > a91mainprogam_with_allocator +0x0041 > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > /opt/sapdb/depend/pgm/kernel > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE Frameinfo > > [0x4567d234] (0x4567da48,0x9,0x4567d9b4,0x84482fb) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE 11: 0x0844830a > > gg941CreateAllocatorAndCallMainprog +0x008a > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > /opt/sapdb/depend/pgm/kernel > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE Frameinfo > > [0x4567d264] (0x4567da48,0x28,0x867bbc3,0x23) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE 12: 0x081004d6 > > a91mainprogram +0x008e > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > /opt/sapdb/depend/pgm/kernel > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE Frameinfo > > [0x4567d9b4] (0x4567da48,0x4567d9e8,0x4567d9e4,0x4002b633) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE 13: 0x08488862 > > en88_CallKernelTaskMain__FP9TASK_TYPE +0x010a > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > /opt/sapdb/depend/pgm/kernel > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE Frameinfo > > [0x4567daa4] (0x5000d2a0,0x401dd7d8,0x401dd7c0,0x40026ff0) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE 14: 0x08488f65 > > en88_RunPthreadTask +0x0035 > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > /opt/sapdb/depend/pgm/kernel > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE Frameinfo > > [0x4567dac4] (0x5000d2a0,0x401dd7d8,0x4567daf4,0x8488f3f) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE 15: 0x08497c4b > > eo07_PthreadEntry +0x00bb > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > /opt/sapdb/depend/pgm/kernel > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE Frameinfo > > [0x4567daf4] (0x5000d2a0,0x401dd7c0,0x4567db24,0x8497bcb) > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE 16: 0x40027f37 > > pthread_start_thread +0x00f7 > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE > /lib/libpthread.so.0 > > 2003-05-27 14:41:31 1765 ERR 11599 BTRACE Frameinfo > > [0x4567db24] (0x401dd788,0x0,0x4567dd28,0x40027e60) > > 2003-05-27 14:41:31 1765 ERR 11196 DBCRASH > vabort:Emergency Shutdown, > > Task: 35 > > > > ****************May the source be with you**************** > > > > This e-mail may contain trade secrets or privileged, undisclosed or > > otherwise confidential information. If you are not the intended > > recipient and have received this e-mail in error, you are hereby > > notified that any review, copying or distribution of it is strictly > > prohibited. Please inform us immediately and destroy the original > > transmittal from your system. Thank you for your co-operation. > > > > _______________________________________________ > > sapdb.general mailing list > > [EMAIL PROTECTED] > > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > ****************May the source be with you**************** > > This e-mail may contain trade secrets or privileged, undisclosed or > otherwise confidential information. If you are not the intended > recipient and have received this e-mail in error, you are hereby > notified that any review, copying or distribution of it is strictly > prohibited. Please inform us immediately and destroy the original > transmittal from your system. Thank you for your co-operation. > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
