MySQL Forums
Forum List  »  NDB clusters

Unable to start data nodes!
Posted by: Rabail Abbasi
Date: November 19, 2013 01:23AM

Hi all,

I have been trying to setup MySQL cluster on three nodes. One Management Node (10.1.254.32), One SQL Node (10.1.254.32), and two data nodes (10.11.11.114 and 10.11.11.90).

Following is my config.ini at /root/MySQL_Cluster at the Management node:

**************************************************************************

#
# Configuration file for ptcldbcluster
#

[NDB_MGMD DEFAULT]
Portnumber=1186

[NDB_MGMD]
NodeId=49
HostName=10.1.254.32
DataDir=/root/MySQL_Cluster/49/
Portnumber=1186


[TCP DEFAULT]
SendBufferMemory=4M
ReceiveBufferMemory=4M

[NDBD DEFAULT]
BackupMaxWriteSize=1M
BackupDataBufferSize=16M
BackupLogBufferSize=4M
BackupMemory=20M
BackupReportFrequency=10
MemReportFrequency=30
LogLevelStartup=15
LogLevelShutdown=15
LogLevelCheckpoint=8
LogLevelNodeRestart=15
DataMemory=1M
IndexMemory=1M
MaxNoOfTables=4096
MaxNoOfTriggers=3500
NoOfReplicas=2
StringMemory=25
DiskPageBufferMemory=64M
SharedGlobalMemory=20M
LongMessageBuffer=32M
MaxNoOfConcurrentTransactions=16384
BatchSizePerLocalScan=512
FragmentLogFileSize=256M
NoOfFragmentLogFiles=3
RedoBuffer=32M
MaxNoOfExecutionThreads=2
StopOnError=false
LockPagesInMainMemory=1
TimeBetweenEpochsTimeout=32000
TimeBetweenWatchdogCheckInitial=60000
TransactionInactiveTimeout=60000
HeartbeatIntervalDbDb=15000
HeartbeatIntervalDbApi=15000

[NDBD]
NodeId=1
HostName=10.11.11.114
DataDir=/root/MySQL_Cluster/1/

[NDBD]
NodeId=2
HostName=10.11.11.90
DataDir=/root/MySQL_Cluster/2/

[MYSQLD DEFAULT]

[MYSQLD]
NodeId=55
HostName=10.1.254.32

***********************************************************************

So following is the status on Management Node:

[root@mysqclusternode1 ~]# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> SHOW
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=1 (not connected, accepting connect from 10.11.11.114)
id=2 (not connected, accepting connect from 10.11.11.90)

[ndb_mgmd(MGM)] 1 node(s)
id=49 @10.1.254.32 (mysql-5.6.11 ndb-7.3.2)

[mysqld(API)] 1 node(s)
id=55 (not connected, accepting connect from 10.1.254.32)

******************************************************************************

When I try to start the data nodes by entering 'ndbd' on each of the node, I get the following error:

[root@mysqlclusternode4 ~]# ndbd
Unable to connect with connect string: nodeid=0,localhost:1186
Retrying every 5 seconds. Attempts left: 12 11 10 9 8 7 6 5 4 3 2 1, failed.
2013-11-19 12:12:42 [ndbd] ERROR -- Could not connect to management server, error: ''

Following is the logfile on the data node:

ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
2013-11-19 12:11:24 [ndbd] ERROR -- Could not set dynamic port for 1->50 (/pb2/build/sb_0-9483450-1371110533.26/rpm/BUILD/mysql-cluster-com-7.3.2/mysql-cluster-com-7.3.2/storage/ndb/src/common/transporter/TransporterRegistry.cpp:2229) - Repeated 18 times
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
2013-11-19 12:11:27 [ndbd] ERROR -- Could not set dynamic port for 1->50 (/pb2/build/sb_0-9483450-1371110533.26/rpm/BUILD/mysql-cluster-com-7.3.2/mysql-cluster-com-7.3.2/storage/ndb/src/common/transporter/TransporterRegistry.cpp:2229) - Repeated 17 times
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
2013-11-19 12:11:30 [ndbd] ERROR -- Could not set dynamic port for 1->50 (/pb2/build/sb_0-9483450-1371110533.26/rpm/BUILD/mysql-cluster-com-7.3.2/mysql-cluster-com-7.3.2/storage/ndb/src/common/transporter/TransporterRegistry.cpp:2229) - Repeated 19 times
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
2013-11-19 12:11:33 [ndbd] ERROR -- Could not set dynamic port for 1->50 (/pb2/build/sb_0-9483450-1371110533.26/rpm/BUILD/mysql-cluster-com-7.3.2/mysql-cluster-com-7.3.2/storage/ndb/src/common/transporter/TransporterRegistry.cpp:2229) - Repeated 18 times
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
2013-11-19 12:11:36 [ndbd] ERROR -- Could not set dynamic port for 1->50 (/pb2/build/sb_0-9483450-1371110533.26/rpm/BUILD/mysql-cluster-com-7.3.2/mysql-cluster-com-7.3.2/storage/ndb/src/common/transporter/TransporterRegistry.cpp:2229) - Repeated 17 times
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
2013-11-19 12:11:39 [ndbd] ERROR -- Could not set dynamic port for 1->50 (/pb2/build/sb_0-9483450-1371110533.26/rpm/BUILD/mysql-cluster-com-7.3.2/mysql-cluster-com-7.3.2/storage/ndb/src/common/transporter/TransporterRegistry.cpp:2229) - Repeated 17 times
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
2013-11-19 12:11:42 [ndbd] ERROR -- Could not set dynamic port for 1->50 (/pb2/build/sb_0-9483450-1371110533.26/rpm/BUILD/mysql-cluster-com-7.3.2/mysql-cluster-com-7.3.2/storage/ndb/src/common/transporter/TransporterRegistry.cpp:2229) - Repeated 18 times
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
2013-11-19 12:11:45 [ndbd] ERROR -- Could not set dynamic port for 1->50 (/pb2/build/sb_0-9483450-1371110533.26/rpm/BUILD/mysql-cluster-com-7.3.2/mysql-cluster-com-7.3.2/storage/ndb/src/common/transporter/TransporterRegistry.cpp:2229) - Repeated 17 times

I am unable to start any of the data node and I am stuck. Kindly help me out if you know the workaround!! Will be really thankful :)

Options: ReplyQuote


Subject
Views
Written By
Posted
Unable to start data nodes!
6471
November 19, 2013 01:23AM
2072
December 01, 2013 10:56AM


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.