# AWX is Upgrading http://localhost/migrations\_notran/#/login http://localhost/migrations\_notran/#/index.html psycopg2.errors.UndefinedTable: relation "main\_instance" does not exist

**URL:** <https://forum.ansible.com/t/awx-is-upgrading-http-localhost-migrations-notran-login-http-localhost-migrations-notran-index-html-psycopg2-errors-undefinedtable-relation-main-instance-does-not-exist/34072>\
**Category:** AWX Project\
**Tags:** awx, aws\
**Created:** [October 21, 2020, 12:50pm UTC](https://forum.ansible.com/t/awx-is-upgrading-http-localhost-migrations-notran-login-http-localhost-migrations-notran-index-html-psycopg2-errors-undefinedtable-relation-main-instance-does-not-exist/34072 "2020-10-21T12:50:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vasiliy\_Danilov](https://avatars.discourse-cdn.com/v4/letter/v/ea5d25/32.png) [@Vasiliy\_Danilov](https://forum.ansible.com/u/Vasiliy_Danilov)\
**Post date:** [October 21, 2020, 12:50pm UTC](https://forum.ansible.com/t/awx-is-upgrading-http-localhost-migrations-notran-login-http-localhost-migrations-notran-index-html-psycopg2-errors-undefinedtable-relation-main-instance-does-not-exist/34072/1 "2020-10-21T12:50:24Z")

</div>

Can’t install AWS 15.0.1 on Win10 WSL2 Docker Desktop  
infinite updating

Between

[http://localhost/migrations\_notran/#/login](http://localhost/migrations_notran/#/login)  
and  
[http://localhost/migrations\_notran/#/index.html](http://localhost/migrations_notran/#/index.html)

With  
AWX is Upgrading

AWX is currently upgrading.

This page will refresh when complete.

docker --version  
Docker version 19.03.13, build 4484c46d9d

# ansible --version

ansible 2.10.2  
config file = None  
configured module search path = [‘/root/.ansible/plugins/modules’, ‘/usr/share/ansible/plugins/modules’]  
ansible python module location = /usr/local/lib/python3.6/site-packages/ansible  
executable location = /usr/local/bin/ansible  
python version = 3.6.8 (default, Nov 21 2019, 19:31:34) [GCC 8.3.1 20190507 (Red Hat 8.3.1-4)]

docker logs -f awx\_task

2020-10-21 12:24:41,463 INFO exited: dispatcher (exit status 1; not expected)  
2020-10-21 12:24:41,463 INFO exited: dispatcher (exit status 1; not expected)  
2020-10-21 12:24:42,467 INFO spawned: ‘dispatcher’ with pid 4313  
2020-10-21 12:24:42,467 INFO spawned: ‘dispatcher’ with pid 4313  
2020-10-21 12:24:43,469 INFO success: dispatcher entered RUNNING state, process has stayed up for \> than 1 seconds (startsecs)  
2020-10-21 12:24:43,469 INFO success: dispatcher entered RUNNING state, process has stayed up for \> than 1 seconds (startsecs)  
2020-10-21 12:24:45,132 WARNING awx.main.dispatch.periodic periodic beat started  
Traceback (most recent call last):  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/backends/utils.py”, line 84, in \_execute  
return self.cursor.execute(sql, params)  
psycopg2.errors.UndefinedTable: relation “main\_instance” does not exist  
LINE 1: SELECT (1) AS “a” FROM “main\_instance” WHERE “main\_instance”…  
^

The above exception was the direct cause of the following exception:

Traceback (most recent call last):  
File “/usr/bin/awx-manage”, line 8, in   
sys.exit(manage())  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/awx/ **init**.py”, line 154, in manage  
execute\_from\_command\_line(sys.argv)  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/core/management/ **init**.py”, line 381, in execute\_from\_command\_line  
utility.execute()  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/core/management/ **init**.py”, line 375, in execute  
self.fetch\_command(subcommand).run\_from\_argv(self.argv)  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/core/management/base.py”, line 323, in run\_from\_argv  
self.execute(\*args, \*\*cmd\_options)  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/core/management/base.py”, line 364, in execute  
output = self.handle(\*args, \*\*options)  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/awx/main/management/commands/run\_dispatcher.py”, line 55, in handle  
reaper.reap()  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/awx/main/dispatch/reaper.py”, line 38, in reap  
(changed, me) = Instance.objects.get\_or\_register()  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/awx/main/managers.py”, line 150, in get\_or\_register  
return (False, [self.me](http://self.me)())  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/awx/main/managers.py”, line 106, in me  
if node.exists():  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/models/query.py”, line 766, in exists  
return self.query.has\_results(using=self.db)  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/models/sql/query.py”, line 522, in has\_results  
return compiler.has\_results()  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/models/sql/compiler.py”, line 1112, in has\_results  
return bool(self.execute\_sql(SINGLE))  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/models/sql/compiler.py”, line 1142, in execute\_sql  
cursor.execute(sql, params)  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/backends/utils.py”, line 67, in execute  
return self.\_execute\_with\_wrappers(sql, params, many=False, executor=self.\_execute)  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/backends/utils.py”, line 76, in \_execute\_with\_wrappers  
return executor(sql, params, many, context)  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/backends/utils.py”, line 84, in \_execute  
return self.cursor.execute(sql, params)  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/utils.py”, line 89, in **exit**  
raise dj\_exc\_value.with\_traceback(traceback) from exc\_value  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/backends/utils.py”, line 84, in \_execute  
return self.cursor.execute(sql, params)  
django.db.utils.ProgrammingError: relation “main\_instance” does not exist  
LINE 1: SELECT (1) AS “a” FROM “main\_instance” WHERE “main\_instance”…  
^

2020-10-21 12:24:45,577 INFO exited: dispatcher (exit status 1; not expected)  
2020-10-21 12:24:45,577 INFO exited: dispatcher (exit status 1; not expected)  
2020-10-21 12:24:46,581 INFO spawned: ‘dispatcher’ with pid 4320  
2020-10-21 12:24:46,581 INFO spawned: ‘dispatcher’ with pid 4320  
2020-10-21 12:24:47,583 INFO success: dispatcher entered RUNNING state, process has stayed up for \> than 1 seconds (startsecs)  
2020-10-21 12:24:47,583 INFO success: dispatcher entered RUNNING state, process has stayed up for \> than 1 seconds (startsecs)  
2020-10-21 12:24:49,073 WARNING awx.main.dispatch.periodic periodic beat started  
Traceback (most recent call last):  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/backends/utils.py”, line 84, in \_execute  
return self.cursor.execute(sql, params)  
psycopg2.errors.UndefinedTable: relation “main\_instance” does not exist  
LINE 1: SELECT (1) AS “a” FROM “main\_instance” WHERE “main\_instance”…  
^

The above exception was the direct cause of the following exception:

Traceback (most recent call last):  
File “/usr/bin/awx-manage”, line 8, in   
sys.exit(manage())  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/awx/ **init**.py”, line 154, in manage  
execute\_from\_command\_line(sys.argv)  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/core/management/ **init**.py”, line 381, in execute\_from\_command\_line  
utility.execute()  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/core/management/ **init**.py”, line 375, in execute  
self.fetch\_command(subcommand).run\_from\_argv(self.argv)  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/core/management/base.py”, line 323, in run\_from\_argv  
self.execute(\*args, \*\*cmd\_options)  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/core/management/base.py”, line 364, in execute  
output = self.handle(\*args, \*\*options)  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/awx/main/management/commands/run\_dispatcher.py”, line 55, in handle  
reaper.reap()  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/awx/main/dispatch/reaper.py”, line 38, in reap  
(changed, me) = Instance.objects.get\_or\_register()  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/awx/main/managers.py”, line 150, in get\_or\_register  
return (False, [self.me](http://self.me)())  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/awx/main/managers.py”, line 106, in me  
if node.exists():  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/models/query.py”, line 766, in exists  
return self.query.has\_results(using=self.db)  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/models/sql/query.py”, line 522, in has\_results  
return compiler.has\_results()  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/models/sql/compiler.py”, line 1112, in has\_results  
return bool(self.execute\_sql(SINGLE))  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/models/sql/compiler.py”, line 1142, in execute\_sql  
cursor.execute(sql, params)  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/backends/utils.py”, line 67, in execute  
return self.\_execute\_with\_wrappers(sql, params, many=False, executor=self.\_execute)  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/backends/utils.py”, line 76, in \_execute\_with\_wrappers  
return executor(sql, params, many, context)  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/backends/utils.py”, line 84, in \_execute  
return self.cursor.execute(sql, params)  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/utils.py”, line 89, in **exit**  
raise dj\_exc\_value.with\_traceback(traceback) from exc\_value  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/backends/utils.py”, line 84, in \_execute  
return self.cursor.execute(sql, params)  
django.db.utils.ProgrammingError: relation “main\_instance” does not exist  
LINE 1: SELECT (1) AS “a” FROM “main\_instance” WHERE “main\_instance”…  
^

2020-10-21 12:24:49,473 INFO exited: dispatcher (exit status 1; not expected)  
2020-10-21 12:24:49,473 INFO exited: dispatcher (exit status 1; not expected)  
2020-10-21 12:24:50,476 INFO spawned: ‘dispatcher’ with pid 4327  
2020-10-21 12:24:50,476 INFO spawned: ‘dispatcher’ with pid 4327  
2020-10-21 12:24:51,478 INFO success: dispatcher entered RUNNING state, process has stayed up for \> than 1 seconds (startsecs)  
2020-10-21 12:24:51,478 INFO success: dispatcher entered RUNNING state, process has stayed up for \> than 1 seconds (startsecs)  
2020-10-21 12:24:52,791 WARNING awx.main.dispatch.periodic periodic beat started  
Traceback (most recent call last):  
File “/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/backends/utils.py”, line 84, in \_execute  
return self.cursor.execute(sql, params)  
psycopg2.errors.UndefinedTable: relation “main\_instance” does not exist  
LINE 1: SELECT (1) AS “a” FROM “main\_instance” WHERE “main\_instance”…

^

> **(attachments)**
>
> ![AWX is Upgrading localhost __migrations_notran___ login http ___localhost__ migrations_notran__index.html.png](https://us1.discourse-cdn.com/ansible/original/2X/0/0b7a3d5d949a27084cfacf6f0666446d8fbb340e.png)  
> ![AWX is Upgrading localhost __migrations_notran___ login http ___localhost__ migrations_notran__index.gif](https://us1.discourse-cdn.com/ansible/original/2X/9/98e551c91c64fd60c28437f178065c0431eb4791.gif)

---

<div class="post-metadata">

**Author:** ![Denson\_George](https://avatars.discourse-cdn.com/v4/letter/d/9de0a6/32.png) [@Denson\_George](https://forum.ansible.com/u/Denson_George)\
**Post date:** [May 28, 2021, 9:29am UTC](https://forum.ansible.com/t/awx-is-upgrading-http-localhost-migrations-notran-login-http-localhost-migrations-notran-index-html-psycopg2-errors-undefinedtable-relation-main-instance-does-not-exist/34072/2 "2021-05-28T09:29:46Z")

</div>

Hi, Any luck with this? I am getting the same error with external Postgres ??