Bug #98860 | main.events_bugs and main.events_1 fail because 2020-01-01 is considered future | ||
---|---|---|---|
Submitted: | 6 Mar 2020 14:07 | Modified: | 6 Mar 2020 19:58 |
Reporter: | Yura Sorokin (OCA) | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | Tests: Server | Severity: | S7 (Test Cases) |
Version: | 5.6.47, 5.7.29, 8.0.19 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[6 Mar 2020 14:07]
Yura Sorokin
[6 Mar 2020 16:19]
MySQL Verification Team
Not repeatable with more recent source built: miguel@tikalmysql-test$./mtr --debug-server main.events_bugs Logging: ./mtr --debug-server main.events_bugs 2020-03-06 13:04:54 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2020-03-06 13:04:54 0 [Note] /home/miguel/dbsd/5.6/bin/mysqld (mysqld 5.6.48-debug) starting as process 7894 ... 2020-03-06 13:04:54 7894 [Note] Plugin 'FEDERATED' is disabled. 2020-03-06 13:04:54 7894 [Note] Binlog end 2020-03-06 13:04:54 7894 [Note] Shutting down plugin 'CSV' 2020-03-06 13:04:54 7894 [Note] Shutting down plugin 'MyISAM' MySQL Version 5.6.48 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Removing old var directory... Creating var directory '/home/miguel/dbsd/5.6/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.events_bugs [ pass ] 10655 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 10.655 of 28 seconds executing testcases Completed: All 1 tests were successful. miguel@tikalmysql-test$./mtr --debug-server main.events_1 Logging: ./mtr --debug-server main.events_1 2020-03-06 13:05:31 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2020-03-06 13:05:31 0 [Note] /home/miguel/dbsd/5.6/bin/mysqld (mysqld 5.6.48-debug) starting as process 7984 ... 2020-03-06 13:05:31 7984 [Note] Plugin 'FEDERATED' is disabled. 2020-03-06 13:05:31 7984 [Note] Binlog end 2020-03-06 13:05:31 7984 [Note] Shutting down plugin 'CSV' 2020-03-06 13:05:31 7984 [Note] Shutting down plugin 'MyISAM' MySQL Version 5.6.48 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/home/miguel/dbsd/5.6/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.events_1 [ pass ] 1890 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 1.890 of 15 seconds executing testcases Completed: All 1 tests were successful. miguel@tikalmysql-test$./mtr --debug-server main.events_bugs Logging: ./mtr --debug-server main.events_bugs MySQL Version 5.7.30 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/home/miguel/dbsd/5.7/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 [100%] main.events_bugs [ pass ] 10801 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 10.801 of 48 seconds executing testcases Completed: All 1 tests were successful. miguel@tikalmysql-test$./mtr --debug-server main.events_1 Logging: ./mtr --debug-server main.events_1 MySQL Version 5.7.30 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/home/miguel/dbsd/5.7/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 [100%] main.events_1 [ pass ] 3635 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 3.635 of 37 seconds executing testcases Completed: All 1 tests were successful. miguel@tikalmysql-test$./mtr --debug-server main.events_bugs Logging: ./mtr --debug-server main.events_bugs MySQL Version 8.0.20 Checking supported features - Binaries are debug compiled Using 'all' suites Collecting tests Checking leftover processes Removing old var directory Creating var directory '/home/miguel/dbsd/8.0/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ [100%] main.events_bugs [ pass ] 74504 ------------------------------------------------------------------------------ The servers were restarted 0 times The servers were reinitialized 0 times Spent 74.504 of 204 seconds executing testcases Completed: All 1 tests were successful. miguel@tikalmysql-test$./mtr --debug-server main.events_1 Logging: ./mtr --debug-server main.events_1 MySQL Version 8.0.20 Checking supported features - Binaries are debug compiled Using 'all' suites Collecting tests Checking leftover processes Removing old var directory Creating var directory '/home/miguel/dbsd/8.0/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ [100%] main.events_1 [ pass ] 39935 ------------------------------------------------------------------------------ The servers were restarted 0 times The servers were reinitialized 0 times Spent 39.935 of 243 seconds executing testcases Completed: All 1 tests were successful.
[6 Mar 2020 16:40]
Tsubasa Tanaka
Is this same as Bug#98107 ? https://bugs.mysql.com/bug.php?id=98107
[6 Mar 2020 19:58]
MySQL Verification Team
Thank you for the feedback.