Some MR timeouts when trying to get all their pipelines
Created by @rymai.
https://sentry.gitlap.com/gitlab/gitlabcom/issues/91322/
PG::QueryCanceled: ERROR: canceling statement due to statement timeout
lib/gitlab/database/load_balancing/connection_proxy.rb:61:in `block in read_using_load_balancer'
connection.send(name, *args, &block)
lib/gitlab/database/load_balancing/load_balancer.rb:66:in `block in read_write'
yield ActiveRecord::Base.retrieve_connection
lib/gitlab/database/load_balancing/load_balancer.rb:116:in `retry_with_backoff'
return yield
lib/gitlab/database/load_balancing/load_balancer.rb:65:in `read_write'
retry_with_backoff do
lib/gitlab/database/load_balancing/connection_proxy.rb:60:in `read_using_load_balancer'
@load_balancer.send(method) do |connection|
...
(147 additional frame(s) were not displayed)
ActiveRecord::StatementInvalid: PG::QueryCanceled: ERROR: canceling statement due to statement timeout
: SELECT DISTINCT(sha) FROM "merge_request_diff_commits" WHERE "merge_request_diff_commits"."merge_request_diff_id" IN (SELECT "merge_request_diffs"."id" FROM "merge_request_diffs" WHERE "merge_request_diffs"."merge_request_id" = 4804799)
ActiveRecord::StatementInvalid: PG::QueryCanceled: ERROR: canceling statement due to statement timeout
: SELECT DISTINCT(sha) FROM "merge_request_diff_commits" WHERE "merge_request_diff_commits"."merge_request_diff_id" IN (SELECT "merge_request_diffs"."id" FROM "merge_request_diffs" WHERE "merge_request_diffs"."merge_request_id" = 4804799)