Bug #80881 MTR: binlog test suite failed to cleanup (contribution)
Submitted: 29 Mar 2016 11:48 Modified: 2 Sep 2016 10:41
Reporter: OCA Admin (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:5.7.11 OS:Any
Assigned to: CPU Architecture:Any

[29 Mar 2016 11:48] OCA Admin
Description:
This bug tracks a contribution by Daniel Black (Github user: grooverdan) as described in http://github.com/mysql/mysql-server/pull/60

How to repeat:
See description

Suggested fix:
See contribution code attached
[29 Mar 2016 11:48] OCA Admin
Contribution submitted via Github - MTR: binlog test suite failed to cleanup 
(*) Contribution by Daniel Black (Github grooverdan, mysql-server/pull/60#issuecomment-202604704): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_63987374.txt (text/plain), 3.53 KiB.

[29 Mar 2016 12:03] Umesh Shastry
Hello daniel,

Thank you for the report and contribution.

Thanks,
Umesh
[29 Mar 2016 12:04] Umesh Shastry
-- 5.7.13

[umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.7.13/mysql-test: ./mtr --debug --force --max-test-fail=40 --repeat=10 --suite=binlog binlog_bug36391
Logging: ./mtr  --debug --force --max-test-fail=40 --repeat=10 --suite=binlog binlog_bug36391
MySQL Version 5.7.13
Checking supported features...
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
 - adding combinations for binlog
Checking leftover processes...
Removing old var directory...
Creating var directory '/export/umesh/server/binaries/mysql-advanced-5.7.13/mysql-test/var'...
Installing system database...

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
binlog.binlog_bug36391 'mix'             [ pass ]    123
binlog.binlog_bug36391 'mix'             [ fail ]
        Test ended at 2016-03-29 14:01:51

CURRENT_TEST: binlog.binlog_bug36391
mysqltest: [Warning] /export/umesh/server/binaries/mysql-advanced-5.7.13/bin/mysqltest: Option 'debug=d:t:A,/export/umesh/server/binaries/mysql-advanced-5.7.13/mysql-test/var/log/mysqltest.trace' used, but is disabled
mysqltest: At line 26: command "copy_file" failed with error 1. my_errno=17

The result from queries just before the failure was:
CREATE TABLE t1(id INT);
SHOW TABLES;
Tables_in_test
t1
FLUSH LOGS;
safe_process[11231]: Child process: 11232, exit: 1

 - the logfile can be found in '/export/umesh/server/binaries/mysql-advanced-5.7.13/mysql-test/var/log/binlog.binlog_bug36391-mix/binlog_bug36391.log'

Retrying test binlog.binlog_bug36391, attempt(2/3)...

binlog.binlog_bug36391 'mix'             [ retry-pass ]    124

Retrying test binlog.binlog_bug36391, attempt(3/3)...

binlog.binlog_bug36391 'mix'             [ retry-fail ]
        Test ended at 2016-03-29 14:02:03
[29 Mar 2016 12:05] Umesh Shastry
-- 5.7.9

[umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.7.9/mysql-test: ./mtr --debug --force --max-test-fail=40 --repeat=10 --suite=binlog binlog_bug36391
Logging: ./mtr  --debug --force --max-test-fail=40 --repeat=10 --suite=binlog binlog_bug36391
MySQL Version 5.7.9
Checking supported features...
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
 - adding combinations for binlog
Checking leftover processes...
Removing old var directory...
Creating var directory '/export/umesh/server/binaries/mysql-advanced-5.7.9/mysql-test/var'...
Installing system database...

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
binlog.binlog_bug36391 'mix'             [ pass ]    128
binlog.binlog_bug36391 'mix'             [ fail ]
        Test ended at 2016-03-29 14:04:58

CURRENT_TEST: binlog.binlog_bug36391
mysqltest: [Warning] /export/umesh/server/binaries/mysql-advanced-5.7.9/bin/mysqltest: Option 'debug=d:t:A,/export/umesh/server/binaries/mysql-advanced-5.7.9/mysql-test/var/log/mysqltest.trace' used, but is disabled
mysqltest: At line 26: command "copy_file" failed with error 1. my_errno=17

The result from queries just before the failure was:
CREATE TABLE t1(id INT);
SHOW TABLES;
Tables_in_test
t1
FLUSH LOGS;
safe_process[11720]: Child process: 11721, exit: 1

 - the logfile can be found in '/export/umesh/server/binaries/mysql-advanced-5.7.9/mysql-test/var/log/binlog.binlog_bug36391-mix/binlog_bug36391.log'

Retrying test binlog.binlog_bug36391, attempt(2/3)...
[2 Sep 2016 10:41] David Moss
Posted by developer:
 
Thank you for your feedback, this has been fixed in upcoming versions and the following was added to the 5.7.15 change log:
The MTR binary log test was failing to clean up copied files. Thanks to Daniel Black for the contribution.