gaia
commented
3 years ago same here while attempting an upgrade. also failed for a new install in the same way, even though I pruned all docker CTs, removed awx/, then cloned again:
Open lcarangelo opened 3 years ago
gaia
commented
3 years ago same here while attempting an upgrade. also failed for a new install in the same way, even though I pruned all docker CTs, removed awx/, then cloned again:
ISSUE TYPE
COMPONENT NAME
SUMMARY
During the installation via : ansible-playbook -i inventory install.yml , it fails during Postgres upgrade (from 10 to 12)
ENVIRONMENT
AWX version: from AWX 12 to latest
AWX install method: , docker on linux,
Ansible version: ansible 2.9.3 config file = /etc/ansible/ansible.cfg configured module search path = [u'/root/.ansible/plugins/modules', u'/usr/share/ansible/plugins/modules'] ansible python module location = /usr/lib/python2.7/site-packages/ansible executable location = /usr/bin/ansible python version = 2.7.5 (default, Aug 7 2019, 00:51:29) [GCC 4.8.5 20150623 (Red Hat 4.8.5-39)]
Operating System: CentOS Linux release 7.7.1908 (Core)
Web Browser: Chrome
STEPS TO REPRODUCE
Standard upgrade from 12 to 17 as described in the installation guide
ACTUAL RESULTS
TASK [local_docker : Upgrade Postgres] **** fatal: [localhost]: FAILED! => {"changed": true, "cmd": "docker run --rm -v /data/postgres/data/10/data:/var/lib/postgresql/10/data -v /data/postgres/data/12/data:/var/lib/postgresql/12/data -e PGUSER=awx -e POSTGRES_INITDB_ARGS=\"-U awx\" tianon/postgres-upgrade:10-to-12 --username=awx\n", "delta": "0:00:03.540644", "end": "2021-01-22 21:01:58.824661", "msg": "non-zero return code", "rc": 1, "start": "2021-01-22 21:01:55.284017", "stderr": "", "stderr_lines": [], "stdout": "Performing Consistency Checks\n -----------------------------\n Checking cluster versions ok\n Checking database user is the install user ok\n Checking database connection settings ok\n Checking for prepared transactions ok\n Checking for reg data types in user tables ok\n Checking for contrib/isn with bigint-passing mismatch ok\n Checking for tables WITH OIDS ok\n Checking for invalid \"sql_identifier\" user columns ok\n Creating dump of global objects ok\n Creating dump of database schemas\n
awx\n
postgres\n
template1\n
ok\n\n New cluster database \"awx\" is not empty: found relation \"public.django_migrations\"\n Failure, exiting", "stdout_lines": ["Performing Consistency Checks", "-----------------------------", "Checking cluster versions ok", "Checking database user is the install user ok", "Checking database connection settings ok", "Checking for prepared transactions ok", "Checking for reg data types in user tables ok", "Checking for contrib/isn with bigint-passing mismatch ok", "Checking for tables WITH OIDS ok", "Checking for invalid \"sql_identifier\" user columns ok", "Creating dump of global objects ok", "Creating dump of database schemas", " awx", " postgres", " template1", " ok", "", "New cluster database \"awx\" is not empty: found relation \"public.django_migrations\"", "Failure, exiting"]}
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 3faede61c2e5 awx:12.0.0 "tini -- /usr/bin/la…" 10 seconds ago Exited (143) 9 seconds ago awx_task 6e3cc6a9c0ac awx:12.0.0 "tini -- /bin/sh -c …" 10 seconds ago Exited (143) 8 seconds ago awx_web 16a2ee248664 postgres:10 "docker-entrypoint.s…" 11 seconds ago Exited (0) 8 seconds ago awx_postgres bb2c3a19f279 redis "docker-entrypoint.s…" 9 minutes ago Exited (0) 8 seconds ago awx_redis