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:

SELECT "notes".* FROM "notes" WHERE "notes"."noteable_id" = $1 AND "notes"."noteable_type" = $2

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 (closed) which addresses nil position errors in UpdateDiffPositionService