Bug #93209 Rapid plugin mtr tests not skipped mysql source complied with -DWITH_RAPID=OFF
Submitted: 15 Nov 2018 14:06 Modified: 21 Nov 2018 13:39
Reporter: lalit Choudhary Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Compiling Severity:S3 (Non-critical)
Version:5.7, 5.7.24 OS:Any
Assigned to: CPU Architecture:Any
Tags: mtr

[15 Nov 2018 14:06] lalit Choudhary
Description:
Hi,

Rapid plugin mtr tests are not skipped even if MySQL source complied with -DWITH_RAPID=OFF.

These tests should be skipped by mtr, for example, debug tests skipped if source not complied with debug option.

How to repeat:
Complied MySQL source with -DWITH_RAPID=OFF and run following mtr tests

./mtr x.mysqlxtest_help
Logging: ./mtr  x.mysqlxtest_help
MySQL Version 5.7.23
Checking supported features...
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
Removing old var directory...
Creating var directory '/home/lalit/git/percona-server_dbg/mysql-test/var'...
Installing system database...
Using parallel: 1

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
x.mysqlxtest_help                        [ fail ]
        Test ended at 2018-11-15 18:34:58

CURRENT_TEST: x.mysqlxtest_help
mysqltest: At line 11: command "$MYSQLXTEST --help  2>&1" failed with wrong error: 127

The result from queries just before the failure was:

############################################################
## Test mysqlxtest executable help printout
##
safe_process[8930]: Child process: 8931, exit: 1

**************************************************************************************************************

$ ./mtr --suite=x
Logging: ./mtr  --suite=x
MySQL Version 5.7.23
Checking supported features...
 - SSL connections supported
 - binaries are debug compiled
Using suites: x
Collecting tests...
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/lalit/git/percona-server_dbg/mysql-test/var'...
Installing system database...
Using parallel: 1

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13019
x.notices_enable                         [ skipped ]  Mysqlx plugin not available.
x.notices_enable_mysqlx                  [ skipped ]  Mysqlx plugin not available.
x.binary_log                             [ skipped ]  Mysqlx plugin not available.
x.connection_skip_networking_win         [ skipped ]  Need windows
x.connection_ipv6                        [ skipped ]  Mysqlx plugin not available.
x.performance_schema_threads             [ skipped ]  Mysqlx plugin not available.
x.regression                             [ skipped ]  Mysqlx plugin not available.
x.connection_tls_version                 [ skipped ]  Mysqlx plugin not available.
x.connection_openssl                     [ skipped ]  Mysqlx plugin not available.
x.connection_yassl                       [ skipped ]  Need YaSSL support
x.admin_list_objects_case_sensitive_names_forced [ skipped ]  Mysqlx plugin not available.
x.performance_schema                     [ skipped ]  Mysqlx plugin not available.
x.performance_schema_sockets             [ skipped ]  Mysqlx plugin not available.
x.capabilities                           [ skipped ]  Mysqlx plugin not available.
x.connection_nonssl                      [ skipped ]  Mysqlx plugin not available.
x.status_variables                       [ skipped ]  Mysqlx plugin not available.
x.notices_disable                        [ skipped ]  Mysqlx plugin not available.
x.notices_disable_mysqlx                 [ skipped ]  Mysqlx plugin not available.
x.crud_create_view                       [ skipped ]  Mysqlx plugin not available.
x.message_protobuf_nested                [ skipped ]  Mysqlx plugin not available.
x.status_variable_errors_unknown_message_type [ skipped ]  Mysqlx plugin not available.
x.system_variable_max_allowed_packet     [ skipped ]  Mysqlx plugin not available.
x.connection_expired_certs               [ skipped ]  Mysqlx plugin not available.
x.admin_bogus                            [ skipped ]  Mysqlx plugin not available.
x.admin_bogus_mysqlx                     [ skipped ]  Mysqlx plugin not available.
x.admin_create_collection                [ skipped ]  Mysqlx plugin not available.
x.admin_create_collection_mysqlx         [ skipped ]  Mysqlx plugin not available.
x.admin_create_index_datetime            [ skipped ]  Mysqlx plugin not available.
x.admin_create_index_datetime_mysqlx     [ skipped ]  Mysqlx plugin not available.
x.admin_create_index_string              [ skipped ]  Mysqlx plugin not available.
x.admin_create_index_string_mysqlx       [ skipped ]  Mysqlx plugin not available.
x.admin_ensure_collection                [ skipped ]  Mysqlx plugin not available.
x.admin_ensure_collection_mysqlx         [ skipped ]  Mysqlx plugin not available.
x.admin_kill                             [ skipped ]  Mysqlx plugin not available.
x.admin_kill_client_mysqlx               [ fail ]
        Test ended at 2018-11-15 19:13:24

