delta/gitlab/gitlab-ce.git/db, branch remove-commit-tree

Merge branch 'change-issues-closed-at-background-migration' into 'master'

2018-01-04T10:14:06+00:00

Use a background migration for migrating issues.closed_at

See merge request gitlab-org/gitlab-ce!16083

Use a background migration for issues.closed_at

2018-01-03T11:28:00+00:00

In a previous attempt (rolled back in
https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/16021) we tried
to migrate `issues.closed_at` from timestamp to timestamptz using a
regular migration. This has a bad impact on GitLab.com and as such was
rolled back.

This commit re-implements the original migrations using generic
background migrations, allowing us to still migrate the data in a single
release but without a negative impact on availability.

To ensure the database schema is up to date the background migrations
are performed inline in development and test environments. We also make
sure to not migrate that that doesn't need migrating in the first place
or has already been migrated.

Cache merged and closed events data in merge_request_metrics table

2018-01-02T19:45:25+00:00

Fix user membership destroy relation

2018-01-02T15:06:44+00:00

Merge branch '39289-local-schema-rb-automatically-reverts-datetime-to-datetime_with_timezone-after-migrations' into 'master'

2018-01-02T12:33:42+00:00

Prevent schema.rb reverting from datetime_with_timezone to datetime

Closes #39289

See merge request gitlab-org/gitlab-ce!14956

Merge branch 'sh-fix-mysql-migration-10-3' into 'master'

2017-12-27T16:14:36+00:00

Fix migration for removing orphaned issues.moved_to_id values in MySQL and PostgreSQL

Closes #41498

See merge request gitlab-org/gitlab-ce!16141

Simplify implementation and allow for batch updates in MySQL

2017-12-27T15:11:54+00:00

Fix PostgreSQL implementation of migration

2017-12-27T12:12:18+00:00

Fix Gitlab::Access.values to Gitlab::Access.sym_options at 06_teams on development db fixtures

2017-12-27T09:55:57+00:00

Fix migration for removing orphaned issues.moved_to_id values in MySQL

2017-12-27T06:29:15+00:00

According to https://dev.mysql.com/doc/refman/5.7/en/update.html,
"You cannot update a table and select from the same table in a subquery."
Attempting to do so results in the error:

```
Mysql2::Error: Table 'issues' is specified twice, both as a target for 'UPDATE' and as a separate source for data
```

Instead, we can use a LEFT JOIN on the same table to make MySQL do the right
thing.

Closes #41498