rspec integration pg-10 5/6

Passed Started 5 years ago by
1Running with gitlab-runner 12.2.0-rc1 (a1db02fa)
2  on prm-com-gitlab-org bd091556
 3  Using Docker executor with image dev.gitlab.org:5005/gitlab/gitlab-build-images:ruby-2.6.3-golang-1.11-git-2.22-chrome-73.0-node-12.x-yarn-1.16-postgresql-10-graphicsmagick-1.3.33 ...  
  00:16
4Starting service postgres:10.9 ...
5Pulling docker image postgres:10.9 ...
6Using docker image sha256:897b33033d6498ba789d2ad5b305209106c8b45622b37ad135440a584ec885d3 for postgres:10.9 ...
7Starting service redis:alpine ...
8Pulling docker image redis:alpine ...
9Using docker image sha256:ed7d2ff5a6232b43bdc89a2220ed989f532c3794422aa2a86823b8bc62e71447 for redis:alpine ...
10Waiting for services to be up and running...
11Pulling docker image dev.gitlab.org:5005/gitlab/gitlab-build-images:ruby-2.6.3-golang-1.11-git-2.22-chrome-73.0-node-12.x-yarn-1.16-postgresql-10-graphicsmagick-1.3.33 ...
12Using docker image sha256:f56a8963ab3ec0167e7f96d50025946a254a4069e01e0a2e6c3731fc19cb5c27 for dev.gitlab.org:5005/gitlab/gitlab-build-images:ruby-2.6.3-golang-1.11-git-2.22-chrome-73.0-node-12.x-yarn-1.16-postgresql-10-graphicsmagick-1.3.33 ...
 13  Running on runner-bd091556-project-278964-concurrent-0 via runner-bd091556-prm-1566552461-df197396...  
  00:01
 14  Fetching changes with git depth set to 20...  
  00:15
15Initialized empty Git repository in /builds/gitlab-org/gitlab-ee/.git/
16Created fresh repository.
17From https://gitlab.com/gitlab-org/gitlab-ee
18 * [new branch]      master     -> origin/master
19Checking out 4447c081 as master...
20Skipping Git submodules setup
 21  Checking cache for debian-stretch-ruby-2.6.3-node-12.x-2...  
  00:31
22Downloading cache.zip from https://storage.googleapis.com/gitlab-com-runners-cache/project/278964/debian-stretch-ruby-2.6.3-node-12.x-2 
23Successfully extracted cache
 24  Downloading artifacts for compile-assets (278682829)...  
  01:49
25Downloading artifacts from coordinator... ok        id=278682829 responseStatus=200 OK token=GD3tnYdc
26Downloading artifacts for setup-test-env (278682830)...
27Downloading artifacts from coordinator... ok        id=278682830 responseStatus=200 OK token=M-vJJYAX
28WARNING: tmp/tests/gitlab-shell/.gitlab_shell_secret: chmod tmp/tests/gitlab-shell/.gitlab_shell_secret: no such file or directory (suppressing repeats) 
29Downloading artifacts for retrieve-tests-metadata (278682832)...
30Downloading artifacts from coordinator... ok        id=278682832 responseStatus=200 OK token=Nc9UNA_2
 31  $ date  
  19:19
