upgrade script failed on clean install of centos 9 stream - Database migrations failed

[fvandonk]

--->>> FYI: I have been able to recreate this error multiple times. <<<---

Clean "server" install of centos 9 stream. Everything installs without any issue until I run the upgrade script (notice the change from python3.8 in the install doc to 3.9 which is installed on my server) as a non-root user. But user is an "administrator":

sudo PYTHON=/usr/bin/python3.9 /opt/netbox/upgrade.sh

All the packages get installed without error, but then it goes wrong here:

Skipping local dependencies (local_requirements.txt not found) Applying database migrations (python3 netbox/manage.py migrate)... Traceback (most recent call last): File "/opt/netbox/venv/lib64/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) psycopg2.errors.UndefinedTable: relation "django_content_type" does not exist LINE 1: ..."."app_label", "django_content_type"."model" FROM "django_co... ^

---

Full output provided below

---

[admin@centos9stream-netbox netbox]$ sudo PYTHON=/usr/bin/python3.9 /opt/netbox/upgrade.sh
Using Python 3.9.16
Creating a new virtual environment at /opt/netbox/venv...
Updating pip (pip install --upgrade pip)...
Requirement already satisfied: pip in ./venv/lib/python3.9/site-packages (21.2.3)
Collecting pip
Downloading pip-23.1.2-py3-none-any.whl (2.1 MB)
|████████████████████████████████| 2.1 MB 3.2 MB/s
Installing collected packages: pip
Attempting uninstall: pip
Found existing installation: pip 21.2.3
Uninstalling pip-21.2.3:
Successfully uninstalled pip-21.2.3
Successfully installed pip-23.1.2
pip 23.1.2 from /opt/netbox/venv/lib64/python3.9/site-packages/pip (python 3.9)
Installing Python system packages (pip install wheel)...
Collecting wheel
Downloading wheel-0.40.0-py3-none-any.whl (64 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 64.5/64.5 kB 1.5 MB/s eta 0:00:00
Installing collected packages: wheel
Successfully installed wheel-0.40.0
Installing core dependencies (pip install -r requirements.txt)...
Collecting bleach==6.0.0 (from -r requirements.txt (line 1))
Downloading bleach-6.0.0-py3-none-any.whl (162 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 162.5/162.5 kB 3.1 MB/s eta 0:00:00
Collecting boto3==1.27.1 (from -r requirements.txt (line 2))
Downloading boto3-1.27.1-py3-none-any.whl (135 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 135.9/135.9 kB 4.2 MB/s eta 0:00:00
Collecting Django==4.1.10 (from -r requirements.txt (line 3))
Downloading Django-4.1.10-py3-none-any.whl (8.1 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 8.1/8.1 MB 2.2 MB/s eta 0:00:00
Collecting django-cors-headers==4.1.0 (from -r requirements.txt (line 4))
Downloading django_cors_headers-4.1.0-py3-none-any.whl (12 kB)
Collecting django-debug-toolbar==4.1.0 (from -r requirements.txt (line 5))
Downloading django_debug_toolbar-4.1.0-py3-none-any.whl (222 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 222.5/222.5 kB 1.7 MB/s eta 0:00:00
Collecting django-filter==23.2 (from -r requirements.txt (line 6))
Downloading django_filter-23.2-py3-none-any.whl (91 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 91.9/91.9 kB 1.9 MB/s eta 0:00:00
Collecting django-graphiql-debug-toolbar==0.2.0 (from -r requirements.txt (line 7))
Downloading django_graphiql_debug_toolbar-0.2.0-py3-none-any.whl (7.3 kB)
Collecting django-mptt==0.14 (from -r requirements.txt (line 8))
Downloading django_mptt-0.14.0-py3-none-any.whl (115 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 115.6/115.6 kB 2.3 MB/s eta 0:00:00
Collecting django-pglocks==1.0.4 (from -r requirements.txt (line 9))
Downloading django-pglocks-1.0.4.tar.gz (4.1 kB)
Preparing metadata (setup.py) ... done
Collecting django-prometheus==2.3.1 (from -r requirements.txt (line 10))
Downloading django_prometheus-2.3.1-py2.py3-none-any.whl (29 kB)
Collecting django-redis==5.3.0 (from -r requirements.txt (line 11))
Downloading django_redis-5.3.0-py3-none-any.whl (30 kB)
Collecting django-rich==1.6.0 (from -r requirements.txt (line 12))
Downloading django_rich-1.6.0-py3-none-any.whl (7.1 kB)
Collecting django-rq==2.8.1 (from -r requirements.txt (line 13))
Downloading django_rq-2.8.1-py2.py3-none-any.whl (50 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 50.8/50.8 kB 1.5 MB/s eta 0:00:00
Collecting django-tables2==2.6.0 (from -r requirements.txt (line 14))
Downloading django_tables2-2.6.0-py2.py3-none-any.whl (95 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 95.2/95.2 kB 2.6 MB/s eta 0:00:00
Collecting django-taggit==4.0.0 (from -r requirements.txt (line 15))
Downloading django_taggit-4.0.0-py3-none-any.whl (60 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 60.3/60.3 kB 2.4 MB/s eta 0:00:00
Collecting django-timezone-field==5.1 (from -r requirements.txt (line 16))
Downloading django_timezone_field-5.1-py3-none-any.whl (10 kB)
Collecting djangorestframework==3.14.0 (from -r requirements.txt (line 17))
Downloading djangorestframework-3.14.0-py3-none-any.whl (1.1 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.1/1.1 MB 3.3 MB/s eta 0:00:00
Collecting drf-spectacular==0.26.3 (from -r requirements.txt (line 18))
Downloading drf_spectacular-0.26.3-py3-none-any.whl (93 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 93.6/93.6 kB 3.3 MB/s eta 0:00:00
Collecting drf-spectacular-sidecar==2023.7.1 (from -r requirements.txt (line 19))
Downloading drf_spectacular_sidecar-2023.7.1-py3-none-any.whl (2.6 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2.6/2.6 MB 3.3 MB/s eta 0:00:00
Collecting dulwich==0.21.5 (from -r requirements.txt (line 20))
Downloading dulwich-0.21.5-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (509 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 509.6/509.6 kB 1.5 MB/s eta 0:00:00
Collecting feedparser==6.0.10 (from -r requirements.txt (line 21))
Downloading feedparser-6.0.10-py3-none-any.whl (81 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 81.1/81.1 kB 2.1 MB/s eta 0:00:00
Collecting graphene-django==3.0.0 (from -r requirements.txt (line 22))
Downloading graphene_django-3.0.0-py2.py3-none-any.whl (101 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 101.9/101.9 kB 389.1 kB/s eta 0:00:00
Collecting gunicorn==20.1.0 (from -r requirements.txt (line 23))
Downloading gunicorn-20.1.0-py3-none-any.whl (79 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 79.5/79.5 kB 1.0 MB/s eta 0:00:00
Collecting Jinja2==3.1.2 (from -r requirements.txt (line 24))
Downloading Jinja2-3.1.2-py3-none-any.whl (133 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 133.1/133.1 kB 1.7 MB/s eta 0:00:00
Collecting Markdown==3.3.7 (from -r requirements.txt (line 25))
Downloading Markdown-3.3.7-py3-none-any.whl (97 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 97.8/97.8 kB 1.9 MB/s eta 0:00:00
Collecting mkdocs-material==9.1.18 (from -r requirements.txt (line 26))
Downloading mkdocs_material-9.1.18-py3-none-any.whl (7.8 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 7.8/7.8 MB 2.3 MB/s eta 0:00:00
Collecting mkdocstrings[python-legacy]==0.22.0 (from -r requirements.txt (line 27))
Downloading mkdocstrings-0.22.0-py3-none-any.whl (26 kB)
Collecting netaddr==0.8.0 (from -r requirements.txt (line 28))
Downloading netaddr-0.8.0-py2.py3-none-any.whl (1.9 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.9/1.9 MB 1.9 MB/s eta 0:00:00
Collecting Pillow==10.0.0 (from -r requirements.txt (line 29))
Downloading Pillow-10.0.0-cp39-cp39-manylinux_2_28_x86_64.whl (3.4 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 3.4/3.4 MB 2.8 MB/s eta 0:00:00
Collecting psycopg2-binary==2.9.6 (from -r requirements.txt (line 30))
Downloading psycopg2_binary-2.9.6-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (3.0 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 3.0/3.0 MB 2.8 MB/s eta 0:00:00
Collecting PyYAML==6.0 (from -r requirements.txt (line 31))
Downloading PyYAML-6.0-cp39-cp39-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_12_x86_64.manylinux2010_x86_64.whl (661 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 661.8/661.8 kB 3.8 MB/s eta 0:00:00
Collecting sentry-sdk==1.27.1 (from -r requirements.txt (line 32))
Downloading sentry_sdk-1.27.1-py2.py3-none-any.whl (211 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 211.7/211.7 kB 3.6 MB/s eta 0:00:00
Collecting social-auth-app-django==5.2.0 (from -r requirements.txt (line 33))
Downloading social_auth_app_django-5.2.0-py3-none-any.whl (24 kB)
Collecting social-auth-core[openidconnect]==4.4.2 (from -r requirements.txt (line 34))
Downloading social_auth_core-4.4.2-py3-none-any.whl (349 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 349.1/349.1 kB 4.2 MB/s eta 0:00:00
Collecting svgwrite==1.4.3 (from -r requirements.txt (line 35))
Downloading svgwrite-1.4.3-py3-none-any.whl (67 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 67.1/67.1 kB 3.8 MB/s eta 0:00:00
Collecting tablib==3.5.0 (from -r requirements.txt (line 36))
Downloading tablib-3.5.0-py3-none-any.whl (45 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 45.5/45.5 kB 4.7 MB/s eta 0:00:00
Collecting tzdata==2023.3 (from -r requirements.txt (line 37))
Downloading tzdata-2023.3-py2.py3-none-any.whl (341 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 341.8/341.8 kB 2.8 MB/s eta 0:00:00
Collecting six>=1.9.0 (from bleach==6.0.0->-r requirements.txt (line 1))
Downloading six-1.16.0-py2.py3-none-any.whl (11 kB)
Collecting webencodings (from bleach==6.0.0->-r requirements.txt (line 1))
Downloading webencodings-0.5.1-py2.py3-none-any.whl (11 kB)
Collecting botocore<1.31.0,>=1.30.1 (from boto3==1.27.1->-r requirements.txt (line 2))
Downloading botocore-1.30.1-py3-none-any.whl (11.0 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 11.0/11.0 MB 2.5 MB/s eta 0:00:00
Collecting jmespath<2.0.0,>=0.7.1 (from boto3==1.27.1->-r requirements.txt (line 2))
Downloading jmespath-1.0.1-py3-none-any.whl (20 kB)
Collecting s3transfer<0.7.0,>=0.6.0 (from boto3==1.27.1->-r requirements.txt (line 2))
Downloading s3transfer-0.6.1-py3-none-any.whl (79 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 79.8/79.8 kB 1.6 MB/s eta 0:00:00
Collecting asgiref<4,>=3.5.2 (from Django==4.1.10->-r requirements.txt (line 3))
Downloading asgiref-3.7.2-py3-none-any.whl (24 kB)
Collecting sqlparse>=0.2.2 (from Django==4.1.10->-r requirements.txt (line 3))
Downloading sqlparse-0.4.4-py3-none-any.whl (41 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 41.2/41.2 kB 1.4 MB/s eta 0:00:00
Collecting django-js-asset (from django-mptt==0.14->-r requirements.txt (line 8))
Downloading django_js_asset-2.1.0-py3-none-any.whl (4.7 kB)
Collecting prometheus-client>=0.7 (from django-prometheus==2.3.1->-r requirements.txt (line 10))
Downloading prometheus_client-0.17.0-py3-none-any.whl (60 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 60.6/60.6 kB 1.8 MB/s eta 0:00:00
Collecting redis!=4.0.0,!=4.0.1,>=3 (from django-redis==5.3.0->-r requirements.txt (line 11))
Downloading redis-4.6.0-py3-none-any.whl (241 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 241.1/241.1 kB 1.9 MB/s eta 0:00:00
Collecting rich>=10.0.0 (from django-rich==1.6.0->-r requirements.txt (line 12))
Downloading rich-13.4.2-py3-none-any.whl (239 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 239.4/239.4 kB 1.4 MB/s eta 0:00:00
Collecting rq>=1.14 (from django-rq==2.8.1->-r requirements.txt (line 13))
Downloading rq-1.15.1-py2.py3-none-any.whl (95 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 95.8/95.8 kB 1.3 MB/s eta 0:00:00
Collecting pytz (from django-timezone-field==5.1->-r requirements.txt (line 16))
Downloading pytz-2023.3-py2.py3-none-any.whl (502 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 502.3/502.3 kB 1.9 MB/s eta 0:00:00
Collecting uritemplate>=2.0.0 (from drf-spectacular==0.26.3->-r requirements.txt (line 18))
Downloading uritemplate-4.1.1-py2.py3-none-any.whl (10 kB)
Collecting jsonschema>=2.6.0 (from drf-spectacular==0.26.3->-r requirements.txt (line 18))
Downloading jsonschema-4.18.0-py3-none-any.whl (81 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 81.5/81.5 kB 1.8 MB/s eta 0:00:00
Collecting inflection>=0.3.1 (from drf-spectacular==0.26.3->-r requirements.txt (line 18))
Downloading inflection-0.5.1-py2.py3-none-any.whl (9.5 kB)
Collecting urllib3>=1.25 (from dulwich==0.21.5->-r requirements.txt (line 20))
Downloading urllib3-2.0.3-py3-none-any.whl (123 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 123.6/123.6 kB 1.9 MB/s eta 0:00:00
Collecting sgmllib3k (from feedparser==6.0.10->-r requirements.txt (line 21))
Downloading sgmllib3k-1.0.0.tar.gz (5.8 kB)
Preparing metadata (setup.py) ... done
Collecting graphene<4,>=3.0 (from graphene-django==3.0.0->-r requirements.txt (line 22))
Downloading graphene-3.2.2-py2.py3-none-any.whl (125 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 125.6/125.6 kB 1.8 MB/s eta 0:00:00
Collecting graphql-core<4,>=3.1.0 (from graphene-django==3.0.0->-r requirements.txt (line 22))
Downloading graphql_core-3.2.3-py3-none-any.whl (202 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 202.9/202.9 kB 1.9 MB/s eta 0:00:00
Collecting graphql-relay<4,>=3.1.1 (from graphene-django==3.0.0->-r requirements.txt (line 22))
Downloading graphql_relay-3.2.0-py3-none-any.whl (16 kB)
Collecting promise>=2.1 (from graphene-django==3.0.0->-r requirements.txt (line 22))
Downloading promise-2.3.tar.gz (19 kB)
Preparing metadata (setup.py) ... done
Collecting text-unidecode (from graphene-django==3.0.0->-r requirements.txt (line 22))
Downloading text_unidecode-1.3-py2.py3-none-any.whl (78 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 78.2/78.2 kB 2.1 MB/s eta 0:00:00
Requirement already satisfied: setuptools>=3.0 in ./venv/lib/python3.9/site-packages (from gunicorn==20.1.0->-r requirements.txt (line 23)) (53.0.0)
Collecting MarkupSafe>=2.0 (from Jinja2==3.1.2->-r requirements.txt (line 24))
Downloading MarkupSafe-2.1.3-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (25 kB)
Collecting importlib-metadata>=4.4 (from Markdown==3.3.7->-r requirements.txt (line 25))
Downloading importlib_metadata-6.8.0-py3-none-any.whl (22 kB)
Collecting colorama>=0.4 (from mkdocs-material==9.1.18->-r requirements.txt (line 26))
Downloading colorama-0.4.6-py2.py3-none-any.whl (25 kB)
Collecting mkdocs-material-extensions>=1.1 (from mkdocs-material==9.1.18->-r requirements.txt (line 26))
Downloading mkdocs_material_extensions-1.1.1-py3-none-any.whl (7.9 kB)
Collecting mkdocs>=1.4.2 (from mkdocs-material==9.1.18->-r requirements.txt (line 26))
Downloading mkdocs-1.4.3-py3-none-any.whl (3.7 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 3.7/3.7 MB 2.1 MB/s eta 0:00:00
Collecting pygments>=2.14 (from mkdocs-material==9.1.18->-r requirements.txt (line 26))
Downloading Pygments-2.15.1-py3-none-any.whl (1.1 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.1/1.1 MB 2.4 MB/s eta 0:00:00
Collecting pymdown-extensions>=9.9.1 (from mkdocs-material==9.1.18->-r requirements.txt (line 26))
Downloading pymdown_extensions-10.0.1-py3-none-any.whl (240 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 240.1/240.1 kB 3.1 MB/s eta 0:00:00
Collecting regex>=2022.4.24 (from mkdocs-material==9.1.18->-r requirements.txt (line 26))
Downloading regex-2023.6.3-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (769 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 769.9/769.9 kB 2.3 MB/s eta 0:00:00
Collecting requests>=2.26 (from mkdocs-material==9.1.18->-r requirements.txt (line 26))
Downloading requests-2.31.0-py3-none-any.whl (62 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 62.6/62.6 kB 2.4 MB/s eta 0:00:00
Collecting mkdocs-autorefs>=0.3.1 (from mkdocstrings[python-legacy]==0.22.0->-r requirements.txt (line 27))
Downloading mkdocs_autorefs-0.4.1-py3-none-any.whl (9.8 kB)
Collecting typing-extensions>=4.1 (from mkdocstrings[python-legacy]==0.22.0->-r requirements.txt (line 27))
Downloading typing_extensions-4.7.1-py3-none-any.whl (33 kB)
Collecting mkdocstrings-python-legacy>=0.2.1 (from mkdocstrings[python-legacy]==0.22.0->-r requirements.txt (line 27))
Downloading mkdocstrings_python_legacy-0.2.3-py3-none-any.whl (26 kB)
Collecting certifi (from sentry-sdk==1.27.1->-r requirements.txt (line 32))
Downloading certifi-2023.5.7-py3-none-any.whl (156 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 157.0/157.0 kB 2.0 MB/s eta 0:00:00
Collecting oauthlib>=1.0.3 (from social-auth-core[openidconnect]==4.4.2->-r requirements.txt (line 34))
Downloading oauthlib-3.2.2-py3-none-any.whl (151 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 151.7/151.7 kB 2.0 MB/s eta 0:00:00
Collecting requests-oauthlib>=0.6.1 (from social-auth-core[openidconnect]==4.4.2->-r requirements.txt (line 34))
Downloading requests_oauthlib-1.3.1-py2.py3-none-any.whl (23 kB)
Collecting PyJWT>=2.0.0 (from social-auth-core[openidconnect]==4.4.2->-r requirements.txt (line 34))
Downloading PyJWT-2.7.0-py3-none-any.whl (22 kB)
Collecting cryptography>=1.4 (from social-auth-core[openidconnect]==4.4.2->-r requirements.txt (line 34))
Downloading cryptography-41.0.1-cp37-abi3-manylinux_2_28_x86_64.whl (4.3 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 4.3/4.3 MB 1.9 MB/s eta 0:00:00
Collecting defusedxml>=0.5.0rc1 (from social-auth-core[openidconnect]==4.4.2->-r requirements.txt (line 34))
Downloading defusedxml-0.7.1-py2.py3-none-any.whl (25 kB)
Collecting python3-openid>=3.0.10 (from social-auth-core[openidconnect]==4.4.2->-r requirements.txt (line 34))
Downloading python3_openid-3.2.0-py3-none-any.whl (133 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 133.7/133.7 kB 3.7 MB/s eta 0:00:00
Collecting python-jose>=3.0.0 (from social-auth-core[openidconnect]==4.4.2->-r requirements.txt (line 34))
Downloading python_jose-3.3.0-py2.py3-none-any.whl (33 kB)
Collecting python-dateutil<3.0.0,>=2.1 (from botocore<1.31.0,>=1.30.1->boto3==1.27.1->-r requirements.txt (line 2))
Downloading python_dateutil-2.8.2-py2.py3-none-any.whl (247 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 247.7/247.7 kB 3.2 MB/s eta 0:00:00
Collecting urllib3>=1.25 (from dulwich==0.21.5->-r requirements.txt (line 20))
Downloading urllib3-1.26.16-py2.py3-none-any.whl (143 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 143.1/143.1 kB 3.9 MB/s eta 0:00:00
Collecting cffi>=1.12 (from cryptography>=1.4->social-auth-core[openidconnect]==4.4.2->-r requirements.txt (line 34))
Downloading cffi-1.15.1-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (441 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 441.2/441.2 kB 4.0 MB/s eta 0:00:00
Collecting aniso8601<10,>=8 (from graphene<4,>=3.0->graphene-django==3.0.0->-r requirements.txt (line 22))
Downloading aniso8601-9.0.1-py2.py3-none-any.whl (52 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 52.8/52.8 kB 2.3 MB/s eta 0:00:00
Collecting zipp>=0.5 (from importlib-metadata>=4.4->Markdown==3.3.7->-r requirements.txt (line 25))
Downloading zipp-3.16.0-py3-none-any.whl (6.7 kB)
Collecting attrs>=22.2.0 (from jsonschema>=2.6.0->drf-spectacular==0.26.3->-r requirements.txt (line 18))
Downloading attrs-23.1.0-py3-none-any.whl (61 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 61.2/61.2 kB 2.3 MB/s eta 0:00:00
Collecting jsonschema-specifications>=2023.03.6 (from jsonschema>=2.6.0->drf-spectacular==0.26.3->-r requirements.txt (line 18))
Downloading jsonschema_specifications-2023.6.1-py3-none-any.whl (17 kB)
Collecting referencing>=0.28.4 (from jsonschema>=2.6.0->drf-spectacular==0.26.3->-r requirements.txt (line 18))
Downloading referencing-0.29.1-py3-none-any.whl (25 kB)
Collecting rpds-py>=0.7.1 (from jsonschema>=2.6.0->drf-spectacular==0.26.3->-r requirements.txt (line 18))
Downloading rpds_py-0.8.10-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (1.2 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.2/1.2 MB 2.0 MB/s eta 0:00:00
Collecting click>=7.0 (from mkdocs>=1.4.2->mkdocs-material==9.1.18->-r requirements.txt (line 26))
Downloading click-8.1.4-py3-none-any.whl (98 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 98.2/98.2 kB 1.5 MB/s eta 0:00:00
Collecting ghp-import>=1.0 (from mkdocs>=1.4.2->mkdocs-material==9.1.18->-r requirements.txt (line 26))
Downloading ghp_import-2.1.0-py3-none-any.whl (11 kB)
Collecting mergedeep>=1.3.4 (from mkdocs>=1.4.2->mkdocs-material==9.1.18->-r requirements.txt (line 26))
Downloading mergedeep-1.3.4-py3-none-any.whl (6.4 kB)
Collecting packaging>=20.5 (from mkdocs>=1.4.2->mkdocs-material==9.1.18->-r requirements.txt (line 26))
Downloading packaging-23.1-py3-none-any.whl (48 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 48.9/48.9 kB 1.6 MB/s eta 0:00:00
Collecting pyyaml-env-tag>=0.1 (from mkdocs>=1.4.2->mkdocs-material==9.1.18->-r requirements.txt (line 26))
Downloading pyyaml_env_tag-0.1-py3-none-any.whl (3.9 kB)
Collecting watchdog>=2.0 (from mkdocs>=1.4.2->mkdocs-material==9.1.18->-r requirements.txt (line 26))
Downloading watchdog-3.0.0-py3-none-manylinux2014_x86_64.whl (82 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 82.1/82.1 kB 2.1 MB/s eta 0:00:00
Collecting pytkdocs>=0.14 (from mkdocstrings-python-legacy>=0.2.1->mkdocstrings[python-legacy]==0.22.0->-r requirements.txt (line 27))
Downloading pytkdocs-0.16.1-py3-none-any.whl (37 kB)
Collecting ecdsa!=0.15 (from python-jose>=3.0.0->social-auth-core[openidconnect]==4.4.2->-r requirements.txt (line 34))
Downloading ecdsa-0.18.0-py2.py3-none-any.whl (142 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 142.9/142.9 kB 2.3 MB/s eta 0:00:00
Collecting rsa (from python-jose>=3.0.0->social-auth-core[openidconnect]==4.4.2->-r requirements.txt (line 34))
Downloading rsa-4.9-py3-none-any.whl (34 kB)
Collecting pyasn1 (from python-jose>=3.0.0->social-auth-core[openidconnect]==4.4.2->-r requirements.txt (line 34))
Downloading pyasn1-0.5.0-py2.py3-none-any.whl (83 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 83.9/83.9 kB 1.2 MB/s eta 0:00:00
Collecting async-timeout>=4.0.2 (from redis!=4.0.0,!=4.0.1,>=3->django-redis==5.3.0->-r requirements.txt (line 11))
Downloading async_timeout-4.0.2-py3-none-any.whl (5.8 kB)
Collecting charset-normalizer<4,>=2 (from requests>=2.26->mkdocs-material==9.1.18->-r requirements.txt (line 26))
Downloading charset_normalizer-3.2.0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (202 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 202.1/202.1 kB 1.9 MB/s eta 0:00:00
Collecting idna<4,>=2.5 (from requests>=2.26->mkdocs-material==9.1.18->-r requirements.txt (line 26))
Downloading idna-3.4-py3-none-any.whl (61 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 61.5/61.5 kB 2.0 MB/s eta 0:00:00
Collecting markdown-it-py>=2.2.0 (from rich>=10.0.0->django-rich==1.6.0->-r requirements.txt (line 12))
Downloading markdown_it_py-3.0.0-py3-none-any.whl (87 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 87.5/87.5 kB 1.6 MB/s eta 0:00:00
Collecting pycparser (from cffi>=1.12->cryptography>=1.4->social-auth-core[openidconnect]==4.4.2->-r requirements.txt (line 34))
Downloading pycparser-2.21-py2.py3-none-any.whl (118 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 118.7/118.7 kB 2.3 MB/s eta 0:00:00
Collecting mdurl~=0.1 (from markdown-it-py>=2.2.0->rich>=10.0.0->django-rich==1.6.0->-r requirements.txt (line 12))
Downloading mdurl-0.1.2-py3-none-any.whl (10.0 kB)
Building wheels for collected packages: django-pglocks, promise, sgmllib3k
Building wheel for django-pglocks (setup.py) ... done
Created wheel for django-pglocks: filename=django_pglocks-1.0.4-py3-none-any.whl size=3876 sha256=75892aa6e14c60ea2a70ee1e338adbe20855c5c38044bd747f359f7bc3bcfb48
Stored in directory: /root/.cache/pip/wheels/54/e4/cd/ef2952231e7b10f1b2fbe71a5cd948664a245a1b9cb71bed31
Building wheel for promise (setup.py) ... done
Created wheel for promise: filename=promise-2.3-py3-none-any.whl size=21501 sha256=d8b7e42dc27ec66a947fcc739214da4d96f3f5a9931338bdb4795dddaf9c851e
Stored in directory: /root/.cache/pip/wheels/e1/e8/83/ddea66100678d139b14bc87692ece57c6a2a937956d2532608
Building wheel for sgmllib3k (setup.py) ... done
Created wheel for sgmllib3k: filename=sgmllib3k-1.0.0-py3-none-any.whl size=6067 sha256=843ab8bf72755bc0e565e06c59fa9061f4cfc6a76a0a98dfb37fe17aab15fd4a
Stored in directory: /root/.cache/pip/wheels/65/7a/a7/78c287f64e401255dff4c13fdbc672fed5efbfd21c530114e1
Successfully built django-pglocks promise sgmllib3k
Installing collected packages: webencodings, text-unidecode, sgmllib3k, pytz, netaddr, aniso8601, zipp, watchdog, urllib3, uritemplate, tzdata, typing-extensions, tablib, svgwrite, sqlparse, six, rpds-py, regex, PyYAML, pytkdocs, PyJWT, pygments, pycparser, pyasn1, psycopg2-binary, prometheus-client, Pillow, packaging, oauthlib, mkdocs-material-extensions, mergedeep, mdurl, MarkupSafe, jmespath, inflection, idna, gunicorn, graphql-core, feedparser, defusedxml, colorama, click, charset-normalizer, certifi, attrs, async-timeout, sentry-sdk, rsa, requests, referencing, redis, pyyaml-env-tag, python3-openid, python-dateutil, promise, markdown-it-py, Jinja2, importlib-metadata, graphql-relay, ecdsa, dulwich, django-prometheus, django-pglocks, cffi, bleach, asgiref, rq, rich, requests-oauthlib, python-jose, Markdown, jsonschema-specifications, graphene, ghp-import, Django, cryptography, botocore, social-auth-core, s3transfer, pymdown-extensions, mkdocs, jsonschema, graphene-django, drf-spectacular-sidecar, djangorestframework, django-timezone-field, django-taggit, django-tables2, django-rq, django-rich, django-redis, django-js-asset, django-filter, django-debug-toolbar, django-cors-headers, social-auth-app-django, mkdocs-material, mkdocs-autorefs, drf-spectacular, django-mptt, django-graphiql-debug-toolbar, boto3, mkdocstrings, mkdocstrings-python-legacy
Successfully installed Django-4.1.10 Jinja2-3.1.2 Markdown-3.3.7 MarkupSafe-2.1.3 Pillow-10.0.0 PyJWT-2.7.0 PyYAML-6.0 aniso8601-9.0.1 asgiref-3.7.2 async-timeout-4.0.2 attrs-23.1.0 bleach-6.0.0 boto3-1.27.1 botocore-1.30.1 certifi-2023.5.7 cffi-1.15.1 charset-normalizer-3.2.0 click-8.1.4 colorama-0.4.6 cryptography-41.0.1 defusedxml-0.7.1 django-cors-headers-4.1.0 django-debug-toolbar-4.1.0 django-filter-23.2 django-graphiql-debug-toolbar-0.2.0 django-js-asset-2.1.0 django-mptt-0.14.0 django-pglocks-1.0.4 django-prometheus-2.3.1 django-redis-5.3.0 django-rich-1.6.0 django-rq-2.8.1 django-tables2-2.6.0 django-taggit-4.0.0 django-timezone-field-5.1 djangorestframework-3.14.0 drf-spectacular-0.26.3 drf-spectacular-sidecar-2023.7.1 dulwich-0.21.5 ecdsa-0.18.0 feedparser-6.0.10 ghp-import-2.1.0 graphene-3.2.2 graphene-django-3.0.0 graphql-core-3.2.3 graphql-relay-3.2.0 gunicorn-20.1.0 idna-3.4 importlib-metadata-6.8.0 inflection-0.5.1 jmespath-1.0.1 jsonschema-4.18.0 jsonschema-specifications-2023.6.1 markdown-it-py-3.0.0 mdurl-0.1.2 mergedeep-1.3.4 mkdocs-1.4.3 mkdocs-autorefs-0.4.1 mkdocs-material-9.1.18 mkdocs-material-extensions-1.1.1 mkdocstrings-0.22.0 mkdocstrings-python-legacy-0.2.3 netaddr-0.8.0 oauthlib-3.2.2 packaging-23.1 prometheus-client-0.17.0 promise-2.3 psycopg2-binary-2.9.6 pyasn1-0.5.0 pycparser-2.21 pygments-2.15.1 pymdown-extensions-10.0.1 python-dateutil-2.8.2 python-jose-3.3.0 python3-openid-3.2.0 pytkdocs-0.16.1 pytz-2023.3 pyyaml-env-tag-0.1 redis-4.6.0 referencing-0.29.1 regex-2023.6.3 requests-2.31.0 requests-oauthlib-1.3.1 rich-13.4.2 rpds-py-0.8.10 rq-1.15.1 rsa-4.9 s3transfer-0.6.1 sentry-sdk-1.27.1 sgmllib3k-1.0.0 six-1.16.0 social-auth-app-django-5.2.0 social-auth-core-4.4.2 sqlparse-0.4.4 svgwrite-1.4.3 tablib-3.5.0 text-unidecode-1.3 typing-extensions-4.7.1 tzdata-2023.3 uritemplate-4.1.1 urllib3-1.26.16 watchdog-3.0.0 webencodings-0.5.1 zipp-3.16.0
Skipping local dependencies (local_requirements.txt not found)
Applying database migrations (python3 netbox/manage.py migrate)...
Traceback (most recent call last):
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedTable: relation "django_content_type" does not exist
LINE 1: ..."."app_label", "django_content_type"."model" FROM "django_co...
^

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

Traceback (most recent call last):
File "/opt/netbox/netbox/manage.py", line 10, in
execute_from_command_line(sys.argv)
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/core/management/init.py", line 446, in execute_from_command_line
utility.execute()
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/core/management/init.py", line 440, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/core/management/base.py", line 402, in run_from_argv
self.execute(*args, **cmd_options)
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/core/management/base.py", line 448, in execute
output = self.handle(*args, **options)
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/core/management/base.py", line 96, in wrapped
res = handle_func(*args, **kwargs)
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/core/management/commands/migrate.py", line 97, in handle
self.check(databases=[database])
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/core/management/base.py", line 475, in check
all_issues = checks.run_checks(
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/core/checks/registry.py", line 88, in run_checks
new_errors = check(app_configs=app_configs, databases=databases)
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/core/checks/urls.py", line 14, in check_url_config
return check_resolver(resolver)
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/core/checks/urls.py", line 24, in check_resolver
return check_method()
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/urls/resolvers.py", line 494, in check
for pattern in self.url_patterns:
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/utils/functional.py", line 57, in get
res = instance.dict[self.name] = self.func(instance)
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/urls/resolvers.py", line 715, in url_patterns
patterns = getattr(self.urlconf_module, "urlpatterns", self.urlconf_module)
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/utils/functional.py", line 57, in get
res = instance.dict[self.name] = self.func(instance)
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/urls/resolvers.py", line 708, in urlconf_module
return import_module(self.urlconf_name)
File "/usr/lib64/python3.9/importlib/init.py", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "", line 1030, in _gcd_import
File "", line 1007, in _find_and_load
File "", line 986, in _find_and_load_unlocked
File "", line 680, in _load_unlocked
File "", line 850, in exec_module
File "", line 228, in _call_with_frames_removed
File "/opt/netbox/netbox/netbox/urls.py", line 29, in
path('circuits/', include('circuits.urls')),
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/urls/conf.py", line 38, in include
urlconf_module = import_module(urlconf_module)
File "/usr/lib64/python3.9/importlib/init.py", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "", line 1030, in _gcd_import
File "", line 1007, in _find_and_load
File "", line 986, in _find_and_load_unlocked
File "", line 680, in _load_unlocked
File "", line 850, in exec_module
File "", line 228, in _call_with_frames_removed
File "/opt/netbox/netbox/circuits/urls.py", line 4, in
from . import views
File "/opt/netbox/netbox/circuits/views.py", line 5, in
from dcim.views import PathTraceView
File "/opt/netbox/netbox/dcim/views.py", line 19, in
from extras.views import ObjectConfigContextView
File "/opt/netbox/netbox/extras/views.py", line 513, in
class ObjectChangeListView(generic.ObjectListView):
File "/opt/netbox/netbox/extras/views.py", line 514, in ObjectChangeListView
queryset = ObjectChange.objects.valid_models()
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/db/models/manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/opt/netbox/netbox/extras/querysets.py", line 164, in valid_models
ct.pk for ct in ContentType.objects.get_for_models(*apps.get_models()).values()
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/contrib/contenttypes/models.py", line 91, in get_for_models
for ct in cts:
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/db/models/query.py", line 394, in iter
self._fetch_all()
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/db/models/query.py", line 1867, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/db/models/query.py", line 87, in iter
results = compiler.execute_sql(
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/db/models/sql/compiler.py", line 1398, in execute_sql
cursor.execute(sql, params)
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/db/backends/utils.py", line 67, in execute
return self._execute_with_wrappers(
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/db/utils.py", line 91, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/opt/netbox/venv/lib64/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: relation "django_content_type" does not exist
LINE 1: ..."."app_label", "django_content_type"."model" FROM "django_co...
^

[admin@centos9stream-netbox netbox]$

[abhi1693]

See #13116

[fvandonk]

Thanks. I read both 13116 and 13137 but I have no idea what I need to do to fix it.
Do I fix it by modifying the querysets.py file as noted here?:
695b4be

Sorry for being a noob with this.

[gitty85]

I just went back to 3.5.4 it was easier :)

Just clear your /opt/netbox directory first but backup the configuration.py file if you want.

[fvandonk]

I followed the steps as shown here:
695b4be

which came from the link provided here:
#13117

and rerun the upgrade scripts and that worked as expected. Thanks all for the quick reply.