Groups > Novell > MySQL with Novell > Mysql cluster memory allocation problem




Mysql cluster memory allocation problem

Mysql cluster memory allocation problem
Mon, 23 Oct 2006 12:54:54 GMT
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. 
If I decrease the data memory to 1200M then I get the followin error:
2006-10-23 06:34:29 [MgmSrvr] ALERT -- Node 2: Forced node shutdown 
completed. Occured during startphase 0. Initiated by signal 0. Caused by 
error 6050: 'WatchDog terminate, internal error or massive overload on the 
machine running this node(Internal error, programming error or missing error 
m

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.


I am sure that the problem is not with mysql but it is caused by a kernel 
parameter that dictates how much memory a process can allocate. I don't know 
what parameter is and much less how to change it. Any help is gratetly 
appreciated.


Post Reply
about | contact