DashboardController Error 500: column reference "due_date" is ambiguous
https://sentry.gitlap.com/gitlab/gitlabcom/issues/223046/
PG::AmbiguousColumn: ERROR: column reference "due_date" is ambiguous
LINE 6: ...2018-07-31') AND "projects"."archived" = 'f' AND (due_date I...
^
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
...
(205 additional frame(s) were not displayed)
ActiveRecord::StatementInvalid: PG::AmbiguousColumn: ERROR: column reference "due_date" is ambiguous
LINE 6: ...2018-07-31') AND "projects"."archived" = 'f' AND (due_date I...
^
: SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id LEFT OUTER JOIN milestones ON issues.milestone_id = milestones.id WHERE (
issues.confidential IS NOT TRUE
OR (issues.confidential = TRUE
AND (issues.author_id = 2071130
OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 2071130 AND issue_id = issues.id)
OR issues.project_id IN(SELECT "projects"."id" FROM "projects" INNER JOIN "project_authorizations" ON "projects"."id" = "project_authorizations"."project_id" WHERE "project_authorizations"."user_id" = 2071130 AND (project_authorizations.access_level >= 20))))) AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 2071130 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 2071130 AND (project_authorizations.project_id = projects.id)))) AND ("issues"."state" IN ('opened')) AND (EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 2071130 AND issue_id = issues.id)) AND "projects"."archived" = 'f' AND ("issues"."milestone_id" = -1 OR "issues"."milestone_id" IS NULL) AND (issues.due_date >= '2018-05-29') AND (issues.due_date <= '2018-07-31') AND "projects"."archived" = 'f' AND (due_date IS NOT NULL) ORDER BY CASE WHEN due_date >= CURRENT_DATE THEN 0 ELSE 1 END ASC, ABS(CURRENT_DATE - due_date) ASC LIMIT 100
ActionView::Template::Error: PG::AmbiguousColumn: ERROR: column reference "due_date" is ambiguous
LINE 6: ...2018-07-31') AND "projects"."archived" = 'f' AND (due_date I...
^
: SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id LEFT OUTER JOIN milestones ON issues.milestone_id = milestones.id WHERE (
issues.confidential IS NOT TRUE
OR (issues.confidential = TRUE
AND (issues.author_id = 2071130
OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 2071130 AND issue_id = issues.id)
OR issues.project_id IN(SELECT "projects"."id" FROM "projects" INNER JOIN "project_authorizations" ON "projects"."id" = "project_authorizations"."project_id" WHERE "project_authorizations"."user_id" = 2071130 AND (project_authorizations.access_level >= 20))))) AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 2071130 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 2071130 AND (project_authorizations.project_id = projects.id)))) AND ("issues"."state" IN ('opened')) AND (EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 2071130 AND issue_id = issues.id)) AND "projects"."archived" = 'f' AND ("issues"."milestone_id" = -1 OR "issues"."milestone_id" IS NULL) AND (issues.due_date >= '2018-05-29') AND (issues.due_date <= '2018-07-31') AND "projects"."archived" = 'f' AND (due_date IS NOT NULL) ORDER BY CASE WHEN due_date >= CURRENT_DATE THEN 0 ELSE 1 END ASC, ABS(CURRENT_DATE - due_date) ASC LIMIT 100
ActionView::Template::Error: PG::AmbiguousColumn: ERROR: column reference "due_date" is ambiguous
LINE 6: ...2018-07-31') AND "projects"."archived" = 'f' AND (due_date I...
^
: SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id LEFT OUTER JOIN milestones ON issues.milestone_id = milestones.id WHERE (
issues.confidential IS NOT TRUE
OR (issues.confidential = TRUE
AND (issues.author_id = 2071130
OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 2071130 AND issue_id = issues.id)
OR issues.project_id IN(SELECT "projects"."id" FROM "projects" INNER JOIN "project_authorizations" ON "projects"."id" = "project_authorizations"."project_id" WHERE "project_authorizations"."user_id" = 2071130 AND (project_authorizations.access_level >= 20))))) AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 2071130 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 2071130 AND (project_authorizations.project_id = projects.id)))) AND ("issues"."state" IN ('opened')) AND (EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 2071130 AND issue_id = issues.id)) AND "projects"."archived" = 'f' AND ("issues"."milestone_id" = -1 OR "issues"."milestone_id" IS NULL) AND (issues.due_date >= '2018-05-29') AND (issues.due_date <= '2018-07-31') AND "projects"."archived" = 'f' AND (due_date IS NOT NULL) ORDER BY CASE WHEN due_date >= CURRENT_DATE THEN 0 ELSE 1 END ASC, ABS(CURRENT_DATE - due_date) ASC LIMIT 100