awx inplace upgrade to v15 using local docker ... Data migration not happening

[rajivkamath]

Inplace upgrade of AWX from 13.x to latest 15.x keeps doing a fresh install and does not retain the data/configs that were present on the existing instance prior to upgrade.

ISSUE TYPE

• Bug Report

SUMMARY

Used the official github instructions to do an inplace upgrade using docker-compose and below is a summary of what was done for the upgrade

• Downloaded the latest awx artifacts from github ( version 15 )

• comment out the dockerhub_base=ansible in the inventory file.

• created a vars file in the installer dir with the key/value pairs that were used for the awx13.x installation. Content of var file below...
  project_data_dir: /opt/awx/projects
  docker_compose_dir: "/opt/awx/awxcompose"
  postgres_data_dir: "/opt/awx/pgdocker"
  awx_alternate_dns_servers: "xxxxxxx,xxxxxxx"
  ssl_certificate: /opt/awx/ssl/xxxxxxx.cer
  ssl_certificate_key: /opt/awx/ssl/xxxxxxx.key
  ca_trust_dir: /opt/awx/ssl/ca
  admin_password: 'xxxxxxxxx'
  pg_password: 'xxxxxxxxxxx'
  secret_key: 'xxxxxx'

• added env variable "PGDATA: /var/lib/postgresql/data/pgdata" to the xxx/installer/roles/local_docker/templates/docker-compose.yml.j2 file as its missing there.

• executed 'ansible-playbook -i inventory install.yml -e @vars.yaml'

ENVIRONMENT

AWX version: 13.x
AWX install method: docker on linux localhost ( dockercompose )
Ansible version: 2.9.13
Operating System: RHEL8
Web Browser: chrome

STEPS TO REPRODUCE

download latest awx artificates from github
create a vars.yaml file populated with the variables/configs used in the existing instance of awx.
execute 'ansible-playbook -i inventory -e @vars.yaml'
login to awx console after install completes and awx_task completes postinstall migrations

EXPECTED RESULTS

Configs and objects that prexisted on AWX need to visible from the console and they are wiped out.

ACTUAL RESULTS

All existing data is deleted and its a fresh install rather than an upgrade.

ADDITIONAL INFORMATION

The awx_task container is supposed to run a task to migrate data from old postgres to new instance but i dont see it in the logs.

partial snippet of the awx_task logs...

Applying sites.0001_initial... OK
Applying sites.0002_alter_domain_unique... OK
Applying social_django.0001_initial... OK
Applying social_django.0002_add_related_name... OK
Applying social_django.0003_alter_email_max_length... OK
Applying social_django.0004_auto_20160423_0400... OK
Applying social_django.0005_auto_20160727_2333... OK
Applying social_django.0006_partial... OK
Applying social_django.0007_code_timestamp... OK
Applying social_django.0008_partial_timestamp... OK
Applying sso.0001_initial... OK
Applying sso.0002_expand_provider_options... OK
Applying taggit.0003_taggeditem_add_unique_index... OK
Successfully registered instance awx
(changed: True)
Creating instance group tower
(changed: True)
Default organization added.
Demo Credential, Inventory, and Job Template added.
(changed: True)
2020-10-20 16:17:11,658 CRIT Supervisor is running as root. Privileges were not dropped because no user is specified in the config file. If you intend to run as root, you can set user=root in the config file to avoid this message.
2020-10-20 16:17:11,658 CRIT Supervisor is running as root. Privileges were not dropped because no user is specified in the config file. If you intend to run as root, you can set user=root in the config file to avoid this message.
2020-10-20 16:17:11,963 INFO RPC interface 'supervisor' initialized
2020-10-20 16:17:11,963 INFO RPC interface 'supervisor' initialized
2020-10-20 16:17:11,963 CRIT Server 'unix_http_server' running without any HTTP authentication checking
2020-10-20 16:17:11,963 CRIT Server 'unix_http_server' running without any HTTP authentication checking
2020-10-20 16:17:11,963 INFO supervisord started with pid 103
2020-10-20 16:17:11,963 INFO supervisord started with pid 103
2020-10-20 16:17:12,965 INFO spawned: 'awx-config-watcher' with pid 106
2020-10-20 16:17:12,965 INFO spawned: 'awx-config-watcher' with pid 106
2020-10-20 16:17:12,968 INFO spawned: 'dispatcher' with pid 107
2020-10-20 16:17:12,968 INFO spawned: 'dispatcher' with pid 107
2020-10-20 16:17:12,970 INFO spawned: 'callback-receiver' with pid 108
2020-10-20 16:17:12,970 INFO spawned: 'callback-receiver' with pid 108

[jeremywinder]

I am having the same issue, data/configs wiped, when re-running the 'ansible-playbook -i inventory install.yml -e @vars.yaml' against an existing 15.0.1 install.

[govbetrieb]

Same Problem here

[nifr]

The same happened to me recently with an awx version 16.0.0 docker-compose installation.

The whole database with all users, configuration etc. was wiped.