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