MySQL Forums
Forum List  »  NDB clusters

ERROR 1114 (HY000): The table '#sql-78b5_1a9' is full
Posted by: Qingyuan Lou
Date: May 30, 2018 05:10PM

My NDB Cluster Server version is 5.6.31-ndb-7.4.12-cluster-gpl MySQL Cluster Community Server (GPL)

When I tried to change a table's engine from InnoDB to NDBCluster it gives Table is full error as below.

mysql> ALTER TABLE SM_USER_WIDGET_MAPPING engine=NDBCLUSTER;
ERROR 1114 (HY000): The table '#sql-78b5_1a9' is full

(Currently there are 40 tables with NDBCluster engine. 23 tables with InnoDB engine waiting to be altered.)

There are two data nodes. Each has 2G memory. Below is the memory report:

Node 2: Data usage is 19%(9389 32K pages of total 48384)
Node 2: Index usage is 16%(1143 8K pages of total 6944)
Node 3: Data usage is 19%(9389 32K pages of total 48384)
Node 3: Index usage is 16%(1143 8K pages of total 6944)

Below is cluster configuration

[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=2 # Number of replicas
DataMemory=1512M # How much memory to allocate for data storage
IndexMemory=54M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.
MaxNoOfConcurrentOperations=100000
MaxNoOfLocalOperations=110000
MaxNoOfTables=4096
MaxNoOfTriggers=3500
MaxNoOfAttributes=25000

[tcp default]
# TCP/IP options:
portnumber=2202 # This the default; however, you can use any
# port that is free for all the hosts in the cluster
# Note: It is recommended that you do not specify the port
# number at all and simply allow the default value to be used
# instead

[ndb_mgmd]
# Management process options:
hostname=10.122.215.52 # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node log files

[ndbd]
# Options for data node "A":
# (one [ndbd] section per data node)
hostname=10.144.118.15 # Hostname or IP address
#hostname=10.122.215.54 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's data files

[ndbd]
# Options for data node "B":
hostname=10.122.215.58 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's data files

[mysqld]
# SQL node options:
hostname=10.144.118.14 # Hostname or IP address
#hostname=10.122.215.53 # Hostname or IP address
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)
[mysqld]
# SQL node options:
hostname=10.122.215.52 # Hostname or IP address

I have spent several hours researching the solution without luck. It would be greatly appreciated if anyone could provide some help.

Thanks,

Qingyuan

Options: ReplyQuote


Subject
Views
Written By
Posted
ERROR 1114 (HY000): The table '#sql-78b5_1a9' is full
2317
May 30, 2018 05:10PM


Sorry, you can't reply to this topic. It has been closed.

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.