summaryrefslogtreecommitdiff
path: root/db
Commit message (Collapse)AuthorAgeFilesLines
* Remove depreceted and big projectsZeger-Jan van de Weg2017-09-201-2/+2
|
* Merge branch 'reoganize-deployment-indexes' into 'master'Stan Hu2017-09-193-2/+52
|\ | | | | | | | | | | | | Reorganize indexes for the "deployments" table Closes #36877 See merge request gitlab-org/gitlab-ce!14348
| * Reorganize indexes for the "deployments" tablereoganize-deployment-indexesYorick Peterse2017-09-193-2/+52
| | | | | | | | | | | | | | | | | | This removes the need for a default scope that adds a "WHERE project_id = X" clause. This commit also includes an additional index for Environment#last_deployment, ensuring this query uses just an index scan instead of also applying a Filter. Fixes https://gitlab.com/gitlab-org/gitlab-ce/issues/36877
* | Merge branch 'fix-rails-migrations-for-partial-indexes' into 'master'Yorick Peterse2017-09-191-1/+1
|\ \ | | | | | | | | | | | | Fix regular expression used for opclasses to not be confused by partial index clause See merge request gitlab-org/gitlab-ce!14343
| * | Fix regular expression used for opclasses to not be confused by partial ↵fix-rails-migrations-for-partial-indexesGreg Stark2017-09-191-1/+1
| |/ | | | | | | index clause
* | Make sure all stages are migrated after a cleanupbackstage/gb/steal-stages-statuses-migrationGrzegorz Bizon2017-09-181-0/+11
| |
* | Steal stages statuses migrationGrzegorz Bizon2017-09-181-0/+15
|/
* 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
| |
* | Merge branch 'master' into 'issue_37640'issue_37640Felipe Artur2017-09-155-3/+94
|\ \ | |/ | | | | # Conflicts: # db/schema.rb
| * Add missing index for getting recent push eventsindexes-for-recent-push-eventsYorick Peterse2017-09-142-2/+42
| | | | | | | | | | | | | | | | | | This index is required to allow fast retrieval of recent push events without merge requests. Without this index in place the query would lead to PostgreSQL scanning over 150 000 index entries all the time, easily taking up between 200 and 500 milliseconds. This index reduces the time spent in this process to around 40 milliseconds on GitLab.com.
| * Merge branch 'ci-environment-status-performance' into 'master'Stan Hu2017-09-142-2/+18
| |\ | | | | | | | | | | | | | | | | | | Constrain environment deployments to project IDs Closes #36877 See merge request gitlab-org/gitlab-ce!14252
| | * Disallow NULL values for environments.project_idci-environment-status-performanceYorick Peterse2017-09-132-2/+18
| | |
| * | Revert "Merge branch 'rs-remove-bad-foreground-migration' into 'master'"Robert Speicher2017-09-131-0/+57
| |/ | | | | This reverts merge request !14240
| * Remove db/migrate/20170828135939_migrate_user_external_mail_data.rbRobert Speicher2017-09-121-57/+0
| | | | | | | | | | | | | | | | | | | | This file is a duplicate of a post-deploy migration and appears to have been left in by mistake. Looping through the Users table in a foreground migration would've been a bad idea. [ci skip]
| * Merge branch 'revert-2f46c3a8' into 'master'Robert Speicher2017-09-122-0/+11
| |\ | | | | | | | | | | | | Revert "Merge branch 'revert-f2421b2b' into 'master'" See merge request !14190
| | * Revert "Merge branch 'revert-f2421b2b' into 'master'"revert-2f46c3a8Annabel Dunstone Gray2017-09-112-0/+11
| | | | | | | | | This reverts merge request !14148
| * | Reset primary keys after swapping events tablesreset-events-primary-key-mysqlYorick Peterse2017-09-111-0/+24
| |/ | | | | | | | | This is required as otherwise newly created events will start with the wrong ID.
* | Add data migrationFelipe Artur2017-09-152-1/+34
|/
* Revert "Merge branch ↵revert-f2421b2bRubén Dávila2017-09-082-11/+0
| | | | | '35012-navigation-add-option-to-change-navigation-color-palette' into 'master'" This reverts merge request !13619
* Merge branch 'jk-update-schema' into 'master'rd-testYorick Peterse2017-09-071-1/+1
|\ | | | | | | | | Update db schema to correspond with migrations See merge request !14115
| * Update db schema to correspond with migrationsjk-update-schemaJarka Kadlecova2017-09-071-1/+1
| |
* | Merge remote-tracking branch 'origin/master' into ↵Kamil Trzcinski2017-09-077-50/+129
|\ \ | |/ | | | | zj/gitlab-ce-zj-auto-devops-table
| * Merge branch ↵Sean McGivern2017-09-072-0/+11
| |\ | | | | | | | | | | | | | | | | | | | | | | | | '35012-navigation-add-option-to-change-navigation-color-palette' into 'master' Add option to change navigation color palette Closes #35012 See merge request !13619
| | * Add theme_id column to users tableRubén Dávila2017-09-062-0/+11
| | |
| * | Merge branch 'events-migration-cleanup' into 'master'Sean McGivern2017-09-075-28/+96
| |\ \ | | | | | | | | | | | | | | | | | | | | | | | | Finish migration to the new events setup Closes #37241 See merge request !13932
| | * | Finish migration to the new events setupevents-migration-cleanupYorick Peterse2017-09-065-28/+96
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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-072-24/+25
| |\ \ \ | | | | | | | | | | | | | | | | | | | | 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-072-24/+25
| | | | | | | | | | | | | | | | | | | | Signed-off-by: Dmitriy Zaporozhets <dmitriy.zaporozhets@gmail.com>
* | | | | Merge branch 'master' into zj-auto-devops-tablezj/gitlab-ce-zj-auto-devops-tableZeger-Jan van de Weg2017-09-071-0/+1
|\ \ \ \ \ | |/ / / /
| * | | | reset namespace columns in migrationjk-fix-migrateJarka Kadlecova2017-09-061-0/+1
| | |_|/ | |/| |
* | | | Fix ordering of columns on new tableZeger-Jan van de Weg2017-09-072-11/+6
| | | |
* | | | Merge branch 'master' of gitlab.com:gitlab-org/gitlab-ce into ↵Kamil Trzcinski2017-09-066-2/+164
|\ \ \ \ | |/ / / | | | | | | | | zj/gitlab-ce-zj-auto-devops-table
| * | | Profile updates from providersAlexander Keramidas2017-09-066-2/+164
| | | |
* | | | Merge branch 'master' into zj-auto-devops-tableZeger-Jan van de Weg2017-09-0613-2/+173
|\ \ \ \ | |/ / /
| * | | Resolve outdated diff discussions on pushSean McGivern2017-09-062-1/+11
| | | |
| * | | Fix migrationSean McGivern2017-09-062-12/+4
| | | |
| * | | change collapse to resolve and comments to discussionsAshley Dumaine2017-09-062-4/+3
| | | |
| * | | Add functionality to collapse outdated diff comments regardless of ↵Ashley Dumaine2017-09-062-0/+19
| | |/ | |/| | | | | | | discussion resolution
| * | Merge branch 'master' into '36860-migrate-issues-author'36860-migrate-issues-authorDouwe Maan2017-09-055-1/+52
| |\ \ | | |/ | | | | | | # Conflicts: # db/schema.rb
| | * 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-052-21/+2
| | |
| | * remove valid_signature from gpg_signaturesAlexis Reigel2017-09-052-2/+12
| | |
| | * 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.
| | * destroy all signatures and add with default valueAlexis Reigel2017-09-052-3/+24
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | To avoid having to implement legacy code handling for the obsolete `verified_signature` attribute and to avoid any race conditions during the zero-downtime-deployment we do the following: 1. Destroy all records 2. Migration: Use add_column_with_default to add the new attribute and update the verification_status values on records created between 1. and 2. 3. Deploy the new code 4. Post migration: Destroy all records Like this we make sure that at no point there is a record with a `nil` value for the new `verification_status` attribute.
| | * update all signatures with the verification statusAlexis Reigel2017-09-051-0/+14
| | |
View Lorry Controller Status