Bug 1344257
| Summary: | ERROR: duplicate key value violates unique constraint "cp_product_content_pkey" | |||
|---|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Roman Plevka <rplevka> | |
| Component: | Candlepin | Assignee: | Justin Sherrill <jsherril> | |
| Status: | CLOSED ERRATA | QA Contact: | Peter Ondrejka <pondrejk> | |
| Severity: | high | Docs Contact: | ||
| Priority: | unspecified | |||
| Version: | 6.2.0 | CC: | bbuckingham, bcourt, bkearney, ehelms, jcallaha, jsherril, ktordeur, rplevka | |
| Target Milestone: | Unspecified | Keywords: | Triaged | |
| Target Release: | Unused | |||
| Hardware: | Unspecified | |||
| OS: | Unspecified | |||
| Whiteboard: | ||||
| Fixed In Version: | candlepin-0.9.54.7-1 | Doc Type: | If docs needed, set a value | |
| Doc Text: | Story Points: | --- | ||
| Clone Of: | ||||
| : | 1344402 (view as bug list) | Environment: | ||
| Last Closed: | 2018-02-21 16:32:07 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: | 1344402 | |||
| Bug Blocks: | 1360430 | |||
There are two more bugs that might be holding up this issue: 1345765, 1345766. The original problem with cp_product_content_pkey already has associted (unreviewed) fix in 1344402 the following BZ is most probably related to this: https://bugzilla.redhat.com/show_bug.cgi?id=1317922 Upstream bug component is Candlepin Verified in Sat 6.3 snap 5 according to steps detailed in problem description. A product with a large number of repos is now successfully removed and no sql errors appear in /var/log/candlepin/candlepin.log 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 |
Description of problem: On removing a product with many repositories, candlepin throws a number of exceptions (probably due to a race condition). This leads to a failed task which stays in paused state and blocks other related tasks (e.g. organization removal). Resuming the task sometimes works. Version-Release number of selected component (if applicable): 6.2.0 Beta GA15.0 How reproducible: Steps to Reproduce: 1. create an organization with some product 2. create many repositories inside this product 3. [optional] tail -f /var/log/candlepin/candlepin.log 4. delete the product (or an organization) ``` this simple loop should feed your product by 50 repos: ORG=3 PROD=1 for i in {1..50}; do hammer --csv repository create --content-type puppet --name="foo_${i}" --organization-id ${ORG} --product-id ${PROD} --url="https://aaaaa.com/aaa/${i}"; done ``` - the URL length migh matter (or whatever that keeps candlepin more busy while processing the repo) Actual results: ERROR: duplicate key value violates unique constraint "cp_product_content_pkey" Expected results: - no SQL errors, product properly removed Additional info: