Re: log restore / kernel

Georg Thome Tue, 27 May 2003 09:28:30 -0700

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_IRawAllocatorRP15Log_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_TransContextGt19SAPDB_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_TransContextR22Log_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_TransContext +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

Re: log restore / kernel

Reply via email to