MySQL Bugs: #43717: i don't know what happen

Bug #43717	i don't know what happen
Submitted:	18 Mar 2009 3:49	Modified:	29 Mar 2011 19:01
Reporter:	Roberto Spadim (Basic Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S1 (Critical)
Version:	db 5.1.32,	OS:	Linux
Assigned to:		CPU Architecture:	Any
Tags:	ndb, qc

Description:
ndb_mgmd computer and ndbd node 2 machine:

[root@SPADIM test]# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2    @200.161.132.95  (Version: 5.1.32, starting, Nodegroup: 0)
id=3 (not connected, accepting connect from 172.16.0.4)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @200.161.132.95  (Version: 5.1.32)

[mysqld(API)]   3 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)

ndb_mgm> Node 2: Forced node shutdown completed. Occured during startphase 3. Caused by error 2350: 'Invalid configuration received from Management Server(Configuration error). Permanent error, external action needed'.
show
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2 (not connected, accepting connect from 200.161.132.95)
id=3    @172.16.0.4  (Version: 5.1.32, starting, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @200.161.132.95  (Version: 5.1.32)

[mysqld(API)]   3 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)

ndb_mgm> Node 2: Forced node shutdown completed. Occured during startphase 1. Caused by error 2341: 'Internal program error (failed ndbrequire)(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'.
Node 3: Forced node shutdown completed. Occured during startphase 1. Caused by error 2308: 'Another node failed during system restart, please investigate error(s) on other node(s)(Restart error). Temporary error, restart node'.

node 3 machine (ndbd)

[root@raja2 cluster]# ndbd --ndb-mgmd-host=172.16.0.254
(work for a time, after node 2 and node 3 errors (ndb_mgm) all ndbd process stop working (node 2 and 3)

i don't know what to do

How to repeat:
? could i send some files?

This is not a bug, but rather expected behaviour when the cluster is misconfigured.

"Node 2: Forced node shutdown completed. Occured during startphase 3. Caused by
error 2350: 'Invalid configuration received from Management Server(Configuration error).
Permanent error, external action needed'." -> This usually means that you've a problem in your config.ini file.

From ndb_2.zip/ndb_pid25253_error.log: "Could not alloc node id at 172.16.0.254 port 1186: Connection with id 2 done from wrong host ip 172.16.0.254, expected 200.161.132.95(200.161.132.95)." -> The data node is connecting from the wrong IP address (not the one assigned to it in your config.ini).

Also, we don't support NDB in the regular 5.1 server - please use the latest MySQL Cluster NDB 6.2 or 6.3 release. See http://dev.mysql.com/downloads/cluster/ for binary and source code packages.

Also please do not use the bug system for asking questions about how to use the product - you can get free help and answers to questions from our User Forums and Mailing Lists.

MySQL Cluster User Forum: http://forums.mysql.com/list.php?25

MySQL Cluster User Mailing List: http://lists.mysql.com/cluster (cluster@lists.mysql.com)

Thanks!

You may also want to consult the documentation at http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-multi-computer.html and http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-config-file.html

i posted cause of this:

Node 2: Forced node shutdown completed. Occured during startphase 1. Caused by
error 2341: 'Internal program error (failed ndbrequire)(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'.

"please report a bug"

any idea or problem?
see ./configure database options:

./configure --with-plugins=max --prefix=/usr --libexecdir=/usr/sbin \
    --localstatedir=/var --sysconfdir=/etc \
    --without-debug --without-docs --without-readline \
    --with-plugins=partition --enable-local-infile --with-ssl \
    --with-charset=latin1 --with-collation=latin1_general_ci \
    --with-extra-charsets=complex --enable-thread-safe-client \
    --with-libwrap --with-ndbcluster

closed since it´s working in newer nbd version