Bug 1571822

Summary: Test case failure: /CoreOS/mysql/testsuite - main.events_2
Product: Red Hat Enterprise Linux 6 Reporter: Karel Volný <kvolny>
Component: mysqlAssignee: Michal Schorm <mschorm>
Status: CLOSED WONTFIX QA Contact: qe-baseos-daemons
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.10CC: databases-maint, hhorak, mmuzila
Target Milestone: rc   
Target Release: ---   
Hardware: Unspecified   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-06-15 09:48:52 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Karel Volný 2018-04-25 13:24:20 UTC
Filed from caserun https://tcms.engineering.redhat.com/run/330034/#caserun_17210285

Version-Release number of selected component (if applicable):
RHEL-6.10-20180418.0
mysql-server-5.1.73-8.el6_8

Steps to Reproduce: 
(run the test)

Actual results: 
main.events_2                            [ fail ]
        Test ended at 2018-04-20 07:50:58

CURRENT_TEST: main.events_2
mysqltest: At line 18: query 'drop event e_26' failed: 1539: Unknown event 'e_26'

The result from queries just before the failure was:
drop database if exists events_test;
create database events_test;
use events_test;
create event e_26 on schedule at '2017-01-01 00:00:00' disable do set @a = 5;
Warnings:
Note	1588	Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.
select db, name, body, definer, convert_tz(execute_at, 'UTC', 'SYSTEM'), on_completion from mysql.event;
db	name	body	definer	convert_tz(execute_at, 'UTC', 'SYSTEM')	on_completion

 - saving '/var/tmp/testgw5/log/main.events_2/' to '/var/tmp/testgw5/log/main.events_2/'

Retrying test main.events_2, attempt(2/3)...

main.events_2                            [ retry-fail ]
        Test ended at 2018-04-20 07:50:59

CURRENT_TEST: main.events_2
mysqltest: At line 18: query 'drop event e_26' failed: 1539: Unknown event 'e_26'

The result from queries just before the failure was:
drop database if exists events_test;
create database events_test;
use events_test;
create event e_26 on schedule at '2017-01-01 00:00:00' disable do set @a = 5;
Warnings:
Note	1588	Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.
select db, name, body, definer, convert_tz(execute_at, 'UTC', 'SYSTEM'), on_completion from mysql.event;
db	name	body	definer	convert_tz(execute_at, 'UTC', 'SYSTEM')	on_completion

 - saving '/var/tmp/testgw5/log/main.events_2/' to '/var/tmp/testgw5/log/main.events_2/'

Test main.events_2 has failed 2 times, no more retries!