Bug 1324733

Summary: [z-stream clone - 3.6.6] engine-setup stage 'Setup validation' takes too long to complete
Product: Red Hat Enterprise Virtualization Manager Reporter: rhev-integ
Component: ovirt-engineAssignee: Eli Mesika <emesika>
Status: CLOSED ERRATA QA Contact: Gonza <grafuls>
Severity: medium Docs Contact:
Priority: high    
Version: 3.5.7CC: didi, ekin.meroglu, emesika, gklein, jcoscia, lsurette, mgoldboi, mkalinin, mperina, oourfali, pstehlik, rbalakri, Rhev-m-bugs, srevivo, tnisan, ykaul
Target Milestone: ovirt-3.6.6Keywords: ZStream
Target Release: 3.6.6   
Hardware: All   
OS: Linux   
Whiteboard: infra
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Previously, the audit_log table was not cleaned correctly, so the FK validation on that table took too long. As a result, the upgrade validation stage also took too long. Now, the audit_log cleanup mechanism has been fixed so that upgrade validation time is normal.
Story Points: ---
Clone Of: 1323826 Environment:
Last Closed: 2016-05-25 12:08:24 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Integration RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On: 1323826    
Bug Blocks:    

Comment 2 Gonza 2016-05-12 10:19:43 UTC
Verified with:
rhevm-3.6.6.2-0.1.el6.noarch

# \d+ event_notification_hist
...
Indexes:
    "idx_event_notification_hist" btree (audit_log_id)
    "idx_event_notification_hist_audit_log_id" btree (audit_log_id)
Foreign-key constraints:
    "fk_event_notification_hist_audit_log" FOREIGN KEY (audit_log_id) REFERENCES audit_log(audit_log_id) ON DELETE CASCADE
...

# select DeleteAuditLogOlderThenDate('2016-05-05 10:27:38.951+02');

Comment 4 errata-xmlrpc 2016-05-25 12:08:24 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://rhn.redhat.com/errata/RHBA-2016-1119.html