The digest field in the blob table contains duplicate values

[devopslyf]

table structure:

duplicate data:

harbor version: v2.4.2

postgresql version: 11.13.0

[devopslyf]

Can I delete one of them, and if so, how can I determine which one to delete?

[stonezdj]

It looks similar to this issue: #17544,
You can refer the wiki: https://github.com/goharbor/harbor/wiki/Harbor-FAQs#duplicate-repository-name-in-the-same-project
Because the blob ID is not referenced in other table, delete any should work.

[devopslyf]

@stonezdj Is the reindex operation indispensable?

[stonezdj]

Yes, because previous index file is corrupted, you need to rebuild it by reindex. please always use the latest supported version.