MySQL Forums
Forum List  »  NDB clusters

NDB's status - Starting (Phase 1) - Never finishes?
Posted by: Adam Priest
Date: October 26, 2006 09:36AM

So I'm setting up a cluster, as much to test it and see if it'll do what we need as anything else. Just a 4 machine setup with one running the Management Node and three running both a ndb node and an SQL node each.

The ndbs appear to connect fine, though their "status" shows
> Node 2: starting (Phase 1) (Version 5.0.26)

And the log as they start up shows
> 2006-10-26 18:32:58 [ndbd] INFO -- NDB Cluster -- DB node 3
> 2006-10-26 18:32:58 [ndbd] INFO -- Version 5.0.26 --
> 2006-10-26 18:32:58 [ndbd] INFO -- Configuration fetched at mojojojo.gemin-i.org port 1186
> 2006-10-26 18:32:59 [ndbd] INFO -- Start initiated (version 5.0.26)

And the SQL *pretends* to connect in that when I start it the cluster log shows
> 2006-10-26 18:21:24 [MgmSrvr] INFO -- Mgmt server state: nodeid 6 reserved for ip 87.240.129.93, m_reserved_nodes 0000000000000042.
> 2006-10-26 18:21:24 [MgmSrvr] INFO -- Node 6: mysqld --server-id=0

And when I do "show Variables" it says
> have_ndbcluster | YES

And when I stop the SQLd it shows
> 2006-10-26 18:22:33 [MgmSrvr] INFO -- Mgmt server state: nodeid 6 freed, m_reserved_nodes 0000000000000002.

Yet whenever I tell the Management Console to "show" it says
> id=6 (not connected, accepting connect from snake.gemin-i.org)

So that's pretty weird I reckon, Can't find any other error reports in any of the logs, and obviously with the SQL connection not actually getting through to the Management server it gives the (fairly misleading) "table already exists" error which "show warnings" reduces down to:
> | Error | 1296 | Got error 4009 'Cluster Failure' from NDB |

So presumably even though they connect enough to show they're "starting", the ndb nodes aren't managing to finish off their startup, while refusing to give an error explaining why either.

Leaving this clustering newbie a bit stuck.

Anyone got any ideas?



Edited 2 time(s). Last edit at 10/26/2006 09:46AM by Adam Priest.

Options: ReplyQuote


Subject
Views
Written By
Posted
NDB's status - Starting (Phase 1) - Never finishes?
2537
October 26, 2006 09:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.