>-----Original Message----- >From: Andre Reitz [mailto:[EMAIL PROTECTED] >Sent: Wednesday, November 24, 2004 12:52 PM >To: Maxdb >Subject: Urgent: Emergency Shutdown -> Please Help > > >DATABASE: >--------- > sapdb 7.4.3.32 (RPM-Installation on SuSE 7.3) > >THE PROBLEM: >------------ >knldiag.err: >... >2004-11-24 11:57:18 10816 ERR 11599 BTRACE >/opt/sapdb/depend74/pgm/kernel >2004-11-24 11:57:18 10816 ERR 11599 BTRACE Frameinfo >[0x40b43904] (0x40b43a44,0x9,0x401e30fc,0x401e2c78) >2004-11-24 11:57:18 10816 ERR 11599 BTRACE 12: 0x084732d0 >gg941CreateAllocatorAndCallMainprog +0x01c0 >2004-11-24 11:57:18 10816 ERR 11599 BTRACE >/opt/sapdb/depend74/pgm/kernel >2004-11-24 11:57:18 10816 ERR 11599 BTRACE Frameinfo >[0x40b43934] (0x40b43a44,0x2,0xffffffff,0x22) >2004-11-24 11:57:18 10816 ERR 11599 BTRACE 13: 0x08105532 >a91mainprogram +0x008e >2004-11-24 11:57:18 10816 ERR 11599 BTRACE >/opt/sapdb/depend74/pgm/kernel >2004-11-24 11:57:18 10816 ERR 11599 BTRACE Frameinfo >[0x40b439b4] (0x40b43a44,0x40b439e4,0x40b439e4,0x4002b633) >2004-11-24 11:57:18 10816 ERR 11599 BTRACE 14: 0x084b4a74 >en88_CallKernelTaskMain__FP9TASK_TYPE +0x0148 >2004-11-24 11:57:18 10816 ERR 11599 BTRACE >/opt/sapdb/depend74/pgm/kernel >2004-11-24 11:57:18 10816 ERR 11599 BTRACE Frameinfo >[0x40b43aa4] (0x50015f84,0x401dec78,0x401dec60,0x40026ff0) >2004-11-24 11:57:18 10816 ERR 11599 BTRACE 15: 0x084b513d >en88_RunPthreadTask +0x0035 >2004-11-24 11:57:18 10816 ERR 11599 BTRACE >/opt/sapdb/depend74/pgm/kernel >2004-11-24 11:57:18 10816 ERR 11599 BTRACE Frameinfo >[0x40b43ac4] (0x50015f84,0x401dec78,0x40b43af4,0x84b5117) >2004-11-24 11:57:18 10816 ERR 11599 BTRACE ----> End of >Stack Back Trace <---- >2004-11-24 11:57:18 10816 ERR 11196 DBCRASH vabort:Emergency >Shutdown, Task: 34 >2004-11-24 12:02:28 --- Starting GMT >2004-11-24 11:02:28 7.4.3 Build 032-121-068-842 >2004-11-24 12:02:36 29846 ERR 0 SAPDBErr Assertion of >state Log_SaveIterator::CheckPageBuffer pagebuffer contains no >endOfLogDevice failed! >2004-11-24 12:02:36 29846 ERR 11196 DBCRASH vabort:Emergency >Shutdown, Log_SaveIterator.cpp: 220 >2004-11-24 12:02:36 29846 ERR 11599 BTRACE ----> Emergency >Stack Back Trace <---- >2 > > >FOUND THE WORKAROUND: >--------------------- > >http://dev.mysql.com/doc/maxdb/changes/changes_7.5.00.11.html > >Fixed Problem: (PTS Message 1127638, fixed in 7.5.00.11) >appearance: >A LogBackup is started and the kernel crashes with the errormessage >"Assertion of state Log_SaveIterator::CheckPageBuffer pagebuffer >contains no endOfLogDevice failed!" in the file knldiag > >Preconditions and circumstances: >A logRecovery lead to a restart by the command >recover_ignore, also this command should have been >rejected by the kernel. > >Workaround: >Try to determine, which changes had been lost by the >recover_ignore (have a look at the timestamps of the not >recovered logbackups). If nothing had been lost, clear the >logvolume and do a complete backup. Otherwise the >recovery has to be reeated including the previously not >recovered logbackups. > >Solution: >Code-correction: A recover_ignore is only allowed, >when the logvolume is cleared. > > >THE QUESTION: >------------- >- What exactly does this Workaround mean for us?
Please send me the files knldiag,knldiag.err,dbm.utl,dbm.prt,dbm.knl they contain a history of the actions you have done. Depending on this information I could give you a hint how to recover the database. >- Which timestamps of which files? This means the time interval of you log backups and the contents of your log volume. >- How do I clear the logvolume? With "util_execute clear log" you can clear/initilialze the log volume. But you will loose changes if you log is not backuped before!!! >- Is the Logvolume the file: /var/opt/sapdb/ONLINE/DISKL001 ? Yes. >- Are the Logbackups the files: >/var/opt/sapdb/ONLINE/autosave.001 .002 ....? Yes. >- Why shall I do a complete backup afterwards? To begin a new backup history. This is necessary after you cleared the full or parts of the log volume (e.g. point in time recovery). Before the complete data backup your are not allowed to backup log again. > > >Thank you very much in Advance, You are welcome. Uwe >Greetings, Andre' > >-- >_______________________________________________________________ >___________ > >Als Technologieunternehmen konzipieren und entwickeln wir >ma�geschneiderte Feedback- und >Monitoring-Systeme - wie beispielsweise L�sungen f�r >Beschwerde- und Ideenmanagement. >Mit dem Inquery� Survey Server bieten wir eine der >leistungsf�higsten Standardl�sungen f�r >Online-Umfragen mit dem Schwerpunkt auf der Messung von >Kundenzufriedenheit an. >_______________________________________________________________ >___________ > > >Inworks GmbH >Andre Reitz, Leiter Entwicklung >H�rvelsinger Weg 39, 89081 Ulm, Germany >Tel +49 (0) 731 / 93807-21 >Fax +49(0)731/93807-18 >Internet: http://www.inworks.de > > > >-- >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]
