DeleteUserWorker executes more than 100 SQL queries
This worker executes more than 100 SQL queries, the maximum number of queries allowed as per MR !154254 (merged). The number of queries should be reduced to less than 100 and the corresponding whitelisted sections of code (Gitlab::QueryLimiting.disable('...')
) should be removed.
See https://gitlab.com/gitlab-org/gitlab/-/pipelines/1307856850 for failing pipeline
Reference: https://docs.gitlab.com/ee/development/database/query_count_limits.html
Update 2024-08-12: Per this discussion in the update MR, we are leaving query limiting disabled and linked to this issue for DeleteUserWorker
. This worker is executed pretty rarely. Due to the nature of deleting users along with all associated projects and groups, there are just a large number of queries to run during the course of this worker.
If the worker runs over the increased 200-query limit, we should investigate breaking the worker up into smaller pieces and making user deletion more asynchronous.