32Fri Aug 23 10:41:56 UTC 2019
33$ source scripts/utils.sh
34$ source scripts/prepare_build.sh
35Bundler version 1.17.2
36Warning: the running version of Bundler (1.17.2) is older than the version that created the lockfile (1.17.3). We suggest you upgrade to the latest version of Bundler by running `gem install bundler`.
37The Gemfile's dependencies are satisfied
38Successfully installed knapsack-1.17.2
391 gem installed
40CREATE ROLE
41GRANT
42Dropped database 'gitlabhq_test'
43Created database 'gitlabhq_test'
44-- enable_extension("pg_trgm")
45   -> 0.0338s
46-- enable_extension("plpgsql")
47   -> 0.0025s
48-- create_table("abuse_reports", {:id=>:serial, :force=>:cascade})
49   -> 0.0040s
50-- create_table("allowed_email_domains", {:force=>:cascade})
51   -> 0.0053s
52-- create_table("analytics_cycle_analytics_group_stages", {:force=>:cascade})
53   -> 0.0136s
54-- create_table("analytics_cycle_analytics_project_stages", {:force=>:cascade})
55   -> 0.0138s
56-- create_table("appearances", {:id=>:serial, :force=>:cascade})
57   -> 0.0033s
58-- create_table("application_setting_terms", {:id=>:serial, :force=>:cascade})
59   -> 0.0024s
60-- create_table("application_settings", {:id=>:serial, :force=>:cascade})
61   -> 0.0682s
62-- create_table("approval_merge_request_rule_sources", {:force=>:cascade})
63   -> 0.0060s
64-- create_table("approval_merge_request_rules", {:force=>:cascade})
65   -> 0.0124s
66-- create_table("approval_merge_request_rules_approved_approvers", {:force=>:cascade})
67   -> 0.0064s
68-- create_table("approval_merge_request_rules_groups", {:force=>:cascade})
69   -> 0.0066s
70-- create_table("approval_merge_request_rules_users", {:force=>:cascade})
71   -> 0.0063s
72-- create_table("approval_project_rules", {:force=>:cascade})
73   -> 0.0076s
74-- create_table("approval_project_rules_groups", {:force=>:cascade})
75   -> 0.0062s
76-- create_table("approval_project_rules_users", {:force=>:cascade})
77   -> 0.0062s
78-- create_table("approvals", {:id=>:serial, :force=>:cascade})
79   -> 0.0061s
80-- create_table("approver_groups", {:id=>:serial, :force=>:cascade})
81   -> 0.0072s
82-- create_table("approvers", {:id=>:serial, :force=>:cascade})
83   -> 0.0067s
84-- create_table("audit_events", {:id=>:serial, :force=>:cascade})
85   -> 0.0072s
86-- create_table("award_emoji", {:id=>:serial, :force=>:cascade})
87   -> 0.0071s
88-- create_table("badges", {:id=>:serial, :force=>:cascade})
89   -> 0.0067s
90-- create_table("board_assignees", {:id=>:serial, :force=>:cascade})
91   -> 0.0062s
92-- create_table("board_group_recent_visits", {:force=>:cascade})
93   -> 0.0101s
94-- create_table("board_labels", {:id=>:serial, :force=>:cascade})
95   -> 0.0061s
96-- create_table("board_project_recent_visits", {:force=>:cascade})
97   -> 0.0111s
98-- create_table("boards", {:id=>:serial, :force=>:cascade})
99   -> 0.0088s
100-- create_table("broadcast_messages", {:id=>:serial, :force=>:cascade})
101   -> 0.0048s
102-- create_table("chat_names", {:id=>:serial, :force=>:cascade})
103   -> 0.0068s
104-- create_table("chat_teams", {:id=>:serial, :force=>:cascade})
105   -> 0.0048s
106-- create_table("ci_build_needs", {:id=>:serial, :force=>:cascade})
107   -> 0.0047s
108-- create_table("ci_build_trace_chunks", {:force=>:cascade})
109   -> 0.0046s
110-- create_table("ci_build_trace_section_names", {:id=>:serial, :force=>:cascade})
111   -> 0.0046s
112-- create_table("ci_build_trace_sections", {:id=>:serial, :force=>:cascade})
113   -> 0.0087s
114-- create_table("ci_builds", {:id=>:serial, :force=>:cascade})
115   -> 0.0529s
116-- create_table("ci_builds_metadata", {:id=>:serial, :force=>:cascade})
117   -> 0.0080s
118-- create_table("ci_builds_runner_session", {:force=>:cascade})
119   -> 0.0049s
120-- create_table("ci_group_variables", {:id=>:serial, :force=>:cascade})
121   -> 0.0068s
122-- create_table("ci_job_artifacts", {:id=>:serial, :force=>:cascade})
123   -> 0.0111s
124-- create_table("ci_job_variables", {:force=>:cascade})
125   -> 0.0073s
126-- create_table("ci_pipeline_chat_data", {:force=>:cascade})
127   -> 0.0065s
128-- create_table("ci_pipeline_schedule_variables", {:id=>:serial, :force=>:cascade})
129   -> 0.0050s
130-- create_table("ci_pipeline_schedules", {:id=>:serial, :force=>:cascade})
131   -> 0.0121s
132-- create_table("ci_pipeline_variables", {:id=>:serial, :force=>:cascade})
133   -> 0.0053s
134-- create_table("ci_pipelines", {:id=>:serial, :force=>:cascade})
135   -> 0.0279s
136-- create_table("ci_runner_namespaces", {:id=>:serial, :force=>:cascade})
137   -> 0.0061s
138-- create_table("ci_runner_projects", {:id=>:serial, :force=>:cascade})
139   -> 0.0062s
140-- create_table("ci_runners", {:id=>:serial, :force=>:cascade})
141   -> 0.0176s
142-- create_table("ci_sources_pipelines", {:id=>:serial, :force=>:cascade})
143   -> 0.0127s
144-- create_table("ci_stages", {:id=>:serial, :force=>:cascade})
145   -> 0.0115s
146-- create_table("ci_trigger_requests", {:id=>:serial, :force=>:cascade})
147   -> 0.0070s
148-- create_table("ci_triggers", {:id=>:serial, :force=>:cascade})
149   -> 0.0067s
150-- create_table("ci_variables", {:id=>:serial, :force=>:cascade})
151   -> 0.0067s
152-- create_table("cluster_groups", {:id=>:serial, :force=>:cascade})
153   -> 0.0062s
154-- create_table("cluster_platforms_kubernetes", {:id=>:serial, :force=>:cascade})
155   -> 0.0050s
156-- create_table("cluster_projects", {:id=>:serial, :force=>:cascade})
157   -> 0.0065s
158-- create_table("cluster_providers_gcp", {:id=>:serial, :force=>:cascade})
159   -> 0.0055s
160-- create_table("clusters", {:id=>:serial, :force=>:cascade})
161   -> 0.0093s
162-- create_table("clusters_applications_cert_managers", {:id=>:serial, :force=>:cascade})
163   -> 0.0050s
164-- create_table("clusters_applications_helm", {:id=>:serial, :force=>:cascade})
165   -> 0.0049s
166-- create_table("clusters_applications_ingress", {:id=>:serial, :force=>:cascade})
167   -> 0.0048s
168-- create_table("clusters_applications_jupyter", {:id=>:serial, :force=>:cascade})
169   -> 0.0069s
170-- create_table("clusters_applications_knative", {:id=>:serial, :force=>:cascade})
171   -> 0.0048s
172-- create_table("clusters_applications_prometheus", {:id=>:serial, :force=>:cascade})
173   -> 0.0048s
174-- create_table("clusters_applications_runners", {:id=>:serial, :force=>:cascade})
175   -> 0.0070s
176-- create_table("clusters_kubernetes_namespaces", {:force=>:cascade})
177   -> 0.0153s
178-- create_table("container_repositories", {:id=>:serial, :force=>:cascade})
179   -> 0.0071s
180-- create_table("conversational_development_index_metrics", {:id=>:serial, :force=>:cascade})
181   -> 0.0068s
182-- create_table("dependency_proxy_blobs", {:id=>:serial, :force=>:cascade})
183   -> 0.0050s
184-- create_table("dependency_proxy_group_settings", {:id=>:serial, :force=>:cascade})
185   -> 0.0048s
186-- create_table("deploy_keys_projects", {:id=>:serial, :force=>:cascade})
187   -> 0.0047s
188-- create_table("deploy_tokens", {:id=>:serial, :force=>:cascade})
189   -> 0.0086s
190-- create_table("deployments", {:id=>:serial, :force=>:cascade})
191   -> 0.0250s
192-- create_table("design_management_designs", {:force=>:cascade})
193   -> 0.0072s
194-- create_table("design_management_designs_versions", {:id=>false, :force=>:cascade})
195   -> 0.0100s
196-- create_table("design_management_versions", {:force=>:cascade})
197   -> 0.0071s
198-- create_table("draft_notes", {:force=>:cascade})
199   -> 0.0100s
200-- create_table("elasticsearch_indexed_namespaces", {:id=>false, :force=>:cascade})
201   -> 0.0035s
202-- create_table("elasticsearch_indexed_projects", {:id=>false, :force=>:cascade})
203   -> 0.0034s
204-- create_table("emails", {:id=>:serial, :force=>:cascade})
205   -> 0.0097s
206-- create_table("environments", {:id=>:serial, :force=>:cascade})
207   -> 0.0124s
208-- create_table("epic_issues", {:id=>:serial, :force=>:cascade})
209   -> 0.0064s
210-- create_table("epic_metrics", {:id=>:serial, :force=>:cascade})
211   -> 0.0043s
212-- create_table("epics", {:id=>:serial, :force=>:cascade})
213   -> 0.0229s
214-- create_table("events", {:id=>:serial, :force=>:cascade})
215   -> 0.0152s
216-- create_table("feature_gates", {:id=>:serial, :force=>:cascade})
217   -> 0.0052s
218-- create_table("features", {:id=>:serial, :force=>:cascade})
219   -> 0.0051s
220-- create_table("fork_network_members", {:id=>:serial, :force=>:cascade})
221   -> 0.0084s
222-- create_table("fork_networks", {:id=>:serial, :force=>:cascade})
223   -> 0.0049s
224-- create_table("forked_project_links", {:id=>:serial, :force=>:cascade})
225   -> 0.0042s
226-- create_table("geo_cache_invalidation_events", {:force=>:cascade})
227   -> 0.0023s
228-- create_table("geo_container_repository_updated_events", {:force=>:cascade})
229   -> 0.0043s
230-- create_table("geo_event_log", {:force=>:cascade})
231   -> 0.0300s
232-- create_table("geo_hashed_storage_attachments_events", {:force=>:cascade})
233   -> 0.0047s
234-- create_table("geo_hashed_storage_migrated_events", {:force=>:cascade})
235   -> 0.0050s
236-- create_table("geo_job_artifact_deleted_events", {:force=>:cascade})
237   -> 0.0058s
238-- create_table("geo_lfs_object_deleted_events", {:force=>:cascade})
239   -> 0.0047s
240-- create_table("geo_node_namespace_links", {:id=>:serial, :force=>:cascade})
241   -> 0.0086s
242-- create_table("geo_node_statuses", {:id=>:serial, :force=>:cascade})
243   -> 0.0063s
244-- create_table("geo_nodes", {:id=>:serial, :force=>:cascade})
245   -> 0.0133s
246-- create_table("geo_repositories_changed_events", {:force=>:cascade})
247   -> 0.0045s
248-- create_table("geo_repository_created_events", {:force=>:cascade})
249   -> 0.0052s
250-- create_table("geo_repository_deleted_events", {:force=>:cascade})
251   -> 0.0053s
252-- create_table("geo_repository_renamed_events", {:force=>:cascade})
253   -> 0.0050s
254-- create_table("geo_repository_updated_events", {:force=>:cascade})
255   -> 0.0082s
256-- create_table("geo_reset_checksum_events", {:force=>:cascade})
257   -> 0.0045s
258-- create_table("geo_upload_deleted_events", {:force=>:cascade})
259   -> 0.0052s
260-- create_table("gitlab_subscriptions", {:force=>:cascade})
261   -> 0.0084s
262-- create_table("gpg_key_subkeys", {:id=>:serial, :force=>:cascade})
263   -> 0.0105s
264-- create_table("gpg_keys", {:id=>:serial, :force=>:cascade})
265   -> 0.0100s
266-- create_table("gpg_signatures", {:id=>:serial, :force=>:cascade})
267   -> 0.0151s
268-- create_table("group_custom_attributes", {:id=>:serial, :force=>:cascade})
269   -> 0.0072s
270-- create_table("historical_data", {:id=>:serial, :force=>:cascade})
271   -> 0.0021s
272-- create_table("identities", {:id=>:serial, :force=>:cascade})
273   -> 0.0092s
274-- create_table("import_export_uploads", {:id=>:serial, :force=>:cascade})
275   -> 0.0073s
276-- create_table("index_statuses", {:id=>:serial, :force=>:cascade})
277   -> 0.0053s
278-- create_table("insights", {:id=>:serial, :force=>:cascade})
279   -> 0.0062s
280-- create_table("internal_ids", {:force=>:cascade})
281   -> 0.0100s
282-- create_table("ip_restrictions", {:force=>:cascade})
283   -> 0.0046s
284-- create_table("issue_assignees", {:id=>false, :force=>:cascade})
285   -> 0.0052s
286-- create_table("issue_links", {:id=>:serial, :force=>:cascade})
287   -> 0.0082s
288-- create_table("issue_metrics", {:id=>:serial, :force=>:cascade})
289   -> 0.0041s
290-- create_table("issue_tracker_data", {:force=>:cascade})
291   -> 0.0050s
292-- create_table("issues", {:id=>:serial, :force=>:cascade})
293   -> 0.0374s
294-- create_table("jira_connect_installations", {:force=>:cascade})
295   -> 0.0047s
296-- create_table("jira_connect_subscriptions", {:force=>:cascade})
297   -> 0.0082s
298-- create_table("jira_tracker_data", {:force=>:cascade})
299   -> 0.0050s
300-- create_table("keys", {:id=>:serial, :force=>:cascade})
301   -> 0.0095s
302-- create_table("label_links", {:id=>:serial, :force=>:cascade})
303   -> 0.0067s
304-- create_table("label_priorities", {:id=>:serial, :force=>:cascade})
305   -> 0.0083s
306-- create_table("labels", {:id=>:serial, :force=>:cascade})
307   -> 0.0143s
308-- create_table("ldap_group_links", {:id=>:serial, :force=>:cascade})
309   -> 0.0028s
310-- create_table("lfs_file_locks", {:id=>:serial, :force=>:cascade})
311   -> 0.0069s
312-- create_table("lfs_objects", {:id=>:serial, :force=>:cascade})
313   -> 0.0067s
314-- create_table("lfs_objects_projects", {:id=>:serial, :force=>:cascade})
315   -> 0.0063s
316-- create_table("licenses", {:id=>:serial, :force=>:cascade})
317   -> 0.0025s
318-- create_table("lists", {:id=>:serial, :force=>:cascade})
319   -> 0.0133s
320-- create_table("members", {:id=>:serial, :force=>:cascade})
321   -> 0.0162s
322-- create_table("merge_request_assignees", {:force=>:cascade})
323   -> 0.0081s
324-- create_table("merge_request_blocks", {:force=>:cascade})
325   -> 0.0064s
326-- create_table("merge_request_diff_commits", {:id=>false, :force=>:cascade})
327   -> 0.0061s
328-- create_table("merge_request_diff_files", {:id=>false, :force=>:cascade})
329   -> 0.0040s
330-- create_table("merge_request_diffs", {:id=>:serial, :force=>:cascade})
331   -> 0.0072s
332-- create_table("merge_request_metrics", {:id=>:serial, :force=>:cascade})
333   -> 0.0175s
334-- create_table("merge_requests", {:id=>:serial, :force=>:cascade})
335   -> 0.0488s
336-- create_table("merge_requests_closing_issues", {:id=>:serial, :force=>:cascade})
337   -> 0.0062s
338-- create_table("merge_trains", {:force=>:cascade})
339   -> 0.0111s
340-- create_table("milestones", {:id=>:serial, :force=>:cascade})
341   -> 0.0162s
342-- create_table("namespace_aggregation_schedules", {:primary_key=>"namespace_id", :id=>:integer, :default=>nil, :force=>:cascade})
343   -> 0.0036s
344-- create_table("namespace_root_storage_statistics", {:primary_key=>"namespace_id", :id=>:integer, :default=>nil, :force=>:cascade})
345   -> 0.0069s
346-- create_table("namespace_statistics", {:id=>:serial, :force=>:cascade})
347   -> 0.0052s
348-- create_table("namespaces", {:id=>:serial, :force=>:cascade})
349   -> 0.0462s
350-- create_table("note_diff_files", {:id=>:serial, :force=>:cascade})
351   -> 0.0050s
352-- create_table("notes", {:id=>:serial, :force=>:cascade})
353   -> 0.0286s
354-- create_table("notification_settings", {:id=>:serial, :force=>:cascade})
355   -> 0.0106s
356-- create_table("oauth_access_grants", {:id=>:serial, :force=>:cascade})
357   -> 0.0051s
358-- create_table("oauth_access_tokens", {:id=>:serial, :force=>:cascade})
359   -> 0.0094s
360-- create_table("oauth_applications", {:id=>:serial, :force=>:cascade})
361   -> 0.0080s
362-- create_table("oauth_openid_requests", {:id=>:serial, :force=>:cascade})
363   -> 0.0047s
364-- create_table("operations_feature_flag_scopes", {:force=>:cascade})
365   -> 0.0066s
366-- create_table("operations_feature_flags", {:force=>:cascade})
367   -> 0.0056s
368-- create_table("operations_feature_flags_clients", {:force=>:cascade})
369   -> 0.0074s
370-- create_table("packages_maven_metadata", {:force=>:cascade})
371   -> 0.0053s
372-- create_table("packages_package_files", {:force=>:cascade})
373   -> 0.0054s
374-- create_table("packages_packages", {:force=>:cascade})
375   -> 0.0052s
376-- create_table("pages_domain_acme_orders", {:force=>:cascade})
377   -> 0.0078s
378-- create_table("pages_domains", {:id=>:serial, :force=>:cascade})
379   -> 0.0191s
380-- create_table("path_locks", {:id=>:serial, :force=>:cascade})
381   -> 0.0095s
382-- create_table("personal_access_tokens", {:id=>:serial, :force=>:cascade})
383   -> 0.0089s
384-- create_table("plans", {:id=>:serial, :force=>:cascade})
385   -> 0.0054s
386-- create_table("pool_repositories", {:force=>:cascade})
387   -> 0.0094s
388-- create_table("programming_languages", {:id=>:serial, :force=>:cascade})
389   -> 0.0047s
390-- create_table("project_alerting_settings", {:primary_key=>"project_id", :id=>:integer, :default=>nil, :force=>:cascade})
391   -> 0.0019s
392-- create_table("project_aliases", {:force=>:cascade})
393   -> 0.0065s
394-- create_table("project_authorizations", {:id=>false, :force=>:cascade})
395   -> 0.0053s
396-- create_table("project_auto_devops", {:id=>:serial, :force=>:cascade})
397   -> 0.0048s
398-- create_table("project_ci_cd_settings", {:id=>:serial, :force=>:cascade})
399   -> 0.0052s
400-- create_table("project_custom_attributes", {:id=>:serial, :force=>:cascade})
401   -> 0.0068s
402-- create_table("project_daily_statistics", {:force=>:cascade})
403   -> 0.0042s
404-- create_table("project_deploy_tokens", {:id=>:serial, :force=>:cascade})
405   -> 0.0062s
406-- create_table("project_error_tracking_settings", {:primary_key=>"project_id", :id=>:integer, :default=>nil, :force=>:cascade})
407   -> 0.0026s
408-- create_table("project_feature_usages", {:primary_key=>"project_id", :id=>:integer, :default=>nil, :force=>:cascade})
409   -> 0.0081s
410-- create_table("project_features", {:id=>:serial, :force=>:cascade})
411   -> 0.0054s
412-- create_table("project_group_links", {:id=>:serial, :force=>:cascade})
413   -> 0.0073s
414-- create_table("project_import_data", {:id=>:serial, :force=>:cascade})
415   -> 0.0046s
416-- create_table("project_incident_management_settings", {:primary_key=>"project_id", :id=>:serial, :force=>:cascade})
417   -> 0.0033s
418-- create_table("project_metrics_settings", {:primary_key=>"project_id", :id=>:integer, :default=>nil, :force=>:cascade})
419   -> 0.0019s
420-- create_table("project_mirror_data", {:id=>:serial, :force=>:cascade})
421   -> 0.0166s
422-- create_table("project_repositories", {:force=>:cascade})
423   -> 0.0097s
424-- create_table("project_repository_states", {:id=>:serial, :force=>:cascade})
425   -> 0.0159s
426-- create_table("project_statistics", {:id=>:serial, :force=>:cascade})
427   -> 0.0093s
428-- create_table("project_tracing_settings", {:force=>:cascade})
429   -> 0.0059s
430-- create_table("projects", {:id=>:serial, :force=>:cascade})
431   -> 0.0693s
432-- create_table("prometheus_alert_events", {:force=>:cascade})
433   -> 0.0069s
434-- create_table("prometheus_alerts", {:id=>:serial, :force=>:cascade})
435   -> 0.0738s
436-- create_table("prometheus_metrics", {:id=>:serial, :force=>:cascade})
437   -> 0.0116s
438-- create_table("protected_branch_merge_access_levels", {:id=>:serial, :force=>:cascade})
439   -> 0.0090s
440-- create_table("protected_branch_push_access_levels", {:id=>:serial, :force=>:cascade})
441   -> 0.0087s
442-- create_table("protected_branch_unprotect_access_levels", {:id=>:serial, :force=>:cascade})
443   -> 0.0088s
444-- create_table("protected_branches", {:id=>:serial, :force=>:cascade})
445   -> 0.0048s
446-- create_table("protected_environment_deploy_access_levels", {:id=>:serial, :force=>:cascade})
447   -> 0.0088s
448-- create_table("protected_environments", {:id=>:serial, :force=>:cascade})
449   -> 0.0071s
450-- create_table("protected_tag_create_access_levels", {:id=>:serial, :force=>:cascade})
451   -> 0.0090s
452-- create_table("protected_tags", {:id=>:serial, :force=>:cascade})
453   -> 0.0068s
454-- create_table("push_event_payloads", {:id=>false, :force=>:cascade})
455   -> 0.0039s
456-- create_table("push_rules", {:id=>:serial, :force=>:cascade})
457   -> 0.0095s
458-- create_table("redirect_routes", {:id=>:serial, :force=>:cascade})
459   -> 0.0066s
460-- create_table("release_links", {:force=>:cascade})
461   -> 0.0069s
462-- create_table("releases", {:id=>:serial, :force=>:cascade})
463   -> 0.0091s
464-- create_table("remote_mirrors", {:id=>:serial, :force=>:cascade})
465   -> 0.0083s
466-- create_table("repository_languages", {:id=>false, :force=>:cascade})
467   -> 0.0034s
468-- create_table("resource_label_events", {:force=>:cascade})
469   -> 0.0128s
470-- create_table("reviews", {:force=>:cascade})
471   -> 0.0084s
472-- create_table("routes", {:id=>:serial, :force=>:cascade})
473   -> 0.0087s
474-- create_table("saml_providers", {:id=>:serial, :force=>:cascade})
475   -> 0.0058s
476-- create_table("scim_oauth_access_tokens", {:id=>:serial, :force=>:cascade})
477   -> 0.0053s
478-- create_table("sent_notifications", {:id=>:serial, :force=>:cascade})
479   -> 0.0048s
480-- create_table("services", {:id=>:serial, :force=>:cascade})
481   -> 0.0158s
482-- create_table("shards", {:id=>:serial, :force=>:cascade})
483   -> 0.0045s
484-- create_table("slack_integrations", {:id=>:serial, :force=>:cascade})
485   -> 0.0068s
486-- create_table("smartcard_identities", {:force=>:cascade})
487   -> 0.0068s
488-- create_table("snippets", {:id=>:serial, :force=>:cascade})
489   -> 0.0158s
490-- create_table("software_license_policies", {:id=>:serial, :force=>:cascade})
491   -> 0.0066s
492-- create_table("software_licenses", {:id=>:serial, :force=>:cascade})
493   -> 0.0048s
494-- create_table("spam_logs", {:id=>:serial, :force=>:cascade})
495   -> 0.0035s
496-- create_table("subscriptions", {:id=>:serial, :force=>:cascade})
497   -> 0.0073s
498-- create_table("suggestions", {:force=>:cascade})
499   -> 0.0070s
500-- create_table("system_note_metadata", {:id=>:serial, :force=>:cascade})
501   -> 0.0046s
502-- create_table("taggings", {:id=>:serial, :force=>:cascade})
503   -> 0.0113s
504-- create_table("tags", {:id=>:serial, :force=>:cascade})
505   -> 0.0070s
506-- create_table("term_agreements", {:id=>:serial, :force=>:cascade})
507   -> 0.0086s
508-- create_table("timelogs", {:id=>:serial, :force=>:cascade})
509   -> 0.0086s
510-- create_table("todos", {:id=>:serial, :force=>:cascade})
511   -> 0.0220s
512-- create_table("trending_projects", {:id=>:serial, :force=>:cascade})
513   -> 0.0043s
514-- create_table("u2f_registrations", {:id=>:serial, :force=>:cascade})
515   -> 0.0071s
516-- create_table("uploads", {:id=>:serial, :force=>:cascade})
517   -> 0.0111s
518-- create_table("user_agent_details", {:id=>:serial, :force=>:cascade})
519   -> 0.0053s
520-- create_table("user_callouts", {:id=>:serial, :force=>:cascade})
521   -> 0.0062s
522-- create_table("user_custom_attributes", {:id=>:serial, :force=>:cascade})
523   -> 0.0072s
524-- create_table("user_interacted_projects", {:id=>false, :force=>:cascade})
525   -> 0.0054s
526-- create_table("user_preferences", {:id=>:serial, :force=>:cascade})
527   -> 0.0065s
528-- create_table("user_statuses", {:primary_key=>"user_id", :id=>:serial, :force=>:cascade})
529   -> 0.0051s
530-- create_table("user_synced_attributes_metadata", {:id=>:serial, :force=>:cascade})
531   -> 0.0060s
532-- create_table("users", {:id=>:serial, :force=>:cascade})
533   -> 0.0605s
534-- create_table("users_ops_dashboard_projects", {:force=>:cascade})
535   -> 0.0065s
536-- create_table("users_star_projects", {:id=>:serial, :force=>:cascade})
537   -> 0.0066s
538-- create_table("vulnerability_feedback", {:id=>:serial, :force=>:cascade})
539   -> 0.0151s
540-- create_table("vulnerability_identifiers", {:force=>:cascade})
541   -> 0.0050s
542-- create_table("vulnerability_occurrence_identifiers", {:force=>:cascade})
543   -> 0.0070s
544-- create_table("vulnerability_occurrence_pipelines", {:force=>:cascade})
545   -> 0.0131s
546-- create_table("vulnerability_occurrences", {:force=>:cascade})
547   -> 0.0120s
548-- create_table("vulnerability_scanners", {:force=>:cascade})
549   -> 0.0051s
550-- create_table("web_hook_logs", {:id=>:serial, :force=>:cascade})
551   -> 0.0074s
552-- create_table("web_hooks", {:id=>:serial, :force=>:cascade})
553   -> 0.0129s
554-- add_foreign_key("allowed_email_domains", "namespaces", {:column=>"group_id", :on_delete=>:cascade})
555   -> 0.0027s
556-- add_foreign_key("analytics_cycle_analytics_group_stages", "labels", {:column=>"end_event_label_id", :on_delete=>:cascade})
557   -> 0.0018s
558-- add_foreign_key("analytics_cycle_analytics_group_stages", "labels", {:column=>"start_event_label_id", :on_delete=>:cascade})
559   -> 0.0013s
560-- add_foreign_key("analytics_cycle_analytics_group_stages", "namespaces", {:column=>"group_id", :on_delete=>:cascade})
561   -> 0.0014s
562-- add_foreign_key("analytics_cycle_analytics_project_stages", "labels", {:column=>"end_event_label_id", :on_delete=>:cascade})
563   -> 0.0014s
564-- add_foreign_key("analytics_cycle_analytics_project_stages", "labels", {:column=>"start_event_label_id", :on_delete=>:cascade})
565   -> 0.0012s
566-- add_foreign_key("analytics_cycle_analytics_project_stages", "projects", {:on_delete=>:cascade})
567   -> 0.0025s
568-- add_foreign_key("application_settings", "namespaces", {:column=>"custom_project_templates_group_id", :on_delete=>:nullify})
569   -> 0.0026s
570-- add_foreign_key("application_settings", "projects", {:column=>"file_template_project_id", :name=>"fk_ec757bd087", :on_delete=>:nullify})
571   -> 0.0022s
572-- add_foreign_key("application_settings", "projects", {:column=>"instance_administration_project_id", :on_delete=>:nullify})
573   -> 0.0021s
574-- add_foreign_key("application_settings", "users", {:column=>"usage_stats_set_by_user_id", :name=>"fk_964370041d", :on_delete=>:nullify})
575   -> 0.0029s
576-- add_foreign_key("approval_merge_request_rule_sources", "approval_merge_request_rules", {:on_delete=>:cascade})
577   -> 0.0016s
578-- add_foreign_key("approval_merge_request_rule_sources", "approval_project_rules", {:on_delete=>:cascade})
579   -> 0.0047s
580-- add_foreign_key("approval_merge_request_rules", "merge_requests", {:on_delete=>:cascade})
581   -> 0.0026s
582-- add_foreign_key("approval_merge_request_rules_approved_approvers", "approval_merge_request_rules", {:on_delete=>:cascade})
583   -> 0.0016s
584-- add_foreign_key("approval_merge_request_rules_approved_approvers", "users", {:on_delete=>:cascade})
585   -> 0.0016s
586-- add_foreign_key("approval_merge_request_rules_groups", "approval_merge_request_rules", {:on_delete=>:cascade})
587   -> 0.0014s
588-- add_foreign_key("approval_merge_request_rules_groups", "namespaces", {:column=>"group_id", :on_delete=>:cascade})
589   -> 0.0013s
590-- add_foreign_key("approval_merge_request_rules_users", "approval_merge_request_rules", {:on_delete=>:cascade})
591   -> 0.0013s
592-- add_foreign_key("approval_merge_request_rules_users", "users", {:on_delete=>:cascade})
593   -> 0.0015s
594-- add_foreign_key("approval_project_rules", "projects", {:on_delete=>:cascade})
595   -> 0.0015s
596-- add_foreign_key("approval_project_rules_groups", "approval_project_rules", {:on_delete=>:cascade})
597   -> 0.0012s
598-- add_foreign_key("approval_project_rules_groups", "namespaces", {:column=>"group_id", :on_delete=>:cascade})
599   -> 0.0013s
600-- add_foreign_key("approval_project_rules_users", "approval_project_rules", {:on_delete=>:cascade})
601   -> 0.0017s
602-- add_foreign_key("approval_project_rules_users", "users", {:on_delete=>:cascade})
603   -> 0.0015s
604-- add_foreign_key("approvals", "merge_requests", {:name=>"fk_310d714958", :on_delete=>:cascade})
605   -> 0.0014s
606-- add_foreign_key("approver_groups", "namespaces", {:column=>"group_id", :on_delete=>:cascade})
607   -> 0.0015s
608-- add_foreign_key("badges", "namespaces", {:column=>"group_id", :on_delete=>:cascade})
609   -> 0.0014s
610-- add_foreign_key("badges", "projects", {:on_delete=>:cascade})
611   -> 0.0015s
612-- add_foreign_key("board_assignees", "boards", {:on_delete=>:cascade})
613   -> 0.0014s
614-- add_foreign_key("board_assignees", "users", {:column=>"assignee_id", :on_delete=>:cascade})
615   -> 0.0014s
616-- add_foreign_key("board_group_recent_visits", "boards", {:on_delete=>:cascade})
617   -> 0.0013s
618-- add_foreign_key("board_group_recent_visits", "namespaces", {:column=>"group_id", :on_delete=>:cascade})
619   -> 0.0013s
620-- add_foreign_key("board_group_recent_visits", "users", {:on_delete=>:cascade})
621   -> 0.0017s
622-- add_foreign_key("board_labels", "boards", {:on_delete=>:cascade})
623   -> 0.0012s
624-- add_foreign_key("board_labels", "labels", {:on_delete=>:cascade})
625   -> 0.0013s
626-- add_foreign_key("board_project_recent_visits", "boards", {:on_delete=>:cascade})
627   -> 0.0013s
628-- add_foreign_key("board_project_recent_visits", "projects", {:on_delete=>:cascade})
629   -> 0.0016s
630-- add_foreign_key("board_project_recent_visits", "users", {:on_delete=>:cascade})
631   -> 0.0015s
632-- add_foreign_key("boards", "namespaces", {:column=>"group_id", :name=>"fk_1e9a074a35", :on_delete=>:cascade})
633   -> 0.0014s
634-- add_foreign_key("boards", "projects", {:name=>"fk_f15266b5f9", :on_delete=>:cascade})
635   -> 0.0016s
636-- add_foreign_key("chat_teams", "namespaces", {:on_delete=>:cascade})
637   -> 0.0015s
638-- add_foreign_key("ci_build_needs", "ci_builds", {:column=>"build_id", :on_delete=>:cascade})
639   -> 0.0023s
640-- add_foreign_key("ci_build_trace_chunks", "ci_builds", {:column=>"build_id", :on_delete=>:cascade})
641   -> 0.0014s
642-- add_foreign_key("ci_build_trace_section_names", "projects", {:on_delete=>:cascade})
643   -> 0.0015s
644-- add_foreign_key("ci_build_trace_sections", "ci_build_trace_section_names", {:column=>"section_name_id", :name=>"fk_264e112c66", :on_delete=>:cascade})
645   -> 0.0012s
646-- add_foreign_key("ci_build_trace_sections", "ci_builds", {:column=>"build_id", :name=>"fk_4ebe41f502", :on_delete=>:cascade})
647   -> 0.0013s
648-- add_foreign_key("ci_build_trace_sections", "projects", {:on_delete=>:cascade})
649   -> 0.0015s
650-- add_foreign_key("ci_builds", "ci_pipelines", {:column=>"auto_canceled_by_id", :name=>"fk_a2141b1522", :on_delete=>:nullify})
651   -> 0.0021s
652-- add_foreign_key("ci_builds", "ci_pipelines", {:column=>"commit_id", :name=>"fk_d3130c9a7f", :on_delete=>:cascade})
653   -> 0.0015s
654-- add_foreign_key("ci_builds", "ci_pipelines", {:column=>"upstream_pipeline_id", :name=>"fk_87f4cefcda", :on_delete=>:cascade})
655   -> 0.0014s
656-- add_foreign_key("ci_builds", "ci_stages", {:column=>"stage_id", :name=>"fk_3a9eaa254d", :on_delete=>:cascade})
657   -> 0.0017s
658-- add_foreign_key("ci_builds", "projects", {:name=>"fk_befce0568a", :on_delete=>:cascade})
659   -> 0.0023s
660-- add_foreign_key("ci_builds_metadata", "ci_builds", {:column=>"build_id", :on_delete=>:cascade})
661   -> 0.0015s
662-- add_foreign_key("ci_builds_metadata", "projects", {:on_delete=>:cascade})
663   -> 0.0016s
664-- add_foreign_key("ci_builds_runner_session", "ci_builds", {:column=>"build_id", :on_delete=>:cascade})
665   -> 0.0014s
666-- add_foreign_key("ci_group_variables", "namespaces", {:column=>"group_id", :name=>"fk_33ae4d58d8", :on_delete=>:cascade})
667   -> 0.0014s
668-- add_foreign_key("ci_job_artifacts", "ci_builds", {:column=>"job_id", :on_delete=>:cascade})
669   -> 0.0015s
670-- add_foreign_key("ci_job_artifacts", "projects", {:on_delete=>:cascade})
671   -> 0.0018s
672-- add_foreign_key("ci_job_variables", "ci_builds", {:column=>"job_id", :on_delete=>:cascade})
673   -> 0.0015s
674-- add_foreign_key("ci_pipeline_chat_data", "chat_names", {:on_delete=>:cascade})
675   -> 0.0015s
676-- add_foreign_key("ci_pipeline_chat_data", "ci_pipelines", {:column=>"pipeline_id", :on_delete=>:cascade})
677   -> 0.0012s
678-- add_foreign_key("ci_pipeline_schedule_variables", "ci_pipeline_schedules", {:column=>"pipeline_schedule_id", :name=>"fk_41c35fda51", :on_delete=>:cascade})
679   -> 0.0013s
680-- add_foreign_key("ci_pipeline_schedules", "projects", {:name=>"fk_8ead60fcc4", :on_delete=>:cascade})
681   -> 0.0016s
682-- add_foreign_key("ci_pipeline_schedules", "users", {:column=>"owner_id", :name=>"fk_9ea99f58d2", :on_delete=>:nullify})
683   -> 0.0014s
684-- add_foreign_key("ci_pipeline_variables", "ci_pipelines", {:column=>"pipeline_id", :name=>"fk_f29c5f4380", :on_delete=>:cascade})
685   -> 0.0014s
686-- add_foreign_key("ci_pipelines", "ci_pipeline_schedules", {:column=>"pipeline_schedule_id", :name=>"fk_3d34ab2e06", :on_delete=>:nullify})
687   -> 0.0012s
688-- add_foreign_key("ci_pipelines", "ci_pipelines", {:column=>"auto_canceled_by_id", :name=>"fk_262d4c2d19", :on_delete=>:nullify})
689   -> 0.0014s
690-- add_foreign_key("ci_pipelines", "merge_requests", {:name=>"fk_a23be95014", :on_delete=>:cascade})
691   -> 0.0015s
692-- add_foreign_key("ci_pipelines", "projects", {:name=>"fk_86635dbd80", :on_delete=>:cascade})
693   -> 0.0017s
694-- add_foreign_key("ci_runner_namespaces", "ci_runners", {:column=>"runner_id", :on_delete=>:cascade})
695   -> 0.0015s
696-- add_foreign_key("ci_runner_namespaces", "namespaces", {:on_delete=>:cascade})
697   -> 0.0014s
698-- add_foreign_key("ci_runner_projects", "projects", {:name=>"fk_4478a6f1e4", :on_delete=>:cascade})
699   -> 0.0018s
700-- add_foreign_key("ci_sources_pipelines", "ci_builds", {:column=>"source_job_id", :name=>"fk_be5624bf37", :on_delete=>:cascade})
701   -> 0.0016s
702-- add_foreign_key("ci_sources_pipelines", "ci_pipelines", {:column=>"pipeline_id", :name=>"fk_e1bad85861", :on_delete=>:cascade})
703   -> 0.0012s
704-- add_foreign_key("ci_sources_pipelines", "ci_pipelines", {:column=>"source_pipeline_id", :name=>"fk_d4e29af7d7", :on_delete=>:cascade})
705   -> 0.0012s
706-- add_foreign_key("ci_sources_pipelines", "projects", {:column=>"source_project_id", :name=>"fk_acd9737679", :on_delete=>:cascade})
707   -> 0.0015s
708-- add_foreign_key("ci_sources_pipelines", "projects", {:name=>"fk_1e53c97c0a", :on_delete=>:cascade})
709   -> 0.0015s
710-- add_foreign_key("ci_stages", "ci_pipelines", {:column=>"pipeline_id", :name=>"fk_fb57e6cc56", :on_delete=>:cascade})
711   -> 0.0013s
712-- add_foreign_key("ci_stages", "projects", {:name=>"fk_2360681d1d", :on_delete=>:cascade})
713   -> 0.0016s
714-- add_foreign_key("ci_trigger_requests", "ci_triggers", {:column=>"trigger_id", :name=>"fk_b8ec8b7245", :on_delete=>:cascade})
715   -> 0.0013s
716-- add_foreign_key("ci_triggers", "projects", {:name=>"fk_e3e63f966e", :on_delete=>:cascade})
717   -> 0.0015s
718-- add_foreign_key("ci_triggers", "users", {:column=>"owner_id", :name=>"fk_e8e10d1964", :on_delete=>:cascade})
719   -> 0.0015s
720-- add_foreign_key("ci_variables", "projects", {:name=>"fk_ada5eb64b3", :on_delete=>:cascade})
721   -> 0.0016s
722-- add_foreign_key("cluster_groups", "clusters", {:on_delete=>:cascade})
723   -> 0.0015s
724-- add_foreign_key("cluster_groups", "namespaces", {:column=>"group_id", :on_delete=>:cascade})
725   -> 0.0015s
726-- add_foreign_key("cluster_platforms_kubernetes", "clusters", {:on_delete=>:cascade})
727   -> 0.0013s
728-- add_foreign_key("cluster_projects", "clusters", {:on_delete=>:cascade})
729   -> 0.0012s
730-- add_foreign_key("cluster_projects", "projects", {:on_delete=>:cascade})
731   -> 0.0015s
732-- add_foreign_key("cluster_providers_gcp", "clusters", {:on_delete=>:cascade})
733   -> 0.0013s
734-- add_foreign_key("clusters", "users", {:on_delete=>:nullify})
735   -> 0.0016s
736-- add_foreign_key("clusters_applications_cert_managers", "clusters", {:on_delete=>:cascade})
737   -> 0.0012s
738-- add_foreign_key("clusters_applications_helm", "clusters", {:on_delete=>:cascade})
739   -> 0.0012s
740-- add_foreign_key("clusters_applications_ingress", "clusters", {:on_delete=>:cascade})
741   -> 0.0013s
742-- add_foreign_key("clusters_applications_jupyter", "clusters", {:on_delete=>:cascade})
743   -> 0.0013s
744-- add_foreign_key("clusters_applications_jupyter", "oauth_applications", {:on_delete=>:nullify})
745   -> 0.0013s
746-- add_foreign_key("clusters_applications_knative", "clusters", {:on_delete=>:cascade})
747   -> 0.0017s
748-- add_foreign_key("clusters_applications_prometheus", "clusters", {:name=>"fk_557e773639", :on_delete=>:cascade})
749   -> 0.0013s
750-- add_foreign_key("clusters_applications_runners", "ci_runners", {:column=>"runner_id", :name=>"fk_02de2ded36", :on_delete=>:nullify})
751   -> 0.0012s
752-- add_foreign_key("clusters_applications_runners", "clusters", {:on_delete=>:cascade})
753   -> 0.0012s
754-- add_foreign_key("clusters_kubernetes_namespaces", "cluster_projects", {:on_delete=>:nullify})
755   -> 0.0015s
756-- add_foreign_key("clusters_kubernetes_namespaces", "clusters", {:on_delete=>:cascade})
757   -> 0.0014s
758-- add_foreign_key("clusters_kubernetes_namespaces", "environments", {:on_delete=>:nullify})
759   -> 0.0015s
760-- add_foreign_key("clusters_kubernetes_namespaces", "projects", {:on_delete=>:nullify})
761   -> 0.0016s
762-- add_foreign_key("container_repositories", "projects")
763   -> 0.0018s
764-- add_foreign_key("dependency_proxy_blobs", "namespaces", {:column=>"group_id", :on_delete=>:cascade})
765   -> 0.0016s
766-- add_foreign_key("dependency_proxy_group_settings", "namespaces", {:column=>"group_id", :on_delete=>:cascade})
767   -> 0.0014s
768-- add_foreign_key("deploy_keys_projects", "projects", {:name=>"fk_58a901ca7e", :on_delete=>:cascade})
769   -> 0.0019s
770-- add_foreign_key("deployments", "clusters", {:name=>"fk_289bba3222", :on_delete=>:nullify})
771   -> 0.0017s
772-- add_foreign_key("deployments", "projects", {:name=>"fk_b9a3851b82", :on_delete=>:cascade})
773   -> 0.0017s
774-- add_foreign_key("design_management_designs", "issues", {:on_delete=>:cascade})
775   -> 0.0020s
776-- add_foreign_key("design_management_designs", "projects", {:on_delete=>:cascade})
777   -> 0.0015s
778-- add_foreign_key("design_management_designs_versions", "design_management_designs", {:column=>"design_id", :name=>"fk_03c671965c", :on_delete=>:cascade})
779   -> 0.0012s
780-- add_foreign_key("design_management_designs_versions", "design_management_versions", {:column=>"version_id", :name=>"fk_f4d25ba00c", :on_delete=>:cascade})
781   -> 0.0012s
782-- add_foreign_key("design_management_versions", "issues", {:on_delete=>:cascade})
783   -> 0.0013s
784-- add_foreign_key("draft_notes", "merge_requests", {:on_delete=>:cascade})
785   -> 0.0020s
786-- add_foreign_key("draft_notes", "users", {:column=>"author_id", :on_delete=>:cascade})
787   -> 0.0016s
788-- add_foreign_key("elasticsearch_indexed_namespaces", "namespaces", {:on_delete=>:cascade})
789   -> 0.0015s
790-- add_foreign_key("elasticsearch_indexed_projects", "projects", {:on_delete=>:cascade})
791   -> 0.0017s
792-- add_foreign_key("environments", "projects", {:name=>"fk_d1c8c1da6a", :on_delete=>:cascade})
793   -> 0.0017s
794-- add_foreign_key("epic_issues", "epics", {:on_delete=>:cascade})
795   -> 0.0017s
796-- add_foreign_key("epic_issues", "issues", {:on_delete=>:cascade})
797   -> 0.0013s
798-- add_foreign_key("epic_metrics", "epics", {:on_delete=>:cascade})
799   -> 0.0012s
800-- add_foreign_key("epics", "epics", {:column=>"parent_id", :name=>"fk_25b99c1be3", :on_delete=>:cascade})
801   -> 0.0012s
802-- add_foreign_key("epics", "milestones", {:on_delete=>:nullify})
803   -> 0.0015s
804-- add_foreign_key("epics", "namespaces", {:column=>"group_id", :name=>"fk_f081aa4489", :on_delete=>:cascade})
805   -> 0.0014s
806-- add_foreign_key("epics", "users", {:column=>"assignee_id", :name=>"fk_dccd3f98fc", :on_delete=>:nullify})
807   -> 0.0016s
808-- add_foreign_key("epics", "users", {:column=>"author_id", :name=>"fk_3654b61b03", :on_delete=>:cascade})
809   -> 0.0015s
810-- add_foreign_key("epics", "users", {:column=>"closed_by_id", :name=>"fk_aa5798e761", :on_delete=>:nullify})
811   -> 0.0016s
812-- add_foreign_key("events", "projects", {:on_delete=>:cascade})
813   -> 0.0019s
814-- add_foreign_key("events", "users", {:column=>"author_id", :name=>"fk_edfd187b6f", :on_delete=>:cascade})
815   -> 0.0016s
816-- add_foreign_key("fork_network_members", "fork_networks", {:on_delete=>:cascade})
817   -> 0.0014s
818-- add_foreign_key("fork_network_members", "projects", {:column=>"forked_from_project_id", :name=>"fk_b01280dae4", :on_delete=>:nullify})
819   -> 0.0016s
820-- add_foreign_key("fork_network_members", "projects", {:on_delete=>:cascade})
821   -> 0.0016s
822-- add_foreign_key("fork_networks", "projects", {:column=>"root_project_id", :name=>"fk_e7b436b2b5", :on_delete=>:nullify})
823   -> 0.0014s
824-- add_foreign_key("forked_project_links", "projects", {:column=>"forked_to_project_id", :name=>"fk_434510edb0", :on_delete=>:cascade})
825   -> 0.0015s
826-- add_foreign_key("geo_container_repository_updated_events", "container_repositories", {:name=>"fk_212c89c706", :on_delete=>:cascade})
827   -> 0.0013s
828-- add_foreign_key("geo_event_log", "geo_cache_invalidation_events", {:column=>"cache_invalidation_event_id", :name=>"fk_42c3b54bed", :on_delete=>:cascade})
829   -> 0.0018s
830-- add_foreign_key("geo_event_log", "geo_container_repository_updated_events", {:column=>"container_repository_updated_event_id", :name=>"fk_6ada82d42a", :on_delete=>:cascade})
831   -> 0.0012s
832-- add_foreign_key("geo_event_log", "geo_hashed_storage_migrated_events", {:column=>"hashed_storage_migrated_event_id", :name=>"fk_27548c6db3", :on_delete=>:cascade})
833   -> 0.0012s
834-- add_foreign_key("geo_event_log", "geo_job_artifact_deleted_events", {:column=>"job_artifact_deleted_event_id", :name=>"fk_176d3fbb5d", :on_delete=>:cascade})
835   -> 0.0012s
836-- add_foreign_key("geo_event_log", "geo_lfs_object_deleted_events", {:column=>"lfs_object_deleted_event_id", :name=>"fk_d5af95fcd9", :on_delete=>:cascade})
837   -> 0.0013s
838-- add_foreign_key("geo_event_log", "geo_repositories_changed_events", {:column=>"repositories_changed_event_id", :name=>"fk_4a99ebfd60", :on_delete=>:cascade})
839   -> 0.0012s
840-- add_foreign_key("geo_event_log", "geo_repository_created_events", {:column=>"repository_created_event_id", :name=>"fk_9b9afb1916", :on_delete=>:cascade})
841   -> 0.0015s
842-- add_foreign_key("geo_event_log", "geo_repository_deleted_events", {:column=>"repository_deleted_event_id", :name=>"fk_c4b1c1f66e", :on_delete=>:cascade})
843   -> 0.0017s
844-- add_foreign_key("geo_event_log", "geo_repository_renamed_events", {:column=>"repository_renamed_event_id", :name=>"fk_86c84214ec", :on_delete=>:cascade})
845   -> 0.0012s
846-- add_foreign_key("geo_event_log", "geo_repository_updated_events", {:column=>"repository_updated_event_id", :name=>"fk_78a6492f68", :on_delete=>:cascade})
847   -> 0.0013s
848-- add_foreign_key("geo_event_log", "geo_reset_checksum_events", {:column=>"reset_checksum_event_id", :name=>"fk_cff7185ad2", :on_delete=>:cascade})
849   -> 0.0012s
850-- add_foreign_key("geo_event_log", "geo_upload_deleted_events", {:column=>"upload_deleted_event_id", :name=>"fk_c1f241c70d", :on_delete=>:cascade})
851   -> 0.0013s
852-- add_foreign_key("geo_hashed_storage_attachments_events", "projects", {:on_delete=>:cascade})
853   -> 0.0019s
854-- add_foreign_key("geo_hashed_storage_migrated_events", "projects", {:on_delete=>:cascade})
855   -> 0.0017s
856-- add_foreign_key("geo_node_namespace_links", "geo_nodes", {:on_delete=>:cascade})
857   -> 0.0016s
858-- add_foreign_key("geo_node_namespace_links", "namespaces", {:on_delete=>:cascade})
859   -> 0.0015s
860-- add_foreign_key("geo_node_statuses", "geo_nodes", {:on_delete=>:cascade})
861   -> 0.0016s
862-- add_foreign_key("geo_repositories_changed_events", "geo_nodes", {:on_delete=>:cascade})
863   -> 0.0012s
864-- add_foreign_key("geo_repository_created_events", "projects", {:on_delete=>:cascade})
865   -> 0.0016s
866-- add_foreign_key("geo_repository_renamed_events", "projects", {:on_delete=>:cascade})
867   -> 0.0017s
868-- add_foreign_key("geo_repository_updated_events", "projects", {:on_delete=>:cascade})
869   -> 0.0016s
870-- add_foreign_key("geo_reset_checksum_events", "projects", {:on_delete=>:cascade})
871   -> 0.0016s
872-- add_foreign_key("gitlab_subscriptions", "namespaces", {:name=>"fk_e2595d00a1", :on_delete=>:cascade})
873   -> 0.0017s
874-- add_foreign_key("gitlab_subscriptions", "plans", {:column=>"hosted_plan_id", :name=>"fk_bd0c4019c3", :on_delete=>:cascade})
875   -> 0.0013s
876-- add_foreign_key("gpg_key_subkeys", "gpg_keys", {:on_delete=>:cascade})
877   -> 0.0015s
878-- add_foreign_key("gpg_keys", "users", {:on_delete=>:cascade})
879   -> 0.0019s
880-- add_foreign_key("gpg_signatures", "gpg_key_subkeys", {:on_delete=>:nullify})
881   -> 0.0023s
882-- add_foreign_key("gpg_signatures", "gpg_keys", {:on_delete=>:nullify})
883   -> 0.0013s
884-- add_foreign_key("gpg_signatures", "projects", {:on_delete=>:cascade})
885   -> 0.0019s
886-- add_foreign_key("group_custom_attributes", "namespaces", {:column=>"group_id", :on_delete=>:cascade})
887   -> 0.0021s
888-- add_foreign_key("identities", "saml_providers", {:name=>"fk_aade90f0fc", :on_delete=>:cascade})
889   -> 0.0015s
890-- add_foreign_key("import_export_uploads", "projects", {:on_delete=>:cascade})
891   -> 0.0019s
892-- add_foreign_key("index_statuses", "projects", {:name=>"fk_74b2492545", :on_delete=>:cascade})
893   -> 0.0018s
894-- add_foreign_key("insights", "namespaces", {:on_delete=>:cascade})
895   -> 0.0016s
896-- add_foreign_key("insights", "projects", {:on_delete=>:cascade})
897   -> 0.0016s
898-- add_foreign_key("internal_ids", "namespaces", {:name=>"fk_162941d509", :on_delete=>:cascade})
899   -> 0.0017s
900-- add_foreign_key("internal_ids", "projects", {:on_delete=>:cascade})
901   -> 0.0018s
902-- add_foreign_key("ip_restrictions", "namespaces", {:column=>"group_id", :on_delete=>:cascade})
903   -> 0.0014s
904-- add_foreign_key("issue_assignees", "issues", {:name=>"fk_b7d881734a", :on_delete=>:cascade})
905   -> 0.0014s
906-- add_foreign_key("issue_assignees", "users", {:name=>"fk_5e0c8d9154", :on_delete=>:cascade})
907   -> 0.0016s
908-- add_foreign_key("issue_links", "issues", {:column=>"source_id", :name=>"fk_c900194ff2", :on_delete=>:cascade})
909   -> 0.0016s
910-- add_foreign_key("issue_links", "issues", {:column=>"target_id", :name=>"fk_e71bb44f1f", :on_delete=>:cascade})
911   -> 0.0013s
912-- add_foreign_key("issue_metrics", "issues", {:on_delete=>:cascade})
913   -> 0.0015s
914-- add_foreign_key("issue_tracker_data", "services", {:on_delete=>:cascade})
915   -> 0.0016s
916-- add_foreign_key("issues", "issues", {:column=>"moved_to_id", :name=>"fk_a194299be1", :on_delete=>:nullify})
917   -> 0.0013s
918-- add_foreign_key("issues", "milestones", {:name=>"fk_96b1dd429c", :on_delete=>:nullify})
919   -> 0.0014s
920-- add_foreign_key("issues", "projects", {:name=>"fk_899c8f3231", :on_delete=>:cascade})
921   -> 0.0019s
922-- add_foreign_key("issues", "users", {:column=>"author_id", :name=>"fk_05f1e72feb", :on_delete=>:nullify})
923   -> 0.0016s
924-- add_foreign_key("issues", "users", {:column=>"closed_by_id", :name=>"fk_c63cbf6c25", :on_delete=>:nullify})
925   -> 0.0017s
926-- add_foreign_key("issues", "users", {:column=>"updated_by_id", :name=>"fk_ffed080f01", :on_delete=>:nullify})
927   -> 0.0017s
928-- add_foreign_key("jira_connect_subscriptions", "jira_connect_installations", {:on_delete=>:cascade})
929   -> 0.0014s
930-- add_foreign_key("jira_connect_subscriptions", "namespaces", {:on_delete=>:cascade})
931   -> 0.0016s
932-- add_foreign_key("jira_tracker_data", "services", {:on_delete=>:cascade})
933   -> 0.0016s
934-- add_foreign_key("label_links", "labels", {:name=>"fk_d97dd08678", :on_delete=>:cascade})
935   -> 0.0014s
936-- add_foreign_key("label_priorities", "labels", {:on_delete=>:cascade})
937   -> 0.0014s
938-- add_foreign_key("label_priorities", "projects", {:on_delete=>:cascade})
939   -> 0.0017s
940-- add_foreign_key("labels", "namespaces", {:column=>"group_id", :on_delete=>:cascade})
941   -> 0.0015s
942-- add_foreign_key("labels", "projects", {:name=>"fk_7de4989a69", :on_delete=>:cascade})
943   -> 0.0018s
944-- add_foreign_key("lfs_file_locks", "projects", {:on_delete=>:cascade})
945   -> 0.0020s
946-- add_foreign_key("lfs_file_locks", "users", {:on_delete=>:cascade})
947   -> 0.0017s
948-- add_foreign_key("lists", "boards", {:name=>"fk_0d3f677137", :on_delete=>:cascade})
949   -> 0.0015s
950-- add_foreign_key("lists", "labels", {:name=>"fk_7a5553d60f", :on_delete=>:cascade})
951   -> 0.0013s
952-- add_foreign_key("lists", "milestones", {:on_delete=>:cascade})
953   -> 0.0013s
954-- add_foreign_key("lists", "users", {:name=>"fk_d6cf4279f7", :on_delete=>:cascade})
955   -> 0.0017s
956-- add_foreign_key("members", "users", {:name=>"fk_2e88fb7ce9", :on_delete=>:cascade})
957   -> 0.0019s
958-- add_foreign_key("merge_request_assignees", "merge_requests", {:on_delete=>:cascade})
959   -> 0.0015s
960-- add_foreign_key("merge_request_assignees", "users", {:on_delete=>:cascade})
961   -> 0.0016s
962-- add_foreign_key("merge_request_blocks", "merge_requests", {:column=>"blocked_merge_request_id", :on_delete=>:cascade})
963   -> 0.0014s
964-- add_foreign_key("merge_request_blocks", "merge_requests", {:column=>"blocking_merge_request_id", :on_delete=>:cascade})
965   -> 0.0014s
966-- add_foreign_key("merge_request_diff_commits", "merge_request_diffs", {:on_delete=>:cascade})
967   -> 0.0014s
968-- add_foreign_key("merge_request_diff_files", "merge_request_diffs", {:on_delete=>:cascade})
969   -> 0.0013s
970-- add_foreign_key("merge_request_diffs", "merge_requests", {:name=>"fk_8483f3258f", :on_delete=>:cascade})
971   -> 0.0015s
972-- add_foreign_key("merge_request_metrics", "ci_pipelines", {:column=>"pipeline_id", :on_delete=>:cascade})
973   -> 0.0017s
974-- add_foreign_key("merge_request_metrics", "merge_requests", {:on_delete=>:cascade})
975   -> 0.0015s
976-- add_foreign_key("merge_request_metrics", "users", {:column=>"latest_closed_by_id", :name=>"fk_ae440388cc", :on_delete=>:nullify})
977   -> 0.0017s
978-- add_foreign_key("merge_request_metrics", "users", {:column=>"merged_by_id", :name=>"fk_7f28d925f3", :on_delete=>:nullify})
979   -> 0.0016s
980-- add_foreign_key("merge_requests", "ci_pipelines", {:column=>"head_pipeline_id", :name=>"fk_fd82eae0b9", :on_delete=>:nullify})
981   -> 0.0015s
982-- add_foreign_key("merge_requests", "merge_request_diffs", {:column=>"latest_merge_request_diff_id", :name=>"fk_06067f5644", :on_delete=>:nullify})
983   -> 0.0014s
984-- add_foreign_key("merge_requests", "milestones", {:name=>"fk_6a5165a692", :on_delete=>:nullify})
985   -> 0.0015s
986-- add_foreign_key("merge_requests", "projects", {:column=>"source_project_id", :name=>"fk_3308fe130c", :on_delete=>:nullify})
987   -> 0.0019s
988-- add_foreign_key("merge_requests", "projects", {:column=>"target_project_id", :name=>"fk_a6963e8447", :on_delete=>:cascade})
989   -> 0.0019s
990-- add_foreign_key("merge_requests", "users", {:column=>"assignee_id", :name=>"fk_6149611a04", :on_delete=>:nullify})
991   -> 0.0018s
992-- add_foreign_key("merge_requests", "users", {:column=>"author_id", :name=>"fk_e719a85f8a", :on_delete=>:nullify})
993   -> 0.0017s
994-- add_foreign_key("merge_requests", "users", {:column=>"merge_user_id", :name=>"fk_ad525e1f87", :on_delete=>:nullify})
995   -> 0.0019s
996-- add_foreign_key("merge_requests", "users", {:column=>"updated_by_id", :name=>"fk_641731faff", :on_delete=>:nullify})
997   -> 0.0019s
998-- add_foreign_key("merge_requests_closing_issues", "issues", {:on_delete=>:cascade})
999   -> 0.0017s
1000-- add_foreign_key("merge_requests_closing_issues", "merge_requests", {:on_delete=>:cascade})
1001   -> 0.0016s
1002-- add_foreign_key("merge_trains", "ci_pipelines", {:column=>"pipeline_id", :on_delete=>:nullify})
1003   -> 0.0016s
1004-- add_foreign_key("merge_trains", "merge_requests", {:on_delete=>:cascade})
1005   -> 0.0014s
1006-- add_foreign_key("merge_trains", "projects", {:column=>"target_project_id", :on_delete=>:cascade})
1007   -> 0.0016s
1008-- add_foreign_key("merge_trains", "users", {:on_delete=>:cascade})
1009   -> 0.0016s
1010-- add_foreign_key("milestones", "namespaces", {:column=>"group_id", :name=>"fk_95650a40d4", :on_delete=>:cascade})
1011   -> 0.0014s
1012-- add_foreign_key("milestones", "projects", {:name=>"fk_9bd0a0c791", :on_delete=>:cascade})
1013   -> 0.0018s
1014-- add_foreign_key("namespace_aggregation_schedules", "namespaces", {:on_delete=>:cascade})
1015   -> 0.0015s
1016-- add_foreign_key("namespace_root_storage_statistics", "namespaces", {:on_delete=>:cascade})
1017   -> 0.0015s
1018-- add_foreign_key("namespace_statistics", "namespaces", {:on_delete=>:cascade})
1019   -> 0.0015s
1020-- add_foreign_key("namespaces", "namespaces", {:column=>"custom_project_templates_group_id", :name=>"fk_e7a0b20a6b", :on_delete=>:nullify})
1021   -> 0.0014s
1022-- add_foreign_key("namespaces", "plans", {:name=>"fk_fdd12e5b80", :on_delete=>:nullify})
1023   -> 0.0015s
1024-- add_foreign_key("namespaces", "projects", {:column=>"file_template_project_id", :name=>"fk_319256d87a", :on_delete=>:nullify})
1025   -> 0.0019s
1026-- add_foreign_key("note_diff_files", "notes", {:column=>"diff_note_id", :on_delete=>:cascade})
1027   -> 0.0018s
1028-- add_foreign_key("notes", "projects", {:name=>"fk_99e097b079", :on_delete=>:cascade})
1029   -> 0.0025s
1030-- add_foreign_key("notes", "reviews", {:name=>"fk_2e82291620", :on_delete=>:nullify})
1031   -> 0.0016s
1032-- add_foreign_key("notification_settings", "users", {:name=>"fk_0c95e91db7", :on_delete=>:cascade})
1033   -> 0.0021s
1034-- add_foreign_key("oauth_openid_requests", "oauth_access_grants", {:column=>"access_grant_id", :name=>"fk_oauth_openid_requests_oauth_access_grants_access_grant_id"})
1035   -> 0.0013s
1036-- add_foreign_key("operations_feature_flag_scopes", "operations_feature_flags", {:column=>"feature_flag_id", :on_delete=>:cascade})
1037   -> 0.0013s
1038-- add_foreign_key("operations_feature_flags", "projects", {:on_delete=>:cascade})
1039   -> 0.0018s
1040-- add_foreign_key("operations_feature_flags_clients", "projects", {:on_delete=>:cascade})
1041   -> 0.0018s
1042-- add_foreign_key("packages_maven_metadata", "packages_packages", {:column=>"package_id", :name=>"fk_be88aed360", :on_delete=>:cascade})
1043   -> 0.0013s
1044-- add_foreign_key("packages_package_files", "packages_packages", {:column=>"package_id", :name=>"fk_86f0f182f8", :on_delete=>:cascade})
1045   -> 0.0012s
1046-- add_foreign_key("packages_packages", "projects", {:on_delete=>:cascade})
1047   -> 0.0018s
1048-- add_foreign_key("pages_domain_acme_orders", "pages_domains", {:on_delete=>:cascade})
1049   -> 0.0018s
1050-- add_foreign_key("pages_domains", "projects", {:name=>"fk_ea2f6dfc6f", :on_delete=>:cascade})
1051   -> 0.0018s
1052-- add_foreign_key("path_locks", "projects", {:name=>"fk_5265c98f24", :on_delete=>:cascade})
1053   -> 0.0019s
1054-- add_foreign_key("path_locks", "users")
1055   -> 0.0017s
1056-- add_foreign_key("personal_access_tokens", "users")
1057   -> 0.0017s
1058-- add_foreign_key("pool_repositories", "projects", {:column=>"source_project_id", :on_delete=>:nullify})
1059   -> 0.0018s
1060-- add_foreign_key("pool_repositories", "shards", {:on_delete=>:restrict})
1061   -> 0.0014s
1062-- add_foreign_key("project_alerting_settings", "projects", {:on_delete=>:cascade})
1063   -> 0.0017s
1064-- add_foreign_key("project_aliases", "projects", {:on_delete=>:cascade})
1065   -> 0.0019s
1066-- add_foreign_key("project_authorizations", "projects", {:on_delete=>:cascade})
1067   -> 0.0018s
1068-- add_foreign_key("project_authorizations", "users", {:on_delete=>:cascade})
1069   -> 0.0016s
1070-- add_foreign_key("project_auto_devops", "projects", {:on_delete=>:cascade})
1071   -> 0.0018s
1072-- add_foreign_key("project_ci_cd_settings", "projects", {:name=>"fk_24c15d2f2e", :on_delete=>:cascade})
1073   -> 0.0017s
1074-- add_foreign_key("project_custom_attributes", "projects", {:on_delete=>:cascade})
1075   -> 0.0018s
1076-- add_foreign_key("project_daily_statistics", "projects", {:on_delete=>:cascade})
1077   -> 0.0018s
1078-- add_foreign_key("project_deploy_tokens", "deploy_tokens", {:on_delete=>:cascade})
1079   -> 0.0015s
1080-- add_foreign_key("project_deploy_tokens", "projects", {:on_delete=>:cascade})
1081   -> 0.0016s
1082-- add_foreign_key("project_error_tracking_settings", "projects", {:on_delete=>:cascade})
1083   -> 0.0016s
1084-- add_foreign_key("project_feature_usages", "projects", {:on_delete=>:cascade})
1085   -> 0.0017s
1086-- add_foreign_key("project_features", "projects", {:name=>"fk_18513d9b92", :on_delete=>:cascade})
1087   -> 0.0017s
1088-- add_foreign_key("project_group_links", "projects", {:name=>"fk_daa8cee94c", :on_delete=>:cascade})
1089   -> 0.0018s
1090-- add_foreign_key("project_import_data", "projects", {:name=>"fk_ffb9ee3a10", :on_delete=>:cascade})
1091   -> 0.0016s
1092-- add_foreign_key("project_incident_management_settings", "projects", {:on_delete=>:cascade})
1093   -> 0.0018s
1094-- add_foreign_key("project_metrics_settings", "projects", {:on_delete=>:cascade})
1095   -> 0.0018s
1096-- add_foreign_key("project_mirror_data", "projects", {:name=>"fk_d1aad367d7", :on_delete=>:cascade})
1097   -> 0.0018s
1098-- add_foreign_key("project_repositories", "projects", {:on_delete=>:cascade})
1099   -> 0.0018s
1100-- add_foreign_key("project_repositories", "shards", {:on_delete=>:restrict})
1101   -> 0.0013s
1102-- add_foreign_key("project_repository_states", "projects", {:on_delete=>:cascade})
1103   -> 0.0020s
1104-- add_foreign_key("project_statistics", "projects", {:on_delete=>:cascade})
1105   -> 0.0018s
1106-- add_foreign_key("project_tracing_settings", "projects", {:on_delete=>:cascade})
1107   -> 0.0017s
1108-- add_foreign_key("projects", "pool_repositories", {:name=>"fk_6e5c14658a", :on_delete=>:nullify})
1109   -> 0.0019s
1110-- add_foreign_key("prometheus_alert_events", "projects", {:on_delete=>:cascade})
1111   -> 0.0018s
1112-- add_foreign_key("prometheus_alert_events", "prometheus_alerts", {:on_delete=>:cascade})
1113   -> 0.0014s
1114-- add_foreign_key("prometheus_alerts", "environments", {:on_delete=>:cascade})
1115   -> 0.0012s
1116-- add_foreign_key("prometheus_alerts", "projects", {:on_delete=>:cascade})
1117   -> 0.0016s
1118-- add_foreign_key("prometheus_alerts", "prometheus_metrics", {:on_delete=>:cascade})
1119   -> 0.0014s
1120-- add_foreign_key("prometheus_metrics", "projects", {:on_delete=>:cascade})
1121   -> 0.0019s
1122-- add_foreign_key("protected_branch_merge_access_levels", "namespaces", {:column=>"group_id", :name=>"fk_98f3d044fe", :on_delete=>:cascade})
1123   -> 0.0017s
1124-- add_foreign_key("protected_branch_merge_access_levels", "protected_branches", {:name=>"fk_8a3072ccb3", :on_delete=>:cascade})
1125   -> 0.0013s
1126-- add_foreign_key("protected_branch_merge_access_levels", "users")
1127   -> 0.0017s
1128-- add_foreign_key("protected_branch_push_access_levels", "namespaces", {:column=>"group_id", :name=>"fk_7111b68cdb", :on_delete=>:cascade})
1129   -> 0.0015s
1130-- add_foreign_key("protected_branch_push_access_levels", "protected_branches", {:name=>"fk_9ffc86a3d9", :on_delete=>:cascade})
1131   -> 0.0012s
1132-- add_foreign_key("protected_branch_push_access_levels", "users")
1133   -> 0.0016s
1134-- add_foreign_key("protected_branch_unprotect_access_levels", "namespaces", {:column=>"group_id", :on_delete=>:cascade})
1135   -> 0.0016s
1136-- add_foreign_key("protected_branch_unprotect_access_levels", "protected_branches", {:on_delete=>:cascade})
1137   -> 0.0012s
1138-- add_foreign_key("protected_branch_unprotect_access_levels", "users", {:on_delete=>:cascade})
1139   -> 0.0015s
1140-- add_foreign_key("protected_branches", "projects", {:name=>"fk_7a9c6d93e7", :on_delete=>:cascade})
1141   -> 0.0018s
1142-- add_foreign_key("protected_environment_deploy_access_levels", "namespaces", {:column=>"group_id", :on_delete=>:cascade})
1143   -> 0.0015s
1144-- add_foreign_key("protected_environment_deploy_access_levels", "protected_environments", {:on_delete=>:cascade})
1145   -> 0.0013s
1146-- add_foreign_key("protected_environment_deploy_access_levels", "users", {:on_delete=>:cascade})
1147   -> 0.0015s
1148-- add_foreign_key("protected_environments", "projects", {:on_delete=>:cascade})
1149   -> 0.0017s
1150-- add_foreign_key("protected_tag_create_access_levels", "namespaces", {:column=>"group_id", :name=>"fk_b4eb82fe3c", :on_delete=>:cascade})
1151   -> 0.0015s
1152-- add_foreign_key("protected_tag_create_access_levels", "protected_tags", {:name=>"fk_f7dfda8c51", :on_delete=>:cascade})
1153   -> 0.0013s
1154-- add_foreign_key("protected_tag_create_access_levels", "users")
1155   -> 0.0018s
1156-- add_foreign_key("protected_tags", "projects", {:name=>"fk_8e4af87648", :on_delete=>:cascade})
1157   -> 0.0017s
1158-- add_foreign_key("push_event_payloads", "events", {:name=>"fk_36c74129da", :on_delete=>:cascade})
1159   -> 0.0013s
1160-- add_foreign_key("push_rules", "projects", {:name=>"fk_83b29894de", :on_delete=>:cascade})
1161   -> 0.0021s
1162-- add_foreign_key("release_links", "releases", {:on_delete=>:cascade})
1163   -> 0.0016s
1164-- add_foreign_key("releases", "projects", {:name=>"fk_47fe2a0596", :on_delete=>:cascade})
1165   -> 0.0017s
1166-- add_foreign_key("releases", "users", {:column=>"author_id", :name=>"fk_8e4456f90f", :on_delete=>:nullify})
1167   -> 0.0018s
1168-- add_foreign_key("remote_mirrors", "projects", {:name=>"fk_43a9aa4ca8", :on_delete=>:cascade})
1169   -> 0.0019s
1170-- add_foreign_key("repository_languages", "projects", {:on_delete=>:cascade})
1171   -> 0.0023s
1172-- add_foreign_key("resource_label_events", "epics", {:on_delete=>:cascade})
1173   -> 0.0018s
1174-- add_foreign_key("resource_label_events", "issues", {:on_delete=>:cascade})
1175   -> 0.0015s
1176-- add_foreign_key("resource_label_events", "labels", {:on_delete=>:nullify})
1177   -> 0.0014s
1178-- add_foreign_key("resource_label_events", "merge_requests", {:on_delete=>:cascade})
1179   -> 0.0015s
1180-- add_foreign_key("resource_label_events", "users", {:on_delete=>:nullify})
1181   -> 0.0026s
1182-- add_foreign_key("reviews", "merge_requests", {:on_delete=>:cascade})
1183   -> 0.0015s
1184-- add_foreign_key("reviews", "projects", {:on_delete=>:cascade})
1185   -> 0.0018s
1186-- add_foreign_key("reviews", "users", {:column=>"author_id", :on_delete=>:nullify})
1187   -> 0.0015s
1188-- add_foreign_key("saml_providers", "namespaces", {:column=>"group_id", :on_delete=>:cascade})
1189   -> 0.0015s
1190-- add_foreign_key("scim_oauth_access_tokens", "namespaces", {:column=>"group_id", :on_delete=>:cascade})
1191   -> 0.0015s
1192-- add_foreign_key("services", "projects", {:name=>"fk_71cce407f9", :on_delete=>:cascade})
1193   -> 0.0019s
1194-- add_foreign_key("slack_integrations", "services", {:on_delete=>:cascade})
1195   -> 0.0014s
1196-- add_foreign_key("smartcard_identities", "users", {:on_delete=>:cascade})
1197   -> 0.0017s
1198-- add_foreign_key("snippets", "projects", {:name=>"fk_be41fd4bb7", :on_delete=>:cascade})
1199   -> 0.0021s
1200-- add_foreign_key("software_license_policies", "projects", {:on_delete=>:cascade})
1201   -> 0.0019s
1202-- add_foreign_key("software_license_policies", "software_licenses", {:on_delete=>:cascade})
1203   -> 0.0013s
1204-- add_foreign_key("subscriptions", "projects", {:on_delete=>:cascade})
1205   -> 0.0020s
1206-- add_foreign_key("suggestions", "notes", {:on_delete=>:cascade})
1207   -> 0.0017s
1208-- add_foreign_key("system_note_metadata", "notes", {:name=>"fk_d83a918cb1", :on_delete=>:cascade})
1209   -> 0.0013s
1210-- add_foreign_key("term_agreements", "application_setting_terms", {:column=>"term_id"})
1211   -> 0.0013s
1212-- add_foreign_key("term_agreements", "users", {:on_delete=>:cascade})
1213   -> 0.0016s
1214-- add_foreign_key("timelogs", "issues", {:name=>"fk_timelogs_issues_issue_id", :on_delete=>:cascade})
1215   -> 0.0016s
1216-- add_foreign_key("timelogs", "merge_requests", {:name=>"fk_timelogs_merge_requests_merge_request_id", :on_delete=>:cascade})
1217   -> 0.0014s
1218-- add_foreign_key("todos", "namespaces", {:column=>"group_id", :on_delete=>:cascade})
1219   -> 0.0019s
1220-- add_foreign_key("todos", "notes", {:name=>"fk_91d1f47b13", :on_delete=>:cascade})
1221   -> 0.0014s
1222-- add_foreign_key("todos", "projects", {:name=>"fk_45054f9c45", :on_delete=>:cascade})
1223   -> 0.0020s
1224-- add_foreign_key("todos", "users", {:column=>"author_id", :name=>"fk_ccf0373936", :on_delete=>:cascade})
1225   -> 0.0016s
1226-- add_foreign_key("todos", "users", {:name=>"fk_d94154aa95", :on_delete=>:cascade})
1227   -> 0.0019s
1228-- add_foreign_key("trending_projects", "projects", {:on_delete=>:cascade})
1229   -> 0.0019s
1230-- add_foreign_key("u2f_registrations", "users")
1231   -> 0.0019s
1232-- add_foreign_key("user_callouts", "users", {:on_delete=>:cascade})
1233   -> 0.0017s
1234-- add_foreign_key("user_custom_attributes", "users", {:on_delete=>:cascade})
1235   -> 0.0016s
1236-- add_foreign_key("user_interacted_projects", "projects", {:name=>"fk_722ceba4f7", :on_delete=>:cascade})
1237   -> 0.0018s
1238-- add_foreign_key("user_interacted_projects", "users", {:name=>"fk_0894651f08", :on_delete=>:cascade})
1239   -> 0.0016s
1240-- add_foreign_key("user_preferences", "users", {:on_delete=>:cascade})
1241   -> 0.0018s
1242-- add_foreign_key("user_statuses", "users", {:on_delete=>:cascade})
1243   -> 0.0016s
1244-- add_foreign_key("user_synced_attributes_metadata", "users", {:on_delete=>:cascade})
1245   -> 0.0017s
1246-- add_foreign_key("users", "application_setting_terms", {:column=>"accepted_term_id", :name=>"fk_789cd90b35", :on_delete=>:cascade})
1247   -> 0.0016s
1248-- add_foreign_key("users", "namespaces", {:column=>"managing_group_id", :name=>"fk_a4b8fefe3e", :on_delete=>:nullify})
1249   -> 0.0019s
1250-- add_foreign_key("users_ops_dashboard_projects", "projects", {:on_delete=>:cascade})
1251   -> 0.0019s
1252-- add_foreign_key("users_ops_dashboard_projects", "users", {:on_delete=>:cascade})
1253   -> 0.0016s
1254-- add_foreign_key("users_star_projects", "projects", {:name=>"fk_22cd27ddfc", :on_delete=>:cascade})
1255   -> 0.0018s
1256-- add_foreign_key("vulnerability_feedback", "ci_pipelines", {:column=>"pipeline_id", :on_delete=>:nullify})
1257   -> 0.0017s
1258-- add_foreign_key("vulnerability_feedback", "issues", {:on_delete=>:nullify})
1259   -> 0.0015s
1260-- add_foreign_key("vulnerability_feedback", "merge_requests", {:name=>"fk_563ff1912e", :on_delete=>:nullify})
1261   -> 0.0015s
1262-- add_foreign_key("vulnerability_feedback", "projects", {:on_delete=>:cascade})
1263   -> 0.0018s
1264-- add_foreign_key("vulnerability_feedback", "users", {:column=>"author_id", :on_delete=>:cascade})
1265   -> 0.0016s
1266-- add_foreign_key("vulnerability_feedback", "users", {:column=>"comment_author_id", :name=>"fk_94f7c8a81e", :on_delete=>:nullify})
1267   -> 0.0016s
1268-- add_foreign_key("vulnerability_identifiers", "projects", {:on_delete=>:cascade})
1269   -> 0.0019s
1270-- add_foreign_key("vulnerability_occurrence_identifiers", "vulnerability_identifiers", {:column=>"identifier_id", :on_delete=>:cascade})
1271   -> 0.0013s
1272-- add_foreign_key("vulnerability_occurrence_identifiers", "vulnerability_occurrences", {:column=>"occurrence_id", :on_delete=>:cascade})
1273   -> 0.0019s
1274-- add_foreign_key("vulnerability_occurrence_pipelines", "ci_pipelines", {:column=>"pipeline_id", :on_delete=>:cascade})
1275   -> 0.0082s
1276-- add_foreign_key("vulnerability_occurrence_pipelines", "vulnerability_occurrences", {:column=>"occurrence_id", :on_delete=>:cascade})
1277   -> 0.0031s
1278-- add_foreign_key("vulnerability_occurrences", "projects", {:on_delete=>:cascade})
1279   -> 0.0025s
1280-- add_foreign_key("vulnerability_occurrences", "vulnerability_identifiers", {:column=>"primary_identifier_id", :on_delete=>:cascade})
1281   -> 0.0014s
1282-- add_foreign_key("vulnerability_occurrences", "vulnerability_scanners", {:column=>"scanner_id", :on_delete=>:cascade})
1283   -> 0.0014s
1284-- add_foreign_key("vulnerability_scanners", "projects", {:on_delete=>:cascade})
1285   -> 0.0018s
1286-- add_foreign_key("web_hook_logs", "web_hooks", {:on_delete=>:cascade})
1287   -> 0.0016s
1288-- add_foreign_key("web_hooks", "projects", {:name=>"fk_0c8ca6d9d1", :on_delete=>:cascade})
1289   -> 0.0019s
1290Dropped database 'gitlabhq_geo_test'
1291Created database 'gitlabhq_geo_test'
1292-- enable_extension("plpgsql")
1293   -> 0.0172s
1294-- create_table("container_repository_registry", {:id=>:serial, :force=>:cascade})
1295   -> 0.0131s
1296-- create_table("event_log_states", {:primary_key=>"event_id", :force=>:cascade})
1297   -> 0.0018s
1298-- create_table("file_registry", {:id=>:serial, :force=>:cascade})
1299   -> 0.0115s
1300-- create_table("job_artifact_registry", {:id=>:serial, :force=>:cascade})
1301   -> 0.0090s
1302-- create_table("project_registry", {:id=>:serial, :force=>:cascade})
1303   -> 0.0433s
1304$ date
1305Fri Aug 23 10:42:42 UTC 2019
1306$ JOB_NAME=( $CI_JOB_NAME )
1307$ TEST_TOOL=${JOB_NAME[0]}
1308$ TEST_LEVEL=${JOB_NAME[1]}
1309$ DATABASE=${JOB_NAME[2]}
1310$ export KNAPSACK_REPORT_PATH=knapsack/${CI_PROJECT_NAME}/${TEST_TOOL}_${TEST_LEVEL}_${DATABASE}_node_${CI_NODE_INDEX}_${CI_NODE_TOTAL}_report.json
1311$ export KNAPSACK_GENERATE_REPORT=true KNAPSACK_LOG_LEVEL=debug KNAPSACK_TEST_DIR=spec
1312$ export SUITE_FLAKY_RSPEC_REPORT_PATH=${FLAKY_RSPEC_SUITE_REPORT_PATH}
1313$ export FLAKY_RSPEC_REPORT_PATH=rspec_flaky/all_${TEST_TOOL}_${CI_NODE_INDEX}_${CI_NODE_TOTAL}_report.json
1314$ export NEW_FLAKY_RSPEC_REPORT_PATH=rspec_flaky/new_${TEST_TOOL}_${CI_NODE_INDEX}_${CI_NODE_TOTAL}_report.json
1315$ export FLAKY_RSPEC_GENERATE_REPORT=true
1316$ export CACHE_CLASSES=true
1317$ cp ${KNAPSACK_RSPEC_SUITE_REPORT_PATH} ${KNAPSACK_REPORT_PATH}
1318$ [[ -f $FLAKY_RSPEC_REPORT_PATH ]] || echo "{}" > ${FLAKY_RSPEC_REPORT_PATH}
1319$ [[ -f $NEW_FLAKY_RSPEC_REPORT_PATH ]] || echo "{}" > ${NEW_FLAKY_RSPEC_REPORT_PATH}
1320$ scripts/gitaly-test-spawn
1321Checking gitaly-ruby bundle...
1322Warning: the running version of Bundler (1.17.2) is older than the version that created the lockfile (1.17.3). We suggest you upgrade to the latest version of Bundler by running `gem install bundler`.
1323The Gemfile's dependencies are satisfied
1324Trying to connect to gitaly: ...... OK
1325$ date
1326Fri Aug 23 10:42:43 UTC 2019
1327$ export KNAPSACK_TEST_FILE_PATTERN=$(ruby -r./lib/quality/test_level.rb -e "puts Quality::TestLevel.new.pattern(:${TEST_LEVEL})")
1328$ mkdir -p tmp/memory_test
1329$ export MEMORY_TEST_PATH="tmp/memory_test/${TEST_TOOL}_${TEST_LEVEL}_${DATABASE}_node_${CI_NODE_INDEX}_${CI_NODE_TOTAL}_memory.csv"
1330$ knapsack rspec "--color --format documentation --format RspecJunitFormatter --out junit_rspec.xml --tag level:${TEST_LEVEL} --tag ~geo"
1331Knapsack report generator started!
1332Run options:
1333  include {:focus=>true, :level=>"integration"}
1334  exclude {:geo=>true}
1335==> Setting up GitLab Shell...
1336    GitLab Shell set up in 0.531058007 seconds...
1337==> Setting up Gitaly...
1338    Gitaly set up in 0.000277594 seconds...
1339==> Setting up GitLab Elasticsearch Indexer...
1340    GitLab Elasticsearch Indexer set up in 0.000335023 seconds...
1341API::Commits
1342  GET /projects/:id/repository/commits
1343    when unauthenticated and project is public
1344      behaves like project commits
1345        returns project commits
1346        include correct pagination headers
1347    when unauthenticated and project is private
1348      behaves like 404 response
1349        returns 404
1350    when authenticated as a maintainer
1351      behaves like project commits
1352        returns project commits
1353        include correct pagination headers
1354      since optional parameter
1355        returns project commits since provided parameter
1356        include correct pagination headers
1357      until optional parameter
1358        returns project commits until provided parameter
1359        include correct pagination headers
1360      invalid xmlschema date parameters
1361        returns an invalid parameter error message
1362      with empty ref_name parameter
1363        behaves like project commits
1364          returns project commits
1365          include correct pagination headers
1366      path optional parameter
1367        returns project commits matching provided path parameter
1368        include correct pagination headers
1369      all optional parameter
1370        returns all project commits
1371      with_stats optional parameter
1372        behaves like project commits
1373          returns project commits
1374          include correct pagination headers
1375          include commits details
1376      with pagination params
1377        returns correct headers
1378        viewing the first page
1379          returns the first 5 commits
1380        viewing the third page
1381          returns the third 5 commits
1382  POST /projects/:id/repository/commits
1383    returns a 403 unauthorized for user without permissions
1384    returns a 400 bad request if no params are given
1385    create
1386      does not increment the usage counters using access token authentication
1387      a new file in project repo
1388      a new file with utf8 chars in project repo
1389      returns a 400 bad request if file exists
1390      with project path containing a dot in URL
1391        a new file in project repo
1392      when committing to a new branch
1393        when the API user is a guest
1394          returns a 403
1395          when start_project is provided
1396            when posting to a forked project the user owns
1397              identified by Integer (id)
1398                adds a new commit to forked_project and returns a 201
1399              identified by String (full_path)
1400                adds a new commit to forked_project and returns a 201
1401              when branch already exists
1402                returns a 400
1403                when force is set to true
1404                  adds a new commit to forked_project and returns a 201
1405              when start_sha is also provided
1406                fetches the start_sha from the original project to use as parent commit and returns a 201
1407            when the target project is not part of the fork network of start_project
1408              returns a 403
1409          when posting to a forked project the user does not have write access
1410            returns a 403
1411        when start_sha is provided
1412          returns a 400 if start_branch is also provided
1413          returns a 400 if branch already exists
1414          returns a 400 if start_sha does not exist
1415          returns a 400 if start_sha is not a full SHA
1416          uses the start_sha as parent commit and returns a 201
1417          when force is set to true and branch already exists
1418            uses the start_sha as parent commit and returns a 201
1419    delete
1420      an existing file in project repo
1421      returns a 400 bad request if file does not exist
1422    move
1423      an existing file in project repo
1424      returns a 400 bad request if file does not exist
1425    update
1426      an existing file in project repo
1427      returns a 400 bad request if file does not exist
1428    chmod
1429      responds with success
1430      when execute_filemode is false
1431        responds with success
1432      when the file doesn't exists
1433        responds with 400
1434    multiple operations
1435      are committed as one in project repo
1436      includes the commit stats
1437      doesn't include the commit stats when stats is false
1438      return a 400 bad request if there are any issues
1439    when committing into a fork as a maintainer
1440      allows pushing to the source branch of the merge request
1441      denies pushing to another branch
1442  GET /projects/:id/repository/commits/:sha/refs
1443    when ref does not exist
1444      behaves like 404 response
1445        returns 404
1446    when repository is disabled
1447      behaves like 404 response
1448        returns 404
1449    for a valid commit
1450      returns all refs with no scope
1451      returns all refs
1452      returns the branch refs
1453      returns the tag refs
1454  GET /projects/:id/repository/commits/:sha
1455    when stat param
1456      is not present return stats by default
1457      is false it does not include stats
1458      is true it includes stats
1459    when unauthenticated and project is public
1460      behaves like ref commit
1461        returns the ref last commit
1462        when ref does not exist
1463          behaves like 404 response
1464            returns 404
1465        when repository is disabled
1466          behaves like 404 response
1467            returns 404
1468    when unauthenticated and project is private
1469      behaves like 404 response
1470        returns 404
1471    when authenticated as a maintainer
1472      behaves like ref commit
1473        returns the ref last commit
1474        when ref does not exist
1475          behaves like 404 response
1476            returns 404
1477        when repository is disabled
1478          behaves like 404 response
1479            returns 404
1480      when branch contains a dot
1481        behaves like ref commit
1482          returns the ref last commit
1483          when ref does not exist
1484            behaves like 404 response
1485              returns 404
1486          when repository is disabled
1487            behaves like 404 response
1488              returns 404
1489      when branch contains a slash
1490        behaves like 404 response
1491          returns 404
1492      when branch contains an escaped slash
1493        behaves like ref commit
1494          returns the ref last commit
1495          when ref does not exist
1496            behaves like 404 response
1497              returns 404
1498          when repository is disabled
1499            behaves like 404 response
1500              returns 404
1501      requesting with the escaped project full path
1502        behaves like ref commit
1503          returns the ref last commit
1504          when ref does not exist
1505            behaves like 404 response
1506              returns 404
1507          when repository is disabled
1508            behaves like 404 response
1509              returns 404
1510        when branch contains a dot
1511          behaves like ref commit
1512            returns the ref last commit
1513            when ref does not exist
1514              behaves like 404 response
1515                returns 404
1516            when repository is disabled
1517              behaves like 404 response
1518                returns 404
1519      when the ref has a pipeline
1520        includes a "created" status
1521        when pipeline succeeds
1522          includes a "success" status
1523  GET /projects/:id/repository/commits/:sha/diff
1524    when unauthenticated and project is public
1525      behaves like ref diff
1526        returns the diff of the selected commit
1527        when ref does not exist
1528          behaves like 404 response
1529            returns 404
1530        when repository is disabled
1531          behaves like 404 response
1532            returns 404
1533    when unauthenticated and project is private
1534      behaves like 404 response
1535        returns 404
1536    when authenticated as a maintainer
1537      behaves like ref diff
1538        returns the diff of the selected commit
1539        when ref does not exist
1540          behaves like 404 response
1541            returns 404
1542        when repository is disabled
1543          behaves like 404 response
1544            returns 404
1545      when branch contains a dot
1546        behaves like ref diff
1547          returns the diff of the selected commit
1548          when ref does not exist
1549            behaves like 404 response
1550              returns 404
1551          when repository is disabled
1552            behaves like 404 response
1553              returns 404
1554      when branch contains a slash
1555        behaves like 404 response
1556          returns 404
1557      when branch contains an escaped slash
1558        behaves like ref diff
1559          returns the diff of the selected commit
1560          when ref does not exist
1561            behaves like 404 response
1562              returns 404
1563          when repository is disabled
1564            behaves like 404 response
1565              returns 404
1566      requesting with the escaped project full path
1567        behaves like ref diff
1568          returns the diff of the selected commit
1569          when ref does not exist
1570            behaves like 404 response
1571              returns 404
1572          when repository is disabled
1573            behaves like 404 response
1574              returns 404
1575        when branch contains a dot
1576          behaves like ref diff
1577            returns the diff of the selected commit
1578            when ref does not exist
1579              behaves like 404 response
1580                returns 404
1581            when repository is disabled
1582              behaves like 404 response
1583                returns 404
1584      when binary diff are treated as text
1585        behaves like ref diff
1586          returns the diff of the selected commit
1587          when ref does not exist
1588            behaves like 404 response
1589              returns 404
1590          when repository is disabled
1591            behaves like 404 response
1592              returns 404
1593  GET /projects/:id/repository/commits/:sha/comments
1594    when unauthenticated and project is public
1595      behaves like ref comments
1596        when ref exists
1597          returns the diff of the selected commit
1598        when ref does not exist
1599          behaves like 404 response
1600            returns 404
1601        when repository is disabled
1602          behaves like 404 response
1603            returns 404
1604    when unauthenticated and project is private
1605      behaves like 404 response
1606        returns 404
1607    when authenticated as a maintainer
1608      behaves like ref comments
1609        when ref exists
1610          returns the diff of the selected commit
1611        when ref does not exist
1612          behaves like 404 response
1613            returns 404
1614        when repository is disabled
1615          behaves like 404 response
1616            returns 404
1617      when branch contains a dot
1618        behaves like ref comments
1619          when ref exists
1620            returns the diff of the selected commit
1621          when ref does not exist
1622            behaves like 404 response
1623              returns 404
1624          when repository is disabled
1625            behaves like 404 response
1626              returns 404
1627      when branch contains a slash
1628        behaves like 404 response
1629          returns 404
1630      when branch contains an escaped slash
1631        behaves like ref comments
1632          when ref exists
1633            returns the diff of the selected commit
1634          when ref does not exist
1635            behaves like 404 response
1636              returns 404
1637          when repository is disabled
1638            behaves like 404 response
1639              returns 404
1640      requesting with the escaped project full path
1641        behaves like ref comments
1642          when ref exists
1643            returns the diff of the selected commit
1644          when ref does not exist
1645            behaves like 404 response
1646              returns 404
1647          when repository is disabled
1648            behaves like 404 response
1649              returns 404
1650        when branch contains a dot
1651          behaves like ref comments
1652            when ref exists
1653              returns the diff of the selected commit
1654            when ref does not exist
1655              behaves like 404 response
1656                returns 404
1657            when repository is disabled
1658              behaves like 404 response
1659                returns 404
1660    when the commit is present on two projects
1661      returns the comments for the target project
1662  POST :id/repository/commits/:sha/cherry_pick
1663    when unauthenticated and project is public
1664      behaves like 403 response
1665        returns 403
1666    when unauthenticated and project is private
1667      behaves like 404 response
1668        returns 404
1669    when authenticated as an owner
1670      behaves like ref cherry-pick
1671        when ref exists
1672          cherry-picks the ref commit
1673        when repository is disabled
1674          behaves like 404 response
1675            returns 404
1676      when ref does not exist
1677        behaves like 404 response
1678          returns 404
1679      when branch is missing
1680        behaves like 400 response
1681          returns 400
1682      when branch is empty
1683        behaves like 400 response
1684          returns 400
1685        behaves like 400 response
1686          returns 400
1687      when branch does not exist
1688        behaves like 404 response
1689          returns 404
1690      when commit is already included in the target branch
1691        behaves like 400 response
1692          returns 400
1693      when ref contains a dot
1694        behaves like ref cherry-pick
1695          when ref exists
1696            cherry-picks the ref commit
1697          when repository is disabled
1698            behaves like 404 response
1699              returns 404
1700      when ref contains a slash
1701        behaves like 404 response
1702          returns 404
1703      requesting with the escaped project full path
1704        behaves like ref cherry-pick
1705          when ref exists
1706            cherry-picks the ref commit
1707          when repository is disabled
1708            behaves like 404 response
1709              returns 404
1710        when ref contains a dot
1711          behaves like ref cherry-pick
1712            when ref exists
1713              cherry-picks the ref commit
1714            when repository is disabled
1715              behaves like 404 response
1716                returns 404
1717    when authenticated as a developer
1718      when branch is protected
1719        returns 400 if you are not allowed to push to the target branch
1720    when cherry picking to a fork as a maintainer
1721      allows access from a maintainer that to the source branch
1722      denies cherry picking to another branch
1723  POST :id/repository/commits/:sha/revert
1724    when unauthenticated and project is public
1725      behaves like 403 response
1726        returns 403
1727    when unauthenticated and project is private
1728      behaves like 404 response
1729        returns 404
1730    when authenticated as an owner
1731      behaves like ref revert
1732        when ref exists
1733          reverts the ref commit
1734        when repository is disabled
1735          behaves like 404 response
1736            returns 404
1737      when ref does not exist
1738        behaves like 404 response
1739          returns 404
1740      when branch is missing
1741        behaves like 400 response
1742          returns 400
1743      when branch is empty
1744        behaves like 400 response
1745          returns 400
1746        behaves like 400 response
1747          returns 400
1748      when branch does not exist
1749        behaves like 404 response
1750          returns 404
1751      when ref contains a dot
1752        behaves like 400 response
1753          returns 400
1754    when authenticated as a developer
1755      when branch is protected
1756        returns 400 if you are not allowed to push to the target branch
1757  POST /projects/:id/repository/commits/:sha/comments
1758    when unauthenticated and project is public
1759      behaves like 400 response
1760        returns 400
1761    when unauthenticated and project is private
1762      behaves like 404 response
1763        returns 404
1764    when authenticated as an owner
1765      returns the inline comment
1766      returns 400 if note is missing
1767      behaves like ref new comment
1768        when ref exists
1769          creates the comment
1770        when repository is disabled
1771          behaves like 404 response
1772            returns 404
1773      when ref does not exist
1774        behaves like 404 response
1775          returns 404
1776      when ref contains a dot
1777        behaves like ref new comment
1778          when ref exists
1779            creates the comment
1780          when repository is disabled
1781            behaves like 404 response
1782              returns 404
1783      when ref contains a slash
1784        behaves like 404 response
1785          returns 404
1786      when ref contains an escaped slash
1787        behaves like ref new comment
1788          when ref exists
1789            creates the comment
1790          when repository is disabled
1791            behaves like 404 response
1792              returns 404
1793      requesting with the escaped project full path
1794        behaves like ref new comment
1795          when ref exists
1796            creates the comment
1797          when repository is disabled
1798            behaves like 404 response
1799              returns 404
1800        when ref contains a dot
1801          behaves like ref new comment
1802            when ref exists
1803              creates the comment
1804            when repository is disabled
1805              behaves like 404 response
1806                returns 404
1807  GET /projects/:id/repository/commits/:sha/merge_requests
1808    returns the correct merge request
1809    returns 403 for an unauthorized user
1810    responds 404 when the commit does not exist
1811    public project
1812      responds 403 when only members are allowed to read merge requests
1813  GET /projects/:id/repository/commits/:sha/signature
1814    when commit does not exist
1815      behaves like 404 response
1816        returns 404
1817    unsigned commit
1818      behaves like 404 response
1819        returns 404
1820    signed commit
1821      returns correct JSON
1822API::Issues
1823  GET /projects/:id/issues
1824    avoids N+1 queries
1825    returns 404 when project does not exist
1826    returns 404 on private projects for other users
1827    returns no issues when user has access to project but not issues
1828    returns project issues without confidential issues for non project members
1829    returns project issues without confidential issues for project members with guest role
1830    returns project confidential issues for author
1831    returns only confidential issues
1832    returns only public issues
1833    returns project confidential issues for assignee
1834    returns project issues with confidential issues for project members
1835    returns project confidential issues for admin
1836    returns an array of labeled project issues
1837    returns an array of labeled project issues with labels param as array
1838    returns issues matching given search string for title
1839    returns issues matching given search string for description
1840    returns an array of issues found by iids
1841    returns an empty array if iid does not exist
1842    returns an empty array if not all labels matches
1843    returns an array of project issues with any label
1844    returns an array of project issues with any label with labels param as array
1845    returns an array of project issues with no label
1846    returns an array of project issues with no label with labels param as array
1847    returns an empty array if no project issue matches labels
1848    returns an empty array if no issue matches milestone
1849    returns an empty array if milestone does not exist
1850    returns an array of issues in given milestone
1851    returns an array of issues matching state in milestone
1852    returns an array of issues with no milestone
1853    returns an array of issues with any milestone
1854    sorts ascending when requested
1855    sorts by updated_at descending when requested
1856    sorts by updated_at ascending when requested
1857    when unauthenticated
1858      returns public project issues
1859      issues_statistics
1860        no state is treated as all state
1861          behaves like project issues statistics
1862            returns project issues statistics
1863        statistics when all state is passed
1864          behaves like project issues statistics
1865            returns project issues statistics
1866        closed state is treated as all state
1867          behaves like project issues statistics
1868            returns project issues statistics
1869        opened state is treated as all state
1870          behaves like project issues statistics
1871            returns project issues statistics
1872        when filtering by milestone and no state treated as all state
1873          behaves like project issues statistics
1874            returns project issues statistics
1875        when filtering by milestone and all state
1876          behaves like project issues statistics
1877            returns project issues statistics
1878        when filtering by milestone and closed state treated as all state
1879          behaves like project issues statistics
1880            returns project issues statistics
1881        when filtering by milestone and opened state treated as all state
1882          behaves like project issues statistics
1883            returns project issues statistics
1884        sort does not affect statistics
1885          behaves like project issues statistics
1886            returns project issues statistics
1887    behaves like accessible merge requests count
1888      returns anonymous accessible merge requests count
1889      returns guest accessible merge requests count
1890      returns reporter accessible merge requests count
1891      returns admin accessible merge requests count
1892    with labeled issues
1893      behaves like labeled issues with labels and label_name params
1894        array of labeled issues when all labels match
1895          behaves like returns label names
1896            returns label names
1897        array of labeled issues when all labels match with labels param as array
1898          behaves like returns label names
1899            returns label names
1900        when with_labels_details provided
1901          array of labeled issues when all labels match
1902            behaves like returns basic label entity
1903              returns basic label entity
1904          array of labeled issues when all labels match with labels param as array
1905            behaves like returns basic label entity
1906              returns basic label entity
1907    without sort params
1908      sorts by created_at descending by default
1909      with 2 issues with same created_at
1910        page breaks first page correctly
1911        page breaks second page correctly
1912    issues_statistics
1913      no state is treated as all state
1914        behaves like project issues statistics
1915          returns project issues statistics
1916      statistics when all state is passed
1917        behaves like project issues statistics
1918          returns project issues statistics
1919      closed state is treated as all state
1920        behaves like project issues statistics
1921          returns project issues statistics
1922      opened state is treated as all state
1923        behaves like project issues statistics
1924          returns project issues statistics
1925      when filtering by milestone and no state treated as all state
1926        behaves like project issues statistics
1927          returns project issues statistics
1928      when filtering by milestone and all state
1929        behaves like project issues statistics
1930          returns project issues statistics
1931      when filtering by milestone and closed state treated as all state
1932        behaves like project issues statistics
1933          returns project issues statistics
1934      when filtering by milestone and opened state treated as all state
1935        behaves like project issues statistics
1936          returns project issues statistics
1937      sort does not affect statistics
1938        behaves like project issues statistics
1939          returns project issues statistics
1940    filtering by assignee_username
1941      returns issues by assignee_username
1942      returns issues by assignee_username as string
1943      returns error when multiple assignees are passed
1944      returns error when assignee_username and assignee_id are passed together
1945  GET /projects/:id/issues/:issue_iid
1946    exposes known attributes
1947    exposes the closed_at attribute
1948    returns a project issue by internal id
1949    returns 404 if issue id not found
1950    returns 404 if the issue ID is used
1951    when unauthenticated
1952      returns public issues
1953    links exposure
1954      exposes related resources full URIs
1955    confidential issues
1956      returns 404 for non project members
1957      returns 404 for project members with guest role
1958      returns confidential issue for project members
1959      returns confidential issue for author
1960      returns confidential issue for assignee
1961      returns confidential issue for admin
1962    behaves like accessible merge requests count
1963      returns anonymous accessible merge requests count
1964      returns guest accessible merge requests count
1965      returns reporter accessible merge requests count
1966      returns admin accessible merge requests count
1967  GET :id/issues/:issue_iid/closed_by
1968    returns merge requests that will close issue on merge
1969    returns 404 when issue doesn't exists
1970    when unauthenticated
1971      return public project issues
1972    when no merge requests will close issue
1973      returns empty array
1974  GET :id/issues/:issue_iid/related_merge_requests
1975    returns merge requests that mentioned a issue
1976    returns merge requests cross-project wide
1977    does not generate references to projects with no access
1978    returns 404 when issue doesn't exists
1979    when unauthenticated
1980      return list of referenced merge requests from issue
1981      renders 404 if project is not visible
1982    no merge request mentioned a issue
1983      returns empty array
1984  GET /projects/:id/issues/:issue_iid/user_agent_detail
1985    exposes known attributes
1986    returns unauthorized for non-admin users
1987    when unauthenticated
1988      returns unauthorized
1989  GET projects/:id/issues/:issue_iid/participants
1990    returns 404 if the issue is confidential
1991    behaves like issuable participants endpoint
1992      returns participants
1993      returns a 404 when iid does not exist
1994      returns a 404 when id is used instead of iid
1995API::Branches
1996  GET /projects/:id/repository/branches
1997    when search parameter is passed
1998      and branch exists
1999        returns correct branches
2000      and branch does not exist
2001        returns an empty array
2002    when unauthenticated and project is public
2003      behaves like repository branches
2004        returns the repository branches
2005        determines only a limited number of merged branch names
2006        merge status matches reality on paginated input
2007        when repository is disabled
2008          behaves like 404 response
2009            returns 404
2010    when unauthenticated and project is private
2011      behaves like 404 response
2012        returns 404
2013    when authenticated as a maintainer
2014      behaves like repository branches
2015        returns the repository branches
2016        determines only a limited number of merged branch names
2017        merge status matches reality on paginated input
2018        when repository is disabled
2019          behaves like 404 response
2020            returns 404
2021      requesting with the escaped project full path
2022        behaves like repository branches
2023          returns the repository branches
2024          determines only a limited number of merged branch names
2025          merge status matches reality on paginated input
2026          when repository is disabled
2027            behaves like 404 response
2028              returns 404
2029    when authenticated as a guest
2030      behaves like 403 response
2031        returns 403
2032  GET /projects/:id/repository/branches/:branch
2033    when unauthenticated and project is public
2034      returns that the current user cannot push
2035      behaves like repository branch
2036        returns the repository branch
2037        HEAD request
2038          returns 204 No Content
2039          returns 404 Not Found
2040        when branch does not exist
2041          behaves like 404 response
2042            returns 404
2043        when the branch refname is invalid
2044          behaves like 400 response
2045            returns 400
2046        when repository is disabled
2047          behaves like 404 response
2048            returns 404
2049    when unauthenticated and project is private
2050      behaves like 404 response
2051        returns 404
2052    when authenticated as a maintainer
2053      returns that the current user can push
2054      behaves like repository branch
2055        returns the repository branch
2056        HEAD request
2057          returns 204 No Content
2058          returns 404 Not Found
2059        when branch does not exist
2060          behaves like 404 response
2061            returns 404
2062        when the branch refname is invalid
2063          behaves like 400 response
2064            returns 400
2065        when repository is disabled
2066          behaves like 404 response
2067            returns 404
2068      when branch contains a dot
2069        behaves like repository branch
2070          returns the repository branch
2071          HEAD request
2072            returns 204 No Content
2073            returns 404 Not Found
2074          when branch does not exist
2075            behaves like 404 response
2076              returns 404
2077          when the branch refname is invalid
2078            behaves like 400 response
2079              returns 400
2080          when repository is disabled
2081            behaves like 404 response
2082              returns 404
2083      when branch contains a slash
2084        behaves like 404 response
2085          returns 404
2086      when branch contains an escaped slash
2087        behaves like repository branch
2088          returns the repository branch
2089          HEAD request
2090            returns 204 No Content
2091            returns 404 Not Found
2092          when branch does not exist
2093            behaves like 404 response
2094              returns 404
2095          when the branch refname is invalid
2096            behaves like 400 response
2097              returns 400
2098          when repository is disabled
2099            behaves like 404 response
2100              returns 404
2101      requesting with the escaped project full path
2102        behaves like repository branch
2103          returns the repository branch
2104          HEAD request
2105            returns 204 No Content
2106            returns 404 Not Found
2107          when branch does not exist
2108            behaves like 404 response
2109              returns 404
2110          when the branch refname is invalid
2111            behaves like 400 response
2112              returns 400
2113          when repository is disabled
2114            behaves like 404 response
2115              returns 404
2116        when branch contains a dot
2117          behaves like repository branch
2118            returns the repository branch
2119            HEAD request
2120              returns 204 No Content
2121              returns 404 Not Found
2122            when branch does not exist
2123              behaves like 404 response
2124                returns 404
2125            when the branch refname is invalid
2126              behaves like 400 response
2127                returns 400
2128            when repository is disabled
2129              behaves like 404 response
2130                returns 404
2131    when authenticated as a developer and branch is protected
2132      returns that the current user cannot push
2133      behaves like repository branch
2134        returns the repository branch
2135        HEAD request
2136          returns 204 No Content
2137          returns 404 Not Found
2138        when branch does not exist
2139          behaves like 404 response
2140            returns 404
2141        when the branch refname is invalid
2142          behaves like 400 response
2143            returns 400
2144        when repository is disabled
2145          behaves like 404 response
2146            returns 404
2147    when authenticated as a guest
2148      behaves like 403 response
2149        returns 403
2150  PUT /projects/:id/repository/branches/:branch/protect
2151    when unauthenticated and project is private
2152      behaves like 404 response
2153        returns 404
2154    when authenticated as a guest
2155      behaves like 403 response
2156        returns 403
2157    when authenticated as a maintainer
2158      when a protected branch doesn't already exist
2159        behaves like repository new protected branch
2160          protects a single branch
2161          protects a single branch and developers can push
2162          protects a single branch and developers can merge
2163          protects a single branch and developers can push and merge
2164          when branch does not exist
2165            behaves like 404 response
2166              returns 404
2167          when the branch refname is invalid
2168            behaves like 400 response
2169              returns 400
2170          when repository is disabled
2171            behaves like 404 response
2172              returns 404
2173        when branch contains a dot
2174          behaves like repository new protected branch
2175            protects a single branch
2176            protects a single branch and developers can push
2177            protects a single branch and developers can merge
2178            protects a single branch and developers can push and merge
2179            when branch does not exist
2180              behaves like 404 response
2181                returns 404
2182            when the branch refname is invalid
2183              behaves like 400 response
2184                returns 400
2185            when repository is disabled
2186              behaves like 404 response
2187                returns 404
2188        when branch contains a slash
2189          behaves like 404 response
2190            returns 404
2191        when branch contains an escaped slash
2192          behaves like repository new protected branch
2193            protects a single branch
2194            protects a single branch and developers can push
2195            protects a single branch and developers can merge
2196            protects a single branch and developers can push and merge
2197            when branch does not exist
2198              behaves like 404 response
2199                returns 404
2200            when the branch refname is invalid
2201              behaves like 400 response
2202                returns 400
2203            when repository is disabled
2204              behaves like 404 response
2205                returns 404
2206        requesting with the escaped project full path
2207          behaves like repository new protected branch
2208            protects a single branch
2209            protects a single branch and developers can push
2210            protects a single branch and developers can merge
2211            protects a single branch and developers can push and merge
2212            when branch does not exist
2213              behaves like 404 response
2214                returns 404
2215            when the branch refname is invalid
2216              behaves like 400 response
2217                returns 400
2218            when repository is disabled
2219              behaves like 404 response
2220                returns 404
2221          when branch contains a dot
2222            behaves like repository new protected branch
2223              protects a single branch
2224              protects a single branch and developers can push
2225              protects a single branch and developers can merge
2226              protects a single branch and developers can push and merge
2227              when branch does not exist
2228                behaves like 404 response
2229                  returns 404
2230              when the branch refname is invalid
2231                behaves like 400 response
2232                  returns 400
2233              when repository is disabled
2234                behaves like 404 response
2235                  returns 404
2236      when protected branch already exists
2237        when developers can push and merge
2238          updates that a developer cannot push or merge
2239        when developers cannot push or merge
2240          updates that a developer can push and merge
2241  PUT /projects/:id/repository/branches/:branch/unprotect
2242    when unauthenticated and project is private
2243      behaves like 404 response
2244        returns 404
2245    when authenticated as a guest
2246      behaves like 403 response
2247        returns 403
2248    when authenticated as a maintainer
2249      when a protected branch doesn't already exist
2250        behaves like repository unprotected branch
2251          unprotects a single branch
2252          when branch does not exist
2253            behaves like 404 response
2254              returns 404
2255          when the branch refname is invalid
2256            behaves like 400 response
2257              returns 400
2258          when repository is disabled
2259            behaves like 404 response
2260              returns 404
2261        when branch contains a dot
2262          behaves like repository unprotected branch
2263            unprotects a single branch
2264            when branch does not exist
2265              behaves like 404 response
2266                returns 404
2267            when the branch refname is invalid
2268              behaves like 400 response
2269                returns 400
2270            when repository is disabled
2271              behaves like 404 response
2272                returns 404
2273        when branch contains a slash
2274          behaves like 404 response
2275            returns 404
2276        when branch contains an escaped slash
2277          behaves like repository unprotected branch
2278            unprotects a single branch
2279            when branch does not exist
2280              behaves like 404 response
2281                returns 404
2282            when the branch refname is invalid
2283              behaves like 400 response
2284                returns 400
2285            when repository is disabled
2286              behaves like 404 response
2287                returns 404
2288        requesting with the escaped project full path
2289          behaves like repository unprotected branch
2290            unprotects a single branch
2291            when branch does not exist
2292              behaves like 404 response
2293                returns 404
2294            when the branch refname is invalid
2295              behaves like 400 response
2296                returns 400
2297            when repository is disabled
2298              behaves like 404 response
2299                returns 404
2300          when branch contains a dot
2301            behaves like repository unprotected branch
2302              unprotects a single branch
2303              when branch does not exist
2304                behaves like 404 response
2305                  returns 404
2306              when the branch refname is invalid
2307                behaves like 400 response
2308                  returns 400
2309              when repository is disabled
2310                behaves like 404 response
2311                  returns 404
2312  POST /projects/:id/repository/branches
2313    returns 400 if branch name is invalid
2314    returns 400 if branch already exists
2315    returns 400 if ref name is invalid
2316    when unauthenticated and project is private
2317      behaves like 404 response
2318        returns 404
2319    when authenticated as a guest
2320      behaves like 403 response
2321        returns 403
2322    when authenticated as a maintainer
2323      when a protected branch doesn't already exist
2324        behaves like repository new branch
2325          creates a new branch
2326          when repository is disabled
2327            behaves like 404 response
2328              returns 404
2329        requesting with the escaped project full path
2330          behaves like repository new branch
2331            creates a new branch
2332            when repository is disabled
2333              behaves like 404 response
2334                returns 404
2335  DELETE /projects/:id/repository/branches/:branch
2336    removes branch
2337    removes a branch with dots in the branch name
2338    returns 404 if branch not exists
2339    when the branch refname is invalid
2340      behaves like 400 response
2341        returns 400
2342    behaves like 412 response
2343      for a modified ressource
2344        returns 412
2345      for an unmodified ressource
2346        returns accepted
2347  DELETE /projects/:id/repository/merged_branches
2348    returns 202 with json body
2349    returns a 403 error if guest
2350Projects::NotesController
2351  GET index
2352    passes last_fetched_at from headers to NotesFinder
2353    when user notes_filter is present
2354      filters system notes by comments
2355      returns all notes
2356      does not merge label event notes
2357    for a discussion note
2358      responds with the expected attributes
2359    for a diff discussion note
2360      responds with the expected attributes
2361    for a commit note
2362      when displayed on a merge request
2363        responds with the expected attributes
2364      when displayed on the commit
2365        responds with the expected attributes
2366        when user cannot read commit
2367          renders 404
2368    for a regular note
2369      responds with the expected attributes
2370    with cross-reference system note
2371      filters notes that the user should not see
2372      does not result in N+1 queries
2373  POST create
2374    returns status 302 for html
2375    returns status 200 for json
2376    returns discussion JSON when the return_discussion param is set
2377    when merge_request_diff_head_sha present
2378      returns status 302 for html
2379    when creating a comment on a commit with SHA1 starting with a large number
2380      creates a note successfully
2381    when creating a commit comment from an MR fork
2382      when the note_project_id is not correct
2383        returns a 404
2384      when the user has no access to the fork
2385        returns a 404
2386      when the user has access to the fork
2387        creates the note
2388    when target_id and noteable_id do not match
2389      uses target_id and ignores noteable_id
2390    when the merge request discussion is locked
2391      when a noteable is not found
2392        returns 404 status
2393      when a user is a team member
2394        returns 302 status for html
2395        returns 200 status for json
2396        creates a new note
2397      when a user is not a team member
2398        returns 404 status
2399        does not create a new note
2400    when creating a note with quick actions
2401      with commands that return changes
2402        includes changes in commands_changes
2403      with commands that do not return changes
2404        does not include changes in commands_changes
2405  PUT update
2406    should update the note with a valid issue
2407      updates the note
2408    doesnt update the note
2409      disallows edits when the issue is confidential and the user has guest permissions
2410  DELETE destroy
2411    user is the author of a note
2412      returns status 200 for html
2413      deletes the note
2414    user is not the author of a note
2415      returns status 404
2416  POST toggle_award_emoji
2417    toggles the award emoji
2418    removes the already awarded emoji
2419    marks Todos on the Noteable as done
2420  resolving and unresolving
2421    POST resolve
2422      when the user is not authorized to resolve the note
2423        returns status 404
2424      when the user is authorized to resolve the note
2425        when the note is not resolvable
2426          returns status 404
2427        when the note is resolvable
2428          resolves the note
2429          sends notifications if all discussions are resolved
2430          returns the name of the resolving user
2431          returns status 200
2432    DELETE unresolve
2433      when the user is not authorized to resolve the note
2434        returns status 404
2435      when the user is authorized to resolve the note
2436        when the note is not resolvable
2437          returns status 404
2438        when the note is resolvable
2439          unresolves the note
2440          returns status 200
2441Git LFS API and storage
2442  when lfs is disabled
2443    responds with 501
2444  project specific LFS settings
2445    with LFS disabled globally
2446      LFS disabled in project
2447        responds with a 501 message on upload
2448        responds with a 501 message on download
2449      LFS enabled in project
2450        responds with a 501 message on upload
2451        responds with a 501 message on download
2452    with LFS enabled globally
2453      LFS disabled in project
2454        responds with a 403 message on upload
2455        responds with a 403 message on download
2456      LFS enabled in project
2457        responds with a 200 message on upload
2458        responds with a 200 message on download
2459  deprecated API
2460    when fetching lfs object using deprecated API
2461      behaves like a deprecated
2462        responds with 501
2463        returns deprecated message
2464    when handling lfs request using deprecated API
2465      behaves like a deprecated
2466        responds with 501
2467        returns deprecated message
2468  when fetching lfs object
2469    and request comes from gitlab-workhorse
2470      without user being authorized
2471        responds with status 401
2472      with required headers
2473        with user is authorized
2474          and does not have project access
2475            responds with status 404
2476          and does have project access
2477            behaves like responds with a file
2478              responds with status 200
2479              responds with the file location
2480            when LFS uses object storage
2481              when proxy download is enabled
2482                responds with redirect
2483                responds with the workhorse send-url
2484              when proxy download is disabled
2485                responds with redirect
2486                responds with the file location
2487        when deploy key is authorized
2488          behaves like responds with a file
2489            responds with status 200
2490            responds with the file location
2491        when using a user key
2492          when user allowed
2493            behaves like responds with a file
2494              responds with status 200
2495              responds with the file location
2496          when user not allowed
2497            responds with status 404
2498        when build is authorized as
2499          administrator
2500            behaves like can download LFS only from own projects
2501              for owned project
2502                behaves like responds with a file
2503                  responds with status 200
2504                  responds with the file location
2505              for member of project
2506                behaves like responds with a file
2507                  responds with status 200
2508                  responds with the file location
2509              for other project
2510                rejects downloading code
2511          regular user
2512            behaves like can download LFS only from own projects
2513              for owned project
2514                behaves like responds with a file
2515                  responds with status 200
2516                  responds with the file location
2517              for member of project
2518                behaves like responds with a file
2519                  responds with status 200
2520                  responds with the file location
2521              for other project
2522                rejects downloading code
2523          does not have user
2524            behaves like can download LFS only from own projects
2525              for owned project
2526                behaves like responds with a file
2527                  responds with status 200
2528                  responds with the file location
2529              for member of project
2530                behaves like responds with a file
2531                  responds with status 200
2532                  responds with the file location
2533              for other project
2534                rejects downloading code
2535      without required headers
2536        responds with status 404
2537  when handling lfs batch request
2538    download
2539      when user is authenticated
2540        behaves like an authorized requests
2541          when downloading an lfs object that is assigned to our project
2542            responds with status 200
2543            with href to download
2544          when downloading an lfs object that is assigned to other project
2545            responds with status 200
2546            with href to download
2547          when downloading a lfs object that does not exist
2548            responds with status 200
2549            with an 404 for specific object
2550          when downloading one new and one existing lfs object
2551            responds with status 200
2552            responds with upload hypermedia link for the new object
2553        when user does is not member of the project
2554          responds with 404
2555        when user does not have download access
2556          responds with 403
2557      when using Deploy Tokens
2558        when Deploy Token is valid
2559          behaves like an authorized requests
2560            when downloading an lfs object that is assigned to our project
2561              responds with status 200
2562              with href to download
2563            when downloading an lfs object that is assigned to other project
2564              responds with status 200
2565              with href to download
2566            when downloading a lfs object that does not exist
2567              responds with status 200
2568              with an 404 for specific object
2569            when downloading one new and one existing lfs object
2570              responds with status 200
2571              responds with upload hypermedia link for the new object
2572        when Deploy Token is not valid
2573          responds with access denied
2574        when Deploy Token is not related to the project
2575          responds with access forbidden
2576      when build is authorized as
2577        administrator
2578          behaves like can download LFS only from own projects
2579            for own project
2580              behaves like an authorized requests
2581                when downloading an lfs object that is assigned to our project
2582                  responds with status 200
2583                  with href to download
2584                when downloading an lfs object that is assigned to other project
2585                  responds with status 200
2586                  with href to download
2587                when downloading a lfs object that does not exist
2588                  responds with status 200
2589                  with an 404 for specific object
2590                when downloading one new and one existing lfs object
2591                  responds with status 200
2592                  responds with upload hypermedia link for the new object
2593            for other project
2594              rejects downloading code
2595        regular user
2596          behaves like can download LFS only from own projects
2597            for own project
2598              behaves like an authorized requests
2599                when downloading an lfs object that is assigned to our project
2600                  responds with status 200
2601                  with href to download
2602                when downloading an lfs object that is assigned to other project
2603                  responds with status 200
2604                  with href to download
2605                when downloading a lfs object that does not exist
2606                  responds with status 200
2607                  with an 404 for specific object
2608                when downloading one new and one existing lfs object
2609                  responds with status 200
2610                  responds with upload hypermedia link for the new object
2611            for other project
2612              rejects downloading code
2613        does not have user
2614          behaves like can download LFS only from own projects
2615            for own project
2616              behaves like an authorized requests
2617                when downloading an lfs object that is assigned to our project
2618                  responds with status 200
2619                  with href to download
2620                when downloading an lfs object that is assigned to other project
2621                  responds with status 200
2622                  with href to download
2623                when downloading a lfs object that does not exist
2624                  responds with status 200
2625                  with an 404 for specific object
2626                when downloading one new and one existing lfs object
2627                  responds with status 200
2628                  responds with upload hypermedia link for the new object
2629            for other project
2630              rejects downloading code
2631      when user is not authenticated
2632        is accessing public project
2633          responds with status 200 and href to download
2634          responds with status 200 and href to download
2635        is accessing non-public project
2636          responds with authorization required
2637    upload
2638      when request is authenticated
2639        when user has project push access
2640          when pushing an lfs object that already exists
2641            responds with status 200
2642            responds with links the object to the project
2643          when pushing a lfs object that does not exist
2644            behaves like pushes new LFS objects
2645              responds with upload hypermedia link
2646          when pushing one new and one existing lfs object
2647            responds with status 200
2648            responds with upload hypermedia link for the new object
2649        when user does not have push access
2650          responds with 403
2651        when build is authorized
2652          build has an user
2653            tries to push to own project
2654              responds with 403 (not 404 because project is public)
2655            tries to push to other project
2656              responds with 403 (not 404 because project is public)
2657          does not have user
2658            responds with 403 (not 404 because project is public)
2659        when deploy key has project push access
2660          behaves like pushes new LFS objects
2661            responds with upload hypermedia link
2662      when user is not authenticated
2663        when user has push access
2664          responds with status 401
2665        when user does not have push access
2666          responds with status 401
2667    unsupported
2668      responds with status 404
2669  when handling lfs batch request on a read-only GitLab instance
2670    responds with a 200 message on download
2671    responds with a 403 message on upload
2672  when pushing a lfs object
2673    to one project
2674      when user is authenticated
2675        when user has push access to the project
2676          and the request bypassed workhorse
2677            raises an exception
2678          and request is sent by gitlab-workhorse to authorize the request
2679            when using local storage
2680              behaves like a local file
2681                behaves like a valid response
2682                  responds with status 200
2683                  uses the gitlab-workhorse content type
2684                  responds with status 200, location of lfs store and object details
2685            when using remote storage
2686              when direct upload is enabled
2687                behaves like a valid response
2688                  responds with status 200
2689                  uses the gitlab-workhorse content type
2690                  responds with status 200, location of lfs remote store and object details
2691              when direct upload is disabled
2692                behaves like a local file
2693                  behaves like a valid response
2694                    responds with status 200
2695                    uses the gitlab-workhorse content type
2696                    responds with status 200, location of lfs store and object details
2697          and request is sent by gitlab-workhorse to finalize the upload
2698            responds with status 200
2699            lfs object is linked to the project
2700          and request to finalize the upload is not sent by gitlab-workhorse
2701            fails with a JWT decode error
2702          and workhorse requests upload finalize for a new lfs object
2703            with object storage disabled
2704              doesn't attempt to migrate file to object storage
2705            with object storage enabled
2706              and direct upload enabled
2707                with invalid remote_id: 123123
2708                  responds with status 403
2709                with invalid remote_id: ../../123123
2710                  responds with status 403
2711                with valid remote_id
2712                  responds with status 200
2713                  schedules migration of file to object storage
2714                  have valid file
2715              and background upload enabled
2716                schedules migration of file to object storage
2717          invalid tempfiles
2718            rejects slashes in the tempfile name (path traversal)
2719        and user does not have push access
2720          behaves like forbidden
2721            and request is sent by gitlab-workhorse to authorize the request
2722              responds with 403
2723            and request is sent by gitlab-workhorse to finalize the upload
2724              responds with 403
2725            and request is sent with a malformed headers
2726              does not recognize it as a valid lfs command
2727      when build is authorized
2728        build has an user
2729          tries to push to own project
2730            responds with 403 (not 404 because the build user can read the project)
2731          tries to push to other project
2732            responds with 404 (do not leak non-public project existence)
2733        does not have user
2734          responds with 404 (do not leak non-public project existence)
2735      for unauthenticated
2736        behaves like unauthorized
2737          and request is sent by gitlab-workhorse to authorize the request
2738            responds with status 401
2739          and request is sent by gitlab-workhorse to finalize the upload
2740            responds with status 401
2741          and request is sent with a malformed headers
2742            does not recognize it as a valid lfs command
2743    to a forked project
2744      when user is authenticated
2745        when user has push access to the project
2746          and request is sent by gitlab-workhorse to authorize the request
2747            responds with status 200
2748            with location of lfs store and object details
2749          and request is sent by gitlab-workhorse to finalize the upload
2750            responds with status 200
2751            lfs object is linked to the source project
2752        and user does not have push access
2753          behaves like forbidden
2754            and request is sent by gitlab-workhorse to authorize the request
2755              responds with 403
2756            and request is sent by gitlab-workhorse to finalize the upload
2757              responds with 403
2758            and request is sent with a malformed headers
2759              does not recognize it as a valid lfs command
2760      when build is authorized
2761        build has an user
2762          tries to push to own project
2763            responds with 403 (not 404 because project is public)
2764          tries to push to other project
2765            responds with 403 (not 404 because project is public)
2766        does not have user
2767          responds with 403 (not 404 because project is public)
2768      for unauthenticated
2769        behaves like unauthorized
2770          and request is sent by gitlab-workhorse to authorize the request
2771            responds with status 401
2772          and request is sent by gitlab-workhorse to finalize the upload
2773            responds with status 401
2774          and request is sent with a malformed headers
2775            does not recognize it as a valid lfs command
2776      and second project not related to fork or a source project
2777        when pushing the same lfs object to the second project
2778          responds with status 200
2779          links the lfs object to the project
2780Adding a Note
2781  behaves like a Note mutation when the user does not have permission
2782    behaves like a Note mutation that does not create a Note
2783      should not change `Note.count`
2784    behaves like a mutation that returns top-level errors
2785      should eq ["The resource that you are attempting to access does not exist or you don't have permission to perform this action"]
2786  when the user has permission
2787    returns the note
2788    behaves like a Note mutation that creates a Note
2789      should change `Note.count` by 1
2790    behaves like a Note mutation when there are active record validation errors
2791      returns an empty Note
2792      behaves like a Note mutation that does not create a Note
2793        should not change `Note.count`
2794      behaves like a mutation that returns errors in the response
2795        should eq ["Error 1", "Error 2"]
2796    behaves like a Note mutation when the given resource id is not for a Noteable
2797      behaves like a Note mutation that does not create a Note
2798        should not change `Note.count`
2799      behaves like a mutation that returns top-level errors
2800        should eq ["Cannot add notes to this resource"]
2801    creating Notes in reply to a discussion
2802      when the user does not have permission to create notes on the discussion
2803        behaves like a mutation that returns top-level errors
2804          should eq ["The discussion does not exist or you don't have permission to perform this action"]
2805      when the user has permission to create notes on the discussion
2806        creates a Note in a discussion
2807Adding an image DiffNote
2808  behaves like a Note mutation when the user does not have permission
2809    behaves like a Note mutation that does not create a Note
2810      should not change `Note.count`
2811    behaves like a mutation that returns top-level errors
2812      should eq ["The resource that you are attempting to access does not exist or you don't have permission to perform this action"]
2813  when the user has permission
2814    returns the note with the correct position
2815    behaves like a Note mutation that creates a Note
2816      should change `Note.count` by 1
2817    behaves like a Note mutation when there are active record validation errors
2818      returns an empty Note
2819      behaves like a Note mutation that does not create a Note
2820        should not change `Note.count`
2821      behaves like a mutation that returns errors in the response
2822        should eq ["Error 1", "Error 2"]
2823    
2824      behaves like a Note mutation when the given resource id is not for a Noteable
2825        behaves like a Note mutation that does not create a Note
2826          should not change `Note.count`
2827        behaves like a mutation that returns top-level errors
2828          should eq ["Cannot add notes to this resource"]
2829API::Issues
2830  GET /issues
2831    when unauthenticated
2832      returns an array of all issues
2833      returns authentication error without any scope
2834      returns authentication error when scope is assigned-to-me
2835      returns authentication error when scope is created-by-me
2836      returns an array of issues matching state in milestone
2837      returns an array of issues matching state in milestone
2838      issues_statistics
2839        returns authentication error without any scope
2840        returns authentication error when scope is assigned_to_me
2841        returns authentication error when scope is created_by_me
2842        no state is treated as all state
2843          behaves like issues statistics
2844            returns issues statistics
2845        statistics when all state is passed
2846          behaves like issues statistics
2847            returns issues statistics
2848        closed state is treated as all state
2849          behaves like issues statistics
2850            returns issues statistics
2851        opened state is treated as all state
2852          behaves like issues statistics
2853            returns issues statistics
2854        when filtering by milestone and no state treated as all state
2855          behaves like issues statistics
2856            returns issues statistics
2857        when filtering by milestone and all state
2858          behaves like issues statistics
2859            returns issues statistics
2860        when filtering by milestone and closed state treated as all state
2861          behaves like issues statistics
2862            returns issues statistics
2863        when filtering by milestone and opened state treated as all state
2864          behaves like issues statistics
2865            returns issues statistics
2866        sort does not affect statistics
2867          behaves like issues statistics
2868            returns issues statistics
2869    when authenticated
2870      returns an array of issues
2871      returns an array of closed issues
2872      returns an array of opened issues
2873      returns an array of all issues
2874      returns issues assigned to me
2875      returns issues assigned to me (kebab-case)
2876      returns issues authored by the given author id
2877      returns issues assigned to the given assignee id
2878      returns issues authored by the given author id and assigned to the given assignee id
2879      returns issues with no assignee
2880      returns issues with any assignee
2881      returns only confidential issues
2882      returns only public issues
2883      returns issues reacted by the authenticated user
2884      returns issues not reacted by the authenticated user
2885      returns issues matching given search string for title
2886      returns issues matching given search string for title and scoped in title
2887      returns an empty array if no issue matches given search string for title and scoped in description
2888      returns issues matching given search string for description
2889      returns an empty array if no issue matches milestone
2890      returns an empty array if milestone does not exist
2891      returns an array of issues in given milestone
2892      returns an array of issues in given milestone_title param
2893      returns an array of issues matching state in milestone
2894      returns an array of issues with no milestone
2895      returns an array of issues with no milestone using milestone_title param
2896      returns an array of issues found by iids
2897      returns an empty array if iid does not exist
2898      sorts ascending when requested
2899      sorts by updated_at descending when requested
2900      sorts by updated_at ascending when requested
2901      matches V4 response schema
2902      returns a related merge request count of 0 if there are no related merge requests
2903      returns a related merge request count > 0 if there are related merge requests
2904      filtering before a specific date
2905        returns issues created before a specific date
2906        returns issues updated before a specific date
2907      filtering after a specific date
2908        returns issues created after a specific date
2909        returns issues updated after a specific date
2910      filter by labels or label_name param
2911        returns an array of labeled issues
2912        returns an array of labeled issues with labels param as array
2913        returns an empty array if no issue matches labels
2914        returns an empty array if no issue matches labels with labels param as array
2915        returns an array of labeled issues matching given state
2916        returns an array of labeled issues matching given state with labels param as array
2917        returns an empty array if no issue matches labels and state filters
2918        returns an array of issues with any label
2919        returns an array of issues with any label with labels param as array
2920        returns an array of issues with no label
2921        returns an array of issues with no label with labels param as array
2922        N+1
2923          tests N+1
2924        with labeled issues
2925          behaves like labeled issues with labels and label_name params
2926            array of labeled issues when all labels match
2927              behaves like returns label names
2928                returns label names
2929            array of labeled issues when all labels match with labels param as array
2930              behaves like returns label names
2931                returns label names
2932            when with_labels_details provided
2933              array of labeled issues when all labels match
2934                behaves like returns basic label entity
2935                  returns basic label entity
2936              array of labeled issues when all labels match with labels param as array
2937                behaves like returns basic label entity
2938                  returns basic label entity
2939      without sort params
2940        sorts by created_at descending by default
2941        with 2 issues with same created_at
2942          page breaks first page correctly
2943          page breaks second page correctly
2944      issues_statistics
2945        no state is treated as all state
2946          behaves like issues statistics
2947            returns issues statistics
2948        statistics when all state is passed
2949          behaves like issues statistics
2950            returns issues statistics
2951        closed state is treated as all state
2952          behaves like issues statistics
2953            returns issues statistics
2954        opened state is treated as all state
2955          behaves like issues statistics
2956            returns issues statistics
2957        when filtering by milestone and no state treated as all state
2958          behaves like issues statistics
2959            returns issues statistics
2960        when filtering by milestone and all state
2961          behaves like issues statistics
2962            returns issues statistics
2963        when filtering by milestone and closed state treated as all state
2964          behaves like issues statistics
2965            returns issues statistics
2966        when filtering by milestone and opened state treated as all state
2967          behaves like issues statistics
2968            returns issues statistics
2969        sort does not affect statistics
2970          behaves like issues statistics
2971            returns issues statistics
2972      filtering by assignee_username
2973        returns issues with by assignee_username
2974        returns issues by assignee_username as string
2975        returns error when multiple assignees are passed
2976        returns error when assignee_username and assignee_id are passed together
2977    when returns issue merge_requests_count for different access levels
2978      behaves like accessible merge requests count
2979        returns anonymous accessible merge requests count
2980        returns guest accessible merge requests count
2981        returns reporter accessible merge requests count
2982        returns admin accessible merge requests count
2983  DELETE /projects/:id/issues/:issue_iid
2984    rejects a non member from deleting an issue
2985    rejects a developer from deleting an issue
2986    returns 404 when using the issue ID instead of IID
2987    when the user is project owner
2988      deletes the issue if an admin requests it
2989      behaves like 412 response
2990        for a modified ressource
2991          returns 412
2992        for an unmodified ressource
2993          returns accepted
2994    when issue does not exist
2995      returns 404 when trying to move an issue
2996  time tracking endpoints
2997    POST /projects/:id/issues/:issue_id/time_estimate
2998      sets the time estimate for issue
2999      with an unauthorized user
3000        behaves like an unauthorized API user
3001          should eq 403
3002      updating the current estimate
3003        when duration has a bad format
3004          does not modify the original estimate
3005        with a valid duration
3006          updates the estimate
3007    POST /projects/:id/issues/:issue_id/reset_time_estimate
3008      resets the time estimate for issue
3009      with an unauthorized user
3010        behaves like an unauthorized API user
3011          should eq 403
3012    POST /projects/:id/issues/:issue_id/add_spent_time
3013      add spent time for issue
3014      with an unauthorized user
3015        behaves like an unauthorized API user
3016          should eq 403
3017      when subtracting time
3018        subtracts time of the total spent time
3019      when time to subtract is greater than the total spent time
3020        does not modify the total time spent
3021    POST /projects/:id/issues/:issue_id/reset_spent_time
3022      resets spent time for issue
3023      with an unauthorized user
3024        behaves like an unauthorized API user
3025          should eq 403
3026    GET /projects/:id/issues/:issue_id/time_stats
3027      returns the time stats for issue
3028Boards::IssuesController
3029  GET index
3030    with invalid board id
3031      returns a not found 404 response
3032    when list id is present
3033      with valid list id
3034DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "COUNT(*), COALESCE(SUM(weight), 0)". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from metadata at /builds/gitlab-org/gitlab-ee/app/services/boards/issues/list_service.rb:16)
3035        returns issues that have the list label applied
3036DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "COUNT(*), COALESCE(SUM(weight), 0)". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from metadata at /builds/gitlab-org/gitlab-ee/app/services/boards/issues/list_service.rb:16)
3037DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "COUNT(*), COALESCE(SUM(weight), 0)". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from metadata at /builds/gitlab-org/gitlab-ee/app/services/boards/issues/list_service.rb:16)
30381st Try error in ./spec/controllers/boards/issues_controller_spec.rb:60:
3039Expected a maximum of 43 queries, got 61:
3040SELECT  1 AS one FROM "identities" WHERE "identities"."user_id" = 1057 AND (provider = 'ultraauth' AND extern_uid IS NOT NULL) LIMIT 1
3041SELECT  "users".* FROM "users" WHERE "users"."id" = 1057 ORDER BY "users"."id" ASC LIMIT 1
3042SELECT  1 AS one FROM "identities" WHERE "identities"."user_id" = 1057 AND (provider LIKE 'ldap%' AND extern_uid IS NOT NULL) LIMIT 1
3043SELECT  1 AS one FROM "identities" WHERE "identities"."user_id" = 1057 AND (provider = 'ultraauth' AND extern_uid IS NOT NULL) LIMIT 1
3044SELECT  "boards".* FROM "boards" WHERE "boards"."project_id" = 635 AND "boards"."id" = 4 LIMIT 1
3045SELECT  "lists".* FROM "lists" WHERE "lists"."board_id" = 4 AND "lists"."id" = 11 ORDER BY "lists"."list_type" ASC, "lists"."position" ASC LIMIT 1
3046SELECT  "projects".* FROM "projects" WHERE "projects"."id" = 635 LIMIT 1
3047SELECT  issues.*, (SELECT MIN("label_priorities"."priority") FROM "labels" INNER JOIN "label_links" ON "label_links"."label_id" = "labels"."id" LEFT OUTER JOIN "label_priorities" ON "labels"."id" = "label_priorities"."label_id" WHERE (label_priorities.project_id = issues.project_id) AND (label_links.target_id = issues.id) AND "label_links"."target_type" = 'Issue') AS highest_priority FROM "issues" WHERE "issues"."project_id" = 635 AND ("issues"."state" IN ('opened')) AND (EXISTS (SELECT  "label_links".* FROM "label_links" WHERE (label_links.target_type = 'Issue' AND label_links.target_id = issues.id) AND (label_links.label_id = 32) LIMIT 1)) GROUP BY "issues"."id" ORDER BY relative_position ASC NULLS LAST, highest_priority ASC NULLS LAST, id DESC LIMIT 21 OFFSET 0
3048SELECT COUNT(*), COALESCE(SUM(weight), 0) FROM "issues" WHERE "issues"."id" IN (SELECT issues.id FROM "issues" WHERE "issues"."project_id" = 635 AND ("issues"."state" IN ('opened')) AND (EXISTS (SELECT  "label_links".* FROM "label_links" WHERE (label_links.target_type = 'Issue' AND label_links.target_id = issues.id) AND (label_links.label_id = 32) LIMIT 1)))
3049SELECT  issues.*, (SELECT MIN("label_priorities"."priority") FROM "labels" INNER JOIN "label_links" ON "label_links"."label_id" = "labels"."id" LEFT OUTER JOIN "label_priorities" ON "labels"."id" = "label_priorities"."label_id" WHERE (label_priorities.project_id = issues.project_id) AND (label_links.target_id = issues.id) AND "label_links"."target_type" = 'Issue') AS highest_priority FROM "issues" WHERE "issues"."project_id" = 635 AND ("issues"."state" IN ('opened')) AND (EXISTS (SELECT  "label_links".* FROM "label_links" WHERE (label_links.target_type = 'Issue' AND label_links.target_id = issues.id) AND (label_links.label_id = 32) LIMIT 1)) GROUP BY "issues"."id" ORDER BY relative_position ASC NULLS LAST, highest_priority ASC NULLS LAST, id DESC LIMIT 21 OFFSET 0
3050SELECT "issue_assignees".* FROM "issue_assignees" WHERE "issue_assignees"."issue_id" IN (747, 746, 745, 744, 743, 742, 741, 740, 739, 738, 737, 736, 735, 734, 733, 732, 731, 730, 729, 728, 727)
3051SELECT "users".* FROM "users" WHERE "users"."id" = 1059
3052SELECT "projects".* FROM "projects" WHERE "projects"."id" = 635
3053SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."source_id" = 635
3054SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1080
3055SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Namespace' AND "routes"."source_id" = 1080
3056SELECT "label_links".* FROM "label_links" WHERE "label_links"."target_type" = 'Issue' AND "label_links"."target_id" IN (747, 746, 745, 744, 743, 742, 741, 740, 739, 738, 737, 736, 735, 734, 733, 732, 731, 730, 729, 728, 727)
3057SELECT "labels".* FROM "labels" WHERE "labels"."id" = 32 ORDER BY "labels"."title" ASC
3058SELECT "label_priorities".* FROM "label_priorities" WHERE "label_priorities"."label_id" = 32
3059SELECT "notes".* FROM "notes" WHERE "notes"."noteable_type" = 'Issue' AND "notes"."noteable_id" IN (747, 746, 745, 744, 743, 742, 741, 740, 739, 738, 737, 736, 735, 734, 733, 732, 731, 730, 729, 728, 727)
3060SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 747
3061SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 747
3062SELECT  "uploads".* FROM "uploads" WHERE "uploads"."uploader" = 'AvatarUploader' AND "uploads"."path" IN ('uploads/-/system/user/avatar/1059/dk.png', 'user/avatar/1059/dk.png') ORDER BY "uploads"."id" ASC LIMIT 1000
3063SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 746
3064SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 746
3065SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 745
3066SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 745
3067SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 744
3068SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 744
3069SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 743
3070SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 743
3071SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 742
3072SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 742
3073SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 741
3074SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 741
3075SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 740
3076SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 740
3077SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 739
3078SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 739
3079SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 738
3080SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 738
3081SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 737
3082SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 737
3083SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 736
3084SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 736
3085SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 735
3086SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 735
3087SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 734
3088SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 734
3089SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 733
3090SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 733
3091SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 732
3092SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 732
3093SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 731
3094SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 731
3095SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 730
3096SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 730
3097SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 729
3098SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 729
3099SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 728
3100SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 728
3101RSpec::Retry: 2nd try ./spec/controllers/boards/issues_controller_spec.rb:60
3102        avoids N+1 database queries
3103DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "COUNT(*), COALESCE(SUM(weight), 0)". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from metadata at /builds/gitlab-org/gitlab-ee/app/services/boards/issues/list_service.rb:16)
3104DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "COUNT(*), COALESCE(SUM(weight), 0)". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from metadata at /builds/gitlab-org/gitlab-ee/app/services/boards/issues/list_service.rb:16)
31051st Try error in ./spec/controllers/boards/issues_controller_spec.rb:71:
3106Expected a maximum of 57 queries, got 59:
3107SELECT  1 AS one FROM "identities" WHERE "identities"."user_id" = 1065 AND (provider = 'ultraauth' AND extern_uid IS NOT NULL) LIMIT 1
3108SELECT  "users".* FROM "users" WHERE "users"."id" = 1065 ORDER BY "users"."id" ASC LIMIT 1
3109SELECT  1 AS one FROM "identities" WHERE "identities"."user_id" = 1065 AND (provider LIKE 'ldap%' AND extern_uid IS NOT NULL) LIMIT 1
3110SELECT  1 AS one FROM "identities" WHERE "identities"."user_id" = 1065 AND (provider = 'ultraauth' AND extern_uid IS NOT NULL) LIMIT 1
3111SELECT  "boards".* FROM "boards" WHERE "boards"."group_id" = 1090 AND "boards"."id" = 9 LIMIT 1
3112SELECT  "lists".* FROM "lists" WHERE "lists"."board_id" = 9 AND "lists"."id" = 23 ORDER BY "lists"."list_type" ASC, "lists"."position" ASC LIMIT 1
3113SELECT  "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 1090 LIMIT 1
3114SELECT  "members".* FROM "members" LEFT OUTER JOIN "users" ON "members"."user_id" = "users"."id" WHERE "members"."type" IN ('GroupMember') AND "members"."source_type" = 'Namespace' AND "users"."state" = 'active' AND "members"."requested_at" IS NULL AND "members"."source_id" = 1090 AND "members"."user_id" = 1065 ORDER BY "members"."access_level" DESC LIMIT 1
3115SELECT  issues.*, (SELECT MIN("label_priorities"."priority") FROM "labels" INNER JOIN "label_links" ON "label_links"."label_id" = "labels"."id" LEFT OUTER JOIN "label_priorities" ON "labels"."id" = "label_priorities"."label_id" WHERE (label_priorities.project_id = issues.project_id) AND (label_links.target_id = issues.id) AND "label_links"."target_type" = 'Issue') AS highest_priority FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS (SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 1090
3116UNION
3117SELECT "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."parent_id" = "base_and_descendants"."id") SELECT "namespaces"."id" FROM "base_and_descendants" AS "namespaces") AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1065 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IS NULL OR "project_features"."issues_access_level" IN (20,30) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1065 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)))) AND ("issues"."state" IN ('opened')) AND "projects"."archived" = FALSE AND (EXISTS (SELECT  "label_links".* FROM "label_links" WHERE (label_links.target_type = 'Issue' AND label_links.target_id = issues.id) AND (label_links.label_id = 36) LIMIT 1)) GROUP BY "issues"."id" ORDER BY relative_position ASC NULLS LAST, highest_priority ASC NULLS LAST, id DESC LIMIT 21 OFFSET 0
3118SELECT  "projects".* FROM "projects" WHERE "projects"."id" = 640 LIMIT 1
3119SELECT  "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 1090 AND "namespaces"."type" = 'Group' LIMIT 1
3120SELECT  1 AS one FROM "boards" WHERE "boards"."group_id" = 1090 LIMIT 1
3121SELECT  "issues"."project_id", MAX(relative_position) AS position FROM "issues" WHERE "issues"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" = 1090) GROUP BY "issues"."project_id" ORDER BY position DESC NULLS LAST LIMIT 1
3122SAVEPOINT active_record_1
3123SELECT  "users".* FROM "users" WHERE "users"."id" = 1072 LIMIT 1
3124UPDATE "issues" SET "relative_position" = 1073742823 WHERE "issues"."id" = 777
3125SELECT  "issue_metrics".* FROM "issue_metrics" WHERE "issue_metrics"."issue_id" = 777 LIMIT 1
3126SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 777 AND "label_links"."target_type" = 'Issue' ORDER BY "labels"."title" ASC
3127SELECT "lists".* FROM "lists" WHERE "lists"."label_id" = 36
3128SELECT  "users".* FROM "users" WHERE "users"."id" = 1070 LIMIT 1
3129SELECT  "projects".* FROM "projects" WHERE "projects"."id" = 639 LIMIT 1
3130UPDATE "issues" SET "relative_position" = 1073743323 WHERE "issues"."id" = 776
3131SELECT  "issue_metrics".* FROM "issue_metrics" WHERE "issue_metrics"."issue_id" = 776 LIMIT 1
3132SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 776 AND "label_links"."target_type" = 'Issue' ORDER BY "labels"."title" ASC
3133SELECT "lists".* FROM "lists" WHERE "lists"."label_id" = 36
3134SELECT  "users".* FROM "users" WHERE "users"."id" = 1068 LIMIT 1
3135SELECT  "projects".* FROM "projects" WHERE "projects"."id" = 638 LIMIT 1
3136UPDATE "issues" SET "relative_position" = 1073743823 WHERE "issues"."id" = 775
3137SELECT  "issue_metrics".* FROM "issue_metrics" WHERE "issue_metrics"."issue_id" = 775 LIMIT 1
3138SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 775 AND "label_links"."target_type" = 'Issue' ORDER BY "labels"."title" ASC
3139SELECT "lists".* FROM "lists" WHERE "lists"."label_id" = 36
3140RELEASE SAVEPOINT active_record_1
3141SELECT  "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1090 LIMIT 1
3142SELECT  "routes".* FROM "routes" WHERE "routes"."source_id" = 1090 AND "routes"."source_type" = 'Namespace' LIMIT 1
3143SELECT  "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1090 LIMIT 1
3144SELECT  "routes".* FROM "routes" WHERE "routes"."source_id" = 1090 AND "routes"."source_type" = 'Namespace' LIMIT 1
3145SELECT  "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1090 LIMIT 1
3146SELECT  "routes".* FROM "routes" WHERE "routes"."source_id" = 1090 AND "routes"."source_type" = 'Namespace' LIMIT 1
3147SELECT COUNT(*), COALESCE(SUM(weight), 0) FROM "issues" WHERE "issues"."id" IN (SELECT issues.id FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS (SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 1090
3148UNION
3149SELECT "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."parent_id" = "base_and_descendants"."id") SELECT "namespaces"."id" FROM "base_and_descendants" AS "namespaces") AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1065 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IS NULL OR "project_features"."issues_access_level" IN (20,30) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1065 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)))) AND ("issues"."state" IN ('opened')) AND "projects"."archived" = FALSE AND (EXISTS (SELECT  "label_links".* FROM "label_links" WHERE (label_links.target_type = 'Issue' AND label_links.target_id = issues.id) AND (label_links.label_id = 36) LIMIT 1)))
3150SELECT  issues.*, (SELECT MIN("label_priorities"."priority") FROM "labels" INNER JOIN "label_links" ON "label_links"."label_id" = "labels"."id" LEFT OUTER JOIN "label_priorities" ON "labels"."id" = "label_priorities"."label_id" WHERE (label_priorities.project_id = issues.project_id) AND (label_links.target_id = issues.id) AND "label_links"."target_type" = 'Issue') AS highest_priority FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS (SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 1090
3151UNION
3152SELECT "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."parent_id" = "base_and_descendants"."id") SELECT "namespaces"."id" FROM "base_and_descendants" AS "namespaces") AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1065 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IS NULL OR "project_features"."issues_access_level" IN (20,30) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1065 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)))) AND ("issues"."state" IN ('opened')) AND "projects"."archived" = FALSE AND (EXISTS (SELECT  "label_links".* FROM "label_links" WHERE (label_links.target_type = 'Issue' AND label_links.target_id = issues.id) AND (label_links.label_id = 36) LIMIT 1)) GROUP BY "issues"."id" ORDER BY relative_position ASC NULLS LAST, highest_priority ASC NULLS LAST, id DESC LIMIT 21 OFFSET 0
3153SELECT "issue_assignees".* FROM "issue_assignees" WHERE "issue_assignees"."issue_id" IN (774, 777, 776, 775)
3154SELECT "users".* FROM "users" WHERE "users"."id" = 1073
3155SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (637, 640, 639, 638)
3156SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."source_id" IN (637, 638, 639, 640)
3157SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1090
3158SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Namespace' AND "routes"."source_id" = 1090
3159SELECT "label_links".* FROM "label_links" WHERE "label_links"."target_type" = 'Issue' AND "label_links"."target_id" IN (774, 777, 776, 775)
3160SELECT "labels".* FROM "labels" WHERE "labels"."id" = 36 ORDER BY "labels"."title" ASC
3161SELECT "label_priorities".* FROM "label_priorities" WHERE "label_priorities"."label_id" = 36
3162SELECT "notes".* FROM "notes" WHERE "notes"."noteable_type" = 'Issue' AND "notes"."noteable_id" IN (774, 777, 776, 775)
3163SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 774
3164SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 774
3165SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 777
3166SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 777
3167SELECT  "uploads".* FROM "uploads" WHERE "uploads"."uploader" = 'AvatarUploader' AND "uploads"."path" IN ('uploads/-/system/user/avatar/1073/dk.png', 'user/avatar/1073/dk.png') ORDER BY "uploads"."id" ASC LIMIT 1000
3168SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 776
3169SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 776
3170SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 775
3171SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 775
3172RSpec::Retry: 2nd try ./spec/controllers/boards/issues_controller_spec.rb:71
3173        avoids N+1 database queries when adding a project
3174DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "COUNT(*), COALESCE(SUM(weight), 0)". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from metadata at /builds/gitlab-org/gitlab-ee/app/services/boards/issues/list_service.rb:16)
3175DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "COUNT(*), COALESCE(SUM(weight), 0)". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from metadata at /builds/gitlab-org/gitlab-ee/app/services/boards/issues/list_service.rb:16)
31761st Try error in ./spec/controllers/boards/issues_controller_spec.rb:88:
3177Expected a maximum of 57 queries, got 59:
3178SELECT  1 AS one FROM "identities" WHERE "identities"."user_id" = 1085 AND (provider = 'ultraauth' AND extern_uid IS NOT NULL) LIMIT 1
3179SELECT  "users".* FROM "users" WHERE "users"."id" = 1085 ORDER BY "users"."id" ASC LIMIT 1
3180SELECT  1 AS one FROM "identities" WHERE "identities"."user_id" = 1085 AND (provider LIKE 'ldap%' AND extern_uid IS NOT NULL) LIMIT 1
3181SELECT  1 AS one FROM "identities" WHERE "identities"."user_id" = 1085 AND (provider = 'ultraauth' AND extern_uid IS NOT NULL) LIMIT 1
3182SELECT  "boards".* FROM "boards" WHERE "boards"."group_id" = 1112 AND "boards"."id" = 13 LIMIT 1
3183SELECT  "lists".* FROM "lists" WHERE "lists"."board_id" = 13 AND "lists"."id" = 33 ORDER BY "lists"."list_type" ASC, "lists"."position" ASC LIMIT 1
3184SELECT  "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 1112 LIMIT 1
3185SELECT  "members".* FROM "members" LEFT OUTER JOIN "users" ON "members"."user_id" = "users"."id" WHERE "members"."type" IN ('GroupMember') AND "members"."source_type" = 'Namespace' AND "users"."state" = 'active' AND "members"."requested_at" IS NULL AND "members"."source_id" = 1112 AND "members"."user_id" = 1085 ORDER BY "members"."access_level" DESC LIMIT 1
3186SELECT  issues.*, (SELECT MIN("label_priorities"."priority") FROM "labels" INNER JOIN "label_links" ON "label_links"."label_id" = "labels"."id" LEFT OUTER JOIN "label_priorities" ON "labels"."id" = "label_priorities"."label_id" WHERE (label_priorities.project_id = issues.project_id) AND (label_links.target_id = issues.id) AND "label_links"."target_type" = 'Issue') AS highest_priority FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS (SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 1112
3187UNION
3188SELECT "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."parent_id" = "base_and_descendants"."id") SELECT "namespaces"."id" FROM "base_and_descendants" AS "namespaces") AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1085 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IS NULL OR "project_features"."issues_access_level" IN (20,30) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1085 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)))) AND ("issues"."state" IN ('opened')) AND "projects"."archived" = FALSE AND (EXISTS (SELECT  "label_links".* FROM "label_links" WHERE (label_links.target_type = 'Issue' AND label_links.target_id = issues.id) AND (label_links.label_id = 40) LIMIT 1)) GROUP BY "issues"."id" ORDER BY relative_position ASC NULLS LAST, highest_priority ASC NULLS LAST, id DESC LIMIT 21 OFFSET 0
3189SELECT  "projects".* FROM "projects" WHERE "projects"."id" = 647 LIMIT 1
3190SELECT  "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 1112 AND "namespaces"."type" = 'Group' LIMIT 1
3191SELECT  1 AS one FROM "boards" WHERE "boards"."group_id" = 1112 LIMIT 1
3192SELECT  "issues"."project_id", MAX(relative_position) AS position FROM "issues" WHERE "issues"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" = 1112) GROUP BY "issues"."project_id" ORDER BY position DESC NULLS LAST LIMIT 1
3193SAVEPOINT active_record_1
3194SELECT  "users".* FROM "users" WHERE "users"."id" = 1090 LIMIT 1
3195UPDATE "issues" SET "relative_position" = 1073742823 WHERE "issues"."id" = 785
3196SELECT  "issue_metrics".* FROM "issue_metrics" WHERE "issue_metrics"."issue_id" = 785 LIMIT 1
3197SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 785 AND "label_links"."target_type" = 'Issue' ORDER BY "labels"."title" ASC
3198SELECT "lists".* FROM "lists" WHERE "lists"."label_id" = 40
3199SELECT  "users".* FROM "users" WHERE "users"."id" = 1094 LIMIT 1
3200SELECT  "projects".* FROM "projects" WHERE "projects"."id" = 649 LIMIT 1
3201UPDATE "issues" SET "relative_position" = 1073743323 WHERE "issues"."id" = 784
3202SELECT  "issue_metrics".* FROM "issue_metrics" WHERE "issue_metrics"."issue_id" = 784 LIMIT 1
3203SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 784 AND "label_links"."target_type" = 'Issue' ORDER BY "labels"."title" ASC
3204SELECT "lists".* FROM "lists" WHERE "lists"."label_id" = 40
3205SELECT  "users".* FROM "users" WHERE "users"."id" = 1092 LIMIT 1
3206SELECT  "projects".* FROM "projects" WHERE "projects"."id" = 648 LIMIT 1
3207UPDATE "issues" SET "relative_position" = 1073743823 WHERE "issues"."id" = 783
3208SELECT  "issue_metrics".* FROM "issue_metrics" WHERE "issue_metrics"."issue_id" = 783 LIMIT 1
3209SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 783 AND "label_links"."target_type" = 'Issue' ORDER BY "labels"."title" ASC
3210SELECT "lists".* FROM "lists" WHERE "lists"."label_id" = 40
3211RELEASE SAVEPOINT active_record_1
3212SELECT  "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1112 LIMIT 1
3213SELECT  "routes".* FROM "routes" WHERE "routes"."source_id" = 1112 AND "routes"."source_type" = 'Namespace' LIMIT 1
3214SELECT  "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1113 LIMIT 1
3215SELECT  "routes".* FROM "routes" WHERE "routes"."source_id" = 1113 AND "routes"."source_type" = 'Namespace' LIMIT 1
3216SELECT  "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1113 LIMIT 1
3217SELECT  "routes".* FROM "routes" WHERE "routes"."source_id" = 1113 AND "routes"."source_type" = 'Namespace' LIMIT 1
3218SELECT COUNT(*), COALESCE(SUM(weight), 0) FROM "issues" WHERE "issues"."id" IN (SELECT issues.id FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS (SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 1112
3219UNION
3220SELECT "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."parent_id" = "base_and_descendants"."id") SELECT "namespaces"."id" FROM "base_and_descendants" AS "namespaces") AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1085 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IS NULL OR "project_features"."issues_access_level" IN (20,30) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1085 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)))) AND ("issues"."state" IN ('opened')) AND "projects"."archived" = FALSE AND (EXISTS (SELECT  "label_links".* FROM "label_links" WHERE (label_links.target_type = 'Issue' AND label_links.target_id = issues.id) AND (label_links.label_id = 40) LIMIT 1)))
3221SELECT  issues.*, (SELECT MIN("label_priorities"."priority") FROM "labels" INNER JOIN "label_links" ON "label_links"."label_id" = "labels"."id" LEFT OUTER JOIN "label_priorities" ON "labels"."id" = "label_priorities"."label_id" WHERE (label_priorities.project_id = issues.project_id) AND (label_links.target_id = issues.id) AND "label_links"."target_type" = 'Issue') AS highest_priority FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS (SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 1112
3222UNION
3223SELECT "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."parent_id" = "base_and_descendants"."id") SELECT "namespaces"."id" FROM "base_and_descendants" AS "namespaces") AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1085 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IS NULL OR "project_features"."issues_access_level" IN (20,30) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1085 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)))) AND ("issues"."state" IN ('opened')) AND "projects"."archived" = FALSE AND (EXISTS (SELECT  "label_links".* FROM "label_links" WHERE (label_links.target_type = 'Issue' AND label_links.target_id = issues.id) AND (label_links.label_id = 40) LIMIT 1)) GROUP BY "issues"."id" ORDER BY relative_position ASC NULLS LAST, highest_priority ASC NULLS LAST, id DESC LIMIT 21 OFFSET 0
3224SELECT "issue_assignees".* FROM "issue_assignees" WHERE "issue_assignees"."issue_id" IN (782, 785, 784, 783)
3225SELECT "users".* FROM "users" WHERE "users"."id" = 1095
3226SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (645, 647, 649, 648)
3227SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."source_id" IN (645, 647, 648, 649)
3228SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" IN (1112, 1113)
3229SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Namespace' AND "routes"."source_id" IN (1112, 1113)
3230SELECT "label_links".* FROM "label_links" WHERE "label_links"."target_type" = 'Issue' AND "label_links"."target_id" IN (782, 785, 784, 783)
3231SELECT "labels".* FROM "labels" WHERE "labels"."id" = 40 ORDER BY "labels"."title" ASC
3232SELECT "label_priorities".* FROM "label_priorities" WHERE "label_priorities"."label_id" = 40
3233SELECT "notes".* FROM "notes" WHERE "notes"."noteable_type" = 'Issue' AND "notes"."noteable_id" IN (782, 785, 784, 783)
3234SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 782
3235SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 782
3236SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 785
3237SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 785
3238SELECT  "uploads".* FROM "uploads" WHERE "uploads"."uploader" = 'AvatarUploader' AND "uploads"."path" IN ('uploads/-/system/user/avatar/1095/dk.png', 'user/avatar/1095/dk.png') ORDER BY "uploads"."id" ASC LIMIT 1000
3239SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 784
3240SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 784
3241SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 783
3242SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 783
3243RSpec::Retry: 2nd try ./spec/controllers/boards/issues_controller_spec.rb:88
3244        avoids N+1 database queries when adding a subgroup, project, and issue
3245      with invalid list id
3246        returns a not found 404 response
3247    when list id is missing
3248DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "COUNT(*), COALESCE(SUM(weight), 0)". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from metadata at /builds/gitlab-org/gitlab-ee/app/services/boards/issues/list_service.rb:16)
3249      returns opened issues without board labels applied
3250    with unauthorized user
3251      returns a forbidden 403 response
3252    with external authorization
3253      returns a 403 for group boards
3254DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "COUNT(*), COALESCE(SUM(weight), 0)". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from metadata at /builds/gitlab-org/gitlab-ee/app/services/boards/issues/list_service.rb:16)
3255      is successful for project boards
3256    PUT bulk_move
3257      when items are moved to another list
3258        behaves like move issues endpoint provider
3259          responds as expected
3260DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "COUNT(*), COALESCE(SUM(weight), 0)". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from metadata at /builds/gitlab-org/gitlab-ee/app/services/boards/issues/list_service.rb:16)
3261          moves issues as expected
3262      when moving just one issue
3263        behaves like move issues endpoint provider
3264          responds as expected
3265DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "COUNT(*), COALESCE(SUM(weight), 0)". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from metadata at /builds/gitlab-org/gitlab-ee/app/services/boards/issues/list_service.rb:16)
3266          moves issues as expected
3267      when user is not allowed to move issue
3268        behaves like move issues endpoint provider
3269          responds as expected
3270DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "COUNT(*), COALESCE(SUM(weight), 0)". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from metadata at /builds/gitlab-org/gitlab-ee/app/services/boards/issues/list_service.rb:16)
3271          moves issues as expected
3272      when issues should be moved visually above existing issue in list
3273        behaves like move issues endpoint provider
3274          responds as expected
3275DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "COUNT(*), COALESCE(SUM(weight), 0)". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from metadata at /builds/gitlab-org/gitlab-ee/app/services/boards/issues/list_service.rb:16)
3276          moves issues as expected
3277      when destination list is empty
3278        behaves like move issues endpoint provider
3279          responds as expected
3280DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "COUNT(*), COALESCE(SUM(weight), 0)". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from metadata at /builds/gitlab-org/gitlab-ee/app/services/boards/issues/list_service.rb:16)
3281          moves issues as expected
3282      when no position arguments are given
3283        behaves like move issues endpoint provider
3284          responds as expected
3285DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "COUNT(*), COALESCE(SUM(weight), 0)". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from metadata at /builds/gitlab-org/gitlab-ee/app/services/boards/issues/list_service.rb:16)
3286          moves issues as expected
3287      when move_before_id and move_after_id are given
3288        behaves like move issues endpoint provider
3289          responds as expected
3290DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "COUNT(*), COALESCE(SUM(weight), 0)". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from metadata at /builds/gitlab-org/gitlab-ee/app/services/boards/issues/list_service.rb:16)
3291          moves issues as expected
3292      when request contains too many issues
3293        behaves like move issues endpoint provider
3294          responds as expected
3295DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "COUNT(*), COALESCE(SUM(weight), 0)". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from metadata at /builds/gitlab-org/gitlab-ee/app/services/boards/issues/list_service.rb:16)
3296          moves issues as expected
3297      when request is malformed
3298        behaves like move issues endpoint provider
3299          responds as expected
3300DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "COUNT(*), COALESCE(SUM(weight), 0)". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from metadata at /builds/gitlab-org/gitlab-ee/app/services/boards/issues/list_service.rb:16)
3301          moves issues as expected
3302  POST create
3303    with valid params
3304      returns a successful 200 response
3305      returns the created issue
3306    with invalid params
3307      when title is nil
3308        returns an unprocessable entity 422 response
3309      when list does not belongs to project board
3310        returns a not found 404 response
3311      with invalid board id
3312        returns a not found 404 response
3313      with invalid list id
3314        returns a not found 404 response
3315    with guest user
3316      in open list
3317        returns a successful 200 response
3318      in label list
3319        returns a forbidden 403 response
3320  PATCH update
3321    with valid params
3322      returns a successful 200 response
3323      moves issue to the desired list
3324    with invalid params
3325      returns a unprocessable entity 422 response for invalid lists
3326      returns a not found 404 response for invalid board id
3327      returns a not found 404 response for invalid issue id
3328    with unauthorized user
3329      returns a forbidden 403 response
3330Update of user activity
3331  without an authenticated user
3332    does not set the last activity cookie
3333  with an authenticated user
3334    with a POST request
3335      does not set the last activity cookie
3336    on GET to /group
3337      updates the last activity date
3338      when calling it twice
3339        updates last_activity_on just once
3340      when last_activity_on is nil
3341        updates the last activity date
3342      when last_activity_on is stale
3343        updates the last activity date
3344      when last_activity_on is up to date
3345        does not try to update it
3346    on GET to /group/project
3347      updates the last activity date
3348      when calling it twice
3349        updates last_activity_on just once
3350      when last_activity_on is nil
3351        updates the last activity date
3352      when last_activity_on is stale
3353        updates the last activity date
3354      when last_activity_on is up to date
3355        does not try to update it
3356    on GET to /groups/group/-/issues
3357      updates the last activity date
3358      when calling it twice
3359        updates last_activity_on just once
3360      when last_activity_on is nil
3361        updates the last activity date
3362      when last_activity_on is stale
3363        updates the last activity date
3364      when last_activity_on is up to date
3365        does not try to update it
3366    on GET to /groups/group/-/boards
3367DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "LOWER(name) ASC". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from boards at /builds/gitlab-org/gitlab-ee/ee/app/services/ee/boards/list_service.rb:28)
3368DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "LOWER(name) ASC". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from boards at /builds/gitlab-org/gitlab-ee/ee/app/services/ee/boards/list_service.rb:28)
3369      updates the last activity date
3370      when calling it twice
3371DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "LOWER(name) ASC". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from boards at /builds/gitlab-org/gitlab-ee/ee/app/services/ee/boards/list_service.rb:28)
3372DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "LOWER(name) ASC". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from boards at /builds/gitlab-org/gitlab-ee/ee/app/services/ee/boards/list_service.rb:28)
3373DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "LOWER(name) ASC". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from boards at /builds/gitlab-org/gitlab-ee/ee/app/services/ee/boards/list_service.rb:28)
3374DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "LOWER(name) ASC". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from boards at /builds/gitlab-org/gitlab-ee/ee/app/services/ee/boards/list_service.rb:28)
3375        updates last_activity_on just once
3376      when last_activity_on is nil
3377DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "LOWER(name) ASC". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from boards at /builds/gitlab-org/gitlab-ee/ee/app/services/ee/boards/list_service.rb:28)
3378DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "LOWER(name) ASC". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from boards at /builds/gitlab-org/gitlab-ee/ee/app/services/ee/boards/list_service.rb:28)
3379        updates the last activity date
3380      when last_activity_on is stale
3381DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "LOWER(name) ASC". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from boards at /builds/gitlab-org/gitlab-ee/ee/app/services/ee/boards/list_service.rb:28)
3382DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "LOWER(name) ASC". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from boards at /builds/gitlab-org/gitlab-ee/ee/app/services/ee/boards/list_service.rb:28)
3383        updates the last activity date
3384      when last_activity_on is up to date
3385DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "LOWER(name) ASC". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from boards at /builds/gitlab-org/gitlab-ee/ee/app/services/ee/boards/list_service.rb:28)
3386DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "LOWER(name) ASC". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from boards at /builds/gitlab-org/gitlab-ee/ee/app/services/ee/boards/list_service.rb:28)
3387        does not try to update it
3388    on GET to /dashboard/projects
3389      updates the last activity date
3390      when calling it twice
3391        updates last_activity_on just once
3392      when last_activity_on is nil
3393        updates the last activity date
3394      when last_activity_on is stale
3395        updates the last activity date
3396      when last_activity_on is up to date
3397        does not try to update it
3398    on GET to /dashboard/snippets
3399      updates the last activity date
3400      when calling it twice
3401        updates last_activity_on just once
3402      when last_activity_on is nil
3403        updates the last activity date
3404      when last_activity_on is stale
3405        updates the last activity date
3406      when last_activity_on is up to date
3407        does not try to update it
3408    on GET to /dashboard/groups
3409      updates the last activity date
3410      when calling it twice
3411        updates last_activity_on just once
3412      when last_activity_on is nil
3413        updates the last activity date
3414      when last_activity_on is stale
3415        updates the last activity date
3416      when last_activity_on is up to date
3417        does not try to update it
3418    on GET to /dashboard/todos
3419      updates the last activity date
3420      when calling it twice
3421        updates last_activity_on just once
3422      when last_activity_on is nil
3423        updates the last activity date
3424      when last_activity_on is stale
3425        updates the last activity date
3426      when last_activity_on is up to date
3427        does not try to update it
3428    on GET to /group/project/issues
3429      updates the last activity date
3430      when calling it twice
3431        updates last_activity_on just once
3432      when last_activity_on is nil
3433        updates the last activity date
3434      when last_activity_on is stale
3435        updates the last activity date
3436      when last_activity_on is up to date
3437        does not try to update it
3438    on GET to /group/project/issues/10
3439      updates the last activity date
3440      when calling it twice
3441        updates last_activity_on just once
3442      when last_activity_on is nil
3443        updates the last activity date
3444      when last_activity_on is stale
3445        updates the last activity date
3446      when last_activity_on is up to date
3447        does not try to update it
3448    on GET to /group/project/merge_requests
3449      updates the last activity date
3450      when calling it twice
3451        updates last_activity_on just once
3452      when last_activity_on is nil
3453        updates the last activity date
3454      when last_activity_on is stale
3455        updates the last activity date
3456      when last_activity_on is up to date
3457        does not try to update it
3458    on GET to /group/project/merge_requests/15
3459      updates the last activity date
3460      when calling it twice
3461        updates last_activity_on just once
3462      when last_activity_on is nil
3463        updates the last activity date
3464      when last_activity_on is stale
3465        updates the last activity date
3466      when last_activity_on is up to date
3467        does not try to update it
3468Projects::BranchesController
3469  POST create with HTML format
3470    on creation of a new branch
3471      valid branch name, valid source
3472        redirects
3473      invalid branch name, valid ref
3474        redirects
3475      valid branch name, invalid ref
3476        should render template new
3477      invalid branch name, invalid ref
3478        should render template new
3479      valid branch name with encoded slashes
3480        should render template new
3481        example at ./spec/controllers/projects/branches_controller_spec.rb:69
3482    created from the new branch button on issues
3483      redirects
3484      posts a system note
3485      confidential_issue_project_id is present
3486        create_confidential_merge_request feature is enabled
3487          user cannot update issue
3488            does not post a system note
3489          user can update issue
3490            issue is under the specified project
3491              posts a system note
3492            issue is not under the specified project
3493              does not post a system note
3494        create_confidential_merge_request feature is disabled
3495          posts a system note on project
3496      repository-less project
3497        redirects to newly created branch
3498        redirects to autodeploy setup page
3499        when user configured kubernetes from CI/CD > Clusters
3500          redirects to autodeploy setup page
3501      when create branch service fails
3502        doesn't post a system note
3503      without issue feature access
3504        doesn't post a system note
3505  POST create with JSON format
3506    with valid params
3507      returns a successful 200 response
3508      returns the created branch
3509    with invalid params
3510      returns an unprocessable entity 422 response
3511  POST destroy with HTML format
3512    returns 303
3513  POST destroy
3514    as JS
3515      valid branch name, valid source
3516        should respond with numeric status code 200
3517        should be blank
3518      valid branch name with unencoded slashes
3519        should respond with numeric status code 200
3520        should be blank
3521      valid branch name with encoded slashes
3522        should respond with numeric status code 200
3523        should be blank
3524      invalid branch name, valid ref
3525        should respond with numeric status code 404
3526        should be blank
3527    as JSON
3528      valid branch name, valid source
3529        returns JSON response with message
3530        should respond with numeric status code 200
3531      valid branch name with unencoded slashes
3532        returns JSON response with message
3533        should respond with numeric status code 200
3534      valid branch name with encoded slashes
3535        returns JSON response with message
3536        should respond with numeric status code 200
3537      invalid branch name, valid ref
3538        returns JSON response with message
3539        should respond with numeric status code 404
3540    as HTML
3541      redirects to branches path
3542  DELETE destroy_all_merged
3543    when user is allowed to push
3544      redirects to branches
3545      starts worker to delete merged branches
3546    when user is not allowed to push
3547      responds with status 404
3548  GET index
3549    when rendering a JSON format
3550      filters branches by name
3551    when cache is enabled yet cold
3552      return with a status 200
3553    when branch contains an invalid UTF-8 sequence
3554      return with a status 200
3555    when deprecated sort/search/page parameters are specified
3556      returns with a status 301 when sort specified
3557      returns with a status 301 when search specified
3558      returns with a status 301 when page specified
3559  GET diverging_commit_counts
3560    returns the commit counts behind and ahead of default branch
3561Destroying a Note
3562  when the user does not have permission
3563    does not destroy the Note
3564    behaves like a mutation that returns top-level errors
3565      should eq ["The resource that you are attempting to access does not exist or you don't have permission to perform this action"]
3566  when the user has permission
3567    destroys the Note
3568    returns an empty Note
3569    behaves like a Note mutation when the given resource id is not for a Note
3570      behaves like a mutation that returns top-level errors
3571        should eq ["Resource is not a note"]
3572API::GroupClusters
3573  GET /groups/:id/clusters
3574    non-authorized user
3575      responds with 403
3576    authorized user
3577      responds with 200
3578      includes pagination headers
3579      only include authorized clusters
3580  GET /groups/:id/clusters/:cluster_id
3581    non-authorized user
3582      responds with 403
3583    authorized user
3584      returns specific cluster
3585      returns cluster information
3586      returns group information
3587      returns kubernetes platform information
3588      returns user information
3589      returns GCP provider information
3590      when cluster has no provider
3591        does not include GCP provider info
3592      with non-existing cluster
3593        returns 404
3594  POST /groups/:id/clusters/user
3595    non-authorized user
3596      responds with 403
3597    authorized user
3598      with valid params
3599        responds with 201
3600        creates a new Cluster::Cluster
3601      when user does not indicate authorization type
3602        defaults to RBAC
3603      when user sets authorization type as ABAC
3604        creates an ABAC cluster
3605      with invalid params
3606        responds with 400
3607        does not create a new Clusters::Cluster
3608        returns validation errors
3609    when user tries to add multiple clusters
3610      responds with 400
3611    non-authorized user
3612      responds with 403
3613  PUT /groups/:id/clusters/:cluster_id
3614    non-authorized user
3615      responds with 403
3616    authorized user
3617      with valid params
3618        responds with 200
3619        updates cluster attributes
3620      with invalid params
3621        responds with 400
3622        does not update cluster attributes
3623        returns validation errors
3624      with a GCP cluster
3625        when user tries to change GCP specific fields
3626          responds with 400
3627          returns validation error
3628        when user tries to change domain
3629          responds with 200
3630      with an user cluster
3631        responds with 200
3632        updates platform kubernetes attributes
3633      with a cluster that does not belong to user
3634        responds with 404
3635  DELETE /groups/:id/clusters/:cluster_id
3636    non-authorized user
3637      responds with 403
3638    authorized user
3639      responds with 204
3640      deletes the cluster
3641      with a cluster that does not belong to user
3642        responds with 404
3643API::Deployments
3644  GET /projects/:id/deployments
3645    as member of the project
3646      returns projects deployments sorted by id asc
3647      ordering
3648        order_by: "created_at", sort: "asc", ordered_deployments: [:deployment_3, :deployment_2, :deployment_1]
3649          returns the deployments ordered
3650        order_by: "created_at", sort: "desc", ordered_deployments: [:deployment_1, :deployment_2, :deployment_3]
3651          returns the deployments ordered
3652        order_by: "id", sort: "asc", ordered_deployments: [:deployment_1, :deployment_2, :deployment_3]
3653          returns the deployments ordered
3654        order_by: "id", sort: "desc", ordered_deployments: [:deployment_3, :deployment_2, :deployment_1]
3655          returns the deployments ordered
3656        order_by: "iid", sort: "asc", ordered_deployments: [:deployment_3, :deployment_1, :deployment_2]
3657          returns the deployments ordered
3658        order_by: "iid", sort: "desc", ordered_deployments: [:deployment_2, :deployment_1, :deployment_3]
3659          returns the deployments ordered
3660        order_by: "ref", sort: "asc", ordered_deployments: [:deployment_2, :deployment_1, :deployment_3]
3661          returns the deployments ordered
3662        order_by: "ref", sort: "desc", ordered_deployments: [:deployment_3, :deployment_1, :deployment_2]
3663          returns the deployments ordered
3664    as non member
3665      returns a 404 status code
3666  GET /projects/:id/deployments/:deployment_id
3667    as a member of the project
3668      returns the projects deployment
3669    as non member
3670      returns a 404 status code
3671Projects::SnippetsController
3672  GET #index
3673    when page param
3674      redirects to last_page if page number is larger than number of pages
3675      redirects to specified page
3676    when the project snippet is private
3677      when anonymous
3678        does not include the private snippet
3679      when signed in as the author
3680        renders the snippet
3681      when signed in as a project member
3682        renders the snippet
3683  POST #create
3684    creates the snippet correctly
3685    when the snippet is spam
3686      when the snippet is private
3687        creates the snippet
3688      when the snippet is public
3689        rejects the shippet
3690        creates a spam log
3691        renders :new with recaptcha disabled
3692        recaptcha enabled
3693          renders :verify with recaptcha enabled
3694          renders snippet page when recaptcha verified
3695  PUT #update
3696    when the snippet is spam
3697      when the snippet is private
3698        updates the snippet
3699      when the snippet is public
3700        rejects the shippet
3701        creates a spam log
3702        renders :edit with recaptcha disabled
3703        recaptcha enabled
3704          renders :verify with recaptcha enabled
3705          renders snippet page when recaptcha verified
3706      when the private snippet is made public
3707        rejects the shippet
3708        creates a spam log
3709        renders :edit with recaptcha disabled
3710        recaptcha enabled
3711          renders :verify with recaptcha enabled
3712          renders snippet page when recaptcha verified
3713  POST #mark_as_spam
3714    updates the snippet
3715  GET #show
3716    when the project snippet is private
3717      when anonymous
3718        responds with status 404
3719      when signed in as the author
3720        renders the snippet
3721      when signed in as a project member
3722        renders the snippet
3723    when the project snippet does not exist
3724      when anonymous
3725        responds with status 404
3726      when signed in
3727        responds with status 404
3728  GET #raw
3729    when the project snippet is private
3730      when anonymous
3731        responds with status 404
3732      when signed in as the author
3733        renders the snippet
3734      when signed in as a project member
3735        renders the snippet
3736    when the project snippet does not exist
3737      when anonymous
3738        responds with status 404
3739      when signed in
3740        responds with status 404
3741  GET #show for embeddable content
3742    when snippet is private
3743      responds with status 404
3744    when snippet is public
3745      responds with status 200
3746    when the project is private
3747      when snippet is public
3748        responds with status 404
3749  GET #raw
3750    CRLF line ending
3751      returns LF line endings by default
3752      does not convert line endings when parameter present
3753Projects::MergeRequests::ConflictsController
3754  GET show
3755    when the conflicts cannot be resolved in the UI
3756      returns a 200 status code
3757      returns JSON with a message
3758    with valid conflicts
3759      matches the schema
3760      includes meta info about the MR
3761      includes each file that has conflicts
3762      splits files into sections with lines
3763      has unique section IDs across files
3764  GET conflict_for_path
3765    when the conflicts cannot be resolved in the UI
3766      returns a 404 status code
3767    when the file does not exist cannot be resolved in the UI
3768      returns a 404 status code
3769    with an existing file
3770      returns a 200 status code
3771      returns the file in JSON format
3772  POST resolve_conflicts
3773    with valid params
3774      creates a new commit on the branch
3775      returns an OK response
3776    when sections are missing
3777      returns a 400 error
3778      has a message with the name of the first missing section
3779      does not create a new commit
3780    when files are missing
3781      returns a 400 error
3782      has a message with the name of the missing file
3783      does not create a new commit
3784    when a file has identical content to the conflict
3785      returns a 400 error
3786      has a message with the path of the problem file
3787      does not create a new commit
3788Groups::ChildrenController
3789  GET #index
3790    for projects
3791      as a user
3792        shows all children
3793        being member of private subgroup
3794          shows public and private children the user is member of
3795      as a guest
3796        shows the public children
3797    for subgroups
3798      as a user
3799        shows all children
3800        being member of private subgroup
3801          shows public and private children the user is member of
3802      as a guest
3803        shows the public children
3804      filtering children
3805        expands the tree for matching projects
3806        expands the tree for matching subgroups
3807        merges the trees correctly
3808        expands the tree upto a specified parent
3809        returns an array with one element when only one result is matched
3810        returns an empty array when there are no search results
3811        succeeds if multiple pages contain matching subgroups
3812        includes pagination headers
3813      queries per rendered element
3814        queries the expected amount for a group row
3815        queries the expected amount for a project row
3816        when rendering hierarchies
3817          queries the expected amount when nested rows are increased for a group
3818          queries the expected amount when a new group match is added
3819          queries the expected amount when nested rows are increased for a project
3820    pagination
3821      with only projects
3822        has projects on the first page
3823        has projects on the second page
3824      with subgroups and projects
3825        contains all subgroups
3826        contains the project and group on the second page
3827        with a mixed first page
3828          correctly calculates the counts
3829    external authorization
3830      works when external authorization service is enabled
3831API::Issues
3832  PUT /projects/:id/issues/:issue_iid to update only title
3833    updates a project issue
3834    returns 404 error if issue iid not found
3835    returns 404 error if issue id is used instead of the iid
3836    allows special label names
3837    allows special label names with labels param as array
3838    confidential issues
3839      returns 403 for non project members
3840      returns 403 for project members with guest role
3841      updates a confidential issue for project members
3842      updates a confidential issue for author
3843      updates a confidential issue for admin
3844      sets an issue to confidential
3845      makes a confidential issue public
3846      does not update a confidential issue with wrong confidential flag
3847  PUT /projects/:id/issues/:issue_iid with spam filtering
3848    does not create a new project issue
3849  PUT /projects/:id/issues/:issue_iid to update assignee
3850    removes assignee
3851    updates an issue with new assignee
3852    support for deprecated assignee_id
3853      removes assignee
3854      updates an issue with new assignee
3855    single assignee restrictions
3856      updates an issue with several assignees but only one has been applied
3857  PUT /projects/:id/issues/:issue_iid to update labels
3858    does not update labels if not present
3859    removes all labels and touches the record
3860    removes all labels and touches the record with labels param as array
3861    updates labels and touches the record
3862    updates labels and touches the record with labels param as array
3863    allows special label names
3864    allows special label names with labels param as array
3865    returns 400 if title is too long
3866  PUT /projects/:id/issues/:issue_iid to update state and label
3867    updates a project issue
3868    reopens a project isssue
3869    when an admin or owner makes the request
3870      accepts the update date to be set
3871  PUT /projects/:id/issues/:issue_iid to update due date
3872    creates a new project issue
3873Boards::ListsController
3874  GET index
3875    returns a successful 200 response
3876    returns a list of board lists
3877    with unauthorized user
3878      returns a forbidden 403 response
3879  POST create
3880    with valid params
3881      returns a successful 200 response
3882      returns the created list
3883    with invalid params
3884      when label is nil
3885        returns a not found 404 response
3886      when label that does not belongs to project
3887        returns a not found 404 response
3888    with unauthorized user
3889      returns a forbidden 403 response
3890  PATCH update
3891    with valid position
3892      returns a successful 200 response
3893      moves the list to the desired position
3894    with invalid position
3895      returns an unprocessable entity 422 response
3896    with invalid list id
3897      returns a not found 404 response
3898    with unauthorized user
3899      returns a forbidden 403 response
3900  DELETE destroy
3901    with valid list id
3902      returns a successful 200 response
3903      removes list from board
3904    with invalid list id
3905      returns a not found 404 response
3906    with unauthorized user
3907      returns a forbidden 403 response
3908  POST generate
3909    when board lists is empty
3910      returns a successful 200 response
3911      returns the defaults lists
3912    when board lists is not empty
3913      returns an unprocessable entity 422 response
3914    with unauthorized user
3915      returns a forbidden 403 response
3916Projects::CompareController
3917  GET index
3918    returns successfully
3919  GET show
3920    when the refs exist
3921      when we set the white space param
3922        shows some diffs with ignore whitespace change option
3923      when we do not set the white space param
3924        sets the diffs and commits ivars
3925    when the source ref does not exist
3926      sets empty diff and commit ivars
3927    when the target ref does not exist
3928      sets empty diff and commit ivars
3929    when the target ref is invalid
3930      shows a flash message and redirects
3931    when the source ref is invalid
3932      shows a flash message and redirects
3933  GET diff_for_path
3934    when the source and target refs exist
3935      when the user has access target the project
3936        when the path exists in the diff
3937          disables diff notes
3938          only renders the diffs for the path given
3939        when the path does not exist in the diff
3940          returns a 404
3941      when the user does not have access target the project
3942        returns a 404
3943    when the source ref does not exist
3944      returns a 404
3945    when the target ref does not exist
3946      returns a 404
3947  POST create
3948    when sending valid params
3949      redirects back to show
3950    when sending invalid params
3951      when the source ref is empty and target ref is set
3952        redirects back to index and preserves the target ref
3953      when the target ref is empty and source ref is set
3954        redirects back to index and preserves source ref
3955      when the target and source ref are empty
3956        redirects back to index
3957  GET signatures
3958    when the source and target refs exist
3959      when the user has access to the project
3960        returns only the commit with a signature
3961      when the user does not have access to the project
3962        returns a 404
3963    when the source ref does not exist
3964      returns no signatures
3965    when the target ref does not exist
3966      returns no signatures
3967API::AwardEmoji
3968  GET /projects/:id/awardable/:awardable_id/award_emoji
3969    on an issue
3970      returns an array of award_emoji
3971      returns a 404 error when issue id not found
3972    on a merge request
3973      returns an array of award_emoji
3974    on a snippet
3975      returns the awarded emoji
3976    when the user has no access
3977      returns a status code 404
3978  GET /projects/:id/awardable/:awardable_id/notes/:note_id/award_emoji
3979    returns an array of award emoji
3980  GET /projects/:id/awardable/:awardable_id/award_emoji/:award_id
3981    on an issue
3982      returns the award emoji
3983      returns a 404 error if the award is not found
3984    on a merge request
3985      returns the award emoji
3986    on a snippet
3987      returns the awarded emoji
3988    when the user has no access
3989      returns a status code 404
3990  GET /projects/:id/awardable/:awardable_id/notes/:note_id/award_emoji/:award_id
3991    returns an award emoji
3992  POST /projects/:id/awardable/:awardable_id/award_emoji
3993    on an issue
3994      creates a new award emoji
3995      marks Todos on the Issue as done
3996      returns a 400 bad request error if the name is not given
3997      returns a 401 unauthorized error if the user is not authenticated
3998      normalizes +1 as thumbsup award
3999      when the emoji already has been awarded
4000        returns a 404 status code
4001    on a snippet
4002      creates a new award emoji
4003  POST /projects/:id/awardable/:awardable_id/notes/:note_id/award_emoji
4004    creates a new award emoji
4005    marks Todos on the Noteable as done
4006    normalizes +1 as thumbsup award
4007    when the emoji already has been awarded
4008      returns a 404 status code
4009  DELETE /projects/:id/awardable/:awardable_id/award_emoji/:award_id
4010    when the awardable is an Issue
4011      deletes the award
4012      returns a 404 error when the award emoji can not be found
4013      behaves like 412 response
4014        for a modified ressource
4015          returns 412
4016        for an unmodified ressource
4017          returns accepted
4018    when the awardable is a Merge Request
4019      deletes the award
4020      returns a 404 error when note id not found
4021      behaves like 412 response
4022        for a modified ressource
4023          returns 412
4024        for an unmodified ressource
4025          returns accepted
4026    when the awardable is a Snippet
4027      deletes the award
4028      behaves like 412 response
4029        for a modified ressource
4030          returns 412
4031        for an unmodified ressource
4032          returns accepted
4033  DELETE /projects/:id/awardable/:awardable_id/award_emoji/:award_emoji_id
4034    deletes the award
4035    behaves like 412 response
4036      for a modified ressource
4037        returns 412
4038      for an unmodified ressource
4039        returns accepted
4040API::PipelineSchedules
4041  GET /projects/:id/pipeline_schedules
4042    authenticated user with valid permissions
4043      returns list of pipeline_schedules
4044      avoids N + 1 queries
4045      when scope is active
4046        returns matched pipeline schedules
4047      when scope is inactive
4048        returns matched pipeline schedules
4049    authenticated user with invalid permissions
4050      does not return pipeline_schedules list
4051    unauthenticated user
4052      does not return pipeline_schedules list
4053  GET /projects/:id/pipeline_schedules/:pipeline_schedule_id
4054    authenticated user with valid permissions
4055      returns pipeline_schedule details
4056      responds with 404 Not Found if requesting non-existing pipeline_schedule
4057    authenticated user with invalid permissions
4058      does not return pipeline_schedules list
4059    authenticated user with insufficient permissions
4060      does not return pipeline_schedules list
4061    unauthenticated user
4062      does not return pipeline_schedules list
4063  POST /projects/:id/pipeline_schedules
4064    authenticated user with valid permissions
4065      with required parameters
4066        creates pipeline_schedule
4067      without required parameters
4068        does not create pipeline_schedule
4069      when cron has validation error
4070        does not create pipeline_schedule
4071    authenticated user with invalid permissions
4072      does not create pipeline_schedule
4073    unauthenticated user
4074      does not create pipeline_schedule
4075  PUT /projects/:id/pipeline_schedules/:pipeline_schedule_id
4076    authenticated user with valid permissions
4077      updates cron
4078      when cron has validation error
4079        does not update pipeline_schedule
4080    authenticated user with invalid permissions
4081      does not update pipeline_schedule
4082    unauthenticated user
4083      does not update pipeline_schedule
4084  POST /projects/:id/pipeline_schedules/:pipeline_schedule_id/take_ownership
4085    authenticated user with valid permissions
4086      updates owner
4087    authenticated user with invalid permissions
4088      does not update owner
4089    unauthenticated user
4090      does not update owner
4091  DELETE /projects/:id/pipeline_schedules/:pipeline_schedule_id
4092    authenticated user with valid permissions
4093      deletes pipeline_schedule
4094      responds with 404 Not Found if requesting non-existing pipeline_schedule
4095      behaves like 412 response
4096        for a modified ressource
4097          returns 412
4098        for an unmodified ressource
4099          returns accepted
4100    authenticated user with invalid permissions
4101      does not delete pipeline_schedule
4102    unauthenticated user
4103      does not delete pipeline_schedule
4104  POST /projects/:id/pipeline_schedules/:pipeline_schedule_id/variables
4105    authenticated user with valid permissions
4106      with required parameters
4107        creates pipeline_schedule_variable
4108      without required parameters
4109        does not create pipeline_schedule_variable
4110      when key has validation error
4111        does not create pipeline_schedule_variable
4112    authenticated user with invalid permissions
4113      does not create pipeline_schedule_variable
4114    unauthenticated user
4115      does not create pipeline_schedule_variable
4116  PUT /projects/:id/pipeline_schedules/:pipeline_schedule_id/variables/:key
4117    authenticated user with valid permissions
4118      updates pipeline_schedule_variable
4119    authenticated user with invalid permissions
4120      does not update pipeline_schedule_variable
4121    unauthenticated user
4122      does not update pipeline_schedule_variable
4123  DELETE /projects/:id/pipeline_schedules/:pipeline_schedule_id/variables/:key
4124    authenticated user with valid permissions
4125      deletes pipeline_schedule_variable
4126      responds with 404 Not Found if requesting non-existing pipeline_schedule_variable
4127    authenticated user with invalid permissions
4128      does not delete pipeline_schedule_variable
4129    unauthenticated user
4130      does not delete pipeline_schedule_variable
4131API::Variables
4132  GET /projects/:id/variables
4133    authorized user with proper permissions
4134      returns project variables
4135    authorized user with invalid permissions
4136      does not return project variables
4137    unauthorized user
4138      does not return project variables
4139  GET /projects/:id/variables/:key
4140    authorized user with proper permissions
4141      returns project variable details
4142      responds with 404 Not Found if requesting non-existing variable
4143    authorized user with invalid permissions
4144      does not return project variable details
4145    unauthorized user
4146      does not return project variable details
4147  POST /projects/:id/variables
4148    authorized user with proper permissions
4149      creates variable
4150      creates variable with optional attributes
4151      does not allow to duplicate variable key
4152      creates variable with a specific environment scope
4153      allows duplicated variable key given different environment scopes
4154    authorized user with invalid permissions
4155      does not create variable
4156    unauthorized user
4157      does not create variable
4158  PUT /projects/:id/variables/:key
4159    authorized user with proper permissions
4160      updates variable data
4161      responds with 404 Not Found if requesting non-existing variable
4162    authorized user with invalid permissions
4163      does not update variable
4164    unauthorized user
4165      does not update variable
4166  DELETE /projects/:id/variables/:key
4167    authorized user with proper permissions
4168      deletes variable
4169      responds with 404 Not Found if requesting non-existing variable
4170    authorized user with invalid permissions
4171      does not delete variable
4172    unauthorized user
4173      does not delete variable
4174Admin::ServicesController
4175  GET #edit
4176    asana
4177      successfully displays the template
4178    assembla
4179      successfully displays the template
4180    bamboo
4181      successfully displays the template
4182    bugzilla
4183      successfully displays the template
4184    buildkite
4185      successfully displays the template
4186    campfire
4187      successfully displays the template
4188    custom_issue_tracker
4189      successfully displays the template
4190    discord
4191      successfully displays the template
4192    drone_ci
4193      successfully displays the template
4194    emails_on_push
4195      successfully displays the template
4196    external_wiki
4197      successfully displays the template
4198    flowdock
4199      successfully displays the template
4200    github
4201      successfully displays the template
4202    hangouts_chat
4203      successfully displays the template
4204    hipchat
4205      successfully displays the template
4206    irker
4207      successfully displays the template
4208    jenkins
4209      successfully displays the template
4210    jenkins_deprecated
4211      successfully displays the template
4212    jira
4213      successfully displays the template
4214    mattermost
4215      successfully displays the template
4216    mattermost_slash_commands
4217      successfully displays the template
4218    microsoft_teams
4219      successfully displays the template
4220    packagist
4221      successfully displays the template
4222    pipelines_email
4223      successfully displays the template
4224    pivotaltracker
4225      successfully displays the template
4226    prometheus
4227      successfully displays the template
4228    pushover
4229      successfully displays the template
4230    redmine
4231      successfully displays the template
4232    slack
4233      successfully displays the template
4234    slack_slash_commands
4235      successfully displays the template
4236    teamcity
4237      successfully displays the template
4238    youtrack
4239      successfully displays the template
4240  #update
4241    calls the propagation worker when service is active
4242    does not call the propagation worker when service is not active
4243Groups::GroupMembersController
4244  GET index
4245    renders index with 200 status code
4246    user with owner access
4247      assigns invited members
4248      restricts search to one email
4249      paginates invited list
4250  POST create
4251    when user does not have enough rights
4252      returns 403
4253    when user has enough rights
4254      adds user to members
4255      adds no user to members
4256  PUT update
4257    can change the access level to Guest
4258    can change the access level to Reporter
4259    can change the access level to Developer
4260    can change the access level to Maintainer
4261  DELETE destroy
4262    when member is not found
4263      returns 403
4264    when member is found
4265      when user does not have enough rights
4266        returns 403
4267      when user has enough rights
4268        [HTML] removes user from members
4269        [JS] removes user from members
4270  DELETE leave
4271    when member is not found
4272      returns 404
4273    when member is found
4274      and is not an owner
4275        removes user from members
4276        supports json request
4277      and is an owner
4278        cannot removes himself from the group
4279      and is a requester
4280        removes user from members
4281  POST request_access
4282    creates a new GroupMember that is not a team member
4283  POST approve_access_request
4284    when member is not found
4285      returns 403
4286    when member is found
4287      when user does not have enough rights
4288        returns 403
4289      when user has enough rights
4290        adds user to members
4291  with external authorization enabled
4292    GET #index
4293      is successful
4294    POST #create
4295      is successful
4296    PUT #update
4297      is successful
4298    DELETE #destroy
4299      is successful
4300    POST #destroy
4301      is successful
4302    POST #approve_request_access
4303      is successful
4304    DELETE #leave
4305      is successful
4306    POST #resend_invite
4307      is successful
4308Projects::CommitController
4309  GET show
4310    handles binary files
4311    with valid id
4312      responds with 200
4313    with invalid id
4314      responds with 404
4315    as diff
4316      triggers workhorse to serve the request
4317    as patch
4318      contains a git diff
4319    commit that removes a submodule
4320      renders it
4321    in the context of a merge_request
4322      prepare diff notes in the context of the merge request
4323  GET branches
4324    contains branch and tags information
4325    returns :limit_exceeded when number of branches/tags reach a threshhold
4326  POST revert
4327    when target branch is not provided
4328      renders the 404 page
4329    when the revert was successful
4330      redirects to the commits page
4331    when the revert failed
4332      redirects to the commit page
4333  POST cherry_pick
4334    when target branch is not provided
4335      renders the 404 page
4336    when the cherry-pick was successful
4337      redirects to the commits page
4338    when the cherry_pick failed
4339      redirects to the commit page
4340  GET diff_for_path
4341    when the commit exists
4342      when the user has access to the project
4343        when the path exists in the diff
4344          enables diff notes
4345          only renders the diffs for the path given
4346        when the path does not exist in the diff
4347          returns a 404
4348      when the user does not have access to the project
4349        returns a 404
4350    when the commit does not exist
4351      returns a 404
4352  GET pipelines
4353    when the commit exists
4354      when the commit has pipelines
4355        when rendering a HTML format
4356          shows pipelines
4357        when rendering a JSON format
4358DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "max(stage_idx)". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from legacy_stages at /builds/gitlab-org/gitlab-ee/app/models/ci/pipeline.rb:377)
4359DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "(SELECT COUNT(*) FROM \"ci_builds\" WHERE \"ci_builds\".\"commit_id\" = 107 AND (\"ci_builds\".\"retried\" = FALSE OR \"ci_builds\".\"retried\" IS NULL) AND (stage=sg.stage) AND \"ci_builds\".\"allow_failure\" = TRUE AND \"ci_builds\".\"status\" IN ('failed', 'canceled'))". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from legacy_stages at /builds/gitlab-org/gitlab-ee/app/models/ci/pipeline.rb:385)
4360          responds with serialized pipelines
4361    when the commit does not exist
4362      returns a 404
4363API::ProtectedTags
4364  GET /projects/:id/protected_tags
4365    when authenticated as a maintainer
4366      behaves like protected tags
4367        returns the protected tags
4368    when authenticated as a guest
4369      behaves like 403 response
4370        returns 403
4371  GET /projects/:id/protected_tags/:tag
4372    when authenticated as a maintainer
4373      behaves like protected tag
4374        returns the protected tag
4375        when protected tag does not exist
4376          behaves like 404 response
4377            returns 404
4378      when protected tag contains a wildcard
4379        behaves like protected tag
4380          returns the protected tag
4381          when protected tag does not exist
4382            behaves like 404 response
4383              returns 404
4384    when authenticated as a guest
4385      behaves like 403 response
4386        returns 403
4387  POST /projects/:id/protected_tags
4388    when authenticated as a maintainer
4389      protects a single tag with maintainers can create tags
4390      protects a single tag with developers can create tags
4391      protects a single tag with no one can create tags
4392      returns a 422 error if the same tag is protected twice
4393      returns 201 if the same tag is proteted on different projects
4394      when tag has a wildcard in its name
4395        protects multiple tags with a wildcard in the name
4396    when authenticated as a guest
4397      returns a 403 error if guest
4398  DELETE /projects/:id/protected_tags/unprotect/:tag
4399    unprotects a single tag
4400    returns 404 if tag does not exist
4401    behaves like 412 response
4402      for a modified ressource
4403        returns 412
4404      for an unmodified ressource
4405        returns accepted
4406    when tag has a wildcard in its name
4407      unprotects a wildcard tag
4408Admin::ClustersController
4409  GET #index
4410    functionality
4411      when instance has one or more clusters
4412        lists available clusters
4413        when page is specified
4414          redirects to the page
4415      when instance does not have a cluster
4416        returns an empty state page
4417    security
4418      should be allowed for admin. Expected: 200,201,204,302 Got: 200
4419      should be denied for user. Expected: 401,404 Got: 404
4420      should be denied for external. Expected: 401,404 Got: 404
4421  GET #new
4422    functionality for new cluster
4423      when omniauth has been configured
4424        has authorize_url
4425      when omniauth has not configured
4426        does not have authorize_url
4427      when access token is valid
4428        has new object
4429      when access token is expired
4430        should be falsey
4431      when access token is not stored in session
4432        should be falsey
4433    functionality for existing cluster
4434      has new object
4435    security
4436      should be allowed for admin. Expected: 200,201,204,302 Got: 200
4437      should be denied for user. Expected: 401,404 Got: 404
4438      should be denied for external. Expected: 401,404 Got: 404
4439  POST #create_gcp
4440    functionality
4441      when access token is valid
4442        creates a new cluster
4443        when legacy_abac param is false
4444          creates a new cluster with legacy_abac_disabled
4445      when access token is expired
4446        should be falsey
4447      when access token is not stored in session
4448        should be falsey
4449    security
4450      should be allowed for admin. Expected: 200,201,204,302 Got: 302
4451      should be denied for user. Expected: 401,404 Got: 404
4452      should be denied for external. Expected: 401,404 Got: 404
4453  POST #create_user
4454    functionality
4455      when creates a cluster
4456        creates a new cluster
4457      when creates a RBAC-enabled cluster
4458        creates a new cluster
4459    security
4460      should be allowed for admin. Expected: 200,201,204,302 Got: 302
4461      should be denied for user. Expected: 401,404 Got: 404
4462      should be denied for external. Expected: 401,404 Got: 404
4463  GET #cluster_status
4464    functionality
4465      responds with matching schema
4466      invokes schedule_status_update on each application
4467    security
4468      should be allowed for admin. Expected: 200,201,204,302 Got: 200
4469      should be denied for user. Expected: 401,404 Got: 404
4470      should be denied for external. Expected: 401,404 Got: 404
4471  GET #show
4472    functionality
4473      responds successfully
4474    security
4475      should be allowed for admin. Expected: 200,201,204,302 Got: 200
4476      should be denied for user. Expected: 401,404 Got: 404
4477      should be denied for external. Expected: 401,404 Got: 404
4478  PUT #update
4479    updates and redirects back to show page
4480    when domain is invalid
4481      does not update cluster attributes
4482    when format is json
4483      when changing parameters
4484        when valid parameters are used
4485          updates and redirects back to show page
4486        when invalid parameters are used
4487          rejects changes
4488    security
4489      should be allowed for admin. Expected: 200,201,204,302 Got: 302
4490      should be denied for user. Expected: 401,404 Got: 404
4491      should be denied for external. Expected: 401,404 Got: 404
4492  DELETE #destroy
4493    functionality
4494      when cluster is provided by GCP
4495        when cluster is created
4496          destroys and redirects back to clusters list
4497        when cluster is being created
4498          destroys and redirects back to clusters list
4499      when cluster is provided by user
4500        destroys and redirects back to clusters list
4501    security
4502      should be allowed for admin. Expected: 200,201,204,302 Got: 302
4503      should be denied for user. Expected: 401,404 Got: 404
4504      should be denied for external. Expected: 401,404 Got: 404
4505SearchController
4506  GET #show
4507    finds issue comments
4508    behaves like when the user cannot read cross project
4509      blocks access without a project_id
4510      allows access with a project_id
4511      still allows accessing the search page
4512    behaves like with external authorization service enabled
4513      renders a 403 when no project is given
4514      renders a 200 when a project was set
4515    uses the right partials depending on scope
4516      partial: "_blob", scope: :blobs
4517        should render template search/results/_blob
4518      partial: "_wiki_blob", scope: :wiki_blobs
4519        should render template search/results/_wiki_blob
4520      partial: "_commit", scope: :commits
4521        should render template search/results/_commit
4522    global search
4523      omits pipeline status from load
4524    on restricted projects
4525      doesn't expose comments on merge_requests
4526      doesn't expose comments on snippets
4527      when signed out
4528        doesn't expose comments on issues
4529  GET #count
4530    returns the result count for the given term and scope
4531    raises an error if search term is missing
4532    raises an error if search scope is missing
4533    behaves like when the user cannot read cross project
4534      blocks access without a project_id
4535      allows access with a project_id
4536    behaves like with external authorization service enabled
4537      renders a 403 when no project is given
4538      renders a 200 when a project was set
4539  GET #autocomplete
4540    behaves like when the user cannot read cross project
4541      blocks access without a project_id
4542      allows access with a project_id
4543    behaves like with external authorization service enabled
4544      renders a 403 when no project is given
4545      renders a 200 when a project was set
4546API::ProjectSnippets
4547  GET /projects/:project_id/snippets/:id/user_agent_detail
4548    exposes known attributes
4549    respects project scoping
4550    returns unauthorized for non-admin users
4551  GET /projects/:project_id/snippets/
4552    returns all snippets available to team member
4553    hides private snippets from regular user
4554  GET /projects/:project_id/snippets/:id
4555    returns snippet json
4556    returns 404 for invalid snippet id
4557  POST /projects/:project_id/snippets/
4558    creates a new snippet
4559    returns 400 for missing parameters
4560    returns 400 for empty code field
4561    when the snippet is spam
4562      when the snippet is private
4563        creates the snippet
4564      when the snippet is public
4565        rejects the snippet
4566        creates a spam log
4567  PUT /projects/:project_id/snippets/:id/
4568    updates snippet
4569    returns 404 for invalid snippet id
4570    returns 400 for missing parameters
4571    returns 400 for empty code field
4572    when the snippet is spam
4573      when the snippet is private
4574        creates the snippet
4575      when the snippet is public
4576        rejects the snippet
4577        creates a spam log
4578      when the private snippet is made public
4579        rejects the snippet
4580        creates a spam log
4581  DELETE /projects/:project_id/snippets/:id/
4582    deletes snippet
4583    returns 404 for invalid snippet id
4584    behaves like 412 response
4585      for a modified ressource
4586        returns 412
4587      for an unmodified ressource
4588        returns accepted
4589  GET /projects/:project_id/snippets/:id/raw
4590    returns raw text
4591    returns 404 for invalid snippet id
4592Admin::ApplicationSettingsController
4593  GET #usage_data with no access
4594    returns 404
4595  GET #usage_data
4596unknown OID 28: failed to recognize type of 'relfrozenxid'. It will be treated as String.
4597unknown OID 1034: failed to recognize type of 'relacl'. It will be treated as String.
4598unknown OID 194: failed to recognize type of 'relpartbound'. It will be treated as String.
4599    returns HTML data
4600    returns JSON data
4601  PUT #update
4602    updates the password_authentication_enabled_for_git setting
4603    updates the default_project_visibility for string value
4604    update the restricted levels for string values
4605    updates the restricted_visibility_levels when empty array is passed
4606    updates the receive_max_input_size setting
4607    updates the default_project_creation for string value
4608    external policy classification settings
4609      updates settings when the feature is available
4610    verify panel actions
4611      behaves like renders correct panels
4612        renders correct action on error
4613        redirects to same panel on success
4614      behaves like renders correct panels
4615        renders correct action on error
4616        redirects to same panel on success
4617      behaves like renders correct panels
4618        renders correct action on error
4619        redirects to same panel on success
4620      behaves like renders correct panels
4621        renders correct action on error
4622        redirects to same panel on success
4623      behaves like renders correct panels
4624        renders correct action on error
4625        redirects to same panel on success
4626      behaves like renders correct panels
4627        renders correct action on error
4628        redirects to same panel on success
4629      behaves like renders correct panels
4630        renders correct action on error
4631        redirects to same panel on success
4632  PUT #reset_registration_token
4633    resets runner registration token
4634    redirects the user to admin runners page
4635Projects::DeploymentsController
4636  GET #index
4637    returns list of deployments from last 8 hours
4638    returns a list with deployments information
4639  GET #metrics
4640    when metrics are disabled
4641      responds with not found
4642    when metrics are enabled
4643      when environment has no metrics
4644        returns a empty response 204 resposne
4645      when environment has some metrics
4646        returns a metrics JSON document
4647  GET #additional_metrics
4648    when metrics are disabled
4649      responds with not found
4650    when metrics are enabled
4651      when environment has no metrics
4652        returns a empty response 204 response
4653      when environment has some metrics
4654        returns a metrics JSON document
4655ApplicationController
4656  #check_password_expiration
4657    redirects if the user is over their password expiry
4658    does not redirect if the user is under their password expiry
4659    does not redirect if the user is over their password expiry but they are an ldap user
4660    does not redirect if the user is over their password expiry but password authentication is disabled for the web interface
4661  #add_gon_variables
4662    with html format
4663      behaves like setting gon variables
4664        sets gon variables
4665      for peek requests
4666        behaves like not setting gon variables
4667          does not set gon variables
4668    with json format
4669      behaves like not setting gon variables
4670        does not set gon variables
4671  session expiration
4672    authenticated user
4673      does not set the expire_after option
4674    unauthenticated user
4675      sets the expire_after option
4676  response format
4677    when format is handled
4678      returns 200 response
4679    when format is not handled
4680      returns 404 response
4681  #route_not_found
4682    renders 404 if authenticated
4683    does redirect to login page via authenticate_user! if not authenticated
4684  #set_page_title_header
4685    URI encodes UTF-8 characters in the title
4686  two-factor authentication
4687    #check_two_factor_requirement
4688      does not redirect if user has temporary oauth email
4689      does not redirect if 2FA is not required
4690      does not redirect if user is not logged in
4691      does not redirect if user has 2FA enabled
4692      does not redirect if 2FA setup can be skipped
4693      redirects to 2FA setup otherwise
4694    #two_factor_authentication_required?
4695      returns false if no 2FA requirement is present
4696      returns true if a 2FA requirement is set in the application settings
4697      returns true if a 2FA requirement is set on the user
4698      returns true if user has signed up using omniauth-ultraauth
4699    #two_factor_grace_period
4700      returns the grace period from the application settings
4701      with a 2FA requirement set on the user
4702        returns the user grace period if lower than the application grace period
4703        returns the application grace period if lower than the user grace period
4704    #two_factor_grace_period_expired?
4705      returns false if the user has not started their grace period yet
4706      with grace period started
4707        returns true if the grace period has expired
4708        returns false if the grace period is still active
4709    #two_factor_skippable
4710      returns false if 2FA is not required
4711      returns false if the user has already enabled 2FA
4712      returns false if the 2FA grace period has expired
4713      returns true otherwise
4714    #skip_two_factor?
4715      returns false if 2FA setup was not skipped
4716      with 2FA setup skipped
4717        returns false if the grace period has expired
4718        returns true if the grace period is still active
4719  terms
4720    does not query more when terms are enforced
4721    when terms are enforced
4722      redirects if the user did not accept the terms
4723      does not redirect when the user accepted terms
4724  #append_info_to_payload
4725    does not log errors with a 200 response
4726    does log correlation id
4727    422 errors
4728      logs a response with a string
4729      logs a response with an array
4730      does not log a string with an empty body
4731      does not log an HTML body
4732  #access_denied
4733    renders a 404 without a message
4734    renders a 403 when a message is passed to access denied
4735    renders a status passed to access denied
4736  when invalid UTF-8 parameters are received
4737    html
4738      renders 412
4739    js
4740      renders 412
4741  X-GitLab-Custom-Error header
4742    given a 422 error page
4743      sets a custom header
4744    given a 500 error page
4745      sets a custom header
4746    given a 200 success page
4747      does not set a custom header
4748    given a json response
4749      sets a custom header
4750      for html request
4751        sets a custom header
4752      for 200 response
4753        does not set a custom header
4754  control headers
4755    user not logged in
4756      sets the default headers
4757    user logged in
4758      sets the default headers
4759      does not set the "no-store" header for XHR requests
4760  Gitlab::Session
4761    is set on web requests
4762    with sessionless user
4763      is not set
4764Projects::ServicesController
4765  #test
4766    when can_test? returns false
4767      renders 404
4768    when validations fail
4769      returns error messages in JSON response
4770    success
4771      returns success
4772      with empty project
4773        returns success
4774        with chat notification service
4775          returns success
4776      when service is configured for the first time
4777        persist the object
4778        creates the ServiceHook object
4779    failure
4780      returns success status code and the error message
4781  PUT #update
4782    when param `active` is set to true
4783      activates the service and redirects to integrations paths
4784    when param `active` is set to false
4785      does not  activate the service but saves the settings
4786    when activating Jira service from a template
4787      activate Jira service from template
4788  GET #edit
4789    with approved services
4790      renders edit page
4791Projects::BadgesController
4792  #pipeline
4793    behaves like a badge resource
4794      when pipelines are public
4795        when project is public
4796          returns the pipeline badge to unauthenticated users
4797        when project is restricted
4798          returns the pipeline badge to guest users
4799      format
4800        renders the `flat` badge layout by default
4801        when style param is set to `flat`
4802          renders the `flat` badge layout
4803        when style param is set to an invalid type
4804          renders the `flat` (default) badge layout
4805        when style param is set to `flat-square`
4806          renders the `flat-square` badge layout
4807      when pipelines are not public
4808        when project is public
4809          returns 404 to unauthenticated users
4810        when project is restricted to the user
4811          defaults to project permissions
4812  #coverage
4813    behaves like a badge resource
4814      when pipelines are public
4815        when project is public
4816          returns the coverage badge to unauthenticated users
4817        when project is restricted
4818          returns the coverage badge to guest users
4819      format
4820        renders the `flat` badge layout by default
4821        when style param is set to `flat`
4822          renders the `flat` badge layout
4823        when style param is set to an invalid type
4824          renders the `flat` (default) badge layout
4825        when style param is set to `flat-square`
4826          renders the `flat-square` badge layout
4827      when pipelines are not public
4828        when project is public
4829          returns 404 to unauthenticated users
4830        when project is restricted to the user
4831          defaults to project permissions
4832Admin::UsersController
4833  GET #index
4834    retrieves all users
4835    filters by admins
4836  GET :id
4837    finds a user case-insensitively
4838  DELETE #user with projects
4839    deletes user and ghosts their contributions
4840    deletes the user and their contributions when hard delete is specified
4841  PUT block/:id
4842    blocks user
4843  PUT unblock/:id
4844    ldap blocked users
4845      does not unblock user
4846    manually blocked users
4847      unblocks user
4848  PUT unlock/:id
4849    unlocks user
4850  PUT confirm/:id
4851    confirms user
4852  PATCH disable_two_factor
4853    disables 2FA for the user
4854    redirects back
4855    displays an alert
4856  POST create
4857    creates the user
4858    shows only one error message for an invalid email
4859  POST update
4860    when the password has changed
4861      when the admin changes his own password
4862        updates the password
4863        does not set the new password to expire immediately
4864      when the new password is valid
4865        redirects to the user
4866        updates the password
4867        sets the new password to expire immediately
4868      when the new password is invalid
4869        shows the edit page again
4870        returns the error message
4871        does not update the password
4872      when the new password does not match the password confirmation
4873        shows the edit page again
4874        returns the error message
4875        does not update the password
4876  POST impersonate
4877    when the user is blocked
4878      shows a notice
4879      doesn't sign us in as the user
4880    when the user is not blocked
4881      stores the impersonator in the session
4882      signs us in as the user
4883      logs the beginning of the impersonation event
4884      redirects to root
4885      shows a notice
4886    when impersonation is disabled
4887      shows error page
4888Adding an AwardEmoji
4889  when the user does not have permission
4890    behaves like a mutation that does not create an AwardEmoji
4891      should not change `AwardEmoji.count`
4892    behaves like a mutation that returns top-level errors
4893      should eq ["The resource that you are attempting to access does not exist or you don't have permission to perform this action"]
4894  when the user has permission
4895    when the given awardable is not an Awardable
4896      behaves like a mutation that does not create an AwardEmoji
4897        should not change `AwardEmoji.count`
4898      behaves like a mutation that returns top-level errors
4899        should eq ["Cannot award emoji to this resource"]
4900    when the given awardable is an Awardable but still cannot be awarded an emoji
4901      behaves like a mutation that does not create an AwardEmoji
4902        should not change `AwardEmoji.count`
4903      behaves like a mutation that returns top-level errors
4904        should eq ["Cannot award emoji to this resource"]
4905    when the given awardable an Awardable
4906      creates an emoji
4907      returns the emoji
4908      marking Todos as done
4909        type: :issue, expectation: true
4910          should eq true
4911        type: :merge_request, expectation: true
4912          should eq true
4913        type: :project_snippet, expectation: false
4914          should eq false
4915        for notes
4916          regular Notes
4917            marks the Todo as done
4918          PersonalSnippet Notes
4919            does not mark the Todo as done
4920      when there were active record validation errors
4921        returns an empty awardEmoji
4922        behaves like a mutation that does not create an AwardEmoji
4923          should not change `AwardEmoji.count`
4924        behaves like a mutation that returns errors in the response
4925          should eq ["Error 1", "Error 2"]
4926API::Snippets
4927  GET /snippets/
4928    returns snippets available
4929    hides private snippets from regular user
4930    returns 404 for non-authenticated
4931    does not return snippets related to a project with disable feature visibility
4932  GET /snippets/public
4933    returns all snippets with public visibility from all users
4934  GET /snippets/:id/raw
4935    requires authentication
4936    returns raw text
4937    forces attachment content disposition
4938    returns 404 for invalid snippet id
4939    hides private snippets from ordinary users
4940    shows internal snippets to ordinary users
4941  GET /snippets/:id
4942    requires authentication
4943    returns snippet json
4944    shows private snippets to an admin
4945    hides private snippets from an ordinary user
4946    shows internal snippets to an ordinary user
4947    returns 404 for invalid snippet id
4948  POST /snippets/
4949    creates a new snippet
4950    returns 400 for missing parameters
4951    when the snippet is spam
4952      when the snippet is private
4953        creates the snippet
4954      when the snippet is public
4955        rejects the shippet
4956        creates a spam log
4957  PUT /snippets/:id
4958    updates snippet
4959    returns 404 for invalid snippet id
4960    returns 404 for another user's snippet
4961    returns 400 for missing parameters
4962    when the snippet is spam
4963      when the snippet is private
4964        updates the snippet
4965      when the snippet is public
4966        rejects the shippet
4967        creates a spam log
4968      when a private snippet is made public
4969        rejects the snippet
4970        creates a spam log
4971  DELETE /snippets/:id
4972    deletes snippet
4973    returns 404 for invalid snippet id
4974    behaves like 412 response
4975      for a modified ressource
4976        returns 412
4977      for an unmodified ressource
4978        returns accepted
4979  GET /snippets/:id/user_agent_detail
4980    exposes known attributes
4981    returns unauthorized for non-admin users
4982Projects::Tags::ReleasesController
4983  GET #edit
4984    initializes a new release
4985    retrieves an existing release
4986  PUT #update
4987    updates release note description
4988    creates a release if one does not exist
4989    sets the release name, sha, and author for a new release
4990    deletes release when description is empty
4991    does nothing when description is empty and the tag does not have a release
4992API::Namespaces
4993  GET /namespaces
4994    when unauthenticated
4995      returns authentication error
4996    when authenticated as admin
4997      returns correct attributes
4998      admin: returns an array of all namespaces
4999      admin: returns an array of matched namespaces
5000    when authenticated as a regular user
5001      returns correct attributes when user can admin group
5002      returns correct attributes when user cannot admin group
5003      user: returns an array of namespaces
5004      admin: returns an array of matched namespaces
5005  GET /namespaces/:id
5006    when unauthenticated
5007      returns authentication error
5008    when authenticated as regular user
5009      when requested namespace is not owned by user
5010        when requesting group
5011          returns not-found
5012        when requesting personal namespace
5013          returns not-found
5014      when requested namespace is owned by user
5015        behaves like namespace reader
5016          when namespace exists
5017            when requested by ID
5018              when requesting group
5019                behaves like can access namespace
5020                  returns namespace details
5021              when requesting personal namespace
5022                behaves like can access namespace
5023                  returns namespace details
5024            when requested by path
5025              when requesting group
5026                behaves like can access namespace
5027                  returns namespace details
5028              when requesting personal namespace
5029                behaves like can access namespace
5030                  returns namespace details
5031          when namespace doesn't exist
5032            returns not-found
5033    when authenticated as admin
5034      when requested namespace is not owned by user
5035        when requesting group
5036          behaves like can access namespace
5037            returns namespace details
5038        when requesting personal namespace
5039          behaves like can access namespace
5040            returns namespace details
5041      when requested namespace is owned by user
5042        behaves like namespace reader
5043          when namespace exists
5044            when requested by ID
5045              when requesting group
5046                behaves like can access namespace
5047                  returns namespace details
5048              when requesting personal namespace
5049                behaves like can access namespace
5050                  returns namespace details
5051            when requested by path
5052              when requesting group
5053                behaves like can access namespace
5054                  returns namespace details
5055              when requesting personal namespace
5056                behaves like can access namespace
5057                  returns namespace details
5058          when namespace doesn't exist
5059            returns not-found
5060GitlabSchema configurations
5061  regular queries
5062    behaves like imposing query limits
5063      #max_complexity
5064        when complexity is too high
5065          shows an error
5066      #max_depth
5067        when query depth is too high
5068          shows error
5069        when query depth is within range
5070          has no error
5071  multiplexed queries
5072    does not authenticate all queries
5073    behaves like imposing query limits
5074      fails all queries when only one of the queries is too complex
5075      #max_complexity
5076        when complexity is too high
5077          shows an error
5078      #max_depth
5079        when query depth is too high
5080          shows error
5081        when query depth is within range
5082          has no error
5083    authentication
5084      authenticates all queries
5085  when IntrospectionQuery
5086    is not too complex
5087  logging
5088    logs the query complexity and depth
5089    logs using `format_message`
5090  global id's
5091    uses GlobalID to expose ids
5092getting a tree in a project
5093  when path does not exist
5094    returns empty tree
5095    returns null commit
5096  when ref does not exist
5097    returns empty tree
5098    returns null commit
5099  when ref and path exist
5100    returns tree
5101    returns blobs, subtrees and submodules inside tree
5102    returns tree latest commit
5103  when current user is nil
5104    returns empty project
5105Projects::PagesController
5106  GET show
5107    returns 200 status
5108    when the project is in a subgroup
5109      returns a 200 status code
5110  DELETE destroy
5111    returns 302 status
5112    when user is developer
5113      returns 404 status
5114  pages disabled
5115    GET show
5116      returns 404 status
5117    DELETE destroy
5118      returns 404 status
5119  PATCH update
5120    returns 302 status
5121    redirects back to the pages settings
5122    calls the update service
5123Groups::Settings::CiCdController
5124  GET #show
5125    when user is owner
5126      renders show with 200 status code
5127    when user is not owner
5128      renders a 404
5129    external authorization
5130      renders show with 200 status code
5131  PUT #reset_registration_token
5132    when user is owner
5133      resets runner registration token
5134      redirects the user to admin runners page
5135    when user is not owner
5136      renders a 404
5137  PATCH #update_auto_devops
5138    when user does not have enough permission
5139      should respond with numeric status code 404
5140    when user has enough privileges
5141      should redirect to "/groups/group260/-/settings/ci_cd"
5142      when service execution went wrong
5143        returns a flash alert
5144      when service execution was successful
5145        returns a flash notice
5146      when changing auto devops value
5147        when explicitly enabling auto devops
5148          updates group attribute
5149        when explicitly disabling auto devops
5150          updates group attribute
5151Explore::ProjectsController
5152  when user is signed in
5153    GET #index.json
5154      should respond with 200
5155    GET #trending.json
5156      should respond with 200
5157    GET #starred.json
5158      should respond with 200
5159    GET #trending
5160      sorting by update date
5161        sorts by last updated
5162        sorts by oldest updated
5163    user preference sorting
5164      behaves like set sort order from user preference
5165        #set_sort_order_from_user_preference
5166          when database is in read-only mode
5167            does not update user preference
5168          when database is not in read-only mode
5169            updates user preference
5170  when user is not signed in
5171    GET #index.json
5172      should respond with 200
5173    GET #trending.json
5174      should respond with 200
5175    GET #starred.json
5176      should respond with 200
5177    GET #trending
5178      sorting by update date
5179        sorts by last updated
5180        sorts by oldest updated
5181    user preference sorting
5182      does not set sort order from user preference
5183Projects::FindFileController
5184  GET #show
5185    valid branch
5186      should respond with 200
5187    invalid branch
5188      should respond with 404
5189  GET #list
5190    valid branch
5191      returns an array of file path list
5192    invalid branch
5193      responds with status 404
5194API::GroupContainerRepositories
5195  GET /groups/:id/registry/repositories
5196    behaves like rejected container repository access
5197      for guest
5198        returns forbidden
5199    behaves like rejected container repository access
5200      for anonymous
5201        returns not_found
5202    behaves like returns repositories for allowed users
5203      for reporter
5204        returns a list of repositories
5205        returns a matching schema
5206        with tags param
5207          returns a list of repositories and their tags
5208          returns a matching schema
5209    with invalid group id
5210      returns not found
5211getting a repository in a project
5212  returns repository
5213  as a non-authorized user
5214    returns nil
5215  when the repository is only accessible to members
5216    returns a repository for the owner
5217    returns nil for the repository for other users
5218    returns nil for the repository for other users
5219GraphQL
5220  logging
5221    with no variables
5222      behaves like logging a graphql query
5223        logs a query with the expected params
5224        does not instantiate any query analyzers
5225    with variables
5226      behaves like logging a graphql query
5227        logs a query with the expected params
5228        does not instantiate any query analyzers
5229    when there is an error in the logger
5230      logs the exception in Sentry and continues with the request
5231  invalid variables
5232    returns an error
5233  authentication
5234    allows access to public data without authentication
5235    does not authenticate a user with an invalid CSRF
5236    authenticates a user with a valid session token
5237    token authentication
5238      Authenticates users with a PAT
5239      when the personal access token has no api scope
5240        does not log the user in
5241  testing for Gitaly calls
5242    behaves like a working graphql query
5243      returns a successful response
5244    when Gitaly is called
5245      logs a warning that the 'calls_gitaly' field declaration is missing
5246API::NotificationSettings
5247  GET /notification_settings
5248    returns global notification settings for the current user
5249  PUT /notification_settings
5250    updates global notification settings for the current user
5251  PUT /notification_settings
5252    fails on non-user email address
5253  GET /groups/:id/notification_settings
5254    returns group level notification settings for the current user
5255  PUT /groups/:id/notification_settings
5256    updates group level notification settings for the current user
5257  GET /projects/:id/notification_settings
5258    returns project level notification settings for the current user
5259  PUT /projects/:id/notification_settings
5260    updates project level notification settings for the current user
5261  PUT /projects/:id/notification_settings
5262    fails on invalid level
5263Admin::GroupsController
5264  DELETE #destroy
5265    schedules a group destroy
5266    redirects to the admin group path
5267  PUT #members_update
5268    adds user to members
5269    can add unlimited members
5270    adds no user to members
5271    updates the project_creation_level successfully
5272    updates the subgroup_creation_level successfully
5273Dashboard::LabelsController
5274  #index
5275    returns global labels for projects the user has a relationship with
5276    behaves like disabled when using an external authorization service
5277      works when the feature is not enabled
5278      renders a 404 with a message when the feature is enabled
5279API::Applications
5280  POST /applications
5281    authenticated and authorized user
5282      creates and returns an OAuth application
5283      does not allow creating an application with the wrong redirect_uri format
5284      does not allow creating an application with a forbidden URI format
5285      does not allow creating an application without a name
5286      does not allow creating an application without a redirect_uri
5287      does not allow creating an application without scopes
5288    authorized user without authorization
5289      does not create application
5290    non-authenticated user
5291      does not create application
5292  GET /applications
5293    authenticated and authorized user
5294      can list application
5295    authorized user without authorization
5296      cannot list application
5297    non-authenticated user
5298      cannot list application
5299  DELETE /applications/:id
5300    authenticated and authorized user
5301      can delete an application
5302    authorized user without authorization
5303      cannot delete an application
5304    non-authenticated user
5305      cannot delete an application
5306Projects::ErrorTrackingController
5307  GET #index
5308    html
5309      renders index with 200 status code
5310      with insufficient permissions
5311        returns 404
5312      with an anonymous user
5313        redirects to sign-in page
5314    format json
5315      service result is successful
5316        returns a list of errors
5317      service result is erroneous
5318        without http_status
5319          returns 400 with message
5320        with explicit http_status
5321          returns http_status with message
5322  POST #list_projects
5323    with insufficient permissions
5324      returns 404
5325    with an anonymous user
5326      redirects to sign-in page
5327    with authorized user
5328      service result is successful
5329        returns a list of projects
5330      service result is erroneous
5331        without http_status
5332          returns 400 with message
5333        with explicit http_status
5334          returns http_status with message
5335API::UserCounts
5336  GET /user_counts
5337    when unauthenticated
5338      returns authentication error
5339    when authenticated
5340      returns open counts for current user
5341      updates the mr count when a new mr is assigned
5342AbuseReportsController
5343  GET new
5344    when the user has already been deleted
5345      redirects the reporter to root_path
5346    when the user has already been blocked
5347      redirects the reporter to the user's profile
5348  POST create
5349    with valid attributes
5350      saves the abuse report
5351      calls notify
5352      redirects back to the reported user
5353    with invalid attributes
5354      renders new
5355LfsRequest
5356  #storage_project
5357    assigns the project as storage project
5358    assigns the source of a forked project
5359Profiles::KeysController
5360  #get_keys
5361    non existent user
5362      does not generally work
5363    user with no keys
5364      does generally work
5365      renders all keys separated with a new line
5366      responds with text/plain content type
5367    user with keys
5368      does generally work
5369      renders all non deploy keys separated with a new line
5370      does not render the comment of the key
5371      responds with text/plain content type
5372Users::TermsController
5373  GET #index
5374    redirects when no terms exist
5375    when terms exist
5376      shows terms when they exist
5377      shows a message when the user already accepted the terms
5378  POST #accept
5379    saves that the user accepted the terms
5380    redirects to a path when specified
5381    redirects to the referer when no redirect specified
5382    redirecting to another domain
5383      is prevented when passing a redirect param
5384      is prevented when redirecting to the referer
5385  POST #decline
5386    stores that the user declined the terms
5387    signs out the user
5388Groups::LabelsController
5389  GET #index
5390    returns group and project labels by default
5391    with ancestor group
5392      returns ancestor group labels
5393    external authorization
5394      behaves like disabled when using an external authorization service
5395        works when the feature is not enabled
5396        renders a 404 with a message when the feature is enabled
5397  POST #toggle_subscription
5398    allows user to toggle subscription on group labels
5399Projects::HooksController
5400  #index
5401    redirects to settings/integrations page
5402  #create
5403    sets all parameters
5404Import::FogbugzController
5405  POST #callback
5406    attempts to contact Fogbugz server
5407  POST #create_user_map
5408    stores the user map in the session
5409  GET status
5410    assigns variables
5411    does not show already added project
5412HealthController
5413  #readiness
5414    accessed from whitelisted ip
5415      behaves like endpoint responding with readiness data
5416        responds with readiness checks data
5417    accessed from not whitelisted ip
5418      responds with resource not found
5419      accessed with valid token
5420        token passed in request header
5421          behaves like endpoint responding with readiness data
5422            responds with readiness checks data
5423      token passed as URL param
5424        behaves like endpoint responding with readiness data
5425          responds with readiness checks data
5426  #liveness
5427    accessed from whitelisted ip
5428      behaves like endpoint responding with liveness data
5429        responds with liveness checks data
5430    accessed from not whitelisted ip
5431      responds with resource not found
5432      accessed with valid token
5433        token passed in request header
5434          behaves like endpoint responding with liveness data
5435            responds with liveness checks data
5436        token passed as URL param
5437          behaves like endpoint responding with liveness data
5438            responds with liveness checks data
5439Admin::SpamLogsController
5440  #index
5441    lists all spam logs
5442  #destroy
5443    removes only the spam log when removing log
5444    removes user and his spam logs when removing the user
5445  #mark_as_ham
5446    submits the log as ham
5447AbuseReportMailer
5448  .notify
5449    behaves like appearance header and footer enabled
5450      contains header and footer
5451    behaves like appearance header and footer not enabled
5452      does not contain header and footer
5453    with admin_notification_email set
5454      sends to the admin_notification_email
5455      includes the user in the subject
5456    with no admin_notification_email set
5457      returns early
5458InstanceStatistics::CohortsController
5459  renders a 404 when the usage ping is disabled
5460  behaves like instance statistics availability
5461    GET #index
5462DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "CAST(DATE_TRUNC('month', created_at) AS date) ASC", "CAST(DATE_TRUNC('month', last_activity_on) AS date) ASC". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from counts_by_month at /builds/gitlab-org/gitlab-ee/app/services/cohorts_service.rb:91)
5463      is available when the feature is available publicly
5464      renders a 404 when the feature is not available publicly
5465      for admins
5466DEPRECATION WARNING: Dangerous query method (method whose arguments are used as raw SQL) called with non-attribute argument(s): "CAST(DATE_TRUNC('month', created_at) AS date) ASC", "CAST(DATE_TRUNC('month', last_activity_on) AS date) ASC". Non-attribute arguments will be disallowed in Rails 6.0. This method should not be called with user-provided values, such as request parameters or model attributes. Known-safe values can be passed by wrapping them in Arel.sql(). (called from counts_by_month at /builds/gitlab-org/gitlab-ee/app/services/cohorts_service.rb:91)
5467        allows access when the feature is not available publicly
5468ContinueParams
5469  returns an empty hash if params are not present
5470  cleans up any params that are not allowed
5471  does not allow cross host redirection
5472  allows redirecting to a path with querystring
5473API::ImportGithub
5474  POST /import/github
5475    returns 201 response when the project is imported successfully
5476    returns 422 response when user can not create projects in the chosen namespace
5477API::Avatar
5478  GET /avatar
5479    avatar uploaded to GitLab
5480      user with matching public email address
5481        returns the avatar url
5482      no user with matching public email address
5483        returns the avatar url from Gravatar
5484    avatar uploaded to Gravatar
5485      user with matching public email address
5486        returns the avatar url from Gravatar
5487      no user with matching public email address
5488        returns the avatar url from Gravatar
5489      public visibility level restricted
5490        when authenticated
5491          returns the avatar url
5492        when unauthenticated
5493          behaves like 403 response
5494            returns 403
5495UserCalloutsController
5496  POST #create
5497    with valid feature name
5498      when callout entry does not exist
5499        creates a callout entry with dismissed state
5500        returns success
5501      when callout entry already exists
5502        returns success
5503    with invalid feature name
5504      returns bad request
5505IssuableCollections
5506  #page_count_for_relation
5507    returns the number of pages
5508  #finder_options
5509    scalar params
5510      only allows whitelisted params
5511    array params
5512      only allows whitelisted params
5513    search using an issue iid
5514      mutates the search into a filter by iid
5515PasswordsController
5516  #check_password_authentication_available
5517    when password authentication is disabled for the web interface and Git
5518      prevents a password reset
5519    when reset email belongs to an ldap user
5520      prevents a password reset
5521MetricsController
5522  #index
5523    accessed from whitelisted ip
5524      behaves like endpoint providing metrics
5525        returns prometheus metrics
5526        prometheus metrics are disabled
5527          returns proper response
5528    accessed from ip in whitelisted range
5529      behaves like endpoint providing metrics
5530        returns prometheus metrics
5531        prometheus metrics are disabled
5532          returns proper response
5533    accessed from not whitelisted ip
5534      returns the expected error response
5535Admin::RequestsProfilesController
5536  #show
5537    when loading HTML profile
5538      renders the data
5539    when loading TXT profile
5540      renders the data
5541    when loading PDF profile
5542      fails to render the data
5543Knapsack report was generated. Preview:
5544{
5545  "spec/requests/api/commits_spec.rb": 193.44603776931763,
5546  "spec/requests/api/issues/get_project_issues_spec.rb": 95.22581338882446,
5547  "spec/requests/api/branches_spec.rb": 56.830987215042114,
5548  "spec/controllers/projects/notes_controller_spec.rb": 62.63071632385254,
5549  "spec/requests/lfs_http_spec.rb": 64.80097484588623,
5550  "spec/requests/api/graphql/mutations/notes/create/note_spec.rb": 41.004337549209595,
5551  "spec/requests/api/graphql/mutations/notes/create/image_diff_note_spec.rb": 36.18509030342102,
5552  "spec/requests/api/issues/issues_spec.rb": 40.65426421165466,
5553  "spec/controllers/boards/issues_controller_spec.rb": 39.53692269325256,
5554  "spec/requests/user_activity_spec.rb": 40.46977782249451,
5555  "spec/controllers/projects/branches_controller_spec.rb": 26.3683979511261,
5556  "spec/requests/api/graphql/mutations/notes/destroy_spec.rb": 17.50410532951355,
5557  "spec/requests/api/group_clusters_spec.rb": 19.153850317001343,
5558  "spec/requests/api/deployments_spec.rb": 20.344456911087036,
5559  "spec/controllers/projects/snippets_controller_spec.rb": 17.60285472869873,
5560  "spec/controllers/projects/merge_requests/conflicts_controller_spec.rb": 14.424451351165771,
5561  "spec/controllers/groups/children_controller_spec.rb": 15.09110951423645,
5562  "spec/requests/api/issues/put_projects_issues_spec.rb": 13.233471393585205,
5563  "spec/controllers/boards/lists_controller_spec.rb": 11.643041610717773,
5564  "spec/controllers/projects/compare_controller_spec.rb": 11.147966861724854,
5565  "spec/requests/api/award_emoji_spec.rb": 9.893916845321655,
5566  "spec/requests/api/pipeline_schedules_spec.rb": 9.294862747192383,
5567  "spec/requests/api/variables_spec.rb": 9.125801801681519,
5568  "spec/controllers/admin/services_controller_spec.rb": 9.0671968460083,
5569  "spec/controllers/groups/group_members_controller_spec.rb": 8.917916536331177,
5570  "spec/controllers/projects/commit_controller_spec.rb": 7.043969631195068,
5571  "spec/requests/api/protected_tags_spec.rb": 7.1480700969696045,
5572  "spec/controllers/admin/clusters_controller_spec.rb": 7.072968482971191,
5573  "spec/controllers/search_controller_spec.rb": 5.727646350860596,
5574  "spec/requests/api/project_snippets_spec.rb": 5.5096435546875,
5575  "spec/controllers/admin/application_settings_controller_spec.rb": 7.013131618499756,
5576  "spec/controllers/projects/deployments_controller_spec.rb": 5.437074661254883,
5577  "spec/controllers/application_controller_spec.rb": 7.062726974487305,
5578  "spec/controllers/projects/services_controller_spec.rb": 4.97827935218811,
5579  "spec/controllers/projects/badges_controller_spec.rb": 5.09835410118103,
5580  "spec/controllers/admin/users_controller_spec.rb": 4.867483854293823,
5581  "spec/requests/api/graphql/mutations/award_emojis/add_spec.rb": 4.332429647445679,
5582  "spec/requests/api/snippets_spec.rb": 4.4188055992126465,
5583  "spec/controllers/projects/tags/releases_controller_spec.rb": 3.4106247425079346,
5584  "spec/requests/api/namespaces_spec.rb": 4.209439992904663,
5585  "spec/requests/api/graphql/gitlab_schema_spec.rb": 2.9263272285461426,
5586  "spec/requests/api/graphql/project/tree/tree_spec.rb": 3.3810837268829346,
5587  "spec/controllers/projects/pages_controller_spec.rb": 3.051332950592041,
5588  "spec/controllers/groups/settings/ci_cd_controller_spec.rb": 2.23587965965271,
5589  "spec/controllers/explore/projects_controller_spec.rb": 2.4898500442504883,
5590  "spec/controllers/projects/find_file_controller_spec.rb": 2.2599356174468994,
5591  "spec/requests/api/group_container_repositories_spec.rb": 2.1391332149505615,
5592  "spec/requests/api/graphql/project/repository_spec.rb": 1.757697582244873,
5593  "spec/requests/api/graphql_spec.rb": 1.5789542198181152,
5594  "spec/requests/api/notification_settings_spec.rb": 2.072384834289551,
5595  "spec/controllers/admin/groups_controller_spec.rb": 1.1543326377868652,
5596  "spec/controllers/dashboard/labels_controller_spec.rb": 1.3497495651245117,
5597  "spec/requests/api/applications_spec.rb": 1.4878177642822266,
5598  "spec/controllers/projects/error_tracking_controller_spec.rb": 1.4154162406921387,
5599  "spec/requests/api/user_counts_spec.rb": 1.346041202545166,
5600  "spec/controllers/abuse_reports_controller_spec.rb": 0.7356417179107666,
5601  "spec/controllers/concerns/lfs_request_spec.rb": 1.1728384494781494,
5602  "spec/controllers/profiles/keys_controller_spec.rb": 0.8764121532440186,
5603  "spec/controllers/users/terms_controller_spec.rb": 1.0869405269622803,
5604  "spec/controllers/groups/labels_controller_spec.rb": 0.7336063385009766,
5605  "spec/controllers/projects/hooks_controller_spec.rb": 0.6804091930389404,
5606  "spec/controllers/import/fogbugz_controller_spec.rb": 0.6334593296051025,
5607  "spec/controllers/health_controller_spec.rb": 0.9367315769195557,
5608  "spec/controllers/admin/spam_logs_controller_spec.rb": 0.5570390224456787,
5609  "spec/mailers/abuse_report_mailer_spec.rb": 0.5365219116210938,
5610  "spec/controllers/instance_statistics/cohorts_controller_spec.rb": 0.4248955249786377,
5611  "spec/controllers/concerns/continue_params_spec.rb": 0.5502395629882812,
5612  "spec/requests/api/import_github_spec.rb": 0.38397884368896484,
5613  "spec/requests/api/avatar_spec.rb": 0.4005141258239746,
5614  "spec/controllers/user_callouts_controller_spec.rb": 0.3064556121826172,
5615  "spec/controllers/concerns/issuable_collections_spec.rb": 0.163466215133667,
5616  "spec/controllers/passwords_controller_spec.rb": 0.46517181396484375,
5617  "spec/controllers/metrics_controller_spec.rb": 0.04414772987365723,
5618  "spec/controllers/admin/requests_profiles_controller_spec.rb": 0.0633552074432373
5619}
5620Knapsack global time execution for tests: 16m 48s
5621Finished in 17 minutes 32 seconds (files took 45.59 seconds to load)
56221898 examples, 0 failures
5623$ date
5624Fri Aug 23 11:01:10 UTC 2019
 5625  Running after script...  
  00:01
