Bug #39999 errno: 140
Submitted: 13 Oct 2008 12:51 Modified: 14 Oct 2008 12:47
Reporter: feniksa Gordon Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:mysql-5.1.23 ndb-6.2.15 OS:Linux
Assigned to: CPU Architecture:Any
Tags: Can't create table 'testingme.User' (errno: 140)

[13 Oct 2008 12:51] feniksa Gordon 
Description:
I am trying to execute ths part of sql to create a struct of table (in a future it will contain a lot of data).

USE testingme;

DROP TABLE IF EXISTS `User`;
CREATE TABLE `User` (
  `Id` int(11) NOT NULL auto_increment,
  `IdUserLink` int(11) NOT NULL default '0',
  `PublicId` text character set cp1251 NOT NULL default '',
  `Role` enum('buyer','provider') character set cp1251 NOT NULL default 'buyer',
  `IsModerator` tinyint(4) NOT NULL default '0',
  `Login` text character set cp1251 NOT NULL default '',
  `Password` text character set cp1251 NOT NULL default '',
  `Email` text character set cp1251 NOT NULL default '',
  `FirstName` text character set cp1251 NOT NULL default '',
  `LastName` text character set cp1251 NOT NULL default '',
  `Title` text character set cp1251 NOT NULL default '',
  `IdCountryDB` int(11) NOT NULL default '0',
  `IdPrimaryLanguage` int(11) NOT NULL default '0',
  `Confirmation` varchar(255) character set cp1251 NOT NULL default '',
  `Status` enum('pending','listed','registered','poster_no_bid','poster_no_offer','bidder','contractor','repeater','cancelled','blocked','deleted') collate utf8_bin NOT NULL default 'pending',
  `Address` varchar(255) character set cp1251 NOT NULL default '',
  `City` text character set cp1251 NOT NULL default '',
  `State` text character set cp1251 NOT NULL default '',
  `Zip` text collate utf8_bin NOT NULL default '',
  `IdTimeZoneDB` int(11) NOT NULL default '0',
  `Company` text character set cp1251 NOT NULL default '',
  `Function` varchar(150) character set cp1251 NOT NULL default '',
  `ProjectNotification` int(11) NOT NULL default '0',
  `EmailFormat` enum('html','text') character set cp1251 NOT NULL default 'html',
  `ProviderRate` double(10,2) NOT NULL default '0.00',
  `ProviderRateCurrency` int(11) NOT NULL default '0',
  `RegisterDate` int(11) NOT NULL default '0',
  `FirmPermise` tinyint(4) NOT NULL default '0',
  `IdFileDBPhoto` tinyint(4) NOT NULL default '0',
  `TaxNumber` text character set cp1251 NOT NULL default '',
  `ReviewOverall` double(3,2) NOT NULL default '0.00',
  `AccountValue` double(10,2) NOT NULL default '0.00',
  `EcrowValue` double(10,2) NOT NULL default '0.00',
  `IsPortfolio` tinyint(1) NOT NULL default '0',
  `IsOnSiteSupport` tinyint(1) NOT NULL default '0',
  `IdProviderMembershipDB` int(11) NOT NULL default '1',
  `SessionBackUrl` varchar(255) collate utf8_bin NOT NULL default '',
  `SessionParameterName` text collate utf8_bin NOT NULL default '',
  `SessionParameterData` text collate utf8_bin NOT NULL,
  `Perfomance` int(11) NOT NULL default '0',
  `Capability` int(11) NOT NULL default '0',
  `Reviews` int(11) NOT NULL default '0',
  `ActivityLevel` int(11) NOT NULL default '0',
  `LastLogin` int(11) NOT NULL default '0',
  `TotalAssignments` int(11) NOT NULL default '0',
  `IsVendor` tinyint(1) NOT NULL default '0',
  `BidCredit` smallint(6) NOT NULL default '5',
  `IsPackage` tinyint(1) NOT NULL default '0',
  `BusinessSince` int(11) NOT NULL default '0',
  `TeamSize` int(11) NOT NULL default '0',
  `BuyerTrackNumber` varchar(20) collate utf8_bin NOT NULL default '',
  `JobsClosed` int(11) NOT NULL default '0',
  `Cookie` varchar(255) collate utf8_bin NOT NULL default '',
  `Industry` varchar(255) collate utf8_bin NOT NULL default '',
  `IdIndustryDB` int(11) NOT NULL default '0',
  `IdUserSalutationDB` int(11) NOT NULL default '0',
  `Referer` int(11) NOT NULL default '0',
  `RefererPaid` tinyint(4) NOT NULL default '0',
  `DeleteDate` int(11) NOT NULL default '0',
  `IsChecked` tinyint(1) NOT NULL default '0',
  `IsBlocked` tinyint(1) NOT NULL default '0',
  `RegistrationStatus` tinyint(4) NOT NULL default '0',
  `ReferenceGrade` double(10,2) NOT NULL default '0.00',
  `PersonalDataLastStep` varchar(32) collate utf8_bin NOT NULL default '',
  `IdSegmentDB` int(11) NOT NULL default '0',
  `EscrowType` enum('safe','safe_escrow') collate utf8_bin NOT NULL default 'safe',
  `MembershipExpire` int(11) NOT NULL default '0',
  `LastPingTime` int(11) NOT NULL default '0',
  `IsCompany` tinyint(1) NOT NULL default '0',
  `MembershipStatus` enum('none','active','canceled') collate utf8_bin NOT NULL default 'none',
  `IdCurrencyPrefered` int(11) NOT NULL default '0',
  `MaxProviderRate` double(10,2) NOT NULL default '0.00',
  `MaxProviderRateCurrency` int(11) NOT NULL default '0',
  `AnnualRevenue` varchar(255) collate utf8_bin NOT NULL default '',
  `Website` text collate utf8_bin NOT NULL default '',
  `CompanyDescription` text collate utf8_bin NOT NULL,
  `References` text collate utf8_bin NOT NULL,
  `ProfileServicesSummary` text collate utf8_bin NOT NULL,
  `IdFileDBLogo` int(11) NOT NULL default '0',
  `IdFileDBVideo` int(11) NOT NULL default '0',
  `PublicEmail` text collate utf8_bin NOT NULL default '',
  `IsTicker` int(11) NOT NULL default '0',
  `IsHidden` tinyint(4) NOT NULL default '0',
  `OrderNum` int(11) NOT NULL default '100',
  `OldStatus` enum('pending','listed','registered','poster_no_bid','poster_no_offer','bidder','contractor','repeater','cancelled','blocked','deleted') collate utf8_bin NOT NULL default 'pending',
  `IsWorkSamples` tinyint(1) NOT NULL default '0',
  `ReservedEmail` text collate utf8_bin NOT NULL default '',
  `IdRefererMessageDB` int(11) NOT NULL default '0',
  `VatId` text collate utf8_bin NOT NULL,
  `IdBuyer` int(11) NOT NULL default '0',
  `IsUpdated` tinyint(4) NOT NULL default '0',
  `IsWasCompany` tinyint(4) NOT NULL default '0',
  `IsJobsFilter` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`Id`)
) ENGINE=ndbcluster DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

