NDBD initial problems

[Darren Collins]

I cannot get ndbd --initial to run. I am trying to set up a 3 node cluster (2 data 1 mgmt). When I run ndbd from either data node, I get the following:

[root@lghdevsr3 mysql-cluster]# ndbd --initial
Unable to connect with connect string: nodeid=0,10.0.0.7:1186
Retrying every 5 seconds. Attempts left: 12

If you let the ndbd retry until it times out, you get the error message and log file, shown at the very end.

ANY suggestions on where to go from here, or what might/is wrong??


Thanks

Configuration information:


********************************************
config.ini
********************************************
[ndbd default]
NoOfReplicas=2
DataMemory=80M
IndexMemory=18M
DataDir=/var/lib/mysql-cluster

[ndb_mgmd default]
DataDir=/var/lib/mysql-cluster

[ndb_mgmd]
hostname=10.0.0.7
datadir=/var/lib/mysql-cluster
ArbitrationRank=1

[ndbd]
hostname=10.0.0.8
datadir=/sqldata

[ndbd]
hostname=10.0.0.9
datadir=/sqldata

[mysqld]
hostname=10.0.0.8

[mysqld]
hostname=10.0.0.8
********************************************
END
********************************************

********************************************
ndb_mgm show
********************************************
Connected to Management Server at: 10.0.0.7:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 (not connected, accepting connect from 10.0.0.8)
id=3 (not connected, accepting connect from 10.0.0.9)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.0.0.7 (Version: 5.1.9)

[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from 10.0.0.8)
id=5 (not connected, accepting connect from 10.0.0.8)
********************************************
END
********************************************

********************************************
my.cnf
********************************************
[mysql.server]
user=mysql

[client]
port=3306
socket=/var/lib/mysql/mysql.sock
default-character-set=latin1

[mysqld]
ndbcluster # run NDB engine
ndb-connectstring=10.0.0.7 # location of MGM node
port=3306
socket=/var/lib/mysql/mysql.sock
basedir=/usr
datadir=/sqldata
default-character-set=latin1
default-storage-engine=NDBCLUSTER
max_connections=341
query_cache_size=16M
thread_concurrency = 8

table_cache=700
tmp_table_size=16M
thread_cache_size=8
log_bin=mysql-bin
server-id = 1
log_warnings
log_slow_queries
long_query_time = 2
log_long_format
transaction_isolation = READ-COMMITTED

key_buffer_size=100M
read_buffer_size=1M
read_rnd_buffer_size=4M
sort_buffer_size=1M

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[mysqlhotcopy]
interactive-timeout

[mysqld_safe]
open-files-limit = 8192
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysql_cluster]
ndb-connectstring=10.0.0.7 # location of MGM node

[ndbd]
connect-string=10.0.0.7

[ndb_mgm]
connect-string=10.0.0.7

[ndb_mgmd]
config-file=/var/lib/mysql-cluster/config.ini
********************************************
END
********************************************

********************************************
netstat -tulnp
********************************************
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:32769 0.0.0.0:* LISTEN 2325/rpc.statd
tcp 0 0 0.0.0.0:1186 0.0.0.0:* LISTEN 10245/ndb_mgmd
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN 2305/portmap
tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN 2457/cupsd
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 4940/sendmail: acce
tcp 0 0 :::80 :::* LISTEN 4845/httpd
tcp 0 0 :::22 :::* LISTEN 2493/sshd
tcp 0 0 :::443 :::* LISTEN 4845/httpd
udp 0 0 0.0.0.0:32768 0.0.0.0:* 2325/rpc.statd
udp 0 0 0.0.0.0:805 0.0.0.0:* 2325/rpc.statd
udp 0 0 0.0.0.0:111 0.0.0.0:* 2305/portmap
udp 0 0 0.0.0.0:631 0.0.0.0:* 2457/cupsd
********************************************
END
********************************************


********************************************
ndbd error message
********************************************
[root@lghdevsr3 mysql-cluster]# ndbd --initial -c 10.0.0.7:1186
Unable to connect with connect string: nodeid=0,10.0.0.7:1186
Retrying every 5 seconds. Attempts left: 12 11 10 9 8 7 6 5 4 3 2 1, failed.
error=2350
2006-06-02 14:26:51 [ndbd] INFO -- Error handler restarting system
2006-06-02 14:26:51 [ndbd] INFO -- Error handler shutdown completed - exiting
sphase=0
exit=-1
********************************************
END
********************************************

********************************************
log file content
********************************************
Current byte-offset of file-pointer is: 568
Time: Friday 2 June 2006 - 14:26:51
Status: Permanent error, external action needed
Message: Invalid configuration received from Management Server (Configuration error)
Error: 2350
Error data: Could not connect to ndb_mgmd
Error object:
Program: ndbd
Pid: 6376
Trace: <no tracefile>
Version: Version 5.1.9 (beta)
***EOM***
********************************************
END
********************************************





Edited 2 time(s). Last edit at 06/02/2006 01:35PM by Darren Collins.