List:Cluster« Previous MessageNext Message »
From:mysql_list Mysql Cluster Date:September 1 2009 8:35am
Subject:Can't create table 'account' (errno: 783)
View as plain text  
Configuration:
4 x ndb 7.0.6 servers (2GB RAM, 2xXeon 2.4GHz)
1 x api (2GB RAM, 2xXeon 2.4GHz)
=================================================


Trying to create table in database:

CREATE TABLE account (
  i_account int(10) unsigned NOT NULL auto_increment,
  id varchar(32) NOT NULL,
  `password` varchar(16) character set utf8 collate utf8_bin default NULL,
  balance decimal(15,5) NOT NULL default '0.00000',
  opening_balance decimal(15,5) NOT NULL default '0.00000',
  issue_date date NOT NULL default '0000-00-00',
  zero_balance_date date default NULL,
  i_customer int(10) unsigned NOT NULL default '0',
  billing_model tinyint(2) NOT NULL default '0',
  activation_date date NOT NULL default '0000-00-00',
  expiration_date date default NULL,
  i_product int(10) unsigned NOT NULL default '0',
  blocked char(1) NOT NULL default 'N',
  last_usage datetime default NULL,
  i_batch int(10) unsigned NOT NULL default '0',
  i_env tinyint(1) unsigned NOT NULL default '1',
  first_usage date default NULL,
  life_time smallint(4) unsigned default NULL,
  redirect_number varchar(32) default NULL,
  control_number int(10) unsigned NOT NULL default '0',
  i_time_zone int(10) unsigned NOT NULL default '1',
  credit_limit decimal(15,5) default NULL,
  iso_4217 char(3) character set utf8 NOT NULL,
  non_call_related_charges decimal(15,5) default NULL,
  refunds decimal(15,5) default NULL,
  login varchar(64) character set utf8 default NULL,
  email varchar(128) character set utf8 default NULL,
  password_timestamp datetime default NULL,
  i_acl int(10) unsigned NOT NULL default '155',
  i_subscriber int(10) unsigned default NULL,
  i_lang char(5) default NULL,
  ua_profile_id int(10) unsigned default NULL,
  follow_me_enabled char(1) NOT NULL default 'N',
  timer datetime default NULL,
  ecommerce_enabled char(1) default 'N',
  out_date_format varchar(16) character set utf8 NOT NULL,
  out_time_format varchar(16) character set utf8 NOT NULL,
  out_date_time_format varchar(32) character set utf8 NOT NULL,
  in_date_format varchar(16) character set utf8 NOT NULL,
  in_time_format varchar(16) character set utf8 NOT NULL,
  i_vd_plan int(10) unsigned default NULL,
  last_recharge datetime default NULL,
  i_moh int(10) unsigned default NULL,
  service_flags varchar(32) character set utf8 NOT NULL,
  PRIMARY KEY  (i_account),
  UNIQUE KEY Accounts_id (id,i_env),
  UNIQUE KEY Accounts_login (login),
  KEY Account_customer (i_customer),
  KEY Accounts_product (i_product),
  KEY AccountsProfileId (ua_profile_id),
  KEY Accounts_iso_4217 (iso_4217),
  KEY env_id (i_env,id),
  KEY AccountFirstUsage (first_usage),
  KEY i_vd_plan (i_vd_plan),
  KEY Accounts_i_acl (i_acl)
 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;


Getting - (errno: 783)

===
Trying to add like this:
CREATE TABLE account (
  i_account int(10) unsigned NOT NULL auto_increment,
  id varchar(32) NOT NULL,
  `password` varchar(16) character set utf8 collate utf8_bin default NULL,
  balance decimal(15,5) NOT NULL default '0.00000',
  opening_balance decimal(15,5) NOT NULL default '0.00000',
  issue_date date NOT NULL default '0000-00-00',
  zero_balance_date date default NULL,
  i_customer int(10) unsigned NOT NULL default '0',
  billing_model tinyint(2) NOT NULL default '0',
  activation_date date NOT NULL default '0000-00-00',
  expiration_date date default NULL,
  i_product int(10) unsigned NOT NULL default '0',
  blocked char(1) NOT NULL default 'N',
  last_usage datetime default NULL,
  i_batch int(10) unsigned NOT NULL default '0',
  i_env tinyint(1) unsigned NOT NULL default '1',
  first_usage date default NULL,
  life_time smallint(4) unsigned default NULL,
  redirect_number varchar(32) default NULL,
  control_number int(10) unsigned NOT NULL default '0',
  i_time_zone int(10) unsigned NOT NULL default '1',
  credit_limit decimal(15,5) default NULL,
  iso_4217 char(3) character set utf8 NOT NULL,
  non_call_related_charges decimal(15,5) default NULL,
  refunds decimal(15,5) default NULL,
  login varchar(64) character set utf8 default NULL,
  email varchar(128) character set utf8 default NULL,
  password_timestamp datetime default NULL,
  i_acl int(10) unsigned NOT NULL default '155',
  i_subscriber int(10) unsigned default NULL,
  i_lang char(5) default NULL,
  ua_profile_id int(10) unsigned default NULL,
  follow_me_enabled char(1) NOT NULL default 'N',
  timer datetime default NULL,
  ecommerce_enabled char(1) default 'N',
  out_date_format varchar(16) character set utf8 NOT NULL,
  out_time_format varchar(16) character set utf8 NOT NULL,
  out_date_time_format varchar(32) character set utf8 NOT NULL,
  in_date_format varchar(16) character set utf8 NOT NULL,
  in_time_format varchar(16) character set utf8 NOT NULL,
  i_vd_plan int(10) unsigned default NULL,
  last_recharge datetime default NULL,
  i_moh int(10) unsigned default NULL,
  service_flags varchar(32) character set utf8 NOT NULL,
  PRIMARY KEY  (i_account)
 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;

Table created without problem. Trying to add more keys:
 CREATE INDEX Account_customer ON account (i_customer);

And server crashed.

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2013 (HY000): Lost connection to MySQL server during query

Thread
Can't create table 'account' (errno: 783)mysql_list Mysql Cluster1 Sep
  • Re: Can't create table 'account' (errno: 783)Jonas Oreland1 Sep
    • Re: Can't create table 'account' (errno: 783)mysql_list Mysql Cluster1 Sep
      • Re: Can't create table 'account' (errno: 783)Geert Vanderkelen1 Sep