Bug #80097 The ndbcluster test suite broken for regular users
Submitted: 21 Jan 2016 11:03 Modified: 21 Jan 2016 15:47
Reporter: Magnus Blåudd Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Engine Severity:S7 (Test Cases)
Version:8.0.0 OS:Any
Assigned to: CPU Architecture:Any

[21 Jan 2016 11:03] Magnus Blåudd
Description:
After having compiled MySQL Server with NDB from mysql-trunk you should be able to run the "ndbcluster" suite to check that the integration points between MySQL Server and MySQL Cluster are still working. Running the testsuite manually with no special arguments to mtr.pl now fails the ndbcluster.pushed_join test.

1) We have an automatic check where PB builds and test that this works. This is done in mysql-trunk and all tests currently runs fine without error.

2) It should also be possible to manually run the same tests. This currently fails when running the ndbcluster.pushed_join test.

These problems are supposedly caused by recent changes to mysql-test/collections/default.push-ndbcluster

commit 56ae0a39a6c99276ce10144bca3b305ccf900e56
Author: Mohit Joshi <mohit.joshi@oracle.com>
Date:   Wed Jan 6 23:47:56 2016 +0530

    WL#8789 - Follow up fix:
    Corrections done in the below files and test-cases.
    default.push-ndbcluster
    cmp_per_index.test
    innodb-bug12552164.test
    innodb-bug12552164.test

How to repeat:
mysql-trunk> ./mtr --suite=ndbcluster --force

<snip>

ndbcluster.pushed_join                   w6 [ retry-fail ]
        Test ended at 2016-01-21 12:02:28

CURRENT_TEST: ndbcluster.pushed_join
mysqltest: In included file /home/mblaudd/mysql/trunk/mysql-test/suite/ndbcluster/pushed_join.inc at line 37:
included from /home/mblaudd/mysql/trunk/mysql-test/suite/ndbcluster/pushed_join.test at line 41:
At line 35: query 'let $defined_before =
`select VARIABLE_VALUE from information_schema.session_status
     where variable_name like 'ndb_pushed_queries_defined'`' failed: 3167: The 'INFORMATION_SCHEMA.SESSION_STATUS' feature is disabled; see the documentation for 'show_compatibility_56'

Suggested fix:
Revert changes to mysql-test/collections/default.push-ndbcluster which adds an additional argument to the mtr.pl command line for running the ndbcluster suite. Running a suite should should not require any special arguments to mtr.pl

Both PB and developer should be able to run tests without having to know special arguments.
[21 Jan 2016 15:47] Paul DuBois
Fixed in 5.8.0 and 7.5.1.

Changes for test suite. No changelog entry needed.
[18 Jun 2016 21:35] Omer Barnir
Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0