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 'foo.bar' (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 my.server.com 7.1-RELEASE FreeBSD 7.1-RELEASE #0: Tue May 12 10:12:51 CAT 2009     sysbg@my.server.com:/usr/obj/usr/src/sys/SEROTONIN-KERNEL  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.

2 Answers 2


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.

  • Thanks for the input, tried rolling restarts to no effect, think I am just going to bite the bullet and use debian for this. Jun 1, 2009 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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