chaoss / chaoss/CollectOSS

[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"

Open
#386 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
13
Forks
17
Avg merge
6h 59m
Merged PRs (30d)
1

Description

### 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

```python
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)
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.