Mysql2::Error: Table 'ci_builds' is specified twice, Migration Cancelled

Summary

An error occurred upon database migration after upgrading from ef518df2 to 09c5885a.

Steps to reproduce

1. bundle install --without postgres development test --deployment
2. bundle clean
3. bundle exec rake db:migrate RAILS_ENV=production

What is the current bug behavior?

Unable to finish database-migration.

Relevant logs and/or screenshots

== 20170503004427 UpateRetriedForCiBuild: migrating ===========================
-- exec_query("SELECT COUNT(*) AS count FROM `ci_builds` WHERE `ci_builds`.`retried` IS NULL")
   -> 0.0056s
-- exec_query("SELECT  `ci_builds`.`id` FROM `ci_builds` WHERE `ci_builds`.`retried` IS NULL  ORDER BY `ci_builds`.`id` ASC LIMIT 1")
   -> 0.0005s
-- exec_query("SELECT  `ci_builds`.`id` FROM `ci_builds` WHERE `ci_builds`.`id` >= 1 AND `ci_builds`.`retried` IS NULL  ORDER BY `ci_builds`.`id` ASC LIMIT 1 OFFSET 402")
   -> 0.0008s
-- execute("UPDATE `ci_builds` SET `retried` = ((SELECT MAX(ci_builds2.id)\n  FROM ci_builds ci_builds2\n  WHERE ci_builds.commit_id=ci_builds2.commit_id\n    AND ci_builds.name=ci_builds2.name\n) != ci_builds.id) WHERE `ci_builds`.`id` >= 1 AND `ci_builds`.`id` < 403 AND `ci_builds`.`retried` IS NULL")
rake aborted!
StandardError: An error has occurred, all later migrations canceled:

