As you can see, this time another assertion let's the kernel stop.
This time it says:
2005-04-28 17:52:17 9016 ERR 0 SAPDBErr Assertion of state redo begin not
found (look into vtrace) failed!
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
In combination with the line above:
2005-04-28 17:52:17 11191 ERR 11000 asynclos tape open error
(/mnt/grmpf/sdb-logs/log.084) for rewind: Permission denied
I would recommend to check the permissions of the file and the running database
process.
In addition you could do what is suggested in round brackets - look into vtrace.
"Dbmcli ... trace_prot akbx" > creates a file <DBNAME>.prt. You could send me
this file and the files dbm.prt,dbm.utl so that we can see if the recovery was
basically correct.
Kind regards
Uwe
>-----Original Message-----
>From: Raimund Jacob [mailto:[EMAIL PROTECTED]
>Sent: Thursday, April 28, 2005 5:59 PM
>To: Brunzema, Martin
>Cc: [email protected]
>Subject: 1133929 again: crash during log recovery
>
>Raimund Jacob wrote:
>
>hello Martin, hello list,
>
>i was waiting for a resolution of this one:
>
>http://www.sapdb.org/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1133929
>
>and it seemed that it happened with 7.5.0.26. i just installed it and
>wanted to continue my log recovery as the crash left it 2 months ago.
>
>sadly. it still does not work. the stack trace looks nearly
>the same but
>the source file line number changed from 322 to 245.
>
>---8<---
>2005-04-28 17:51:58 --- Starting GMT
>2005-04-28
>15:51:58 7.5.0 Build 026-121-094-430
>2005-04-28 17:52:17 11191 ERR 11000 asynclos tape open error
>(/mnt/grmpf/sdb-logs/log.084) for rewind: Permission denied
>2005-04-28 17:52:17 9016 ERR 0 SAPDBErr Assertion of state redo
>begin not found (look into vtrace) failed!
>2005-04-28 17:52:17 9016 ERR 11196 DBCRASH vabort:Emergency
>Shutdown,
>Rst_RedoReadTask.cpp: 245
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE ----> Emergency
>Stack Back
>Trace <----
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE (0):0x878b2ca
>[0x6012c630](0x0,0x0,0x1,0x878b2b8)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE (2):0x87a97bd
>[0x6012c660](0x8af21dc,0x8938160,0x8938182,0x6012c688)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE (4):0x87153c3
>[0x6012c690](0x40240001,0xf5,0x6012c6d0,0x8715346)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE (6):0x86d7e81
>[0x6012c6d0](0x6012cad4,0x0,0x0,0x86d79cc)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE (8):0x86d6d42
>[0x6012cb30](0x60145658,0x6012cf14,0x63701028,0x6014588c)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE (10):0x86d6bec
>[0x6012cba0](0x60145658,0x6012cf14,0x10,0x86d6bc4)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE (12):0x86d2183
>[0x6012cbd0](0x8b5bc0c,0x6012cf14,0x2,0x86d2168)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE (14):0x84081d1
>[0x6012cc00](0x8b5bb80,0x6012cf14,0x6012cd18,0x84081b5)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE (16):0x8407f31
>[0x6012cc30](0x6012cf14,0x3,0x1,0x6012cc98)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE (18):0x84079f1
>[0x6012ccd0](0x6012cd20,0x0,0x6012cda0,0x84079e5)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE (20):0x813ce59
>[0x6012cda0](0x6012cf14,0x9,0x6012cecc,0x813cc9e)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE (22):0x813d381
>[0x6012ce20](0x6012cf14,0x9,0x4022eba4,0x813d341)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE (24):0x8531a69
>[0x6012ce50](0x6012cf14,0x2,0xffffffff,0x25)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE (26):0x813d318
>[0x6012cee0](0x6012cf14,0x0,0x0,0x813d2ec)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE (28):0x87cd772
>[0x6012cf80](0x8af21dc,0x40224350,0x87cdc70,0x87cdc70)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE (30):0x87cdc9e
>[0x6012cfb0](0x500143f0,0x8ba8520,0x0,0x0)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE (32):0x401382a4
>[0x6012cff0](0x879568a,0x0,0x0,0x0)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE ----> Module List <----
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE |.text Start
>|.text End |
>Module File Name
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE | 0x08048000 |
>0x0895b000 |
>/opt/sapdb/depend75/pgm/kernel
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE | 0x40000000 |
>0x40016000 |
>/lib/ld-2.3.3.so
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE | 0x4002a000 |
>0x40038000 |
>/lib/i686/libpthread.so.0
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE | 0x4007b000 |
>0x4007d000 |
>/lib/libdl.so.2
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE | 0x4007f000 |
>0x40086000 |
>/lib/librt.so.1
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE | 0x40092000 |
>0x400cc000 |
>/usr/lib/libstdc++-3-libc6.2-2-2.10.0.so
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE | 0x400df000 |
>0x40100000 |
>/lib/i686/libm.so.6
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE | 0x40101000 |
>0x4020a000 |
>/lib/i686/libc.so.6
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE ----> Symbolic Stack Back
>Trace <----
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE 0: 0x0878b2ca
>eo670_CTraceStack +0x001e
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE
>/opt/sapdb/depend75/pgm/kernel
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE Frameinfo
>[0x6012c630] (0x0,0x0,0x1,0x878b2b8)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE 1: 0x087a97bd
>vabort +0x0039
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE
>/opt/sapdb/depend75/pgm/kernel
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE Frameinfo
>[0x6012c660] (0x8af21dc,0x8938160,0x8938182,0x6012c688)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE 2: 0x087153c3
>RTE_Crash__FRC20SAPDBErr_MessageList +0x010f
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE
>/opt/sapdb/depend75/pgm/kernel
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE Frameinfo
>[0x6012c690] (0x40240001,0xf5,0x6012c6d0,0x8715346)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE 3: 0x086d7e81
>InternReadLogAndCreateRedoFile__16Rst_RedoReadTaskR18tgg00_Tran
>sContextR23Rst_IRedoTrafficControlR
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE
>20Rst_LogEntryIteratorR22SAPDBMem_IRawAllocator +0x0fe1
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE
>/opt/sapdb/depend75/pgm/kernel
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE Frameinfo
>[0x6012c6d0] (0x6012cad4,0x0,0x0,0x86d79cc)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE 4: 0x086d6d42
>ReadLogAndCreateRedoFiles__16Rst_RedoReadTaskR18tgg00_TransCont
>ext +0x011e
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE
>/opt/sapdb/depend75/pgm/kernel
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE Frameinfo
>[0x6012cb30] (0x60145658,0x6012cf14,0x63701028,0x6014588c)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE 5: 0x086d6bec
>ReadLogAndCreateRedoFiles__15Rst_RedoManagerR18tgg00_TransConte
>xt +0x0034
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE
>/opt/sapdb/depend75/pgm/kernel
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE Frameinfo
>[0x6012cba0] (0x60145658,0x6012cf14,0x10,0x86d6bc4)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE 6: 0x086d2183
>ReadLogAndCreateRedoFiles__21Kernel_AdministrationR18tgg00_Tran
>sContext
>+0x0027
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE
>/opt/sapdb/depend75/pgm/kernel
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE Frameinfo
>[0x6012cbd0] (0x8b5bc0c,0x6012cf14,0x2,0x86d2168)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE 7: 0x084081d1
>kb921RedoLogReadTask +0x0029
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE
>/opt/sapdb/depend75/pgm/kernel
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE Frameinfo
>[0x6012cc00] (0x8b5bb80,0x6012cf14,0x6012cd18,0x84081b5)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE 8: 0x08407f31
>kb92_server +0x052d
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE
>/opt/sapdb/depend75/pgm/kernel
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE Frameinfo
>[0x6012cc30] (0x6012cf14,0x3,0x1,0x6012cc98)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE 9: 0x084079f1
>k92server_process +0x019d
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE
>/opt/sapdb/depend75/pgm/kernel
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE Frameinfo
>[0x6012ccd0] (0x6012cd20,0x0,0x6012cda0,0x84079e5)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE 10: 0x0813ce59
>ak91run_non_user_process +0x01c9
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE
>/opt/sapdb/depend75/pgm/kernel
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE Frameinfo
>[0x6012cda0] (0x6012cf14,0x9,0x6012cecc,0x813cc9e)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE 11: 0x0813d381
>a91mainprogam_with_allocator +0x004d
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE
>/opt/sapdb/depend75/pgm/kernel
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE Frameinfo
>[0x6012ce20] (0x6012cf14,0x9,0x4022eba4,0x813d341)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE 12: 0x08531a69
>gg941CreateAllocatorAndCallMainprog +0x01e5
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE
>/opt/sapdb/depend75/pgm/kernel
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE Frameinfo
>[0x6012ce50] (0x6012cf14,0x2,0xffffffff,0x25)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE 13: 0x0813d318
>a91mainprogram +0x003c
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE
>/opt/sapdb/depend75/pgm/kernel
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE Frameinfo
>[0x6012cee0] (0x6012cf14,0x0,0x0,0x813d2ec)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE 14: 0x087cd772
>en88_CallKernelTaskMain__FP9TASK_TYPE +0x016e
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE
>/opt/sapdb/depend75/pgm/kernel
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE Frameinfo
>[0x6012cf80] (0x8af21dc,0x40224350,0x87cdc70,0x87cdc70)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE 15: 0x087cdc9e
>en88_CallCoroutineKernelTaskMain +0x002e
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE
>/opt/sapdb/depend75/pgm/kernel
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE Frameinfo
>[0x6012cfb0] (0x500143f0,0x8ba8520,0x0,0x0)
>2005-04-28 17:52:17 9016 ERR 11599 BTRACE ----> End of Stack Back
>Trace <----
>2005-04-28 17:52:17 9016 ERR 11196 DBCRASH vabort:Emergency
>Shutdown,
>Task: 37
>2005-04-28 17:52:18 0 ERR 11979 DBCRASH Kernel exited
>without core
>and exit status 0x200
>2005-04-28 17:52:18 0 ERR 11983 DBCRASH Kernel exited exit code 2
>2005-04-28 17:52:18 ___ Stopping GMT
>2005-04-28
>15:52:18 7.5.0 Build 026-121-094-430
>--->8---
>
>so, what's next?
>
> Raimund
>
>--
>Enterprise Content Management mit automatisiertem Pressespiegel
>f�r RedDot-Projekte, http://www.pinuts.de/news
>
>Pinuts media+science GmbH http://www.pinuts.de
>Dipl.-Inform. Raimund Jacob [EMAIL PROTECTED]
>Krausenstr. 9-10 voice : +49 30 59 00 90 322
>10117 Berlin fax : +49 30 59 00 90 390
>Germany
>
>--
>MaxDB Discussion Mailing List
>For list archives: http://lists.mysql.com/maxdb
>To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
