summaryrefslogtreecommitdiff
path: root/db/post_migrate
Commit message (Collapse)AuthorAgeFilesLines
* Clean up schema of the "issues" tablecleanup-issues-schemaYorick Peterse2017-11-091-0/+19
| | | | | | | | This adds various foreign key constraints, indexes, missing NOT NULL constraints, and changes some column types from timestamp to timestamptz. Fixes https://gitlab.com/gitlab-org/gitlab-ce/issues/31811
* Merge branch 'refactor-clusters' into 'master'Grzegorz Bizon2017-11-061-0/+99
|\ | | | | | | | | Refactor Clusters to be consisted from GcpProvider and KubernetesPlatform See merge request gitlab-org/gitlab-ce!14879
| * Fix statis analysysShinya Maeda2017-11-051-1/+1
| |
| * Move migration file to post-migration. Use EachBatch. batch_size 1Shinya Maeda2017-11-041-0/+99
| |
* | make the migration reversiblemicael.bergeron2017-11-031-1/+1
| |
* | add changelog and move migration to post_migratemicael.bergeron2017-11-031-0/+14
|/
* Merge branch '37631-add-a-merge_request_diff_id-column-to-merge_requests' ↵Yorick Peterse2017-11-021-0/+27
|\ | | | | | | | | | | | | into 'master' Resolve "Add a `merge_request_diff_id` column to `merge_requests`" See merge request gitlab-org/gitlab-ce!15035
| * Add a column linking an MR to its diffSean McGivern2017-11-021-0/+27
| | | | | | | | | | | | We already had this the other way around (merge_request_diffs.merge_request_id), but this is needed to gather only the most recent diffs for a set of merge requests.
* | Remove user authentication_token columnDouwe Maan2017-11-021-0/+20
|/
* Don't rename groups/projects that aren't reserved anymorebvl-dont-rename-free-namesBob Van Landuyt2017-10-241-11/+0
| | | | | In https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/12932 we freed up some names. But we were still renaming them.
* Move migration to backgroundMichael Kozono2017-10-071-284/+9
|
* Update DN class in migrationMichael Kozono2017-10-071-41/+60
|
* Rename method to `to_normalized_s`Michael Kozono2017-10-071-2/+2
|
* Normalize existing persisted DNsMichael Kozono2017-10-071-0/+285
|
* Add more specs.36829-gpg-commit-not-verified-if-signed-with-a-subkeyRubén Dávila2017-10-051-1/+2
|
* Small refactor and fix for RuboCopRubén Dávila2017-10-051-2/+4
|
* Convert migrations to generate subkeys to a background migrationRubén Dávila2017-10-052-61/+25
|
* Invalidate GpgSignatures associated to GpgKeySubkeys when revoking the GpgKeyRubén Dávila2017-10-051-1/+1
|
* Address some feedback from last code reviewRubén Dávila2017-10-051-1/+3
|
* Convert migration to a post deployment migrationRubén Dávila2017-10-051-0/+59
| | | | | This migration can take a bit of time to complete and I don't want to delay the deployment process.
* Merge branch ↵Rémy Coutable2017-09-291-0/+32
|\ | | | | | | | | | | | | | | | | '36631-activerecord-statementinvalid-pg-querycanceled-error-canceling-statement-due-to-statement-timeout' into 'master' Insert at most 1,000 rows at once in MR diff background migration Closes #36631 et #37505 See merge request gitlab-org/gitlab-ce!13661
| * Reschedule merge request diff background migration36631-activerecord-statementinvalid-pg-querycanceled-error-canceling-statement-due-to-statement-timeoutSean McGivern2017-09-291-0/+32
| | | | | | | | | | | | | | | | | | | | | | | | | | The first attempt didn't migrate all rows on GitLab.com, due to a couple of issues: 1. Some rows in merge_request_diffs had truly huge numbers of commits and diffs serialised - one in particular had 26,000 commits! 2. The jobs were sometimes on Sidekiq hosts with frequent OOM errors, leading to the job being lost. The previous commit adds more logging, and a more robust insertion method. This commit reschedules the jobs, with a generous pause between each.
* | Fix notes type created from importLin Jen-Shin (godfat)2017-09-292-0/+32
|/
* Fix PG::UniqueViolation external_email migrationsh-fix-email-provider-take2Stan Hu2017-09-251-1/+1
| | | | | | Missing parens prevented this migration from working in some cases. Closes #38246
* Fix duplicate key errors in PostDeployMigrateUserExternalMailData migrationsh-fix-issue-38246Stan Hu2017-09-221-1/+1
| | | | | | | | | | | `email_provider` by default is NULL, and if a user had not logged the value would remain NULL. Upgrading to GitLab 10.0 would lead to a PG::UniqueViolation because the post-deploy migration would attempt to reinsert the entry because the NULL comparison between `users.email_provider` and `user_synced_attributes_metadata.email_provider` would never match. Closes #38246
* Merge branch 'mk-delete-conflicting-redirects-mysql' into 'master'Douwe Maan2017-09-181-0/+37
|\ | | | | | | | | | | | | Clean up redirect routes that conflict with regular routes Closes #36229 See merge request gitlab-org/gitlab-ce!13783
| * Reduce batch sizemk-delete-conflicting-redirects-mysqlMichael Kozono2017-09-141-1/+3
| | | | | | | | …to stay within our query timeout of 60s. Also reduce the job interval to keep the same overall migration time of ~3.3 days.
| * Spread out the work a littleMichael Kozono2017-09-141-1/+1
| |
| * Extract helper for queuing background jobsMichael Kozono2017-09-141-32/+1
| |
| * Add specs for deleting conflicting redirectsMichael Kozono2017-09-141-1/+1
| |
| * Delete conflicting redirects in backgroundMichael Kozono2017-09-141-0/+66
| |
* | Add data migrationFelipe Artur2017-09-151-0/+33
|/
* Merge branch 'events-migration-cleanup' into 'master'Sean McGivern2017-09-071-0/+48
|\ | | | | | | | | | | | | Finish migration to the new events setup Closes #37241 See merge request !13932
| * Finish migration to the new events setupevents-migration-cleanupYorick Peterse2017-09-061-0/+48
| | | | | | | | | | | | | | | | | | | | | | | | | | This finishes the procedure for migrating events from the old format into the new format. Code no longer uses the old setup and the database tables used during the migration process are swapped, with the old table being dropped. While the database migration can be reversed this will 1) take a lot of time as data has to be coped around 2) won't restore data in the "events.data" column as we have no way of restoring this. Fixes https://gitlab.com/gitlab-org/gitlab-ce/issues/37241
* | Merge branch 'dz-rebuild-schema' into 'master'Yorick Peterse2017-09-071-2/+2
|\ \ | | | | | | | | | | | | Update schema.rb from db:migrate and fix invalid index check See merge request !14107
| * | Update schema.rb from db:migrate and fix invalid index checkdz-rebuild-schemaDmitriy Zaporozhets2017-09-071-2/+2
| |/ | | | | | | Signed-off-by: Dmitriy Zaporozhets <dmitriy.zaporozhets@gmail.com>
* | Profile updates from providersAlexander Keramidas2017-09-063-0/+81
|/
* remove obsolete migrationAlexis Reigel2017-09-051-23/+0
| | | | | as we destroy all gpg_signatures we don't need to downcase the email addresses anymore.
* truncate gpg signature instead of destroyAlexis Reigel2017-09-051-12/+1
|
* remove valid_signature from gpg_signaturesAlexis Reigel2017-09-051-0/+11
|
* destroy signatures instead of updating themAlexis Reigel2017-09-052-14/+21
| | | | | | This is faster for the deployment process, as the destroyed signatures will be re-generated on demand again, instead of updating them all on deploy.
* update all signatures with the verification statusAlexis Reigel2017-09-051-0/+14
|
* downcase all GpgSignature#gpg_key_user_emailAlexis Reigel2017-09-051-0/+23
|
* Merge commit '2be34630623711fc20ef8c101b5cef688f207cc1' into ↵backstage/gb/rename-ci-cd-processing-sidekiq-queuesGrzegorz Bizon2017-08-261-4/+4
|\ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | backstage/gb/rename-ci-cd-processing-sidekiq-queues * commit '2be34630623711fc20ef8c101b5cef688f207cc1': Common Docker Documentation Location in `gitlab-ce` fix deprecation warning present during webpack compiles Enable 5 lines of Sidekiq backtrace lines to aid in debugging Add support for copying permalink to notes via more actions dropdown Handle creating a nested group on MySQL correctly Decrease statuses batch size even more in a migration Fix repo editor scrollbar Replace 'source/search_code.feature' spinach test with an rspec analog Authorizations regarding OAuth - style confirmation Update README.md Refactor complicated API group finding rules into GroupsFinder Fix group and project search for anonymous users Document version Group Milestones API introduced Allow v4 API GET requests for groups to be unauthenticated Adjust a range and a size in stages statuses migration Update README.md Point to /developers on docs/administration/authentiq.md Indexes GFM markdown guide use inline links instead of referenced Add index on ci_runners.contacted_at
| * Decrease statuses batch size even more in a migrationGrzegorz Bizon2017-08-251-1/+1
| |
| * Adjust a range and a size in stages statuses migrationbackstage/gb/improve-stages-statuses-migrationGrzegorz Bizon2017-08-231-4/+4
| |
* | Migrate new jobs when reverting pipeline queues migrationGrzegorz Bizon2017-08-251-0/+3
| |
* | Merge branch 'master' into 'backstage/gb/rename-ci-cd-processing-sidekiq-queues'Kamil Trzciński2017-08-251-0/+54
|\ \ | |/ | | | | # Conflicts: # db/schema.rb
| * Use EachBatch concern to loop over batchestc-remove-nonexisting-namespace-pending-delete-projectsToon Claes2017-08-221-21/+21
| |
| * Migration to remove pending delete projects with non-existing namespaceToon Claes2017-08-221-0/+54
| | | | | | | | | | | | | | There might be some projects where the namespace was removed, but the project wasn't. For these the projects still have a `namespace_id` set. So this adds a post-deploy migration remove all projects that are pending delete, and have a `namespace_id` that is non-existing.