| Bug #102552 | The mysql-test 'binlog.binlog_rewrite_order' failed | ||
|---|---|---|---|
| Submitted: | 10 Feb 2021 7:48 | Modified: | 10 Feb 2021 9:42 |
| Reporter: | GONGTUI FU | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | Tools: MTR / mysql-test-run | Severity: | S3 (Non-critical) |
| Version: | 8.0.18 | OS: | Red Hat (7.4) |
| Assigned to: | CPU Architecture: | x86 | |
| Tags: | mysql-test binlog.binlog_rewrite_order | ||
[10 Feb 2021 9:42]
MySQL Verification Team
Thank you for the bug report. I couldn't repeat with 8.0.23:
miguel@fossa:~/dbs/8.0/mysql-test$ ./mtr binlog.binlog_rewrite_order
Logging: ./mtr binlog.binlog_rewrite_order
MySQL Version 8.0.23
Checking supported features
Using 'all' suites
Collecting tests
- Adding combinations for binlog
Removing old var directory
Creating var directory '/home/miguel/dbs/8.0/mysql-test/var'
Installing system database
Using parallel: 1
==============================================================================
TEST NAME RESULT TIME (ms) COMMENT
------------------------------------------------------------------------------
[ 25%] binlog.binlog_rewrite_order 'mix' [ pass ] 1912
[ 50%] binlog.binlog_rewrite_order 'row' [ skipped ] Doesn't support --binlog-format = 'row'
[ 75%] binlog.binlog_rewrite_order 'stmt' [ skipped ] Doesn't support --binlog-format = 'statement'
[100%] shutdown_report [ pass ]
------------------------------------------------------------------------------
The servers were restarted 0 times
The servers were reinitialized 0 times
Spent 1.912 of 14 seconds executing testcases
Completed: All 2 tests were successful.
2 tests were skipped, 0 by the test itself.
Description: Hi guys: mysql-test 'binlog.binlog_rewrite_order' failed when single execution. It may be success when running in parallel. How to repeat: [fuys1@test205 15:35:42 ~/DBVERSION/allmaster/DB/build/mysql-test]$ ./mtr binlog.binlog_rewrite_order Logging: /home/fuys1/DBVERSION/allmaster/DB/mysql-test/mysql-test-run.pl binlog.binlog_rewrite_order MySQL Version 8.0.21 Checking supported features Using 'all' suites Collecting tests - Adding combinations for binlog Removing old var directory Creating var directory '/home/fuys1/DBVERSION/allmaster/DB/build/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ [ 33%] binlog.binlog_rewrite_order 'mix' [ fail ] Test ended at 2021-02-10 15:35:58 MTR's internal check of the test case 'binlog.binlog_rewrite_order' 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 '/home/fuys1/DBVERSION/allmaster/DB/build/mysql-test/var/tmp/check-mysqld_1.result'. mysqltest: Logging to '/home/fuys1/DBVERSION/allmaster/DB/build/mysql-test/var/tmp/check-mysqld_1.log'. mysqltest: Connecting to server localhost:27000 (socket /home/fuys1/DBVERSION/allmaster/DB/build/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. --- /home/fuys1/DBVERSION/allmaster/DB/build/mysql-test/var/tmp/check-mysqld_1.result 2021-02-10 10:35:56.831106868 +0300 +++ /home/fuys1/DBVERSION/allmaster/DB/build/mysql-test/var/tmp/check-mysqld_1.reject 2021-02-10 10:35:58.071106872 +0300 @@ -71,6 +71,15 @@ #-------------- MYSQLTEST_VARDIR/run -------------- mysqld.1.pid #-------------- MYSQLTEST_VARDIR/tmp -------------- +SQL_LOAD_MB-1-0 +SQL_LOAD_MB-1-1 +SQL_LOAD_MB-1-2 +SQL_LOAD_MB-2-0 +SQL_LOAD_MB-2-1 +SQL_LOAD_MB-2-2 +SQL_LOAD_MB-3-0 +SQL_LOAD_MB-3-1 +SQL_LOAD_MB-3-2 mysqld.1 #------------- MYSQLTEST_VARDIR/std_data ------------ .mylogin.cnf mysqltest: Result content mismatch not ok safe_process[72715]: Child process: 72717, exit: 1 - the logfile can be found in '/home/fuys1/DBVERSION/allmaster/DB/build/mysql-test/var/log/binlog.binlog_rewrite_order-mix/binlog_rewrite_order.log' Only 1 of 3 completed. mysql-test-run: *** ERROR: Not all tests completed Suggested fix: a lack of --remove_files_wildcard $MYSQLTEST_VARDIR/tmp/ SQL_LOAD_MB* ?