# Migrations error moving from awx 19.0.1  to 21.0.0

**URL:** <https://forum.ansible.com/t/migrations-error-moving-from-awx-19-0-1-to-21-0-0/36577>\
**Category:** Ansible Project\
**Tags:** awx\
**Created:** [April 29, 2022, 3:04pm UTC](https://forum.ansible.com/t/migrations-error-moving-from-awx-19-0-1-to-21-0-0/36577 "2022-04-29T15:04:23Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Buyongo\_Phiri](https://avatars.discourse-cdn.com/v4/letter/b/b9e5f3/32.png) [@Buyongo\_Phiri](https://forum.ansible.com/u/Buyongo_Phiri)\
**Post date:** [April 29, 2022, 3:04pm UTC](https://forum.ansible.com/t/migrations-error-moving-from-awx-19-0-1-to-21-0-0/36577/1 "2022-04-29T15:04:23Z")

</div>

Hello,  
Migrations seem to fail on this one, looks like the db changed. Is there a way to fix it?

(awx) bash-5.1$ awx-manage migrate  
Operations to perform:  
Apply all migrations: auth, conf, contenttypes, main, oauth2\_provider, sessions, sites, social\_django, sso, taggit  
Running migrations:  
Applying main.0156\_capture\_mesh\_topology…Traceback (most recent call last):  
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/db/backends/utils.py”, line 84, in \_execute  
return self.cursor.execute(sql, params)  
psycopg2.errors.InvalidForeignKey: there is no unique constraint matching given keys for referenced table “main\_instance”

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

Traceback (most recent call last):  
File “/var/lib/awx/venv/awx/bin/awx-manage”, line 8, in   
sys.exit(manage())  
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/awx/ **init**.py”, line 170, in manage  
execute\_from\_command\_line(sys.argv)  
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/core/management/ **init**.py”, line 419, in execute\_from\_command\_line  
utility.execute()  
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/core/management/ **init**.py”, line 413, in execute  
self.fetch\_command(subcommand).run\_from\_argv(self.argv)  
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/core/management/base.py”, line 354, in run\_from\_argv  
self.execute(\*args, \*\*cmd\_options)  
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/core/management/base.py”, line 398, in execute  
output = self.handle(\*args, \*\*options)  
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/core/management/base.py”, line 89, in wrapped  
res = handle\_func(\*args, \*\*kwargs)  
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/core/management/commands/migrate.py”, line 244, in handle  
post\_migrate\_state = executor.migrate(  
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/db/migrations/executor.py”, line 117, in migrate  
state = self.\_migrate\_all\_forwards(state, plan, full\_plan, fake=fake, fake\_initial=fake\_initial)  
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/db/migrations/executor.py”, line 147, in \_migrate\_all\_forwards  
state = self.apply\_migration(state, migration, fake=fake, fake\_initial=fake\_initial)  
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/db/migrations/executor.py”, line 230, in apply\_migration  
migration\_recorded = True  
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/db/backends/base/schema.py”, line 118, in **exit**  
self.execute(sql)  
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/db/backends/base/schema.py”, line 145, in execute  
cursor.execute(sql, params)  
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/db/backends/utils.py”, line 66, in execute  
return self.\_execute\_with\_wrappers(sql, params, many=False, executor=self.\_execute)  
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/db/backends/utils.py”, line 75, in \_execute\_with\_wrappers  
return executor(sql, params, many, context)  
File “/var/lib/awx/venv/awx/lib64/python3.9/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.9/site-packages/django/db/utils.py”, line 90, in **exit**  
raise dj\_exc\_value.with\_traceback(traceback) from exc\_value  
File “/var/lib/awx/venv/awx/lib64/python3.9/site-packages/django/db/backends/utils.py”, line 84, in \_execute  
return self.cursor.execute(sql, params)  
django.db.utils.ProgrammingError: there is no unique constraint matching given keys for referenced table “main\_instance”