Queries cause cluster failure...
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
Subject
Views
Written By
Posted
Queries cause cluster failure...
2169
June 22, 2006 01:00AM
1286
June 28, 2006 12:24AM
1356
June 28, 2006 11:46AM
1274
June 28, 2006 10:25PM
1248
June 28, 2006 06:22PM
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.