[SOLVED] Gitlab 500 Error on sign in

Every time i try to log in i get 500 Whoops, something went wrong on our end.
I took a look at the logs, and here is the error:

Started GET "/users/sign_in" for 154.5.173.254 at 2017-01-06 23:41:14 +0200
Processing by SessionsController#new as HTML
Redirected to https://dev.xxx.com/
Filter chain halted as :require_no_authentication rendered or redirected
Completed 302 Found in 63ms (ActiveRecord: 6.6ms)
Started GET "/" for 154.5.173.254 at 2017-01-06 23:41:14 +0200
Processing by RootController#index as HTML
Completed 500 Internal Server Error in 286ms (ActiveRecord: 19.9ms)

ActionView::Template::Error (PG::GroupingError: ERROR:  column "ci_commits.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 2: ..."ci_commits"."ref", "ci_commits"."sha")  ORDER BY "ci_commit...
                                                             ^
: SELECT (CASE
        WHEN (SELECT count(*) FROM "ci_commits" WHERE "ci_commits"."gl_project_id" = 7 AND "ci_commits"."sha" = 'd9c3fa5ad4b974e445095beb87a9d3c939e499f5' AND "ci_commits"."id" IN (SELECT max("ci_commits".id) FROM "ci_commits" WHERE "ci$
        WHEN (SELECT count(*) FROM "ci_commits" WHERE "ci_commits"."gl_project_id" = 7 AND "ci_commits"."sha" = 'd9c3fa5ad4b974e445095beb87a9d3c939e499f5' AND "ci_commits"."id" IN (SELECT max("ci_commits".id) FROM "ci_commits" WHERE "ci$
        WHEN (SELECT count(*) FROM "ci_commits" WHERE "ci_commits"."gl_project_id" = 7 AND "ci_commits"."sha" = 'd9c3fa5ad4b974e445095beb87a9d3c939e499f5' AND "ci_commits"."id" IN (SELECT max("ci_commits".id) FROM "ci_commits" WHERE "ci$
        WHEN (SELECT count(*) FROM "ci_commits" WHERE "ci_commits"."gl_project_id" = 7 AND "ci_commits"."sha" = 'd9c3fa5ad4b974e445095beb87a9d3c939e499f5' AND "ci_commits"."id" IN (SELECT max("ci_commits".id) FROM "ci_commits" WHERE "ci$
        WHEN (SELECT count(*) FROM "ci_commits" WHERE "ci_commits"."gl_project_id" = 7 AND "ci_commits"."sha" = 'd9c3fa5ad4b974e445095beb87a9d3c939e499f5' AND "ci_commits"."id" IN (SELECT max("ci_commits".id) FROM "ci_commits" WHERE "ci$
        WHEN (SELECT count(*) FROM "ci_commits" WHERE "ci_commits"."gl_project_id" = 7 AND "ci_commits"."sha" = 'd9c3fa5ad4b974e445095beb87a9d3c939e499f5' AND "ci_commits"."id" IN (SELECT max("ci_commits".id) FROM "ci_commits" WHERE "ci$
        WHEN (SELECT count(*) FROM "ci_commits" WHERE "ci_commits"."gl_project_id" = 7 AND "ci_commits"."sha" = 'd9c3fa5ad4b974e445095beb87a9d3c939e499f5' AND "ci_commits"."id" IN (SELECT max("ci_commits".id) FROM "ci_commits" WHERE "ci$
        ELSE 'failed'
      END) FROM "ci_commits" WHERE "ci_commits"."gl_project_id" = $1 AND "ci_commits"."sha" = $2 AND "ci_commits"."id" IN (SELECT max("ci_commits".id) FROM "ci_commits" WHERE "ci_commits"."gl_project_id" = $3 AND "ci_commits"."sha" = $4$
     7: - show_last_commit_as_description = false unless local_assigns[:show_last_commit_as_description] == true && project.commit
     8: - css_class += " no-description" if project.description.blank? && !show_last_commit_as_description
     9: - cache_key = [project.namespace, project, controller.controller_name, controller.action_name, current_application_settings, 'v2.3']
    10: - cache_key.push(project.commit.status) if project.commit.try(:status)
    11:
    12: %li.project-row{ class: css_class }
    13:   = cache(cache_key) do
  app/models/concerns/has_status.rb:38:in `status'
  app/models/ci/pipeline.rb:101:in `latest_status'
  app/models/commit.rb:233:in `status'
  app/views/shared/projects/_project.html.haml:10:in `_app_views_shared_projects__project_html_haml__606302756948863989_69858871433360'
  app/views/shared/projects/_list.html.haml:16:in `block in _app_views_shared_projects__list_html_haml__1708565735447634_69858885285100'
  app/views/shared/projects/_list.html.haml:14:in `_app_views_shared_projects__list_html_haml__1708565735447634_69858885285100'
  app/views/dashboard/projects/_projects.html.haml:1:in `_app_views_dashboard_projects__projects_html_haml___947587567084884615_69858884706140'
  app/views/dashboard/projects/index.html.haml:15:in `_app_views_dashboard_projects_index_html_haml__1140774871299627447_69858935119440'
  app/controllers/dashboard/projects_controller.rb:15:in `index'
  app/controllers/root_controller.rb:13:in `index'
  lib/gitlab/middleware/multipart.rb:93:in `call'
  lib/gitlab/request_profiler/middleware.rb:15:in `call'
  lib/gitlab/middleware/go.rb:16:in `call'

Any help?

The latest gitlab update fixed it.

Hi,

I got same error. please help.

Thanks,
Venkatesh