ERROR 1005 (HY000): Can't create table './temp/foo.frm' (errno: 4009)

[Chris Waterson]

Hi there! I'm trying to do some testing with MySQL Cluster 4.1.9. I have a bunch of Linux boxes, each with a variable amount of memory; in order to create as large a database as possible, I'm trying to run multiple ndbd's per host. This all works great, until I try to add a PRIMARY KEY index to my table. Doing so causes mysql to return the following:

mysql> CREATE TABLE foo (foo_id INT NOT NULL PRIMARY KEY);
ERROR 1005 (HY000): Can't create table './temp/foo.frm' (errno: 4009)

And what's worse, every ndbd crashes! Here's a sample ndb_X_error.log:

Date/Time: Thursday 17 February 2005 - 02:08:50
Type of error: error
Message: Internal program error (failed ndbrequire)
Fault ID: 2341
Problem data: DbtuxMeta.cpp
Object of reference: DBTUX (Line: 132) 0x0000000e
ProgramName: ndbd
ProcessID: 4529
TraceFile: /home/waterson/mysql/cluster/ndb_6_trace.log.1
***EOM***

Now, this all works fine so long as I either:

1. Don't add a PRIMARY KEY to my CREATE TABLE, or
2. Don't run more than one ndbd per host.

Is this a known problem? Or am I just chundering the configuration somehow? Here's my config.ini:

[NDBD DEFAULT]
NoOfReplicas=2
DataDir=/home/waterson/mysql/cluster
DataMemory=512MB
IndexMemory=512MB
#Diskless=Y
#LockPagesInMainMemory=Y
MaxNoOfConcurrentOperations=500000
[NDB_MGMD]
HostName= dev4.pants.callcast.vpn
DataDir=/home/waterson/mysql/cluster
[NDBD]
HostName=dev1.pants.callcast.vpn
[NDBD]
HostName=dev3.pants.callcast.vpn
[NDBD]
HostName=dev1.pants.callcast.vpn
[NDBD]
HostName=dev4.pants.callcast.vpn
[NDBD]
HostName=dev1.pants.callcast.vpn
[NDBD]
HostName=dev5.pants.callcast.vpn
[NDBD]
HostName=devdb.liveops.com
[NDBD]
HostName=dev5.pants.callcast.vpn
[NDBD]
HostName=dev4.pants.callcast.vpn
[NDBD]
HostName=dev5.pants.callcast.vpn
[MYSQLD]
[MYSQLD]
[MYSQLD]

Thanks in advance for any advice...

chris