ActionView::Template::Error: PG::GroupingError: ERROR: column "projects.id" must appear in the GROUP BY clause or be used in ...
https://sentry.gitlab.net/gitlab/gitlabcom/issues/564792/
PG::GroupingError: ERROR: column "projects.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...at" AS t0_r25, "issues"."closed_by_id" AS t0_r26, "projects"...
^
peek/views/pg.rb:17:in `async_exec'
super(*args)
peek/views/pg.rb:17:in `async_exec'
super(*args)
active_record/connection_adapters/postgresql_adapter.rb:592:in `block in exec_no_cache'
log(sql, name, binds) { @connection.async_exec(sql, []) }
active_record/connection_adapters/abstract_adapter.rb:484:in `block in log'
:binds => binds) { yield }
active_support/notifications/instrumenter.rb:20:in `instrument'
yield payload
...
(196 additional frame(s) were not displayed)
ActiveRecord::StatementInvalid: PG::GroupingError: ERROR: column "projects.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...at" AS t0_r25, "issues"."closed_by_id" AS t0_r26, "projects"...
^
: SELECT "issues"."id" AS t0_r0, "issues"."title" AS t0_r1, "issues"."author_id" AS t0_r2, "issues"."project_id" AS t0_r3, "issues"."created_at" AS t0_r4, "issues"."updated_at" AS t0_r5, "issues"."description" AS t0_r6, "issues"."milestone_id" AS t0_r7, "issues"."state" AS t0_r8, "issues"."iid" AS t0_r9, "issues"."updated_by_id" AS t0_r10, "issues"."weight" AS t0_r11, "issues"."confidential" AS t0_r12, "issues"."moved_to_id" AS t0_r13, "issues"."due_date" AS t0_r14, "issues"."lock_version" AS t0_r15, "issues"."title_html" AS t0_r16, "issues"."description_html" AS t0_r17, "issues"."time_estimate" AS t0_r18, "issues"."relative_position" AS t0_r19, "issues"."service_desk_reply_to" AS t0_r20, "issues"."cached_markdown_version" AS t0_r21, "issues"."last_edited_at" AS t0_r22, "issues"."last_edited_by_id" AS t0_r23, "issues"."discussion_locked" AS t0_r24, "issues"."closed_at" AS t0_r25, "issues"."closed_by_id" AS t0_r26, "projects"."id" AS t1_r0, "projects"."name" AS t1_r1, "projects"."path" AS t1_r2, "projects"."description" AS t1_r3, "projects"."created_at" AS t1_r4, "projects"."updated_at" AS t1_r5, "projects"."creator_id" AS t1_r6, "projects"."namespace_id" AS t1_r7, "projects"."last_activity_at" AS t1_r8, "projects"."import_url" AS t1_r9, "projects"."visibility_level" AS t1_r10, "projects"."archived" AS t1_r11, "projects"."import_status" AS t1_r12, "projects"."merge_requests_template" AS t1_r13, "projects"."star_count" AS t1_r14, "projects"."merge_requests_rebase_enabled" AS t1_r15, "projects"."import_type" AS t1_r16, "projects"."import_source" AS t1_r17, "projects"."avatar" AS t1_r18, "projects"."approvals_before_merge" AS t1_r19, "projects"."reset_approvals_on_push" AS t1_r20, "projects"."merge_requests_ff_only_enabled" AS t1_r21, "projects"."issues_template" AS t1_r22, "projects"."mirror" AS t1_r23, "projects"."mirror_last_update_at" AS t1_r24, "projects"."mirror_last_successful_update_at" AS t1_r25, "projects"."mirror_user_id" AS t1_r26, "projects"."import_error" AS t1_r27, "projects"."ci_id" AS t1_r28, "projects"."shared_runners_enabled" AS t1_r29, "projects"."runners_token" AS t1_r30, "projects"."build_coverage_regex" AS t1_r31, "projects"."build_allow_git_fetch" AS t1_r32, "projects"."build_timeout" AS t1_r33, "projects"."mirror_trigger_builds" AS t1_r34, "projects"."public_builds" AS t1_r35, "projects"."pending_delete" AS t1_r36, "projects"."last_repository_check_failed" AS t1_r37, "projects"."last_repository_check_at" AS t1_r38, "projects"."container_registry_enabled" AS t1_r39, "projects"."only_allow_merge_if_pipeline_succeeds" AS t1_r40, "projects"."has_external_issue_tracker" AS t1_r41, "projects"."repository_storage" AS t1_r42, "projects"."request_access_enabled" AS t1_r43, "projects"."has_external_wiki" AS t1_r44, "projects"."repository_read_only" AS t1_r45, "projects"."lfs_enabled" AS t1_r46, "projects"."description_html" AS t1_r47, "projects"."only_allow_merge_if_all_discussions_are_resolved" AS t1_r48, "projects"."repository_size_limit" AS t1_r49, "projects"."service_desk_enabled" AS t1_r50, "projects"."printing_merge_request_link_enabled" AS t1_r51, "projects"."auto_cancel_pending_pipelines" AS t1_r52, "projects"."import_jid" AS t1_r53, "projects"."cached_markdown_version" AS t1_r54, "projects"."last_repository_updated_at" AS t1_r55, "projects"."ci_config_path" AS t1_r56, "projects"."disable_overriding_approvers_per_merge_request" AS t1_r57, "projects"."delete_error" AS t1_r58, "projects"."storage_version" AS t1_r59, "projects"."resolve_outdated_diff_discussions" AS t1_r60, "projects"."remote_mirror_available_overridden" AS t1_r61, "projects"."only_mirror_protected_branches" AS t1_r62, "projects"."pull_mirror_available_overridden" AS t1_r63, "projects"."jobs_cache_index" AS t1_r64, "projects"."external_authorization_classification_label" AS t1_r65, ...
ActionView::Template::Error: PG::GroupingError: ERROR: column "projects.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...at" AS t0_r25, "issues"."closed_by_id" AS t0_r26, "projects"...
^
: SELECT "issues"."id" AS t0_r0, "issues"."title" AS t0_r1, "issues"."author_id" AS t0_r2, "issues"."project_id" AS t0_r3, "issues"."created_at" AS t0_r4, "issues"."updated_at" AS t0_r5, "issues"."description" AS t0_r6, "issues"."milestone_id" AS t0_r7, "issues"."state" AS t0_r8, "issues"."iid" AS t0_r9, "issues"."updated_by_id" AS t0_r10, "issues"."weight" AS t0_r11, "issues"."confidential" AS t0_r12, "issues"."moved_to_id" AS t0_r13, "issues"."due_date" AS t0_r14, "issues"."lock_version" AS t0_r15, "issues"."title_html" AS t0_r16, "issues"."description_html" AS t0_r17, "issues"."time_estimate" AS t0_r18, "issues"."relative_position" AS t0_r19, "issues"."service_desk_reply_to" AS t0_r20, "issues"."cached_markdown_version" AS t0_r21, "issues"."last_edited_at" AS t0_r22, "issues"."last_edited_by_id" AS t0_r23, "issues"."discussion_locked" AS t0_r24, "issues"."closed_at" AS t0_r25, "issues"."closed_by_id" AS t0_r26, "projects"."id" AS t1_r0, "projects"."name" AS t1_r1, "projects"."path" AS t1_r2, "projects"."description" AS t1_r3, "projects"."created_at" AS t1_r4, "projects"."updated_at" AS t1_r5, "projects"."creator_id" AS t1_r6, "projects"."namespace_id" AS t1_r7, "projects"."last_activity_at" AS t1_r8, "projects"."import_url" AS t1_r9, "projects"."visibility_level" AS t1_r10, "projects"."archived" AS t1_r11, "projects"."import_status" AS t1_r12, "projects"."merge_requests_template" AS t1_r13, "projects"."star_count" AS t1_r14, "projects"."merge_requests_rebase_enabled" AS t1_r15, "projects"."import_type" AS t1_r16, "projects"."import_source" AS t1_r17, "projects"."avatar" AS t1_r18, "projects"."approvals_before_merge" AS t1_r19, "projects"."reset_approvals_on_push" AS t1_r20, "projects"."merge_requests_ff_only_enabled" AS t1_r21, "projects"."issues_template" AS t1_r22, "projects"."mirror" AS t1_r23, "projects"."mirror_last_update_at" AS t1_r24, "projects"."mirror_last_successful_update_at" AS t1_r25, "projects"."mirror_user_id" AS t1_r26, "projects"."import_error" AS t1_r27, "projects"."ci_id" AS t1_r28, "projects"."shared_runners_enabled" AS t1_r29, "projects"."runners_token" AS t1_r30, "projects"."build_coverage_regex" AS t1_r31, "projects"."build_allow_git_fetch" AS t1_r32, "projects"."build_timeout" AS t1_r33, "projects"."mirror_trigger_builds" AS t1_r34, "projects"."public_builds" AS t1_r35, "projects"."pending_delete" AS t1_r36, "projects"."last_repository_check_failed" AS t1_r37, "projects"."last_repository_check_at" AS t1_r38, "projects"."container_registry_enabled" AS t1_r39, "projects"."only_allow_merge_if_pipeline_succeeds" AS t1_r40, "projects"."has_external_issue_tracker" AS t1_r41, "projects"."repository_storage" AS t1_r42, "projects"."request_access_enabled" AS t1_r43, "projects"."has_external_wiki" AS t1_r44, "projects"."repository_read_only" AS t1_r45, "projects"."lfs_enabled" AS t1_r46, "projects"."description_html" AS t1_r47, "projects"."only_allow_merge_if_all_discussions_are_resolved" AS t1_r48, "projects"."repository_size_limit" AS t1_r49, "projects"."service_desk_enabled" AS t1_r50, "projects"."printing_merge_request_link_enabled" AS t1_r51, "projects"."auto_cancel_pending_pipelines" AS t1_r52, "projects"."import_jid" AS t1_r53, "projects"."cached_markdown_version" AS t1_r54, "projects"."last_repository_updated_at" AS t1_r55, "projects"."ci_config_path" AS t1_r56, "projects"."disable_overriding_approvers_per_merge_request" AS t1_r57, "projects"."delete_error" AS t1_r58, "projects"."storage_version" AS t1_r59, "projects"."resolve_outdated_diff_discussions" AS t1_r60, "projects"."remote_mirror_available_overridden" AS t1_r61, "projects"."only_mirror_protected_branches" AS t1_r62, "projects"."pull_mirror_available_overridden" AS t1_r63, "projects"."jobs_cache_index" AS t1_r64, "projects"."external_authorization_classification_label" AS t1_r65, ...
ActionView::Template::Error: PG::GroupingError: ERROR: column "projects.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...at" AS t0_r25, "issues"."closed_by_id" AS t0_r26, "projects"...
^
: SELECT "issues"."id" AS t0_r0, "issues"."title" AS t0_r1, "issues"."author_id" AS t0_r2, "issues"."project_id" AS t0_r3, "issues"."created_at" AS t0_r4, "issues"."updated_at" AS t0_r5, "issues"."description" AS t0_r6, "issues"."milestone_id" AS t0_r7, "issues"."state" AS t0_r8, "issues"."iid" AS t0_r9, "issues"."updated_by_id" AS t0_r10, "issues"."weight" AS t0_r11, "issues"."confidential" AS t0_r12, "issues"."moved_to_id" AS t0_r13, "issues"."due_date" AS t0_r14, "issues"."lock_version" AS t0_r15, "issues"."title_html" AS t0_r16, "issues"."description_html" AS t0_r17, "issues"."time_estimate" AS t0_r18, "issues"."relative_position" AS t0_r19, "issues"."service_desk_reply_to" AS t0_r20, "issues"."cached_markdown_version" AS t0_r21, "issues"."last_edited_at" AS t0_r22, "issues"."last_edited_by_id" AS t0_r23, "issues"."discussion_locked" AS t0_r24, "issues"."closed_at" AS t0_r25, "issues"."closed_by_id" AS t0_r26, "projects"."id" AS t1_r0, "projects"."name" AS t1_r1, "projects"."path" AS t1_r2, "projects"."description" AS t1_r3, "projects"."created_at" AS t1_r4, "projects"."updated_at" AS t1_r5, "projects"."creator_id" AS t1_r6, "projects"."namespace_id" AS t1_r7, "projects"."last_activity_at" AS t1_r8, "projects"."import_url" AS t1_r9, "projects"."visibility_level" AS t1_r10, "projects"."archived" AS t1_r11, "projects"."import_status" AS t1_r12, "projects"."merge_requests_template" AS t1_r13, "projects"."star_count" AS t1_r14, "projects"."merge_requests_rebase_enabled" AS t1_r15, "projects"."import_type" AS t1_r16, "projects"."import_source" AS t1_r17, "projects"."avatar" AS t1_r18, "projects"."approvals_before_merge" AS t1_r19, "projects"."reset_approvals_on_push" AS t1_r20, "projects"."merge_requests_ff_only_enabled" AS t1_r21, "projects"."issues_template" AS t1_r22, "projects"."mirror" AS t1_r23, "projects"."mirror_last_update_at" AS t1_r24, "projects"."mirror_last_successful_update_at" AS t1_r25, "projects"."mirror_user_id" AS t1_r26, "projects"."import_error" AS t1_r27, "projects"."ci_id" AS t1_r28, "projects"."shared_runners_enabled" AS t1_r29, "projects"."runners_token" AS t1_r30, "projects"."build_coverage_regex" AS t1_r31, "projects"."build_allow_git_fetch" AS t1_r32, "projects"."build_timeout" AS t1_r33, "projects"."mirror_trigger_builds" AS t1_r34, "projects"."public_builds" AS t1_r35, "projects"."pending_delete" AS t1_r36, "projects"."last_repository_check_failed" AS t1_r37, "projects"."last_repository_check_at" AS t1_r38, "projects"."container_registry_enabled" AS t1_r39, "projects"."only_allow_merge_if_pipeline_succeeds" AS t1_r40, "projects"."has_external_issue_tracker" AS t1_r41, "projects"."repository_storage" AS t1_r42, "projects"."request_access_enabled" AS t1_r43, "projects"."has_external_wiki" AS t1_r44, "projects"."repository_read_only" AS t1_r45, "projects"."lfs_enabled" AS t1_r46, "projects"."description_html" AS t1_r47, "projects"."only_allow_merge_if_all_discussions_are_resolved" AS t1_r48, "projects"."repository_size_limit" AS t1_r49, "projects"."service_desk_enabled" AS t1_r50, "projects"."printing_merge_request_link_enabled" AS t1_r51, "projects"."auto_cancel_pending_pipelines" AS t1_r52, "projects"."import_jid" AS t1_r53, "projects"."cached_markdown_version" AS t1_r54, "projects"."last_repository_updated_at" AS t1_r55, "projects"."ci_config_path" AS t1_r56, "projects"."disable_overriding_approvers_per_merge_request" AS t1_r57, "projects"."delete_error" AS t1_r58, "projects"."storage_version" AS t1_r59, "projects"."resolve_outdated_diff_discussions" AS t1_r60, "projects"."remote_mirror_available_overridden" AS t1_r61, "projects"."only_mirror_protected_branches" AS t1_r62, "projects"."pull_mirror_available_overridden" AS t1_r63, "projects"."jobs_cache_index" AS t1_r64, "projects"."external_authorization_classification_label" AS t1_r65, "projects"."mirror_overwrites_diverged_branches" AS t1_r66, "projects"."external_webhook_token" AS t1_r67, "projects"."pages_https_only" AS t1_r68, "projects"."packages_enabled" AS t1_r69, "projects"."merge_requests_author_approval" AS t1_r70, "projects"."pool_repository_id" AS t1_r71, "namespaces"."id" AS t2_r0, "namespaces"."name" AS t2_r1, "namespaces"."path" AS t2_r2, "namespaces"."owner_id" AS t2_r3, "namespaces"."created_at" AS t2_r4, "namespaces"."updated_at" AS t2_r5, "namespaces"."type" AS t2_r6, "namespaces"."description" AS t2_r7, "namespaces"."avatar" AS t2_r8, "namespaces"."membership_lock" AS t2_r9, "namespaces"."share_with_group_lock" AS t2_r10, "namespaces"."visibility_level" AS t2_r11, "namespaces"."request_access_enabled" AS t2_r12, "namespaces"."ldap_sync_status" AS t2_r13, "namespaces"."ldap_sync_error" AS t2_r14, "namespaces"."ldap_sync_last_update_at" AS t2_r15, "namespaces"."ldap_sync_last_successful_update_at" AS t2_r16, "namespaces"."ldap_sync_last_sync_at" AS t2_r17, "namespaces"."lfs_enabled" AS t2_r18, "namespaces"."description_html" AS t2_r19, "namespaces"."parent_id" AS t2_r20, "namespaces"."shared_runners_minutes_limit" AS t2_r21, "namespaces"."repository_size_limit" AS t2_r22, "namespaces"."require_two_factor_authentication" AS t2_r23, "namespaces"."two_factor_grace_period" AS t2_r24, "namespaces"."cached_markdown_version" AS t2_r25, "namespaces"."plan_id" AS t2_r26, "namespaces"."project_creation_level" AS t2_r27, "namespaces"."runners_token" AS t2_r28, "namespaces"."trial_ends_on" AS t2_r29, "namespaces"."file_template_project_id" AS t2_r30 FROM "issues" INNER JOIN "label_links" ON "label_links"."target_id" = "issues"."id" AND "label_links"."target_type" = 'Issue' INNER JOIN "labels" ON "labels"."id" = "label_links"."label_id" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT OUTER JOIN "namespaces" ON "namespaces"."id" = "projects"."namespace_id" LEFT OUTER JOIN milestones ON issues.milestone_id = milestones.id WHERE (issues.confidential IS NOT TRUE) AND "issues"."project_id" = 13083 AND "milestones"."title" = '10.0' AND "labels"."title" IN ('CI/CD', 'auto devops') AND (issues.due_date >= '2018-11-02') AND (issues.due_date <= '2018-12-31') AND "projects"."archived" = 'f' AND ("issues"."due_date" IS NOT NULL) GROUP BY "issues"."id" HAVING COUNT(DISTINCT labels.title) = 2 ORDER BY CASE WHEN issues.due_date >= CURRENT_DATE THEN 0 ELSE 1 END ASC, ABS(CURRENT_DATE - issues.due_date) ASC LIMIT 100 OFFSET 0