7 messages in com.mysql.lists.clusterRe: Error 1005: can't create tabe: er...
FromSent OnAttachments
Junzo(Acorn Networks)25 Oct 2004 09:36 
Junzo Tamada26 Oct 2004 05:19 
Junzo Tamada26 Oct 2004 07:07 
Tomas Ulin26 Oct 2004 07:08 
Junzo Tamada26 Oct 2004 07:46 
Hugo Kohmann27 Oct 2004 12:01 
Junzo Tamada28 Oct 2004 00:00 
Subject:Re: Error 1005: can't create tabe: errorno=4009
From:Junzo Tamada (tam@acornnetworks.co.jp)
Date:10/26/2004 05:19:04 AM
List:com.mysql.lists.cluster

Thank you for your advice. I have found that the latest code of 4.1.6-gamma works well so far. I'm not so sure what was wrong. But with the same configuration file, the latest code works anyway.

The code I used previously was almost one month old. Do you have any revision number to identify the code even using a version of 4.1.6-gamma ?

Thank you very much. /Junzo

----- Original Message ----- From: "Tomas Ulin" <tom@mysql.com> To: "Junzo(Acorn Networks)" <tam@acornnetworks.co.jp> Cc: <clus@lists.mysql.com> Sent: Tuesday, October 26, 2004 11:08 PM Subject: Re: Error 1005: can't create tabe: errorno=4009

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