List:Cluster« Previous MessageNext Message »
From:Tomas Ulin Date:October 26 2004 2:08pm
Subject:Re: Error 1005: can't create tabe: errorno=4009
View as plain text  
The mysql server is not connected to the cluster.  Please verify with:

echo "show" | ndb_mgm

which should display rows (among others):
...
mysqld(API) ...
Id=6 .... connected ...
...

BR,

T

Junzo(Acorn Networks) wrote:

> Hello
>
> I am facing a problem shown below.
> I found very similar problem in this mailing list, but it seems to me
> that solution is not clear yet
> I use 4.1.6-gamma compiled from source with compile-pentium-max
> script. I just followed procedures in chapter 17 of the cluster manual.
> mysql> use test;
> Database changed
> mysql> create table ctest (i int) engine=ndbcluster;
> ERROR 1005 (HY000): Can't create table './test/ctest.frm' (errno: 4009)
> mysql>
>
> ---/etc/my.cnf---
> [client]
> port=3306
> socket=/tmp/mysql.sock
> [mysqld]
> socket=/tmp/mysql.sock
> port=3306
> datadir=./data
> basedir=/usr/local/mysql
> ndbcluster
> ---/etc/my.cnf end---
> ---config.ini---
> [COMPUTER]
> ID: 1
> HostName:pine
> [COMPUTER]
> ID: 2
> HostName:c1
> [COMPUTER]
> ID: 3
> HostName:c2
> [COMPUTER]
> ID: 4
> HostName:c3
> [COMPUTER]
> ID: 5
> HostName:c4
>
> [NDBD DEFAULT]
> NoOfReplicas= 2
>
> [NDB_MGMD]
> Id: 1
> ExecuteOnComputer: 1
> PortNumber: 10000
> PortNumberStats: 10001
> LogDestination: 
> CONSOLE;SYSLOG:facility=syslog;FILE:filename=/home/mysql/tamada/log/cluster.log, 
> maxsize=1000000,maxfiles=6
> ArbitrationRank: 1
>
> [NDBD]
> Id: 2
> ExecuteOnComputer: 2
> FileSystemPath: /home/mysql/tamada/filesystem/2
> DataDir: /home/mysql/tamada/2
> [NDBD]
> Id: 3
> ExecuteOnComputer: 3
> FileSystemPath: /home/mysql/tamada/filesystem/3
> DataDir: /home/mysql/tamada/3
> [NDBD]
> Id: 4
> ExecuteOnComputer: 4
> FileSystemPath: /home/mysql/tamada/filesystem/4
> DataDir: /home/mysql/tamada/4
> [NDBD]
> Id: 5
> ExecuteOnComputer: 5
> FileSystemPath: /home/mysql/tamada/filesystem/5
> DataDir: /home/mysql/tamada/5
>
> [MYSQLD]
> Id: 6
> ExecuteOnComputer: 1
>
> [TCP DEFAULT]
> SendSignalId: N
> Checksum: N
> SendBufferMemory: 256k
> ReceiveBufferMemory: 64k
>
> # TCP/IP connection
> # MGM <-> DB
> [TCP]
> NodeId1: 1
> NodeId2: 2
> [TCP]
> NodeId1: 1
> NodeId2: 3
> [TCP]
> NodeId1: 1
> NodeId2: 4
> [TCP]
> NodeId1: 1
> NodeId2: 5
> # DB <-> DB
> [TCP]
> NodeId1: 2
> NodeId2: 3
> [TCP]
> NodeId1: 2
> NodeId2: 4
> [TCP]
> NodeId1: 2
> NodeId2: 5
> [TCP]
> NodeId1: 3
> NodeId2: 4
> [TCP]
> NodeId1: 3
> NodeId2: 5
> [TCP]
> NodeId1: 4
> NodeId2: 5
> # DB <-> API
> [TCP]
> NodeId1: 2
> NodeId2: 6
> [TCP]
> NodeId1: 3
> NodeId2: 6
> [TCP]
> NodeId1: 4
> NodeId2: 6
> [TCP]
> NodeId1: 5
> NodeId2: 6
> --- config.ini end---
> Thank you in advance.
> /Junzo
>
>

Thread
Error 1005: can't create tabe: errorno=4009Junzo(Acorn Networks)25 Oct
  • Re: Error 1005: can't create tabe: errorno=4009Tomas Ulin26 Oct
  • Re: Error 1005: can't create tabe: errorno=4009Junzo Tamada26 Oct
  • MySQL Cluster with SCI interconnectJunzo Tamada26 Oct