MySQL Forums
Forum List  »  NDB clusters

Help error Caused by error 2327 after increasing DataMemory
Posted by: Jose Hernandez
Date: October 16, 2006 08:07AM

I have cluster composed of 2 data nodes and one management node. I am trying to increase the data memory from 900M to 1500M and index memory from 250 to 512. For some unknown reason I get error 2327 when starting the data nodes. All nodes OS are Suse Linux Enterprise servers(Linux OES) and have 4GB of RAM. Mysql version is mysql-max-5.0.19-linux-i686-glibc23. The management config.ini is as follows:

# Options affecting ndbd processes on all data nodes:
[NDBD DEFAULT]
NoOfReplicas=2 # Number of replicas
DataMemory = 900M # How much memory to allocate for data storage1024
IndexMemory = 250M # How much memory to allocate for index storage
MaxNoOfAttributes = 2000 # For DataMemory and IndexMemory
MaxNoOfOrderedIndexes = 5000 # default values.
MaxNoOfUniqueHashIndexes = 5000 # only about 500KB,
# this example Cluster setup.
# TCP/IP options:
[TCP DEFAULT]
portnumber=2202 # This the default; however, you can use any
# port that is free for all the hosts in cluster
# Note: It is recommended beginning with MySQL 5.0 that
# you do not specify the portnumber at all and simply allow
# the default value to be used instead
# Management process options:
[NDB_MGMD]
hostname=192.168.0.1 # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles
# Options for data node "A":
[NDBD]
hostname=192.168.0.2 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's datafiles
MaxNoOfConcurrentOperations = 700000 # sets the number of records that can be updated simultaneously
MaxNoOfConcurrentTransactions = 10000 # sets the number of parallel transactions posible in a node
# Options for data node "B":
[NDBD]
hostname=192.168.0.3 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's datafiles
MaxNoOfConcurrentTransactions = 10000 #sets the number of parallel transactions possible in a node
MaxNoOfConcurrentOperations = 700000 #sets the number of records that can beupdated simultaneously
# SQL node options:
[MYSQLD]
hostname=192.168.0.2 # Hostname or IP address
[MYSQLD]
hostname=192.168.0.3 # Hostname or IP address
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)



The erros log is as follows:

2006-10-14 13:39:40 [MgmSrvr] INFO -- Mgmt server state: nodeid 2 reserved for ip 192.168.0.2, m_reserved_nodes 0000000000000016.
2006-10-14 13:39:40 [MgmSrvr] INFO -- Node 1: Node 2 Connected
2006-10-14 13:39:41 [MgmSrvr] INFO -- Mgmt server state: nodeid 2 freed, m_reserved_nodes 0000000000000012.
2006-10-14 13:39:43 [MgmSrvr] ALERT -- Node 2: Forced node shutdown completed. Occured during startphase 0. Initiated by signal 0. Caused by error 2327: 'Memory allocation failure, please decrease some configuration parameters(Configuration error). Permanent error, external action needed'.
2006-10-14 13:40:23 [MgmSrvr] INFO -- Mgmt server state: nodeid 2 reserved for ip 192.168.0.2, m_reserved_nodes 0000000000000016.
2006-10-14 13:40:23 [MgmSrvr] INFO -- Node 1: Node 2 Connected
2006-10-14 13:40:24 [MgmSrvr] INFO -- Mgmt server state: nodeid 2 freed, m_reserved_nodes 0000000000000012.
2006-10-14 13:40:59 [MgmSrvr] INFO -- Node 1: Node 2 Connected
2006-10-14 13:40:59 [MgmSrvr] ALERT -- Node 2: Forced node shutdown completed. Occured during startphase 0. Initiated by signal 0. Caused by error 2327: 'Memory allocation failure, please decrease some configuration parameters(Configuration error). Permanent error, external action needed'.
2006-10-14 13:47:13 [MgmSrvr] INFO -- NDB Cluster Management Server. Version 5.0.19
2006-10-14 13:47:13 [MgmSrvr] INFO -- Id: 1, Command port: 1186
2006-10-14 13:47:28 [MgmSrvr] INFO -- Mgmt server state: nodeid 2 reserved for ip 192.168.0.2, m_reserved_nodes 0000000000000006.
2006-10-14 13:47:28 [MgmSrvr] INFO -- Node 1: Node 2 Connected
2006-10-14 13:47:29 [MgmSrvr] INFO -- Mgmt server state: nodeid 2 freed, m_reserved_nodes 0000000000000002.


Any help is gratetly appreciated



Edited 2 time(s). Last edit at 10/16/2006 08:11AM by Jose Hernandez.

Options: ReplyQuote


Subject
Views
Written By
Posted
Help error Caused by error 2327 after increasing DataMemory
1770
October 16, 2006 08:07AM


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.