MySQL Forums
Forum List  »  NDB clusters

The table is full - Error #1114
Posted by: Joseph Borg
Date: April 04, 2019 06:02AM

Hi all,

We are receiving the above error message when trying to add a primary or foreign key to any table within any database. I have looked at our memory reports and all indicates hardly any memory is being used whatsoever:

ndb_mgm> all report memory
Node 3: Data usage is 0%(570 32K pages of total 98304)
Node 3: Index usage is 0%(474 8K pages of total 262176)
Node 4: Data usage is 0%(570 32K pages of total 98304)
Node 4: Index usage is 0%(474 8K pages of total 262176)
Node 5: Data usage is 0%(570 32K pages of total 98304)
Node 5: Index usage is 0%(474 8K pages of total 262176)

Our setup is as follows:
NDB Cluster version: 7.4.14
2x Managment nodes - 4Gb RAM
2x Application nodes - 4Gb RAM
3x Data nodes - 6Gb RAM 25Gb Secondary HDD - (1% disk space used - 95Mb)

Checked the disk space of the data nodes as can be seen above and only 1% used. I decided to increase the IndexMemory to 3Gb just in case this was the cause but to no avail. Our config is as such:

[ndb_mgmd]
HostName=mgm1.example.com
DataDir=/u01/cluster-data

[ndb_mgmd]
HostName=mgm2.example.com
DataDir=/u01/cluster-data

[ndbd default]
NoOfReplicas=3
DataMemory=3072M
IndexMemory=2048M
ServerPort=2002
BackupDataDir=/u01/cluster-data/backups
DataDir=/u01/cluster-data

[ndbd]
HostName=data1.example.com

[ndbd]
HostName=data2.example.com

[ndbd]
HostName=data3.example.com

[mysqld]
HostName=sql1.example.com

[mysqld]
HostName=sql2.example.com

Any help or advice on streamlining our config would be greatly appreciated.

Cheers

Joe



Edited 1 time(s). Last edit at 04/04/2019 06:24AM by Joseph Borg.

Options: ReplyQuote


Subject
Views
Written By
Posted
The table is full - Error #1114
420
April 04, 2019 06:02AM


Sorry, only registered users may post in this forum.

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.