Note: This is a public test instance of Red Hat Bugzilla. The data contained within is a snapshot of the live data so any changes you make will not be reflected in the production Bugzilla. Email is disabled so feel free to test any aspect of the site that you want. File any problems you find or give feedback at bugzilla.redhat.com.

Bug 1417896

Summary: Test case failure: /CoreOS/mysql/testsuite - main.audit_plugin_2
Product: [Fedora] Fedora Reporter: Karel Volný <kvolny>
Component: community-mysqlAssignee: Michal Schorm <mschorm>
Status: CLOSED ERRATA QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 25CC: databases-maint, hhorak, jstanek, mschorm, qe-baseos-daemons
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: community-mysql-5.7.19-1.fc26 community-mysql-5.7.19-1.fc25 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: 1387162 Environment:
Last Closed: 2017-08-09 15:56:28 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:
Bug Depends On: 1387162    
Bug Blocks:    

Description Karel Volný 2017-01-31 11:29:01 UTC 
the same with community-mysql-server-5.7.17-1.fc25.x86_64

+++ This bug was initially created as a clone of Bug #1387162 +++

Version-Release number of selected component (if applicable):
rh-mysql57-mysql-server-5.7.15-2.el6.x86_64

Actual results:
main.audit_plugin_2                      [ fail ]
        Test ended at 2016-10-19 10:01:02

CURRENT_TEST: main.audit_plugin_2
mysqltest: At line 1594: query 'SELECT * FROM INFORMATION_SCHEMA.TABLES' failed: 3164: MYSQL_AUDIT_QUERY_STATUS_END instead of MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUD

The result from queries just before the failure was:
< snip >
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";';
safe_process[6378]: Child process: 6379, exit: 1

 - the logfile can be found in '/var/opt/rh/rh-mysql57/lib/mysql/testGqV/log/main.audit_plugin_2/audit_plugin_2.log'

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

main.audit_plugin_2                      [ retry-fail ]
        Test ended at 2016-10-19 10:01:03

CURRENT_TEST: main.audit_plugin_2
mysqltest: At line 1594: query 'SELECT * FROM INFORMATION_SCHEMA.TABLES' failed: 3164: MYSQL_AUDIT_QUERY_STATUS_END instead of MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;MYSQL_AUD

The result from queries just before the failure was:
< snip >
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;;'
                                     'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";';
safe_process[6420]: Child process: 6421, exit: 1

 - the logfile can be found in '/var/opt/rh/rh-mysql57/lib/mysql/testGqV/log/main.audit_plugin_2/audit_plugin_2.log'

Test main.audit_plugin_2 has failed 2 times, no more retries!
Comment 1 Fedora Update System 2017-07-25 13:17:42 UTC 
community-mysql-5.7.19-1.fc26 has been submitted as an update to Fedora 26. https://bodhi.fedoraproject.org/updates/FEDORA-2017-ee93493bea
Comment 2 Fedora Update System 2017-07-25 22:49:55 UTC 
community-mysql-5.7.19-1.fc24 has been pushed to the Fedora 24 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2017-7a827cf42a
Comment 3 Fedora Update System 2017-07-25 22:54:38 UTC 
community-mysql-5.7.19-1.fc25 has been pushed to the Fedora 25 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2017-7c039552fa
Comment 4 Fedora Update System 2017-07-26 01:19:58 UTC 
community-mysql-5.7.19-1.fc26 has been pushed to the Fedora 26 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2017-ee93493bea
Comment 5 Fedora Update System 2017-08-09 15:56:28 UTC 
community-mysql-5.7.19-1.fc26 has been pushed to the Fedora 26 stable repository. If problems still persist, please make note of it in this bug report.
Comment 6 Fedora Update System 2017-08-09 19:57:24 UTC 
community-mysql-5.7.19-1.fc25 has been pushed to the Fedora 25 stable repository. If problems still persist, please make note of it in this bug report.