Re: ERROR 1005 (HY000): Can't create table - Mikael Ronström - com.mysql.lists.cluster

4 messages in com.mysql.lists.clusterRe: ERROR 1005 (HY000): Can't create ...

From	Sent On	Attachments
Frank Fuhrmann	23 Sep 2005 04:39
Mikael Ronström	23 Sep 2005 05:31
Frank Fuhrmann	23 Sep 2005 06:11
Stewart Smith	24 Sep 2005 01:30

Subject:	Re: ERROR 1005 (HY000): Can't create table
From:	Mikael Ronström (mik...@mysql.com)
Date:	09/23/2005 05:31:57 AM
List:	com.mysql.lists.cluster

Hi Frank,

2005-09-23 kl. 13.39 skrev Frank Fuhrmann:

Hi,

I've a problem creating tables in my cluster. If i try to create a table in a new database, i get the following error:

mysql> CREATE TABLE ctest (i INT) ENGINE=NDBCLUSTER; ERROR 1005 (HY000): Can't create table './foo/ctest.frm' (errno: 4009)

This means that the MySQL Server considers the cluster down. The listing below verifies that since the cluster is still starting.

And the management console gives the following output:

ndb_mgm> show Cluster Configuration

--------------------- [ndbd(NDB)] 2 node(s) id=2 @192.168.1.4 (Version: 4.1.9, starting, Nodegroup: 0, Master) id=3 @123.123.123.124 (Version: 4.1.9, starting, Nodegroup: 0, Master)

Looks to me as if there is no connection working between id 2 and id 3 (should they really be on different IP networks, 192.168 looks like a local IP address and 123 looks like a public IP address). This I defer by that both considers themselves Masters and thus they can't know of each other although the management server obviously manages to communicate with both of them.

Rgrds Mikael

[ndb_mgmd(MGM)] 1 node(s) id=1 @123.123.123.123 (Version: 4.1.9)

I built the cluster with this howto: http://www.davz.net/static/howto/mysqlcluster

The same problem occurs, if there is only one storage node in the cluster.

Mikael Ronstrom, Senior Software Architect MySQL AB, www.mysql.com

Jumpstart your cluster: http://www.mysql.com/consulting/packaged/cluster.html