awx restore loop

[birb57]

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

Hi

I am trying to restore awx backup taken from old host under redhat to a new one

Seems that awx restore role complete succeefully but non stop loop

awx version 👍 | 2.19.1 | 24.6.1 |

[IAAS - root@awx-on-k3s]$ kubectl version
Client Version: v1.28.5+k3s1
Kustomize Version: v5.0.4-0.20230601165947-6ce0bf390ce3
Server Version: v1.28.5+k3s1
[IAAS - root@awx-on-k3s]$ more restore/awxrestore.yaml

apiVersion: awx.ansible.com/v1beta1
kind: AWXRestore
metadata:
name: awxrestore-2025-10-02
namespace: awx
spec:
deployment_name: awx

Parameters to restore from AWXBackup object

#backup_name: awxbackup-2021-06-06

Parameters to restore from existing files on PVC (without AWXBackup object)

backup_pvc: awx-backup-claim
backup_dir: /backups/tower-openshift-backup-2025-10-02-105434

Uncomment to reveal "censored" logs

#no_log: false

Thanks

AWX Operator version

2.19.1

AWX version

24.6.1

Kubernetes platform

kubernetes

Kubernetes/Platform version

v1.28.5+k3s1

Modifications

no

Steps to reproduce

backup awx via role on old system under 24.6.1/2.19.1
restore awx backup on new system under same RH/AWX/Operator release

Expected results

NAME READY STATUS RESTARTS AGE
awx-operator-controller-manager-745b55d94b-9j2sr 2/2 Running 4 (48m ago) 109m
awx-postgres-15-0 1/1 Running 0 36m
awx-migration-24.6.1-xbg4c 0/1 Completed 0 35m
awx-web-7c78fbd657-zv9zz 3/3 Running 0 4m21s
awx-task-678d56774d-dgkdn 4/4 Running 4 (55s ago) 4m19s
[IAAS - root@awx-on-k3s]$ more restore/

Actual results

NAME READY STATUS RESTARTS AGE
awx-operator-controller-manager-745b55d94b-9j2sr 2/2 Running 4 (59m ago) 119m
awx-postgres-15-0 1/1 Running 0 47m
awx-migration-24.6.1-6d6xp 0/1 Error 0 46m
awx-migration-24.6.1-xbg4c 0/1 Completed 0 46m
awx-web-7c78fbd657-dkdkp 3/3 Running 0 3m37s
awx-task-678d56774d-jcstn 3/4 CrashLoopBackOff 3 (34s ago) 3m35s
awxrestore-2025-10-02-db-management 1/1 Terminating 0 4m39s

Additional information

No response

Operator Logs

restore command] ****************************************\r\ntask path: /opt/ansible/roles/restore/tasks/postgres.yml:75\nok: [localhost] => {"censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false}\n\r\nTASK [restore : Set drop db command] *******************************************\r\ntask path: /opt/ansible/roles/restore/tasks/postgres.yml:87\nskipping: [localhost] => {"censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false}\n\r\nTASK [restore : Set create db command] *****************************************\r\ntask path: /opt/ansible/roles/restore/tasks/postgres.yml:97\nskipping: [localhost] => {"censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false}\n\r\nTASK [restore : Set complete pg restore command] *******************************\r\ntask path: /opt/ansible/roles/restore/tasks/postgres.yml:107\nskipping: [localhost] => {"changed": false, "false_condition": "force_drop_db", "skip_reason": "Conditional result was False"}\n\r\nTASK [restore : Restore database dump to the new postgresql container] *********\r\ntask path: /opt/ansible/roles/restore/tasks/postgres.yml:114\nfatal: [localhost]: FAILED! => {"censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": true}\n\r\nPLAY RECAP *********************************************************************\r\nlocalhost : ok=50 changed=8 unreachable=0 failed=1 skipped=19 rescued=0 ignored=0 \n","job":"200270453323133515","name":"awxrestore-2025-10-02","namespace":"awx","error":"exit status 2","stacktrace":"github.com/operator-framework/ansible-operator-plugins/internal/ansible/runner.(*runner).Run.func1\n\tansible-operator-plugins/internal/ansible/runner/runner.go:269"}

[birb57]

Let me know if you need more info
thanks for your support

[birb57]

