UniqueViolation: duplicate key value violates unique constraint "skipped_content_sha1_sha1_git_sha256_key"
Sentry Issue: SWH-STORAGE-2WXX
UniqueViolation: duplicate key value violates unique constraint "skipped_content_sha1_sha1_git_sha256_key"
DETAIL: Key (sha1, sha1_git, sha256)=(\x50411d9df99e90613fc6e436fbf25b07568985eb, \x0ae122ad07a240d40a72bb9d82813695777649c2, \x0f8fc4bad315e4e41b69d3060db2964321d7ecd0319cd053449061c23a8ddbe2) already exists.
CONTEXT: SQL statement "insert into skipped_content (sha1, sha1_git, sha256, blake2s256, length, status, reason, origin)
select distinct sha1, sha1_git, sha256, blake2s256, length, status, reason, or...
(5 additional frame(s) were not displayed)
...
File "swh/core/api/__init__.py", line 546, in f
ret = obj_meth(**kw)
File "swh/core/db/common.py", line 73, in _meth
return meth(self, *args, db=db, cur=cur, **kwargs)
File "swh/storage/postgresql/storage.py", line 586, in skipped_content_add
self._skipped_content_add_metadata(db, cur, content)
File "swh/storage/postgresql/storage.py", line 559, in _skipped_content_add_metadata
db.skipped_content_add_from_temp(cur)
File "swh/core/db/db_utils.py", line 46, in _meth
self._cursor(cur).execute("SELECT %s()" % stored_proc)