Creating a lot of relationships at once causes a timeout error

[Lhorus6]

Description

When we launch the creation of a large number of relationships in a knowledge graph, the creation process takes too long and a timeout error occurs. Here's an example of a use case where this happens: I have 350 IOCs in a report and one malware. I want to link all the IOCs with my malware, but the error occurs.

Environment

OCTI 6.0.6

Reproducible Steps

Steps to create the smallest reproducible scenario:

1. Create a repot
2. Go in the entities tab
3. Add one malware
4. Add 400 Indicators
5. Go in the knowledge graph
6. Try to create a relation between all indicators and the malware (in one run)

Screenshots

[SamuelHassine]

I confirm this has been reported several times. This is something we should address in the backend.

Current situation:

• The frontend create 400 relationships 1 by 1

Whished situation:

• The frontend send all relationships to create all things at once.

[lndrtrbn]

The frontend send all relationships to create all things at once.

Does this kind of API already exists and it's just frontend code to change? Or do we also need to create this batch relationships creation API?

[nino-filigran]

@SouadHadjiat @aHenryJard @labo-flg Do you have any idea about the above question? ☝️

[SamuelHassine]

We need a new API "stixCoreRelationshipsAdd" (plurial) in addition to "stixCoreRelationshipAdd" to batch creation of relationships.

[richard-julien]

This one is really complex to achieve. Please come talk to me before starting it

[SamuelHassine]

Assigning to Julien since we are working on removing locks on relationships nodes.

[SamuelHassine]

Will be resolved by #6361.