MySQL Bugs: #70364: Got error 707 'No more table metadata records (increase MaxNoOfTables)' from NDB

Bug #70364	Got error 707 'No more table metadata records (increase MaxNoOfTables)' from NDB
Submitted:	17 Sep 2013 11:03	Modified:	17 Sep 2013 14:44
Reporter:	prasanth katta	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S3 (Non-critical)
Version:	mysql-5.6.11 ndb-7.3.2	OS:	Linux (Ubuntu 12.04 LTS)
Assigned to:		CPU Architecture:	Any

Description:
i am facing problem while dumpig data to mysql cluster. when ever i dump the data (.sql which is of 800MB in size with 400 tables) in to mysql cluster i am getting the following error "No more table metadata records (increase MaxNoOfTables)' from NDBCLUSTER"
2013-09-17 09:15:41 [MgmtSrvr] INFO     -- Node 3: mysqld --server-id=0
2013-09-17 09:15:42 [MgmtSrvr] INFO     -- Node 2: Node 3 Connected
2013-09-17 09:15:42 [MgmtSrvr] INFO     -- Node 2: Node 3: API mysql-5.6.11 ndb-7.3.2
2013-09-17 09:27:32 [MgmtSrvr] INFO     -- Node 2: Data usage is 0%(8 32K pages of total 524288)
2013-09-17 09:27:32 [MgmtSrvr] INFO     -- Node 2: Index usage is 0%(12 8K pages of total 1310752)
2013-09-17 09:27:32 [MgmtSrvr] INFO     -- Node 2: Resource 0 min: 524407 max: 859521 curr: 331025
2013-09-17 09:27:32 [MgmtSrvr] INFO     -- Node 2: Resource 3 min: 851976 max: 851976 curr: 327696
2013-09-17 09:27:32 [MgmtSrvr] INFO     -- Node 2: Resource 5 min: 1152 max: 1152 curr: 1088
2013-09-17 09:27:32 [MgmtSrvr] INFO     -- Node 2: Resource 7 min: 2240 max: 2240 curr: 2240
2013-09-17 09:27:32 [MgmtSrvr] INFO     -- Node 2: Resource 9 min: 64 max: 0 curr: 1

How to repeat:
dump data which is of 800MB with 400 table to mysql cluster
then it show this error one it dumps 102 tables no matter what parameters you change int config.ini file.

Suggested fix:
i have changed the maxNoOFtables value to 20320 which is max even though it is showing the same error. the error which i am facing is not really related to maxNoOftables. it is not showing the related errors

config file of my setup

Attachment: config.ini (application/x-wine-extension-ini, text), 2.29 KiB.

log file one

Attachment: ndb_1_cluster.log (text/x-log), 20.40 KiB.

log file two

Attachment: ndb_1_out.log (text/x-log), 404 bytes.

log file three

Attachment: ndb_2_out.log (text/x-log), 17.04 KiB.

Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

http://bugs.mysql.com/bug.php?id=70363

Hello Godofredo sorry for the mess-up ...can you pls provide the details of the existing one(like ticket no etc) i just want to have look of that particular issue to compare with mine...

Pls close the ticket as it is already opened (Bug #70363)