Unable to start data nodes on MySQL CGE 7.3.2

Rabail · November 19, 2013

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

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

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

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

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

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

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

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

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

Sign In

Unable to start data nodes on MySQL CGE 7.3.2

Recommended Posts

Rabail

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information