ERROR 1105 (HY000): Failed to open 'City', error while unpacking from engine
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>
Subject
Views
Written By
Posted
ERROR 1105 (HY000): Failed to open 'City', error while unpacking from engine
1943
January 24, 2007 05:26AM
1408
January 26, 2007 06:15AM
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.