Bug 1729048

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