ValueError when upgrading from 3.6.5 to 3.6.8 #9005

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

Originally created by @advoenkin on GitHub (Dec 28, 2023).

Deployment Type

Self-hosted

NetBox Version

v3.6.8

Python Version

3.10

Steps to Reproduce

  1. Use installed self-hosted instance Netbox v.3.6.5
  2. Run upgrade.sh script to upgrade to v.3.6.8

Expected Behavior

Previously, such an error did not occur.

Observed Behavior


Completed. Total entries: 278154
Removing expired user sessions (python3 netbox/manage.py clearsessions)...
Traceback (most recent call last):
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/fields/__init__.py", line 2053, in get_prep_value
    return int(value)
ValueError: invalid literal for int() with base 10: 'ma60hl2jatad0t2uo6mia04ww49i98p7'

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

Traceback (most recent call last):
  File "/opt/netbox-3.6.8/netbox/manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/core/management/__init__.py", line 442, in execute_from_command_line
    utility.execute()
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/core/management/__init__.py", line 436, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/core/management/base.py", line 412, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/core/management/base.py", line 458, in execute
    output = self.handle(*args, **options)
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/contrib/sessions/management/commands/clearsessions.py", line 16, in handle
    engine.SessionStore.clear_expired()
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/contrib/sessions/backends/db.py", line 110, in clear_expired
    cls.get_model_class().objects.filter(expire_date__lt=timezone.now()).delete()
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/query.py", line 1148, in delete
    deleted, _rows_count = collector.delete()
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/deletion.py", line 463, in delete
    signals.pre_delete.send(
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/dispatch/dispatcher.py", line 176, in send
    return [
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/dispatch/dispatcher.py", line 177, in <listcomp>
    (receiver, receiver(signal=self, sender=sender, **named))
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/netbox_attachments/models.py", line 113, in pre_delete_receiver
    NetBoxAttachment.objects.filter(
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/manager.py", line 87, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/query.py", line 1436, in filter
    return self._filter_or_exclude(False, args, kwargs)
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/query.py", line 1454, in _filter_or_exclude
    clone._filter_or_exclude_inplace(negate, args, kwargs)
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/query.py", line 1461, in _filter_or_exclude_inplace
    self._query.add_q(Q(*args, **kwargs))
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/sql/query.py", line 1546, in add_q
    clause, _ = self._add_q(q_object, self.used_aliases)
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/sql/query.py", line 1577, in _add_q
    child_clause, needed_inner = self.build_filter(
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/sql/query.py", line 1492, in build_filter
    condition = self.build_lookup(lookups, col, value)
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/sql/query.py", line 1319, in build_lookup
    lookup = lookup_class(lhs, rhs)
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/lookups.py", line 27, in __init__
    self.rhs = self.get_prep_lookup()
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/lookups.py", line 341, in get_prep_lookup
    return super().get_prep_lookup()
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/lookups.py", line 85, in get_prep_lookup
    return self.lhs.output_field.get_prep_value(self.rhs)
  File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/fields/__init__.py", line 2055, in get_prep_value
    raise e.__class__(
ValueError: Field 'object_id' expected a number but got 'ma60hl2jatad0t2uo6mia04ww49i98p7'.

Originally created by @advoenkin on GitHub (Dec 28, 2023). ### Deployment Type Self-hosted ### NetBox Version v3.6.8 ### Python Version 3.10 ### Steps to Reproduce 1. Use installed self-hosted instance Netbox v.3.6.5 2. Run upgrade.sh script to upgrade to v.3.6.8 ### Expected Behavior Previously, such an error did not occur. ### Observed Behavior ``` Completed. Total entries: 278154 Removing expired user sessions (python3 netbox/manage.py clearsessions)... Traceback (most recent call last): File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/fields/__init__.py", line 2053, in get_prep_value return int(value) ValueError: invalid literal for int() with base 10: 'ma60hl2jatad0t2uo6mia04ww49i98p7' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/opt/netbox-3.6.8/netbox/manage.py", line 10, in <module> execute_from_command_line(sys.argv) File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/core/management/__init__.py", line 442, in execute_from_command_line utility.execute() File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/core/management/__init__.py", line 436, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/core/management/base.py", line 412, in run_from_argv self.execute(*args, **cmd_options) File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/core/management/base.py", line 458, in execute output = self.handle(*args, **options) File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/contrib/sessions/management/commands/clearsessions.py", line 16, in handle engine.SessionStore.clear_expired() File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/contrib/sessions/backends/db.py", line 110, in clear_expired cls.get_model_class().objects.filter(expire_date__lt=timezone.now()).delete() File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/query.py", line 1148, in delete deleted, _rows_count = collector.delete() File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/deletion.py", line 463, in delete signals.pre_delete.send( File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/dispatch/dispatcher.py", line 176, in send return [ File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/dispatch/dispatcher.py", line 177, in <listcomp> (receiver, receiver(signal=self, sender=sender, **named)) File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/netbox_attachments/models.py", line 113, in pre_delete_receiver NetBoxAttachment.objects.filter( File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/manager.py", line 87, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/query.py", line 1436, in filter return self._filter_or_exclude(False, args, kwargs) File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/query.py", line 1454, in _filter_or_exclude clone._filter_or_exclude_inplace(negate, args, kwargs) File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/query.py", line 1461, in _filter_or_exclude_inplace self._query.add_q(Q(*args, **kwargs)) File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/sql/query.py", line 1546, in add_q clause, _ = self._add_q(q_object, self.used_aliases) File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/sql/query.py", line 1577, in _add_q child_clause, needed_inner = self.build_filter( File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/sql/query.py", line 1492, in build_filter condition = self.build_lookup(lookups, col, value) File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/sql/query.py", line 1319, in build_lookup lookup = lookup_class(lhs, rhs) File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/lookups.py", line 27, in __init__ self.rhs = self.get_prep_lookup() File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/lookups.py", line 341, in get_prep_lookup return super().get_prep_lookup() File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/lookups.py", line 85, in get_prep_lookup return self.lhs.output_field.get_prep_value(self.rhs) File "/opt/netbox-3.6.8/venv/lib/python3.10/site-packages/django/db/models/fields/__init__.py", line 2055, in get_prep_value raise e.__class__( ValueError: Field 'object_id' expected a number but got 'ma60hl2jatad0t2uo6mia04ww49i98p7'. ```
adam closed this issue 2025-12-29 20:44:04 +01:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#9005