Why the Clean Up Management Jobs are Failing with the "Error: public.main_jobevent does not exist" on Automation Controller?

Solution Verified - Updated -

Issue

  • Why the Clean up Management jobs are failing.
  • Getting the below error while running the Clean up Management jobs:


    File "/var/lib/awx/venv/awx/lib64/python3.8/site-packages/django/db/utils.py", line 90, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "/var/lib/awx/venv/awx/lib64/python3.8/site-packages/django/db/backends/utils.py", line 82, in _execute return self.cursor.execute(sql) django.db.utils.ProgrammingError: relation "public.main_jobevent" does not exist LINE 1: ...ild FROM pg_catalog.pg_inherits WHERE inhparent = 'public.ma...

Environment

  • Ansible Automation Platform 2.1 or later.

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content