IntegrityError when deleting a CO that is referenced by another CO

[mrmrcoleman]

Plugin Version

0.4.1

NetBox Version

4.4.5

Python Version

Python 3.12.3

Steps to Reproduce

• Create COT B
• Create COT A
• Add COTF (Object) to COT A that points to COT B
• Create a CO (type B)
• Create a CO (type A) that point to CO (type B)
• Delete CO (type B)

Expected Behavior

My assumption that we are using on_delete = CASCADE so I would expect to be warned that deleting the CO (type B) would also delete the CO (type A)

Observed Behaviour

<class 'django.db.utils.IntegrityError'>

update or delete on table "custom_objects_1" violates foreign key constraint "custom_objects_2_relation_id_4e48eab4_fk_custom_objects_1_id" on table "custom_objects_2"
DETAIL:  Key (id)=(1) is still referenced from table "custom_objects_2".

Python version: 3.12.3
NetBox version: 4.4.5-Docker-3.4.2
Plugins: 
  netbox_branching: 0.7.2
  netbox_changes: 0.4.0
  netbox_custom_objects: 0.4.1

[arthanson]

Traceback (most recent call last):
  File "/Users/ahanson/dev/work/netbox/venv/lib/python3.13/site-packages/django/core/handlers/exception.py", line 55, in inner
    response = get_response(request)
  File "/Users/ahanson/dev/work/netbox/venv/lib/python3.13/site-packages/django/core/handlers/base.py", line 197, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "/Users/ahanson/dev/work/netbox/venv/lib/python3.13/site-packages/django/views/generic/base.py", line 105, in view
    return self.dispatch(request, *args, **kwargs)
           ~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/ahanson/dev/work/netbox/netbox/netbox/views/generic/base.py", line 26, in dispatch
    return super().dispatch(request, *args, **kwargs)
           ~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/ahanson/dev/work/netbox/netbox/utilities/views.py", line 144, in dispatch
    return super().dispatch(request, *args, **kwargs)
           ~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/ahanson/dev/work/netbox/netbox/utilities/views.py", line 45, in dispatch
    return super().dispatch(request, *args, **kwargs)
           ~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/ahanson/dev/work/netbox/venv/lib/python3.13/site-packages/django/views/generic/base.py", line 144, in dispatch
    return handler(request, *args, **kwargs)
  File "/Users/ahanson/dev/work/netbox/netbox/netbox/views/generic/object_views.py", line 480, in post
    obj.delete()
    ~~~~~~~~~~^^
  File "/Users/ahanson/dev/work/netbox/netbox/netbox/models/deletion.py", line 81, in delete
    return collector.delete()
           ~~~~~~~~~~~~~~~~^^
  File "/Users/ahanson/dev/work/netbox/venv/lib/python3.13/site-packages/django/db/models/deletion.py", line 454, in delete
    with transaction.atomic(using=self.using, savepoint=False):
         ~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/ahanson/dev/work/netbox/venv/lib/python3.13/site-packages/django/db/transaction.py", line 263, in __exit__
    connection.commit()
    ~~~~~~~~~~~~~~~~~^^
  File "/Users/ahanson/dev/work/netbox/venv/lib/python3.13/site-packages/django/utils/asyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "/Users/ahanson/dev/work/netbox/venv/lib/python3.13/site-packages/django/db/backends/base/base.py", line 327, in commit
    self._commit()
    ~~~~~~~~~~~~^^
  File "/Users/ahanson/dev/work/netbox/venv/lib/python3.13/site-packages/django/db/backends/base/base.py", line 302, in _commit
    with debug_transaction(self, "COMMIT"), self.wrap_database_errors:
                                            ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/ahanson/dev/work/netbox/venv/lib/python3.13/site-packages/django/db/utils.py", line 91, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/Users/ahanson/dev/work/netbox/venv/lib/python3.13/site-packages/django/db/backends/base/base.py", line 303, in _commit
    return self.connection.commit()
           ~~~~~~~~~~~~~~~~~~~~~~^^
  File "/Users/ahanson/dev/work/netbox/venv/lib/python3.13/site-packages/psycopg/connection.py", line 274, in commit
    self.wait(self._commit_gen())
    ~~~~~~~~~^^^^^^^^^^^^^^^^^^^^
  File "/Users/ahanson/dev/work/netbox/venv/lib/python3.13/site-packages/psycopg/connection.py", line 453, in wait
    return waiting.wait(gen, self.pgconn.socket, interval=interval)
           ~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "psycopg_c/_psycopg/waiting.pyx", line 213, in psycopg_c._psycopg.wait_c
  File "/Users/ahanson/dev/work/netbox/venv/lib/python3.13/site-packages/psycopg/_connection_base.py", line 581, in _commit_gen
    yield from self._exec_command(b"COMMIT")
  File "/Users/ahanson/dev/work/netbox/venv/lib/python3.13/site-packages/psycopg/_connection_base.py", line 479, in _exec_command
    raise e.error_from_result(result, encoding=self.pgconn._encoding)
django.db.utils.IntegrityError: update or delete on table "custom_objects_2" violates foreign key constraint "custom_objects_1_f1_id_24e1bbe4_fk_custom_objects_2_id" on table "custom_objects_1"
DETAIL:  Key (id)=(1) is still referenced from table "custom_objects_1".
****