Error starting SQL Node
Posted by: Luciano Schardosim
Date: January 24, 2012 07:37AM

Hi,

I own the following scenario:


ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.0.213 (mysql-5.5.16 ndb-7.2.2, Nodegroup: 0, Master)
id=3 @192.168.0.214 (mysql-5.5.16 ndb-7.2.2, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.0.211 (mysql-5.5.16 ndb-7.2.2)

[mysqld(API)] 2 node(s)
id=4 @192.168.0.212 (mysql-5.5.16 ndb-7.2.2)
id=5 (not connected, accepting connect from 192.168.0.215)

when I try to start the node 5, returns the following message:

2012-01-24 07:38:07 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 192.168.0.212. Returned eror: 'No free node id found for mysqld(API).' - Repeated 2 times

My config.ini is:

[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=2 # Number of replicas
DataMemory=128M # How much memory to allocate for data storage
IndexMemory=64M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.

[tcp default]
# TCP/IP options:
portnumber=2202 # This the default; however, you can use any
# port that is free for all the hosts in the cluster
# Note: It is recommended that you do not specify the port
# number at all and simply allow the default value to be used
# instead

[ndb_mgmd]
# Management process options:
hostname=192.168.0.211 # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node log files

[ndbd]
# Options for data node "A":
# (one [ndbd] section per data node)
hostname=192.168.0.213 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's data files

[ndbd]
# Options for data node "B":
hostname=192.168.0.214 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's data files

[mysqld]
# SQL node options:
hostname=192.168.0.212 # Hostname or IP address
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)

[mysqld]
hostname=192.168.0.215 # Hostname or IP address

I want to start the second node sql and I can not, can someone help me?

Options: ReplyQuote


Subject
Views
Written By
Posted
Error starting SQL Node
1252
January 24, 2012 07:37AM
594
January 24, 2012 07:41AM


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.