Cannot Create A NDB Data Warehouse

[Dan Gruhn]

Greetings,

I'm having a problem getting 4.1.8 to create a data warehouse that I've used just fine for a long time in a non-cluster environment. I've downloaded the tar/gz file mysql-max-4.1.8-pc-linux-i686.tar.gz and installed it.

Here are the commands that I run and their output:

> mysqladmin -f drop dgruhn_dw
Database "dgruhn_dw" dropped
> mysqladmin create dgruhn_dw
> mysql dgruhn_dw <dw_schema

ERROR 1005 at line 352: Can't create table './dgruhn_dw/#sql-117c_2d.frm' (errno: 4009)

The schema file I'm using is failing at line 352, which is the following:

ALTER TABLE AirAssetConfiguration ADD UNIQUE (ConfigurationName, SignatureName, FuelConfigurationName);

We've found it is faster to create tables and then add indexes later, so this point in the schema file is just adding new indexes to tables. We have about 188 tables and the rest of the almost 5000 lines of the schema file are adding indexes and inserting values to the tables (we fail before getting to the insertions).

When I look at the NDB error log, I see the following:

Date/Time: Thursday 30 December 2004 - 12:01:34
Type of error: error
Message: Internal program error (failed ndbrequire)
Fault ID: 2341
Problem data: Suma.cpp
Object of reference: SUMA (Line: 1355) 0x0000000c
ProgramName: /usr/local/mysql/bin/ndbd
ProcessID: 11773
TraceFile: /var/lib/mysql-cluster/ndb_2_trace.log.1
***EOM***

The line in Suma.cpp being referenced is the following:
...
// The attribute buffer
LocalDataBuffer<15> attrBuf(c_dataBufferPool, tabPtr.p->m_attributes);

// Temporary buffer
DataBuffer<15> theRest(c_dataBufferPool);

if(!attrBuf.seize(noAttribs)){
ndbrequire(false); <-----------------------------------------------
return false;
}
...

It seems that I'm having a problem with not enough attributes being allocated. However, I've played with a number of parameters and can't seem to get beyond this point. Here is my config.ini file:

[NDBD DEFAULT]
NoOfReplicas = 1

[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]

[NDB_MGMD]
HostName = analyst04-lx.group-w-inc.com

[NDBD]
HostName = analyst04-lx.group-w-inc.com
DataDir = /var/lib/mysql-cluster
MaxNoOfTables = 1600
DataMemory = 512MB
IndexMemory = 512MB
MaxNoOfAttributes = 32767
MaxNoOfOrderedIndexes = 2048
MaxNoOfUniqueHashIndexes = 2048
MaxNoOfTriggers = 4096
Diskless = Y
StopOnError = N

[MYSQLD]
...

I've got about 2 GB available on the analyst04 machine, which it seems like should be more than enough to at least create the warehouse. That machine is running the manager and the NDB, but no server. My local machine is running a server.


1) How can I check the values of various parameters to see if I'm setting them correctly?

2) Are there some better values I could use for the parameters I'm setting?

3) Are there some other parameters I should be modifying as well?

4) Does anyone have any other ideas what I could try or where I could look?

Thanks,

Dan Gruhn