issue upgrade 3.5.9 to 3.6 #8585

Closed
opened 2025-12-29 20:38:30 +01:00 by adam · 0 comments
Owner

Originally created by @doby on GitHub (Sep 7, 2023).

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 }) }

Originally created by @doby on GitHub (Sep 7, 2023). ### 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 <module> 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 }) }
adam closed this issue 2025-12-29 20:38:30 +01:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#8585