Bug #80875 main.wl6443_deprecation cannot run with ./mtr --repeat=2 (or more)
Submitted: 29 Mar 2016 6:32 Modified: 7 Jun 2016 8:04
Reporter: Daniel Black Email Updates:
Status: Closed Impact on me:
Category:Tests Severity:S3 (Non-critical)
Version:5.7.11, 5.6.29 OS:Any
Assigned to: CPU Architecture:Any

[29 Mar 2016 6:32] Daniel Black
$ (cd ./mysql-test; ./mtr --repeat=2  main.wl6443_deprecation)
Logging: /home/danielgb/mysql-server/mysql-test/mysql-test-run.pl  --repeat=2 main.wl6443_deprecation
MySQL Version 5.7.11
Checking supported features...
 - SSL connections supported
Collecting tests...
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/danielgb/mysql-server-build/mysql-test/var'...
 - symlinking 'var' to '/dev/shm/var_auto_9VwB'
Installing system database...


TEST                                      RESULT   TIME (ms) or COMMENT

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.wl6443_deprecation                  [ pass ]   2905
main.wl6443_deprecation                  [ fail ]
        Test ended at 2016-03-29 17:30:39

CURRENT_TEST: main.wl6443_deprecation
--- /home/danielgb/mysql-server/mysql-test/r/wl6443_deprecation.result  2016-03-29 09:30:27.201816112 +0300
+++ /home/danielgb/mysql-server-build/mysql-test/var/log/wl6443_deprecation.reject      2016-03-29 09:30:39.595804176 +0300
@@ -101,7 +101,7 @@
 UNINSTALL PLUGIN validate_password;
 # Search for deprecation warnings in error log.
 # YMMDD HH:MM:SS [Warning] The syntax 'plugin-validate-password-length' is deprecated and will be removed in a future release. Please use validate-password-length instead.
-Deprecation warning count : 1
+Deprecation warning count : 2
 # Host table deprecation
 select count(*) from information_schema.tables where table_name like 'host' and table_schema like 'mysql' and table_type like 'BASE TABLE';

mysqltest: Result content mismatch

safe_process[18284]: Child process: 18285, exit: 1

 - the logfile can be found in '/home/danielgb/mysql-server-build/mysql-test/var/log/main.wl6443_deprecation/wl6443_deprecation.log'
The servers were restarted 1 times
Spent 2.905 of 10 seconds executing testcases

Completed: Failed 1/2 tests, 50.00% were successful.

Failing test(s): main.wl6443_deprecation

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

mysql-test-run: *** ERROR: there were failing test cases

How to repeat:
$ (cd ./mysql-test; ./mtr --repeat=2  main.wl6443_deprecation)

Suggested fix:
tried removing the log file and FLUSH ERROR LOGS; after the perl code in the test however this wasn't sufficient.
[29 Mar 2016 6:56] MySQL Verification Team
Hello Daniel,

Thank you for the report.

[7 Jun 2016 8:04] Paul DuBois
Posted by developer:
Fixed in 5.7.14.

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