Unable to remove stale / unused systems in Satellite 6

Solution Verified - Updated -

Issue

When removing stale / old / unused systems in Satellite 6.1 using foreman-rake, a error is thrown and the delete operation fails:

[root@server ~]# foreman-rake katello:clean_backend_objects --trace

** Invoke katello:clean_backend_objects (first_time)

** Invoke environment (first_time)

** Execute environment

** Execute katello:clean_backend_objects

"exception when destroying candlepin consumer 0669b3b7-8f7b-4047-8638-8e7a8c0144ae:Katello::Resources::Candlepin::Consumer: 500 Internal Server Error {\"displayMessage\":\"Runtime Error ERROR: update or delete on table \\\"cp_consumer\\\" violates foreign key constraint \\\"fk_sourcestack_consumer\\\" on table \\\"cp_pool_source_stack\\\"\\n  Detail: Key (id)=(9a9c949856492d1401570a11010455c0) is still referenced from table \\\"cp_pool_source_stack\\\". at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse:2,157\",\"requestUuid\":\"b29751e8-05bd-4013-94f4-a4d4c43601ca\"} (DELETE /candlepin/consumers/0669b3b7-8f7b-4047-8638-8e7a8c0144ae): {\"displayMessage\":\"Runtime Error ERROR: update or delete on table \\\"cp_consumer\\\" violates foreign key constraint \\\"fk_sourcestack_consumer\\\" on table \\\"cp_pool_source_stack\\\"\\n  Detail: Key (id)=(9a9c949856492d1401570a11010455c0) is still referenced from table \\\"cp_pool_source_stack\\\". at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse:2,157\",\"requestUuid\":\"b29751e8-05bd-4013-94f4-a4d4c43601ca\"}"

The system is also not found when deleting it using its name or UUID:

irb(main):001:0> Katello::System.find_by_name("client01.example.com")
2016-12-27 17:00:13 [D]   Katello::System Load (8.9ms)  SELECT "katello_systems".* FROM "katello_systems" WHERE "katello_systems"."name" = 'ctmm1prod-compute-40.localdomain' LIMIT 1
=> nil

irb(main):002:0> Katello::System.find_by_uuid("0669b3b7-8f7b-4047-8638-8e7a8c0144ae")
2016-12-27 17:00:26 [D]   Katello::System Load (11.6ms)  SELECT "katello_systems".* FROM "katello_systems" WHERE "katello_systems"."uuid" = '0669b3b7-8f7b-4047-8638-8e7a8c0144ae' LIMIT 1
=> nil

Environment

  • Red Hat Satellite 6.1
  • Red Hat Satellite 6.2

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.