Below logs from task pod during crash:
[IAAS - root@vmtowerstaging awx-on-k3s]$ kubectl logs awx-task-678d56774d-tbn49 -n awx
[wait-for-migrations] Waiting for database migrations...
[wait-for-migrations] Attempt 1
min_value in DecimalField should be Decimal type.
Instance Group already registered controlplane
Instance Group already registered default
Successfully registered instance None
(changed: True)
2025-10-04 15:24:45,668 INFO RPC interface 'supervisor' initialized
2025-10-04 15:24:45,668 INFO RPC interface 'supervisor' initialized
2025-10-04 15:24:45,668 CRIT Server 'unix_http_server' running without any HTTP authentication checking
2025-10-04 15:24:45,668 CRIT Server 'unix_http_server' running without any HTTP authentication checking
2025-10-04 15:24:45,668 INFO supervisord started with pid 7
2025-10-04 15:24:45,668 INFO supervisord started with pid 7
2025-10-04 15:24:46,671 INFO spawned: 'superwatcher' with pid 37
2025-10-04 15:24:46,671 INFO spawned: 'superwatcher' with pid 37
2025-10-04 15:24:46,673 INFO spawned: 'dispatcher' with pid 38
2025-10-04 15:24:46,673 INFO spawned: 'dispatcher' with pid 38
2025-10-04 15:24:46,675 INFO spawned: 'callback-receiver' with pid 39
2025-10-04 15:24:46,675 INFO spawned: 'callback-receiver' with pid 39
2025-10-04 15:24:46,677 INFO spawned: 'wsrelay' with pid 40
2025-10-04 15:24:46,677 INFO spawned: 'wsrelay' with pid 40
READY
2025-10-04 15:24:47,678 INFO success: superwatcher entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2025-10-04 15:24:47,678 INFO success: superwatcher entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2025-10-04 15:24:47,678 INFO success: wsrelay entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2025-10-04 15:24:47,678 INFO success: wsrelay entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2025-10-04 15:24:48,800 INFO [-] awx.main.wsrelay Active instance with hostname awx-task-678d56774d-tbn49 is registered.
2025-10-04 15:24:48,810 INFO [-] awx.main.wsrelay Starting Websocket Relayer...
2025-10-04 15:24:48,829 INFO [-] awx.main.commands.run_callback_receiver Callback receiver started with pid=39
2025-10-04 15:24:48,841 DEBUG [-] awx.main.dispatch scaling up worker pid:64
2025-10-04 15:24:48,848 DEBUG [-] awx.main.dispatch scaling up worker pid:65
2025-10-04 15:24:48,854 DEBUG [-] awx.main.dispatch scaling up worker pid:66
2025-10-04 15:24:48,859 DEBUG [-] awx.main.dispatch scaling up worker pid:67
2025-10-04 15:24:48,862 INFO [-] awx.main.dispatch Running worker dispatcher listening to queues ['tower_broadcast_all', 'tower_settings_change', 'awx-task-678d56774d-tbn49']
2025-10-04 15:24:48,917 DEBUG [-] awx.main.tasks Syncing Schedules
2025-10-04 15:24:49,014 ERROR [-] awx.main.dispatch Encountered unhandled error in dispatcher main loop
Traceback (most recent call last):
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/fields/related_descriptors.py", line 218, in get
rel_obj = self.field.get_cached_value(instance)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/fields/mixins.py", line 15, in get_cached_value
return instance._state.fields_cache[cache_name]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
KeyError: 'unified_job_template'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/tasks/system.py", line 97, in dispatch_startup
sch.update_computed_fields()
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/models/schedules.py", line 299, in update_computed_fields
super(Schedule, self).save(update_fields=['next_run', 'dtstart', 'dtend', 'modified'])
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/models/base.py", line 344, in save
super(PrimordialModel, self).save(*args, **kwargs)
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/models/base.py", line 192, in save
super(CreatedModifiedModel, self).save(*args, **kwargs)
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/base.py", line 814, in save
self.save_base(
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/base.py", line 861, in save_base
pre_save.send(
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/dispatch/dispatcher.py", line 176, in send
return [
^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/dispatch/dispatcher.py", line 177, in
(receiver, receiver(signal=self, sender=sender, **named))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/signals.py", line 472, in activity_stream_update
changes = model_instance_diff(old, new, model_serializer_mapping())
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/utils/common.py", line 413, in model_instance_diff
old_value = getattr(old, field, None)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/fields/related_descriptors.py", line 236, in get
rel_obj = self.get_object(instance)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/fields/related_descriptors.py", line 199, in get_object
return qs.get(self.field.get_reverse_related_filter(instance))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/query.py", line 633, in get
num = len(clone)
^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/query.py", line 380, in len
self._fetch_all()
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/query.py", line 1881, in _fetch_all
self._result_cache = list(self._iterable_class(self))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/polymorphic/query.py", line 64, in _polymorphic_iterator
real_results = self.queryset._get_real_instances(base_result_objects)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/polymorphic/query.py", line 470, in _get_real_instances
real_class = real_object.get_real_instance_class()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/polymorphic/models.py", line 129, in get_real_instance_class
raise PolymorphicTypeInvalid(
polymorphic.models.PolymorphicTypeInvalid: ContentType 1 for <class 'awx.main.models.jobs.SystemJobTemplate'> #1 does not point to a subclass!

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/fields/related_descriptors.py", line 218, in get
rel_obj = self.field.get_cached_value(instance)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/fields/mixins.py", line 15, in get_cached_value
return instance._state.fields_cache[cache_name]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
KeyError: 'unified_job_template'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/dispatch/worker/base.py", line 237, in run
self.worker.on_start()
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/dispatch/worker/task.py", line 141, in on_start
dispatch_startup()
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/tasks/system.py", line 99, in dispatch_startup
logger.exception("Failed to rebuild schedule {}.".format(sch))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/models/schedules.py", line 234, in str
return u'%s_t%s_%s_%s' % (self.name, self.unified_job_template.id, self.id, self.next_run)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/fields/related_descriptors.py", line 236, in get
rel_obj = self.get_object(instance)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/fields/related_descriptors.py", line 199, in get_object
return qs.get(self.field.get_reverse_related_filter(instance))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/query.py", line 633, in get
num = len(clone)
^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/query.py", line 380, in len
self._fetch_all()
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/query.py", line 1881, in _fetch_all
self._result_cache = list(self._iterable_class(self))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/polymorphic/query.py", line 64, in _polymorphic_iterator
real_results = self.queryset._get_real_instances(base_result_objects)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/polymorphic/query.py", line 470, in _get_real_instances
real_class = real_object.get_real_instance_class()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/polymorphic/models.py", line 129, in get_real_instance_class
raise PolymorphicTypeInvalid(
polymorphic.models.PolymorphicTypeInvalid: ContentType 1 for <class 'awx.main.models.jobs.SystemJobTemplate'> #1 does not point to a subclass!
2025-10-04 15:24:49,020 DEBUG [-] awx.main.dispatch worker exiting gracefully pid:65
Traceback (most recent call last):
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/fields/related_descriptors.py", line 218, in get
rel_obj = self.field.get_cached_value(instance)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/fields/mixins.py", line 15, in get_cached_value
return instance._state.fields_cache[cache_name]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
KeyError: 'unified_job_template'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/tasks/system.py", line 97, in dispatch_startup
sch.update_computed_fields()
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/models/schedules.py", line 299, in update_computed_fields
super(Schedule, self).save(update_fields=['next_run', 'dtstart', 'dtend', 'modified'])
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/models/base.py", line 344, in save
super(PrimordialModel, self).save(*args, **kwargs)
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/models/base.py", line 192, in save
super(CreatedModifiedModel, self).save(*args, **kwargs)
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/base.py", line 814, in save
self.save_base(
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/base.py", line 861, in save_base
pre_save.send(
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/dispatch/dispatcher.py", line 176, in send
return [
^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/dispatch/dispatcher.py", line 177, in
(receiver, receiver(signal=self, sender=sender, **named))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/signals.py", line 472, in activity_stream_update
changes = model_instance_diff(old, new, model_serializer_mapping())
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/utils/common.py", line 413, in model_instance_diff
2025-10-04 15:24:49,020 DEBUG [-] awx.main.dispatch worker exiting gracefully pid:64
old_value = getattr(old, field, None)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/fields/related_descriptors.py", line 236, in get
rel_obj = self.get_object(instance)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/fields/related_descriptors.py", line 199, in get_object
return qs.get(self.field.get_reverse_related_filter(instance))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/query.py", line 633, in get
num = len(clone)
^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/query.py", line 380, in len
self._fetch_all()
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/query.py", line 1881, in _fetch_all
self._result_cache = list(self._iterable_class(self))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/polymorphic/query.py", line 64, in _polymorphic_iterator
real_results = self.queryset._get_real_instances(base_result_objects)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/polymorphic/query.py", line 470, in _get_real_instances
real_class = real_object.get_real_instance_class()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/polymorphic/models.py", line 129, in get_real_instance_class
raise PolymorphicTypeInvalid(
polymorphic.models.PolymorphicTypeInvalid: ContentType 1 for <class 'awx.main.models.jobs.SystemJobTemplate'> #1 does not point to a subclass!

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/fields/related_descriptors.py", line 218, in get
rel_obj = self.field.get_cached_value(instance)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/fields/mixins.py", line 15, in get_cached_value
return instance._state.fields_cache[cache_name]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
KeyError: 'unified_job_template'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/usr/bin/awx-manage", line 8, in
sys.exit(manage())
^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/init.py", line 177, in manage
execute_from_command_line(sys.argv)
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/core/management/init.py", line 442, in execute_from_command_line
utility.execute()
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/core/management/init.py", line 436, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/core/management/base.py", line 412, in run_from_argv
self.execute(*args, **cmd_options)
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/core/management/base.py", line 458, in execute
output = self.handle(*args, **options)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/management/commands/run_dispatcher.py", line 71, in handle
consumer.run()
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/dispatch/worker/base.py", line 237, in run
self.worker.on_start()
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/dispatch/worker/task.py", line 141, in on_start
dispatch_startup()
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/tasks/system.py", line 99, in dispatch_startup
2025-10-04 15:24:49,025 DEBUG [-] awx.main.dispatch worker exiting gracefully pid:67
logger.exception("Failed to rebuild schedule {}.".format(sch))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/awx/main/models/schedules.py", line 234, in str
return u'%s_t%s_%s_%s' % (self.name, self.unified_job_template.id, self.id, self.next_run)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/fields/related_descriptors.py", line 236, in get
rel_obj = self.get_object(instance)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/fields/related_descriptors.py", line 199, in get_object
return qs.get(self.field.get_reverse_related_filter(instance))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/query.py", line 633, in get
num = len(clone)
^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/query.py", line 380, in len
self._fetch_all()
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/models/query.py", line 1881, in _fetch_all
self._result_cache = list(self._iterable_class(self))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/polymorphic/query.py", line 64, in _polymorphic_iterator
real_results = self.queryset._get_real_instances(base_result_objects)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/polymorphic/query.py", line 470, in _get_real_instances
real_class = real_object.get_real_instance_class()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/polymorphic/models.py", line 129, in get_real_instance_class
raise PolymorphicTypeInvalid(
polymorphic.models.PolymorphicTypeInvalid: ContentType 1 for <class 'awx.main.models.jobs.SystemJobTemplate'> #1 does not point to a subclass!
[IAAS - root@vmtowerstaging awx-on-k3s]$

[birb57]

Hi

when setting "no_log: false" in awxrestore.yaml I got below fatal error for pg_restore:
TASK [Restore database dump to the new postgresql container] ********************************
fatal: [localhost]: FAILED! => {"changed": true, "rc": 1, "return_code": 1, "stderr": "pg_restore: error: could not execute query: ERROR: could not create unique index "dab_rbac_objectrole
pkey"\nDETAIL: Key (id)=(1) is duplicated.\nCommand was: ALTER TABLE ONLY public.dab_rbac_objectrole\n ADD CONSTRAINT dab_rbac_objectrole_pkey PRIMARY KEY (id);\n\n\npg_restore: error:
could not execute query: ERROR: could not create unique index "dab_rbac_roleevaluation_pkey"\nDETAIL: Key (id)=(1) is duplicated.\nCommand was: ALTER TABLE ONLY public.dab_rbac_roleeval
uation\n ADD CONSTRAINT dab_rbac_roleevaluation_pkey PRIMARY KEY (id);\n\n\npg_restore: error: could not execute query: ERROR: could not create unique index "main_organization_name_key
"\nDETAIL: Key (name)=(Default) is duplicated.\nCommand was: ALTER TABLE ONLY public.main_organization\n ADD CONSTRAINT main_organization_name_key UNIQUE (name);\n\n\npg_restore: error:
could not execute query: ERROR: could not create unique index "main_organization_pkey"\nDETAIL: Key (id)=(1) is duplicated.\nCommand was: ALTER TABLE ONLY public.main_organization\n A
DD CONSTRAINT main_organization_pkey PRIMARY KEY (id);\n\n\npg_restore: error: could not execute query: ERROR: could not create unique index "main_organizationgalaxycredentialmembership_pk
ey"\nDETAIL: Key (id)=(1) is duplicated.\nCommand was: ALTER TABLE ONLY public.main_organizationgalaxycredentialmembership\n ADD CONSTRAINT main_organizationgalaxycredentialmembership_p
key PRIMARY KEY (id);\n\n\npg_restore: error: could not execute query: ERROR: could not create unique index "main_rbac_roles_members_pkey"\nDETAIL: Key (id)=(1) is duplicated.\nCommand w
as: ALTER TABLE ONLY public.main_rbac_roles_members\n ADD CONSTRAINT main_rbac_roles_members_pkey PRIMARY KEY (id);\n\n\npg_restore: error: could not execute query: ERROR: could not crea
te unique index "main_rbac_roles_parents_from_role_id_to_role_id_1ab75c81_uniq"\nDETAIL: Key (from_role_id, to_role_id)=(18, 16) is duplicated.\nCommand was: ALTER TABLE ONLY public.main
rbac_roles_parents\n ADD CONSTRAINT main_rbac_roles_parents_from_role_id_to_role_id_1ab75c81_uniq UNIQUE (from_role_id, to_role_id);\n\n\npg_restore: error: could not execute query: ERROR
: could not create unique index "main_rbac_roles_parents_pkey"\nDETAIL: Key (id)=(25) is duplicated.\nCommand was: ALTER TABLE ONLY public.main_rbac_roles_parents\n ADD CONSTRAINT mai
n_rbac_roles_parents_pkey PRIMARY KEY (id);\n\n\npg_restore: error: could not execute query: ERROR: could not create unique index "main_rbac_roles_pkey"\nDETAIL: Key (id)=(17) is duplica
ted.\nCommand was: ALTER TABLE ONLY public.main_rbac_roles\n ADD CONSTRAINT main_rbac_roles_pkey PRIMARY KEY (id);\n\n\npg_restore: error: could not execute query: ERROR: could not creat
e unique index "main_rbac_roles_singleton_name_key"\nDETAIL: Key (singleton_name)=(system_auditor) is duplicated.\nCommand was: ALTER TABLE ONLY public.main_rbac_roles\n ADD CONSTRAINT
main_rbac_roles_singleton_name_key UNIQUE (singleton_name);\n\n\npg_restore: error: could not execute query: ERROR: could not create unique index "main_unifiedjobtemplate_pkey"\nDETAIL:
Key (id)=(2) is duplicated.\nCommand was: ALTER TABLE ONLY public.main_unifiedjobtemplate\n ADD CONSTRAINT main_unifiedjobtemplate_pkey PRIMARY KEY (id);\n\n\npg_restore: error: could no
t execute query: ERROR: there is no unique constraint matching given keys for referenced table "dab_rbac_objectrole"\nCommand was: ALTER TABLE ONLY public.dab_rbac_objectrole_provides_tea
ms\n ADD CONSTRAINT dab_rbac_objectrole__objectrole_id_406b577e_fk_dab_rbac_ FOREIGN KEY (objectrole_id) REFERENCES public.dab_rbac_objectrole(id) DEFERRABLE INITIALLY DEFERRED;\n\n\npg_r
estore: error: could not execute query: ERROR: there is no unique constraint matching given keys for referenced table "dab_rbac_objectrole"\nCommand was: ALTER TABLE ONLY public.dab_rbac_
roleevaluationuuid\n ADD CONSTRAINT dab_rbac_roleevaluat_role_id_254631b0_fk_dab_rbac_ FOREIGN KEY (role_id) REFERENCES public.dab_rbac_objectrole(id) DEFERRABLE INITIALLY DEFERRED;\n\n\n
pg_restore: error: could not execute query: ERROR: there is no unique constraint matching given keys for referenced table "dab_rbac_objectrole"\nCommand was: ALTER TABLE ONLY public.dab_r
bac_roleevaluation\n ADD CONSTRAINT dab_rbac_roleevaluat_role_id_93254162_fk_dab_rbac_ FOREIGN KEY (role_id) REFERENCES public.dab_rbac_objectrole(id) DEFERRABLE INITIALLY DEFERRED;\n\n\n
pg_restore: error: could not execute query: ERROR: there is no unique constraint matching given keys for referenced table "dab_rbac_objectrole"\nCommand was: ALTER TABLE ONLY public.dab_r
bac_roleteamassignment\n ADD CONSTRAINT dab_rbac_roleteamass_object_role_id_4a315264_fk_dab_rbac_ FOREIGN KEY (object_role_id) REFERENCES public.dab_rbac_objectrole(id) DEFERRABLE INITIAL
LY DEFERRED;\n\n\npg_restore: error: could not execute query: ERROR: there is no unique constraint matching given keys for referenced table "dab_rbac_objectrole"\nCommand was: ALTER TABLE
ONLY public.dab_rbac_roleuserassignment\n ADD CONSTRAINT dab_rbac_roleuserass_object_role_id_47901e46_fk_dab_rbac_ FOREIGN KEY (object_role_id) REFERENCES public.dab_rbac_objectrole(id)
DEFERRABLE INITIALLY DEFERRED;\n\n\npg_restore: error: could not execute query: ERROR: there is no unique constraint matching given keys for referenced table "main_organization"\nCommand
was: ALTER TABLE ONLY public.main_activitystream_organization\n

[birb57]

thanks

[birb57]

Hi

some feedback ?

Thanks