fix(backend.storage): spectrogramPaths query can Timeout

[mathieudpnt]

During a verification phase, the loading time is quite long, I sometimes have an error message too. This might be due to datarmor and/or the way APLOSE search for the tasks ?

[ElodieENSTA]

504 : Gateway Timeout
-> The request doesn't response within an appropriate amount of time (30s in production if I remember)

On annotation page, the query can also try to access files on the storage, so it could be APLOSE or Datarmor at this point.

Can you give me the url that cause the issue? Or at least the campaign?

[mathieudpnt]

504 : Gateway Timeout -> The request doesn't response within an appropriate amount of time (30s in production if I remember)

On annotation page, the query can also try to access files on the storage, so it could be APLOSE or Datarmor at this point.

Can you give me the url that cause the issue? Or at least the campaign?

One of the verif campaign i'm currently working on is "double_check_apocado_C16D1", i filter out task with no detections then I double checked each remaining task

[ElodieENSTA]

Actually this query is a 3-in-1 query.

I tested each one separatly and the spectrogramPaths cause the issue, on my two tests I got a 504 (Timeout after 1min) and then an answer after 23s. Too long!

=> I must update the Spectrogram-Analysis relation model to store the spectrogram/audio paths relative to the dataset for each analysis in the database

[ElodieENSTA]

Solution in three steps:

1. [Dev] Creation of a SpectrogramAnalysisRelation model with spectrogram_path and audio_path fields
2. [Use] Call "Store path" action on every spectrogram analysis and Check that every SpectrogramAnalysisRelation has spectrogram_path filled
3. [Dev] Clean useless code: make spectrogram_path mandatory and remove "Store path" action. And in gql query, recover these paths from the relation node