MySQL Forums
Forum List  »  NDB clusters

MySQL cluster - error 707
Posted by: Dirk-Jan Alken
Date: September 16, 2011 02:43AM

Hello All,

We've setup MySQL cluster some time ago. Most of our tables are running ndbcluster, but we can't create any new ones (or alter MyISAM tables). At first I tought this had to do with MaxNoOfTables, but that's not the problem. If I create a table without a KEY it works just fine, but with a KEY we get the error:

Error Code: 1005 Can't create table 'dbname.table' (errno: 707)

Perror says:

perror --ndb 707
NDB error code 707: No more table metadata records (increase MaxNoOfTables): Permanent error: Schema error

But I think we shouldn't be able to create tables without a KEY.

The setup is running NDB 7.1.13 and MySQL 5.1.56 (2 data nodes, 1 management server). We used this in the config.ini file:

DataMemory=2G
IndexMemory=1000M
MaxNoOfConcurrentOperations=100000
MaxNoOfConcurrentTransactions=16384
StringMemory=25
MaxNoOfTables=20320
MaxNoOfOrderedIndexes=25000
MaxNoOfUniqueHashIndexes=15000
MaxNoOfAttributes=201950
MaxNoOfTriggers=71120

NoOfFragmentLogFiles=25

Anyone has an idea?

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL cluster - error 707
3195
September 16, 2011 02:43AM
1876
September 19, 2011 04:26PM
1020
September 20, 2011 12:23AM
961
September 19, 2011 04:29PM


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.