Skip to content

Indexer-Storage: UndefinedFunction: operator does not exist: sha1 = text

Sentry Issue: SWH-INDEXER-WQ

UndefinedFunction: operator does not exist: sha1 = text
LINE 5:                 on c.id=t.id
                               ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.

(7 additional frame(s) were not displayed)
...
  File "swh/indexer/storage/__init__.py", line 430, in content_metadata_get
    for c in db.content_metadata_get_from_list(ids, cur)
  File "swh/indexer/storage/__init__.py", line 427, in <listcomp>
    ContentMetadataRow.from_dict(
  File "swh/indexer/storage/db.py", line 246, in content_metadata_get_from_list
    "content_metadata", ids, self.content_metadata_cols, cur=cur
  File "swh/indexer/storage/db.py", line 125, in _get_from_list
    yield from execute_values_generator(cur, query, ((_id,) for _id in ids))
  File "swh/core/db/db_utils.py", line 478, in execute_values_generator
    cur.execute(b"".join(parts))