Bug #32789 MySQL server crashes in SELECT ... ORDER BY when using NDB (platform-specific)
Submitted: 27 Nov 2007 19:44 Modified: 22 Sep 2010 10:29
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:mysql-5.0 OS:IBM AIX (32 bit, debug build)
Assigned to: Jonas Oreland CPU Architecture:Any
Tags: 5.0.51
Triage: Triaged: D1 (Critical)

[27 Nov 2007 19:44] Joerg Bruehe
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.
[22 Sep 2010 10:29] Jonas Oreland
aix not supported any longer
closing