Re: Can't create table - Mikael Ronström - com.mysql.lists.cluster

11 messages in com.mysql.lists.clusterRe: Can't create table

From	Sent On	Attachments
Tatiana Peña	21 Sep 2004 09:53
Mikael Ronström	21 Sep 2004 13:46
Tatiana Peña	22 Sep 2004 20:34
Tomas Ulin	23 Sep 2004 02:44
Tatiana Peña	23 Sep 2004 07:16
Tomas Ulin	23 Sep 2004 11:52
Tatiana Peña	25 Sep 2004 17:15
Magnus Svensson	26 Sep 2004 01:15
Tatiana Peña	27 Sep 2004 17:08
Tatiana Peña	27 Sep 2004 17:12
Magnus Svensson	28 Sep 2004 00:19

Subject:	Re: Can't create table
From:	Mikael Ronström (mik...@mysql.com)
Date:	09/21/2004 01:46:02 PM
List:	com.mysql.lists.cluster

Hi Tayota,

4336 has something to do with Autoincrement during create table. I know some bug were fixed on this in the 4.1.5 but cannot be sure whether this is the one.

Rgrds Mikael

2004-09-21 kl. 18.54 skrev Tatiana Peña:

Hello!!

I have a cluster running using mysql-4.1.4a-gamma, on Debian 3.0 stable. It has a master (MGM), two DBs and two (API). I included the config.ini file at the end.

When I was trying to follow the Quick Test on http://dev.mysql.com/doc/mysql/en/MySQL_Cluster_quick.html, I got an error trying to create a table

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

I've created another databases but I cannot create tables on them :(

What does that error means (errno:4336)?

Thanks a lot for your help!!

---------config.ini--------- [DB DEFAULT] NoOfReplicas: 2

[COMPUTER] Id: 1 HostName: dip.ola.com.co

[COMPUTER] Id: 2 HostName: proc1.ola.com.co

[COMPUTER] Id: 3 HostName: proc2.ola.com.co

[MGM] Id: 1 ExecuteOnComputer: 1

[DB] Id: 2 ExecuteOnComputer: 2 FileSystemPath: /eva0/mysql/ndb/data DataMemory: 1000M IndexMemory: 400M

[DB] Id: 3 ExecuteOnComputer: 3 FileSystemPath: /eva0/mysql/ndb/data DataMemory: 1000M IndexMemory: 400M

[API] Id: 4 ExecuteOnComputer: 2

[API] Id: 5 ExecuteOnComputer: 3

[TCP DEFAULT] PortNumber: 10002

# [TCP] # NodeId1: 1 # NodeId2: 2

# [TCP] # NodeId1: 2 # NodeId2: 3

--------

Mikael Ronström, Senior Software Architect MySQL AB, www.mysql.com

Clustering: http://www.infoworld.com/article/04/04/14/HNmysqlcluster_1.html

http://www.eweek.com/article2/0,1759,1567546,00.asp