|
| 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
|
|
|
|
|
|
|
|
|
|