ActiveRecord::StatementInvalid: PG::SyntaxError: ERROR: subquery has too many columns
https://sentry.gitlap.com/gitlab/gitlabcom/issues/110807/
PG::SyntaxError: ERROR: subquery has too many columns
LINE 1: ...d" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT...
^
app/models/concerns/issuable.rb:214:in `labels_hash'
relation.pluck(:id, 'labels.title').each do |issue_id, label|
app/services/issues/export_csv_service.rb:11:in `initialize'
@labels = @issues.labels_hash
lib/gitlab/metrics/instrumentation.rb:159:in `block in initialize'
.measure { super }
lib/gitlab/metrics/method_call.rb:53:in `measure'
retval = yield
lib/gitlab/metrics/instrumentation.rb:159:in `initialize'
.measure { super }
...
(59 additional frame(s) were not displayed)
ActiveRecord::StatementInvalid: PG::SyntaxError: ERROR: subquery has too many columns
LINE 1: ...d" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT...
^
: SELECT "issues"."id", labels.title FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_id" = "issues"."id" AND "label_links"."target_type" = 'Issue' LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT issues.*, (SELECT MIN("label_priorities"."priority") FROM "labels" INNER JOIN "label_links" ON "label_links"."label_id" = "labels"."id" LEFT OUTER JOIN "label_priorities" ON "labels"."id" = "label_priorities"."label_id" WHERE (label_priorities.project_id = issues.project_id) AND (label_links.target_id = issues.id) AND "label_links"."target_type" = 'Issue') AS highest_priority, MIN(milestones.due_date), "issues"."id" FROM "issues" LEFT OUTER JOIN milestones ON issues.milestone_id = milestones.id WHERE "issues"."deleted_at" IS NULL AND ("issues"."state" IN ('opened')) AND "issues"."project_id" = 1910488 GROUP BY "issues"."id" ORDER BY MIN(milestones.due_date) ASC NULLS LAST, highest_priority ASC NULLS LAST, "issues"."id" DESC)
PG::SyntaxError: ERROR: subquery has too many columns
LINE 1: ...d" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT...
^
: SELECT "issues"."id", labels.title FROM "issues" LEFT OUTER JOIN "label_links" ON "label_links"."target_id" = "issues"."id" AND "label_links"."target_type" = 'Issue' LEFT OUTER JOIN "labels" ON "labels"."id" = "label_links"."label_id" WHERE "issues"."id" IN (SELECT issues.*, (SELECT MIN("label_priorities"."priority") FROM "labels" INNER JOIN "label_links" ON "label_links"."label_id" = "labels"."id" LEFT OUTER JOIN "label_priorities" ON "labels"."id" = "label_priorities"."label_id" WHERE (label_priorities.project_id = issues.project_id) AND (label_links.target_id = issues.id) AND "label_links"."target_type" = 'Issue') AS highest_priority, MIN(milestones.due_date), "issues"."id" FROM "issues" LEFT OUTER JOIN milestones ON issues.milestone_id = milestones.id WHERE "issues"."deleted_at" IS NULL AND ("issues"."state" IN ('opened')) AND "issues"."project_id" = 1910488 GROUP BY "issues"."id" ORDER BY MIN(milestones.due_date) ASC NULLS LAST, highest_priority ASC NULLS LAST, "issues"."id" DESC)
/cc @smcgivern