MySQL Forums
Forum List  »  NDB clusters

Re: Can't create table 'xxx' (errno: 4318)
Posted by: Mikael Ronström
Date: January 12, 2005 08:18AM

holger.siemoneit wrote:
> I have tried to create a table with primary key,
> unique keys and keys, engine=ndbcluster default
> charset=latin1 collate=latin1_german1_ci, but I
> got the error :
> ERROR 1005 (HY000): Can't create table 'xxx'
> (errno: 4318)
> perror 4318 gives me an Illegal error code.
> What can I do?

You can do the following in the source code tree
/wl1354/ndb/src/ndbapi] % grep 4318 *
NdbDictionaryImpl.cpp: m_error.code = 4318;
grep: SCCS: Operation not permitted
ndberror.c: { 4318, AE, "Invalid attribute name" },
grep: signal-sender: Operation not permitted
x [~/wl1354/ndb/src/ndbapi] % vi NdbDictionaryImpl.cpp
x [~/wl1354/ndb/src/ndbapi] % cd ..
x [~/wl1354/ndb/src] % grep -r NDB_MAX_ATTR *
ndbapi/NdbDictionaryImpl.cpp: if (sz > NDB_MAX_ATTRIBUTES_IN_TABLE){
x [~/wl1354/ndb/src] % cd ../include/
x [~/wl1354/ndb/include] % grep -r NDB_MAX_ATTR *
ndbapi/ndbapi_limits.h:#define NDB_MAX_ATTRIBUTES_IN_INDEX NDB_MAX_NO_OF_ATTRIBUTES_IN_KEY
ndbapi/ndbapi_limits.h:#define NDB_MAX_ATTR_NAME_SIZE 32
ndbapi/ndbapi_limits.h:#define NDB_MAX_ATTRIBUTES_IN_TABLE 128

if (sz > NDB_MAX_ATTRIBUTES_IN_TABLE){
m_error.code = 4318;
DBUG_RETURN(-1);
}

So too many attributes in table where max = 128

Rgrds Mikael

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Can't create table 'xxx' (errno: 4318)
2974
January 12, 2005 08:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.