MySQL Forums
Forum List  »  NDB clusters

Re: ERROR 1114 (HY000): The table '#sql-414_3d' is full
Posted by: John King
Date: May 26, 2015 01:56PM

Hi,

I seem to have a similar issue with my cluster setup as well. I believe all my cluster related settings are correct however when I try to restore a database from another mysql server (Ubuntu Native mysql package version 5.5) onto the cluster, I receive "ERROR 1114 (HY000) at line 1230: The table 'survey_group_members' is full"

The database engine on the Native mysql database dump is InnoDB. I have edited the *.sql script and replaced ENGINE=InnoDB with ENGINE=NDBCLUSTER.

Here is my config.ini

# Configuration file for uamysqluat1-clus1
#

[NDB_MGMD DEFAULT]
Portnumber=1186

[NDB_MGMD]
NodeId=49
HostName=142.244.115.16
DataDir=/mysqldb/MySQL_Cluster/49/
Portnumber=1186

[TCP DEFAULT]
SendBufferMemory=8M
ReceiveBufferMemory=8M

[NDBD DEFAULT]
BackupMaxWriteSize=1M
BackupDataBufferSize=16M
BackupLogBufferSize=4M
BackupMemory=20M
BackupReportFrequency=10
MemReportFrequency=30
LogLevelStartup=15
LogLevelShutdown=15
LogLevelCheckpoint=8
LogLevelNodeRestart=15
DataMemory=9998M
IndexMemory=1785M
MaxNoOfTables=4096
MaxNoOfAttributes=100000
MaxNoOfTriggers=3500
NoOfReplicas=2
StringMemory=25
DiskPageBufferMemory=64M
SharedGlobalMemory=2048M
LongMessageBuffer=32M
MaxNoOfConcurrentTransactions=16384
BatchSizePerLocalScan=512
FragmentLogFileSize=256M
NoOfFragmentLogFiles=58
RedoBuffer=64M
MaxNoOfExecutionThreads=4
StopOnError=false
LockPagesInMainMemory=1
TimeBetweenEpochsTimeout=32000
TimeBetweenWatchdogCheckInitial=60000
TransactionInactiveTimeout=60000
HeartbeatIntervalDbDb=1500
HeartbeatIntervalDbApi=1500

[NDBD]
NodeId=1
HostName=142.244.115.19
DataDir=/mysqldb/MySQL_Cluster/1/
BackupDataDir=/mysqllogs/backups/1/

[NDBD]
NodeId=2
HostName=142.244.115.20
DataDir=/mysqldb/MySQL_Cluster/2/
BackupDataDir=/mysqllogs/backups/2/
[MYSQLD DEFAULT]

[MYSQLD]
NodeId=60
HostName=142.244.115.17
#HostName=uamysqluat1-sql.srv.ualberta.ca

[MYSQLD]
NodeId=61
HostName=142.244.115.18
#HostName=uamysqluat1-sql.srv.ualberta.ca

[API]
NodeId=50
HostName=142.244.115.16

[API]
NodeId=51
HostName=142.244.115.17

[API]
NodeId=52
HostName=142.244.115.18

Here is my my.cnf file on the sql nodes;
# Configuration file for uamysqluat1-clus1
# Generated by mcc
#
[mysqld]
log-error=/mysqllogs/mysql/61/mysqld.61.err
datadir="/mysqldb/MySQL_Cluster/61/"
tmpdir="/mysqldb/MySQL_Cluster/61/tmp"
basedir="/opt/mysql/server-5.6/"
general_log=1
general_log_file=/mysqllogs/mysql/61/mysql.61.log
slow_query_log=1
slow_query_log_file=/mysqllogs/mysql/61/slow_query.61.log
port=3306
socket="/tmp/mysql.sock"
ndbcluster

[mysql_cluster]
ndbcluster=on
ndb-nodeid=61
ndb-connectstring=142.244.115.16:1186,
ndb_extra_logging=9
ndb-use-exact-count=0
ndb-index-stat-enable=0
ndb-force-send=1
[mysqld_safe]
socket="/tmp/mysql.sock"

# Configuration file for uamysqluat1-clus1
# Generated by mcc
#
[mysqld]
log-error=/mysqllogs/mysql/60/mysqld.60.err
datadir="/mysqldb/MySQL_Cluster/60/"
tmpdir="/mysqldb/MySQL_Cluster/60/tmp"
basedir="/opt/mysql/server-5.6/"
general_log=1
general_log_file=/mysqllogs/mysql/60/mysql.60.log
slow_query_log=1
slow_query_log_file=/mysqllogs/mysql/60/slow_query.60.log
port=3306
socket="/tmp/mysql.sock"
ndbcluster
#optimizer_switch=engine_condition_pushdown=1

[mysql_cluster]
#ndbcluster=on
ndb-nodeid=60
ndb-connectstring=142.244.115.16:1186,
ndb_extra_logging=9
ndb-use-exact-count=0
ndb-index-stat-enable=0
ndb-force-send=1
[mysqld_safe]
socket="/tmp/mysql.sock"

here is the output from the management server
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=1 @142.244.115.19 (mysql-5.6.22 ndb-7.3.8, Nodegroup: 0)
id=2 @142.244.115.20 (mysql-5.6.22 ndb-7.3.8, Nodegroup: 0, *)

[ndb_mgmd(MGM)] 1 node(s)
id=49 @142.244.115.16 (mysql-5.6.22 ndb-7.3.8)

[mysqld(API)] 5 node(s)
id=50 (not connected, accepting connect from 142.244.115.16)
id=51 (not connected, accepting connect from 142.244.115.17)
id=52 (not connected, accepting connect from 142.244.115.18)
id=60 @142.244.115.17 (mysql-5.6.22 ndb-7.3.8)
id=61 @142.244.115.18 (mysql-5.6.22 ndb-7.3.8)

ndb_mgm>

ndb_mgm> ALL REPORT MemoryUsage
Node 1: Data usage is 0%(253 32K pages of total 319936)
Node 1: Index usage is 0%(227 8K pages of total 228512)
Node 2: Data usage is 0%(253 32K pages of total 319936)
Node 2: Index usage is 0%(227 8K pages of total 228512)

ndb_mgm>

The 2 database nodes have 4 cores and 32GB of RAM each
The 2 sql nodes have 4 cores and 8GB of RAM each.

I have been able to upload the world test database to the cluster with no issues. I had to of course replace the ENGINE=NDBCLUSTER before applying the SQL dump. WHen I did this there were no table related error messages and I was successfully able to run tests against that database.

I have also been able to apply a wordpress database from another server to the cluster. Again editing the sql dump script and replacing the ENGINE type.

Note; both the world test database supplied from oracle as well as the wordpress database were very small.

The current database I am trying to apply to the cluster is around 100MB in size. I have also attempted to apply a larger database the size is around 1.2 GB but in each attempt I receive the messaged noted at the start of this post.

Any suggestions anyone has will be greatly appreciated!

Regards,

John

Options: ReplyQuote




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.