Home » Open Source » MySQL » Unable to start data nodes in MySQL CGE 7.3.2 (MySQL CGE 7.3.2 on RHEL 6)
Unable to start data nodes in MySQL CGE 7.3.2 [message #601272] Tue, 19 November 2013 02:18 Go to next message
Rabail Pervez
Messages: 1
Registered: November 2013
Location: Islamabad
Junior Member

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/T ransporterRegistry.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/T ransporterRegistry.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/T ransporterRegistry.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/T ransporterRegistry.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/T ransporterRegistry.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/T ransporterRegistry.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/T ransporterRegistry.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/T ransporterRegistry.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 Smile
Re: Unable to start data nodes in MySQL CGE 7.3.2 [message #602743 is a reply to message #601272] Sun, 08 December 2013 05:51 Go to previous message
mzainal
Messages: 48
Registered: March 2010
Location: Malaysia
Member
Have you check iptables and SElinux?
Previous Topic: Slow Query
Next Topic: how to conncet mysql database and oracle database 11g2 on linux 5.4
Goto Forum:
  


Current Time: Wed Jul 30 17:29:45 CDT 2014

Total time taken to generate the page: 0.14263 seconds