[GARBAGE_COLLECTION] SQL Error on execution table

[sebglon]

Hi,

I have this error on my logs:

2023-10-27T07:00:00Z [INFO] [/pkg/task/sweep_job.go:150]: [GARBAGE_COLLECTION] start to sweep, retain latest 50 executions
2023-10-27T07:00:00Z [INFO] [/pkg/task/sweep_job.go:160]: [GARBAGE_COLLECTION] listed 73 candidate executions for sweep
2023-10-27T07:00:00Z [ERROR] [/pkg/task/sweep_job.go:175]: [GARBAGE_COLLECTION] failed to batch clean candidates, error: failed to delete executions: ERROR: update or delete on table "execution" violates foreign key constraint "task_execution_id_fkey" on
2023-10-27T07:00:00Z [ERROR] [/pkg/task/sweep_job.go:110]: [GARBAGE_COLLECTION] failed to run sweep, error: failed to delete executions: ERROR: update or delete on table "execution" violates foreign key constraint "task_execution_id_fkey" on table "task"

Versions:
Please specify the versions of following systems.

• harbor version: [2.8.3 & 2.9.0]

[sebglon]

After manually dropping all execution and task related to GC, i have no more error;
Request applied:

delete from task where execution_id in (select id from execution where vendor_type='GARBAGE_COLLECTION');
delete from execution where vendor_type='GARBAGE_COLLECTION'; 

[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.