Duplicates in repository

[nevlkv]

Repository names identic

registry=# select * from repository where name ILIKE 'ugc/notifications-producer-cli';
 repository_id |              name              | project_id | description | pull_count | star_count |       creation_time        |        update_time         
---------------+--------------------------------+------------+-------------+------------+------------+----------------------------+----------------------------
        110498 | ugc/notifications-producer-cli |         80 |             |         51 |          0 | 2023-06-09 06:58:45.735555 | 2023-09-10 12:45:17.833493
        123525 | ugc/notifications-producer-cli |         80 |             |        286 |          0 | 2023-09-11 05:39:43.378043 | 2023-10-17 23:18:13.397831
(2 rows)

registry=# insert into repository(name,project_id) values('ugc/notifications-producer-cli',80);
ERROR:  duplicate key value violates unique constraint "repository_name_key"
DETAIL:  Key (name)=(ugc/notifications-producer-cli) already exists.

registry=# \d+ repository;
                                                                   Table "public.repository"
    Column     |            Type             | Collation | Nullable |                      Default                      | Storage  | Stats target | Description 
---------------+-----------------------------+-----------+----------+---------------------------------------------------+----------+--------------+-------------
 repository_id | integer                     |           | not null | nextval('repository_repository_id_seq'::regclass) | plain    |              | 
 name          | character varying(255)      |           | not null |                                                   | extended |              | 
 project_id    | integer                     |           | not null |                                                   | plain    |              | 
 description   | text                        |           |          |                                                   | extended |              | 
 pull_count    | integer                     |           | not null | 0                                                 | plain    |              | 
 star_count    | integer                     |           | not null | 0                                                 | plain    |              | 
 creation_time | timestamp without time zone |           |          | CURRENT_TIMESTAMP                                 | plain    |              | 
 update_time   | timestamp without time zone |           |          | CURRENT_TIMESTAMP                                 | plain    |              | 
Indexes:
    "repository_pkey" PRIMARY KEY, btree (repository_id)
    "repository_name_key" UNIQUE CONSTRAINT, btree (name)
Triggers:
    repository_update_time_at_modtime BEFORE UPDATE ON repository FOR EACH ROW EXECUTE FUNCTION update_update_time_at_column()
Access method: heap

• harbor version: 2.8.4

[stonezdj]

It seems the unique constraint doesn't work.
Please refer the workaround #17544 (comment)

[MinerYang]

Have you done any upgrade between create these two repository? if any upgrade happened, form which version to current one?

[github-actions]

This issue is being marked stale due to a period of inactivity. If this issue is still relevant, please comment or remove the stale label. Otherwise, this issue will close in 30 days.

[github-actions]

This issue was closed because it has been stalled for 30 days with no activity. If this issue is still relevant, please re-open a new issue.