From: Johan Andersson
Date: May 5 2011 8:55pm
Subject: Re: No free node id found
List-Archive: http://lists.mysql.com/cluster/8053
Message-Id: <7E5B23AA-D7BC-4097-BCAF-384C4CBAC08C@severalnines.com>
MIME-Version: 1.0 (iPhone Mail 8G4)
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

Yes, it looks healthy but you still need to do a rolling restart so that the=
 data nodes pick up the config change.

-
Johan
www.severalnines.com

On 5 maj 2011, at 22:51, csavino <csavino@stripped> wrote:

> Hi,
>=20
> When I do show in ndb_mgm everything else looks healthy.  I am using
> ndb-cluster-connection-pool variable set to 4 in all my.cnf files.
>=20
> Candice
>=20
> On 5/5/11 3:38 PM, "Massimo Brignoli" <massimo.brignoli@stripped> wrote:=

>=20
>> Hi,
>>=20
>> Can you do
>>=20
>> ndb_mgm -e "show" to check the status of the nodes?
>>=20
>> Are you using the connection_pool paramenter in the my.cnf of the mysqlds=
?
>>=20
>> Massimo
>>=20
>> On 05/05/11 22.10, "Johan Andersson" <johan@stripped> wrote:
>>=20
>>> Hi,
>>>=20
>>> 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.
>>>=20
>>> Best regards,
>>> Johan Andersson
>>> www.severalnines.com
>>>=20
>>>=20
>>> On 2011-05-05 22.02, csavino wrote:
>>>> I=C2=B9m having an odd problem.  I=C2=B9m installing/configuring a new c=
luster
>>>> 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=C2=B9s=

>>>> specified.  I=C2=B9m trying to bring up a 5th sqld node and it won=C2=B9=
t connect
>>>> to
>>>> the cluster.  I=C2=B9m getting the below error in the cluster log.
>>>>=20
>>>> 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=

>>>>=20
>>>> 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=C2=B9t
>>>> help.
>>>>=20
>>>> Does anyone have an idea what might be causing this?
>>>>=20
>>>> Thanks for any help in advance,
>>>> Candice
>>>>=20
>>>=20
>>>=20
>>> --=20
>>> MySQL Cluster Mailing List
>>> For list archives: http://lists.mysql.com/cluster
>>> To unsubscribe:    http://lists.mysql.com/cluster?unsub=3Dmassimo@mysql.=
com
>>>=20
>>=20
>>=20
>=20
>=20
> --=20
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:    http://lists.mysql.com/cluster?unsub=3Djohan@severalnin=
es.com
>=20
>=20