Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• mysql openssl Question
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• Update one field with more fields from another table
• Getting Identity after INSERT
• ERROR 2002: Can 't connect to local MySQL server through socket
• mysql test 4 1 fails with the gis test
• MySQL Cluster Software
• Downgrade Mysql from 4 to 3 23
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Can 't access mysql after kernel upgrade
• Executing MySQL Commands From Within C Program
• Comparing and writing out BLOBS
• Preventing Duplicate Entries
• FULLTEXT query format question
• Strange behavior, Table Level Permission
• Does the binary log enabling affect the MySQL performances?
• mysql:it 's a db not a dbms how it 's possible?!
• mysql have same function mthod as Oracle decode()
 
Instance broken after system restrart

Instance broken after system restrart

2007-06-29       - By Ralf Bast

 Back
Reply:     1     2     3     4     5  

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=mysql@(protected)