MySQL Forums
Forum List  »  NDB clusters

Encounter problem to insert "text" field data into the cluster table
Posted by: Brian Leung
Date: December 06, 2004 08:11PM

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:cfchow1962@yahoo.com.hk 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

Options: ReplyQuote


Subject
Views
Written By
Posted
Encounter problem to insert "text" field data into the cluster table
5163
December 06, 2004 08:11PM


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.