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.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.