[Bug]: Agents - concurrents file deletion requests erratic behaviour

[thingersoft]

What happened?

Concurrent file deletion requests for agents RAG tool can lead to inconsistent DB state.
In these cases the tool resouce file ids array contains entries for deleted files.

Similarly to #4746 on server side the agent update logic includes two async operations, one to retrieve the agent and the following to update it based on the previously retrieved data.
With multiple concurrent requests being processed the retrieved data can become stale, causing the reported issue.

Steps to Reproduce

1. configure RAG
2. configure an agent
3. enable file search for the agent
4. upload 2 documents
5. while debugging put a breakpoint just after the agent retrieval in removeAgentResourceFiles from /api/models/Agent.js
6. delete the first file and wait for the request to trigger the breakpoint
7. delete the second file and wait for the request to trigger the breakpoint
8. resume the first file deletion and wait for it to complete
9. resume the second file deletion and wait for it to complete

You'll and up with the first file id still associated with the agent while no file is showing in the UI.

What browsers are you seeing the problem on?

No response

Relevant log output

No response

Screenshots

No response

Code of Conduct

• I agree to follow this project's Code of Conduct