________________________________

From: davi...@gmail.com [mailto:davi...@gmail.com] On Behalf Of Alex Davies Sent: 20 April 2006 15:19 To: Simon Jones Cc: clus...@lists.mysql.com Subject: Re: Cluster error

Can you post the recent lines in the error log on the node that is failing to start (node 3; these will be in the DataDir on that node)?

Alex

On 20/04/06, Simon Jones <Sim...@saq.co.uk> wrote:

Hi,

I've had a stable mysql cluster running for a week, node 2 fell over today and I can not get it to connect to the cluster.

When I do: /usr/local/mysql/bin/ndbd

Then check the management server I get:

ndb_mgm> show Cluster Configuration --------------------- [ndbd(NDB)] 2 node(s) id=2 @10.0.0.150 (Version: 5.0.19, Nodegroup: 0, Master) id=3 @ 10.0.0.151 <http://10.0.0.151> (Version: 5.0.19, starting, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s) id=1 @10.0.0.60 (Version: 5.0.19)

[mysqld(API)] 2 node(s) id=4 @ 10.0.0.150 <http://10.0.0.150> (Version: 5.0.19) id=5 (not connected, accepting connect from any host)

ndb_mgm> Node 3: Node shutdown completed. Initiated by signal 15. Node 3: Forced node shutdown completed. Occured during startphase 2. Initiated by signal 0. Caused by error 2341: 'Internal program error (failed ndbrequire)(Internal error, programming error or missing error message, please report a bug). Temporary error

If I do: /usr/local/mysql/bin/ndbd --initial

Then check the management server there is no reported error but the node does not connect:

ndb_mgm> show Connected to Management Server at: localhost:1186 Cluster Configuration --------------------- [ndbd(NDB)] 2 node(s) id=2 @10.0.0.150 (Version: 5.0.19, Nodegroup: 0, Master) id=3 @10.0.0.151 (Version: 5.0.19, starting, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s) id=1 @10.0.0.60 (Version: 5.0.19)

[mysqld(API)] 2 node(s) id=4 @10.0.0.150 (Version: 5.0.19) id=5 (not connected, accepting connect from any host)

ndb_mgm>

Can anyone help?

Simon Jones SAQ Internet www.saq.co.uk sim...@saq.co.uk

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

-- Alex Davies // http://www.davz.net

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender immediately by e-mail and delete this e-mail permanently.

Contact me - MSN: a_d...@hotmail.com SKYPE: alex.davies

-- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.4.4/319 - Release Date: 19/04/2006