Sorry it is: Help!!! errorno: 4336
Posted by:
mon lax
Date: July 17, 2005 03:12PM
Hi,
I am trying to execute the following query on a cluster with 2 NDB and 2 API nodes and one API also being a mgmt node:
CREATE TABLE `companies` (
`company_id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`company_module` INT( 10 ) NOT NULL default 0,
`company_name` varchar( 100 ) default '',
`company_phone1` varchar( 30 ) default '',
`company_phone2` varchar( 30 ) default '',
`company_fax` varchar( 30 ) default '',
`company_address1` varchar( 50 ) default '',
`company_address2` varchar( 50 ) default '',
`company_city` varchar( 30 ) default '',
`company_state` varchar( 30 ) default '',
`company_zip` varchar( 11 ) default '',
`company_primary_url` varchar( 255 ) default '',
`company_owner` int( 11 ) NOT NULL default '0',
`company_description` text NOT NULL default '',
`company_type` int( 3 ) NOT NULL DEFAULT '0',
`company_email` varchar( 255 ) ,
`company_custom` LONGTEXT,
PRIMARY KEY ( `company_id` ) ,
KEY `idx_cpy1` ( `company_owner` )
)
The error is:
#1005 - Can't create table './dotproject/companies.frm' (errno: 4336)
Sorry for the faulty previous post.
Can somebody help me.