Hi Ralf, when restarting down your machine the database weren't offline. This means that the logentries from the last savepoint until the newest one are redone during startup in order to ensure that your database content will be the same than before the shutdown.
During the execution of one redoentry an error occured. The reason is that an update command cannot find the key of the record to be updated. Please ensure that the writecache of your machine is disabled. Otherwise there can be inconsistencies in the database because the code relies on the fact that a write operation will really persist the written data. Also it could be the follwing error: http://www.sapdb.org/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1141691 It can occur if after a migration of internal database structures no savepoint has been written. Thus it can occur only after the first restart after the recovery. Kind Regards, Martin -- Martin Brunzema MaxDB&liveCache Base SAP AG mailto:[EMAIL PROTECTED] www.sap.com Sitz der Gesellschaft/Registered Office: Walldorf, Germany Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Léo Apotheker (stellvertretender Sprecher/Deputy CEO), Werner Brandt, Claus Heinrich, Gerhard Oswald, Peter Zencke Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso Plattner Registergericht/Commercial Register Mannheim No HRB 350269 Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank. This e-mail may contain trade secrets or privileged, undisclosed, or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying, or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation. > -----Original Message----- > From: Ralf Bast [mailto:[EMAIL PROTECTED] > Sent: Friday, June 29, 2007 10:24 AM > To: maxdb@lists.mysql.com > Subject: Instance broken after system restrart > > 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 > 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]
