Encounter problem to insert "text" field data into the cluster table

[Brian Leung]

Hi,

I installed the cluster 4.1.7 version and running in
the following configuration :
machine a :
1 ndb_mgmd
1 ndbd
1 mysqld
machine b:
1 ndbd
1 mysqld

and the config.ini is as follows :

[ndbd default]
NoOfReplicas= 2
MaxNoOfOrderedIndexes=1000
DataMemory=1024M
IndexMemory=512M

[mysqld default]
[ndb_mgmd default]
[tcp default]

[ndbd]
HostName= a
DataDir: /var/lib/mysql-cluster/

[ndbd]
HostName= b
DataDir: /var/lib/mysql-cluster/

[ndb_mgmd]
HostName= a

[mysqld]
[mysqld]
[mysqld]

It ran pretty soomthly for a normal data. I created 14
tables in the database and migrated the existing data
from the current single node mysql into this cluster.
And I found out that one of the tables in which
the structure as follows having problem for me to
insert the data on the text field:

CREATE TABLE `enquiry_temp` (
`E_ID` int(11) unsigned NOT NULL auto_increment,
`E_SUBJECT` varchar(200) NOT NULL default '',
`E_FROM_DEPT` int(11) NOT NULL default '0',
`E_TO_DEPT` int(11) NOT NULL default '0',
`E_ENTRY_TS` timestamp NOT NULL default
CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`E_MESSAGE` text NOT NULL,
`M_ID` varchar(20) NOT NULL default '',
`E_READF` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`ENQ_ID`)
) ENGINE=ndbcluster DEFAULT CHARSET=utf8;

INSERT INTO `enquiry_temp`
(`ENQ_ID`,`E_SUBJECT`,`E_FROM_DEPT`,`E_TO_DEPT`,`E_ENTRY_TS`,`E_MESSAGE`,`M_ID`,`E_READF`)
VALUES
(254,'Enquiry','CEDD','CSB','2004-09-01 07:51:00',
'Dear Sirs,I\'ve sent you an enquiry yesterday on
the requirement of reporting of private
investment.Please send your reply to me at the
following email
address:[e-mail] Thanks.',
'cfchow',1);

The mysql prompt just hang and no responsed at all
I found out that if I inserted this record into the
single node mysql, there is no problem. And also if
the E_Message field is varchar(255), there is no
problem to insert into this cluster table.

I wonder if there is issues on inserting data into the
"text" or "mediumtext" datatype in mysql clustering.
Hope someone can help me.

Regards