Bug #101798 MTR tests failed for main.events_bugs
Submitted: 30 Nov 2020 10:15 Modified: 1 Dec 2020 4:21
Reporter: yadong bai Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:5.7.28 OS:CentOS
Assigned to: CPU Architecture:x86

[30 Nov 2020 10:15] yadong bai
Description:
Logging: ./mysql-test-run  --max-test-fail=1 --force --testcase-timeout=180 --suite-timeout=2880 --nounit-tests events_bugs
2020-11-30T09:47:59.989847Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2020-11-30T09:47:59.989976Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
MySQL Version 5.7.28
Checking supported features...
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
Removing old var directory...
Creating var directory '/usr/local/mysql5.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                         [ fail ]
        Test ended at 2020-11-30 17:48:13

CURRENT_TEST: main.events_bugs
mysqltest: At line 1046: 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 IF EXISTS e1;
DROP EVENT IF EXISTS e2;

set @orig_sql_mode = @@sql_mode;
set sql_mode=(select replace(@@sql_mode,'NO_AUTO_CREATE_USER',''));
Warnings:
Warning	3090	Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.
GRANT EVENT ON *.* TO mysqltest_u1@localhost;
Warnings:
Warning	1287	Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement.
set sql_mode= @orig_sql_mode;
Warnings:
Warning	3090	Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.

SET GLOBAL READ_ONLY = 1;

#
# Connection: u1_con (mysqltest_u1@localhost/events_test).
#

safe_process[20587]: Child process: 20588, exit: 1

 - the logfile can be found in '/usr/local/mysql5.7/mysql-test/var/log/main.events_bugs/events_bugs.log'
The servers were restarted 0 times
Spent 0.000 of 14 seconds executing testcases

Too many failed: Failed 1/1 tests, 0.00% were successful.

Failing test(s): main.events_bugs

The log files in var/log may give you some hint of what went wrong.

If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html

Too many tests(1) failed! Terminating...
mysql-test-run: *** ERROR: Test suite aborted

How to repeat:
My compilation options:
cmake .. -DCMAKE_INSTALL_PREFIX=/usr/local/mysql5.7/  -DWITH_DEBUG=1 -DDOWNLOAD_BOOST=0 -DWITH_BOOST=../boost
make -j 16 && make install

Test command:
./mysql-test-run --max-test-fail=1 --force --testcase-timeout=180 --suite-timeout=2880 --nounit-tests events_bugs
[30 Nov 2020 11:48] MySQL Verification Team
Hello yadong bai,

Thank you for the report and feedback.
Could you please try with the latest 5.7.32 build and report us back if you are still seeing the issue? Thank you!

-
 ./mysql-test-run --debug --max-test-fail=1 --force --testcase-timeout=180 --suite-timeout=2880 --nounit-tests events_bugs
Logging: ./mysql-test-run  --debug --max-test-fail=1 --force --testcase-timeout=180 --suite-timeout=2880 --nounit-tests events_bugs
MySQL Version 5.7.32
Checking supported features...
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/umshastr/work/binaries/ga/mysql-5.7.32/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
[ 50%] main.events_bugs                         [ pass ]  12959
[100%] shutdown_report                          [ pass ]
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 12.959 of 46 seconds executing testcases

Completed: All 2 tests were successful.

Related - Bug #98107 	

regards,
Umesh
[1 Dec 2020 3:28] yadong bai
Yes, I use version 5.7.32, this test case passed. Thank you.
[1 Dec 2020 4:21] MySQL Verification Team
Thank you for confirming, closing it now.

regards,
Umesh