NDB Fails On Loading Complex Data Warehouse

[Dan Gruhn]

Mikael/Dean, after your help on the previous problem we had with getting a data warehouse schema loaded, I hope you can help us with this one. Same data warehouse but it is now failing on loading.

We're getting the following error message:

ERROR 1105 at line 1466: Unknown error

when trying to load a complex data warehouse. Below is the cluster config file.

It doesn't seem like we are running into any parameter limits, and we've turned on logging and are not running out of memory, at least any that the logging shows.

I'm also going to attach a tarball with a directory that contains the necessary files plus a bash script called "testload" which should recreate the error.

In the set of files, the file "dw_data" is the mysql command input which, after everything is set up, tries to load in the data. There is also a "dw_data.short" file which will take you just up to the failure point.

We think we may need to increase some parameter, but can't seem to find the right combination.

# file "config.ini" - showing minimal setup consisting of 1 DB node,
# 1 management server, and 4 MySQL servers.
#
[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 = 1280MB
IndexMemory = 1024MB
MaxNoOfAttributes = 8192
MaxNoOfOrderedIndexes = 8192
MaxNoOfUniqueHashIndexes = 8192
MaxNoOfTriggers = 8192
Diskless = Y
StopOnError = N

[MYSQLD]
HostName = class01-lx.group-w-inc.com

[MYSQLD]
HostName = class02-lx.group-w-inc.com

[MYSQLD]
HostName = class03-lx.group-w-inc.com

[MYSQLD]
HostName = dgruhn-lx.group-w-inc.com

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