Bug 1389541

Summary: Errata applicability generate is taking a very long time
Product: Red Hat Satellite Reporter: Bryan Kearney <bkearney>
Component: PulpAssignee: satellite6-bugs <satellite6-bugs>
Status: CLOSED ERRATA QA Contact: jcallaha
Severity: high Docs Contact:
Priority: high    
Version: 6.2.2CC: abalakht, bbuckingham, bkearney, bmbouter, cwelton, daniele, daviddavis, dkliban, egolov, ggainey, inecas, ipanova, jcallaha, katello-qa-list, mhrivnak, mmello, nkim, pcreech, pdwyer, rchan, satellite6-bugs, sthirugn, ttereshc, zhunting
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: 1387314 Environment:
Last Closed: 2018-02-21 16:31:31 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:
Bug Depends On: 1387314    
Bug Blocks:    

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