Ansible Automation Platform 2.1, jobs are hanging and failing with error "Task was marked as running but was not present in the job queue, so it has been marked as failed"

Issue

• Ansible Automation Platform 2.1, jobs are hanging, failing with error "Task was marked as running but was not present in the job queue, so it has been marked as failed". The following error can be seen in tower.log.

  2023-02-08 05:00:24,992 ERROR    [-] awx.main.commands.run_callback_receiver Database Error Saving Job Event
  Traceback (most recent call last):
    File "/var/lib/awx/venv/awx/lib64/python3.8/site-packages/django/db/backends/utils.py", line 84, in _execute
  return self.cursor.execute(sql, params)
  psycopg2.errors.CheckViolation: no partition of relation "main_jobevent" found for row
  DETAIL:  Partition key of the failing row contains (job_created) = (2023-02-08 05:00:07.808235+00).