Bug 1389541 - Errata applicability generate is taking a very long time
Summary: Errata applicability generate is taking a very long time
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Pulp
Version: 6.2.2
Hardware: Unspecified
OS: Unspecified
high
high vote
Target Milestone: Unspecified
Assignee: satellite6-bugs
QA Contact: jcallaha
URL:
Whiteboard:
Depends On: 1387314
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-10-27 20:20 UTC by Bryan Kearney
Modified: 2021-04-06 17:55 UTC (History)
24 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of: 1387314
Environment:
Last Closed: 2018-02-21 16:31:31 UTC
Target Upstream Version:

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Pulp Redmine 2362 0 High CLOSED - CURRENTRELEASE applicability calculation wastes time scanning a list 2016-12-02 16:01:34 UTC
Red Hat Knowledge Base (Solution) 2726721 0 None None None 2016-10-27 20:20:25 UTC

Comment 2 pulp-infra@redhat.com 2016-10-28 13:01:27 UTC 
The Pulp upstream bug status is at MODIFIED. Updating the external tracker on this bug.
Comment 3 pulp-infra@redhat.com 2016-10-28 13:01:32 UTC 
The Pulp upstream bug priority is at High. Updating the external tracker on this bug.
Comment 4 pulp-infra@redhat.com 2016-11-21 22:31:34 UTC 
The Pulp upstream bug status is at ON_QA. Updating the external tracker on this bug.
Comment 5 pulp-infra@redhat.com 2016-12-02 16:01:35 UTC 
The Pulp upstream bug status is at CLOSED - CURRENTRELEASE. Updating the external tracker on this bug.
Comment 6 jcallaha 2017-11-02 19:38:39 UTC 
Verified in Satellite 6.3 Snap 22.

errata applicability regeneration now takes on average 0.03s on a system with over 1,000 content hosts, each with approximately 150 applicable errata. See below output from /var/log/messages


Nov  2 15:22:18 rhsm-qe-1 pulp: celery.worker.job:INFO: Task pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers[57ed2848-bcec-4451-8fb0-2d21642d274d] succeeded in 18.3129570065s: None
Nov  2 15:22:18 rhsm-qe-1 pulp: celery.worker.job:INFO: Task pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers[ee544f51-bc7a-4f57-bdb1-a78a3774b61b] succeeded in 0.0308371577412s: None
Nov  2 15:22:18 rhsm-qe-1 pulp: celery.worker.job:INFO: Task pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers[3287ae22-d4e2-4a1d-bf99-19c2311124a0] succeeded in 0.0263295825571s: None
Nov  2 15:22:18 rhsm-qe-1 pulp: celery.worker.job:INFO: Task pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers[cf7035fe-5554-4b73-869d-3870e0925690] succeeded in 0.0292721735314s: None
Nov  2 15:22:18 rhsm-qe-1 pulp: celery.worker.job:INFO: Task pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers[01e6ab25-1579-4c48-b873-16a257013a17] succeeded in 0.0259636584669s: None
Nov  2 15:22:18 rhsm-qe-1 pulp: celery.worker.job:INFO: Task pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers[ee05496e-a9a1-49b0-bcec-e6c2747a76c3] succeeded in 0.0306181656197s: None
Nov  2 15:22:18 rhsm-qe-1 pulp: celery.worker.job:INFO: Task pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers[01c80689-582b-4568-a42e-7b4debc62b59] succeeded in 0.0295735644177s: None
Nov  2 15:22:18 rhsm-qe-1 pulp: celery.worker.job:INFO: Task pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers[8634ddc6-6012-4fba-9bad-b989aa1e79b5] succeeded in 0.0311072310433s: None
Nov  2 15:22:18 rhsm-qe-1 pulp: celery.worker.job:INFO: Task pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers[e7c930c6-7fb0-453f-bf72-80d2b1f5fc76] succeeded in 0.0292136054486s: None
Nov  2 15:22:18 rhsm-qe-1 pulp: celery.worker.job:INFO: Task pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers[ee20e06a-a744-4da3-bd85-1b3514cab962] succeeded in 0.0264438549057s: None
Nov  2 15:22:18 rhsm-qe-1 pulp: celery.worker.job:INFO: Task pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers[84d1f61c-184f-4bd2-9d6f-e3c8fdbe8890] succeeded in 0.0269902581349s: None
Nov  2 15:22:18 rhsm-qe-1 pulp: celery.worker.job:INFO: Task pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers[04c517a0-3323-42cb-bfb5-718d7ffbded2] succeeded in 0.0301549723372s: None
Nov  2 15:22:19 rhsm-qe-1 pulp: celery.worker.job:INFO: Task pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers[5a8c5c30-bf5d-45e3-bd02-da2db1417ca2] succeeded in 0.026947199367s: None
Nov  2 15:22:19 rhsm-qe-1 pulp: celery.worker.job:INFO: Task pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers[807680e6-31f1-4269-8a51-290c5ad68f10] succeeded in 0.0256103686988s: None
Nov  2 15:22:19 rhsm-qe-1 pulp: celery.worker.job:INFO: Task pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers[4d74e530-7854-4a4e-b4b1-3a304dd0d163] succeeded in 0.0261389240623s: None
Nov  2 15:22:19 rhsm-qe-1 pulp: celery.worker.job:INFO: Task pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers[3efb8994-6273-43d9-ba34-223a6f1222bb] succeeded in 0.0254320427775s: None
Nov  2 15:22:19 rhsm-qe-1 pulp: celery.worker.job:INFO: Task pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers[0950b0f9-03fd-4c6c-88cd-ccc580d44f02] succeeded in 0.0299131339416s: None
Nov  2 15:22:19 rhsm-qe-1 pulp: celery.worker.job:INFO: Task pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers[22fc7bcc-8ff5-43e3-bcae-e55d740f46da] succeeded in 0.0315136518329s: None
Comment 7 Bryan Kearney 2018-02-21 16:31:31 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://access.redhat.com/errata/RHSA-2018:0336
Note You need to log in before you can comment on or make changes to this bug.