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