CURRENT_TEST: x.admin_kill_client_mysqlx
mysqltest: At line 4: query 'create user unpriv@localhost' failed: 1396: Operation CREATE USER failed for 'unpriv'@'localhost'
safe_process[15243]: Child process: 15244, exit: 1

Server [mysqld.1 - pid: 15162, winpid: 15162] log: 
Server log from this test:
----------SERVER LOG START-----------
----------SERVER LOG END-------------

 - the logfile can be found in '/home/lalit/git/percona-server_dbg/mysql-test/var/log/x.admin_kill_client_mysqlx/admin_kill_client_mysqlx.log'

Only  35  of 172 completed.
mysql-test-run: *** ERROR: Not all tests completed
[21 Nov 2018 13:39] Umesh Shastry
Hi Lalit,

Thank you for the report.

regards,
Umesh
[21 Nov 2018 13:39] Umesh Shastry
## If source and target are diff then "x" suite is not copied at all with -DWITH_RAPID=OFF

rm -rf bld/
mkdir bld && cd bld
cmake .. -DWITH_BOOST=../boost/ -DCMAKE_BUILD_TYPE=Release -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DWITH_EMBEDDED_SERVER=OFF   -DCMAKE_INSTALL_PREFIX=/export/umesh/server/source/bugs/src_build/fb_builds/93209 -DWITH_RAPID=OFF
make -j32
make install
[umshastr@hod03]/export/umesh/server/source/bugs/src_build/fb_builds/93209: find . -name mysqlxtest_help.test
[umshastr@hod03]/export/umesh/server/source/bugs/src_build/fb_builds/93209: ls -l mysql-test/suite/x
ls: cannot access mysql-test/suite/x: No such file or directory
[umshastr@hod03]/export/umesh/server/source/bugs/src_build/fb_builds/93209:

rm -rf bld/
mkdir bld && cd bld
cmake .. -DWITH_BOOST=../boost/ -DCMAKE_BUILD_TYPE=Release -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DWITH_EMBEDDED_SERVER=OFF -DWITH_RAPID=OFF
make -j32
[umshastr@hod03]/export/umesh/server/source/bugs/src_build/fb_builds/mysql-5.7.24/bld: cd mysql-test/
[umshastr@hod03]/export/umesh/server/source/bugs/src_build/fb_builds/mysql-5.7.24/bld/mysql-test: ./mtr x.mysqlxtest_help
Logging: /export/umesh/server/source/bugs/src_build/fb_builds/mysql-5.7.24/mysql-test/mysql-test-run.pl  x.mysqlxtest_help
MySQL Version 5.7.24
Too long tmpdir path '/export/umesh/server/source/bugs/src_build/fb_builds/mysql-5.7.24/bld/mysql-test/var/tmp'  creating a shorter one...
 - using tmpdir: '/tmp/egACRRzyeF'

Checking supported features...
 - SSL connections supported
Collecting tests...
Removing old var directory...
Creating var directory '/export/umesh/server/source/bugs/src_build/fb_builds/mysql-5.7.24/bld/mysql-test/var'...
Installing system database...
Using parallel: 1

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
[100%] x.mysqlxtest_help                        [ fail ]
        Test ended at 2018-11-21 13:05:34

CURRENT_TEST: x.mysqlxtest_help
mysqltest: At line 11: command "$MYSQLXTEST --help  2>&1" failed with wrong error: 127

The result from queries just before the failure was:

############################################################
## Test mysqlxtest executable help printout
##
safe_process[1660]: Child process: 1661, exit: 1

 - the logfile can be found in '/export/umesh/server/source/bugs/src_build/fb_builds/mysql-5.7.24/bld/mysql-test/var/log/x.mysqlxtest_help/mysqlxtest_help.log'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 3 seconds executing testcases

Completed: Failed 1/1 tests, 0.00% were successful.

Failing test(s): x.mysqlxtest_help

The log files in var/log may give you some hint of what went wrong.

If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html

mysql-test-run: *** ERROR: there were failing test cases
[umshastr@hod03]/export/umesh/server/source/bugs/src_build/fb_builds/mysql-5.7.24/bld/mysql-test: ./mtr --suite=x
Logging: /export/umesh/server/source/bugs/src_build/fb_builds/mysql-5.7.24/mysql-test/mysql-test-run.pl  --suite=x
MySQL Version 5.7.24
Too long tmpdir path '/export/umesh/server/source/bugs/src_build/fb_builds/mysql-5.7.24/bld/mysql-test/var/tmp'  creating a shorter one...
 - using tmpdir: '/tmp/5etAZkdYUk'

