Re: Can't create table 'xxx' (errno: 4318)
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
Subject
Views
Written By
Posted
4031
January 12, 2005 07:02AM
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.