MySQL Forums
Forum List  »  NDB clusters

Mysql NDB Cluster error while restoration of data "ERROR 1114 (HY000) at line 25: The table 'table1' is full"
Posted by: purval patel
Date: May 02, 2023 07:09AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql NDB Cluster error while restoration of data "ERROR 1114 (HY000) at line 25: The table 'table1' is full"
175
May 02, 2023 07:09AM


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.