MySQL Bugs: #41205: Cluster failing most tests in 4.1.25-pre x86 and x86

Bug #41205	Cluster failing most tests in 4.1.25-pre x86 and x86_64
Submitted:	3 Dec 2008 16:36	Modified:	5 Dec 2008 7:15
Reporter:	Kent Boortz	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S1 (Critical)
Version:	4.1.25-pre	OS:	Linux (x86 & x86_64)
Assigned to:		CPU Architecture:	Any

Description:
Regression test show that most cluster tests fail, Linux 32 and 64 bits x86.
Failures are the same on both platforms, making it likely it caused by the
same bug, and that it is not random.

Failures include

----------------------------------------
ndb_multi (and ndb_cache, ndb_loaddatalocal, ndb_load, ndb_restore, ndb_alter_table, ndb_truncate)

At line 13: query 'create table t1 (a int) engine=ndbcluster' failed: 1005: Can't create table './test/t1.frm' (errno: 4336)
----------------------------------------
ndb_insert (and ndb_transaction, ndb_blob, ndb_lock, ndb_autodiscover, ndb_update, ndb_subquery, ps_7ndb, ndb_basic, ndb_index_ordered, ndb_index_unique, ndb_index, ndb_limit)

At line 21: query 'INSERT INTO t1 VALUES (0, 0, 0)' failed: 1296: Got error 840 'Trying to set a NOT NULL attribute to NULL' from ndbcluster
----------------------------------------
ndb_autodiscover2

At line 10: query 'select * from t9 order by a' failed: 1146: Table 'test.t9' doesn't exist
----------------------------------------
ndb_minmax

At line 19: query 'select MAX(a) from t1' failed: 2013: Lost connection to MySQL server during query
----------------------------------------
ndb_charset

At line 22: query 'select * from t1 order by a' failed: 2013: Lost connection to MySQL server during query
----------------------------------------
ndb_autodiscover3

At line 35: query 'select * from t2 order by a limit 3' failed: 2013: Lost connection to MySQL server during query
----------------------------------------
ndb_replace

At line 20: query 'replace into t1 (gesuchnr,benutzer_id) values (1,1)' failed: 1297: Got temporary error 286 'Node failure caused abort of transaction' from ndbcluster
----------------------------------------

There are also core files produced from some of the test cases

var/log/ndb_autodiscover3/core.21425: ...from 'mysqld'
var/log/ndb_charset/core.22157:       ...from 'mysqld'
var/log/ndb_minmax/core.24296:        ... from 'mysqld'

How to repeat:
Compile and run the ndb test cases in the regression suite

Test 'ndb_minmax' stack trace

Attachment: ndb_minmax-stack-trace.txt (text/plain), 7.54 KiB.

Test 'ndb_charset' stack trace

Attachment: ndb_charset-stack-trace.txt (text/plain), 6.25 KiB.

Test 'ndb_autodiscover3' stack trace

Attachment: ndb_autodiscover3-stack-trace.txt (text/plain), 8.18 KiB.

The problem was that MySQL custer on Linux x86 and x86_64 doesn't work
well if compiled with gcc 4. Switching to gcc 3 made the test failures
go away.