Cannot delete large projects

[tesence]

Current Behavior

Hello,

I am currently in a situation where Dependency Track is unable to delete a large project (25k components) and I can't tell if the problem is due to Dependency Track not being able to handle such a big request or if it's the Postgres server that is acting as a bottleneck. I'm aware that it might not be supposed to support that usecase, for now I'm just hoping to go back to a healthy state.

Note that I'm able to delete small/medium-sized project so Dependency Track is functionning overall.

Also, as suggested by the warning logs, I tried to lower the connection max life time value using ALPINE_DATABASE_POOL_MAX_LIFETIME (I'm currently running DT on a kubernetes cluster) but it does not seem to help.

Any idea of how to investigate and remedy this problem is welcome

dependency-track.log

Steps to Reproduce

1. Create a project.
2. Import a really large SBOM (in my case 60MB and 25k components).
3. Delete the projet.

Expected Behavior

The project should eventually be deleted.

Dependency-Track Version

4.12.0

Dependency-Track Distribution

Container Image

Database Server

PostgreSQL

Database Server Version

14.5

Browser

Mozilla Firefox

Checklist

• [x] I have read and understand the contributing guidelines
• [x] I have checked the existing issues for whether this defect was already reported

[tesence]

Turns out that the deletion fails if the transaction is not processed within 1min. Is there a way to increase the value ?

EDIT: The workaround is to delete as many components as you can to fall under that 1min threshold ^^'

[rerkcp]

Since you're running in Kubernetes, the 1min threshold could be the (default) timeout of your ingress. Try something like nginx.ingress.kubernetes.io/proxy-read-timeout: "300" if you're using nginx as ingress.

[ogirardot]

+1 on the issue

[frrusi]

In version 4.13.6 the problem is still present, only in my case I try to remove collection of projects