5 messages in com.mysql.lists.clusterRe: Cluster works, ndb_desc and other...
FromSent OnAttachments
Marcin Hłybin21 Jan 2008 12:11 
Augusto Bott21 Jan 2008 12:19 
Marcin Hłybin21 Jan 2008 12:23 
Adam Dixon21 Jan 2008 13:09 
Marcin Hłybin22 Jan 2008 02:11 
Subject:Re: Cluster works, ndb_desc and other tools don't.
From:Marcin Hłybin (mar@rootnode.pl)
Date:01/22/2008 02:11:10 AM
List:com.mysql.lists.cluster

On Monday 21 January 2008 22:09, Adam Dixon wrote:

Hello,

On Jan 22, 2008 6:53 AM, Marcin Hłybin <mar@rootnode.pl> wrote: ...

That was my first guess also. I have added empty [MYSQLD] to ndb-mgm config earlier.

...

Log file: 2008-01-21 22:20:28 [MgmSrvr] INFO -- Mgmt server state: nodeid 6 reserved for ip 10.0.0.1, m_reserved_nodes 0000000000000042.

2008-01-21 22:20:59 [MgmSrvr] INFO -- Mgmt server state: nodeid 6 freed, m_reserved_nodes 0000000000000002.

Please show your config.ini, did you restart your ndb_mgmd after config change?

# cat /etc/mysql/ndb_mgmd.cnf [NDBD DEFAULT] NoOfReplicas=2 DataMemory=10MB IndexMemory=25MB MaxNoOfTables=256 MaxNoOfOrderedIndexes=256 MaxNoOfUniqueHashIndexes=128

[MYSQLD DEFAULT]

[NDB_MGMD DEFAULT]

[TCP DEFAULT]

[NDB_MGMD] Id=1 HostName=10.0.0.1 # management node

[NDBD] Id=2 HostName=10.0.0.1 # data node DataDir= /var/lib/mysql-cluster

[NDBD] Id=3 HostName=10.0.0.2 # data node DataDir=/var/lib/mysql-cluster

[MYSQLD] Id=4 # sql node HostName=10.0.0.1

[MYSQLD] Id=5 # sql node HostName=10.0.0.2

[MYSQLD]

ndb_mgm> show

# ndb_mgm -e show Connected to Management Server at: 10.0.0.1:1186 Cluster Configuration --------------------- [ndbd(NDB)] 2 node(s) id=2 @10.0.0.1 (Version: 5.0.32, Nodegroup: 0, Master) id=3 @10.0.0.2 (Version: 5.0.32, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s) id=1 @10.0.0.1 (Version: 5.0.32)

[mysqld(API)] 3 node(s) id=4 @10.0.0.1 (Version: 5.0.32) id=5 @10.0.0.2 (Version: 5.0.32) id=6 (not connected, accepting connect from any host)

If you see a free node id to use such as '8' or something you can use --ndb-nodeid=8 argument.

It is very interesting. Firstly I tried to run with --ndb-nodeid=6. It didn't work. Then I tried to run ndb_desc without any parameters one more time and it started to work. Strange.

NDBT_ProgramExit: 0 - OK

If you still have no luck, also provide paste of your ndb_mgm> show output.

Definitely in luck :) For other guys with the same problem: SOLUTION is to add [MYSQLD] string at the end of ndb-mgm config file.

Thank you for your time.

-- M.