Description:
rpl_gtid.rpl_gtid_stm_drop_table test (see https://github.com/mysql/mysql-server/blob/8.0/mysql-test/suite/rpl_gtid/t/rpl_gtid_stm_dr...) fails for me with MySQL 8.0.11 built from GitHub source code on Ubuntu 14.04:
openxs@ao756:~$ cd git/mysql-server/mysql-test/
openxs@ao756:~/git/mysql-server/mysql-test$ ./mtr rpl_gtid.rpl_gtid_stm_drop_table
Logging: ./mtr rpl_gtid.rpl_gtid_stm_drop_table
2018-04-24T15:13:34.288051Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161)
2018-04-24T15:13:34.288204Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000)
2018-04-24T15:13:34.288678Z 0 [System] [MY-010116] [Server] /home/openxs/git/mysql-server/runtime_output_directory/mysqld (mysqld 8.0.11) starting as process 28332
MySQL Version 8.0.11
Checking supported features...
- SSL connections supported
Collecting tests...
- adding combinations for rpl_gtid
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/openxs/git/mysql-server/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_gtid.rpl_gtid_stm_drop_table 'mix' [ skipped ] Doesn't support --binlog-format='mixed'
rpl_gtid.rpl_gtid_stm_drop_table 'row' [ skipped ] Doesn't support --binlog-format='row'
rpl_gtid.rpl_gtid_stm_drop_table 'stmt' [ fail ]
Test ended at 2018-04-24 18:14:54
CURRENT_TEST: rpl_gtid.rpl_gtid_stm_drop_table
mysqltest: In included file ./include/assert.inc at line 72:
included from ./extra/rpl_tests/rpl_gtid_drop_table.test at line 331:
included from /home/openxs/git/mysql-server/mysql-test/suite/rpl_gtid/t/rpl_gtid_stm_drop_table.test at line 3:
At line 71: Test assertion failed in assert.inc
The result from queries just before the failure was:
< snip >
Number_of_lines Relay_log_name Relay_log_pos Master_log_name Master_log_pos Sql_delay Number_of_workers Id Channel_name
**** slave_master_info on server_1 ****
SELECT * FROM mysql.slave_master_info;
Number_of_lines Master_log_name Master_log_pos Host User_name User_password Port Connect_retry Enabled_ssl Ssl_ca Ssl_capath Ssl_certSsl_cipher Ssl_key Ssl_verify_server_cert Heartbeat Bind Ignored_server_ids Uuid Retry_count Ssl_crl Ssl_crlpath Enabled_auto_position Channel_name Tls_version Public_key_path Get_public_key
**** mysql.gtid_executed on server_1 ****
SELECT * FROM mysql.gtid_executed;
source_uuid interval_start interval_end
11111111-1111-1111-1111-111111111111 4 4
33f80e60-47d2-11e8-a172-f4b7e2133dbd 1 21
rpl_topology= 1->2->3
rand_seed: '' _rand_state: ''
extra debug info if any: ''
rpl_topology=1->2->3
connection slave;
Assertion text: 'Slave_open_temp_tables should be 0'
Assertion condition: '[SHOW STATUS LIKE "Slave_open_temp_tables", Value, 1] = 0'
Assertion condition, interpolated: '10 = 0'
Assertion result: '0'
safe_process[28498]: Child process: 28499, exit: 1
- the logfile can be found in '/home/openxs/git/mysql-server/mysql-test/var/log/rpl_gtid.rpl_gtid_stm_drop_table-stmt/rpl_gtid_stm_drop_table.log'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 80 seconds executing testcases
Completed: Failed 1/1 tests, 0.00% were successful.
Failing test(s): rpl_gtid.rpl_gtid_stm_drop_table
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
2 tests were skipped, 0 by the test itself.
mysql-test-run: *** ERROR: there were failing test cases
openxs@ao756:~/git/mysql-server/mysql-test$
How to repeat:
Build MySQL 8.0.11 from GitHub source with the following cmake command line:
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
cd mysql-test and run:
./mtr rpl_gtid.rpl_gtid_stm_drop_table
Suggested fix:
Do something for this test not to fail.