Restore leaves broken awx_task container

[gendergap]

Please confirm the following

• I agree to follow this project's code of conduct.
• I have checked the current issues for duplicates.
• I understand that the AWX Operator is open source software provided for free and that I might not receive a timely response.

Bug Summary

Restoring an AWX backup spins up the web interface, but the task container does not work. It shows a database column error.

AWX Operator version

2.9.0

AWX version

23.5.1

Kubernetes platform

kubernetes

Kubernetes/Platform version

1.20.11

Modifications

no

Steps to reproduce

• Restore a backup of AWX (previously created like described in the manual)
• Wait until the manager stops spinning up resources and the database has been restored
• Log in to the web interface
• Launch any job

Expected results

The job should start and complete.

Actual results

The job stays pending for eternity. Inspecting the awx_task pod shows the error message:

[wait-for-migrations] Waiting for database migrations...
[wait-for-migrations] Attempt 1
Traceback (most recent call last):
File "/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
File "/var/lib/awx/venv/awx/lib64/python3.9/site-packages/psycopg/cursor.py", line 723, in execute
raise ex.with_traceback(None)
psycopg.errors.UndefinedColumn: column "listener_port" of relation "main_instance" does not exist
LINE 1: ...city", "mem_capacity", "node_type", "node_state", "listener_...

Additional information

No response

Operator Logs

No response