i think am having a database error

Troubleshooting
1 
            Traceback (most recent call last):
  File "/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py", line 312, in _commit
    return self.connection.commit()
           ^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/rockstor/.venv/lib/python3.11/site-packages/psycopg/connection.py", line 262, in commit
    self.wait(self._commit_gen())
  File "/opt/rockstor/.venv/lib/python3.11/site-packages/psycopg/connection.py", line 414, in wait
    return waiting.wait(gen, self.pgconn.socket, interval=interval)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/rockstor/.venv/lib/python3.11/site-packages/psycopg/waiting.py", line 354, in wait_poll
    s = gen.send(ready)
        ^^^^^^^^^^^^^^^
  File "/opt/rockstor/.venv/lib/python3.11/site-packages/psycopg/_connection_base.py", line 580, in _commit_gen
    yield from self._exec_command(b"COMMIT")
  File "/opt/rockstor/.venv/lib/python3.11/site-packages/psycopg/_connection_base.py", line 478, in _exec_command
    raise e.error_from_result(result, encoding=self.pgconn._encoding)
psycopg.errors.ForeignKeyViolation: insert or update on table "storageadmin_networkdevice" violates foreign key constraint "storageadmin_network_connection_id_6a520cbf_fk_storagead"
DETAIL:  Key (connection_id)=(6) is not present in table "storageadmin_networkconnection".

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

Traceback (most recent call last):
  File "/opt/rockstor/src/rockstor/rest_framework_custom/generic_view.py", line 40, in _handle_exception
    yield
  File "/opt/rockstor/src/rockstor/storageadmin/views/network.py", line 235, in get_queryset
    self._refresh_devices()
  File "/usr/lib64/python3.11/contextlib.py", line 80, in inner
    with self._recreate_cm():
  File "/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/transaction.py", line 263, in __exit__
    connection.commit()
  File "/opt/rockstor/.venv/lib/python3.11/site-packages/django/utils/asyncio.py", line 26, in inner
    return func(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^
  File "/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py", line 336, in commit
    self._commit()
  File "/opt/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py", line 311, in _commit
    with debug_transaction(self, "COMMIT"), self.wrap_database_errors:
  File "/opt/rockstor/.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/rockstor/.venv/lib/python3.11/site-packages/django/db/backends/base/base.py", line 312, in _commit
    return self.connection.commit()
           ^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/rockstor/.venv/lib/python3.11/site-packages/psycopg/connection.py", line 262, in commit
    self.wait(self._commit_gen())
  File "/opt/rockstor/.venv/lib/python3.11/site-packages/psycopg/connection.py", line 414, in wait
    return waiting.wait(gen, self.pgconn.socket, interval=interval)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/rockstor/.venv/lib/python3.11/site-packages/psycopg/waiting.py", line 354, in wait_poll
    s = gen.send(ready)
        ^^^^^^^^^^^^^^^
  File "/opt/rockstor/.venv/lib/python3.11/site-packages/psycopg/_connection_base.py", line 580, in _commit_gen
    yield from self._exec_command(b"COMMIT")
  File "/opt/rockstor/.venv/lib/python3.11/site-packages/psycopg/_connection_base.py", line 478, in _exec_command
    raise e.error_from_result(result, encoding=self.pgconn._encoding)
django.db.utils.IntegrityError: insert or update on table "storageadmin_networkdevice" violates foreign key constraint "storageadmin_network_connection_id_6a520cbf_fk_storagead"
DETAIL:  Key (connection_id)=(6) is not present in table "storageadmin_networkconnection".
2

Howdy!

Does the error go away on page refresh?

The following similar reports seem to suggest that will do the trick:

2 Likes