5626$ date
5627Fri Aug 23 11:01:11 UTC 2019
 5628  Not uploading cache debian-stretch-ruby-2.6.3-node-12.x-2 due to policy  
  00:02
 5629  Uploading artifacts...  
  00:03
5630coverage/: found 5 matching files                  
5631knapsack/: found 5 matching files                  
5632rspec_flaky/: found 4 matching files               
5633rspec_profiling/: found 1 matching files           
5634WARNING: tmp/capybara/: no matching files          
5635tmp/memory_test/: found 2 matching files           
5636Uploading artifacts to coordinator... ok            id=278682957 responseStatus=201 Created token=DSEaCvxd
5637Uploading artifacts...
5638junit_rspec.xml: found 1 matching files            
5639Uploading artifacts to coordinator... ok            id=278682957 responseStatus=201 Created token=DSEaCvxd
5640Job succeeded
Tags: gitlab-org
Job artifacts
The artifacts were removed 5 years ago
Commit 4447c081
Automatic merge of gitlab-org/gitlab-ce master
Related jobs

rspec quarantine pg
rspec quarantine pg ee
cache gems
code_quality
db:check-schema-pg
db:migrate:reset-pg
db:rollback-pg
db:rollback-pg-geo
dependency_scanning
docs lint
gitlab:assets:compile
gitlab:setup-pg
gitlab_git_test
jest
karma
lint-ci-gitlab
memory-on-boot
memory-static
migration:path-pg
migration:upgrade-pg-ce-to-ee
qa-frontend-node:10
qa-frontend-node:8
qa-frontend-node:latest
qa:internal
qa:selectors
rspec geo pg ee 1/3
rspec geo pg ee 2/3
rspec geo pg ee 3/3
rspec geo pg-10 ee 1/3
rspec geo pg-10 ee 2/3
rspec geo pg-10 ee 3/3
rspec integration pg 1/6
rspec integration pg 2/6
rspec integration pg 3/6
rspec integration pg 4/6
rspec integration pg 5/6
rspec integration pg 6/6
rspec integration pg ee 1/3
rspec integration pg ee 2/3
rspec integration pg ee 3/3
rspec integration pg-10 1/6
rspec integration pg-10 2/6
rspec integration pg-10 3/6
rspec integration pg-10 4/6
rspec integration pg-10 5/6
rspec integration pg-10 6/6
rspec system pg 1/24
rspec system pg 10/24
rspec system pg 11/24
rspec system pg 12/24
rspec system pg 13/24
rspec system pg 14/24
rspec system pg 15/24
rspec system pg 16/24
rspec system pg 17/24
rspec system pg 18/24
rspec system pg 19/24
rspec system pg 2/24
rspec system pg 20/24
rspec system pg 21/24
rspec system pg 22/24
rspec system pg 23/24
rspec system pg 24/24
rspec system pg 3/24
rspec system pg 4/24
rspec system pg 5/24
rspec system pg 6/24
rspec system pg 7/24
rspec system pg 8/24
rspec system pg 9/24
rspec system pg ee 1/5
rspec system pg ee 2/5
rspec system pg ee 3/5
rspec system pg ee 4/5
rspec system pg ee 5/5
rspec system pg-10 1/24
rspec system pg-10 10/24
rspec system pg-10 11/24
rspec system pg-10 12/24
rspec system pg-10 13/24
rspec system pg-10 14/24
rspec system pg-10 15/24
rspec system pg-10 16/24
rspec system pg-10 17/24
rspec system pg-10 18/24
rspec system pg-10 19/24
rspec system pg-10 2/24
rspec system pg-10 20/24
rspec system pg-10 21/24
rspec system pg-10 22/24
rspec system pg-10 23/24
rspec system pg-10 24/24
rspec system pg-10 3/24
rspec system pg-10 4/24
rspec system pg-10 5/24
rspec system pg-10 6/24
rspec system pg-10 7/24
rspec system pg-10 8/24
rspec system pg-10 9/24
rspec unit pg 1/20
rspec unit pg 10/20
rspec unit pg 11/20
rspec unit pg 12/20
rspec unit pg 13/20
rspec unit pg 14/20
rspec unit pg 15/20
rspec unit pg 16/20
rspec unit pg 17/20
rspec unit pg 18/20
rspec unit pg 19/20
rspec unit pg 2/20
rspec unit pg 20/20
rspec unit pg 3/20
rspec unit pg 4/20
rspec unit pg 5/20
rspec unit pg 6/20
rspec unit pg 7/20
rspec unit pg 8/20
rspec unit pg 9/20
rspec unit pg ee 1/7
rspec unit pg ee 2/7
rspec unit pg ee 3/7
rspec unit pg ee 4/7
rspec unit pg ee 5/7
rspec unit pg ee 6/7
rspec unit pg ee 7/7
rspec unit pg-10 1/20
rspec unit pg-10 10/20
rspec unit pg-10 11/20
rspec unit pg-10 12/20
rspec unit pg-10 13/20
rspec unit pg-10 14/20
rspec unit pg-10 15/20
rspec unit pg-10 16/20
rspec unit pg-10 17/20
rspec unit pg-10 18/20
rspec unit pg-10 19/20
rspec unit pg-10 2/20
rspec unit pg-10 20/20
rspec unit pg-10 3/20
rspec unit pg-10 4/20
rspec unit pg-10 5/20
rspec unit pg-10 6/20
rspec unit pg-10 7/20
rspec unit pg-10 8/20
rspec unit pg-10 9/20
rspec-fast-spec-helper
sast
static-analysis
qa-frontend-node:8