Description:
I tried to run ./mtr regression test suite on MySQL 8.0.11 built from source on up to date 64-bit Ubuntu 14.04 and found that rpl.rpl_public_key fails, even if it is run separately:
openxs@ao756:~/dbs/8.0/mysql-test$ ./mtr rpl.rpl_public_key
Logging: ./mtr rpl.rpl_public_key
2018-04-22T17:24:09.429625Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161)
2018-04-22T17:24:09.429783Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000)
2018-04-22T17:24:09.430266Z 0 [System] [MY-010116] [Server] /home/openxs/dbs/8.0/bin/mysqld (mysqld 8.0.11) starting as process 18363
MySQL Version 8.0.11
Checking supported features...
- SSL connections supported
Collecting tests...
- adding combinations for rpl
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/openxs/dbs/8.0/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
rpl.rpl_public_key 'mix' [ fail ]
Test ended at 2018-04-22 20:25:27
CURRENT_TEST: rpl.rpl_public_key
--- /home/openxs/dbs/8.0/mysql-test/suite/rpl/r/rpl_public_key.result 2018-01-30 20:53:24.000000000 +0300
+++ /home/openxs/dbs/8.0/mysql-test/var/log/rpl_public_key.reject 2018-04-22 20:25:27.450250183 +0300
@@ -65,7 +65,6 @@
SELECT * FROM t1;
c1
1
-2
==== Reset and cleanup ====
[connection slave]
include/stop_slave.inc
mysqltest: Result content mismatch
safe_process[18507]: Child process: 18508, exit: 1
- the logfile can be found in '/home/openxs/dbs/8.0/mysql-test/var/log/rpl.rpl_public_key-mix/rpl_public_key.log'
Only 1 of 3 completed.
mysql-test-run: *** ERROR: Not all tests completed
openxs@ao756:~/dbs/8.0/mysql-test$
How to repeat:
Build MySQL 8.0.11 from GitHub source using the following cmake command:
openxs@ao756:~/git/mysql-server$ cmake . -DCMAKE_BUILD_TYPE=RelWithDebInfo -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DWITH_EMBEDDED_SERVER=OFF -DCMAKE_INSTALL_PREFIX=/home/openxs/dbs/8.0 -DWITH_BOOST=/home/openxs/boost -DDOWNLOAD_BOOST=1 -DENABLE_DOWNLOADS=1 -DWITH_UNIT_TESTS=OFF
...
openxs@ao756:~/git/mysql-server$ time make -j 2
...
[100%] Built target mysqld
real 77m57.705s
user 133m53.854s
sys 7m3.053s
openxs@ao756:~/git/mysql-server$
Then run make install && make clean, got to the mysql-test subdirecotry and run:
./mtr rpl.rpl_public_ke
Enjoy the result.
Suggested fix:
Do something for this test not to fail.
Description: I tried to run ./mtr regression test suite on MySQL 8.0.11 built from source on up to date 64-bit Ubuntu 14.04 and found that rpl.rpl_public_key fails, even if it is run separately: openxs@ao756:~/dbs/8.0/mysql-test$ ./mtr rpl.rpl_public_key Logging: ./mtr rpl.rpl_public_key 2018-04-22T17:24:09.429625Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161) 2018-04-22T17:24:09.429783Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000) 2018-04-22T17:24:09.430266Z 0 [System] [MY-010116] [Server] /home/openxs/dbs/8.0/bin/mysqld (mysqld 8.0.11) starting as process 18363 MySQL Version 8.0.11 Checking supported features... - SSL connections supported Collecting tests... - adding combinations for rpl Checking leftover processes... Removing old var directory... Creating var directory '/home/openxs/dbs/8.0/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 rpl.rpl_public_key 'mix' [ fail ] Test ended at 2018-04-22 20:25:27 CURRENT_TEST: rpl.rpl_public_key --- /home/openxs/dbs/8.0/mysql-test/suite/rpl/r/rpl_public_key.result 2018-01-30 20:53:24.000000000 +0300 +++ /home/openxs/dbs/8.0/mysql-test/var/log/rpl_public_key.reject 2018-04-22 20:25:27.450250183 +0300 @@ -65,7 +65,6 @@ SELECT * FROM t1; c1 1 -2 ==== Reset and cleanup ==== [connection slave] include/stop_slave.inc mysqltest: Result content mismatch safe_process[18507]: Child process: 18508, exit: 1 - the logfile can be found in '/home/openxs/dbs/8.0/mysql-test/var/log/rpl.rpl_public_key-mix/rpl_public_key.log' Only 1 of 3 completed. mysql-test-run: *** ERROR: Not all tests completed openxs@ao756:~/dbs/8.0/mysql-test$ How to repeat: Build MySQL 8.0.11 from GitHub source using the following cmake command: openxs@ao756:~/git/mysql-server$ cmake . -DCMAKE_BUILD_TYPE=RelWithDebInfo -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DWITH_EMBEDDED_SERVER=OFF -DCMAKE_INSTALL_PREFIX=/home/openxs/dbs/8.0 -DWITH_BOOST=/home/openxs/boost -DDOWNLOAD_BOOST=1 -DENABLE_DOWNLOADS=1 -DWITH_UNIT_TESTS=OFF ... openxs@ao756:~/git/mysql-server$ time make -j 2 ... [100%] Built target mysqld real 77m57.705s user 133m53.854s sys 7m3.053s openxs@ao756:~/git/mysql-server$ Then run make install && make clean, got to the mysql-test subdirecotry and run: ./mtr rpl.rpl_public_ke Enjoy the result. Suggested fix: Do something for this test not to fail.