Bug 974487
Summary: | Loading manifest throws foreign key error | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Product: | [Retired] Subscription Asset Manager | Reporter: | Tazim Kolhar <tkolhar> | ||||||||||||
Component: | katello | Assignee: | Tom McKay <tomckay> | ||||||||||||
Status: | CLOSED ERRATA | QA Contact: | Tazim Kolhar <tkolhar> | ||||||||||||
Severity: | medium | Docs Contact: | |||||||||||||
Priority: | unspecified | ||||||||||||||
Version: | 1.3 | CC: | bkearney, cwelton, jsherril, omaciel, sthirugn, tkolhar, tomckay | ||||||||||||
Target Milestone: | rc | Keywords: | Reopened, Triaged | ||||||||||||
Target Release: | 1.3 | ||||||||||||||
Hardware: | x86_64 | ||||||||||||||
OS: | Linux | ||||||||||||||
Whiteboard: | |||||||||||||||
Fixed In Version: | Doc Type: | Bug Fix | |||||||||||||
Doc Text: | Story Points: | --- | |||||||||||||
Clone Of: | Environment: | ||||||||||||||
Last Closed: | 2013-10-01 10:58:05 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: | |||||||||||||||
Bug Blocks: | 833466 | ||||||||||||||
Attachments: |
|
Since this issue was entered in Red Hat Bugzilla, the release flag has been set to ? to ensure that it is properly evaluated for this release. Hey Tazim, Katello/Satellite does not support manifest deletion, only SAM/Headpin. It looks like you have headpin installed, so I'm assuming that this was filed against the wrong product? Hi, I faced this issue on a headpin nightly setup Regards, Tazim Hey Tazim, right that makes sense, i'm just confused why this is on the Satellite product. I'll triage it for 6.0.2 since manifest deletion should be in it, but feel free to change the product to katello or SAM. This works for me. The subscriptions are displayed until the async background task is completed in candlepin, at which point the UI is refreshed. Please re-open if you have any further issues. Created attachment 774032 [details]
Delete Manifests
Hi,
I re-tested this for below rpm's :
# rpm -qa | grep katello
katello-glue-elasticsearch-1.4.2-1.git.837.d2ca1b8.el6.noarch
signo-katello-0.0.9-1.el6.noarch
katello-cli-common-1.4.2-1.git.121.7c18bf3.el6.noarch
katello-common-1.4.2-1.git.837.d2ca1b8.el6.noarch
katello-headpin-1.4.2-1.git.837.d2ca1b8.el6.noarch
katello-certs-tools-1.4.2-1.el6.noarch
katello-selinux-1.4.3-1.git.4.99dc194.el6.noarch
katello-headpin-all-1.4.2-1.git.837.d2ca1b8.el6.noarch
katello-candlepin-cert-key-pair-1.0-1.noarch
katello-cli-1.4.2-1.git.121.7c18bf3.el6.noarch
katello-configure-1.4.3-1.git.67.f71e590.el6.noarch
katello-glue-candlepin-1.4.2-1.git.837.d2ca1b8.el6.noarch
katello-repos-1.4.2-1.el6.noarch
It is still failing .
Regards,
Tazim
I cannot reproduce this. Please attach katello-debug. Specifically, the delayed job log should show the problem. As I mentioned, when you select delete manifest it is run as an async job so the subscriptions will remain visible until that completes and the page refreshes. Created attachment 774186 [details]
Delayed Job Log
Created attachment 774187 [details]
katello-debug
Created attachment 774212 [details]
Manifest used
Attached manifests (private) to reproduce error in katello: 1. import manifest #1 into org 1 2. import manifest #2 into same org 1 [[31mERROR[0m [34m2013-07-16 10:13:39[0m [36mapp[0m] Error during manifest import: {"displayMessage"=>"PG::Error: ERROR: update or delete on table \"products\" violates foreign key constraint \"marketing_engineering_products_marketing_product_id_fk\" on table \"marketing_engineering_products\"\nDETAIL: Key (id)=(7) is still referenced from table \"marketing_engineering_products\".\n: COMMIT", "conflicts"=>["UNKNOWN"]} [DEBUG [34m2013-07-16 10:13:39[0m [36mapp[0m] Task import manifest (4) error [[31mERROR[0m [34m2013-07-16 10:13:39[0m [36mapp[0m] 2013-07-16T10:13:39-0400: [Worker(host:tomckay.csb pid:17348)] Provider#queue_import_manifest failed with ActiveRecord::InvalidForeignKey: PG::Error: ERROR: update or delete on table "products" violates foreign key constraint "marketing_engineering_products_marketing_product_id_fk" on table "marketing_engineering_products" | DETAIL: Key (id)=(7) is still referenced from table "marketing_engineering_products". | : COMMIT - 0 failed attempts [[32m INFO[0m [34m2013-07-16 10:13:39[0m [36mapp[0m] 2013-07-16T10:13:39-0400: [Worker(host:tomckay.csb pid:17348)] PERMANENTLY removing Provider#queue_import_manifest because of 1 consecutive failures. [[31mERROR[0m [34m2013-07-16 10:13:39[0m [36mapp[0m] PG::Error: ERROR: update or delete on table "products" violates foreign key constraint "marketing_engineering_products_marketing_product_id_fk" on table "marketing_engineering_products" | DETAIL: Key (id)=(7) is still referenced from table "marketing_engineering_products". | : COMMIT 1:30 PM Branch: refs/heads/master Home: https://github.com/Katello/katello Commit: 3f86f7b7755c7cedef66a7ce385816646faa0d6e https://github.com/Katello/katello/commit/3f86f7b7755c7cedef66a7ce385816646faa0d6e Author: Tom McKay <thomasmckay> Date: 2013-07-16 (Tue, 16 Jul 2013) SNAP0 contains these bug fixes. Moving to ON_QA. Verified. Manifest delete now removes the subscriptions. And the issue mentioned in https://bugzilla.redhat.com/show_bug.cgi?id=974487#c15 here is tracked under a separate bug https://bugzilla.redhat.com/show_bug.cgi?id=996688 Package tested: * candlepin-0.8.19-1.el6sam.noarch * candlepin-scl-1-5.el6_4.noarch * candlepin-scl-quartz-2.1.5-5.el6_4.noarch * candlepin-scl-rhino-1.7R3-1.el6_4.noarch * candlepin-scl-runtime-1-5.el6_4.noarch * candlepin-selinux-0.8.19-1.el6sam.noarch * candlepin-tomcat6-0.8.19-1.el6sam.noarch * elasticsearch-0.19.9-8.el6sat.noarch * katello-candlepin-cert-key-pair-1.0-1.noarch * katello-certs-tools-1.4.2-2.el6sat.noarch * katello-cli-1.4.3-5.el6sat.noarch * katello-cli-common-1.4.3-5.el6sat.noarch * katello-common-1.4.3-6.el6sam_splice.noarch * katello-configure-1.4.4-2.el6sat.noarch * katello-glue-candlepin-1.4.3-6.el6sam_splice.noarch * katello-glue-elasticsearch-1.4.3-6.el6sam_splice.noarch * katello-headpin-1.4.3-6.el6sam_splice.noarch * katello-headpin-all-1.4.3-6.el6sam_splice.noarch * katello-selinux-1.4.4-2.el6sat.noarch * thumbslug-0.0.32-1.el6sam.noarch * thumbslug-selinux-0.0.32-1.el6sam.noarch 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. http://rhn.redhat.com/errata/RHEA-2013-1390.html |
Created attachment 761183 [details] Manifest delete UI Description of problem: After manifest delete, the list of subscriptions is still visible in the UI Version-Release number of selected component (if applicable): # rpm -qa | grep katello signo-katello-0.0.9-1.el6.noarch katello-headpin-1.4.2-1.git.638.2148be1.el6.noarch katello-certs-tools-1.4.2-1.el6.noarch katello-cli-1.4.2-1.git.90.6c7a175.el6.noarch katello-cli-common-1.4.2-1.git.90.6c7a175.el6.noarch katello-glue-candlepin-1.4.2-1.git.638.2148be1.el6.noarch katello-configure-1.4.3-1.git.62.f050662.el6.noarch katello-candlepin-cert-key-pair-1.0-1.noarch katello-glue-elasticsearch-1.4.2-1.git.638.2148be1.el6.noarch katello-selinux-1.4.3-1.git.4.99dc194.el6.noarch katello-common-1.4.2-1.git.638.2148be1.el6.noarch katello-headpin-all-1.4.2-1.git.638.2148be1.el6.noarch katello-repos-1.4.2-1.el6.noarch How reproducible: # yum install -y katello-headpin-all # katello-configure --user-pass=**** Steps to Reproduce: 1.Login to UI 2.Navigate to Content -> Redhat Subscriptions 3.Upload the manifest 4.Delete the manifest 5.Manifest is deleted 6.But the UI is not refreshed Actual results: the list of subscriptions is still visible Expected results: After deletion no such list should be seen in UI Additional info: Screen shot attached