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:
None 
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
Description:
Both main.events_bugs and main.events_1 fail with the following errors
mysqltest: At line 69: Query 'ALTER EVENT event_starts_test ON SCHEDULE AT '2020-02-02 20:00:02'' failed.
ERROR 1589 (HY000): Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was not changed. Specify a time in the future.

mysqltest: At line 1036: Query 'CREATE EVENT e1 ON SCHEDULE AT '2020-01-01 00:00:00' DO SET @a = 1' succeeded, should have failed with error '1290'

How to repeat:
./mtr --debug-server main.events_bugs
./mtr --debug-server main.events_1

Suggested fix:
Change '2020-XX-YY' date to '2038-XX-YY'
[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.