Hi,
4242 says Too Many Indexes. Thus the problem here is that the configuration needs to
specify more indexes. A further look at the code reveals that it actually is the unique
hash indexes that are too few. This configuration parameter is MaxNoOfUniqueHashIndexes
and is set to 64 by default. Thus increasing this to a bigger value should solve your
problem.
Rgrds Mikael
Peter Schulz wrote:
> ok i found out that the problem ist the "unique
> key" in my statement... that causes errno:
> 4242....
>
> CREATE TABLE `tbl_users` (
> `user_id` int(11) NOT NULL auto_increment,
> `user_login` varchar(15) NOT NULL default '',
> PRIMARY KEY (`user_id`),
> UNIQUE KEY `user_login` (`user_login`)
> ) ENGINE=NDBCLUSTER;
>
>
> it seems to be a limitation error - because if my
> database don't has any tables i can perform that
> statement... if i have some tables in there that
> statement fails 4242... any ideas?
>
> _pete®
Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:
http://mikaelronstrom.blogspot.com