Timeout when deleting a report and resulting corrupted data

[Lhorus6]

Description

Deleting a report failed. Looking in the logs, it appears to be a timeout. The timeout happens quite quickly, like 1 minute (AFAIK, it should be 5 minutes).

Looking in Elastic, it appears that the report ID has been removed from the entities contained in the report (at least in part of the entities). However, the report still has its object_ref, and the internal_relation still exists. -> The start of the deletion was therefore made, but stopped in the middle.

NB: @SouadHadjiat knows the situation, otherwise you can ping me.

Environment

OCTI 6.4.1

Reproducible Steps

The problematic report is in one of our SaaS platforms. It contains around 150 entities, and 70 inferred relationships.

I was unable to reproduce the problem by creating a report with the same characteristics.

Expected Output

Be able to delete my entity

And, if it fails, I don't want to end up with a corrupted database after only partially deleting things and stopped in the middle of cleaning.

Additional information

Note not necessarily related to this bug:

If we reach a timeout when deleting an element, we end up with corrupted entities! This approach should perhaps be reviewed.

[nino-filigran]

Could not reproduce either, but @Lhorus6 & @SouadHadjiat seem to be aware of the situation.
I guess the fix should be to either extend the timeout or to prevent timing-out when a deletion occurs.