NDBCluster: Table is full
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
---------------------------------------------------
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.