Re: Gentoo Linux and NDBD doestn work

On Sun, 2007-09-09 at 15:06 +0200, Norbert Schmidt wrote:
> Hello,
>
> i think i have found a problem with Gentoo Linux and MySQL-5.0.45.
>
> Im trying to configure a MySQL.-Cluster but it doesnt work.
>
> The Problem is that the NDBD-Node doesnt connect to the Management Node,
> the NDBD Node stops with the status "starting", i dont know where is the
> Problem,
>

If the node registers with the ndb_mgm console as "starting" it has connected to the management node and received its configuration.

> Cluster Configuration
> ---------------------
> [ndbd(NDB)] 2 node(s)
> id=1 @127.0.0.1 (Version: 5.0.45, starting, Nodegroup: 0)
> id=2 (not connected, accepting connect from 192.168.1.109)
>
> [ndb_mgmd(MGM)] 1 node(s)
> id=3 @192.168.1.109 (Version: 5.0.45)
>
> [mysqld(API)] 1 node(s)
> id=4 (not connected, accepting connect from any host)
>
>
> ndb_1_out.log shows this
>
> 2007-09-09 14:37:55 [ndbd] INFO -- Angel pid: 22910 ndb pid: 22911
> 2007-09-09 14:37:55 [ndbd] INFO -- NDB Cluster -- DB node 1
> 2007-09-09 14:37:55 [ndbd] INFO -- Version 5.0.45 --
> 2007-09-09 14:37:55 [ndbd] INFO -- Configuration fetched at
> 127.0.0.1 port 1186
> 2007-09-09 14:37:55 [ndbd] INFO -- Start initiated (version
> 5.0.45)
>
> ndb_3_cluster.log shows this
>
> 2007-09-09 14:46:09 [MgmSrvr] INFO -- Node 1: Initial start,
> waiting
> for 0000000000000004 to connect, nodes [ all: 0000000000000006
> connected: 0000000000000002 no-wait: 0000000000000000 ]

Here the log shows node 1 is waiting for node 2 to connect to the MGM node before attempting to perform an initial start.

On initial start ndbd waits for all other nodes in the cluster to begin startup for StartPartialTimeout (30sec) and StartPartitionedTimeout (60sec) before attempting to initialize the cluster to avoid a partial or network partitioned startup.

Either start the 2nd ndbd process or wait the default full 1m30s and the 1st ndbd node should start.

> the config.ini
>
> [tcp default]
> [ndbd default]
> NoOfReplicas=2
> [mysqld default]
> [ndb_mgmd default]
> datadir=/home/norbi/mysql-5.0.45/var/mysql-cluster
> [ndbd]
> id=1
> hostname=192.168.1.109
> datadir=/home/norbi/mysql-5.0.45/var/mysql-cluster
> [ndbd]
> id=2
> hostname=192.168.1.109
> datadir=/home/norbi/mysql-5.0.45/var/mysql-cluster
> [ndb_mgmd]
> id=3
> hostname=192.168.1.109
> [mysqld]
>
>
>
>

-- 
Matthew Montgomery, Support Engineer
San Antonio, TX
MySQL Inc, www.mysql.com


-- 
MySQL Cluster Mailing List
For list archives: 
http://lists.mysql.com/cluster
To unsubscribe:    
http://lists.mysql.com/cluster?unsub=lists@pantek.com