From: Tomas Ulin
Date: September 30 2004 8:55am
Subject: Re: Errors creating tables 701 4009
List-Archive: http://lists.mysql.com/cluster/748
Message-Id: <415BCA11.6060305@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

bash-2.05b$ perror --ndb 701
Error code 701:  System busy with other schema operation: Permanent 
error: Schema error
bash-2.05b$ perror --ndb 4009
Error code 4009:  Cluster Failure: Unknown result: Unknown result error

We need more input to analyze:

What are the tables you've created?
What does the cluster.log say?
What do the error.log's for the respective nodes say?
If the error log refers to a trace file, what does that say?

BR,

Tomas

Tatiana Peņa wrote:

>Hi!!
>
>I'm creating tables in my cluster and I got these errors:
>
>ERROR 1005 (HY000) at line 1: Can't create table
>'./bogota/bogt_2004092800.frm' (errno: 701)
>ERROR 1005 (HY000) at line 1: Can't create table
>'./bogota/bogt_2004092900.frm' (errno: 701)
>
>
>ERROR 1005 (HY000) at line 1: Can't create table
>'./bogota/bogt_2004092600.frm' (errno: 4009)
>ERROR 1005 (HY000) at line 1: Can't create table
>'./bogota/bogt_2004092700.frm' (errno: 4009)
>
>What do they mean?
>After I got these errors the clusters goes down :(
>
>There is a kind of documentation about the numbers enclosed by the
>parenthesis where we can find out a hint about what is happening ?
>
>
>Thanks for the help!!
>
>
>
>This is my config.ini
>
>----- Config.ini
>
>[COMPUTER]
>Id = 1
>HostName = 192.168.1.1
>
>[COMPUTER]
>Id = 2
>HostName = proc1.ola.com.co
>
>[COMPUTER]
>Id = 3
>HostName = proc2.ola.com.co
>
>[MGM]
>Id = 1
>ExecuteOnComputer = 1
>
>[DB DEFAULT]
>NoOfReplicas = 2
>DataMemory = 1000M
>IndexMemory = 400M
>MaxNoOfConcurrentTransactions = 50
>MaxNoOfConcurrentOperations = 250000
>TimeBetweenWatchDogCheck = 4000
>MaxNoOfOrderedIndexes = 27000
>MaxNoOfTables = 9000
>MaxNoOfAttributes = 25000
># LockPagesInMainMemory = Y
># StopOnError = Y
>
>[DB]
>Id = 2
>ExecuteOnComputer = 2
>FileSystemPath = /eva0/mysql/ndb/data
>
>[DB]
>Id = 3
>ExecuteOnComputer = 3
>FileSystemPath = /eva0/mysql/ndb/data
>
># [API DEFAULT]
># BatchSize = 992
># MaxScanBatchSize = 16MB
>
>[API]
>Id = 4
>ExecuteOnComputer = 2
>
>[API]
>Id = 5
>ExecuteOnComputer = 3
>
>
>[TCP DEFAULT]
>PortNumber = 10002
>
>
>----- END Config.ini
>
>
>  
>