Skip to content

Instantly share code, notes, and snippets.

@AlanCoding
Created September 5, 2024 13:32
Show Gist options
  • Save AlanCoding/8579e072400e07d6347e43611600d319 to your computer and use it in GitHub Desktop.
Save AlanCoding/8579e072400e07d6347e43611600d319 to your computer and use it in GitHub Desktop.
2024-09-04 19:22:58,406 INFO [60b4e28e] awx.api.authentication User admin performed a DELETE to /api/v2/users/2/ through the API using OAuth 2 token 1.
2024-09-04 19:22:58,618 ERROR [60b4e28e] django.request Internal Server Error: /api/v2/users/2/
Traceback (most recent call last):
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/backends/base/base.py", line 313, in _commit
 return self.connection.commit()
 ^^^^^^^^^^^^^^^^^^^^^^^^
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/connection.py", line 896, in commit
 self.wait(self._commit_gen())
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/connection.py", line 969, in wait
 return waiting.wait(gen, self.pgconn.socket, timeout=timeout)
 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/waiting.py", line 350, in wait_poll
 s = gen.send(ready)
 ^^^^^^^^^^^^^^^
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/connection.py", line 538, in _commit_gen
 yield from self._exec_command(b"COMMIT")
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/connection.py", line 472, in _exec_command
 raise e.error_from_result(result, encoding=pgconn_encoding(self.pgconn))
psycopg.errors.ForeignKeyViolation: insert or update on table "main_activitystream_user" violates foreign key constraint "main_activitystream_user_user_id_435f8320_fk_auth_user_id"
DETAIL: Key (user_id)=(2) is not present in table "auth_user".

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

Traceback (most recent call last):
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/core/handlers/exception.py", line 55, in inner
 response = get_response(request)
 ^^^^^^^^^^^^^^^^^^^^^
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/core/handlers/base.py", line 197, in _get_response
 response = wrapped_callback(request, *callback_args, **callback_kwargs)
 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
 File "/usr/lib64/python3.11/contextlib.py", line 80, in inner
 with self._recreate_cm():
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/transaction.py", line 263, in __exit__
 connection.commit()
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/utils/asyncio.py", line 26, in inner
 return func(*args, **kwargs)
 ^^^^^^^^^^^^^^^^^^^^^
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/backends/base/base.py", line 337, in commit
 self._commit()
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/backends/base/base.py", line 312, in _commit
 with debug_transaction(self, "COMMIT"), self.wrap_database_errors:
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/utils.py", line 91, in __exit__
 raise dj_exc_value.with_traceback(traceback) from exc_value
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/backends/base/base.py", line 313, in _commit
 return self.connection.commit()
 ^^^^^^^^^^^^^^^^^^^^^^^^
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/connection.py", line 896, in commit
 self.wait(self._commit_gen())
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/connection.py", line 969, in wait
 return waiting.wait(gen, self.pgconn.socket, timeout=timeout)
 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/waiting.py", line 350, in wait_poll
 s = gen.send(ready)
 ^^^^^^^^^^^^^^^
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/connection.py", line 538, in _commit_gen
 yield from self._exec_command(b"COMMIT")
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/connection.py", line 472, in _exec_command
 raise e.error_from_result(result, encoding=pgconn_encoding(self.pgconn))
django.db.utils.IntegrityError: insert or update on table "main_activitystream_user" violates foreign key constraint "main_activitystream_user_user_id_435f8320_fk_auth_user_id"
DETAIL: Key (user_id)=(2) is not present in table "auth_user".
2024-09-04 19:22:58,618 ERROR [60b4e28e] django.request Internal Server Error: /api/v2/users/2/
Traceback (most recent call last):
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/backends/base/base.py", line 313, in _commit
 return self.connection.commit()
 ^^^^^^^^^^^^^^^^^^^^^^^^
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/connection.py", line 896, in commit
 self.wait(self._commit_gen())
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/connection.py", line 969, in wait
 return waiting.wait(gen, self.pgconn.socket, timeout=timeout)
 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/waiting.py", line 350, in wait_poll
 s = gen.send(ready)
 ^^^^^^^^^^^^^^^
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/connection.py", line 538, in _commit_gen
 yield from self._exec_command(b"COMMIT")
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/connection.py", line 472, in _exec_command
 raise e.error_from_result(result, encoding=pgconn_encoding(self.pgconn))
psycopg.errors.ForeignKeyViolation: insert or update on table "main_activitystream_user" violates foreign key constraint "main_activitystream_user_user_id_435f8320_fk_auth_user_id"
DETAIL: Key (user_id)=(2) is not present in table "auth_user".

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

Traceback (most recent call last):
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/core/handlers/exception.py", line 55, in inner
 response = get_response(request)
 ^^^^^^^^^^^^^^^^^^^^^
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/core/handlers/base.py", line 197, in _get_response
 response = wrapped_callback(request, *callback_args, **callback_kwargs)
 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
 File "/usr/lib64/python3.11/contextlib.py", line 80, in inner
 with self._recreate_cm():
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/transaction.py", line 263, in __exit__
 connection.commit()
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/utils/asyncio.py", line 26, in inner
 return func(*args, **kwargs)
 ^^^^^^^^^^^^^^^^^^^^^
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/backends/base/base.py", line 337, in commit
 self._commit()
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/backends/base/base.py", line 312, in _commit
 with debug_transaction(self, "COMMIT"), self.wrap_database_errors:
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/utils.py", line 91, in __exit__
 raise dj_exc_value.with_traceback(traceback) from exc_value
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/django/db/backends/base/base.py", line 313, in _commit
 return self.connection.commit()
 ^^^^^^^^^^^^^^^^^^^^^^^^
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/connection.py", line 896, in commit
 self.wait(self._commit_gen())
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/connection.py", line 969, in wait
 return waiting.wait(gen, self.pgconn.socket, timeout=timeout)
 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/waiting.py", line 350, in wait_poll
 s = gen.send(ready)
 ^^^^^^^^^^^^^^^
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/connection.py", line 538, in _commit_gen
 yield from self._exec_command(b"COMMIT")
 File "/var/lib/awx/venv/awx/lib64/python3.11/site-packages/psycopg/connection.py", line 472, in _exec_command
 raise e.error_from_result(result, encoding=pgconn_encoding(self.pgconn))
django.db.utils.IntegrityError: insert or update on table "main_activitystream_user" violates foreign key constraint "main_activitystream_user_user_id_435f8320_fk_auth_user_id"
DETAIL: Key (user_id)=(2) is not present in table "auth_user".
[pid: 583|app: 0|req: 159/682] 172.19.0.1 () {40 vars in 493 bytes} [Wed Sep 4 19:22:58 2024] DELETE /api/v2/users/2/ => generated 262243 bytes in 224 msecs (HTTP/1.1 500) 7 headers in 282 bytes (1 switches on core 0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment