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.
