Mysql Error Number 708
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: NDB clusters :: Got error 708 'No more attribute metadata records (increase MaxNoOfAttributes)' from NDB New Topic Advanced Search Got error 708 'No more attribute metadata records (increase MaxNoOfAttributes)' from NDB Posted by: Sebastien LELIEVRE () Date: May 04, 2007 01:30AM Hi, I was trying to modify some OBM SQL scripts to configure it on a MySQL Cluster dbms I got an error with this table : mysql> CREATE TABLE Invoice ( -> invoice_id int(8) auto_increment, -> invoice_domain_id int(8) default 0, -> invoice_timeupdate timestamp, -> invoice_timecreate timestamp, -> invoice_userupdate int(8), -> invoice_usercreate int(8), -> invoice_company_id int(8) NOT NULL, -> invoice_deal_id int(8) default NULL, -> invoice_project_id int(8) default NULL, -> invoice_number varchar(10) DEFAULT '0', -> invoice_label varchar(40) NOT NULL DEFAULT '', -> invoice_amount_ht double(10,2), -> invoice_amount_ttc double(10,2), -> invoice_status_id int(4) DEFAULT 0 NOT NULL, -> invoice_date date not NULL DEFAULT '0000-00-00', -> invoice_expiration_date date, -> invoice_payment_date date, -> invoice_inout char(1), -> invoice_archive char(1) NOT NULL DEFAULT '0', -> invoice_comment text, -> PRIMARY KEY (invoice_id) -> ) ENGINE=NDBCLUSTER; ERROR 1005 (HY000): Can't create table 'obm.Invoice' (errno: 708) mysql> SHOW WARNINGS; +-------+------+------------------------------------------------------------------------------------------+ | Level | Code | Message | +-------+------+------------------------------------------------------------------------------------------+ | Error | 1296 | Got error 708 'No more attribute metadata records (increase MaxNoOfAttributes)' from NDB | | Error | 1005 | Can't create table 'obm.Invoice' (errno: 708) | +-------+------+------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) I've looked at the MySQL Cluster Limitations page, but I didn't find anything to explain that error. I'm currently running MySQL Cluster 5.1.17 What am I missing ? Regards, Sebastien.
CLI (24) Cloud (2) Cluster (3) Database (1) Downgrade (1) Drupal (1) FreeBSD (26) Ftp (1) IIS (1) Lighttpd (1) Linux (15) Microsoft (2) MSSQL (2) Mysql (24) Network (2) News (62) Nginx (1) OCS (1) Perl (1) PHP (3) Proftpd (1) Replication (1) Rsync (2) SCVMM 2012 (1) Squid (1) SSL (1) Ubuntu (17) Upgrade (5) Virtual (1) VMware (8) Windows (3) WMI (1) Zenoss (2) Blog Archive ► 2012 (13) ► December (1) ► October (1) ► September (2) ► June (2) ► May (2) ► April (2) ► March (3) ► 2011 http://forums.mysql.com/read.php?25,151743 (17) ► November (1) ► October (1) ► August (1) ► July (2) ► June (4) ► May (3) ► April (3) ► February (1) ► January (1) ▼ 2010 (43) ► November (1) ► October (1) ► August (2) ► July (1) ► June (7) ► May (10) ► April (2) ► March (6) ► February (4) ▼ January (9) Rollback with MySQL Transaction Log Add HDD http://techovdoom.blogspot.com/2010/01/cant-create-table-errno-708-mysql-bugs.html on VMWARE (linux) Add HDD on VMWARE (FreeBSD) Setting in FSTAB add HDD in FreeBSD or Unix Script to rename multiple table in MySQL Enable the query cache in MySQL to improve perform... SUDO in FreeBSD / Unix Can't create table (errno: 708) (Mysql BUGS) Check RAM on FreeBSD ► 2009 (32) ► December (4) ► November (5) ► October (3) ► September (3) ► August (2) ► July (3) ► June (12) Search This Blog Loading... Followers Friday, January 8, 2010 Can't create table (errno: 708) (Mysql BUGS) I recently face my mysql problem like this.mysql> alter table 19m4t_enrol_authorize engine=ndbcluster;ERROR 1005 (HY000): Can't create table './lmsdb/#sql-2ece_a.frm' (errno: 708)when i want to cluster my tables on my other nodes this error appear.The Solution is go to my mysql management node and i increaseincrease "MaxNoOfAttributes" into my ndb_mgm.confexample :DataMemory = 24G IndexMemory = 4G MaxNoOfOrderedIndexes = 1024 MaxNoOfAttributes = 10000 MaxNoOfTables = 2500 MaxNoOfConcurrentOperations = 250000 MaxNoOfConcurrentIndexOperations = 250000 reboot all machine.DONE! Posted by waxs at 1:45 AM Reactions: Labels: Cluster, Mysql, News 1 comment: testJanuary 23, 2011 at 2:52 AMexcellent resolution thanks !seems to be new with version 7.1.9aReplyDeleteAdd commentLoad more... Newer Post Older Post Home Subscribe to: Post Comments (Atom) Views
here for a quick overview of the site Help Center http://stackoverflow.com/questions/31919855/issue-in-importing-from-innodb-to-ndbcluster Detailed answers to any questions you might have Meta http://www.programering.com/q/MTO3UDNwATk.html Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question mysql error x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up issue in importing from innodb to ndbcluster up vote 0 down vote favorite We have a table mysql error number with lots of columns. We are trying to import into MySQL 7.3 cluster. But we get the following error everytime: "Got Error 708 no more attribute meta data records increase max no of attributes ndbcluster" Our config.ini is as follows: [NDBD DEFAULT] BackupMaxWriteSize=1M BackupDataBufferSize=16M BackupLogBufferSize=4M BackupMemory=20M BackupReportFrequency=10 MemReportFrequency=30 LogLevelStartup=15 LogLevelShutdown=15 LogLevelCheckpoint=8 LogLevelNodeRestart=15 DataMemory=2247M IndexMemory=374M MaxNoOfTables=4096 MaxNoOfTriggers=3500 NoOfReplicas=2 StringMemory=25 DiskPageBufferMemory=64M SharedGlobalMemory=20M LongMessageBuffer=32M MaxNoOfConcurrentTransactions=16384 BatchSizePerLocalScan=512 FragmentLogFileSize=256M NoOfFragmentLogFiles=13 RedoBuffer=32M MaxNoOfExecutionThreads=2 StopOnError=false LockPagesInMainMemory=1 TimeBetweenEpochsTimeout=32000 TimeBetweenWatchdogCheckInitial=60000 TransactionInactiveTimeout=60000 HeartbeatIntervalDbDb=1500 HeartbeatIntervalDbApi=1500 MaxNoOfAttributes=4G [NDBD] NodeId=1 HostName=127.0.0.1 DataDir=D:/MySQL_Cluster/1/ MaxNoOfAttributes=4G MaxNoOfTables=4096 [NDBD] NodeId=2 HostName=127.0.0.1 DataDir=D:/MySQL_Cluster/2/ MaxNoOfAttributes=4G MaxNoOfTables=4096 Please suggest how to import a big table mysql innodb share|improve this question edited Aug 12 '15 at 13:33 ElGavilan 3,12461634 asked Aug 10 '15 at 12:40 Swati DreamSoft4u 1 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote 4G is bigger than the limit mentioned in the manual: http://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-ndbd-definition.html#ndbparam-n
(HY000): Got error 708 'No more attribute metadata records (increase MaxNoOfAttributes)' from NDBCLUSTER What is the cause of the MaxNoOfAttributes parameter is invalid? How to view the current of each NDBD node default values? [root@ClusterMgm ~]# vi /etc/mycluster.cnf [NDBD DEFAULT] NoOfReplicas=2 DataMemory=64M IndexMemory=18M MaxNoOfTables=1024 MaxNoOfAttributes=5000000 MaxNoOfOrderedIndexes=10000 #[TCP DEFAULT] #portnumber=2202 [NDB_MGMD] nodeid=1 hostname=10.16.147.20 datadir=/var/lib/mysql-cluster [MYSQLD] nodeid=2 hostname=10.16.147.21 [MYSQLD] nodeid=3 hostname=10.16.147.22 [NDBD] nodeid=4 hostname=10.16.147.23 datadir=/var/lib/mysql-cluster MaxNoOfTables=1024 MaxNoOfAttributes=5000000 MaxNoOfOrderedIndexes=10000 [NDBD] nodeid=5 hostname=10.16.147.24 datadir=/var/lib/mysql-cluster MaxNoOfTables=1024 MaxNoOfAttributes=5000000 MaxNoOfOrderedIndexes=10000 [root@ClusterMgm ~]# cat /etc/mycluster.cnf [NDBD DEFAULT] NoOfReplicas=2 DataMemory=64M IndexMemory=18M MaxNoOfTables=1024 MaxNoOfAttributes=5000000 MaxNoOfOrderedIndexes=10000 #[TCP DEFAULT] #portnumber=2202 [NDB_MGMD] nodeid=1 hostname=10.16.147.20 datadir=/var/lib/mysql-cluster [MYSQLD] nodeid=2 hostname=10.16.147.21 [MYSQLD] nodeid=3 hostname=10.16.147.22 [NDBD] nodeid=4 hostname=10.16.147.23 datadir=/var/lib/mysql-cluster MaxNoOfTables=1024 MaxNoOfAttributes=5000000 MaxNoOfOrderedIndexes=10000 [NDBD] nodeid=5 hostname=10.16.147.24 datadir=/var/lib/mysql-cluster MaxNoOfTables=1024 MaxNoOfAttributes=5000000 MaxNoOfOrderedIndexes=10000 -- NDB Cluster -- Management Client -- ndb_mgm> show Connected to Management Server at: 10.16.147.20:1186 Cluster Configuration --------------------- [ndbd(NDB)] 2 node(s) id=4 @10.16.147.23 (mysql-5.6.17 ndb-7.3.5, Nodegroup: 0, *) id=5 @10.16.147.24 (mysql-5.6.17 ndb-7.3.5, Nodegroup: 0) [ndb_mgmd(MGM)] 1 node(s) id=1 @10.16.147.20 (mysql-5.6.17 ndb-7.3.5) [mysqld(API)] 2 node(s) id=2 @10.16.147.21 (mysql-5.6.17 ndb-7.3.5) id=3 @10.16.147.22 (mysql-5.6.17 ndb-7.3.5) Started by Kay at August 04, 2014 - 11:21 AM Finally find out why the original, modify the config file, you need to add the --initial parameter to re read it... Didn't actually have such a t