issue upgrade 3.5.9 to 3.6

[doby]

NetBox version

v3.5.9

Python version

3.10

Steps to Reproduce

1 . podman pull quay.io/netboxcommunity/netbox:v3.6
2. podman stop netbox
3. podman rm netbox
4. podman run -d --env-file env-netbox -e NETBOX_DELETE_LEGACY_DATA=1 -t --name netbox --pod netbox quay.io/netboxcommunity/netbox:v3.6

Expected Behavior

start version 3.6

Observed Behavior

⚙️ Applying database migrations
🧬 loaded config '/etc/netbox/config/configuration.py'
🧬 loaded config '/etc/netbox/config/extra.py'
🧬 loaded config '/etc/netbox/config/logging.py'
🧬 loaded config '/etc/netbox/config/plugins.py'
Operations to perform:
Apply all migrations: account, admin, auth, circuits, contenttypes, core, dcim, django_rq, extras, ipam, sessions, social_django, taggit, tenancy, users, virtualization, wireless
Running migrations:
Applying dcim.0177_devicetype_component_counters...Traceback (most recent call last):
File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/backends/utils.py", line 89, in execute
return self.cursor.execute(sql, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/netbox/venv/lib/python3.11/site-packages/psycopg/cursor.py", line 737, in execute
raise ex.with_traceback(None)
psycopg.errors.InternalError: failed to look up symbol "evalexpr_0_0": Failed to materialize symbols: { (main, { evalexpr_0_71, evalexpr_0_32, evalexpr_0_41, evalexpr_0_11, evalexpr_0_13, evalexpr_0_61, evalexpr_0_53, evalexpr_0_16, evalexpr_0_59, evalexpr_0_54, evalexpr_0_34, evalexpr_0_3, evalexpr_0_39, evalexpr_0_24, evalexpr_0_58, evalexpr_0_27, evalexpr_0_6, evalexpr_0_25, evalexpr_0_9, evalexpr_0_73, evalexpr_0_69, evalexpr_0_68, evalexpr_0_51, evalexpr_0_49, evalexpr_0_66, evalexpr_0_29, evalexpr_0_31, evalexpr_0_0, evalexpr_0_22, evalexpr_0_72, evalexpr_0_2, evalexpr_0_46, evalexpr_0_43, evalexpr_0_18, evalexpr_0_36, evalexpr_0_56, evalexpr_0_48, evalexpr_0_63, evalexpr_0_44, evalexpr_0_20, evalexpr_0_64, evalexpr_0_38 }) }

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/lib/python3.11/site-packages/django/core/management/init.py", line 442, in execute_from_command_line
utility.execute()
File "/opt/netbox/venv/lib/python3.11/site-packages/django/core/management/init.py", line 436, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/opt/netbox/venv/lib/python3.11/site-packages/django/core/management/base.py", line 412, in run_from_argv
self.execute(*args, **cmd_options)
File "/opt/netbox/venv/lib/python3.11/site-packages/django/core/management/base.py", line 458, in execute
output = self.handle(*args, **options)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/netbox/venv/lib/python3.11/site-packages/django/core/management/base.py", line 106, in wrapper
res = handle_func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/netbox/venv/lib/python3.11/site-packages/django/core/management/commands/migrate.py", line 356, in handle
post_migrate_state = executor.migrate(
^^^^^^^^^^^^^^^^^
File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/migrations/executor.py", line 135, in migrate
state = self._migrate_all_forwards(
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/migrations/executor.py", line 167, in _migrate_all_forwards
state = self.apply_migration(
^^^^^^^^^^^^^^^^^^^^^
File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/migrations/executor.py", line 252, in apply_migration
state = migration.apply(state, schema_editor)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/migrations/migration.py", line 132, in apply
operation.database_forwards(
File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/migrations/operations/special.py", line 193, in database_forwards
self.code(from_state.apps, schema_editor)
File "/opt/netbox/netbox/dcim/migrations/0177_devicetype_component_counters.py", line 9, in recalculate_devicetype_template_counts
device_types = list(DeviceType.objects.all().annotate(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/models/query.py", line 398, in iter
self._fetch_all()
File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/models/query.py", line 1881, in _fetch_all
self._result_cache = list(self._iterable_class(self))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/models/query.py", line 91, in iter
results = compiler.execute_sql(
^^^^^^^^^^^^^^^^^^^^^
File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/models/sql/compiler.py", line 1562, in execute_sql
cursor.execute(sql, params)
File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/backends/utils.py", line 67, in execute
return self._execute_with_wrappers(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
return executor(sql, params, many, context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/backends/utils.py", line 84, in _execute
with self.db.wrap_database_errors:
File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/utils.py", line 91, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/netbox/venv/lib/python3.11/site-packages/psycopg/cursor.py", line 737, in execute
raise ex.with_traceback(None)
django.db.utils.InternalError: failed to look up symbol "evalexpr_0_0": Failed to materialize symbols: { (main, { evalexpr_0_71, evalexpr_0_32, evalexpr_0_41, evalexpr_0_11, evalexpr_0_13, evalexpr_0_61, evalexpr_0_53, evalexpr_0_16, evalexpr_0_59, evalexpr_0_54, evalexpr_0_34, evalexpr_0_3, evalexpr_0_39, evalexpr_0_24, evalexpr_0_58, evalexpr_0_27, evalexpr_0_6, evalexpr_0_25, evalexpr_0_9, evalexpr_0_73, evalexpr_0_69, evalexpr_0_68, evalexpr_0_51, evalexpr_0_49, evalexpr_0_66, evalexpr_0_29, evalexpr_0_31, evalexpr_0_0, evalexpr_0_22, evalexpr_0_72, evalexpr_0_2, evalexpr_0_46, evalexpr_0_43, evalexpr_0_18, evalexpr_0_36, evalexpr_0_56, evalexpr_0_48, evalexpr_0_63, evalexpr_0_44, evalexpr_0_20, evalexpr_0_64, evalexpr_0_38 }) }

[kkthxbye-code]

I converted this to a discussion as the error is an internal postgres LLVM JIT error, which would indicate a bug in postgres or your system.