Bug #90612 rpl_gtid.rpl_gtid_stm_drop_table test fails
Submitted: 24 Apr 2018 15:19 Modified: 24 Apr 2018 17:10
Reporter: Valeriy Kravchuk Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:8.0.11 OS:Ubuntu (14.04)
Assigned to: CPU Architecture:x86
Tags: rpl_gtid.rpl_gtid_stm_drop_table, test

[24 Apr 2018 15:19] Valeriy Kravchuk
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.
[24 Apr 2018 17:10] MySQL Verification Team
Thank you for the bug report.