Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2013
    Posts
    2

    Unanswered: Unable to start data nodes on MySQL CGE 7.3.2

    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

  2. #2
    Join Date
    Jun 2007
    Posts
    197
    Make sure there should no firewall in any node

    use

    Code:
    serivice iptables stop
    [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: ''
    In this your node is trying to connect management server on local host but you have management server on other host [10.1.254.32]

    use -c option with ndbd

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •