6 messages in com.mysql.lists.clusterRE: I can't create table in cluster
FromSent OnAttachments
NiCK22 Nov 2004 22:13 
Martin Skold22 Nov 2004 22:55 
NiCK23 Nov 2004 01:52 
Olivier Kaloudoff23 Nov 2004 02:02 
Martin Skold23 Nov 2004 02:05 
Bocquet Denis25 Nov 2004 01:43 
Subject:RE: I can't create table in cluster
From:Olivier Kaloudoff (kal@kalou.net)
Date:11/23/2004 02:02:45 AM
List:com.mysql.lists.cluster

I dump a mysql database. Why I can import into mysql cluster.

mysql huahua< hua4.sql ERROR 1005 (HY000) at line 7: Can't create table './huahua/ltchat_user.frm'
(errno: 881)

ge:/# perror --ndb 881 Error code 881: Unable to create table, out of data pages (increase DataMemory) : Permanent error: Schema error

Hi Nick,

as perror 881 says, you're running out of Memory on the DB Nodes, you have to increase DataMemory in the config.ini for ndb_mgmd, and then

(advanced people please correct me if I'm wrong:

- restart ndb_mgmd - restart the first DB Node, issuing the command at ndb_mgm prompt:

<id> RESTART [-n] [-i] Restart DB node

- restart the second DB Node

(and so on for each of your DB Nodes).

Following this procedure, you should be able to change the values for DataMemory without breaking the service.

Regards,