# AAP 2.4 to AAP 2.5 upgrade error: Migrate the gateway database schema

**URL:** <https://forum.ansible.com/t/aap-2-4-to-aap-2-5-upgrade-error-migrate-the-gateway-database-schema/39642>\
**Category:** Get Help\
**Tags:** aap, awx\
**Created:** [January 16, 2025, 11:07am UTC](https://forum.ansible.com/t/aap-2-4-to-aap-2-5-upgrade-error-migrate-the-gateway-database-schema/39642 "2025-01-16T11:07:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Daveops](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/daveops/32/7227_2.png) [@Daveops](https://forum.ansible.com/u/Daveops)\
**Post date:** [January 16, 2025, 11:07am UTC](https://forum.ansible.com/t/aap-2-4-to-aap-2-5-upgrade-error-migrate-the-gateway-database-schema/39642/1 "2025-01-16T11:07:48Z")

</div>

Getting the following error when upgrading aap 2.4 to aap 2.5

TASK [ansible.automation\_platform\_installer.automationgateway : Migrate the gateway database schema] \*\*\*  
fatal: [10.204.16.18]: FAILED! =\> {“changed”: true, “cmd”: “aap-gateway-manage migrate”, “delta”: “0:00:01.093896”, “end”: “2025-01-16 11:39:29.686047”, “msg”: “non-zero return code”, “rc”: 1, “start”: “2025-01-16 11:39:28.592151”, “stderr”: “Traceback (most recent call last):\n File "/bin/aap-gateway-manage", line 8, in \n sys.exit(manage())\n ^^^^^^^^\n File "/usr/lib/python3.11/site-packages/aap\_gateway\_api/ **init**.py", line 22, in manage\n execute\_from\_command\_line(sys.argv)\n File "/usr/lib/python3.11/site-packages/django/core/management/ **init**.py", line 442, in execute\_from\_command\_line\n utility.execute()\n File "/usr/lib/python3.11/site-packages/django/core/management/ **init**.py", line 416, in execute\n django.setup()\n File "/usr/lib/python3.11/site-packages/django/ **init**.py", line 24, in setup\n apps.populate(settings.INSTALLED\_APPS)\n File "/usr/lib/python3.11/site-packages/django/apps/registry.py", line 124, in populate\n app\_config.ready()\n File "/usr/lib/python3.11/site-packages/aap\_gateway\_api/apps.py", line 42, in ready\n import aap\_gateway\_api.signals # noqa 401\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/lib/python3.11/site-packages/aap\_gateway\_api/signals/ **init**.py", line 1, in \n from aap\_gateway\_api.signals.user import user\_logged\_out # noqa: 401\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/lib/python3.11/site-packages/aap\_gateway\_api/signals/user.py", line 3, in \n from ansible\_base.lib.utils.requests import get\_remote\_host\n File "/usr/lib/python3.11/site-packages/ansible\_base/lib/utils/requests.py", line 7, in \n from ansible\_base.jwt\_consumer.common.util import validate\_x\_trusted\_proxy\_header\n File "/usr/lib/python3.11/site-packages/ansible\_base/jwt\_consumer/common/util.py", line 9, in \n from ansible\_base.jwt\_consumer.common.cert import JWTCert, JWTCertException\n File "/usr/lib/python3.11/site-packages/ansible\_base/jwt\_consumer/common/cert.py", line 7, in \n from ansible\_base.jwt\_consumer.common.cache import JWTCache\n File "/usr/lib/python3.11/site-packages/ansible\_base/jwt\_consumer/common/cache.py", line 14, in \n cache = caches[jwt\_cache\_name]\n ~~~~~~^^^^^^^^^^^^^^^^\n File "/usr/lib/python3.11/site-packages/django/utils/connection.py", line 62, in **getitem** \n conn = self.create\_connection(alias)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/lib/python3.11/site-packages/django/core/cache/ **init**.py", line 52, in create\_connection\n return backend\_cls(location, params)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/lib/python3.11/site-packages/ansible\_base/lib/cache/fallback\_cache.py", line 44, in **init** \n self.\_temp\_file.unlink()\n File "/usr/lib64/python3.11/pathlib.py", line 1147, in unlink\n os.unlink(self)\nPermissionError: [Errno 1] Operation not permitted: ‘/tmp/gw\_primary\_cache\_failed’”, “stderr\_lines”: [“Traceback (most recent call last):”, " File "/bin/aap-gateway-manage", line 8, in “, " sys.exit(manage())”, " ^^^^^^^^“, " File "/usr/lib/python3.11/site-packages/aap\_gateway\_api/ **init**.py", line 22, in manage”, " execute\_from\_command\_line(sys.argv)“, " File "/usr/lib/python3.11/site-packages/django/core/management/ **init**.py", line 442, in execute\_from\_command\_line”, " utility.execute()“, " File "/usr/lib/python3.11/site-packages/django/core/management/ **init**.py", line 416, in execute”, " django.setup()“, " File "/usr/lib/python3.11/site-packages/django/ **init**.py", line 24, in setup”, " apps.populate(settings.INSTALLED\_APPS)“, " File "/usr/lib/python3.11/site-packages/django/apps/registry.py", line 124, in populate”, " app\_config.ready()“, " File "/usr/lib/python3.11/site-packages/aap\_gateway\_api/apps.py", line 42, in ready”, " import aap\_gateway\_api.signals # noqa 401", " ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^“, " File "/usr/lib/python3.11/site-packages/aap\_gateway\_api/signals/ **init**.py", line 1, in ”, " from aap\_gateway\_api.signals.user import user\_logged\_out # noqa: 401", " ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^“, " File "/usr/lib/python3.11/site-packages/aap\_gateway\_api/signals/user.py", line 3, in ”, " from ansible\_base.lib.utils.requests import get\_remote\_host", " File "/usr/lib/python3.11/site-packages/ansible\_base/lib/utils/requests.py", line 7, in “, " from ansible\_base.jwt\_consumer.common.util import validate\_x\_trusted\_proxy\_header”, " File "/usr/lib/python3.11/site-packages/ansible\_base/jwt\_consumer/common/util.py", line 9, in “, " from ansible\_base.jwt\_consumer.common.cert import JWTCert, JWTCertException”, " File "/usr/lib/python3.11/site-packages/ansible\_base/jwt\_consumer/common/cert.py", line 7, in “, " from ansible\_base.jwt\_consumer.common.cache import JWTCache”, " File "/usr/lib/python3.11/site-packages/ansible\_base/jwt\_consumer/common/cache.py", line 14, in “, " cache = caches[jwt\_cache\_name]”, "~~~~~~^^^^^^^^^^^^^^^^“, " File "/usr/lib/python3.11/site-packages/django/utils/connection.py", line 62, in **getitem** ”, " conn = self.create\_connection(alias)“, " ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^”, " File "/usr/lib/python3.11/site-packages/django/core/cache/ **init**.py", line 52, in create\_connection", " return backend\_cls(location, params)“, " ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^”, " File "/usr/lib/python3.11/site-packages/ansible\_base/lib/cache/fallback\_cache.py", line 44, in **init**", " self.\_temp\_file.unlink()“, " File "/usr/lib64/python3.11/pathlib.py", line 1147, in unlink”, " os.unlink(self)", “PermissionError: [Errno 1] Operation not permitted: ‘/tmp/gw\_primary\_cache\_failed’”], “stdout”: “”, “stdout\_lines”: }

This is my inventory:

[automationgateway]  
10.204.16.18 ansible\_user=ec2-user ansible\_ssh\_private\_key\_file=~/.ssh/key.pem

[automationcontroller]  
10.204.16.11 ansible\_user=ec2-user ansible\_ssh\_private\_key\_file=~/.ssh/key.pem

[automationhub]  
10.204.16.16 ansible\_user=ec2-user ansible\_ssh\_private\_key\_file=~/.ssh/key.pem

[database]  
10.204.16.17 ansible\_user=ec2-user ansible\_ssh\_private\_key\_file=~/.ssh/key.pem

[all:vars]  
admin\_password=‘…’

# Postgresql

pg\_host=‘10.204.16.17’  
pg\_port=‘5432’  
pg\_database=‘awx’  
pg\_username=‘awx’  
pg\_password=‘…’  
pg\_sslmode=‘prefer’

# Redis

redis\_mode=standalone

# Common variables

registry\_url=‘[registry.redhat.io](http://registry.redhat.io)’  
registry\_username=‘’  
registry\_password=‘’

# AAP Automation Hub

automationhub\_admin\_password=‘…’

automationhub\_pg\_host=‘10.204.16.17’

automationhub\_pg\_port=‘5432’

automationhub\_pg\_database=‘awx’

automationhub\_pg\_username=‘awx’

automationhub\_pg\_password='…

automationhub\_pg\_sslmode=‘prefer’

# Automation Gateway configuration

automationgateway\_admin\_password=‘..’

automationgateway\_pg\_host=‘10.204.16.17’

automationgateway\_pg\_port=5432

automationgateway\_pg\_database=‘automationgateway’

automationgateway\_pg\_username=‘awx’

automationgateway\_pg\_password=‘…’

automationgateway\_pg\_sslmode=‘prefer’

automationgateway\_disable\_https=true

---

<div class="post-metadata">

**Author:** ![mahespth](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/mahespth/32/252_2.png) [@mahespth](https://forum.ansible.com/u/mahespth)\
**Post date:** [January 28, 2025, 8:54am UTC](https://forum.ansible.com/t/aap-2-4-to-aap-2-5-upgrade-error-migrate-the-gateway-database-schema/39642/2 "2025-01-28T08:54:08Z")

</div>

Hi Dave,

I had the same error due to the gateway database not being created its not the clearest of errors, there is an assumption that it already exists. Once created it was fine, if you search for the “Migrate the gateway” in the installer it should become obvious.

Regards