From: Johan Andersson
Date: May 5 2011 8:10pm
Subject: Re: No free node id found
List-Archive: http://lists.mysql.com/cluster/8051
Message-Id: <4DC3044D.70901@severalnines.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Hi,

Did you also restart the data nodes after restarting the management 
server with --reload?
Also, I do recommend you to upgrade to 7.1.10 or later.

Best regards,
Johan Andersson
www.severalnines.com


On 2011-05-05 22.02, csavino wrote:
> Iım having an odd problem.  Iım installing/configuring a new cluster using
> ndb version 5.1.44-ndb-7.1.3.  I have 2 management nodes connected to
> cluster with 2 data nodes and 4 sqld nodes connected.  I have 36 open
> [mysqld] entries in the config.ini files with no hostnames or idıs
> specified.  Iım trying to bring up a 5th sqld node and it wonıt connect to
> the cluster.  Iım getting the below error in the cluster log.
>
> WARNING  -- Allocate nodeid (0) failed. Connection from ip 10.44.9.40.
> Returned error string "No free node id found for mysqld(API)."
> 2011-05-05 13:45:35 [MgmtSrvr] INFO     -- Mgmt server state: node id's 2 3
> 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 connected but not reserved
>
> Normally when I get this message I would think I needed to add mysqld
> entries in the config file, but there are plenty available right now.  I
> have tried restarting the management nodes several times after updating the
> config.ini file with specific ids that were not being used, but that didnıt
> help.
>
> Does anyone have an idea what might be causing this?
>
> Thanks for any help in advance,
> Candice
>