MySQL Forums
Forum List  »  NDB clusters

ERROR 1105 (HY000): Failed to open 'City', error while unpacking from engine
Posted by: Gururaja Rao
Date: January 24, 2007 05:26AM

Hi,

I have done the cluster setup with 2 mysql nodes and 3 data nodes. One of the mysql node is used as management node also.

When i try to select or insert into table from one of mysql node, i am getting the following error.

ERROR 1105 (HY000): Failed to open 'City', error while unpacking from engine

My config.ini file is as follows:


[NDBD DEFAULT]
NoOfReplicas= 3
DataDir= /var/lib/mysql-cluster

[TCP DEFAULT]
portnumber=2202

[NDB_MGMD]
Id=1
Hostname=domU-12-31-34-00-02-CC.usma2.compute.amazonaws.com
DataDir= /mnt/mysql-cluster/data

[NDBD]
Id=2
HostName=domU-12-31-34-00-03-ED.usma2.compute.amazonaws.com
DataDir= /mnt/mysql-cluster/data
DataMemory=500M
IndexMemory=100M

[NDBD]
Id=3
HostName=domU-12-31-34-00-02-93.usma2.compute.amazonaws.com
DataDir= /mnt/mysql-cluster/data
DataMemory=500M
IndexMemory=100M

[NDBD]
Id=4
HostName=domU-12-31-34-00-03-B1.usma2.compute.amazonaws.com
DataDir= /mnt/mysql-cluster/data
DataMemory=500M
IndexMemory=100M


[MYSQLD]
Id=5
Hostname=domU-12-31-34-00-02-CC.usma2.compute.amazonaws.com

[MYSQLD]
Id=6
Hostname=domU-12-31-34-00-03-80.usma2.compute.amazonaws.com

[MYSQLD]


The cluster show is:

[root@domU-12-31-34-00-02-CC ~]# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> CONNECT 127.0.0.1:1186
Connected to Management Server at: localhost:1186
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 3 node(s)
id=2 @216.182.239.33 (Version: 5.0.27, Nodegroup: 0, Master)
id=3 @216.182.238.87 (Version: 5.0.27, Nodegroup: 0)
id=4 @216.182.239.93 (Version: 5.0.27, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @216.182.238.32 (Version: 5.0.27)

[mysqld(API)] 3 node(s)
id=5 (not connected, accepting connect from domU-12-31-34-00-02-CC.usma2.compute.amazonaws.com)
id=6 (not connected, accepting connect from domU-12-31-34-00-03-80.usma2.compute.amazonaws.com)
id=7 (not connected, accepting connect from any host)

ndb_mgm>

Options: ReplyQuote


Subject
Views
Written By
Posted
ERROR 1105 (HY000): Failed to open 'City', error while unpacking from engine
1943
January 24, 2007 05:26AM


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.