ValueError when upgrading from 3.6.5 to 3.6.8

[advoenkin]

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'.

[advoenkin]

I would like to clarify that the Netbox is up and running, but I do not know what potential damage was or was not caused. So far I haven't found any problems.

[candlerb]

  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(

It looks like you have a plugin installed, probably called "netbox-attachments" or similar, and this is the source of the error.

I suggest you disable the plugin then re-run ./upgrade.sh and if that's OK, report the problem to the plugin author (or leave the plugin disabled).

[advoenkin]

Indeed, you are right. I did as you said and everything updated correctly. Thank you.
I will report the problem to the author of the plugin.