Description:
This happened during a build using the 5.0.51 sources (community tree),
when the test suite is run for the debug server.
In the optimized server, these crashes did *not* occur.
The commonality of all these crashes is that they happen for a
SELECT ... ORDER BY
mysqltest [ pass ] 32083
ndb_alter_table [ pass ] 57626
ndb_alter_table2 [ pass ] 5663
ndb_autodiscover [ pass ] 116643
ndb_autodiscover2 [ pass ] 6154
ndb_autodiscover3 [ pass ] 113929
ndb_backup_print [ pass ] 8515
ndb_basic [ fail ]
mysqltest: At line 94: query 'SELECT * FROM t1 ORDER BY id' failed: 2013: Lost connection to MySQL server during query
The result from queries just before the failure was:
< snip >
SELECT * FROM t1;
pk1 attr1 attr2 attr3
9411 9413 NULL NULL
DROP TABLE t1;
CREATE TABLE t1 (id INT, id2 int) engine=ndbcluster;
INSERT INTO t1 values(3456, 7890);
SELECT * FROM t1;
id id2
3456 7890
UPDATE t1 SET id=2 WHERE id2=12;
SELECT * FROM t1;
id id2
3456 7890
UPDATE t1 SET id=1234 WHERE id2=7890;
SELECT * FROM t1;
id id2
1234 7890
DELETE FROM t1;
INSERT INTO t1 values(3456, 7890), (3456, 7890), (3456, 7890), (3454, 7890);
SELECT * FROM t1 ORDER BY id;
More results from queries before failure can be found in /data/mysqldev/tmp-200711150808-5.0.51-30861/aix52/test/mysql-debug-5.0.51-aix5.2-powerpc/mysql-test/var/log/ndb_basic.log
Stopping All Servers
ndb_bitfield [ fail ]
mysqltest: At line 46: query 'select a+0 from t1 order by a' failed: 2013: Lost connection to MySQL server during query
...
ndb_blob [ pass ] 60211
ndb_bug26793 [ pass ] 63498
ndb_cache [ pass ] 2266
ndb_cache2 [ pass ] 9135
ndb_cache_multi [ pass ] 2754
ndb_cache_multi2 [ pass ] 3964
ndb_charset [ pass ] 31857
ndb_condition_pushdown [ pass ] 26404
ndb_config [ pass ] 6174
ndb_database [ pass ] 4411
ndb_gis [ fail ]
mysqltest: In included file "./include/gis_generic.inc": At line 75: query 'SELECT fid, AsText(g) FROM gis_point ORDER by fid' failed: 2013: Lost connection to MySQL server during query
...
ndb_index [ pass ] 7483
ndb_index_ordered [ pass ] 49753
ndb_index_unique [ pass ] 86338
ndb_insert [ fail ]
mysqltest: At line 617: query 'SELECT * FROM t1 ORDER BY a' failed: 2013: Lost connection to MySQL server during query
...
ndb_limit [ pass ] 11876
ndb_load [ fail ]
mysqltest: At line 21: query 'SELECT * FROM t1 ORDER BY word' failed: 2013: Lost connection to MySQL server during query
...
How to repeat:
Run the test suite on a debug server.