[Celery Failure] collectoss.tasks.github.util.populate_repo_src_id.populate_repo_src_id_task: IntegrityError('(psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "repo_src_id_unique"\nDETAIL: Key (repo_src_id)=(555914450) alre

[MoralCode]

Task Details

• Task Name: collectoss.tasks.github.util.populate_repo_src_id.populate_repo_src_id_task
• Task ID: 44ac2883-b04b-4685-8c5d-ca52624a11ac
• Arguments: ('https://github.com/computersciencehouse/deadass',)
• Keyword Args: {}

Exception

IntegrityError('(psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "repo_src_id_unique"\nDETAIL:  Key (repo_src_id)=(555914450) already exists.\n')

Stack Trace

Traceback (most recent call last):
  File "/collectoss/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context
    self.dialect.do_execute(
  File "/collectoss/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
    cursor.execute(statement, parameters)
psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "repo_src_id_unique"
DETAIL:  Key (repo_src_id)=(555914450) already exists.


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

Traceback (most recent call last):
  File "/collectoss/.venv/lib/python3.11/site-packages/celery/app/trace.py", line 453, in trace_task
    R = retval = fun(*args, **kwargs)
                 ^^^^^^^^^^^^^^^^^^^^
  File "/collectoss/.venv/lib/python3.11/site-packages/celery/app/trace.py", line 736, in __protected_call__
    return self.run(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/collectoss/collectoss/tasks/github/util/populate_repo_src_id.py", line 20, in populate_repo_src_id_task
    update_repo_src_id(repo_id, repo_src_id)
  File "/collectoss/collectoss/tasks/github/util/populate_repo_src_id.py", line 29, in update_repo_src_id
    execute_sql(query)
  File "/collectoss/collectoss/application/db/lib.py", line 82, in execute_sql
    return_data = connection.execute(sql_text)
                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/collectoss/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1416, in execute
    return meth(
           ^^^^^
  File "/collectoss/.venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 516, in _execute_on_connection
    return connection._execute_clauseelement(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/collectoss/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1639, in _execute_clauseelement
    ret = self._execute_context(
          ^^^^^^^^^^^^^^^^^^^^^^
  File "/collectoss/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1848, in _execute_context
    return self._exec_single_context(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/collectoss/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1988, in _exec_single_context
    self._handle_dbapi_exception(
  File "/collectoss/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2343, in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
  File "/collectoss/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context
    self.dialect.do_execute(
  File "/collectoss/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "repo_src_id_unique"
DETAIL:  Key (repo_src_id)=(555914450) already exists.

[SQL: UPDATE repo SET repo_src_id=%(repo_src_id)s WHERE repo_id=%(repo_id)s;
        ]
[parameters: {'repo_src_id': 555914450, 'repo_id': 96620}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)