List:General Discussion« Previous MessageNext Message »
From:Sai Kumar Ganji Date:April 15 2013 7:34am
Subject:ERROR 1005 (HY000): Can't create table 'user_database.user_table'
View as plain text  
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

Thread
ERROR 1005 (HY000): Can't create table 'user_database.user_table'(errno: 157)Sai Kumar Ganji15 Apr