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
>
>
