59 messages in com.mysql.lists.clusterError when insert into tabele, Help!
FromSent OnAttachments
Gurgen Petrosyan24 Aug 2004 06:32 
Crouch, Luke H.24 Aug 2004 06:56 
Crouch, Luke H.24 Aug 2004 21:49 
Magnus Svensson25 Aug 2004 01:58 
Lars Thalmann25 Aug 2004 04:21 
Gurgen Petrosyan25 Aug 2004 06:02 
Lars Thalmann25 Aug 2004 07:39 
Gurgen Petrosyan25 Aug 2004 13:29 
Tomas Ulin14 Sep 2004 02:37 
Tomas Ulin14 Sep 2004 05:20 
Gurgen Petrosyan14 Sep 2004 08:34 
Gurgen Petrosyan14 Sep 2004 10:32 
Gurgen Petrosyan14 Sep 2004 11:02 
Tomas Ulin16 Sep 2004 06:35 
Gurgen Petrosyan16 Sep 2004 12:38 
Gurgen Petrosyan16 Sep 2004 13:10 
Gurgen Petrosyan17 Sep 2004 12:56 
Gurgen Petrosyan17 Sep 2004 14:41 
Sharad Maloo20 Sep 2004 07:12 
Gurgen Petrosyan20 Sep 2004 13:39 
Magnus Svensson22 Sep 2004 05:28 
Bruce Robertson22 Sep 2004 10:00 
Gurgen Petrosyan22 Sep 2004 13:59 
Gurgen Petrosyan22 Sep 2004 14:21 
Gurgen Petrosyan22 Sep 2004 14:35 
Gurgen Petrosyan22 Sep 2004 14:39 
Gurgen Petrosyan22 Sep 2004 15:49 
Mikael Ronström23 Sep 2004 00:20 
Mikael Ronström23 Sep 2004 00:29 
Gurgen Petrosyan03 Oct 2004 11:32 
Crouch, Luke H.04 Oct 2004 06:12 
Gurgen Petrosyan04 Oct 2004 13:58 
pek...@mysql.com08 Nov 2004 05:16 
Gurgen Petrosyan08 Nov 2004 12:51 
Joseph E. Sacco, Ph.D.11 Nov 2004 05:18 
Gurgen Petrosyan11 Nov 2004 05:25 
Gurgen Petrosyan28 Nov 2004 08:47 
Jonas Oreland29 Nov 2004 00:15 
Klaus Byskov Pedersen18 Jan 2005 00:27 
Mikael Ronström18 Jan 2005 02:14 
Gurgen Petrosyan18 Jan 2005 07:21 
Gurgen Petrosyan18 Jan 2005 08:47 
Gurgen Petrosyan18 Jan 2005 09:00 
Gurgen Petrosyan18 Jan 2005 09:17 
Jon Stephens02 Feb 2005 09:03 
Mikael Ronström02 Feb 2005 11:21 
Gurgen Petrosyan02 Feb 2005 16:28 
Jon Stephens02 Feb 2005 18:16 
Jon Stephens07 Feb 2005 09:16 
Gurgen Petrosyan07 Feb 2005 10:18 
Gurgen Petrosyan09 Feb 2005 11:51 
Stefan Hinz23 Feb 2005 06:12 
Eric Bergen05 Mar 2005 11:36 
Gurgen Petrosyan05 Mar 2005 12:56 
Gurgen Petrosyan05 Mar 2005 14:00 
Gurgen Petrosyan05 Mar 2005 14:15 
Jon Stephens05 Mar 2005 18:20 
Jon Stephens07 Mar 2005 07:35 
Gurgen Petrosyan07 Mar 2005 11:39 
Subject:Error when insert into tabele, Help!
From:Gurgen Petrosyan (gur@ipia.sci.am)
Date:01/18/2005 07:21:18 AM
List:com.mysql.lists.cluster

Hello! We had a problem!

At us is 1 MGM node and 4 DB nodes! Each of 5 computers have 1Gb operative memory! We have created 3 SQL a file (everyone on 900Mb) each of which has consisted of 10 000 000 lines

insert into big_table_a set a1='213123', a2='123123', a3='213124', a4='234234'; insert into big_table_a set a1='213123', a2='978433', a3='234234', a4='2535623'; ............................

Through API node we have started this SQL a script with the help of a command

source data1.sql; source data2.sql; source data3.sql;

When in a database already has entered the name more than 14 000 000 lines MySQL Cluster has given out the following mistake:

ERROR 1114: The table 'big_table_a' is full

Please help to solve this problem!

Here we config.ini maybe a mistake in it?

###################### [COMPUTER DEFAULT]

[DB DEFAULT] NoOfReplicas: 1

[MGM DEFAULT] ArbitrationRank: 1

[TCP DEFAULT] PortNumber: 28002

[COMPUTER] Id: 1 HostName: 192.168.1.21

[COMPUTER] Id: 2 HostName: 192.168.1.22

[COMPUTER] Id: 3 HostName: 192.168.1.23

[COMPUTER] Id: 4 HostName: 192.168.1.24

[COMPUTER] Id: 5 HostName: 192.168.1.25

[MGM] Id: 1 ExecuteOnComputer: 1 PortNumber: 29000

[DB] Id: 2 ExecuteOnComputer: 2 IndexMemory: 100M DataMemory: 700M

[DB] Id: 3 ExecuteOnComputer: 3 IndexMemory: 100M DataMemory: 700M

[DB] Id: 4 ExecuteOnComputer: 4 IndexMemory: 100M DataMemory: 700M

[DB] Id: 5 ExecuteOnComputer: 5 IndexMemory: 100M DataMemory: 700M

[API] Id: 6 ExecuteOnComputer: 1 ########################