MySQL Forums
Forum List  »  Install & Repo

DB Node crashes
Posted by: Yannis Tsakiris
Date: September 13, 2004 04:55AM

Hello,
I have set up a NDB cluster consisting of two computers, with 2 MGM nodes, 2 DB nodes, and 2 API nodes (2 Replicas, 1 node group). I have used the last release of 4.1.5 (gamma-nightly-20040912). Here is the problem:
I start all the nodes of the cluster and everything seems to work fine.
Then I reboot the first computer, to check if the cluster will still working.
This causes the ndbd on the second computer to crash.
This is the last message of the db node's error log at the time of the crash:
Date/Time: Monday 13 September 2004 - 13:20:38
Type of error: error
Message: Arbitrator shutdown
Fault ID: 2305
Problem data: Arbitrator decided to shutdown this node
Object of reference: QMGR (Line: 3774) 0x0000000a
ProgramName: NDB Kernel
ProcessID: 2131
TraceFile: ./ndb_3_trace.log.17
***EOM***
I can't find an explanation why this is happening? Any ideas?
The config.ini file I use is as follows:
[COMPUTER DEFAULT]
[DB DEFAULT]
NoOfReplicas: 2
[API DEFAULT]
[MGM DEFAULT]
ArbitrationRank: 2
[TCP DEFAULT]
PortNumber: 28002
[COMPUTER]
Id: 1
Hostname: 10.3.90.1
[COMPUTER]
Id: 2
HostName: 10.3.90.2
[MGM]
Id: 1
ExecuteOnComputer: 1
PortNumber: 2200
[MGM]
Id: 6
ExecuteOnComputer: 2
PortNumber: 2200
[DB]
Id: 2
ExecuteOnComputer: 1
FileSystemPath: /usr/local/mysql/cluster/db1/
[DB]
Id: 3
ExecuteOnComputer: 2
FileSystemPath: /usr/local/mysql/cluster/db2/
[API]
Id: 4
ExecuteOnComputer: 1
[API]
Id: 5
ExecuteOnComputer: 2
[TCP]
NodeId1: 1
NodeId2: 2
[TCP]
NodeId1: 1
NodeId2: 3
[TCP]
NodeId1: 6
NodeId2: 2
[TCP]
NodeId1: 6
NodeId2: 3
If you see something wrong or have any suggestion please help me.
Thanks in advance,
Yannis Tsakiris

Options: ReplyQuote


Subject
Written By
Posted
DB Node crashes
September 13, 2004 04:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.