DB Node crashes
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
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.