Skip to content

ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR: column "highest_priority" does not exist

https://sentry.gitlab.net/gitlab/gitlabcom/issues/561918/

PG::UndefinedColumn: ERROR:  column "highest_priority" does not exist
LINE 3: ...ORDER BY MIN(milestones.due_date) ASC NULLS LAST, highest_pr...
                                                             ^

  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
...
(154 additional frame(s) were not displayed)

ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR:  column "highest_priority" does not exist
LINE 3: ...ORDER BY MIN(milestones.due_date) ASC NULLS LAST, highest_pr...
                                                             ^
: SELECT issues.created_at 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 "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS (SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 9970
UNION
SELECT "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."parent_id" = "base_and_descendants"."id") SELECT "id" FROM "base_and_descendants" AS "namespaces") AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 426128 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20,30) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 426128 AND (project_authorizations.project_id = projects.id)))) AND (issues.created_at >= '2017-11-01 00:00:00.000000') GROUP BY "issues"."id"  ORDER BY MIN(milestones.due_date) ASC NULLS LAST, highest_priority ASC NULLS LAST, "issues"."id" DESC

ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR:  column "highest_priority" does not exist
LINE 3: ...ORDER BY MIN(milestones.due_date) ASC NULLS LAST, highest_pr...
                                                             ^
: SELECT issues.created_at 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 "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS (SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 9970
UNION
SELECT "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."parent_id" = "base_and_descendants"."id") SELECT "id" FROM "base_and_descendants" AS "namespaces") AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 426128 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20,30) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 426128 AND (project_authorizations.project_id = projects.id)))) AND (issues.created_at >= '2017-11-01 00:00:00.000000') GROUP BY "issues"."id"  ORDER BY MIN(milestones.due_date) ASC NULLS LAST, highest_priority ASC NULLS LAST, "issues"."id" DESC