MySQL Forums
Forum List  »  NDB clusters

Re: can not use indexes with mySQL Cluster?
Posted by: Mikael Ronström
Date: June 01, 2005 01:12PM

Hi,
4009 means cluster failure so the query will work when the cluster is up.

Rgrds Mikael

Anton Aleksandrov wrote:
> Guys.. Could you please give me simple answer -
> does MySQL cluster support indexes and primary
> keys or not? I have setup MySQL cluster with the
> following configuration: 6 data nodes, 3 API
> nodes, 1 management server (which is one of the
> API nodes at the same time). It works until I try
> to run the following SQL...
>
> mysql> CREATE TABLE GBbuffer (
> -> id int(10) NOT NULL default '0',
> -> til int(6) NOT NULL default '0',
> -> fra int(6) NOT NULL default '0',
> -> beskjed text,
> -> tid datetime default NULL,
> -> PRIMARY KEY (id)
> -> ) ENGINE=NDBCLUSTER;
> ERROR 1005 (HY000): Can't create table
> './test/GBbuffer.frm' (errno: 4009)
>
> After that all data nodes crashes and I have to go
> and start them again. I would appreciate your
> help.

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog: http://mikaelronstrom.blogspot.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: can not use indexes with mySQL Cluster?
2145
June 01, 2005 01:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.