List:Cluster« Previous MessageNext Message »
From:Johan Andersson Date:April 15 2013 7:34am
Subject:Re: ERROR 1005 (HY000): Can't create table 'user_database.user_table'
View as plain text  
HI,
Where did you find the MySQL 5.1.68 release?
I do recommend you use an Oracle build instead.

However, the mysql error log should reveal some more information as it
looks like the MySQL Server is not really connected to the data nodes (but
managed to connect to the management node.

Best regards
Johan


On Mon, Apr 15, 2013 at 9:16 AM, Sai Kumar Ganji
<saikumarganji.i@stripped>wrote:

> 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
  • Re: ERROR 1005 (HY000): Can't create table 'user_database.user_table'(errno: 157)Johan Andersson15 Apr