Welcome to mirror list, hosted at ThFree Co, Russian Federation.

gitlab.com/gitlab-org/gitlab-foss.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
path: root/db
AgeCommit message (Collapse)Author
2018-11-29Move drop_site_statistics to be a post deployment migrationGabriel Mazetto
As post deployment migration we don't need to make it a migration that requires downtime
2018-11-29Store hashed storage paths in the databaseToon Claes
2018-11-29Merge branch 'security-fix-uri-xss-applications' into 'master'Cindy Pallares
[master] Resolve "Reflected XSS in OAuth Authorize window due to redirect_uri allowing arbitrary protocols" See merge request gitlab/gitlabhq!2572
2018-11-29Merge branch 'security-stored-xss-for-environments' into 'master'Cindy Pallares
[master] Stored XSS for Environments Closes #2727 See merge request gitlab/gitlabhq!2594
2018-11-28Merge branch 'zj-object-pool-path' into 'master'Nick Thomas
Rename Repository table to PoolRepository See merge request gitlab-org/gitlab-ce!23236
2018-11-28Move code to a BackgroundMigrationToon Claes
And run in intervals.
2018-11-28Migration to write fullpath in all repository configsToon Claes
In https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/16027 it was added to write `gitlab.fullpath` in the git config of all repositories. But this only writes them on move or migrate to hashed storage. This adds a migration that writes the fullpath to all the repositories. Closes https://gitlab.com/gitlab-org/gitlab-ce/issues/41776
2018-11-27Merge branch '53778-remove-site-statistics' into 'master'Sean McGivern
Remove Site Statistic Closes #53778 See merge request gitlab-org/gitlab-ce!23314
2018-11-27Rename the Repository table to PoolRepositoryZeger-Jan van de Weg
To separate the different kinds of repositories we have at GitLab this table will be renamed to pool_repositories. A project can, for now at least, be member of none, or one of these. The table will get additional columns in a later merge request where more logic is implemented for the model. Further included is a small refactor of logic around hashing ids for the disk_path, mainly to ensure a previous implementation is reusable. The disk_path for the pool_repositories table no longer has a NOT NULL constraint, but given the hashing of the ID requires the DB to assign the record an ID, an after_create hook is used to update the value. A related MR is: https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/23143, adding tables for 'normal' repositories and wiki_repositories.
2018-11-27Merge branch 'triggermesh-phase2-external-ip' into 'master'Kamil Trzciński
Expose External IP address for Knative's gateway See merge request gitlab-org/gitlab-ce!23162
2018-11-27Remove Site StatisticGabriel Mazetto
This approach caused many different problems as we tightened the query execution timeout.
2018-11-26Expose external_ip to knative cluster applicationChris Baumbauer
2018-11-26Remove notes index on updated_atLin Jen-Shin
2018-11-26Add events index on project_id and created_atLin Jen-Shin
2018-11-23Merge branch 'certmanager-temp' into 'master'Kamil Trzciński
Deploy cert-manager to managed cluster for SSL certificates See merge request gitlab-org/gitlab-ce!23036
2018-11-22Add version 4.2 to all existing migrationsJan Provaznik
DB schema generated by a migration may look different in rails 4 and 5 (because rails 5 may use different default values). For this reason it's important to explicitly set for which rails version a migration was written for. See https://stackoverflow.com/questions/35929869/activerecordmigration-deprecation-warning-asks-for-rails-version-but-im-no/35930912#35930912
2018-11-22Updated migration filesAmit Rathi
2018-11-21unique: true on cluster_id index on cert_managerAmit Rathi
2018-11-21Eliminate duplicated wordsTakuya Noguchi
Signed-off-by: Takuya Noguchi <takninnovationresearch@gmail.com>
2018-11-20Merge branch 'master' into certmanager-tempAmit Rathi
2018-11-19Updated schema.rb and remove extra char from install_commandAmit Rathi
2018-11-19Merge branch 'master' into certmanager-tempAmit Rathi
2018-11-19adding cluster_id index to cert_manager migrartionAmit Rathi
2018-11-19Remove unnecessary codeShinya Maeda
2018-11-19Merge branch 'master-ce' into drop-default-value-status-deploymentsShinya Maeda
2018-11-19Fix nilShinya Maeda
2018-11-15Add missing cluster_id on knativeKamil Trzciński
2018-11-15Cleanup schema.rbAmit Rathi
2018-11-15Remove indexes for FKKamil Trzciński
2018-11-15Validate foreign keys being indexedKamil Trzciński
2018-11-14Update db/schema.rb according to Rails 5Jan Provaznik
* add_index replaced with t.index * intiger(size 8) replaced with bigint
2018-11-14Revert "Merge branch 'revert-drop-gcp-clusters-table' into 'master'"Kamil Trzciński
2018-11-13CleanupAmit Rathi
2018-11-13Cert manager migration, cluster_issuer etc.Amit Rathi
2018-11-13Updated loggingAmit Rathi
2018-11-13Remove unnecessary line in schema.rbShinya Maeda
2018-11-13Drop default value on status column in deployments tableShinya Maeda
2018-11-12Merge branch 'master' into certmanager-tempAmit Rathi
2018-11-07CE backport - Chart showing issues created per monthConstance Okoghenun
2018-11-07Merge branch 'triggermesh-phase1-knative' into 'master'Grzegorz Bizon
Allow to install Knative as cluster application See merge request gitlab-org/gitlab-ce!22593
2018-11-07Merge branch 'fix-environment-status-in-merge-request-widget' into 'master'Sean McGivern
Fix environment status in merge request widget Closes #51120 and #25140 See merge request gitlab-org/gitlab-ce!22799
2018-11-07Merge branch '43521-keep-personal-emails-private' into 'master'Douwe Maan
Adds option to override commit email Closes #43521 See merge request gitlab-org/gitlab-ce!22560
2018-11-07Merge branch 'refactor-snippets-finder' into 'master'Douwe Maan
Rewrite SnippetsFinder to improve performance Closes #52639 See merge request gitlab-org/gitlab-ce!22606
2018-11-07Remove low selective indexesShinya Maeda
2018-11-07User can keep their commit email privateTiago Botelho
The private commit email is automatically generated in the format: id-username@noreply.HOSTNAME GitLab instance admins are able to change the HOSTNAME portion, that defaults to Gitlab's hostname, to whatever they prefer.
2018-11-07Add migration to steal FillStoreUploadToon Claes
2018-11-07Enhance performance of counting local UploadsToon Claes
Add an index to the `store` column on `uploads`. This makes counting local uploads faster. Also, there is no longer need to check for objects with `store = NULL`. See https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18557 --- ### Query plans Query: ```sql SELECT COUNT(*) FROM "uploads" WHERE ("uploads"."store" = ? OR "uploads"."store" IS NULL) ``` #### Without index ``` gitlabhq_production=# EXPLAIN ANALYZE SELECT uploads.* FROM uploads WHERE (uploads.store = 1 OR uploads.store IS NULL); QUERY PLAN --------------------------------------------------------------------------------------------------------------- Seq Scan on uploads (cost=0.00..601729.54 rows=578 width=272) (actual time=6.170..2308.256 rows=545 loops=1) Filter: ((store = 1) OR (store IS NULL)) Rows Removed by Filter: 4411957 Planning time: 38.652 ms Execution time: 2308.454 ms (5 rows) ``` #### Add index ``` gitlabhq_production=# create index uploads_tmp1 on uploads (store); CREATE INDEX ``` #### With index ``` gitlabhq_production=# EXPLAIN ANALYZE SELECT uploads.* FROM uploads WHERE (uploads.store = 1 OR uploads.store IS NULL); QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------- Bitmap Heap Scan on uploads (cost=11.46..1238.88 rows=574 width=272) (actual time=0.155..0.577 rows=545 loops=1) Recheck Cond: ((store = 1) OR (store IS NULL)) Heap Blocks: exact=217 -> BitmapOr (cost=11.46..11.46 rows=574 width=0) (actual time=0.116..0.116 rows=0 loops=1) -> Bitmap Index Scan on uploads_tmp1 (cost=0.00..8.74 rows=574 width=0) (actual time=0.095..0.095 rows=545 loops=1) Index Cond: (store = 1) -> Bitmap Index Scan on uploads_tmp1 (cost=0.00..2.44 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=1) Index Cond: (store IS NULL) Planning time: 0.274 ms Execution time: 0.637 ms (10 rows) ``` Closes https://gitlab.com/gitlab-org/gitlab-ee/issues/6070
2018-11-07Add index on created_at with statusShinya Maeda
2018-11-07Bring back created indexesShinya Maeda
2018-11-07Merge branch 'master-ce' into fix-environment-status-in-merge-request-widgetShinya Maeda