ERROR: column "projects.mirror" must appear in the GROUP BY clause...
Running latest 9.3.3-ee.0 docker image and seeing the following error in the logs repeatedly. Using omnibus with all internal services except for elasticsearch.
==> /var/log/gitlab/postgresql/current <==
2017-06-30_15:09:31.33353 ERROR: column "projects.mirror" must appear in the GROUP BY clause or be used in an aggregate function at character 57
2017-06-30_15:09:31.33358 STATEMENT: SELECT
2017-06-30_15:09:31.33358 ci_builds.runner_id,
2017-06-30_15:09:31.33359 ci_runners.is_shared,
2017-06-30_15:09:31.33359 projects.mirror,
2017-06-30_15:09:31.33359 projects.pending_delete,
2017-06-30_15:09:31.33359 projects.mirror_trigger_builds,
2017-06-30_15:09:31.33359 ci_pipelines.pipeline_schedule_id,
2017-06-30_15:09:31.33359 ci_builds.trigger_request_id,
2017-06-30_15:09:31.33359 COUNT(*) AS count
2017-06-30_15:09:31.33360 FROM ci_builds
2017-06-30_15:09:31.33360 JOIN ci_runners
2017-06-30_15:09:31.33360 ON ci_runners.id = ci_builds.runner_id
2017-06-30_15:09:31.33360 JOIN projects
2017-06-30_15:09:31.33360 ON projects.id = ci_builds.project_id
2017-06-30_15:09:31.33360 JOIN ci_pipelines
2017-06-30_15:09:31.33361 ON ci_pipelines.id = ci_builds.commit_id
2017-06-30_15:09:31.33361 WHERE ci_builds.type = 'Ci::Build'
2017-06-30_15:09:31.33361 AND ci_builds.status = 'running'
2017-06-30_15:09:31.33361 GROUP BY
2017-06-30_15:09:31.33361 ci_builds.runner_id,
2017-06-30_15:09:31.33361 ci_runners.is_shared,
2017-06-30_15:09:31.33362 ci_pipelines.pipeline_schedule_id,
2017-06-30_15:09:31.33362 ci_builds.trigger_request_id
2017-06-30_15:09:31.33362
==> /var/log/gitlab/gitlab-monitor/current <==
2017-06-30_15:09:31.33437 2017-06-30 15:09:31 - PG::GroupingError - ERROR: column "projects.mirror" must appear in the GROUP BY clause or be used in an aggregate function
2017-06-30_15:09:31.33438 LINE 4: projects.mirror,
2017-06-30_15:09:31.33438 ^
2017-06-30_15:09:31.33439 :
2017-06-30_15:09:31.33439 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/gitlab-monitor-1.8.0/lib/gitlab_monitor/database/ci_builds.rb:100:in `exec'
2017-06-30_15:09:31.33439 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/gitlab-monitor-1.8.0/lib/gitlab_monitor/database/ci_builds.rb:100:in `get_per_runner'
2017-06-30_15:09:31.33439 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/gitlab-monitor-1.8.0/lib/gitlab_monitor/database/ci_builds.rb:91:in `run'
2017-06-30_15:09:31.33439 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/gitlab-monitor-1.8.0/lib/gitlab_monitor/database/ci_builds.rb:173:in `probe_db'
2017-06-30_15:09:31.33440 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/gitlab-monitor-1.8.0/lib/gitlab_monitor/prober.rb:17:in `block (3 levels) in probe_all'
2017-06-30_15:09:31.33441 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/gitlab-monitor-1.8.0/lib/gitlab_monitor/prober.rb:16:in `each'
2017-06-30_15:09:31.33441 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/gitlab-monitor-1.8.0/lib/gitlab_monitor/prober.rb:16:in `block (2 levels) in probe_all'
2017-06-30_15:09:31.33441 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/gitlab-monitor-1.8.0/lib/gitlab_monitor/prober.rb:14:in `each'
2017-06-30_15:09:31.33442 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/gitlab-monitor-1.8.0/lib/gitlab_monitor/prober.rb:14:in `block in probe_all'
2017-06-30_15:09:31.33442 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/gitlab-monitor-1.8.0/lib/gitlab_monitor/prober.rb:13:in `each'
2017-06-30_15:09:31.33442 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/gitlab-monitor-1.8.0/lib/gitlab_monitor/prober.rb:13:in `probe_all'
2017-06-30_15:09:31.33454 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/gitlab-monitor-1.8.0/lib/gitlab_monitor/web_exporter.rb:32:in `block (2 levels) in setup_probes'
2017-06-30_15:09:31.33455 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:1611:in `call'
2017-06-30_15:09:31.33455 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:1611:in `block in compile!'
2017-06-30_15:09:31.33455 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:975:in `block (3 levels) in route!'
2017-06-30_15:09:31.33455 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:994:in `route_eval'
2017-06-30_15:09:31.33456 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:975:in `block (2 levels) in route!'
2017-06-30_15:09:31.33457 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:1015:in `block in process_route'
2017-06-30_15:09:31.33457 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:1013:in `catch'
2017-06-30_15:09:31.33457 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:1013:in `process_route'
2017-06-30_15:09:31.33457 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:973:in `block in route!'
2017-06-30_15:09:31.33458 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:972:in `each'
2017-06-30_15:09:31.33458 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:972:in `route!'
2017-06-30_15:09:31.33458 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:1085:in `block in dispatch!'
2017-06-30_15:09:31.33458 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:1067:in `block in invoke'
2017-06-30_15:09:31.33458 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:1067:in `catch'
2017-06-30_15:09:31.33459 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:1067:in `invoke'
2017-06-30_15:09:31.33459 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:1082:in `dispatch!'
2017-06-30_15:09:31.33463 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:907:in `block in call!'
2017-06-30_15:09:31.33463 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:1067:in `block in invoke'
2017-06-30_15:09:31.33463 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:1067:in `catch'
2017-06-30_15:09:31.33464 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:1067:in `invoke'
2017-06-30_15:09:31.33464 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:907:in `call!'
2017-06-30_15:09:31.33464 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:895:in `call'
2017-06-30_15:09:31.33464 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/rack-protection-1.5.3/lib/rack/protection/xss_header.rb:18:in `call'
2017-06-30_15:09:31.33464 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/rack-protection-1.5.3/lib/rack/protection/path_traversal.rb:16:in `call'
2017-06-30_15:09:31.33465 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/rack-protection-1.5.3/lib/rack/protection/json_csrf.rb:18:in `call'
2017-06-30_15:09:31.33466 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49:in `call'
2017-06-30_15:09:31.33466 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49:in `call'
2017-06-30_15:09:31.33466 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/rack-protection-1.5.3/lib/rack/protection/frame_options.rb:31:in `call'
2017-06-30_15:09:31.33466 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/rack-1.6.8/lib/rack/nulllogger.rb:9:in `call'
2017-06-30_15:09:31.33466 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/rack-1.6.8/lib/rack/head.rb:13:in `call'
2017-06-30_15:09:31.33466 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/show_exceptions.rb:25:in `call'
2017-06-30_15:09:31.33467 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:182:in `call'
2017-06-30_15:09:31.33470 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:2013:in `call'
2017-06-30_15:09:31.33471 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:1487:in `block in call'
2017-06-30_15:09:31.33471 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:1787:in `synchronize'
2017-06-30_15:09:31.33471 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/sinatra-1.4.8/lib/sinatra/base.rb:1487:in `call'
2017-06-30_15:09:31.33472 /opt/gitlab/embedded/lib/ruby/gems/2.3.0/gems/rack-1.6.8/lib/rack/handler/webrick.rb:88:in `service'
2017-06-30_15:09:31.33472 /opt/gitlab/embedded/lib/ruby/2.3.0/webrick/httpserver.rb:140:in `service'
2017-06-30_15:09:31.33472 /opt/gitlab/embedded/lib/ruby/2.3.0/webrick/httpserver.rb:96:in `run'
2017-06-30_15:09:31.33472 /opt/gitlab/embedded/lib/ruby/2.3.0/webrick/server.rb:296:in `block in start_thread'