[Celery Failure] collectoss.tasks.github.events.collect_events: violation of unique constraint "pr-unqiue-event": Key (node_id) already exists

[MoralCode]

Task Details

• Task Name: collectoss.tasks.github.events.collect_events
• Task ID: d81cce6a-cca3-4520-8828-d94f00569980
• Arguments: ('https://github.com/ansible/galaxy_collection_archived', True)
• Keyword Args: {}

Exception

IntegrityError('(psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "pr-unqiue-event"\nDETAIL:  Key (node_id)=(MDExOkNsb3NlZEV2ZW50NDg3MTAyMDEzNg==) 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 "pr-unqiue-event"
DETAIL:  Key (node_id)=(MDExOkNsb3NlZEV2ZW50NDg3MTAyMDEzNg==) already exists.


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

Traceback (most recent call last):
  File "/collectoss/collectoss/application/db/lib.py", line 371, in bulk_insert_dicts
    connection.execute(stmnt)
  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 "pr-unqiue-event"
DETAIL:  Key (node_id)=(MDExOkNsb3NlZEV2ZW50NDg3MTAyMDEzNg==) already exists.

[SQL: INSERT INTO data.pull_request_events (pr_event_id, pull_request_id, repo_id, cntrb_id, action, action_commit_hash, created_at, issue_event_src_id, node_id, node_url, platform_id, pr_platform_event_id, tool_source, tool_version, data_source) VALUES 

[truncated for github comment length]