MySQL Forums
Forum List  »  Install & Repo

NDBCluster: Table is full
Posted by: Kasandra Padisha
Date: September 15, 2004 03:09PM


Hi

I have a cluster running using mysql-4.1.4a-gamma, on debians 3.0
stable. It has a master (MGM), two DBs and two (API). I included
the config.ini file at the end.

It works pretty well, we have test it all, from one API, from the
other, the sync works OK, .. everything looking good

..but now we are starting to load it with a big amount of
information and we start to have the message:

ERROR 1114 at line 2: The table 'aaaaa' is full

We are running an script that loads lot of information, and
in some places it stops with this message, and it is not
always. We tried to do it by hand, with the tables in trouble,
and it lets to insert one row at a time, but with two it did not.

We tried to increase the max rows as it is shown in the
manual Sect A.2.11 (of course it is for myisam but we gave
it a go) .. but we got an error

ALTER table aaa MAX_ROWS=10000000 AVG_ROW_LENGTH=1039335076;

and returned
ERROR 1005 (HY000): Can't create table './cdr/#sql-4a98_10f.frm' (errno:
4336)

strange .. ... Any clue somebody ???


--------------------------------------- config.ini ---------------
[DB DEFAULT]
NoOfReplicas: 2

[COMPUTER]
Id: 1
HostName: mgm

[COMPUTER]
Id: 2
HostName: proc1

[COMPUTER]
Id: 3
HostName: proc2

[MGM]
Id: 1
ExecuteOnComputer: 1

[DB]
Id: 2
ExecuteOnComputer: 2
FileSystemPath: /var/mysql/ndb/data

[DB]
Id: 3
ExecuteOnComputer: 3
FileSystemPath: /var/mysql/ndb/data

[API]
Id: 4
ExecuteOnComputer: 2

[API]
Id: 5
ExecuteOnComputer: 3

[TCP DEFAULT]
PortNumber: 10002
---------------------------------------------------

Options: ReplyQuote


Subject
Written By
Posted
NDBCluster: Table is full
September 15, 2004 03:09PM


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.