MySQL Forums
Forum List  »  NDB clusters

MaxNoOfConcurrentTransactions Error
Posted by: Jeff
Date: October 04, 2005 12:45PM

I created a simple function on mysql cluster.

1) step 1, create a table t with only one column.
mysql> desc t;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| a | int(11) | YES | | NULL | |
+-------+---------+------+-----+---------+-------+
1 row in set (0.01 sec)

2. step 2, create a function

mysql> delimiter //
mysql> create function loopfunction() returns VARCHAR(20)
-> begin
->
-> declare l_loop int default 0;
->
-> loop1: loop
->
-> insert into t values (1);
->
-> set l_loop := l_loop + 1;
->
-> IF l_loop >= 10 THEN
-> leave loop1;
-> end if;
->
-> end loop loop1;
->
-> return concat('We looped ',l_loop,' times');
->
-> end
-> //
Query OK, 0 rows affected (0.01 sec)

3) Run the function and got the error below:
mysql> delimiter ;
mysql> select loopfunction();
ERROR 1297 (HY000): Got temporary error 4006 'Connect failure - out of connection objects (increase MaxNoOfConcurrentTransactions)' from ndbcluster

4) My config.ini is:
[root@mysql02 mysql-cluster]# cat config.ini
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=200M
IndexMemory=50M

[NDB_MGMD]
hostname=192.168.0.2
datadir=/var/lib/mysql-cluster

[NDBD]
hostname=192.168.0.3
datadir=/mysql-data
MaxNoOfConcurrentTransactions=100000
MaxNoOfConcurrentOperations=200000
BackupDataDir=/mysql-data/BACKUP

[NDBD]
hostname=192.168.0.1
datadir=/var/lib/mysql
MaxNoOfConcurrentTransactions=100000
MaxNoOfConcurrentOperations=200000
BackupDataDir=/u08/mysql-backup/BACKUP

[MYSQLD]
hostname=192.168.0.3

[MYSQLD]
hostname=192.168.0.1

How should I set the MaxNoOfConcurrentTransactions? Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
MaxNoOfConcurrentTransactions Error
3791
October 04, 2005 12:45PM
1767
October 05, 2005 07:05AM


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.