Hi Ralf, yes, I meant the harddrive cache. If it were enabled than there may be more than one corrupt data/logpage. Did you restore your data again in order to ensure that your database is error-free?
Are you getting the errors only during restart or also if the database is online and you're working with it? Is the kind of error always the same? Kind regards, Martin > -----Original Message----- > From: Ralf Bast [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 05, 2007 10:20 AM > To: maxdb@lists.mysql.com > Subject: RE: RE: Instance broken after system restrart > > Hi Martin, > > Thank you very much for your answer. > > I'm right in the suggestion with writecache you mean the > writecache of the harddrive? > > If yes, it did not really help. > It it still crashes again after a few restarts. > > Maybe it helps that the machine, I'm trying to get the > database working, is a Samsung Q1b UMPC. > > Unfortunately I'm not able to reproduce the error on demand. > Sometimes it work and sometimes not. > So I do not really know how to test if the database is working or not. > > Is there any other idea what could have cause such an error? > Or is there anything i can maybe try? > > Thanks! > > Regards > Ralf > > >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&ErrorI > D=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: [EMAIL PROTECTED] > >> 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/maxdb?unsub=1 > >> > >> > ______________________________________________________________ > _________ > Jetzt neu! Schützen Sie Ihren PC mit McAfee und WEB.DE. 3 Monate > kostenlos testen. > http://www.pc-sicherheit.web.de/startseite/?mc=022220 > > > -- > 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]
