| Unable to start data nodes in MySQL CGE 7.3.2 [message #601272] |
Tue, 19 November 2013 02:18  |
 |
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 
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
