RE: Urgent: Emergency Shutdown -> Please Help

>-----Original Message-----
>From: Andre Reitz [mailto:reitz@xxxxxxxxxx] 
>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/maxdb?unsub=uwe.hahn@xxxxxxx
>
>

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx