Database statement timeout retrieving issues for GitLab CE
Attempting to retrieve 100 GitLab CE issues results in an error due to a statement timeout.
https://sentry.gitlap.com/gitlab/gitlabcom/issues/118185/
PG::QueryCanceled: ERROR: canceling statement due to statement timeout
lib/api/helpers/pagination.rb:15:in `add_pagination_headers'
header 'X-Total', paginated_data.total_count.to_s
lib/api/helpers/pagination.rb:8:in `block in paginate'
add_pagination_headers(data)
lib/api/helpers/pagination.rb:7:in `tap'
relation.page(params[:page]).per(params[:per_page]).tap do |data|
lib/api/helpers/pagination.rb:7:in `paginate'
relation.page(params[:page]).per(params[:per_page]).tap do |data|
lib/api/v3/issues.rb:112:in `block (2 levels) in <class:Issues>'
present paginate(issues), with: ::API::V3::Entities::Issue, current_user: current_user, project: user_project
...
(138 additional frame(s) were not displayed)
ActiveRecord::StatementInvalid: PG::QueryCanceled: ERROR: canceling statement due to statement timeout
: SELECT COUNT(DISTINCT "issues"."id") FROM "issues" LEFT OUTER JOIN "notes" ON "notes"."noteable_id" = "issues"."id" AND "notes"."noteable_type" = 'Issue' LEFT OUTER JOIN "projects" ON "projects"."id" = "notes"."project_id" LEFT OUTER JOIN "users" ON "users"."id" = "notes"."author_id" LEFT OUTER JOIN "award_emoji" ON "award_emoji"."awardable_id" = "notes"."id" AND "award_emoji"."awardable_type" = 'Note' WHERE "issues"."deleted_at" IS NULL AND "issues"."project_id" = 13083
ActiveRecord::StatementInvalid: PG::QueryCanceled: ERROR: canceling statement due to statement timeout
: SELECT COUNT(DISTINCT "issues"."id") FROM "issues" LEFT OUTER JOIN "notes" ON "notes"."noteable_id" = "issues"."id" AND "notes"."noteable_type" = 'Issue' LEFT OUTER JOIN "projects" ON "projects"."id" = "notes"."project_id" LEFT OUTER JOIN "users" ON "users"."id" = "notes"."author_id" LEFT OUTER JOIN "award_emoji" ON "award_emoji"."awardable_id" = "notes"."id" AND "award_emoji"."awardable_type" = 'Note' WHERE "issues"."deleted_at" IS NULL AND "issues"."project_id" = 13083