1. 17 May, 2018 18 commits
    • Rémy Coutable's avatar
      Merge branch 'order_groups' into 'master' · be54edbf
      Rémy Coutable authored
      Fix: Use case in-sensitive ordering by name for groups
      
      See merge request gitlab-org/gitlab-ce!18553
      be54edbf
    • Harish Ved's avatar
      b11c218a
    • Robert Speicher's avatar
      Merge branch '6020-extract-ee-specific-controller-lines' into 'master' · 47555ef8
      Robert Speicher authored
      [CE]  Resolve "Extract EE specific files/lines for some controllers"
      
      See merge request gitlab-org/gitlab-ce!18994
      47555ef8
    • Grzegorz Bizon's avatar
      Merge branch 'pipelines-index-performance' into 'master' · 4583e67c
      Grzegorz Bizon authored
      Improve performance of Projects::PipelinesController#index
      
      See merge request gitlab-org/gitlab-ce!18427
      4583e67c
    • Grzegorz Bizon's avatar
      Merge branch '46177-fix-present-on-generic-commit-status' into 'master' · d9b78477
      Grzegorz Bizon authored
      Resolve "NoMethodError: undefined method `present' for #<GenericCommitStatus:0x00007f6eacf34a40>"
      
      Closes #46177
      
      See merge request gitlab-org/gitlab-ce!18979
      d9b78477
    • Achilleas Pipinellis's avatar
      Merge branch... · 2eb8099f
      Achilleas Pipinellis authored
      Merge branch 'docs/46042-document-that-project-templates-can-be-used-with-auto-devops' into 'master'
      
      Resolve "Document that Project Templates can be used with Auto DevOps"
      
      Closes #46042
      
      See merge request gitlab-org/gitlab-ce!19009
      2eb8099f
    • Mayra Cabrera's avatar
      Add changelog · 22d3e90c
      Mayra Cabrera authored
      22d3e90c
    • Fabio Busatto's avatar
      Update quick_start_guide.md · 143a98a3
      Fabio Busatto authored
      143a98a3
    • Yorick Peterse's avatar
      da7bbef8
    • Yorick Peterse's avatar
      Exclude coverage data from the pipelines page · 878ca2e6
      Yorick Peterse authored
      When displaying a project's pipelines
      (Projects::PipelinesController#index) we now exclude the coverage data.
      This data was not used by the frontend, yet getting it would require one
      SQL query per pipeline. These queries in turn could be quite expensive
      on GitLab.com.
      878ca2e6
    • Yorick Peterse's avatar
      Preload pipeline data for project pipelines · 19428e80
      Yorick Peterse authored
      When displaying the pipelines of a project we now preload the following
      data:
      
      1. Authors of the commits that belong to these pipelines
      2. The number of warnings per pipeline, which is used by
         Ci::Pipeline#has_warnings?
      
      == Commit Authors
      
      Previously this data was queried for every Commit separately, leading to
      20 SQL queries being executed in the worst case. With an average of 3 to
      5 milliseconds per SQL query this could result in 100 milliseconds being
      spent in _just_ getting Commit authors.
      
      To preload this data Commit#author now uses BatchLoader (through
      Commit#lazy_author), and a separate module
      Gitlab::Ci::Pipeline::Preloader is used to ensure all authors are loaded
      before they are used.
      
      == Number of warnings
      
      This changes Ci::Pipeline#has_warnings? so it supports preloading of the
      number of warnings per pipeline. This removes the need for executing a
      COUNT(*) query for every pipeline just to see if it has any warnings or
      not.
      19428e80
    • Yorick Peterse's avatar
      Limit the number of pipelines to count · 70985aa1
      Yorick Peterse authored
      When displaying the project pipelines dashboard we display a few tabs
      for different pipeline states. For every such tab we count the number of
      pipelines that belong to it. For large projects such as GitLab CE this
      means having to count over 80 000 rows, which can easily take between 70
      and 100 milliseconds per query.
      
      To improve this we apply a technique we already use for search results:
      we limit the number of rows to count. The current limit is 1000, which
      means that if more than 1000 rows are present for a state we will show
      "1000+" instead of the exact number. The SQL queries used for this
      perform much better than a regular COUNT, even when a project has a lot
      of pipelines.
      
      Prior to these changes we would end up running a query like this:
      
          SELECT COUNT(*)
          FROM ci_pipelines
          WHERE project_id = 13083
          AND status IN ('success', 'failed', 'canceled')
      
      This would produce a plan along the lines of the following:
      
          Aggregate  (cost=3147.55..3147.56 rows=1 width=8) (actual time=501.413..501.413 rows=1 loops=1)
            Buffers: shared hit=17116 read=861 dirtied=2
            ->  Index Only Scan using index_ci_pipelines_on_project_id_and_ref_and_status_and_id on ci_pipelines  (cost=0.56..2984.14 rows=65364 width=0) (actual time=0.095..490.263 rows=80388 loops=1)
                  Index Cond: (project_id = 13083)
                  Filter: ((status)::text = ANY ('{success,failed,canceled}'::text[]))
                  Rows Removed by Filter: 2894
                  Heap Fetches: 353
                  Buffers: shared hit=17116 read=861 dirtied=2
          Planning time: 1.409 ms
          Execution time: 501.519 ms
      
      Using the LIMIT count technique we instead run the following query:
      
          SELECT COUNT(*)
          FROM (
              SELECT 1
              FROM ci_pipelines
              WHERE project_id = 13083
              AND status IN ('success', 'failed', 'canceled')
              LIMIT 1001
          ) for_count
      
      This query produces the following plan:
      
          Aggregate  (cost=58.77..58.78 rows=1 width=8) (actual time=1.726..1.727 rows=1 loops=1)
            Buffers: shared hit=169 read=15
            ->  Limit  (cost=0.56..46.25 rows=1001 width=4) (actual time=0.164..1.570 rows=1001 loops=1)
                  Buffers: shared hit=169 read=15
                  ->  Index Only Scan using index_ci_pipelines_on_project_id_and_ref_and_status_and_id on ci_pipelines  (cost=0.56..2984.14 rows=65364 width=4) (actual time=0.162..1.426 rows=1001 loops=1)
                        Index Cond: (project_id = 13083)
                        Filter: ((status)::text = ANY ('{success,failed,canceled}'::text[]))
                        Rows Removed by Filter: 9
                        Heap Fetches: 10
                        Buffers: shared hit=169 read=15
          Planning time: 1.832 ms
          Execution time: 1.821 ms
      
      While this query still uses a Filter for the "status" field the number
      of rows that it may end up filtering (at most 1001) is small enough that
      an additional index does not appear to be necessary at this time.
      
      See https://gitlab.com/gitlab-org/gitlab-ce/issues/43132#note_68659234
      for more information.
      70985aa1
    • Douwe Maan's avatar
      Merge branch '42531-open-invite-404' into 'master' · ec7163ae
      Douwe Maan authored
      Resolve "Opening Project with invite but without accepting leads to 404 error page"
      
      Closes #42531
      
      See merge request gitlab-org/gitlab-ce!17634
      ec7163ae
    • 🙈  jacopo beschi 🙉's avatar
    • Douwe Maan's avatar
      Merge branch 'ce-5980-add-ce-upgrade-ee-test' into 'master' · bbd8d5b2
      Douwe Maan authored
      CE: Add jobs to verify that migrating from CE to EE works
      
      See merge request gitlab-org/gitlab-ce!18909
      bbd8d5b2
    • Grzegorz Bizon's avatar
      Merge branch 'zj-workhorse-commit-patch-diff' into 'master' · 48877dfc
      Grzegorz Bizon authored
      Workhorse to send raw diff and patch for commits
      
      Closes gitaly#1196
      
      See merge request gitlab-org/gitlab-ce!18974
      48877dfc
    • Phil Hughes's avatar
      Merge branch 'remove-css-imports' into 'master' · 2f7e0aba
      Phil Hughes authored
      Remove unneccessary imports
      
      See merge request gitlab-org/gitlab-ce!18993
      2f7e0aba
    • Phil Hughes's avatar
      Merge branch 'jivl-add-dot-system-notes' into 'master' · e5289643
      Phil Hughes authored
      Add dot to separate system notes content
      
      Closes #45676
      
      See merge request gitlab-org/gitlab-ce!18864
      e5289643
  2. 16 May, 2018 22 commits