Resolve Database DeadlockException (!3296) · Merge requests · foodsharing-dev / foodsharing · GitLab

As of 2024-05-14 a change has been implemented to enforce access token expiry. If you see higher numbers of HTTP 401 responses, please check tokens that may have expired. For more details, including how to mitigate disruption, please check our docs guide on Expired Access Tokens. If you have a support contract, you may open a support ticket for additional assistance.

Anton Ballmaier requested to merge 1869-doctrine-dbal-exception-deadlockexception-an-exception-occurred-while-executing-a-query into master Apr 30, 2024

`Closes #1869 (closed)

What does this MR do?

Adds a retry mechanism to db queries in case they fail due to deadlock exceptions.

How confident are you it won't break things if deployed?

quite confident. Not sure though if it solves the issue. In case it doesn't we might want to try slightly randomizing the wait time.

Checklist

added a test, or explain why one is not needed/possible...
no unrelated changes
asked someone for a code review
set a "for:" label to indicate who will be affected by this change
added to the next milestone (see https://gitlab.com/foodsharing-dev/foodsharing/-/milestones, unless it has a "for:Dev" label)
added an entry to `CHANGELOG.md

Edited Apr 30, 2024 by Anton Ballmaier