MySQL Forums
Forum List  »  NDB clusters

Queries cause cluster failure...
Posted by: Jim Mchugh
Date: June 22, 2006 01:00AM

Hello all!!!

I'm new to the forums but I'm sure you guys can help.

I've set up a simple two node MySQL cluster using the examples that MySQL release.

Two machines with one management system. MySQL Max with MDB Storage.

Everything work fine! Tables are clustered across stroage nodes etc etc. Look at my management node output:

ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @190.170.66.91 (Version: 5.0.16, Nodegroup: 0)
id=3 @190.170.66.92 (Version: 5.0.16, Nodegroup: 0, Master)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @190.170.66.81 (Version: 5.0.16)

[mysqld(API)] 2 node(s)
id=4 @190.170.66.91 (Version: 5.0.16)
id=5 @190.170.66.92 (Version: 5.0.16)

Beautiful!!!

Until I fire a bunch of queries at it!

Then it just collapses and the management node logs the following:

ndb_mgm> Node 2: Forced node shutdown completed. 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, restart node'.
Node 3: Forced node shutdown completed. 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, restart node'.

What is going on????

There's not much point in a high availability MySQL CLuster that falls over when you query it!

I've got loads of memory etc.

Any ideas???

Jim Mchugh

Options: Reply• Quote


Subject
Views
Written By
Posted
Queries cause cluster failure...
2169
June 22, 2006 01:00AM


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.