Description of problem: # in foreman-rake console > rl = ForemanTasks::RecurringLogic.last > rl.destroy ActiveRecord::StatementInvalid (PG::UndefinedColumn: ERROR: column katello_sync_plans.recurring_logic_id does not exist) LINE 1: ...llo_sync_plans".* FROM "katello_sync_plans" WHERE "katello_s... ^ : SELECT "katello_sync_plans".* FROM "katello_sync_plans" WHERE "katello_sync_plans"."recurring_logic_id" = $1 LIMIT $2 Version-Release number of selected component (if applicable): 6.5 How reproducible: Always Steps to Reproduce: 1. Create a sync plan 2. From the Monitor -> recurring logic, you will be able to see the created sync plan 3. Cancel this recurring logic. 3. Now try to delete this "cancelled" recurring logic # foreman-rake console ForemanTasks::RecurringLogic.where(state: "cancelled").destroy_all Actual results: irb(main):001:0> ForemanTasks::RecurringLogic.where(state: "cancelled").destroy_all Traceback (most recent call last): 2: from lib/tasks/console.rake:5:in `block in <top (required)>' 1: from (irb):1 ActiveRecord::StatementInvalid (PG::UndefinedColumn: ERROR: column katello_sync_plans.recurring_logic_id does not exist) LINE 1: ...llo_sync_plans".* FROM "katello_sync_plans" WHERE "katello_s... ^ : SELECT "katello_sync_plans".* FROM "katello_sync_plans" WHERE "katello_sync_plans"."recurring_logic_id" = $1 LIMIT $2 irb(main):002:0> Expected results: Delete the "cancelled" recurring logic Additional info: There is an upstream bug already fixed for the same issue. I have tried the patch and it works with no issue https://projects.theforeman.org/issues/26028
Upstream bug assigned to inecas
Moving this bug to POST for triage into Satellite 6 since the upstream issue https://projects.theforeman.org/issues/26028 has been resolved.
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-2019:3172