7 messages in com.mysql.lists.clustermysql cluster with 3 DB nodes
FromSent OnAttachments
Kasthuri Ilankamban22 Jul 2004 12:35 
Devananda22 Jul 2004 12:49 
Kasthuri Ilankamban22 Jul 2004 13:02 
Joseph E. Sacco, Ph.D.22 Jul 2004 13:07 
Mikael Ronström29 Jul 2004 08:45 
Jim Hoadley29 Jul 2004 09:32 
Mikael Ronström29 Jul 2004 13:01 
Subject:mysql cluster with 3 DB nodes
From:Kasthuri Ilankamban (kast@umich.edu)
Date:07/22/2004 12:35:13 PM
List:com.mysql.lists.cluster

I'm trying to setup three db nodes on three separate machines. I'm successful with 2 db nodes on two different machines, but three is not working. I'm able to start management server without any problem, but when I start ndbd -i on third computer, all three db nodes crashes . The first two nodes crashes with this error in the error.log:

Date/Time: Thursday 22 July 2004 - 11:25:02 Type of error: error Message: Arbitrator shutdown Fault ID: 2305 Problem data: Arbitrator decided to shutdown this node Object of reference: QMGR (Line: 3764) 0x00000006 ProgramName: NDB Kernel ProcessID: 1970 TraceFile: NDB_TraceFile_5.trace ***EOM***

and the third ndbd logs this error:

Date/Time: Thursday 22 July 2004 - 12:27:12 Type of error: error Message: Internal program error (failed ndbrequire) Fault ID: 2341 Problem data: DbdihMain.cpp Object of reference: DBDIH (Line: 1080) 0x00000006 ProgramName: NDB Kernel ProcessID: 1955 TraceFile: NDB_TraceFile_1.trace ***EOM***

cluster config.ini file looks like this:

[COMPUTER] Id: 1 HostName: sanskrit.web.itd.umich.edu

[COMPUTER] Id: 2 HostName: slovak.web.itd.umich.edu

[COMPUTER] Id: 3 HostName: croatian.web.itd.umich.edu

[MGM] Id: 1 ExecuteOnComputer: 1 LogDestination: SYSLOG:facility=local0 PortNumber: 28000

[DB DEFAULT] NoOfReplicas: 2

[DB] Id: 2 ExecuteOnComputer: 1 FileSystemPath: /var/mysql/cluster/data

[DB] Id: 3 ExecuteOnComputer: 2 FileSystemPath: /var/mysql/cluster/data

[DB] Id: 4 ExecuteOnComputer: 3 FileSystemPath: /var/mysql/cluster/data

[API DEFAULT] ArbitrationRank: 1

[API] Id: 5 ExecuteOnComputer: 1

[API] Id: 6 ExecuteOnComputer: 2

[API] Id: 7 ExecuteOnComputer: 3

[TCP DEFAULT] PortNumber: 28002

Thanks Kasthuri