Hi,
I’m trying to upgrade from 9.0.0 > 11.2.0 using the given instructions, but when I do the UI throws this error
ERROR!
Failed to get dashboard: 500 A server error has occurred.
and docker logs -f awx_task shows this
2020-06-05 11:07:56,891 - ERROR - worker - Error processing message with consumer awx.main.consumers.ws_receive:
Traceback (most recent call last):
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/utils.py”, line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedTable: relation “main_channelgroup” does not exist
LINE 1: …oup".“group”, “main_channelgroup”.“channels” FROM "main_chan…
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/channels/worker.py”, line 119, in run
consumer(message, **kwargs)
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/channels/sessions.py”, line 78, in inner
return func(*args, **kwargs)
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/channels/auth.py”, line 42, in inner
return func(message, *args, **kwargs)
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/awx/main/consumers.py”, line 86, in ws_receive
Group(name).add(message.reply_channel)
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/channels/channel.py”, line 70, in add
self.channel_layer.group_add(self.name, channel)
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/asgi_amqp/core.py”, line 161, in group_add
g, created = self.model.objects.select_for_update().get_or_create(group=group)
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/query.py”, line 538, in get_or_create
return self.get(**kwargs), False
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/query.py”, line 402, in get
num = len(clone)
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/query.py”, line 256, in len
self._fetch_all()
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/query.py”, line 1242, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/query.py”, line 55, in iter
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/sql/compiler.py”, line 1100, in execute_sql
cursor.execute(sql, params)
File “/var/lib/awx/venv/awx/lib64/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/lib64/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/lib64/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/lib64/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/lib64/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_channelgroup” does not exist
LINE 1: …oup".“group”, “main_channelgroup”.“channels” FROM "main_chan…
Is there a remedy or workaround for this? Saw it as a known issue with rabbitmq and from 10 uses redis so not sure if it’s related.
Thanks