Description:
./mysql-test-run main.events_bugs
Logging: ./mysql-test-run main.events_bugs
2020-01-08 14:23:58 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-01-08 14:23:58 0 [Note] /opt/test/mysql5646/bin/mysqld (mysqld 5.6.46-debug) starting as process 15064 ...
2020-01-08 14:23:58 15064 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
2020-01-08 14:23:58 15064 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)
2020-01-08 14:23:58 15064 [Note] Plugin 'FEDERATED' is disabled.
2020-01-08 14:23:58 15064 [Note] Binlog end
2020-01-08 14:23:58 15064 [Note] Shutting down plugin 'CSV'
2020-01-08 14:23:58 15064 [Note] Shutting down plugin 'MyISAM'
MySQL Version 5.6.46
Checking supported features...
- SSL connections supported
- binaries are debug compiled
Collecting tests...
Checking leftover processes...
Removing old var directory...
Creating var directory '/opt/test/mysql5646/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 [ fail ]
Test ended at 2020-01-08 14:24:15
CURRENT_TEST: main.events_bugs
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 errno 1290...
The result from queries just before the failure was:
< snip >
DROP EVENT bug28641;
#####################################################################
#
# BUG#31111: --read-only crashes MySQL (events fail to load).
#
#####################################################################
DROP USER mysqltest_u1@localhost;
DROP EVENT IF EXISTS e1;
DROP EVENT IF EXISTS e2;
GRANT EVENT ON *.* TO mysqltest_u1@localhost;
SET GLOBAL READ_ONLY = 1;
#
# Connection: u1_con (mysqltest_u1@localhost/events_test).
#
- the logfile can be found in '/opt/test/mysql5646/mysql-test/var/log/main.events_bugs/events_bugs.log'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 17 seconds executing testcases
Completed: Failed 1/1 tests, 0.00% were successful.
Failing test(s): main.events_bugs
How to repeat:
./mysql-test-run main.events_bugs
Description: ./mysql-test-run main.events_bugs Logging: ./mysql-test-run main.events_bugs 2020-01-08 14:23:58 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-01-08 14:23:58 0 [Note] /opt/test/mysql5646/bin/mysqld (mysqld 5.6.46-debug) starting as process 15064 ... 2020-01-08 14:23:58 15064 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2020-01-08 14:23:58 15064 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2020-01-08 14:23:58 15064 [Note] Plugin 'FEDERATED' is disabled. 2020-01-08 14:23:58 15064 [Note] Binlog end 2020-01-08 14:23:58 15064 [Note] Shutting down plugin 'CSV' 2020-01-08 14:23:58 15064 [Note] Shutting down plugin 'MyISAM' MySQL Version 5.6.46 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/opt/test/mysql5646/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 [ fail ] Test ended at 2020-01-08 14:24:15 CURRENT_TEST: main.events_bugs 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 errno 1290... The result from queries just before the failure was: < snip > DROP EVENT bug28641; ##################################################################### # # BUG#31111: --read-only crashes MySQL (events fail to load). # ##################################################################### DROP USER mysqltest_u1@localhost; DROP EVENT IF EXISTS e1; DROP EVENT IF EXISTS e2; GRANT EVENT ON *.* TO mysqltest_u1@localhost; SET GLOBAL READ_ONLY = 1; # # Connection: u1_con (mysqltest_u1@localhost/events_test). # - the logfile can be found in '/opt/test/mysql5646/mysql-test/var/log/main.events_bugs/events_bugs.log' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 17 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.events_bugs How to repeat: ./mysql-test-run main.events_bugs