Note: This is a beta release of Red Hat Bugzilla 5.0. The data contained within is a snapshot of the live data so any changes you make will not be reflected in the production Bugzilla. Also email is disabled so feel free to test any aspect of the site that you want. File any problems you find or give feedback here.
Bug 1693793 - race condition when importing manifest with registered hypervisors
Summary: race condition when importing manifest with registered hypervisors
Status: NEW
Alias: None
Product: Red Hat Satellite 6
Classification: Red Hat
Component: Content Management
Version: 6.5.0
Hardware: Unspecified
OS: Unspecified
medium vote
Target Milestone: Unspecified
Assignee: satellite6-bugs
QA Contact: jcallaha
Depends On:
TreeView+ depends on / blocked
Reported: 2019-03-28 16:04 UTC by Justin Sherrill
Modified: 2019-04-02 10:20 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Last Closed:
Target Upstream Version:

Attachments (Terms of Use)

System ID Priority Status Summary Last Updated
Foreman Issue Tracker 26472 None None None 2019-03-28 16:04:24 UTC

Description Justin Sherrill 2019-03-28 16:04:23 UTC
Reproduction steps:

1.  register a bunch of hypervisors
2.  import a manifest with virt supported subs
3.  delete the manifest and repeat 2 a few times until you hit an warning



PG::ForeignKeyViolation: ERROR: update or delete on table "katello_pools" violates foreign key constraint "katello_pool_products_pool_id_fk" on table "katello_pool_products" DETAIL: Key (id)=(247) is still referenced from table "katello_pool_products". : DELETE FROM "katello_pools" WHERE "katello_pools"."id" = $1

- "/home/vagrant/.rvm/gems/ruby-2.5.1/gems/activerecord-5.2.1/lib/active_record/transactions.rb:305:in
- "/home/vagrant/git/katello/app/models/katello/glue/candlepin/candlepin_object.rb:49:in
  `block (2 levels) in import_all'"
- "/home/vagrant/.rvm/gems/ruby-2.5.1/gems/activerecord-5.2.1/lib/active_record/relation/delegation.rb:41:in
- "/home/vagrant/.rvm/gems/ruby-2.5.1/gems/activerecord-5.2.1/lib/active_record/relation/delegation.rb:41:in
- "/home/vagrant/git/katello/app/models/katello/glue/candlepin/candlepin_object.rb:44:in
  `block in import_all'"

Comment 1 Justin Sherrill 2019-03-28 16:04:25 UTC
Created from redmine issue

Comment 2 Justin Sherrill 2019-03-28 16:04:27 UTC
Upstream bug assigned to None

Comment 4 Brad Buckingham 2019-04-02 10:20:16 UTC
If this error is encountered, attempt a manifest refresh as a workaround.

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