| Bug #91863 | MTR's internal check of the test case 'main.mysqldump' failed | ||
|---|---|---|---|
| Submitted: | 2 Aug 2018 6:11 | Modified: | 3 Aug 2018 7:05 |
| Reporter: | long jian | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Tests | Severity: | S3 (Non-critical) |
| Version: | 5.7.22 | OS: | CentOS (CentOS Linux release 7.5.1804) |
| Assigned to: | CPU Architecture: | x86 (Intel(R) Xeon(R) CPU @ 2.50GHz) | |
| Tags: | main.mysqldump, MTR's internal check, mysql.gtid_executed | ||
[2 Aug 2018 6:11]
long jian
[2 Aug 2018 6:22]
MySQL Verification Team
Hello long jian, Thank you for the report. I'm no longer seeing this on 5.7.23/8.0.12. Could you please try with 5.7.23/8.0.12 build? Thank you! Thanks, Umesh
[2 Aug 2018 6:24]
MySQL Verification Team
- 5.7.23 ./mtr main.mysqldump Logging: ./mtr main.mysqldump MySQL Version 5.7.23 Checking supported features... - SSL connections supported Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-5.7.23/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 main.mysqldump [ pass ] 6928 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 6.928 of 12 seconds executing testcases Completed: All 1 tests were successful. [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.23/mysql-test: cd ../../mysql-8.0.12/mysql-test/ [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.12/mysql-test: ./mtr main.mysqldump Logging: ./mtr main.mysqldump MySQL Version 8.0.12 Checking supported features... - SSL connections supported Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-8.0.12/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 main.mysqldump [ pass ] 13726 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 13.726 of 20 seconds executing testcases Completed: All 1 tests were successful. - 8.0.12 ./mtr main.mysqldump Logging: ./mtr main.mysqldump MySQL Version 8.0.12 Checking supported features... - SSL connections supported Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-8.0.12/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 main.mysqldump [ pass ] 13726 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 13.726 of 20 seconds executing testcases Completed: All 1 tests were successful. - 5.7.22 ./mtr main.mysqldump Logging: ./mtr main.mysqldump MySQL Version 5.7.22 Checking supported features... - SSL connections supported Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-5.7.22/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 main.mysqldump [ pass ] 6667 MTR's internal check of the test case 'main.mysqldump' 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: Logging to '/export/umesh/server/binaries/GABuilds/mysql-5.7.22/mysql-test/var/tmp/check-mysqld_1.log'. mysqltest: Results saved in '/export/umesh/server/binaries/GABuilds/mysql-5.7.22/mysql-test/var/tmp/check-mysqld_1.result'. mysqltest: Connecting to server localhost:13000 (socket /export/umesh/server/binaries/GABuilds/mysql-5.7.22/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. --- /export/umesh/server/binaries/GABuilds/mysql-5.7.22/mysql-test/var/tmp/check-mysqld_1.result 2018-08-02 09:19:57.189719787 +0300 +++ /export/umesh/server/binaries/GABuilds/mysql-5.7.22/mysql-test/var/tmp/check-mysqld_1.reject 2018-08-02 09:20:04.164880507 +0300
[3 Aug 2018 7:02]
long jian
there is no problem in 5.7.23 and 8.0.12 I found it has been fixed in commit c84ed7095ddbc4040e5967c0e4c53b171520fd34. thanks.
[3 Aug 2018 7:05]
MySQL Verification Team
Thanks for confirming from your end too. Closing the issue for now. regards, Umesh
