When uploading Manifest on Satellite 6.5, facing issue: 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"
Issue
Uploading a subscription manifest on Satellite 6.5 server sometimes fails due to the error:
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)=(2) is still referenced from table "katello_pool_products".
: DELETE FROM "katello_pools" WHERE "katello_pools"."id" = $1
Environment
Satellite 6.5
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.