delta/gitlab/gitlab-ce.git/db, branch update-csslab-version

Add partial indexes on todos to handle users with many todos

2018-03-09T16:56:58+00:00

Merge branch 'jprovazn-commits-count-reschedule' into 'master'

2018-03-09T12:57:06+00:00

Reschedule commits_count background migration

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

Reschedule commits_count background migration

2018-03-09T08:56:49+00:00

We still have >100K unmigrated MergeRequestDiffs
which don't have commits_count set yet (see
https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/17567#note_61904891)

This migration re-schedules the original background migration.
To assure that records are not processed twice, records with
commits_count set are skipped.

Related to #41698 and !17567

Fix index name to Rails default to ensure idempotency

2018-03-08T19:36:41+00:00

See https://gitlab.com/gitlab-com/infrastructure/issues/3822

Merge branch 'jprovazn-revert-commit-cleanup' into 'master'

2018-03-08T13:07:36+00:00

Revert "Cleanup after adding MR diff's commit_count"

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

Merge branch '43802-ensure-foreign-keys-on-clusters-applications' into 'master'

2018-03-08T13:00:37+00:00

Resolve "Add missing foreign key constraint in clusters_applications_ingress"

Closes #43802

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

Merge branch 'sh-add-missing-acts-as-taggable-indices' into 'master'

2018-03-08T12:54:57+00:00

Adding missing indexes migrations from taggings table

Closes #43927

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

Revert "Cleanup after adding MR diff's commit_count"

2018-03-08T11:43:14+00:00

This reverts commit 0b7d10851456018328da137beeca931767b4fd0a.

Add index on section_name_id on ci_build_trace_sections table

2018-03-08T08:25:15+00:00

This was causing user deletions to time out.

Closes #44008

Adding missing indexes on taggings table

2018-03-08T05:39:20+00:00

API requests were timing out because `tag_id` was missing an index. These
migrations were imported by running https://github.com/mbleigh/acts-as-taggable-on#post-installation:

```
bundle exec rake acts_as_taggable_on_engine:install:migrations
```

It looks like the `acts-as-tagglable` gem added the indexes in v4.0.0, but
when we upgraded from v3.5.0 (back in 2016 via
f571aeb5ce38dce1a9e5f58d76360836d4a8f8a0) we did not add them.

On staging, there are about 10.7 million rows on the `taggings` table. It took about 30 seconds for each index to be created.

On production, there are about 17.4 million rows, so I suspect the time to be about a minute per index.

Closes #43927