Bug #37807 ndb.ndb_dd_basic fails randomly
Submitted: 2 Jul 2008 12:20 Modified: 7 Oct 2009 12:32
Reporter: Alexander Nozdrin Email Updates:
Status: Won't fix Impact on me:
None 
Category:Tools: MTR / mysql-test-run Severity:S3 (Non-critical)
Version:6.0-BK OS:Any
Assigned to: Magnus Blåudd CPU Architecture:Any
Tags: pushbuild, sporadic, test failure

[2 Jul 2008 12:20] Alexander Nozdrin
Description:
ndb.ndb_dd_basic               [ fail ]

mysqltest: At line 238: query 'CREATE TABLE City (
ID int(11) NOT NULL AUTO_INCREMENT,
Name char(35) NOT NULL,
CountryCode char(3) NOT NULL,
District char(20) NOT NULL,
Population int(11) NOT NULL,
PRIMARY KEY (ID)
) ENGINE=ndbcluster
tablespace ts2
storage disk' failed: 1005: Can't create table 'test.City' (errno: 146)

The result from queries just before the failure was:
< snip >
ADD UNDOFILE 'x.dat'
INITIAL_SIZE 1000000000000K
ENGINE = NDB;
ERROR HY000: The size number was correct but we don't allow the digit part to be more than 2 billion
DROP TABLE t1;
create tablespace ts2
add datafile 'datafile2_1.dat'
use logfile group lg1
initial_size 12M
engine ndb;
CREATE TABLE City (
ID int(11) NOT NULL AUTO_INCREMENT,
Name char(35) NOT NULL,
CountryCode char(3) NOT NULL,
District char(20) NOT NULL,
Population int(11) NOT NULL,
PRIMARY KEY (ID)
) ENGINE=ndbcluster
tablespace ts2
storage disk;

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?testname=ndb.ndb_dd_basic
[12 Feb 2009 14:32] Martin Skold
Is this still occuring?
[7 Oct 2009 12:32] Magnus Blåudd
Reported against 6.0 -> won't fix.