# Upgrading from 1.5.0.24 to 1.0.6

**URL:** <https://forum.ansible.com/t/upgrading-from-1-5-0-24-to-1-0-6/28326>\
**Category:** AWX Project\
**Tags:** awx\
**Created:** [August 14, 2018, 8:06am UTC](https://forum.ansible.com/t/upgrading-from-1-5-0-24-to-1-0-6/28326 "2018-08-14T08:06:36Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![anthony.cleaves](https://avatars.discourse-cdn.com/v4/letter/a/4af34b/32.png) [@anthony.cleaves](https://forum.ansible.com/u/anthony.cleaves)\
**Post date:** [August 14, 2018, 8:06am UTC](https://forum.ansible.com/t/upgrading-from-1-5-0-24-to-1-0-6/28326/1 "2018-08-14T08:06:36Z")

</div>

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](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`

---

<div class="post-metadata">

**Author:** ![anthony.cleaves](https://avatars.discourse-cdn.com/v4/letter/a/4af34b/32.png) [@anthony.cleaves](https://forum.ansible.com/u/anthony.cleaves)\
**Post date:** [August 14, 2018, 8:10am UTC](https://forum.ansible.com/t/upgrading-from-1-5-0-24-to-1-0-6/28326/2 "2018-08-14T08:10:05Z")

</div>

By failed, It stays on version:

```auto
< AWX 1.0.5.24 >

```

---

<div class="post-metadata">

**Author:** ![anthony.cleaves](https://avatars.discourse-cdn.com/v4/letter/a/4af34b/32.png) [@anthony.cleaves](https://forum.ansible.com/u/anthony.cleaves)\
**Post date:** [August 14, 2018, 8:16am UTC](https://forum.ansible.com/t/upgrading-from-1-5-0-24-to-1-0-6/28326/3 "2018-08-14T08:16:11Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![anthony.cleaves](https://avatars.discourse-cdn.com/v4/letter/a/4af34b/32.png) [@anthony.cleaves](https://forum.ansible.com/u/anthony.cleaves)\
**Post date:** [August 14, 2018, 8:17am UTC](https://forum.ansible.com/t/upgrading-from-1-5-0-24-to-1-0-6/28326/4 "2018-08-14T08:17:32Z")

</div>

This has made no difference.

---

<div class="post-metadata">

**Author:** ![anthony.cleaves](https://avatars.discourse-cdn.com/v4/letter/a/4af34b/32.png) [@anthony.cleaves](https://forum.ansible.com/u/anthony.cleaves)\
**Post date:** [August 14, 2018, 8:25am UTC](https://forum.ansible.com/t/upgrading-from-1-5-0-24-to-1-0-6/28326/5 "2018-08-14T08:25:47Z")

</div>

> > > > 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.

---

<div class="post-metadata">

**Author:** ![anthony.cleaves](https://avatars.discourse-cdn.com/v4/letter/a/4af34b/32.png) [@anthony.cleaves](https://forum.ansible.com/u/anthony.cleaves)\
**Post date:** [August 14, 2018, 8:43am UTC](https://forum.ansible.com/t/upgrading-from-1-5-0-24-to-1-0-6/28326/6 "2018-08-14T08:43:02Z")

</div>

All I see in my logs are errors ☹

`

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…

`

---

<div class="post-metadata">

**Author:** ![Christopher\_Meyers](https://avatars.discourse-cdn.com/v4/letter/c/3e96dc/32.png) [@Christopher\_Meyers](https://forum.ansible.com/u/Christopher_Meyers)\
**Post date:** [August 14, 2018, 3:55pm UTC](https://forum.ansible.com/t/upgrading-from-1-5-0-24-to-1-0-6/28326/7 "2018-08-14T15:55:32Z")

</div>

Anthony,

Did you clear our your database too?

---

<div class="post-metadata">

**Author:** ![Christopher\_Meyers](https://avatars.discourse-cdn.com/v4/letter/c/3e96dc/32.png) [@Christopher\_Meyers](https://forum.ansible.com/u/Christopher_Meyers)\
**Post date:** [August 14, 2018, 4:55pm UTC](https://forum.ansible.com/t/upgrading-from-1-5-0-24-to-1-0-6/28326/8 "2018-08-14T16:55:35Z")

</div>

Please see the following link on how to migrate your data on upgrade. [https://github.com/ansible/awx/blob/devel/DATA\_MIGRATION.md](https://github.com/ansible/awx/blob/devel/DATA_MIGRATION.md)

---

<div class="post-metadata">

**Author:** ![Anthony\_Cleaves](https://avatars.discourse-cdn.com/v4/letter/a/87869e/32.png) [@Anthony\_Cleaves](https://forum.ansible.com/u/Anthony_Cleaves)\
**Post date:** [August 15, 2018, 1:38pm UTC](https://forum.ansible.com/t/upgrading-from-1-5-0-24-to-1-0-6/28326/9 "2018-08-15T13:38:28Z")

</div>

Can this be used for 1.0.7 as well?

---

<div class="post-metadata">

**Author:** ![Anthony\_Cleaves](https://avatars.discourse-cdn.com/v4/letter/a/87869e/32.png) [@Anthony\_Cleaves](https://forum.ansible.com/u/Anthony_Cleaves)\
**Post date:** [August 16, 2018, 4:02pm UTC](https://forum.ansible.com/t/upgrading-from-1-5-0-24-to-1-0-6/28326/10 "2018-08-16T16:02:37Z")

</div>

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