Please take our Survey
logo       

Choosing A Webhost:
A web hosting service is a type of Internet hosting service that allows individuals and organizations to provide their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers they do not own to be located in their data center, called colocation. more...

Urgent: Emergency Shutdown -> Please Help: msg#00237

db.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?
- Which timestamps of which files?
- How do I clear the logvolume?
- Is the Logvolume the file: /var/opt/sapdb/ONLINE/DISKL001 ?
- Are the Logbackups the files: /var/opt/sapdb/ONLINE/autosave.001 .002 ....?
- Why shall I do a complete backup afterwards?


Thank you very much in Advance,
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=gcdm-maxdb@xxxxxxxxxxx




<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe

Navigation

Home | advertise | OSDir is an inevitable website. super tiny logo