summaryrefslogtreecommitdiff
path: root/db
Commit message (Collapse)AuthorAgeFilesLines
* Seed abuse reportsseed-abuse-reportsEric Eastwood2017-02-151-0/+5
| | | | | | | | | ``` rake db:seed_fu FILTER=abuse_reports ``` Thanks to @stanhu, https://gitlab.com/gitlab-org/gitlab-ce/issues/28059#note_23325328
* Use Gitlab::Database.with_connection_pool from !9192remove-inactive-default-email-servicesLin Jen-Shin2017-02-142-41/+24
|
* Disconnect the pool after doneLin Jen-Shin2017-02-141-0/+1
|
* Use threads directly, introduce pool later:Lin Jen-Shin2017-02-141-5/+33
| | | | | Feedback: https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/8987#note_22938402
* Revert "Bump schema to pass `rake db:setup`"Lin Jen-Shin2017-02-141-1/+1
| | | | This reverts commit f2ed7cbc9b36b6ad9bcc714b271e98ead756b816.
* Introduce ThreadedConnectionPool for customized poolLin Jen-Shin2017-02-141-28/+17
| | | | | | | | | This way we could reuse this pool for other migrations Feedback: * https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/8987#note_22923350 * https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/8987#note_22923365
* Bump schema to pass `rake db:setup`Lin Jen-Shin2017-02-141-1/+1
|
* Try this way to provide database connectionLin Jen-Shin2017-02-141-6/+3
|
* Use IS FALSE for both pg and mysql; Handle connectionsLin Jen-Shin2017-02-141-9/+11
| | | | | by ourselves so that even if the setting has 1 connection we could still use more connections.
* Run two threads to improve migration running timeLin Jen-Shin2017-02-141-3/+17
|
* Remove inactive default email servicesLin Jen-Shin2017-02-141-0/+27
| | | | | Note that we no longer generate this by default. This is for clearing legacy default data.
* Merge branch 'option-to-be-notified-of-own-activity' into 'master' Douwe Maan2017-02-132-0/+15
|\ | | | | | | | | Add option to receive email notifications about your own activity See merge request !8836
| * Add notified_of_own_activity column to users tableRichard Macklin2017-02-012-0/+15
| |
* | Merge branch 'sh-add-labels-index' into 'master' Yorick Peterse2017-02-132-0/+14
|\ \ | | | | | | | | | | | | | | | | | | Add indices to improve loading of labels page Closes #25413 See merge request !9121
| * | Add indices to improve loading of labels pagesh-add-labels-indexStan Hu2017-02-132-0/+14
| | |
* | | Enforce use of add_concurrent_foreign_keyconcurrent-foreign-keysYorick Peterse2017-02-103-3/+3
|/ / | | | | | | | | | | | | This adds a Rubocop rule to enforce the use of add_concurrent_foreign_key instead of the regular add_foreign_key method. This cop has been disabled for existing migrations so we don't need to change those.
* | Add index to ci_trigger_requests for commit_idsh-add-index-to-ci-trigger-requestsStan Hu2017-02-102-1/+14
| | | | | | | | | | | | https://gitlab.com/gitlab-org/gitlab-ce/pipelines.json makes a number of unindexed slow queries. This index should speed things up.
* | Migration does not require downtimeDouwe Maan2017-02-081-0/+2
| |
* | Satisfy the new rubocop :)Douwe Maan2017-02-082-2/+10
| |
* | Store group and project full name and full path in routes tabledz-refactor-full-pathDmitriy Zaporozhets2017-02-082-0/+13
| | | | | | | | Signed-off-by: Dmitriy Zaporozhets <dmitriy.zaporozhets@gmail.com>
* | Refactor migration to not require downtime26908-add-foreign-keys-to-timelogsRuben Davila2017-02-074-12/+76
| |
* | Use normal associations instead of polymorphic.Ruben Davila2017-02-072-3/+51
| | | | | | | | | | | | | | We can't properly use foreign keys on columns that are configured for polymorphic associations which has disadvantages related to data integrity and storage. Given we only use time tracking for Issues and Merge Requests we're moving to the usage of regular associations.
* | Merge branch '21518_recaptcha_spam_issues' into 'master'Sean McGivern2017-02-072-1/+17
|\ \ | | | | | | | | | | | | | | | | | | Use reCaptcha when an issue identified as spam Closes #21518 See merge request !8846
| * | Use reCaptcha when an issue identified as spamJarka Kadlecova2017-02-072-1/+17
| | |
* | | Merge branch 'master' into 'jej-pages-to-ce'jej-pages-to-ceJames Edwards-Jones2017-02-064-1/+64
|\ \ \ | |/ / | | | | | | # Conflicts: # db/schema.rb
| * | Introduce maximum session time for terminal websocket connectionterminal-max-session-timeAdam Niedzielski2017-02-062-0/+34
| | | | | | | | | | | | | | | Store the value in application settings. Expose the value to Workhorse.
| * | Add index to labels for `type` and project_id`sh-add-index-for-label-countStan Hu2017-02-042-1/+13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | When loading pages that display the number of open issues, the backend runs a query such as: ```sql SELECT "labels"."id" FROM "labels" WHERE "labels"."type" IN ('ProjectLabel') AND "labels"."project_id" = 1000 ``` This results in an entire scan of the `labels` table. To optimize performance, add the appropriate index to the table. Closes #27676
| * | Fixed DB schemaPhil Hughes2017-02-031-26/+15
| | | | | | | | | | | | Changed how components are added in objects
| * | Remove unnecessary include from RemoveBacklogListsFromBoards migrationDouglas Barbosa Alexandre2017-02-031-2/+0
| | |
| * | Remove backlog lists from boardsDouglas Barbosa Alexandre2017-02-032-15/+45
| | |
* | | Merge branch 'master' into jej-pages-picked-from-eeJames Edwards-Jones2017-02-033-1/+15
|\ \ \ | |/ /
| * | Merge branch 'fwn-to-find-by-full-path' into 'master' Dmitriy Zaporozhets2017-02-031-1/+1
| |\ \ | | | | | | | | | | | | | | | | replace `find_with_namespace` with `find_by_full_path` See merge request !8949
| | * | replace `find_with_namespace` with `find_by_full_path`Adam Pahlevi2017-02-031-1/+1
| | | | | | | | | | | | | | | | add complete changelog for !8949
| * | | Merge branch '20248-add-coverage-regex-in-job-yaml' into 'master'Douwe Maan2017-02-022-0/+14
| |\ \ \ | | |_|/ | |/| | | | | | | | | | | | | | | | | | Add ability to define a coverage regex in the .gitlab-ci.yml Closes #20428 See merge request !7447
| | * | Add ability to define a coverage regex in the .gitlab-ci.ymlLeandro Camargo2017-01-252-0/+14
| | | | | | | | | | | | | | | | * Instead of using the proposed `coverage` key, this expects `coverage_regex`
* | | | Use non-downtime migration for ApplicationSetting’s max_pages_sizeJames Edwards-Jones2017-02-023-10/+21
| | | |
* | | | Pages domain model specsKamil Trzcinski2017-01-311-0/+11
| | | |
* | | | Added PagesDomainKamil Trzcinski2017-01-312-10/+14
| | | |
* | | | Implement proper verification of certificate's public_key against the ↵Kamil Trzcinski2017-01-311-3/+3
| | | | | | | | | | | | | | | | private_key
* | | | Initial work on GitLab Pages updateKamil Trzcinski2017-01-311-0/+10
| | | |
* | | | Add GitLab PagesKamil Trzcinski2017-01-312-0/+6
|/ / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - The pages are created when build artifacts for `pages` job are uploaded - Pages serve the content under: http://group.pages.domain.com/project - Pages can be used to serve the group page, special project named as host: group.pages.domain.com - User can provide own 403 and 404 error pages by creating 403.html and 404.html in group page project - Pages can be explicitly removed from the project by clicking Remove Pages in Project Settings - The size of pages is limited by Application Setting: max pages size, which limits the maximum size of unpacked archive (default: 100MB) - The public/ is extracted from artifacts and content is served as static pages - Pages asynchronous worker use `dd` to limit the unpacked tar size - Pages needs to be explicitly enabled and domain needs to be specified in gitlab.yml - Pages are part of backups - Pages notify the deployment status using Commit Status API - Pages use a new sidekiq queue: pages - Pages use a separate nginx config which needs to be explicitly added
* | | Merge branch '26852-fix-slug-for-openshift' into 'master' Kamil Trzciński2017-01-311-5/+13
|\ \ \ | | | | | | | | | | | | | | | | | | | | | | | | Avoid repeated dashes in $CI_ENVIRONMENT_SLUG Closes #26852 See merge request !8638
| * | | Avoid repeated dashes in $CI_ENVIRONMENT_SLUGNick Thomas2017-01-231-5/+13
| | | |
* | | | Add project ID index to `project_authorizations` table to optimize queriessh-add-project-id-index-project-authorizationsStan Hu2017-01-302-1/+13
| |_|/ |/| | | | | | | | | | | | | | | | | | | | As described in #27443, the `project_authorizations` table is often used to retrieve all team members of this project. This can lead to a number of slow queries impacting load times. This MR adds an index for just `project_id`. Closes #27443
* | | Merge branch 'refresh-authorizations-fork-join' into 'master' Douwe Maan2017-01-2514-11/+37
|\ \ \ | |_|/ |/| | | | | | | | | | | | | | Fix race conditions for AuthorizedProjectsWorker Closes #26194 and #26310 See merge request !8701
| * | Fix race conditions for AuthorizedProjectsWorkerrefresh-authorizations-fork-joinYorick Peterse2017-01-2514-11/+37
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | There were two cases that could be problematic: 1. Because sometimes AuthorizedProjectsWorker would be scheduled in a transaction it was possible for a job to run/complete before a COMMIT; resulting in it either producing an error, or producing no new data. 2. When scheduling jobs the code would not wait until completion. This could lead to a user creating a project and then immediately trying to push to it. Usually this will work fine, but given enough load it might take a few seconds before a user has access. The first one is problematic, the second one is mostly just annoying (but annoying enough to warrant a solution). This commit changes two things to deal with this: 1. Sidekiq scheduling now takes places after a COMMIT, this is ensured by scheduling using Rails' after_commit hook instead of doing so in an arbitrary method. 2. When scheduling jobs the calling thread now waits for all jobs to complete. Solution 2 requires tracking of job completions. Sidekiq provides a way to find a job by its ID, but this involves scanning over the entire queue; something that is very in-efficient for large queues. As such a more efficient solution is necessary. There are two main Gems that can do this in a more efficient manner: * sidekiq-status * sidekiq_status No, this is not a joke. Both Gems do a similar thing (but slightly different), and the only difference in their name is a dash vs an underscore. Both Gems however provide far more than just checking if a job has been completed, and both have their problems. sidekiq-status does not appear to be actively maintained, with the last release being in 2015. It also has some issues during testing as API calls are not stubbed in any way. sidekiq_status on the other hand does not appear to be very popular, and introduces a similar amount of code. Because of this I opted to write a simple home grown solution. After all, all we need is storing a job ID somewhere so we can efficiently look it up; we don't need extra web UIs (as provided by sidekiq-status) or complex APIs to update progress, etc. This is where Gitlab::SidekiqStatus comes in handy. This namespace contains some code used for tracking, removing, and looking up job IDs; all without having to scan over an entire queue. Data is removed explicitly, but also expires automatically just in case. Using this API we can now schedule jobs in a fork-join like manner: we schedule the jobs in Sidekiq, process them in parallel, then wait for completion. By using Sidekiq we can leverage all the benefits such as being able to scale across multiple cores and hosts, retrying failed jobs, etc. The one downside is that we need to make sure we can deal with unexpected increases in job processing timings. To deal with this the class Gitlab::JobWaiter (used for waiting for jobs to complete) will only wait a number of seconds (30 by default). Once this timeout is reached it will simply return. For GitLab.com almost all AuthorizedProjectWorker jobs complete in seconds, only very rarely do we spike to job timings of around a minute. These in turn seem to be the result of external factors (e.g. deploys), in which case a user is most likely not able to use the system anyway. In short, this new solution should ensure that jobs are processed properly and that in almost all cases a user has access to their resources whenever they need to have access.
* | | Make the time estimate migrations reversibleadd-existence-checks-in-backported-migrations-ceRémy Coutable2017-01-242-2/+16
| | | | | | | | | | | | Signed-off-by: Rémy Coutable <remy@rymai.me>
* | | Reject projects without namespacezj-requeue-pending-deleteZ.J. van de Weg2017-01-241-0/+1
| | |
* | | Quote class name in case it gets destroyedZeger-Jan van de Weg2017-01-241-1/+1
| | |
* | | Requeue projects pending deletionZ.J. van de Weg2017-01-241-0/+48
|/ / | | | | | | | | | | | | | | | | | | There have been several bugs in the project deletion service and worker. Resulting in projects stuck in pending delete state, which limits users to create projects with the same name, keeps stale records in the database, and all kinds of other trouble. This post deployment migration requeues all these projects for deletion, in the hope that most of these could be removed by the updated code.