Bug 1652302 - Embedded Ansible Service Stops Running
Summary: Embedded Ansible Service Stops Running
Keywords:
Status: CLOSED DUPLICATE of bug 1653871
Alias: None
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: Appliance
Version: 5.9.3
Hardware: Unspecified
OS: Unspecified
urgent
urgent
Target Milestone: GA
: 5.9.7
Assignee: Gregg Tanzillo
QA Contact: Satyajit Bulage
Red Hat CloudForms Documentation
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2018-11-21 20:29 UTC by Tuan
Modified: 2022-03-13 16:10 UTC (History)
6 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2018-11-27 20:25:10 UTC
Category: Bug
Cloudforms Team: CFME Core
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Comment 5 Nick Carboni 2018-11-27 20:22:36 UTC
It turns out that this issue was caused by too many entries in the event_streams table. This was causing some queries to take ~12 hours to run. The backend connection to the database would remain open throughout the runtime of the query even though the worker which issued the query was killed.

When the workers issuing these queries were killed they would be restarted and then attempt to run the same query again. These connections associated with long running queries were accumulating until we hit the limit of 1000.

To solve this issue we truncated the event_streams table which allowed the workers to run and the number of connections stabilized.

As a fix, we should allow blacklisting events for openshift (which accounted for the majority of the 28 million rows in the table). But I'm not sure if we should attach that fix to this bug as the description here is not directly related to the fix.

Comment 6 Nick Carboni 2018-11-27 20:25:10 UTC

*** This bug has been marked as a duplicate of bug 1653871 ***


Note You need to log in before you can comment on or make changes to this bug.