MySQL Forums
Forum List  »  NDB clusters

ERROR 1005 (HY000): Can't create table (errno: 4336)
Posted by: Alan Aldrich
Date: December 29, 2005 05:20PM

I have set up a minimal cluster with 1 manager, 2 data nodes and 2 sql nodes
though the data nodes and sql nodes are the same two servers. Is this legal?

It seems to be setup correctly but when I go onto one of the sql servers and try to create a table using the syntax
mysql> create table btest (i int) engine=ndb;
I get this error
ERROR 1005 (HY000): Can't create table './foo/btest.frm' (errno: 4336)

my.cnf on each data and sql node looks like this
[mysqld]
ndbcluster
ndb-connectstring=192.168.44.130
[mysql_cluster]
ndb-connectstring=192.168.44.130


and config.ini on the manaemnet node looks like this

[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=80M
IndexMemory=18M
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
# Managment Server
[NDB_MGMD]
HostName=192.168.44.130 # the IP of THIS SERVER
# Storage Engines
[NDBD]
HostName=192.168.44.128 # the IP of the FIRST SERVER
DataDir= /var/lib/mysql-cluster
[NDBD]
HostName=192.168.44.129 # the IP of the SECOND SERVER
DataDir=/var/lib/mysql-cluster
# 2 MySQL Clients
[MYSQLD]
[MYSQLD]

This is Mysql 4.1.15 on FreeBSD 5.4

ndb_mgm shows this
oot@ndbmgr# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.44.128 (Version: 4.1.15, Nodegroup: 0, Master)
id=3 @192.168.44.129 (Version: 4.1.15, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.44.130 (Version: 4.1.15)

[mysqld(API)] 2 node(s)
id=4 @192.168.44.129 (Version: 4.1.15)
id=5 @192.168.44.128 (Version: 4.1.15)

ndb_mgm>

Any clues as to what I have wrong?

Options: ReplyQuote


Subject
Views
Written By
Posted
ERROR 1005 (HY000): Can't create table (errno: 4336)
2593
December 29, 2005 05:20PM


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.