OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Instance broken after system restrart

From: Ralf Bast (BastRalfweb.de)
Date: Fri Jun 29 2007 - 03:24:19 CDT


Hi everybody,

I got a problem with some of my database instances.

At first I'm using MaxDB 7.6.00.27 ( the old version, because with the newer the installer always crashes) on a Windows XP Multilanguage System.

I had 2 instances running. Yesterday I have added a new one, recover a backup in it and everything works fine.

Now to my problem: after a restart of the machine the database does not come up again.
The try to bring it online, ends with "-9407, System error".

I have absolutely no idea what could cause this problem.

Attached you will find a quot of the KNLDIAGERR.

Has someone a idea what could cause this problem?
Or better how to prevent this Problem.

Regards
Ralf Bast

2007-06-29 10:04:25 0xD78 ERR 46 SrvTasks After Job execution the job is still allocating 512 bytes.
2007-06-29 10:04:25 0xD78 ERR 32 SrvTasks + Server T87 Id7 dynamic: ''
2007-06-29 10:04:25 0xD78 ERR 46 SrvTasks After Job execution the job is still allocating 512 bytes.
2007-06-29 10:04:25 0xD78 ERR 32 SrvTasks + Server T66 Id0 dynamic: ''
2007-06-29 10:04:25 0xD78 ERR 46 SrvTasks After Job execution the job is still allocating 512 bytes.
2007-06-29 10:04:25 0xD78 ERR 32 SrvTasks + Server T86 Id8 dynamic: ''
2007-06-29 10:04:25 0xD78 ERR 46 SrvTasks After Job execution the job is still allocating 512 bytes.
2007-06-29 10:04:25 0xD78 ERR 32 SrvTasks + Server T85 Id9 dynamic: ''
2007-06-29 10:04:25 0xD78 ERR 46 SrvTasks After Job execution the job is still allocating 512 bytes.
2007-06-29 10:04:25 0xD78 ERR 32 SrvTasks + Server T84 Id10 dynamic: ''
2007-06-29 10:04:25 0xD78 ERR 46 SrvTasks After Job execution the job is still allocating 512 bytes.
2007-06-29 10:04:25 0xD78 ERR 32 SrvTasks + Server T92 Id2 dynamic: ''
2007-06-29 10:04:25 0xD78 ERR 46 SrvTasks After Job execution the job is still allocating 512 bytes.
2007-06-29 10:04:25 0xD78 ERR 32 SrvTasks + Server T91 Id3 dynamic: ''
2007-06-29 10:04:25 0xD78 ERR 46 SrvTasks After Job execution the job is still allocating 512 bytes.
2007-06-29 10:04:25 0xD78 ERR 32 SrvTasks + Server T89 Id5 dynamic: ''
2007-06-29 10:04:25 0xD78 ERR 46 SrvTasks After Job execution the job is still allocating 512 bytes.
2007-06-29 10:04:25 0xD78 ERR 32 SrvTasks + Server T90 Id4 dynamic: ''
2007-06-29 10:04:25 0xD78 ERR 46 SrvTasks After Job execution the job is still allocating 512 bytes.
2007-06-29 10:04:25 0xD78 ERR 32 SrvTasks + Server T93 Id1 dynamic: ''
2007-06-29 10:04:25 0x798 ERR 51080 SYSERROR -9407 unexpected error
2007-06-29 10:04:25 0x798 ERR 3 Admin Database state: OFFLINE
2007-06-29 10:04:25 0x798 ERR 6 KernelCo + Rst_RedoReadTask::GetOrCreateRedoTransaction, Errorcode 400 "cancelled"
2007-06-29 10:04:25 0x798 ERR 2 Rst + Trans 8658 failed during redo with 3 (ExecuteError)
2007-06-29 10:04:25 0x798 ERR 20078 Log + Trans: #8658 redoExecute committed [83]
2007-06-29 10:04:25 0x798 ERR 6 KernelCo + BasisError, Errorcode 1200 "key_not_found"
2007-06-29 10:04:25 0x798 ERR 6 KernelCo + error, Errorcode 1200 "key_not_found"
2007-06-29 10:04:25 0x798 ERR 3 Log + Log_AfterImage: type=UpdateRecord/1 isdone=no seq=684 TR8658
2007-06-29 10:04:25 0x798 ERR 6 Log + Action UpdateRecord.1 Length=288(32) ForceWriting=false WaitForWrite=false LocalCacheAllowed=true
2007-06-29 10:04:25 0x798 ERR 6 KernelCo + RedoError, Errorcode 1200 "key_not_found"
2007-06-29 10:04:25 0x798 ERR 20079 Log + Trans: UndoFile, root:2147483647 last:2147483647 lastseq:4294967295 ()
2007-06-29 10:04:25 0x798 ERR 20079 Log + Trans: RedoFile, root:89395 last:59615 lastseq:4294967295 (765)
2007-06-29 10:04:25 0x798 ERR 20080 Log + Trans: Redo log writing is DISABLED.
2007-06-29 10:04:25 0x798 ERR 20081 Log + Trans: Session: -1.8658.0
2007-06-29 10:04:25 0x798 ERR 20082 Log + Trans: T87 TRIDX:105
2007-06-29 10:04:25 0x798 ERR 20056 Data + Data_ChainSplitSpaceForwardReadChain::Iterator: space is not complete break=29840.4712 (ForUpdate)
2007-06-29 10:04:25 0x798 ERR 20057 Data + PAM: t87 tr8658 root=89395
2007-06-29 10:04:25 0x798 ERR 20052 Data + Data_SplitSpace: split space not assigned
2007-06-29 10:04:25 0x798 ERR 20051 Data + SplitSpaceReader: currpart=1 currlen=316 restlen=0 releasable
2007-06-29 10:04:25 0x798 ERR 20052 Data + Data_SplitSpace: split space not assigned
2007-06-29 10:04:25 0x798 ERR 2 Rst + Trans 8658 failed during redo with 3 (ExecuteError)
2007-06-29 10:04:25 0x798 ERR 20078 Log + Trans: #8658 redoExecute committed [83]
2007-06-29 10:04:25 0x798 ERR 6 KernelCo + BasisError, Errorcode 1200 "key_not_found"
2007-06-29 10:04:25 0x798 ERR 6 KernelCo + error, Errorcode 1200 "key_not_found"
2007-06-29 10:04:25 0x798 ERR 3 Log + Log_AfterImage: type=UpdateRecord/1 isdone=no seq=684 TR8658
2007-06-29 10:04:25 0x798 ERR 6 Log + Action UpdateRecord.1 Length=288(32) ForceWriting=false WaitForWrite=false LocalCacheAllowed=true
2007-06-29 10:04:25 0x798 ERR 6 KernelCo + RedoError, Errorcode 1200 "key_not_found"
2007-06-29 10:04:25 0xD78 ERR 46 SrvTasks After Job execution the job is still allocating 512 bytes.
2007-06-29 10:04:25 0xD78 ERR 32 SrvTasks + Server T88 Id6 dynamic: ''
2007-06-29 10:04:25 0x798 ERR 20079 Log + Trans: UndoFile, root:2147483647 last:2147483647 lastseq:4294967295 ()
2007-06-29 10:04:25 0x798 ERR 20079 Log + Trans: RedoFile, root:89395 last:59615 lastseq:4294967295 (765)
2007-06-29 10:04:25 0x798 ERR 20080 Log + Trans: Redo log writing is DISABLED.
2007-06-29 10:04:25 0x798 ERR 20081 Log + Trans: Session: -1.8658.0
2007-06-29 10:04:25 0x798 ERR 20082 Log + Trans: T87 TRIDX:105
2007-06-29 10:04:25 0x798 ERR 20056 Data + Data_ChainSplitSpaceForwardReadChain::Iterator: space is not complete break=29840.4712 (ForUpdate)
2007-06-29 10:04:25 0x798 ERR 20057 Data + PAM: t87 tr8658 root=89395
2007-06-29 10:04:25 0x798 ERR 20052 Data + Data_SplitSpace: split space not assigned
2007-06-29 10:04:25 0x798 ERR 20051 Data + SplitSpaceReader: currpart=1 currlen=316 restlen=0 releasable
2007-06-29 10:04:25 0x798 ERR 20052 Data + Data_SplitSpace: split space not assigned
2007-06-29 10:04:25 0x2A8 ERR 7 Messages Begin of dump of registered messages
2007-06-29 10:04:25 0x2A8 ERR 8 Messages End of the message list registry dump
_________________________________________________________________________
In 5 Schritten zur eigenen Homepage. Jetzt Domain sichern und gestalten!
Nur 3,99 EUR/Monat! http://www.maildomain.web.de/?mc=021114

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb