Table Create Error 1071 (42000)
I am trying to create my database on a 2-node cluster on SuSE Ent 9 on Intel. My machines are 2Gb RAM, and dedicated to this. I have successfully used the same schema on an InnoDB, and in this case I am only attempting to create the raw tables (at this stage, have not attempted to apply data or constraints).
I have a script that contains 121 tables, which when run against the cluster, creates only 120 tables. One one of the tables, I get an error that the key was too long. This is funny, as the key is a bigint, like about 75 of the other tables that get created in the database. I have included the config.ini at the bottom if this will help.
mysql> create table SE_FUNCTION (
-> SE_ID BIGINT NOT NULL AUTO_INCREMENT,
-> SE_VERSION INTEGER not null,
SE_FUNCTIONGROUP_ID BIGINT,
-> SE_FUNCTIONGROUP_ID BIGINT,
-> SE_DESCRIPTION TEXT,
-> SE_DISPLAYID VARCHAR(100) unique,
-> SE_NAME VARCHAR(100) not null,
SE_PRINCIPLEKEY VARCHAR(30),
-> SE_PRINCIPLEKEY VARCHAR(30),
-> SE_CREATEDBY VARCHAR(30),
-> SE_CREATEDDATETIME DATETIME,
-> SE_MODIFIEDBY VARCHAR(30),
SE_MODIFIEDDATETIME DATETIME,
-> SE_MODIFIEDDATETIME DATETIME,
-> primary key (SE_ID)
-> ) ENGINE=NDBCLUSTER DEFAULT CHARSET=utf8;
ERROR 1071 (42000): Specified key was too long; max key length is 255 bytes
mysql> ERROR 1071 (42000)
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=500M
IndexMemory=200M
MaxNoOfAttributes=50000
MaxNoOfTables=250
MaxNoOfOrderedIndexes=500
MaxNoOfUniqueHashIndexes=500
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
# Management Server
[NDB_MGMD]
Id=1
HostName=192.168.16.3 #Private IP of ndm_mgmd
#HostName=192.168.168.57 #Public IP of ndb_mgmd
# Storage Engines
[NDBD]
Id=2
HostName=192.168.16.4 #Private IP of ndbd 1
#HostName=192.168.168.93 #Public IP of ndbd 1
DataDir=/usr/local/mysql/data_ndb
[NDBD]
Id=3
HostName=192.168.16.5 #Private IP of ndbd 2
#HostName=192.168.168.105 #Public IP of ndbd 2
DataDir=/usr/local/mysql/data_ndb
# MySQL Daemons
[MYSQLD]
Id=4
hostname=192.168.16.4 #Private IP of mysqld 1
#hostname=192.168.168.93 #Public IP of mysqld 1
[MYSQLD]
Id=5
hostname=192.168.16.5 #Private IP of mysqld 2
#hostname=192.168.168.105 #Public IP of mysqld 2