UpdateMergeRequestWorker timing out on SQL queries
## SQL Query Timeout in UpdateMergeRequestWorker ### Description The UpdateMergeRequestWorker is experiencing timeouts on SQL queries, specifically when querying notes by noteable_id and noteable_type, and when querying merge request diff commits. ### Error Details - Worker: UpdateMergeRequestWorker - Queries timing out: ```sql SELECT "notes".* FROM "notes" WHERE "notes"."noteable_id" = $1 AND "notes"."noteable_type" = $2 ``` ```sql SELECT "merge_request_diff_commits".* FROM "merge_request_diff_commits" WHERE "merge_request_diff_commits"."merge_request_diff_id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30) ``` ### Postgres ai https://console.postgres.ai/gitlab/gitlab-production-main/sessions/42092/commands/129059 ### Kibana Links - Specific query timeout: https://log.gprd.gitlab.net/app/r/s/gbeZz - Worker timeout logs: https://log.gprd.gitlab.net/app/r/s/mShEe ### Related Issues Similar to #559084 which addresses nil position errors in UpdateDiffPositionService
issue