Error starting MaxDB after power failure

[johan_vanzijl]

Hi

We are running MaxDB 7.7.02.17 on Linux(Suse) X64 and the power failed on our machine. I am not able to start the database and receive the following error in the startdb.log:

Starting Database Instance...

OK

Opening Database...

ERR

-24988,ERR_SQL: SQL error

-9407,System error: unexpected error

3,Database state: OFFLINE

SplitSpaceReader: currpart=0 currlen=12 restlen=12 not releasable

Log_AfterImage: type=UpdateRecord/1 isdone=no seq=0 TR117557189

: val=' 1cea21c' len=12 tot.len=28

20000,Assertion of state Error during reading of after image failed!

###:TR4294967295(0)[58813209]@1695259.392'UpdateRecord':20080712:104204

-

---

Mon Jul 14 10:57:19 SAST 2008

Connect to the database to verify the database is now open

dbmcli check finished with return code: 0

Database start failed

I also receive the following in the DB Error Log:

Thread - Task - 2008-07-14 11:06:02 MsgOutput 27: --- Starting GMT 2008-07-14 09:06:02 7.7.02 Build 017-123-160-512

Thread 0x2FB Task 192 2008-07-14 11:21:40 AdminMsg 0: 487B1AA40003 0000 RST RESTART

Thread 0x2FB Task 192 2008-07-14 11:24:59 ERR SYSERROR 51080: -9407 unexpected error

Thread 0x2FB Task 192 2008-07-14 11:24:59 ERR Admin 3: Database state: OFFLINE,_FILE=Kernel_Administration.cpp,_LINE=658

2008-07-14 11:24:59 Data 20052: SplitSpaceReader: currpart=0 currlen=12 restlen=12 not releasable

2008-07-14 11:24:59 Log 3: Log_AfterImage: type=UpdateRecord/1 isdone=no seq=0 TR117557189

2008-07-14 11:24:59 Restart 20006: : val=' 1c3221c' len=12 tot.len=28

2008-07-14 11:24:59 ERR Restart 20000: Assertion of state Error during reading of after image failed!,_FILE=Rst_RedoReadTask.cpp,_LINE=598

2008-07-14 11:24:59 Log 20012: ###:TR4294967295(0)[58813209]@1695259.392'UpdateRecord':20080712:104204

Thread 0x2F9 Task - 2008-07-14 11:25:02 ERR DBCRASH 12009: Kernel exited due to signal 0(Killed after timeout with state SERVER_KILL)

Thread 0x2F9 Task - 2008-07-14 11:25:02 MsgOutput 28: ___ Stopping GMT 2008-07-14 09:25:02 7.7.02 Build 017-123-160-512

I have not been able to find any information(i think its trying to process the log file) on this error and would appreciate any information on how to correct this error?

Many thanks

Johan

[lbreddemann]

Hi Johan,

if you're a SAP customer, please open a support message.

Otherwise please post the whole knldiag file (convert the knlmsg file via protconv).

KR Lars