Upgrading from 1.5.0.24 to 1.0.6

Archives AWX Project
1

Hello, this is my second attempt at upgrading AWX which has seemed to fail.

The instructions I got from various online articles were.

  • Delete the containers
  • Re-run the installer.

I have now tried devel and also using the 1.0.6 tag.

https://github.com/ansible/awx/releases/tag/1.0.6

Change branch to the tag.

`

root@ansible-awx[shared_services]:awx (devel)$ git checkout -b 1.0.6 tags/1.0.6
Switched to a new branch ‘1.0.6’

`

Stop containers

root@ansible-awx[shared_services]:awx (1.0.6)$ docker stop 9fd57deeb66a 333c8a9329f5 2ba03e546802 59e35e5f872b 713d0fe6bbb6 9fd57deeb66a 333c8a9329f5 2ba03e546802 59e35e5f872b 713d0fe6bbb6

Remove Containers

root@ansible-awx[shared_services]:awx (1.0.6)$ docker rm 9fd57deeb66a 333c8a9329f5 2ba03e546802 59e35e5f872b 713d0fe6bbb6 9fd57deeb66a 333c8a9329f5 2ba03e546802 59e35e5f872b 713d0fe6bbb6

Change to installer dir

root@ansible-awx[shared_services]:awx (1.0.6)$ cd installer/

Run the playbook

root@ansible-awx[shared_services]:installer (1.0.6)$ ansible-playbook -i inventory install.yml -e postgres_data_dir=/var/lib/pgdocker

2

By failed, It stays on version:

<  AWX 1.0.5.24  >
3

Attempting the zip now, I must have missed this (https://github.com/ansible/awx/archive/1.0.6.zip)

4

This has made no difference.

5

docker stop awx_task
docker rm awx_task
docker rmi ansible/awx_task:latest

docker stop awx_web
docker rm awx_web
docker rmi ansible/awx_web:latest

ansible-playbook -i hosts install.yml

I missed the rmi part you can close this.

6

All I see in my logs are errors :frowning:

`

2018-08-14 08:41:31,273 ERROR awx.main.tasks Failed to rebuild schedule Prod - Common.yml_t20_9_2018-08-14 09:25:00+00:00.
Traceback (most recent call last):
File “/usr/lib/python2.7/site-packages/awx/main/tasks.py”, line 115, in celery_startup
sch.update_computed_fields()
File “/usr/lib/python2.7/site-packages/awx/main/models/schedules.py”, line 249, in update_computed_fields
self.unified_job_template.update_computed_fields()
File “/usr/lib/python2.7/site-packages/awx/main/models/unified_jobs.py”, line 253, in update_computed_fields
self.save(update_fields=[‘next_schedule’, ‘next_job_run’])
File “/usr/lib/python2.7/site-packages/awx/main/models/unified_jobs.py”, line 266, in save
super(UnifiedJobTemplate, self).save(*args, **kwargs)
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/polymorphic/models.py”, line 83, in save
return super(PolymorphicModel, self).save(*args, **kwargs)
File “/usr/lib/python2.7/site-packages/awx/main/models/base.py”, line 316, in save
super(PrimordialModel, self).save(*args, **kwargs)
File “/usr/lib/python2.7/site-packages/awx/main/models/base.py”, line 164, in save
super(CreatedModifiedModel, self).save(*args, **kwargs)
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/models/base.py”, line 808, in save
force_update=force_update, update_fields=update_fields)
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/models/base.py”, line 848, in save_base
update_fields=update_fields, raw=raw, using=using,
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/dispatch/dispatcher.py”, line 193, in send
for receiver in self._live_receivers(sender)
File “/usr/lib/python2.7/site-packages/awx/main/fields.py”, line 331, in _post_save
update_role_parentage_for_instance(latest_instance)
File “/usr/lib/python2.7/site-packages/awx/main/fields.py”, line 198, in update_role_parentage_for_instance
cur_role.parents.remove(*list(original_parents - new_parents))
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/models/fields/related_descriptors.py”, line 950, in remove
self._remove_items(self.source_field_name, self.target_field_name, *objs)
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/models/fields/related_descriptors.py”, line 1137, in _remove_items
model=self.model, pk_set=old_ids, using=db,
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/dispatch/dispatcher.py”, line 193, in send
for receiver in self._live_receivers(sender)
File “/usr/lib/python2.7/site-packages/awx/main/signals.py”, line 195, in rbac_activity_stream
if role is not None and is_implicit_parent(parent_role=role, child_role=instance):
File “/usr/lib/python2.7/site-packages/awx/main/fields.py”, line 181, in is_implicit_parent
related_obj = getattr(related_obj, next_field)
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/models/fields/related_descriptors.py”, line 184, in get
rel_obj = self.get_object(instance)
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/models/fields/related_descriptors.py”, line 159, in get_object
return qs.get(self.field.get_reverse_related_filter(instance))
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/models/query.py”, line 374, in get
num = len(clone)
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/models/query.py”, line 232, in len
self._fetch_all()
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/models/query.py”, line 1118, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/models/query.py”, line 53, in iter
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
File “/var/lib/awx/venv/awx/lib/python2.7/site-packages/django/db/models/sql/compiler.py”, line 899, in execute_sql
raise original_exception
ProgrammingError: column main_organization.job_template_admin_role_id does not exist
LINE 1: …“main_organization”.“notification_admin_role_id”, "main_orga…

`

7

Anthony,

Did you clear our your database too?

8

Please see the following link on how to migrate your data on upgrade. https://github.com/ansible/awx/blob/devel/DATA_MIGRATION.md

9

Can this be used for 1.0.7 as well?

10

Are you looking for feedback on this?

If so the following did not import

Schedules

The following imported but any encrypted components ended up being nonsense after the import:

Credentials