| Bug #78904 | mysql test binlog.binlog_stm_mix_innodb_myisam fails | ||
|---|---|---|---|
| Submitted: | 21 Oct 2015 18:22 | Modified: | 26 Oct 2015 16:34 |
| Reporter: | Richard Prohaska | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: Tests | Severity: | S3 (Non-critical) |
| Version: | 5.7.9 | OS: | Ubuntu (14.04) |
| Assigned to: | CPU Architecture: | Any | |
[21 Oct 2015 20:13]
MySQL Verification Team
Not repeatable on Linux CentOS 6.5 and Windows too: [miguel@miguelbr mysql-test]$ ./mtr binlog.binlog_stm_mix_innodb_myisam Logging: ./mtr binlog.binlog_stm_mix_innodb_myisam 2015-10-21T20:09:54.205492Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2015-10-21T20:09:54.205590Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 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 '/home/miguel/mysql-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_stm_mix_innodb_myisam 'mix' [ skipped ] Doesn't support --binlog-format='mixed' binlog.binlog_stm_mix_innodb_myisam 'row' [ skipped ] Doesn't support --binlog-format='row' binlog.binlog_stm_mix_innodb_myisam 'stmt' [ pass ] 62422 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 62.422 of 142 seconds executing testcases Completed: All 1 tests were successful. 2 tests were skipped, 0 by the test itself.
[21 Oct 2015 20:33]
Richard Prohaska
test sometimes fails on my ubuntu 14.04 (4 core 8 thread 32GB memory) system run 'mtr --repeat=10 --force --retry=0 binlog.binlog_stm_mix_innodb_myisam' ... Completed: Failed 3/10 tests, 70.00% were successful.
[22 Oct 2015 10:34]
MySQL Verification Team
Thank you for the feedback. I wasn't able to repeat even with 'mtr --repeat=10 --force --retry=0 binlog.binlog_stm_mix_innodb_myisam' several times.
[26 Oct 2015 16:34]
Richard Prohaska
fails on my machine 34/100 trials. probably a real race since binlog_stm_mix_innodb_myisam.test and binlog_row_mix_innodb_myisam.test are almost identical.
Description: $ ./mtr binlog.binlog_stm_mix_innodb_myisam Logging: ./mtr binlog.binlog_stm_mix_innodb_myisam 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 '/home/rfp/mysql-server-install-2/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_stm_mix_innodb_myisam 'mix' [ skipped ] Doesn't support --binlog-format='mixed' binlog.binlog_stm_mix_innodb_myisam 'row' [ skipped ] Doesn't support --binlog-format='row' binlog.binlog_stm_mix_innodb_myisam 'stmt' [ fail ] Test ended at 2015-10-21 14:21:31 CURRENT_TEST: binlog.binlog_stm_mix_innodb_myisam --- /home/rfp/mysql-server-install-2/mysql-test/suite/binlog/r/binlog_stm_mix_innodb_myisam.result 2015-10-21 16:15:32.000000000 +0300 +++ /home/rfp/mysql-server-install-2/mysql-test/var/log/binlog_stm_mix_innodb_myisam.reject 2015-10-21 21:21:31.444504520 +0300 @@ -297,7 +297,6 @@ master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # use `test`; create table t2 (n int) engine=innodb master-bin.000001 # Query # # use `test`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `ti` -master-bin.000001 # Query # # use `test`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `t1` do release_lock("lock1"); drop table t0,t2; set autocommit=0; mysqltest: Result content mismatch safe_process[3043]: Child process: 3044, exit: 1 - the logfile can be found in '/home/rfp/mysql-server-install-2/mysql-test/var/log/binlog.binlog_stm_mix_innodb_myisam-stmt/binlog_stm_mix_innodb_myisam.log' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 13 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): binlog.binlog_stm_mix_innodb_myisam 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 How to repeat: build debug 5.7.9 run mtr binlog.binlog_stm_mix_innodb_myisam Suggested fix: probably just need a results file change.