OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
ERROR 1005 (HY000): Can't create table 'user_database.user_table' (errno: 157)

From: Sai Kumar Ganji (saikumarganji.igmail.com)
Date: Mon Apr 15 2013 - 02:34:29 CDT

Hello Guys,

I am trying to setup a mysql-cluster with two data nodes and one management
node.

The sequence of step I followed are:

Ran *'ndb_mgmd' *on management node
Ran '*ndbd --initial' *on both the data nodes
Ran '*mysqld' *on both the data nodes

Then the status of the cluster on management node is:

[ndbd(NDB)] 2 node(s)
id=2 10.252.151. <http://10.252.151.67/>xx (Version: 5.1.68,
Nodegroup: 0, Master)
id=3 10.253.4. <http://10.253.4.143/>xx (Version: 5.1.68,
Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 10.253.19. <http://10.253.19.149/>xx (Version: 5.1.68)

[mysqld(API)] 2 node(s)
id=4 10.253.4. <http://10.253.4.143/>xx (Version: 5.1.68)
id=5 10.252.151. <http://10.252.151.67/>xx (Version: 5.1.68)

Then I tried to create the following 'user_table' on 'user_database':

create table user_table(
  ycsb_key varchar(32) primary key,
  field1 varchar(100), field2 varchar(100), field3 varchar(100), field4
varchar(100),
  field5 varchar(100), field6 varchar(100), field7 varchar(100), field8
varchar(100),
  field9 varchar(100), field10 varchar(100))
  max_rows=1000 engine=ndbcluster partition by key(ycsb_key);

I get this error:

*ERROR 1005 (HY000): Can't create table 'user_database.user_table' (errno:
157)*

Can you guys please help me in this .

And when I ran *mysql> show engines; *I get this
*
*

+------------+---------+-----------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment
        | Transactions | XA | Savepoints |
+------------+---------+-----------------------------------------------------------+--------------+------+------------+
| ndbcluster | DEFAULT | Clustered, fault-tolerant tables
       | YES | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables
        | NO | NO | NO |
| CSV | YES | CSV storage engine
       | NO | NO | NO |
| MyISAM | YES | Default engine as of MySQL 3.23 with great
performance | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary
tables | NO | NO | NO |
+------------+---------+-----------------------------------------------------------+--------------+------+------------+

--
Thanks & Regards

Venkata Sai Ganji
Graduate Student
Dept of Computer Science
Montana State University - Bzn