From: Andrew Morgan Date: October 4 2012 4:32pm Subject: RE: Problem with memcached List-Archive: http://lists.mysql.com/cluster/8411 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi Maxime, Try running "ndb_mgm -c 37.59.48.15:1186 -e show" from the same host that = you're running memcached from to see if you get the same response. Regards, Andrew. > -----Original Message----- > From: Maxime Th=E9bault [mailto:webmaster@stripped] > Sent: 04 October 2012 17:22 > To: cluster@stripped > Subject: Re: Problem with memcached >=20 > Thanks for your answer ! >=20 > I check in my ndb_1_cluster.log and i have this line : > 2012-10-04 18:10:39 [MgmtSrvr] WARNING -- Failed to allocate nodeid for > API at 2.2.2.2. Returned eror: 'No free node id found for mysqld(API).' > 2012-10-04 18:10:42 [MgmtSrvr] WARNING -- Failed to allocate nodeid for > API at 2.2.2.2. Returned eror: 'No free node id found for mysqld(API).' >=20 >=20 > But when i run on my manager ndb_mgm -e show i have this : >=20 > ndb_mgm> show > Connected to Management Server at: localhost:1186 Cluster Configuration > --------------------- > [ndbd(NDB)] 2 node(s) > id=3D3 @1.1.1.1 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0) > id=3D4 @2.2.2.2 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0, Master) >=20 > [ndb_mgmd(MGM)] 2 node(s) > id=3D1 @3.3.3.3 (mysql-5.5.22 ndb-7.2.6) > id=3D2 @4.4.4.4 (mysql-5.5.22 ndb-7.2.6) >=20 > [mysqld(API)] 14 node(s) > id=3D5 @2.2.2.2 (mysql-5.5.22 ndb-7.2.6) > id=3D6 @1.1.1.1 (mysql-5.5.22 ndb-7.2.6) > id=3D7 (not connected, accepting connect from any host) > id=3D8 (not connected, accepting connect from any host) > id=3D9 (not connected, accepting connect from any host) > id=3D10 (not connected, accepting connect from any host) > id=3D11 (not connected, accepting connect from any host) > id=3D12 (not connected, accepting connect from any host) > id=3D13 (not connected, accepting connect from any host) > id=3D14 (not connected, accepting connect from any host) > id=3D15 (not connected, accepting connect from any host) > id=3D16 (not connected, accepting connect from any host) > id=3D17 (not connected, accepting connect from any host) > id=3D18 (not connected, accepting connect from any host) >=20 > Twelve free nodes... I have 14 empty [MYSQLD] in my manager config file. > I must specific option in this sections ? >=20 > Maxime >=20 > Le 04/10/2012 18:02, Andrew Morgan a =E9crit : > > Hi Maxime, could you please check the Cluster log (it should be located > with the ndb_mgmd) to see if there's evidence of the memcached trying to > connect? Otherwise, double check that the connect string is for the corre= ct > host and port for the ndb_mgmd and that there are no firewall rules that > would block communication between these hosts. > > > > Regards, Andrew. > > > > Andrew Morgan | MySQL Principal Product Manager > > Mobile: +447833483595 > > Web: www.clusterdb.com > > United Kingdom > > > > ORACLE Corporation UK Ltd is a company incorporated in England & Wales > > | Company Reg. No. 1782505 | Reg. office: Oracle Parkway, Thames > > Valley Park, Reading RG6 1RA > > > >> -----Original Message----- > >> From: Maxime Th=E9bault [mailto:webmaster@stripped] > >> Sent: 04 October 2012 09:56 > >> To: cluster@stripped > >> Subject: Problem with memcached > >> > >> Hello, > >> > >> I try to configure memcached on my mysql cluster but i have an error. > >> > >> Result of ndb_mgm -e show : > >> ndb_mgm -e show > >> Connected to Management Server at: 3.3.3.3:1186 Cluster Configuration > >> --------------------- > >> [ndbd(NDB)] 2 node(s) > >> id=3D3 @1.1.1.1 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0) > >> id=3D4 @2.2.2.2 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0, Master) > >> > >> [ndb_mgmd(MGM)] 2 node(s) > >> id=3D1 @3.3.3.3 (mysql-5.5.22 ndb-7.2.6) > >> id=3D2 @4.4.4.4 (mysql-5.5.22 ndb-7.2.6) > >> > >> [mysqld(API)] 14 node(s) > >> id=3D5 @2.2.2.2 (mysql-5.5.22 ndb-7.2.6) > >> id=3D6 @1.1.1.1 (mysql-5.5.22 ndb-7.2.6) > >> id=3D7 (not connected, accepting connect from any host) > >> id=3D8 (not connected, accepting connect from any host) > >> id=3D9 (not connected, accepting connect from any host) > >> id=3D10 (not connected, accepting connect from any host) > >> id=3D11 (not connected, accepting connect from any host) > >> id=3D12 (not connected, accepting connect from any host) > >> id=3D13 (not connected, accepting connect from any host) > >> id=3D14 (not connected, accepting connect from any host) > >> id=3D15 (not connected, accepting connect from any host) > >> id=3D16 (not connected, accepting connect from any host) > >> id=3D17 (not connected, accepting connect from any host) > >> id=3D18 (not connected, accepting connect from any host) > >> > >> But when i execute the command from 1.1.1.1 (api node) : > >> memcached -E /usr/local/mysql/lib/ndb_engine.so -u mysql -e > >> "connectstring=3D3.3.3.3:1186;role=3Ddb-only;debug=3Dtrue" -vv -c 20 > >> (3.3.3.3 is the manager) > >> > >> The result is : > >> > >> main --> ndb_initialize() > >> main --> connect_to_primary_cluster() > >> 04-Oct-2012 10:54:42 CEST NDB Memcache 5.5.22-ndb-7.2.6 started [NDB > >> 7.2.6; MySQL 5.5.22] Contacting primary management server > >> (37.59.48.15:1186) ... > >> main --> ClusterConnectionPool::connect() FAILED. > >> Could not connect to NDB. Shutting down. > >> main --> ndb_destroy() > >> Failed to initialize instance. Error code: 255 > >> > >> I try with localhost, without connectstring... > >> > >> Can you help me ? > >> > >> Many thanks ! > >> > >> > >> > >> > >> -- > >> MySQL Cluster Mailing List > >> For list archives: http://lists.mysql.com/cluster > >> To unsubscribe: http://lists.mysql.com/cluster > >> > > > > > > >=20 >=20 > -- > MySQL Cluster Mailing List > For list archives: http://lists.mysql.com/cluster > To unsubscribe: http://lists.mysql.com/cluster >=20