6 messages in com.mysql.lists.clusterRe: Error when batch creating new tab...
FromSent OnAttachments
wb...@dynacraft.com10 Apr 2005 19:10 
wb...@dynacraft.com11 Apr 2005 22:20 
Mikael Ronström11 Apr 2005 23:24 
wb...@dynacraft.com11 Apr 2005 23:30 
Martin Skold12 Apr 2005 02:04 
wb...@dynacraft.com12 Apr 2005 02:11 
Subject:Re: Error when batch creating new tables for engine=ndbcluster
From:Mikael Ronström (mik@mysql.com)
Date:04/11/2005 11:24:40 PM
List:com.mysql.lists.cluster

Error description of 4335 from a newer version:

ndberror.c: { 4335, AE, "Only one autoincrement column allowed per table. Having a table without primary key uses an autoincremented hidden key, i.e. a table without a primary key can not have an autoincremented column" },

Rgrds Mikael

2005-04-12 kl. 07.20 skrev wb@dynacraft.com:

My config.ini look like this

[NDBD DEFAULT]

NoOfReplicas=2

MaxNoOfAttributes=10000

DataMemory=600M

IndexMemory=200M

MaxNoOfOrderedIndexes=20000

MaxNoOfUniqueHashIndexes=20000

MaxNoOfTables=5000

But when I load the sql file for recreating the new tables (about 200 tables) to engine=ndbcluster, I hit the following error where the sql file has created about 160 tables.

ERROR 1005 (HY000) at line 3365: Can't create table './e_app_db/prate_section_user.frm' (errno: 4335)

Boon

Building Towards A Better Tomorrow Together

You Ask Me To Fight For You, I Give You Freedom & Protection And Then You Question The Manner In Which I Provide It, I'd Rather You Just Said -- "Thank You" --

Jumpstart your cluster: http://www.mysql.com/consulting/packaged/cluster.html