Mysql NDB Cluster error while restoration of data "ERROR 1114 (HY000) at line 25: The table 'table1' is full"

[purval patel]

I have created mysql NDB Cluster with two data nodes and two mysql servers.
below is the configuration of ndb_mgmd.

$cat /usr/mysql-cluster/config.ini
[ndbd default]
NoOfReplicas=2
DataMemory=1024M
IndexMemory=54M
MaxNoOfConcurrentOperations=100000
MaxNoOfLocalOperations=110000
MaxNoOfTables=4096
MaxNoOfTriggers=3500
MaxNoOfAttributes=25000

[ndb_mgmd]
hostname=172.31.16.19
datadir=/usr/mysql-cluster
NodeId=1

[ndbd]
hostname=172.31.20.59
NodeId=11
datadir=/usr/local/mysql/data

[ndbd]
hostname=172.31.16.136
NodeId=12
datadir=/usr/local/mysql/data

[mysqld]
hostname=172.31.16.136
NodeId=21

[mysqld]
hostname=172.31.20.59
NodeId=22


When i am trying to restore the databackup .sql file. which is around 2.2 GB in size at that time i am getting error of table is full.
i have checked the disk storage but it is showing available.
Please suggest, i am stuck with the issue from last two days.



Edited 1 time(s). Last edit at 05/02/2023 07:10AM by purval patel.