Wiki pages are still very slow to load
Summary
The GHC installation (#55039 (moved)) has been seeing Wiki page load times of several seconds.
Note that we previously reported this as https://gitlab.com/gitlab-org/gitlab-ce/issues/53523, which has been closed as the issue is supposedly fixed.
Steps to reproduce
- Push the GHC Wiki to a the Wiki repository of a new project.
- Try to load
/home
page of the Wiki. Notice that the page takes >5 seconds to load.
Example Project
The GHC Wiki.
What is the current bug behavior?
The page takes between four and seven seconds to load. CPU time seems to be split between the ruby
and unicorn
processes. I have attached a profile from the request profiler (although the request timed out before finishing, in this case).
What is the expected correct behavior?
The page should load nearly instantly.
Relevant logs and/or screenshots
(Paste any relevant logs - please use code blocks (```) to format console output, logs, and code as it's tough to read otherwise.)
Output of checks
Results of GitLab environment info
Expand for output related to GitLab environment info
System information System: Proxy: no Current User: root Using RVM: no Ruby Version: unknown Gem Version: Bundler Version:1.17.2 Rake Version: 12.3.2 Redis Version: unknown Git Version: 2.22.0 Sidekiq Version:5.2.7 Go Version: unknownGitLab information Version: 12.0.3-ee Revision: Unknown Directory: /nix/store/kpg7k0ca66pif309vv6si5kh1schxhnr-gitlab-ee-12.0.3/share/gitlab DB Adapter: PostgreSQL DB Version: 9.6.13 URL: https://gitlab.haskell.org HTTP Clone URL: https://gitlab.haskell.org/some-group/some-project.git SSH Clone URL: git@gitlab.haskell.org:some-group/some-project.git Elasticsearch: yes Geo: no Using LDAP: no Using Omniauth: yes Omniauth Providers: github
GitLab Shell Version: 9.3.0 Repository storage paths:
- default: /var/gitlab/state/repositories GitLab Shell path: /nix/store/azrxmgh7wv3sd7isk0637715ab9z50di-gitlab-shell-9.3.0 Git: git
Results of GitLab application Check
Expand for output related to the GitLab application check
Checking GitLab subtasks ...Checking GitLab Shell ...
GitLab Shell: ... GitLab Shell version >= 9.3.0 ? ... OK (9.3.0) Running /nix/store/azrxmgh7wv3sd7isk0637715ab9z50di-gitlab-shell-9.3.0/bin/check Check GitLab API access: OK Redis available via internal API: OK
Access to /var/gitlab/state/home/.ssh/authorized_keys: OK gitlab-shell self-check successful
Checking GitLab Shell ... Finished
Checking Gitaly ...
Gitaly: ... default ... OK
Checking Gitaly ... Finished
Checking Sidekiq ...
Sidekiq: ... Running? ... no Try fixing it: sudo -u git -H RAILS_ENV=production bin/background_jobs start For more information see: doc/install/installation.md in section "Install Init Script" see log/sidekiq.log for possible errors Please fix the error above and rerun the checks.
Checking Sidekiq ... Finished
Checking Incoming Email ...
Incoming Email: ... Reply by email is disabled in config/gitlab.yml
Checking Incoming Email ... Finished
Checking LDAP ...
LDAP: ... LDAP is disabled in config/gitlab.yml
Checking LDAP ... Finished
Checking GitLab App ...
Git configured correctly? ... yes Database config exists? ... yes All migrations up? ... yes Database contains orphaned GroupMembers? ... no GitLab config exists? ... yes GitLab config up to date? ... yes Log directory writable? ... yes Tmp directory writable? ... yes Uploads directory exists? ... yes Uploads directory has correct permissions? ... yes Uploads directory tmp has correct permissions? ... no Try fixing it: sudo chown -R git /var/gitlab/state/uploads sudo find /var/gitlab/state/uploads -type f -exec chmod 0644 {} ; sudo find /var/gitlab/state/uploads -type d -not -path /var/gitlab/state/uploads -exec chmod 0700 {} ; For more information see: doc/install/installation.md in section "GitLab" Please fix the error above and rerun the checks. Init script exists? ... no Try fixing it: Install the init script For more information see: doc/install/installation.md in section "Install Init Script" Please fix the error above and rerun the checks. Init script up-to-date? ... can't check because of previous errors Projects have namespace: ... 2/1 ... yes 2/4 ... yes 2/5 ... yes 2/6 ... yes 2/8 ... yes 2/9 ... yes 2/10 ... yes 4/11 ... yes 4/12 ... yes 4/13 ... yes 4/14 ... yes 4/15 ... yes 4/16 ... yes 4/17 ... yes 4/18 ... yes 4/19 ... yes 4/20 ... yes 4/21 ... yes 4/22 ... yes 4/23 ... yes 4/24 ... yes 4/25 ... yes 4/26 ... yes 4/27 ... yes 4/28 ... yes 4/29 ... yes 4/30 ... yes 4/31 ... yes 4/32 ... yes 4/33 ... yes 3/34 ... yes 11/35 ... yes 13/36 ... yes 14/37 ... yes 18/38 ... yes 23/39 ... yes 28/40 ... yes 7/41 ... yes 15/43 ... yes 29/44 ... yes 38/45 ... yes 40/46 ... yes 36/48 ... yes 44/49 ... yes 45/50 ... yes 41/51 ... yes 46/52 ... yes 53/53 ... yes 65/54 ... yes 2/55 ... yes 68/56 ... yes 73/57 ... yes 76/58 ... yes 83/59 ... yes 52/60 ... yes 91/61 ... yes 101/63 ... yes 112/64 ... yes 12/65 ... yes 115/66 ... yes 35/68 ... yes 24/69 ... yes 141/70 ... yes 8/71 ... yes 54/72 ... yes 129/73 ... yes 145/74 ... yes 149/75 ... yes 149/76 ... yes 144/77 ... yes 2/78 ... yes 159/79 ... yes 161/80 ... yes 164/81 ... yes 135/82 ... yes 138/83 ... yes 48/84 ... yes 138/85 ... yes 51/86 ... yes 51/87 ... yes 10/88 ... yes 183/89 ... yes 184/90 ... yes 185/92 ... yes 199/93 ... yes 205/94 ... yes 4/95 ... yes 4/96 ... yes 4/97 ... yes 4/98 ... yes 4/99 ... yes 4/100 ... yes 4/101 ... yes 4/102 ... yes 4/103 ... yes 4/104 ... yes 2/105 ... yes 4/106 ... yes 4/107 ... yes 4/108 ... yes 4/109 ... yes 2/110 ... yes 4/111 ... yes 4/112 ... yes 212/113 ... yes 214/114 ... yes 15/116 ... yes 2/117 ... yes 219/118 ... yes 6/119 ... yes 6/120 ... yes 3/122 ... yes 21/123 ... yes 241/124 ... yes 242/125 ... yes 221/126 ... yes 244/127 ... yes 14/128 ... yes 118/129 ... yes 50/130 ... yes 195/131 ... yes 265/133 ... yes 262/134 ... yes 277/135 ... yes 134/136 ... yes 20/137 ... yes 87/138 ... yes 217/139 ... yes 178/140 ... yes 178/141 ... yes 291/142 ... yes 295/143 ... yes 216/144 ... yes 312/145 ... yes 123/146 ... yes 314/147 ... yes 314/148 ... yes 2/149 ... yes 321/150 ... yes 3/152 ... yes 337/153 ... yes 348/155 ... yes 359/156 ... yes 3/157 ... yes 2/158 ... yes 3/159 ... yes 2/161 ... yes 200/162 ... yes 2674/163 ... yes 3486/164 ... yes 2896/165 ... yes 3487/166 ... yes 187/167 ... yes 344/177 ... yes 52/178 ... yes 144/186 ... yes 144/188 ... yes 174/189 ... yes 276/192 ... yes 1204/193 ... yes 3588/195 ... yes 51/196 ... yes 62/197 ... yes 2757/198 ... yes 2/200 ... yes 3609/203 ... yes 20/204 ... yes 144/205 ... yes 3/206 ... yes 2628/208 ... yes 17/209 ... yes 163/211 ... yes 3684/217 ... yes 3646/218 ... yes 3613/219 ... yes 3353/222 ... yes 311/223 ... yes 177/224 ... yes 253/225 ... yes 3709/227 ... yes 253/228 ... yes 3289/229 ... yes 3719/230 ... yes 3718/231 ... yes 3724/232 ... yes 3723/236 ... yes 2439/239 ... yes 175/243 ... yes 1721/250 ... yes 144/251 ... yes 253/252 ... yes 3268/254 ... yes 138/255 ... yes 654/256 ... yes 3233/257 ... yes 3151/258 ... yes 3831/261 ... yes 3779/262 ... yes 294/266 ... yes 314/267 ... yes 3849/269 ... yes 3853/270 ... yes 3854/271 ... yes 3430/272 ... yes 2505/273 ... yes 3658/275 ... yes 3205/276 ... yes 3884/278 ... yes 328/279 ... yes 2158/283 ... yes 3905/284 ... yes 3912/285 ... yes 3643/286 ... yes 255/287 ... yes 11/288 ... yes 255/290 ... yes 3931/291 ... yes 3943/293 ... yes 2780/294 ... yes 3831/295 ... yes 192/296 ... yes 3/297 ... yes 3977/298 ... yes 2/299 ... yes 3/300 ... yes 2/301 ... yes 3996/303 ... yes 3312/304 ... yes 3999/305 ... yes 4002/306 ... yes 4009/307 ... yes 4011/308 ... yes 4015/309 ... yes 3546/311 ... yes 4020/313 ... yes 4023/314 ... yes 4002/315 ... yes 4001/316 ... yes 4022/317 ... yes 3999/318 ... yes 3999/319 ... yes 79/320 ... yes 121/321 ... yes 1673/322 ... yes 193/323 ... yes 4045/325 ... yes 1166/326 ... yes 4054/327 ... yes 4042/328 ... yes 255/330 ... yes 4076/331 ... yes 163/333 ... yes 44/338 ... yes 4092/340 ... yes 15/341 ... yes 3990/343 ... yes 4108/344 ... yes 3907/345 ... yes 3907/346 ... yes 3907/347 ... yes 4122/348 ... yes 4122/349 ... yes 296/351 ... yes 2041/352 ... yes 3292/355 ... yes 1521/356 ... yes Redis version >= 2.8.0? ... no Try fixing it: Update your redis server to a version >= 2.8.0 For more information see: gitlab-public-wiki/wiki/Trouble-Shooting-Guide in section sidekiq Please fix the error above and rerun the checks. Ruby version >= 2.5.3 ? ... yes (2.5.5) Git version >= 2.21.0 ? ... yes (2.22.0) Git user has default SSH configuration? ... yes Active users: ... 4076 Elasticsearch version 5.6 - 6.x? ... yes (6.7.2)
Checking GitLab App ... Finished
Checking GitLab subtasks ... Finished
Possible fixes
(If you can, link to the line of code that might be responsible for the problem)