Awx: "relation "conf_setting" does not exist at character 158" & "relation "django_migrations" does not exist at character 124" errors in postgres container

Created on 20 Mar 2018 · 6Comments · Source: ansible/awx

ISSUE TYPE

Bug Report

COMPONENT NAME

awx_web

SUMMARY

Browsing to the localhost URL yields the "This site can’t be reached" error.
I see Starting server at tcp:port=8051:interface=127.0.0.1, channel layer awx.asgi:channel_layer. in dockercompose_web_1 logs, yet the container redirects 0.0.0.0:80->8052/tcp. This may explain the issue. Or maybe I'm missing something.

ENVIRONMENT

AWX version: tag 1.0.4
AWX install method: docker/docker-compose on linux
Ansible version: v2.4.3.0-1
Operating System: Ubuntu 17.10
Web Browser: chrome 65.0.3325.162
docker-ce 18.02.0~ce-0~ubuntu (from official docker PPA)
docker==3.1.3
docker-compose==1.20.0
requests==2.18.1
Django==1.11.10

STEPS TO REPRODUCE

# echo ---------------------------
# echo Starting all AWX containers
# echo ---------------------------
# cd <docker-compose.yml folder>
# docker-compose start
Starting memcached ... done
Starting postgres  ... done
Starting rabbitmq  ... done
Starting web       ... done
Starting task      ... done

# docker ps
CONTAINER ID        IMAGE                     COMMAND                  CREATED             STATUS              PORTS                                NAMES
d54f70bc9382        ansible/awx_task:latest   "/tini -- /bin/sh -c…"   15 minutes ago      Up 15 minutes       8052/tcp                             dockercompose_task_1
4474f311762e        ansible/awx_web:latest    "/tini -- /bin/sh -c…"   15 minutes ago      Up 15 minutes       0.0.0.0:80->8052/tcp                 dockercompose_web_1
58ec082ced51        rabbitmq:3                "docker-entrypoint.s…"   15 minutes ago      Up 15 minutes       4369/tcp, 5671-5672/tcp, 25672/tcp   dockercompose_rabbitmq_1
a67dadbea52a        postgres:9.6              "docker-entrypoint.s…"   15 minutes ago      Up 15 minutes       5432/tcp                             dockercompose_postgres_1
5ce8b8f76985        memcached:alpine          "docker-entrypoint.s…"   15 minutes ago      Up 15 minutes       11211/tcp                            dockercompose_memcached_1

dockercompose_task_1.logs
dockercompose_web_1.logs

Access http://localhost with chrome

EXPECTED RESULTS

ACTUAL RESULTS

This site can’t be reached

bug

Source

jean-christophe-manciot

Most helpful comment

Getting the same ERROR with new ansible version as well..

ERROR: relation "django_migrations" does not exist at character 124
STATEMENT: SELECT "django_migrations"."id", "django_migrations"."app", "django_migrations"."name", "django_migrations"."applied" FROM "django_migrations" WHERE ("django_migrations"."app" = 'main' AND NOT ("django_migrations"."name"::text LIKE '%squashed%')) ORDER BY "django_migrations"."id" DESC LIMIT 1

anyone there to help ?

chandrukvr on 22 Oct 2019

👍2

All 6 comments

upgrading to stable 18.03.0~ce-0~ubuntu leads to some similar logs for the web container:

# docker logs -f dockercompose_web_1
Traceback (most recent call last):
  File "/usr/bin/awx-manage", line 9, in <module>
...
django.db.utils.OperationalError: could not connect to server: Connection refused
    Is the server running on host "postgres" (172.23.0.4) and accepting
    TCP/IP connections on port 5432?

Checking that the postgres container lives at the expected IP address and port:

# docker ps 
CONTAINER ID        IMAGE                     COMMAND                  CREATED             STATUS              PORTS                                NAMES
3aec2f95c206        ansible/awx_task:latest   "/tini -- /bin/sh -c…"   25 minutes ago      Up 25 minutes       8052/tcp                             dockercompose_task_1
169df4ff8898        ansible/awx_web:latest    "/tini -- /bin/sh -c…"   25 minutes ago      Up 25 minutes       0.0.0.0:80->8052/tcp                 dockercompose_web_1
237f8d0e4551        postgres:9.6              "docker-entrypoint.s…"   25 minutes ago      Up 25 minutes       5432/tcp                             dockercompose_postgres_1
a8395ce35ad7        rabbitmq:3                "docker-entrypoint.s…"   25 minutes ago      Up 25 minutes       4369/tcp, 5671-5672/tcp, 25672/tcp   dockercompose_rabbitmq_1
a4e6e3b46011        memcached:alpine          "docker-entrypoint.s…"   25 minutes ago      Up 25 minutes       11211/tcp                            dockercompose_memcached_1

# docker inspect dockercompose_postgres_1 | grep "\"IPAddress\": "
"IPAddress": "172.23.0.4"
docker inspect dockercompose_postgres_1 | grep -C 1 "\"Ports\": "
"Ports": {
                "5432/tcp": null

and the logs for postgres container show:

# docker logs -f dockercompose_postgres_1
...
LOG:  received fast shutdown request
LOG:  aborting any active transactions
waiting for server to shut down....LOG:  autovacuum launcher shutting down
LOG:  shutting down
LOG:  database system is shut down
 done
server stopped

PostgreSQL init process complete; ready for start up.

LOG:  database system was shut down at 2018-03-22 15:43:15 UTC
LOG:  MultiXact member wraparound protections are now enabled
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started
LOG:  incomplete startup packet
ERROR:  relation "conf_setting" does not exist at character 158
...
ERROR:  relation "django_migrations" does not exist at character 124
...
...

It seems that awx web container cannot connect to postgres container because of the errors relation "conf_setting" does not exist at character 158 & relation "django_migrations" does not exist at character 124.

Other logs:

jean-christophe-manciot on 22 Mar 2018

👍2

Seeing the same issue on v1.5.0.