Bug #29110 NDB has no "autoincrement" in an icc/ia64 build: "Start of Master cluster failed
Submitted: 14 Jun 2007 16:15 Modified: 17 May 2008 13:15
Reporter: Joerg Bruehe Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:4.1.23 OS:Linux (IA64 / ICC only)
Assigned to: CPU Architecture:Any
Triage: D3 (Medium)

[14 Jun 2007 16:15] Joerg Bruehe
Description:
This differs from the previous reports about NDB built by icc on ia64
(like bug#21875) because we now use a newer compiler there,
version 9.1.045 (icc (ICC) 9.1 20061105).

There are some different symptoms in "ndb_*" tests on that platform,
and several tests pass,
but it seems appropriate to combine the failures in one bug report.
These test failures occur identical in the NDB tests of both a "cluster" and a "max" build.

The typical bug is error 4336 on a "create table", 
both with explicit "autoincrement" and without primary key.
The error 4336 does not occur on any other platform in the 4.1.23 tests.

::::::::::::::
ndb_alter_table                [ fail ]

ERROR: Start of Master cluster failed

::::::::::::::
ndb_autodiscover2              [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line NNN: query 'select * from t9 order by a' failed: 1146: Table 'test.t9' doesn't exist

::::::::::::::
ndb_autodiscover3              [ fail ]

Errors are (from /PATH/mysqltest-time) :
waitNodeState(STARTED, -1) timeout after 121 attemps
mysqltest: At line NNN: command "$NDB_TOOLS_DIR/ndb_waiter --no-defaults >> $NDB_TOOLS_OUTPUT" failed

::::::::::::::
ndb_autodiscover               [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line NNN: query 'create table t1(id int) engine=ndbcluster' failed: 1005: Can't create table './test/t1.frm'
(errno: 4336)

::::::::::::::
ndb_basic                      [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line NNN: query 'CREATE TABLE t1 (id INT, id2 int) engine=ndbcluster' failed: 1005: Can't create table './tes
t/t1.frm' (errno: 4336)

::::::::::::::
ndb_blob                       [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line NNN: query 'create table t1 (
id int(11) unsigned primary key NOT NULL auto_increment,
msg text NOT NULL
) engine=ndbcluster default charset=utf8' failed: 1005: Can't create table './test/t1.frm' (errno: 4336)

::::::::::::::
ndb_cache                      [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line NNN: query 'CREATE TABLE t1 (a int) ENGINE=ndbcluster' failed: 1005: Can't create table './test/t1.frm'
(errno: 4336)

::::::::::::::
ndb_index_ordered              [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line NNN: query 'CREATE TABLE test1 (
SubscrID int(11) NOT NULL auto_increment,
UsrID int(11) NOT NULL default '0',
PRIMARY KEY  (SubscrID),
KEY idx_usrid (UsrID)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1' failed: 1005: Can't create table './test/test1.frm' (errno: 4336)

::::::::::::::
ndb_index_unique               [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line NNN: query 'create table t1(
id integer not null auto_increment,
month integer not null,
year integer not null,
code varchar( 2) not null,
primary key ( id),
unique idx_t1( month, code, year)
) engine=ndb' failed: 1005: Can't create table './test/t1.frm' (errno: 4336)

::::::::::::::
ndb_insert                     [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line NNN: query 'CREATE TABLE t1(a INT) ENGINE=ndb' failed: 1005: Can't create table './test/t1.frm' (errno:
4336)

::::::::::::::
ndb_limit                      [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line NNN: query 'delete from t2 limit 1000' failed: 1297: Got temporary error 4031 'Node failure caused abort
 of transaction' from ndbcluster

::::::::::::::
ndb_load                       [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line NNN: query 'CREATE TABLE t1 (word CHAR(20) NOT NULL) ENGINE=NDB' failed: 1005: Can't create table './tes
t/t1.frm' (errno: 4336)

::::::::::::::
ndb_loaddatalocal              [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line NNN: query 'create table t1(a int) engine=ndb' failed: 1005: Can't create table './test/t1.frm' (errno:
4336)

::::::::::::::
ndb_multi                      [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line NNN: query 'create table t1 (a int) engine=ndbcluster' failed: 1005: Can't create table './test/t1.frm'
(errno: 4336)

::::::::::::::
ndb_restore                    [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line NNN: query 'create table t1_c engine=ndbcluster as select * from t1' failed: 1005: Can't create table '.
/test/t1_c.frm' (errno: 4336)

::::::::::::::
ndb_transaction                [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line NNN: query 'CREATE TABLE t1 (id INT, id2 int) engine=ndbcluster' failed: 1005: Can't create table './tes
t/t1.frm' (errno: 4336)

::::::::::::::
ndb_truncate                   [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line NNN: query 'CREATE TABLE t1 (
a bigint unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
b int unsigned not null,
c int unsigned
) engine=ndbcluster' failed: 1005: Can't create table './test/t1.frm' (errno: 4336)

How to repeat:
Found by running the test suite on an ia64/icc build.
[14 Jun 2007 16:33] Joerg Bruehe
Remove "ndb_autodiscover2" and "ndb_autodiscover3" from the above list,
this seems to be a different issue.
[14 Apr 2008 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[17 Apr 2008 13:15] Susanne Ebrecht
Joerg,

feedback is still needed here.
[17 May 2008 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".