Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Got a problem with a MySQL Cluster,

All the nodes connect fine to the ndb management node, however when I try to create a table on one of the nodes it returns this error :

mysql> use foo;
Database changed
mysql> create table bar (i int) engine=ndbcluster;
ERROR 1005 (HY000): Can't create table '' (errno: 157)

I check my nodes, and get this :

-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: X.X.X.X:1186
Cluster Configuration
[ndbd(NDB)]     1 node(s)
id=2    @X.X.X.X  (Version: 5.1.34, Nodegroup: 0, Master)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @X.X.X.X  (Version: 5.1.34)

[mysqld(API)]   4 node(s)
id=3    @X.X.X.X  (Version: 5.1.34)
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)


so all looks good,

heres some version stuff .

FreeBSD 7.1-RELEASE FreeBSD 7.1-RELEASE #0: Tue May 12 10:12:51 CAT 2009  i386

/usr/local/libexec/mysqld  Ver 5.1.34 for portbld-freebsd7.1 on i386 (FreeBSD port: mysql-server-5.1.34)

MySQL distrib 5.1.34, for portbld-freebsd7.1 (i386) compiled with --with-ndbcluster --with-plugins=max

Any assistance will be most appreciated.

share|improve this question

Try restarting the cluster. First bring the management node online, then the servers. I think this is a race condition (well sort of). Let me know if this works.

share|improve this answer
Thanks for the input, tried rolling restarts to no effect, think I am just going to bite the bullet and use debian for this. – Bruce Grobler Jun 1 '09 at 10:38

Management node seems fine, but you have no data nodes. You need to get /usr/sbin/ndbd running correctly on data nodes....why it's not in probably in your my.cnf file.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.