| 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: | |
| Category: | MySQL Server: Compiling | Severity: | S3 (Non-critical) |
| Version: | 5.7, 5.7.24 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | mtr | ||
[21 Nov 2018 13:39]
MySQL Verification Team
Hi Lalit, Thank you for the report. regards, Umesh
[21 Nov 2018 13:39]
MySQL Verification Team
## 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.
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