The table is full - Error #1114

[Joseph Borg]

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.