Mysql2::Error: Table 'ci_builds' is specified twice, both as a target for 'UPDATE' and as a separate source for data: UPDATE `ci_builds` SET `retried` = ((SELECT MAX(ci_builds2.id)
  FROM ci_builds ci_builds2
  WHERE ci_builds.commit_id=ci_builds2.commit_id
    AND ci_builds.name=ci_builds2.name
) != ci_builds.id) WHERE `ci_builds`.`id` >= 1 AND `ci_builds`.`id` < 403 AND `ci_builds`.`retried` IS NULL/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:309:in `query'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:309:in `block in execute'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:484:in `block in log'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.8/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:478:in `log'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:309:in `execute'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/mysql2_adapter.rb:225:in `execute'
/home/git/gitlab/config/initializers/connection_fix.rb:20:in `execute'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:665:in `block in method_missing'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:634:in `block in say_with_time'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:634:in `say_with_time'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:654:in `method_missing'
/home/git/gitlab/lib/gitlab/database/migration_helpers.rb:198:in `block in update_column_in_batches'
/home/git/gitlab/lib/gitlab/database/migration_helpers.rb:175:in `loop'
/home/git/gitlab/lib/gitlab/database/migration_helpers.rb:175:in `update_column_in_batches'
/home/git/gitlab/db/post_migrate/20170503004427_upate_retried_for_ci_build.rb:23:in `block in up'
/home/git/gitlab/db/post_migrate/20170503004427_upate_retried_for_ci_build.rb:37:in `with_temporary_partial_index'
/home/git/gitlab/db/post_migrate/20170503004427_upate_retried_for_ci_build.rb:11:in `up'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:611:in `exec_migration'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:592:in `block (2 levels) in migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:591:in `block in migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:590:in `migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:768:in `migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:1046:in `ddl_transaction'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:997:in `execute_migration_in_transaction'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:959:in `block in migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:955:in `each'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:955:in `migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:823:in `up'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:801:in `migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/tasks/database_tasks.rb:137:in `migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>'
/usr/local/bin/bundle:22:in `load'
/usr/local/bin/bundle:22:in `<main>'
ActiveRecord::StatementInvalid: Mysql2::Error: Table 'ci_builds' is specified twice, both as a target for 'UPDATE' and as a separate source for data: UPDATE `ci_builds` SET `retried` = ((SELECT MAX(ci_builds2.id)
  FROM ci_builds ci_builds2
  WHERE ci_builds.commit_id=ci_builds2.commit_id
    AND ci_builds.name=ci_builds2.name
) != ci_builds.id) WHERE `ci_builds`.`id` >= 1 AND `ci_builds`.`id` < 403 AND `ci_builds`.`retried` IS NULL
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:309:in `query'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:309:in `block in execute'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:484:in `block in log'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.8/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:478:in `log'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:309:in `execute'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/mysql2_adapter.rb:225:in `execute'
/home/git/gitlab/config/initializers/connection_fix.rb:20:in `execute'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:665:in `block in method_missing'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:634:in `block in say_with_time'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:634:in `say_with_time'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:654:in `method_missing'
/home/git/gitlab/lib/gitlab/database/migration_helpers.rb:198:in `block in update_column_in_batches'
/home/git/gitlab/lib/gitlab/database/migration_helpers.rb:175:in `loop'
/home/git/gitlab/lib/gitlab/database/migration_helpers.rb:175:in `update_column_in_batches'
/home/git/gitlab/db/post_migrate/20170503004427_upate_retried_for_ci_build.rb:23:in `block in up'
/home/git/gitlab/db/post_migrate/20170503004427_upate_retried_for_ci_build.rb:37:in `with_temporary_partial_index'
/home/git/gitlab/db/post_migrate/20170503004427_upate_retried_for_ci_build.rb:11:in `up'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:611:in `exec_migration'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:592:in `block (2 levels) in migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:591:in `block in migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:590:in `migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:768:in `migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:1046:in `ddl_transaction'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:997:in `execute_migration_in_transaction'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:959:in `block in migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:955:in `each'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:955:in `migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:823:in `up'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:801:in `migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/tasks/database_tasks.rb:137:in `migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>'
/usr/local/bin/bundle:22:in `load'
/usr/local/bin/bundle:22:in `<main>'
Mysql2::Error: Table 'ci_builds' is specified twice, both as a target for 'UPDATE' and as a separate source for data
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:309:in `query'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:309:in `block in execute'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:484:in `block in log'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.8/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:478:in `log'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:309:in `execute'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/mysql2_adapter.rb:225:in `execute'
/home/git/gitlab/config/initializers/connection_fix.rb:20:in `execute'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:665:in `block in method_missing'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:634:in `block in say_with_time'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:634:in `say_with_time'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:654:in `method_missing'
/home/git/gitlab/lib/gitlab/database/migration_helpers.rb:198:in `block in update_column_in_batches'
/home/git/gitlab/lib/gitlab/database/migration_helpers.rb:175:in `loop'
/home/git/gitlab/lib/gitlab/database/migration_helpers.rb:175:in `update_column_in_batches'
/home/git/gitlab/db/post_migrate/20170503004427_upate_retried_for_ci_build.rb:23:in `block in up'
/home/git/gitlab/db/post_migrate/20170503004427_upate_retried_for_ci_build.rb:37:in `with_temporary_partial_index'
/home/git/gitlab/db/post_migrate/20170503004427_upate_retried_for_ci_build.rb:11:in `up'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:611:in `exec_migration'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:592:in `block (2 levels) in migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:591:in `block in migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:590:in `migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:768:in `migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:1046:in `ddl_transaction'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:997:in `execute_migration_in_transaction'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:959:in `block in migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:955:in `each'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:955:in `migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:823:in `up'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:801:in `migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/tasks/database_tasks.rb:137:in `migrate'
/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>'
/usr/local/bin/bundle:22:in `load'
/usr/local/bin/bundle:22:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)

Results of GitLab environment info

[git@dev gitlab]$ bundle exec rake gitlab:env:info RAILS_ENV=production

System information
System:
Current User:   git
Using RVM:      no
Ruby Version:   2.3.3p222
Gem Version:    2.5.2
Bundler Version:1.15.0
Rake Version:   10.5.0
Redis Version:  3.2.3
Git Version:    2.8.4
Sidekiq Version:5.0.0
Go Version:     go1.5.3 linux/amd64

GitLab information
Version:        9.2.0-pre
Revision:       09c5885
Directory:      /home/git/gitlab
DB Adapter:     mysql2
URL:            https://example.com
HTTP Clone URL: https://example.com/some-group/some-project.git
SSH Clone URL:  git@example.com:some-group/some-project.git
Using LDAP:     no
Using Omniauth: no

GitLab Shell
Version:        5.0.4
Repository storage paths:
- default:      /home/git/repositories
Hooks:          /home/git/gitlab-shell/hooks
Git:            /usr/local/bin/git

Results of GitLab application Check

[git@dev gitlab]$ bundle exec rake gitlab:check RAILS_ENV=production SANITIZE=true
Checking GitLab Shell ...

GitLab Shell version >= 5.0.3 ? ... OK (5.0.4)
Repo base directory exists?
default... yes
Repo storage directories are symlinks?
default... no
Repo paths owned by git:root, or git:git?
default... yes
Repo paths access is drwxrws---?
default... yes
hooks directories in repos are links: ...
4/2 ... ok
6/3 ... repository is empty
6/6 ... ok
7/10 ... ok
4/11 ... ok
4/12 ... ok
6/16 ... ok
12/17 ... ok
6/18 ... ok
6/19 ... ok
12/20 ... ok
12/21 ... repository is empty
12/22 ... ok
6/23 ... repository is empty
14/24 ... ok
14/25 ... ok
14/26 ... ok
16/28 ... ok
7/29 ... ok
14/30 ... ok
14/32 ... ok
14/33 ... ok
7/34 ... ok
16/35 ... ok
16/36 ... ok
16/37 ... repository is empty
7/39 ... ok
1/40 ... ok
18/41 ... ok
18/42 ... ok
18/43 ... repository is empty
18/44 ... ok
19/45 ... ok
21/46 ... ok
19/47 ... ok
7/48 ... ok
Running /home/git/gitlab-shell/bin/check
Check GitLab API access: OK
Access to /home/git/.ssh/authorized_keys: OK
Send ping to redis server: OK
gitlab-shell self-check successful

Checking GitLab Shell ... Finished

Checking Sidekiq ...

Running? ... yes
Number of Sidekiq processes ... 1

Checking Sidekiq ... Finished

Checking Reply by email ...

Reply by email is disabled in config/gitlab.yml

Checking Reply by email ... Finished

Checking LDAP ...

LDAP is disabled in config/gitlab.yml

Checking LDAP ... Finished

Checking GitLab ...

Git configured with autocrlf=input? ... yes
Database config exists? ... yes
All migrations up? ... yes
Database contains orphaned GroupMembers? ... no
GitLab config exists? ... yes
GitLab config outdated? ... no
Log directory writable? ... yes
Tmp directory writable? ... yes
Uploads directory setup correctly? ... skipped (no tmp uploads folder yet)
Init script exists? ... yes
Init script up-to-date? ... yes
projects have namespace: ...
4/2 ... yes
6/3 ... yes
6/6 ... yes
7/10 ... yes
4/11 ... yes
4/12 ... yes
6/16 ... yes
12/17 ... yes
6/18 ... yes
6/19 ... yes
12/20 ... yes
12/21 ... yes
12/22 ... yes
6/23 ... yes
14/24 ... yes
14/25 ... yes
14/26 ... yes
16/28 ... yes
7/29 ... yes
14/30 ... yes
14/32 ... yes
14/33 ... yes
7/34 ... yes
16/35 ... yes
16/36 ... yes
16/37 ... yes
7/39 ... yes
1/40 ... yes
18/41 ... yes
18/42 ... yes
18/43 ... yes
18/44 ... yes
19/45 ... yes
21/46 ... yes
19/47 ... yes
7/48 ... yes
Redis version >= 2.8.0? ... yes
Ruby version >= 2.1.0 ? ... yes (2.3.3)
Your git bin path is "/usr/local/bin/git"
Git version >= 2.7.3 ? ... yes (2.8.4)
Active users: 10

Checking GitLab ... Finished

just updated from 9.2.0-pre to 9.2.0-rc7 and facing the same issue: https://pastebin.co.za/5675267779461120

Thanks for the reports!

@grzesiek Please could you take a look?

added ~19173 ~12980 database labels

@ayufan This seems to be related to db/post_migrate/20170503004427_upate_retried_for_ci_build.rb

assigned to @ayufan

Thanks. I will try to fix that ASAP.

@tmaczukin Could you help fixing that?

Our test didn't catch this because there's no records when we run migrations, and this would require records in order to happen. The job was https://gitlab.com/gitlab-org/gitlab-ce/builds/16747017

Here we could see that it's doing an COUNT, then nothing else to do.

== 20170503004427 UpateRetriedForCiBuild: migrating ===========================
-- exec_query("SELECT COUNT(*) AS count FROM `ci_builds` WHERE `ci_builds`.`retried` IS NULL")
   -> 0.0009s
== 20170503004427 UpateRetriedForCiBuild: migrated (0.0014s) ==================

@rtripault reported this a week ago at https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/11115#note_29500321

I guess Search System of gitlab still fails?

It should show up on search result(comments). Because I remember searching issue related to the error...

mentioned in issue #32677 (closed)

We could probably use a LEFT OUTER JOIN for MySQL

Huh. Thanks for pointing that out @godfat.

mentioned in commit b5918f22

mentioned in merge request !11593 (merged)

@godfat My naive fix: https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/11593

mentioned in issue #31934 (closed)

closed via merge request !11593 (merged)

mentioned in commit 539d9a00

mentioned in merge request !14785