How to repeat:
my mysql-cluster manager config:

[NDBD DEFAULT]
NoOfReplicas=1          # i have only one node group
DataMemory=350M         # default is 80M
IndexMemory=80M         # default is 18M
MaxNoOfOrderedIndexes=512       # default 128
MaxNoOfUniqueHashIndexes=256    # default 64
MaxNoOfAttributes       = 1M    # default 1000
MaxNoOfOpenFiles = 40 #default is 40, must be a bug

[MYSQLD DEFAULT]

[NDB_MGMD DEFAULT]

[TCP DEFAULT]

# Management Server

[NDB_MGMD]
HostName=192.168.1.1

# Storage Nodes

My config of cluster manager:

[NDBD]
HostName=192.168.1.110
DataDir=/var/lib/mysql-cluster

[NDBD]
HostName=192.168.1.113
DataDir=/var/lib/mysql-cluster

# Setup node IDs for mySQL API-servers (clients of the cluster)
[MYSQLD]
HostName=192.168.1.110

[MYSQLD]
HostName=192.168.1.113

try to execute this sql.
[19 Jul 2006 17:23] Martin Friebe 
.
[13 Oct 2008 21:03] Sveta Smirnova 
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Please read at http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-limitations-database-objects.html about limitations of NDB storage engine.
[14 Oct 2008 12:47] feniksa Gordon 
thanks for answer