MySQL Forums
Forum List  »  NDB clusters

ERROR 1114 (HY000) at line 1038: The table 'member_attribute' is full
Posted by: David Wong
Date: September 12, 2008 03:01PM

Hi,

I’m trying to import a .sql file and its giving me this error. Anyone know how to fix this? Do I need to incrase my datausage? I already set it up to 12G. Anyone know the correct setting for my setup? Any help will be appreciated.

[root@mysql-cluster]# uname -a
Linux mysql1.dohma.com 2.6.9-67.0.4.ELsmp #1 SMP Fri Jan 18 05:00:00 EST 2008 x86_64 x86_64 x86_64 GNU/Linux
16G memory Dual Core 2
DELL PowerEdge 2950 MKIII Linux 2.5in
Both machine.

Here is my setup
1 management machine
2 node/api

Mysql1# Mysql –u root –p db1 < db1.sql
ERROR 1114 (HY000) at line 1038: The table 'member_attribute' is full
LOG
2008-09-12 13:02:50 [MgmSrvr] INFO -- Node 3: Data usage increased to 91%(359042 32K pages of total 393216)
2008-09-12 13:02:50 [MgmSrvr] INFO -- Node 2: Data usage increased to 91%(359180 32K pages of total 393216)
2008-09-12 13:07:46 [MgmSrvr] INFO -- Node 3: Data usage increased to 100%(393216 32K pages of total 393216)
2008-09-12 13:07:46 [MgmSrvr] INFO -- Node 2: Data usage increased to 100%(393216 32K pages of total 393216)


[root@reporting mysql-cluster]# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.1.211 (Version: 5.0.67, Nodegroup: 0, Master)
id=3 @192.168.1.109 (Version: 5.0.67, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.1.51 (Version: 5.0.67)

[mysqld(API)] 2 node(s)
id=4 @192.168.1.211 (Version: 5.0.67)
id=5 @192.168.1.109 (Version: 5.0.67)

Config.ini
[root@reporting mysql-cluster]# more config.ini
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=12288M
IndexMemory=3072M
#FragmentLogFileSize=16M
NoOfFragmentLogFiles=200
UndoIndexBuffer=10M
RedoBuffer=256M
MaxNoOfConcurrentOperations=100000
#NoOfDiskPagesToDiskAfterRestartTUP=150
#NoOfDiskPagesToDiskAfterRestartACC=83
#Diskcheckpointspeed=10M
#Diskcheckpointspeedinrestart=100M
TimeBetweenGlobalCheckpoints=1000
TimeBetweenLocalCheckpoints=3
MaxNoOfTables=4096
MaxNoOfAttributes=24756
MaxNoOfOrderedIndexes=2048
MaxNoOfUniqueHashIndexes=512
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
# Managment Server
[NDB_MGMD]
HostName=192.168.1.51 # the IP of THIS SERVER
DataDir= /var/lib/mysql-cluster
# Storage Engines
[NDBD]
HostName=192.168.1.211 # the IP of the FIRST SERVER
DataDir= /var/lib/mysql-cluster
[NDBD]
HostName=192.168.1.109 # the IP of the SECOND SERVER
DataDir=/var/lib/mysql-cluster
# 2 MySQL Clients
# I personally leave this blank to allow rapid changes of the mysql clients;
# you can enter the hostnames of the above two servers here. I suggest you dont.
[MYSQLD]
[MYSQLD]

My.cnf
[root@mysql1 mysql-cluster]# more /etc/my.cnf
# Options for mysqld process:
[mysqld]
ndbcluster # run NDB storage engine
ndb-connectstring=192.168.1.51 # location of management server

# Options for ndbd process:
[mysql_cluster]
ndb-connectstring=192.168.1.51 # location of management server

[root@mysql2 mysql-cluster]# more /etc/my.cnf
# Options for mysqld process:
[mysqld]
ndbcluster # run NDB storage engine
ndb-connectstring=192.168.1.51 # location of management server

# Options for ndbd process:
[mysql_cluster]
ndb-connectstring=192.168.1.51 # location of management server




Thank you
David Wong

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.