Checking supported features...
 - SSL connections supported
Using suites: x
Collecting tests...
Checking leftover processes...
Removing old var directory...
Creating var directory '/export/umesh/server/source/bugs/src_build/fb_builds/mysql-5.7.24/bld/mysql-test/var'...
Installing system database...
Using parallel: 1

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13019
[  0%] x.notices_enable                         [ skipped ]  Mysqlx plugin not available.
[  1%] x.notices_enable_mysqlx                  [ skipped ]  Mysqlx plugin not available.
[  1%] x.binary_log                             [ skipped ]  Test requires: 'have_debug_sync'
[  2%] x.connection_skip_networking_win         [ skipped ]  Need windows
[  2%] x.connection_ipv6                        [ skipped ]  Mysqlx plugin not available.
[  3%] x.performance_schema_threads             [ skipped ]  Mysqlx plugin not available.
[  4%] x.regression                             [ skipped ]  Mysqlx plugin not available.
[  4%] x.connection_tls_version                 [ skipped ]  Mysqlx plugin not available.
[  5%] x.connection_openssl                     [ skipped ]  Need OpenSSL support
[  5%] x.connection_yassl                       [ skipped ]  Mysqlx plugin not available.
[  6%] x.admin_list_objects_case_sensitive_names_forced [ skipped ]  Mysqlx plugin not available.
[  6%] x.performance_schema                     [ skipped ]  Mysqlx plugin not available.
[  7%] x.performance_schema_sockets             [ skipped ]  Mysqlx plugin not available.
[  8%] x.capabilities                           [ skipped ]  Mysqlx plugin not available.
[  8%] x.connection_nonssl                      [ skipped ]  Mysqlx plugin not available.
[  9%] x.status_variables                       [ skipped ]  Mysqlx plugin not available.
[  9%] x.notices_disable                        [ skipped ]  Mysqlx plugin not available.
[ 10%] x.notices_disable_mysqlx                 [ skipped ]  Mysqlx plugin not available.
[ 11%] x.crud_create_view                       [ skipped ]  Mysqlx plugin not available.
[ 11%] x.message_protobuf_nested                [ skipped ]  Mysqlx plugin not available.
[ 12%] x.status_variable_errors_unknown_message_type [ skipped ]  Mysqlx plugin not available.
[ 12%] x.system_variable_max_allowed_packet     [ skipped ]  Mysqlx plugin not available.
[ 13%] x.connection_expired_certs               [ skipped ]  Mysqlx plugin not available.
[ 13%] x.admin_bogus                            [ skipped ]  Mysqlx plugin not available.
[ 14%] x.admin_bogus_mysqlx                     [ skipped ]  Mysqlx plugin not available.
[ 15%] x.admin_create_collection                [ skipped ]  Mysqlx plugin not available.
[ 15%] x.admin_create_collection_mysqlx         [ skipped ]  Mysqlx plugin not available.
[ 16%] x.admin_create_index_datetime            [ skipped ]  Mysqlx plugin not available.
[ 16%] x.admin_create_index_datetime_mysqlx     [ skipped ]  Mysqlx plugin not available.
[ 17%] x.admin_create_index_string              [ skipped ]  Mysqlx plugin not available.
[ 18%] x.admin_create_index_string_mysqlx       [ skipped ]  Mysqlx plugin not available.
[ 18%] x.admin_ensure_collection                [ skipped ]  Mysqlx plugin not available.
[ 19%] x.admin_ensure_collection_mysqlx         [ skipped ]  Mysqlx plugin not available.
[ 19%] x.admin_kill                             [ skipped ]  Mysqlx plugin not available.
[ 20%] x.admin_kill_client_mysqlx               [ fail ]
        Test ended at 2018-11-21 13:06:48

CURRENT_TEST: x.admin_kill_client_mysqlx
mysqltest: At line 4: query 'create user unpriv@localhost' failed: 1396: Operation CREATE USER failed for 'unpriv'@'localhost'
safe_process[2303]: Child process: 2304, exit: 1

 - the logfile can be found in '/export/umesh/server/source/bugs/src_build/fb_builds/mysql-5.7.24/bld/mysql-test/var/log/x.admin_kill_client_mysqlx/admin_kill_client_mysqlx.log'

Only  35  of 172 completed.
mysql-test-run: *** ERROR: Not all tests completed
[23 Nov 2018 14:14] Erlend Dahl
Posted by developer:
 
Some tests are probably missing 

--source include/have_mysqlx_plugin.inc;

Note that rapid/ is gone in 8.0 and xplugin is compiled in by default.