Bug #95896 innodb_stress tests failing testcase check
Submitted: 20 Jun 2019 13:09 Modified: 9 Jul 2019 17:05
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:8.0.16 OS:Any
Assigned to: CPU Architecture:Any

[20 Jun 2019 13:09] Laurynas Biveinis
Description:
[100%] innodb_stress.innodb_stress               [ fail ]
        Test ended at 2019-06-20 16:06:07

MTR's internal check of the test case 'innodb_stress.innodb_stress' failed.
This means that the test case does not preserve the state that existed
before the test case was executed.  Most likely the test case did not
do a proper clean-up. It could also be caused by the previous test run
by this thread, if the server wasn't restarted.
This is the diff of the states of the servers before and after the
test case was executed:
mysqltest: Results saved in '/Users/laurynas/percona/obj-mysql-8.0-debug/mysql-test/var/tmp/check-mysqld_1.result'.
mysqltest: Logging to '/Users/laurynas/percona/obj-mysql-8.0-debug/mysql-test/var/tmp/check-mysqld_1.log'.
mysqltest: Connecting to server localhost:13000 (socket /Users/laurynas/percona/obj-mysql-8.0-debug/mysql-test/var/tmp/mysqld.1.sock) as 'root', connection 'default', attempt 0 ...
mysqltest: ... Connected.
mysqltest: Start processing test commands from './include/check-testcase.test' ...
mysqltest: ... Done processing test commands.
--- /Users/laurynas/percona/obj-mysql-8.0-debug/mysql-test/var/tmp/check-mysqld_1.result	2019-06-20 16:06:04.000000000 +0300
+++ /Users/laurynas/percona/obj-mysql-8.0-debug/mysql-test/var/tmp/check-mysqld_1.reject	2019-06-20 16:06:07.000000000 +0300
@@ -3354,6 +3354,7 @@
 Variable_name	Value
 Slave_open_temp_tables	0
 USER	HOST	DB	COMMAND	INFO
+root	localhost:61646	NULL	Binlog Dump	NULL
 root	localhost	mtr	Query	SELECT USER, HOST, DB, COMMAND, INFO FROM INFORMATION_SCHEMA.PROCESSLIST     WHERE COMMAND NOT IN ('Sleep')       AND USER NOT IN ('mysql.session', 'event_scheduler')         ORDER BY COMMAND
 Table	Checksum
 mysql.columns_priv	0

mysqltest: Result content mismatch

How to repeat:
./mtr --suite=innodb_stress

Suggested fix:
It looks like innodb_stress.inc needs rpl_end.inc.
[21 Jun 2019 7:19] MySQL Verification Team
Hello Laurynas,

Thank you for the report and feedback!

regards,
Umesh
[9 Jul 2019 17:05] Paul DuBois
Posted by developer:
 
Fixed in 8.0.18.

Work was done for test suite. No changelog entry required.