· 5 years ago · Apr 23, 2020, 07:04 AM
1root@gitlab:/var/log/gitlab/nginx# gitlab-ctl reconfigure
2Starting Chef Client, version 14.14.29
3resolving cookbooks for run list: ["gitlab"]
4Synchronizing Cookbooks:
5 - gitlab (0.0.1)
6 - redis (0.1.0)
7 - package (0.1.0)
8 - registry (0.1.0)
9 - mattermost (0.1.0)
10 - postgresql (0.1.0)
11 - praefect (0.1.0)
12 - letsencrypt (0.1.0)
13 - nginx (0.1.0)
14 - runit (4.3.0)
15 - crond (0.1.0)
16 - monitoring (0.1.0)
17 - acme (4.1.1)
18 - consul (0.1.0)
19 - gitaly (0.1.0)
20Installing Cookbook Gems:
21Compiling Cookbooks...
22Recipe: gitlab::default
23 * directory[/etc/gitlab] action create (up to date)
24 Converging 286 resources
25 * directory[/etc/gitlab] action create (up to date)
26 * directory[Create /var/opt/gitlab] action create (up to date)
27 * directory[Create /var/log/gitlab] action create (up to date)
28 * directory[/opt/gitlab/embedded/etc] action create (up to date)
29 * template[/opt/gitlab/embedded/etc/gitconfig] action create
30 - update content in file /opt/gitlab/embedded/etc/gitconfig from e3db82 to 147a3a
31 --- /opt/gitlab/embedded/etc/gitconfig 2019-10-25 06:20:31.000000000 +0200
32 +++ /opt/gitlab/embedded/etc/.chef-gitconfig20200423-4545-10bwywv 2020-04-23 07:34:54.000000000 +0200
33 @@ -1,5 +1,6 @@
34 [pack]
35 threads = 1
36 +useSparse = true
37 [receive]
38 fsckObjects = true
39 advertisePushOptions = true
40 @@ -12,4 +13,6 @@
41 [core]
42 alternateRefsCommand="exit 0 #"
43 fsyncObjectFiles = true
44 +[fetch]
45 + writeCommitGraph = true
46Recipe: gitlab::web-server
47 * account[Webserver user and group] action create
48 * group[Webserver user and group] action create (up to date)
49 * linux_user[Webserver user and group] action create (up to date)
50 (up to date)
51Recipe: gitlab::users
52 * directory[/var/opt/gitlab] action create (up to date)
53 * account[GitLab user and group] action create
54 * group[GitLab user and group] action create (up to date)
55 * linux_user[GitLab user and group] action create (up to date)
56 (up to date)
57 * template[/var/opt/gitlab/.gitconfig] action create (up to date)
58 * directory[/var/opt/gitlab/.bundle] action create (up to date)
59Recipe: gitlab::gitlab-shell
60 * storage_directory[/var/opt/gitlab/.ssh] action create
61 * ruby_block[directory resource: /var/opt/gitlab/.ssh] action run (skipped due to not_if)
62 (up to date)
63 * directory[/var/log/gitlab/gitlab-shell/] action create (up to date)
64 * directory[/var/opt/gitlab/gitlab-shell] action create (up to date)
65 * templatesymlink[Create a config.yml and create a symlink to Rails root] action create
66 * template[/var/opt/gitlab/gitlab-shell/config.yml] action create (up to date)
67 * link[Link /opt/gitlab/embedded/service/gitlab-shell/config.yml to /var/opt/gitlab/gitlab-shell/config.yml] action create (up to date)
68 (up to date)
69 * link[/opt/gitlab/embedded/service/gitlab-shell/.gitlab_shell_secret] action create (up to date)
70 * file[/var/opt/gitlab/.ssh/authorized_keys] action create_if_missing (up to date)
71Recipe: gitlab::gitlab-rails
72 * storage_directory[/var/opt/gitlab/git-data] action create
73 * ruby_block[directory resource: /var/opt/gitlab/git-data] action run (skipped due to not_if)
74 (up to date)
75 * storage_directory[/var/opt/gitlab/git-data/repositories] action create
76 * ruby_block[directory resource: /var/opt/gitlab/git-data/repositories] action run (skipped due to not_if)
77 (up to date)
78 * storage_directory[/var/opt/gitlab/gitlab-rails/shared] action create
79 * ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared] action run (skipped due to not_if)
80 (up to date)
81 * storage_directory[/var/opt/gitlab/gitlab-rails/shared/artifacts] action create
82 * ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared/artifacts] action run (skipped due to not_if)
83 (up to date)
84 * storage_directory[/var/opt/gitlab/gitlab-rails/shared/external-diffs] action create
85 * ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared/external-diffs] action run (skipped due to not_if)
86 (up to date)
87 * storage_directory[/var/opt/gitlab/gitlab-rails/shared/lfs-objects] action create
88 * ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared/lfs-objects] action run (skipped due to not_if)
89 (up to date)
90 * storage_directory[/var/opt/gitlab/gitlab-rails/shared/packages] action create
91 * ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared/packages] action run (skipped due to not_if)
92 (up to date)
93 * storage_directory[/var/opt/gitlab/gitlab-rails/shared/dependency_proxy] action create
94 * ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared/dependency_proxy] action run (skipped due to not_if)
95 (up to date)
96 * storage_directory[/var/opt/gitlab/gitlab-rails/shared/terraform_state] action create
97 * ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared/terraform_state] action run
98 - execute the ruby block directory resource: /var/opt/gitlab/gitlab-rails/shared/terraform_state
99
100 * storage_directory[/var/opt/gitlab/gitlab-rails/uploads] action create
101 * ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/uploads] action run (skipped due to not_if)
102 (up to date)
103 * storage_directory[/var/opt/gitlab/gitlab-ci/builds] action create
104 * ruby_block[directory resource: /var/opt/gitlab/gitlab-ci/builds] action run (skipped due to not_if)
105 (up to date)
106 * storage_directory[/var/opt/gitlab/gitlab-rails/shared/cache] action create
107 * ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared/cache] action run (skipped due to not_if)
108 (up to date)
109 * storage_directory[/var/opt/gitlab/gitlab-rails/shared/tmp] action create
110 * ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared/tmp] action run (skipped due to not_if)
111 (up to date)
112 * storage_directory[/opt/gitlab/embedded/service/gitlab-rails/public] action create (skipped due to only_if)
113 * storage_directory[/var/opt/gitlab/gitlab-rails/shared/pages] action create
114 * ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared/pages] action run (skipped due to not_if)
115 (up to date)
116 * directory[create /var/opt/gitlab/gitlab-rails/etc] action create (up to date)
117 * directory[create /opt/gitlab/etc/gitlab-rails] action create (up to date)
118 * directory[create /var/opt/gitlab/gitlab-rails/working] action create (up to date)
119 * directory[create /var/opt/gitlab/gitlab-rails/tmp] action create (up to date)
120 * directory[create /var/opt/gitlab/gitlab-rails/upgrade-status] action create (up to date)
121 * directory[create /var/log/gitlab/gitlab-rails] action create (up to date)
122 * storage_directory[/var/opt/gitlab/backups] action create
123 * ruby_block[directory resource: /var/opt/gitlab/backups] action run (skipped due to not_if)
124 (up to date)
125 * directory[/var/opt/gitlab/gitlab-rails] action create (up to date)
126 * directory[/var/opt/gitlab/gitlab-ci] action create (up to date)
127 * file[/var/opt/gitlab/gitlab-rails/etc/gitlab-registry.key] action create (skipped due to only_if)
128 * template[/opt/gitlab/etc/gitlab-rails/gitlab-rails-rc] action create (up to date)
129 * file[/opt/gitlab/embedded/service/gitlab-rails/.secret] action delete (up to date)
130 * file[/var/opt/gitlab/gitlab-rails/etc/secret] action delete (up to date)
131 * templatesymlink[Create a database.yml and create a symlink to Rails root] action create
132 * template[/var/opt/gitlab/gitlab-rails/etc/database.yml] action create
133 - update content in file /var/opt/gitlab/gitlab-rails/etc/database.yml from 2c7239 to 7d65af
134 --- /var/opt/gitlab/gitlab-rails/etc/database.yml 2020-02-24 05:45:15.937968401 +0100
135 +++ /var/opt/gitlab/gitlab-rails/etc/.chef-database20200423-4545-12fn4vg.yml 2020-04-23 07:34:55.952077681 +0200
136 @@ -21,4 +21,6 @@
137 prepared_statements: false
138 statement_limit: 1000
139 fdw:
140 + variables:
141 + statement_timeout: 60000
142 * link[Link /opt/gitlab/embedded/service/gitlab-rails/config/database.yml to /var/opt/gitlab/gitlab-rails/etc/database.yml] action create (up to date)
143
144 * templatesymlink[Create a secrets.yml and create a symlink to Rails root] action create
145 * template[/var/opt/gitlab/gitlab-rails/etc/secrets.yml] action create (up to date)
146 * link[Link /opt/gitlab/embedded/service/gitlab-rails/config/secrets.yml to /var/opt/gitlab/gitlab-rails/etc/secrets.yml] action create (up to date)
147 (up to date)
148 * templatesymlink[Create a resque.yml and create a symlink to Rails root] action create
149 * template[/var/opt/gitlab/gitlab-rails/etc/resque.yml] action create (up to date)
150 * link[Link /opt/gitlab/embedded/service/gitlab-rails/config/resque.yml to /var/opt/gitlab/gitlab-rails/etc/resque.yml] action create (up to date)
151 (up to date)
152 * templatesymlink[Create a cable.yml and create a symlink to Rails root] action create
153 * template[/var/opt/gitlab/gitlab-rails/etc/cable.yml] action create
154 - create new file /var/opt/gitlab/gitlab-rails/etc/cable.yml
155 - update content in file /var/opt/gitlab/gitlab-rails/etc/cable.yml from none to 551667
156 --- /var/opt/gitlab/gitlab-rails/etc/cable.yml 2020-04-23 07:34:55.968078184 +0200
157 +++ /var/opt/gitlab/gitlab-rails/etc/.chef-cable20200423-4545-of41a1.yml 2020-04-23 07:34:55.968078184 +0200
158 @@ -1 +1,4 @@
159 +production:
160 + adapter: redis
161 + url: unix:/var/opt/gitlab/redis/redis.socket
162 - change mode from '' to '0644'
163 - change owner from '' to 'root'
164 - change group from '' to 'root'
165 * link[Link /opt/gitlab/embedded/service/gitlab-rails/config/cable.yml to /var/opt/gitlab/gitlab-rails/etc/cable.yml] action create
166 - create symlink at /opt/gitlab/embedded/service/gitlab-rails/config/cable.yml to /var/opt/gitlab/gitlab-rails/etc/cable.yml
167
168 * templatesymlink[Create a redis.cache.yml and create a symlink to Rails root] action create (skipped due to not_if)
169 * file[/opt/gitlab/embedded/service/gitlab-rails/config/redis.cache.yml] action delete (up to date)
170 * file[/var/opt/gitlab/gitlab-rails/etc/redis.cache.yml] action delete (up to date)
171 * templatesymlink[Create a redis.queues.yml and create a symlink to Rails root] action create (skipped due to not_if)
172 * file[/opt/gitlab/embedded/service/gitlab-rails/config/redis.queues.yml] action delete (up to date)
173 * file[/var/opt/gitlab/gitlab-rails/etc/redis.queues.yml] action delete (up to date)
174 * templatesymlink[Create a redis.shared_state.yml and create a symlink to Rails root] action create (skipped due to not_if)
175 * file[/opt/gitlab/embedded/service/gitlab-rails/config/redis.shared_state.yml] action delete (up to date)
176 * file[/var/opt/gitlab/gitlab-rails/etc/redis.shared_state.yml] action delete (up to date)
177 * templatesymlink[Create a smtp_settings.rb and create a symlink to Rails root] action delete
178 * file[/var/opt/gitlab/gitlab-rails/etc/smtp_settings.rb] action delete (up to date)
179 * link[/opt/gitlab/embedded/service/gitlab-rails/config/initializers/smtp_settings.rb] action delete (up to date)
180 (up to date)
181 * templatesymlink[Create a gitlab.yml and create a symlink to Rails root] action create
182 * template[/var/opt/gitlab/gitlab-rails/etc/gitlab.yml] action create
183 - update content in file /var/opt/gitlab/gitlab-rails/etc/gitlab.yml from 04ad62 to d91a35
184 --- /var/opt/gitlab/gitlab-rails/etc/gitlab.yml 2020-04-01 05:52:23.633628909 +0200
185 +++ /var/opt/gitlab/gitlab-rails/etc/.chef-gitlab20200423-4545-wxza65.yml 2020-04-23 07:34:55.980078562 +0200
186 @@ -221,6 +221,16 @@
187 remote_directory: "dependency_proxy"
188 connection: {}
189
190 + ## Terraform state
191 + terraform_state:
192 + enabled:
193 + # The location where terraform state files are stored (default: shared/terraform_state).
194 + storage_path: /var/opt/gitlab/gitlab-rails/shared/terraform_state
195 + object_store:
196 + enabled: false
197 + remote_directory: "terraform_state"
198 + connection: {}
199 +
200 ## Container Registry
201 registry:
202 enabled: false
203 * link[Link /opt/gitlab/embedded/service/gitlab-rails/config/gitlab.yml to /var/opt/gitlab/gitlab-rails/etc/gitlab.yml] action create (up to date)
204
205 * templatesymlink[Create a rack_attack.rb and create a symlink to Rails root] action create
206 * template[/var/opt/gitlab/gitlab-rails/etc/rack_attack.rb] action create (up to date)
207 * link[Link /opt/gitlab/embedded/service/gitlab-rails/config/initializers/rack_attack.rb to /var/opt/gitlab/gitlab-rails/etc/rack_attack.rb] action create (up to date)
208 (up to date)
209 * templatesymlink[Create a gitlab_workhorse_secret and create a symlink to Rails root] action create
210 * template[/var/opt/gitlab/gitlab-rails/etc/gitlab_workhorse_secret] action create (up to date)
211 * link[Link /opt/gitlab/embedded/service/gitlab-rails/.gitlab_workhorse_secret to /var/opt/gitlab/gitlab-rails/etc/gitlab_workhorse_secret] action create (up to date)
212 (up to date)
213 * templatesymlink[Create a gitlab_shell_secret and create a symlink to Rails root] action create
214 * template[/var/opt/gitlab/gitlab-rails/etc/gitlab_shell_secret] action create (up to date)
215 * link[Link /opt/gitlab/embedded/service/gitlab-rails/.gitlab_shell_secret to /var/opt/gitlab/gitlab-rails/etc/gitlab_shell_secret] action create (up to date)
216 (up to date)
217 * templatesymlink[Create a gitlab_pages_secret and create a symlink to Rails root] action create
218 * template[/var/opt/gitlab/gitlab-rails/etc/gitlab_pages_secret] action create (up to date)
219 * link[Link /opt/gitlab/embedded/service/gitlab-rails/.gitlab_pages_secret to /var/opt/gitlab/gitlab-rails/etc/gitlab_pages_secret] action create (up to date)
220 (up to date)
221 * link[/opt/gitlab/embedded/service/gitlab-rails/config/initializers/relative_url.rb] action delete (up to date)
222 * file[/var/opt/gitlab/gitlab-rails/etc/relative_url.rb] action delete (up to date)
223 * env_dir[/opt/gitlab/etc/gitlab-rails/env] action create
224 * directory[/opt/gitlab/etc/gitlab-rails/env] action create (up to date)
225 * file[/opt/gitlab/etc/gitlab-rails/env/HOME] action create (up to date)
226 * file[/opt/gitlab/etc/gitlab-rails/env/RAILS_ENV] action create (up to date)
227 * file[/opt/gitlab/etc/gitlab-rails/env/LD_PRELOAD] action create (up to date)
228 * file[/opt/gitlab/etc/gitlab-rails/env/SIDEKIQ_MEMORY_KILLER_MAX_RSS] action create (up to date)
229 * file[/opt/gitlab/etc/gitlab-rails/env/BUNDLE_GEMFILE] action create (up to date)
230 * file[/opt/gitlab/etc/gitlab-rails/env/PATH] action create (up to date)
231 * file[/opt/gitlab/etc/gitlab-rails/env/ICU_DATA] action create (up to date)
232 * file[/opt/gitlab/etc/gitlab-rails/env/PYTHONPATH] action create (up to date)
233 * file[/opt/gitlab/etc/gitlab-rails/env/EXECJS_RUNTIME] action create (up to date)
234 * file[/opt/gitlab/etc/gitlab-rails/env/TZ] action create (up to date)
235 (up to date)
236 * link[/opt/gitlab/embedded/service/gitlab-rails/tmp] action create (up to date)
237 * link[/opt/gitlab/embedded/service/gitlab-rails/public/uploads] action create (up to date)
238 * link[/opt/gitlab/embedded/service/gitlab-rails/log] action create (up to date)
239 * link[/var/log/gitlab/gitlab-rails/sidekiq.log] action create (skipped due to not_if)
240 * file[/opt/gitlab/embedded/service/gitlab-rails/db/structure.sql] action create
241 - change owner from 'root' to 'git'
242 * remote_file[/var/opt/gitlab/gitlab-rails/VERSION] action create
243 - update content in file /var/opt/gitlab/gitlab-rails/VERSION from 071cd8 to 598142
244 --- /var/opt/gitlab/gitlab-rails/VERSION 2020-04-21 05:34:18.410569631 +0200
245 +++ /var/opt/gitlab/gitlab-rails/.chef-VERSION20200423-4545-3y84la 2020-04-23 07:34:56.048080702 +0200
246 @@ -1,2 +1,2 @@
247 -12.9.4
248 +12.10.0
249 * remote_file[/var/opt/gitlab/gitlab-rails/REVISION] action create
250 - update content in file /var/opt/gitlab/gitlab-rails/REVISION from dd8c03 to 34dfeb
251 --- /var/opt/gitlab/gitlab-rails/REVISION 2020-04-21 05:34:18.438570395 +0200
252 +++ /var/opt/gitlab/gitlab-rails/.chef-REVISION20200423-4545-12ety4d 2020-04-23 07:34:56.052080827 +0200
253 @@ -1,2 +1,2 @@
254 -9d231b25b49
255 +869bc26464b
256 * file[/var/opt/gitlab/gitlab-rails/RUBY_VERSION] action create (up to date)
257 * execute[clear the gitlab-rails cache] action nothing (skipped due to action :nothing)
258 * file[/var/opt/gitlab/gitlab-rails/config.ru] action delete (up to date)
259Recipe: gitlab::selinux
260 * bash[Set proper security context on ssh files for selinux] action run (skipped due to only_if)
261Recipe: gitlab::add_trusted_certs
262 * directory[/etc/gitlab/trusted-certs] action create (up to date)
263 * directory[/opt/gitlab/embedded/ssl/certs] action create (up to date)
264 * file[/opt/gitlab/embedded/ssl/certs/README] action create (up to date)
265 * ruby_block[Move existing certs and link to /opt/gitlab/embedded/ssl/certs] action run
266
267 * Moving existing certificates found in /opt/gitlab/embedded/ssl/certs
268
269 * Symlinking existing certificates found in /etc/gitlab/trusted-certs
270
271 - execute the ruby block Move existing certs and link to /opt/gitlab/embedded/ssl/certs
272Recipe: gitlab::default
273 * service[create a temporary unicorn service] action nothing (skipped due to action :nothing)
274 * service[create a temporary puma service] action nothing (skipped due to action :nothing)
275 * service[create a temporary sidekiq service] action nothing (skipped due to action :nothing)
276 * service[create a temporary mailroom service] action nothing (skipped due to action :nothing)
277Recipe: package::runit_systemd
278 * directory[/usr/lib/systemd/system] action create (up to date)
279 * template[/usr/lib/systemd/system/gitlab-runsvdir.service] action create (up to date)
280 * file[/etc/systemd/system/default.target.wants/gitlab-runsvdir.service] action delete (up to date)
281 * file[/etc/systemd/system/basic.target.wants/gitlab-runsvdir.service] action delete (up to date)
282 * execute[systemctl daemon-reload] action nothing (skipped due to action :nothing)
283 * execute[systemctl enable gitlab-runsvdir] action nothing (skipped due to action :nothing)
284 * execute[systemctl start gitlab-runsvdir] action nothing (skipped due to action :nothing)
285Recipe: package::sysctl
286 * execute[reload all sysctl conf] action nothing (skipped due to action :nothing)
287Recipe: postgresql::bin
288 * ruby_block[check_postgresql_version] action run (skipped due to not_if)
289 * ruby_block[Link postgresql bin files to the correct version] action run (skipped due to only_if)
290Recipe: redis::enable
291 * account[user and group for redis] action create
292 * group[user and group for redis] action create (up to date)
293 * linux_user[user and group for redis] action create (up to date)
294 (up to date)
295 * group[Socket group] action create (up to date)
296 * directory[/var/opt/gitlab/redis] action create (up to date)
297 * directory[/var/log/gitlab/redis] action create (up to date)
298 * template[/var/opt/gitlab/redis/redis.conf] action create
299 - update content in file /var/opt/gitlab/redis/redis.conf from 0e485a to 06cf88
300 --- /var/opt/gitlab/redis/redis.conf 2019-08-23 06:19:20.843407480 +0200
301 +++ /var/opt/gitlab/redis/.chef-redis20200423-4545-hdwa6r.conf 2020-04-23 07:34:56.216085987 +0200
302 @@ -579,6 +579,55 @@
303 # maxmemory-samples 5
304 maxmemory-samples 5
305
306 +############################# LAZY FREEING ####################################
307 +
308 +# Redis has two primitives to delete keys. One is called DEL and is a blocking
309 +# deletion of the object. It means that the server stops processing new commands
310 +# in order to reclaim all the memory associated with an object in a synchronous
311 +# way. If the key deleted is associated with a small object, the time needed
312 +# in order to execute the DEL command is very small and comparable to most other
313 +# O(1) or O(log_N) commands in Redis. However if the key is associated with an
314 +# aggregated value containing millions of elements, the server can block for
315 +# a long time (even seconds) in order to complete the operation.
316 +#
317 +# For the above reasons Redis also offers non blocking deletion primitives
318 +# such as UNLINK (non blocking DEL) and the ASYNC option of FLUSHALL and
319 +# FLUSHDB commands, in order to reclaim memory in background. Those commands
320 +# are executed in constant time. Another thread will incrementally free the
321 +# object in the background as fast as possible.
322 +#
323 +# DEL, UNLINK and ASYNC option of FLUSHALL and FLUSHDB are user-controlled.
324 +# It's up to the design of the application to understand when it is a good
325 +# idea to use one or the other. However the Redis server sometimes has to
326 +# delete keys or flush the whole database as a side effect of other operations.
327 +# Specifically Redis deletes objects independently of a user call in the
328 +# following scenarios:
329 +#
330 +# 1) On eviction, because of the maxmemory and maxmemory policy configurations,
331 +# in order to make room for new data, without going over the specified
332 +# memory limit.
333 +# 2) Because of expire: when a key with an associated time to live (see the
334 +# EXPIRE command) must be deleted from memory.
335 +# 3) Because of a side effect of a command that stores data on a key that may
336 +# already exist. For example the RENAME command may delete the old key
337 +# content when it is replaced with another one. Similarly SUNIONSTORE
338 +# or SORT with STORE option may delete existing keys. The SET command
339 +# itself removes any old content of the specified key in order to replace
340 +# it with the specified string.
341 +# 4) During replication, when a replica performs a full resynchronization with
342 +# its master, the content of the whole database is removed in order to
343 +# load the RDB file just transferred.
344 +#
345 +# In all the above cases the default is to delete objects in a blocking way,
346 +# like if DEL was called. However you can configure each case specifically
347 +# in order to instead release memory in a non-blocking way like if UNLINK
348 +# was called, using the following configuration directives:
349 +
350 +lazyfree-lazy-eviction no
351 +lazyfree-lazy-expire no
352 +lazyfree-lazy-server-del no
353 +replica-lazy-flush no
354 +
355 ############################## APPEND ONLY MODE ###############################
356
357 # By default Redis asynchronously dumps the dataset on disk. This mode is
358 * runit_service[redis] action restart (up to date)
359Recipe: <Dynamically Defined Resource>
360 * service[redis] action nothing (skipped due to action :nothing)
361Recipe: redis::enable
362 * runit_service[redis] action enable
363 * ruby_block[restart_service] action nothing (skipped due to action :nothing)
364 * ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
365 * ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
366 * directory[/opt/gitlab/sv/redis] action create (up to date)
367 * template[/opt/gitlab/sv/redis/run] action create (up to date)
368 * directory[/opt/gitlab/sv/redis/log] action create (up to date)
369 * directory[/opt/gitlab/sv/redis/log/main] action create (up to date)
370 * template[/opt/gitlab/sv/redis/log/run] action create (up to date)
371 * template[/var/log/gitlab/redis/config] action create (up to date)
372 * ruby_block[verify_chown_persisted_on_redis] action nothing (skipped due to action :nothing)
373 * directory[/opt/gitlab/sv/redis/env] action create (up to date)
374 * ruby_block[Delete unmanaged env files for redis service] action run (skipped due to only_if)
375 * template[/opt/gitlab/sv/redis/check] action create (skipped due to only_if)
376 * template[/opt/gitlab/sv/redis/finish] action create (skipped due to only_if)
377 * directory[/opt/gitlab/sv/redis/control] action create (up to date)
378 * link[/opt/gitlab/init/redis] action create (up to date)
379 * file[/opt/gitlab/sv/redis/down] action delete (up to date)
380 * directory[/opt/gitlab/service] action create (up to date)
381 * link[/opt/gitlab/service/redis] action create (up to date)
382 * ruby_block[wait for redis service socket] action run (skipped due to not_if)
383 (up to date)
384 * ruby_block[warn pending redis restart] action run (skipped due to only_if)
385 * template[/opt/gitlab/etc/gitlab-redis-cli-rc] action create
386 - create new file /opt/gitlab/etc/gitlab-redis-cli-rc
387 - update content in file /opt/gitlab/etc/gitlab-redis-cli-rc from none to 44cac1
388 --- /opt/gitlab/etc/gitlab-redis-cli-rc 2020-04-23 07:34:57.000000000 +0200
389 +++ /opt/gitlab/etc/.chef-gitlab-redis-cli-rc20200423-4545-a468xk 2020-04-23 07:34:57.000000000 +0200
390 @@ -1 +1,5 @@
391 +redis_dir='/var/opt/gitlab/redis'
392 +redis_host='127.0.0.1'
393 +redis_port='0'
394 +redis_socket='/var/opt/gitlab/redis/redis.socket'
395 - change owner from '' to 'root'
396 - change group from '' to 'root'
397Recipe: gitaly::enable
398 * directory[/var/opt/gitlab/gitaly] action create (up to date)
399 * directory[/var/log/gitlab/gitaly] action create (up to date)
400 * directory[/var/opt/gitlab/gitaly/internal_sockets] action create (up to date)
401 * env_dir[/opt/gitlab/etc/gitaly/env] action create
402 * directory[/opt/gitlab/etc/gitaly/env] action create (up to date)
403 * file[/opt/gitlab/etc/gitaly/env/HOME] action create (up to date)
404 * file[/opt/gitlab/etc/gitaly/env/PATH] action create (up to date)
405 * file[/opt/gitlab/etc/gitaly/env/TZ] action create (up to date)
406 * file[/opt/gitlab/etc/gitaly/env/PYTHONPATH] action create (up to date)
407 * file[/opt/gitlab/etc/gitaly/env/ICU_DATA] action create (up to date)
408 * file[/opt/gitlab/etc/gitaly/env/SSL_CERT_DIR] action create (up to date)
409 * file[/opt/gitlab/etc/gitaly/env/GITALY_PID_FILE] action create (up to date)
410 * file[/opt/gitlab/etc/gitaly/env/WRAPPER_JSON_LOGGING] action create (up to date)
411 (up to date)
412 * template[Create Gitaly config.toml] action create (up to date)
413Recipe: <Dynamically Defined Resource>
414 * service[gitaly] action nothing (skipped due to action :nothing)
415Recipe: gitaly::enable
416 * runit_service[gitaly] action enable
417 * ruby_block[restart_service] action nothing (skipped due to action :nothing)
418 * ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
419 * ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
420 * directory[/opt/gitlab/sv/gitaly] action create (up to date)
421 * template[/opt/gitlab/sv/gitaly/run] action create (up to date)
422 * directory[/opt/gitlab/sv/gitaly/log] action create (up to date)
423 * directory[/opt/gitlab/sv/gitaly/log/main] action create (up to date)
424 * template[/opt/gitlab/sv/gitaly/log/run] action create (up to date)
425 * template[/var/log/gitlab/gitaly/config] action create (up to date)
426 * ruby_block[verify_chown_persisted_on_gitaly] action nothing (skipped due to action :nothing)
427 * directory[/opt/gitlab/sv/gitaly/env] action create (up to date)
428 * ruby_block[Delete unmanaged env files for gitaly service] action run (skipped due to only_if)
429 * template[/opt/gitlab/sv/gitaly/check] action create (skipped due to only_if)
430 * template[/opt/gitlab/sv/gitaly/finish] action create (skipped due to only_if)
431 * directory[/opt/gitlab/sv/gitaly/control] action create (up to date)
432 * link[/opt/gitlab/init/gitaly] action create (up to date)
433 * file[/opt/gitlab/sv/gitaly/down] action delete (up to date)
434 * directory[/opt/gitlab/service] action create (up to date)
435 * link[/opt/gitlab/service/gitaly] action create (up to date)
436 * ruby_block[wait for gitaly service socket] action run (skipped due to not_if)
437 (up to date)
438 * file[/var/opt/gitlab/gitaly/VERSION] action create
439 - update content in file /var/opt/gitlab/gitaly/VERSION from e78043 to 6de68d
440 --- /var/opt/gitlab/gitaly/VERSION 2020-04-21 05:34:18.862581979 +0200
441 +++ /var/opt/gitlab/gitaly/.chef-VERSION20200423-4545-1suyhk 2020-04-23 07:34:57.248118458 +0200
442 @@ -1,2 +1,2 @@
443 -Gitaly, version 12.9.4
444 +Gitaly, version 12.10.0-rc1-109-g66fd5d1b
445 * consul_service[gitaly] action delete
446 * file[/var/opt/gitlab/consul/config.d/gitaly-service.json] action delete (up to date)
447 (up to date)
448Recipe: <Dynamically Defined Resource>
449 * service[praefect] action nothing (skipped due to action :nothing)
450Recipe: praefect::disable
451 * runit_service[praefect] action disable
452 * ruby_block[disable praefect] action run (skipped due to only_if)
453 (up to date)
454 * consul_service[praefect] action delete
455 * file[/var/opt/gitlab/consul/config.d/praefect-service.json] action delete (up to date)
456 (up to date)
457Recipe: postgresql::user
458 * account[Postgresql user and group] action create
459 * group[Postgresql user and group] action create (up to date)
460 * linux_user[Postgresql user and group] action create (up to date)
461 (up to date)
462 * directory[/var/opt/gitlab/postgresql] action create (up to date)
463 * file[/var/opt/gitlab/postgresql/.profile] action create (up to date)
464Recipe: postgresql::enable
465 * directory[/var/opt/gitlab/postgresql] action create (up to date)
466 * directory[/var/opt/gitlab/postgresql/data] action create (up to date)
467 * directory[/var/log/gitlab/postgresql] action create (up to date)
468 * link[/var/opt/gitlab/postgresql/data] action create (skipped due to not_if)
469 * gitlab_sysctl[kernel.shmmax] action create
470 * directory[create /etc/sysctl.d for kernel.shmmax] action create (up to date)
471 * file[create /opt/gitlab/embedded/etc/90-omnibus-gitlab-kernel.shmmax.conf kernel.shmmax] action create (up to date)
472 * link[/etc/sysctl.d/90-omnibus-gitlab-kernel.shmmax.conf] action create (up to date)
473 * execute[load sysctl conf kernel.shmmax] action nothing (skipped due to action :nothing)
474 (up to date)
475 * gitlab_sysctl[kernel.shmall] action create
476 * directory[create /etc/sysctl.d for kernel.shmall] action create (up to date)
477 * file[create /opt/gitlab/embedded/etc/90-omnibus-gitlab-kernel.shmall.conf kernel.shmall] action create (up to date)
478 * link[/etc/sysctl.d/90-omnibus-gitlab-kernel.shmall.conf] action create (up to date)
479 * execute[load sysctl conf kernel.shmall] action nothing (skipped due to action :nothing)
480 (up to date)
481 * gitlab_sysctl[kernel.sem] action create
482 * directory[create /etc/sysctl.d for kernel.sem] action create (up to date)
483 * file[create /opt/gitlab/embedded/etc/90-omnibus-gitlab-kernel.sem.conf kernel.sem] action create (up to date)
484 * link[/etc/sysctl.d/90-omnibus-gitlab-kernel.sem.conf] action create (up to date)
485 * execute[load sysctl conf kernel.sem] action nothing (skipped due to action :nothing)
486 (up to date)
487 * execute[/opt/gitlab/embedded/bin/initdb -D /var/opt/gitlab/postgresql/data -E UTF8] action run (skipped due to not_if)
488 * file[/var/opt/gitlab/postgresql/data/server.crt] action create (up to date)
489 * file[/var/opt/gitlab/postgresql/data/server.key] action create (up to date)
490 * postgresql_config[gitlab] action create
491 * template[/var/opt/gitlab/postgresql/data/postgresql.conf] action create (up to date)
492 * template[/var/opt/gitlab/postgresql/data/runtime.conf] action create (up to date)
493 * template[/var/opt/gitlab/postgresql/data/pg_hba.conf] action create (up to date)
494 * template[/var/opt/gitlab/postgresql/data/pg_ident.conf] action create (up to date)
495 (up to date)
496Recipe: <Dynamically Defined Resource>
497 * service[postgresql] action nothing (skipped due to action :nothing)
498Recipe: postgresql::enable
499 * runit_service[postgresql] action enable
500 * ruby_block[restart_service] action nothing (skipped due to action :nothing)
501 * ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
502 * ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
503 * directory[/opt/gitlab/sv/postgresql] action create (up to date)
504 * template[/opt/gitlab/sv/postgresql/run] action create (up to date)
505 * directory[/opt/gitlab/sv/postgresql/log] action create (up to date)
506 * directory[/opt/gitlab/sv/postgresql/log/main] action create (up to date)
507 * template[/opt/gitlab/sv/postgresql/log/run] action create (up to date)
508 * template[/var/log/gitlab/postgresql/config] action create (up to date)
509 * ruby_block[verify_chown_persisted_on_postgresql] action nothing (skipped due to action :nothing)
510 * directory[/opt/gitlab/sv/postgresql/env] action create (up to date)
511 * ruby_block[Delete unmanaged env files for postgresql service] action run (skipped due to only_if)
512 * template[/opt/gitlab/sv/postgresql/check] action create (skipped due to only_if)
513 * template[/opt/gitlab/sv/postgresql/finish] action create (skipped due to only_if)
514 * directory[/opt/gitlab/sv/postgresql/control] action create (up to date)
515 * template[/opt/gitlab/sv/postgresql/control/t] action create (up to date)
516 * link[/opt/gitlab/init/postgresql] action create (up to date)
517 * file[/opt/gitlab/sv/postgresql/down] action delete (up to date)
518 * directory[/opt/gitlab/service] action create (up to date)
519 * link[/opt/gitlab/service/postgresql] action create (up to date)
520 * ruby_block[wait for postgresql service socket] action run (skipped due to not_if)
521 * directory[/opt/gitlab/service/postgresql/supervise] action create (up to date)
522 * directory[/opt/gitlab/service/postgresql/log/supervise] action create (up to date)
523 * file[/opt/gitlab/sv/postgresql/supervise/ok] action touch (skipped due to only_if)
524 * file[/opt/gitlab/sv/postgresql/log/supervise/ok] action touch (skipped due to only_if)
525 * file[/opt/gitlab/sv/postgresql/supervise/status] action touch
526 - change owner from 'root' to 'gitlab-psql'
527 - change group from 'root' to 'gitlab-psql'
528 - update utime on file /opt/gitlab/sv/postgresql/supervise/status
529 * file[/opt/gitlab/sv/postgresql/log/supervise/status] action touch (skipped due to only_if)
530 * file[/opt/gitlab/sv/postgresql/supervise/control] action touch (skipped due to only_if)
531 * file[/opt/gitlab/sv/postgresql/log/supervise/control] action touch (skipped due to only_if)
532
533 * template[/opt/gitlab/etc/gitlab-psql-rc] action create (up to date)
534 * postgresql_user[gitlab] action create
535 * execute[create gitlab postgresql user] action run (skipped due to not_if)
536 (up to date)
537 * execute[create gitlabhq_production database] action run (skipped due to not_if)
538 * postgresql_user[gitlab_replicator] action create
539 * execute[create gitlab_replicator postgresql user] action run (skipped due to not_if)
540 * execute[set options for gitlab_replicator postgresql user] action run (skipped due to not_if)
541 (up to date)
542 * postgresql_extension[pg_trgm] action enable
543 * postgresql_query[enable pg_trgm extension] action run (skipped due to only_if)
544 (up to date)
545 * ruby_block[warn pending postgresql restart] action run (skipped due to only_if)
546 * execute[reload postgresql] action nothing (skipped due to action :nothing)
547 * execute[start postgresql] action nothing (skipped due to action :nothing)
548Recipe: gitlab::database_migrations
549 * bash[migrate gitlab-rails database] action run
550 [execute] == 20200204131831 CreateDailyReportResults: migrating =========================
551 -- create_table(:ci_daily_report_results)
552 -> 1.1399s
553 == 20200204131831 CreateDailyReportResults: migrated (1.1399s) ================
554
555 == 20200213100530 AddVerificationColumnsToPackages: migrating =================
556 -- add_column(:packages_package_files, :verification_retry_at, :datetime_with_timezone)
557 -> 0.0125s
558 -- add_column(:packages_package_files, :verified_at, :datetime_with_timezone)
559 -> 0.0274s
560 -- add_column(:packages_package_files, :verification_checksum, :string, {:limit=>255})
561 -> 0.0007s
562 -- add_column(:packages_package_files, :verification_failure, :string, {:limit=>255})
563 -> 0.0006s
564 -- add_column(:packages_package_files, :verification_retry_count, :integer)
565 -> 0.0005s
566 == 20200213100530 AddVerificationColumnsToPackages: migrated (0.0420s) ========
567
568 == 20200214025454 AddCanonicalEmails: migrating ===============================
569 -- create_table(:user_canonical_emails)
570 -> 0.0669s
571 -- add_index(:user_canonical_emails, [:user_id, :canonical_email], {:unique=>true})
572 -> 0.0073s
573 -- add_index(:user_canonical_emails, :user_id, {:unique=>true})
574 -> 0.0093s
575 == 20200214025454 AddCanonicalEmails: migrated (0.0915s) ======================
576
577 == 20200219135440 AddLimitMetricTypeToList: migrating =========================
578 -- add_column(:lists, :limit_metric, :string, {:limit=>20})
579 -> 0.0129s
580 == 20200219135440 AddLimitMetricTypeToList: migrated (0.0130s) ================
581
582 == 20200220115023 FixProjectsWithoutPrometheusService: migrating ==============
583 == 20200220115023 FixProjectsWithoutPrometheusService: migrated (0.1181s) =====
584
585 == 20200226124757 RemoveHealthStatusFromEpics: migrating ======================
586 -- remove_column(:epics, :health_status)
587 -> 0.1239s
588 == 20200226124757 RemoveHealthStatusFromEpics: migrated (0.1256s) =============
589
590 == 20200302152516 AddWikiSlug: migrating ======================================
591 -- create_table(:wiki_page_meta, {:id=>:serial})
592 -> 0.2131s
593 -- create_table(:wiki_page_slugs, {:id=>:serial})
594 -> 0.1229s
595 == 20200302152516 AddWikiSlug: migrated (0.3362s) =============================
596
597 == 20200303181648 AddHealthyToClustersApplicationsPrometheus: migrating =======
598 -- add_column(:clusters_applications_prometheus, :healthy, :boolean)
599 -> 0.0344s
600 == 20200303181648 AddHealthyToClustersApplicationsPrometheus: migrated (0.0345s)
601
602 == 20200304124406 AddUnlockMembershipToLdapOfGroups: migrating ================
603 -- add_column(:namespaces, :unlock_membership_to_ldap, :boolean)
604 -> 0.0753s
605 == 20200304124406 AddUnlockMembershipToLdapOfGroups: migrated (0.0780s) =======
606
607 == 20200305200641 CreateTerraformStates: migrating ============================
608 -- create_table(:terraform_states)
609 -> 0.0167s
610 == 20200305200641 CreateTerraformStates: migrated (0.0167s) ===================
611
612 == 20200311074438 MigrateBotTypeToUserType: migrating =========================
613 -- execute("UPDATE users SET user_type = bot_type WHERE bot_type IS NOT NULL AND user_type IS NULL")
614 -> 0.0097s
615 == 20200311074438 MigrateBotTypeToUserType: migrated (0.0098s) ================
616
617 == 20200311082301 AddUserStateIndex: migrating ================================
618 -- transaction_open?()
619 -> 0.0000s
620 -- index_exists?(:users, [:state, :user_type], {:where=>"ghost IS NOT TRUE", :name=>"index_users_on_state_and_user_type_internal", :algorithm=>:concurrently})
621 -> 0.0121s
622 -- execute("SET statement_timeout TO 0")
623 -> 0.0002s
624 -- add_index(:users, [:state, :user_type], {:where=>"ghost IS NOT TRUE", :name=>"index_users_on_state_and_user_type_internal", :algorithm=>:concurrently})
625 -> 0.0086s
626 -- execute("RESET ALL")
627 -> 0.0002s
628 -- transaction_open?()
629 -> 0.0000s
630 -- indexes(:users)
631 -> 0.0091s
632 -- execute("SET statement_timeout TO 0")
633 -> 0.0002s
634 -- remove_index(:users, {:algorithm=>:concurrently, :name=>"index_users_on_state_and_internal_ee"})
635 -> 0.0630s
636 -- execute("RESET ALL")
637 -> 0.0003s
638 -- transaction_open?()
639 -> 0.0000s
640 -- indexes(:users)
641 -> 0.0109s
642 -- execute("SET statement_timeout TO 0")
643 -> 0.0002s
644 -- remove_index(:users, {:algorithm=>:concurrently, :name=>"index_users_on_state_and_internal"})
645 -> 0.0085s
646 -- execute("RESET ALL")
647 -> 0.0002s
648 == 20200311082301 AddUserStateIndex: migrated (0.1144s) =======================
649
650 == 20200311130802 SchedulePopulateUserHighestRolesTable: migrating ============
651 == 20200311130802 SchedulePopulateUserHighestRolesTable: migrated (0.0564s) ===
652
653 == 20200311154110 CreateVulnerabilityExports: migrating =======================
654 -- create_table(:vulnerability_exports)
655 -> 0.0198s
656 == 20200311154110 CreateVulnerabilityExports: migrated (0.0198s) ==============
657
658 == 20200311214912 AddModsecurityModeToIngressApplication: migrating ===========
659 -- transaction_open?()
660 -> 0.0000s
661 -- execute("SET statement_timeout TO 0")
662 -> 0.0002s
663 -- transaction()
664 -- add_column(:clusters_applications_ingress, :modsecurity_mode, :smallint, {:default=>nil})
665 -> 0.0050s
666 -- change_column_default(:clusters_applications_ingress, :modsecurity_mode, 0)
667 -> 0.0024s
668 -> 0.0092s
669 -- columns(:clusters_applications_ingress)
670 -> 0.0025s
671 -- transaction_open?()
672 -> 0.0000s
673 -- exec_query("SELECT COUNT(*) AS count FROM \"clusters_applications_ingress\"")
674 -> 0.0474s
675 -- change_column_null(:clusters_applications_ingress, :modsecurity_mode, false)
676 -> 0.0013s
677 -- execute("RESET ALL")
678 -> 0.0003s
679 == 20200311214912 AddModsecurityModeToIngressApplication: migrated (0.0616s) ==
680
681 == 20200312053852 PopulateCanonicalEmails: migrating ==========================
682 == 20200312053852 PopulateCanonicalEmails: migrated (0.0071s) =================
683
684 == 20200312125121 AddIndexOnActiveAndTemplateAndTypeAndIdToServices: migrating
685 -- transaction_open?()
686 -> 0.0000s
687 -- index_exists?(:services, [:type, :id, :template], {:where=>"active = TRUE", :name=>"index_services_on_type_and_id_and_template_when_active", :algorithm=>:concurrently})
688 -> 0.0029s
689 -- execute("SET statement_timeout TO 0")
690 -> 0.0002s
691 -- add_index(:services, [:type, :id, :template], {:where=>"active = TRUE", :name=>"index_services_on_type_and_id_and_template_when_active", :algorithm=>:concurrently})
692 -> 0.2248s
693 -- execute("RESET ALL")
694 -> 0.0003s
695 == 20200312125121 AddIndexOnActiveAndTemplateAndTypeAndIdToServices: migrated (0.2284s)
696
697 == 20200312160532 AddIndexOnMirrorAndIdToProjects: migrating ==================
698 -- transaction_open?()
699 -> 0.0000s
700 -- index_exists?(:projects, :id, {:where=>"mirror = TRUE AND mirror_trigger_builds = TRUE", :name=>"index_projects_on_mirror_id_where_mirror_and_trigger_builds", :algorithm=>:concurrently})
701 -> 0.0240s
702 -- execute("SET statement_timeout TO 0")
703 -> 0.0002s
704 -- add_index(:projects, :id, {:where=>"mirror = TRUE AND mirror_trigger_builds = TRUE", :name=>"index_projects_on_mirror_id_where_mirror_and_trigger_builds", :algorithm=>:concurrently})
705 -> 0.0109s
706 -- execute("RESET ALL")
707 -> 0.0002s
708 -- transaction_open?()
709 -> 0.0000s
710 -- indexes(:projects)
711 -> 0.0164s
712 -- execute("SET statement_timeout TO 0")
713 -> 0.0002s
714 -- remove_index(:projects, {:algorithm=>:concurrently, :name=>"index_projects_on_mirror_and_mirror_trigger_builds_both_true"})
715 -> 0.1762s
716 -- execute("RESET ALL")
717 -> 0.0010s
718 == 20200312160532 AddIndexOnMirrorAndIdToProjects: migrated (0.2297s) =========
719
720 == 20200313101649 FillGhostUserType: migrating ================================
721 -- execute("UPDATE users SET user_type = 5 WHERE ghost IS TRUE AND user_type IS NULL")
722 -> 0.0012s
723 == 20200313101649 FillGhostUserType: migrated (0.0013s) =======================
724
725 == 20200313202430 AddIndexChatNameServiceId: migrating ========================
726 -- transaction_open?()
727 -> 0.0000s
728 -- index_exists?(:chat_names, :service_id, {:algorithm=>:concurrently})
729 -> 0.0021s
730 -- execute("SET statement_timeout TO 0")
731 -> 0.0002s
732 -- add_index(:chat_names, :service_id, {:algorithm=>:concurrently})
733 -> 0.0299s
734 -- execute("RESET ALL")
735 -> 0.0003s
736 == 20200313202430 AddIndexChatNameServiceId: migrated (0.0328s) ===============
737
738 == 20200313203525 AddInvalidForeignKeyFromChatNameToService: migrating ========
739 -- transaction_open?()
740 -> 0.0000s
741 -- foreign_keys(:chat_names)
742 -> 0.0083s
743 -- execute("ALTER TABLE chat_names\nADD CONSTRAINT fk_00797a2bf9\nFOREIGN KEY (service_id)\nREFERENCES services (id)\nON DELETE CASCADE\nNOT VALID;\n")
744 -> 0.0016s
745 == 20200313203525 AddInvalidForeignKeyFromChatNameToService: migrated (0.0138s)
746
747 == 20200313203550 RemoveOrphanedChatNames: migrating ==========================
748 -- execute("DELETE FROM chat_names WHERE service_id NOT IN(SELECT id FROM services WHERE services.type = 'chat')")
749 -> 0.0651s
750 == 20200313203550 RemoveOrphanedChatNames: migrated (0.0652s) =================
751
752 == 20200313204021 ValidateForeignKeyFromChatNameToService: migrating ==========
753 -- foreign_keys(:chat_names)
754 -> 0.0687s
755 -- execute("SET statement_timeout TO 0")
756 -> 0.0004s
757 -- execute("ALTER TABLE chat_names VALIDATE CONSTRAINT fk_00797a2bf9;")
758 -> 0.0013s
759 -- execute("RESET ALL")
760 -> 0.0003s
761 == 20200313204021 ValidateForeignKeyFromChatNameToService: migrated (0.0710s) =
762
763 == 20200314060834 AddScannedResourcesCountToSecurityScan: migrating ===========
764 -- add_column(:security_scans, :scanned_resources_count, :integer)
765 -> 0.0376s
766 == 20200314060834 AddScannedResourcesCountToSecurityScan: migrated (0.0377s) ==
767
768 == 20200316111759 AddIndexOnIdAndLdapKeyToKeys: migrating =====================
769 -- transaction_open?()
770 -> 0.0000s
771 -- index_exists?(:keys, [:id], {:where=>"type = 'LDAPKey'", :name=>"index_keys_on_id_and_ldap_key_type", :algorithm=>:concurrently})
772 -> 0.0044s
773 -- execute("SET statement_timeout TO 0")
774 -> 0.0002s
775 -- add_index(:keys, [:id], {:where=>"type = 'LDAPKey'", :name=>"index_keys_on_id_and_ldap_key_type", :algorithm=>:concurrently})
776 -> 0.0650s
777 -- execute("RESET ALL")
778 -> 0.0003s
779 == 20200316111759 AddIndexOnIdAndLdapKeyToKeys: migrated (0.0703s) ============
780
781 == 20200316162648 AddIndexOnNamespaceIdAndIdToProjects: migrating =============
782 -- transaction_open?()
783 -> 0.0000s
784 -- index_exists?(:projects, [:namespace_id, :id], {:algorithm=>:concurrently})
785 -> 0.0243s
786 -- execute("SET statement_timeout TO 0")
787 -> 0.0002s
788 -- add_index(:projects, [:namespace_id, :id], {:algorithm=>:concurrently})
789 -> 0.0316s
790 -- execute("RESET ALL")
791 -> 0.0003s
792 -- transaction_open?()
793 -> 0.0000s
794 -- index_exists?(:projects, :namespace_id, {:algorithm=>:concurrently})
795 -> 0.0290s
796 -- execute("SET statement_timeout TO 0")
797 -> 0.0002s
798 -- remove_index(:projects, {:algorithm=>:concurrently, :column=>:namespace_id})
799 -> 0.0268s
800 -- execute("RESET ALL")
801 -> 0.0002s
802 == 20200316162648 AddIndexOnNamespaceIdAndIdToProjects: migrated (0.1131s) ====
803
804 == 20200316173312 AddVulnerabilityExportProjectForeignKey: migrating ==========
805 -- add_foreign_key(:vulnerability_exports, :projects, {:column=>:project_id, :on_delete=>:cascade, :index=>false})
806 -> 0.0017s
807 == 20200316173312 AddVulnerabilityExportProjectForeignKey: migrated (0.0040s) =
808
809 == 20200317110602 AddMigratingUserHighestRolesTableIndexToUsers: migrating ====
810 -- transaction_open?()
811 -> 0.0000s
812 -- index_exists?(:users, :id, {:where=>"state = 'active' AND user_type IS NULL AND bot_type IS NULL AND ghost IS NOT TRUE", :name=>"index_for_migrating_user_highest_roles_table", :algorithm=>:concurrently})
813 -> 0.0072s
814 -- execute("SET statement_timeout TO 0")
815 -> 0.0002s
816 -- add_index(:users, :id, {:where=>"state = 'active' AND user_type IS NULL AND bot_type IS NULL AND ghost IS NOT TRUE", :name=>"index_for_migrating_user_highest_roles_table", :algorithm=>:concurrently})
817 -> 0.0121s
818 -- execute("RESET ALL")
819 -> 0.0002s
820 == 20200317110602 AddMigratingUserHighestRolesTableIndexToUsers: migrated (0.0199s)
821
822 == 20200317142110 AddVulnerabilityExportUserForeignKey: migrating =============
823 -- add_foreign_key(:vulnerability_exports, :users, {:column=>:author_id, :on_delete=>:cascade, :index=>false})
824 -> 0.0072s
825 == 20200317142110 AddVulnerabilityExportUserForeignKey: migrated (0.0116s) ====
826
827 == 20200318140400 CreateVulnerabilityUserMentions: migrating ==================
828 -- create_table(:vulnerability_user_mentions)
829 -> 0.0535s
830 -- add_index(:vulnerability_user_mentions, [:vulnerability_id], {:where=>"note_id is null", :unique=>true, :name=>"index_vulns_user_mentions_on_vulnerability_id"})
831 -> 0.0066s
832 -- add_index(:vulnerability_user_mentions, [:vulnerability_id, :note_id], {:unique=>true, :name=>"index_vulns_user_mentions_on_vulnerability_id_and_note_id"})
833 -> 0.0076s
834 == 20200318140400 CreateVulnerabilityUserMentions: migrated (0.0678s) =========
835
836 == 20200318152134 AddsSha256ToPackageFiles: migrating =========================
837 -- add_column(:packages_package_files, :file_sha256, :binary)
838 -> 0.0007s
839 == 20200318152134 AddsSha256ToPackageFiles: migrated (0.0008s) ================
840
841 == 20200318162148 AddExternalKeyToIssuesTable: migrating ======================
842 -- add_column(:issues, :external_key, :string, {:limit=>255})
843 -> 0.0064s
844 == 20200318162148 AddExternalKeyToIssuesTable: migrated (0.0080s) =============
845
846 == 20200318163148 AddIndexOnExternalKeyToIssuesTable: migrating ===============
847 -- transaction_open?()
848 -> 0.0000s
849 -- index_exists?(:issues, [:project_id, :external_key], {:unique=>true, :where=>"external_key IS NOT NULL", :algorithm=>:concurrently})
850 -> 0.0098s
851 -- execute("SET statement_timeout TO 0")
852 -> 0.0003s
853 -- add_index(:issues, [:project_id, :external_key], {:unique=>true, :where=>"external_key IS NOT NULL", :algorithm=>:concurrently})
854 -> 2.4910s
855 -- execute("RESET ALL")
856 -> 0.0002s
857 == 20200318163148 AddIndexOnExternalKeyToIssuesTable: migrated (2.5015s) ======
858
859 == 20200318164448 AddExternalKeyToEpicsTable: migrating =======================
860 -- add_column(:epics, :external_key, :string, {:limit=>255})
861 -> 0.0006s
862 == 20200318164448 AddExternalKeyToEpicsTable: migrated (0.0017s) ==============
863
864 == 20200318165448 AddIndexOnExternalKeyToEpicsTable: migrating ================
865 -- transaction_open?()
866 -> 0.0000s
867 -- index_exists?(:epics, [:group_id, :external_key], {:unique=>true, :where=>"external_key IS NOT NULL", :algorithm=>:concurrently})
868 -> 0.0061s
869 -- execute("SET statement_timeout TO 0")
870 -> 0.0001s
871 -- add_index(:epics, [:group_id, :external_key], {:unique=>true, :where=>"external_key IS NOT NULL", :algorithm=>:concurrently})
872 -> 0.0072s
873 -- execute("RESET ALL")
874 -> 0.0001s
875 == 20200318165448 AddIndexOnExternalKeyToEpicsTable: migrated (0.0137s) =======
876
877 == 20200318175008 AddIndexOnIdAndArchivedAndPendingDeleteToProjects: migrating
878 -- transaction_open?()
879 -> 0.0000s
880 -- index_exists?(:projects, :id, {:where=>"archived = FALSE AND pending_delete = FALSE", :name=>"index_projects_on_id_and_archived_and_pending_delete", :algorithm=>:concurrently})
881 -> 0.0129s
882 -- execute("SET statement_timeout TO 0")
883 -> 0.0001s
884 -- add_index(:projects, :id, {:where=>"archived = FALSE AND pending_delete = FALSE", :name=>"index_projects_on_id_and_archived_and_pending_delete", :algorithm=>:concurrently})
885 -> 0.0073s
886 -- execute("RESET ALL")
887 -> 0.0001s
888 == 20200318175008 AddIndexOnIdAndArchivedAndPendingDeleteToProjects: migrated (0.0206s)
889
890 == 20200318183553 CreatePypiPackageMetadata: migrating ========================
891 -- create_table(:packages_pypi_metadata, {:id=>false})
892 -> 0.0179s
893 == 20200318183553 CreatePypiPackageMetadata: migrated (0.0179s) ===============
894
895 == 20200319071702 ConsumeRemainingLinkLfsObjectsProjectsJobs: migrating =======
896 == 20200319071702 ConsumeRemainingLinkLfsObjectsProjectsJobs: migrated (0.0013s)
897
898 == 20200319123041 UpdatePlanLimitsDefaults: migrating =========================
899 -- change_column_default(:plan_limits, :project_hooks, 100)
900 -> 0.0425s
901 -- change_column_default(:plan_limits, :group_hooks, 50)
902 -> 0.0040s
903 -- change_column_default(:plan_limits, :ci_project_subscriptions, 2)
904 -> 0.0032s
905 -- change_column_default(:plan_limits, :ci_pipeline_schedules, 10)
906 -> 0.0040s
907 == 20200319123041 UpdatePlanLimitsDefaults: migrated (0.0540s) ================
908
909 == 20200319124127 CreateMetricsDashboardAnnotations: migrating ================
910 -- create_table(:metrics_dashboard_annotations)
911 -> 0.0532s
912 == 20200319124127 CreateMetricsDashboardAnnotations: migrated (0.0532s) =======
913
914 == 20200319203901 AddIndexOnUsersUnlockToken: migrating =======================
915 -- transaction_open?()
916 -> 0.0000s
917 -- index_exists?(:users, :unlock_token, {:unique=>true, :name=>"index_users_on_unlock_token", :algorithm=>:concurrently})
918 -> 0.0138s
919 -- execute("SET statement_timeout TO 0")
920 -> 0.0002s
921 -- add_index(:users, :unlock_token, {:unique=>true, :name=>"index_users_on_unlock_token", :algorithm=>:concurrently})
922 -> 0.0078s
923 -- execute("RESET ALL")
924 -> 0.0002s
925 == 20200319203901 AddIndexOnUsersUnlockToken: migrated (0.0223s) ==============
926
927 == 20200320112455 AddCostFactorFiledsToCiRunners: migrating ===================
928 -- transaction_open?()
929 -> 0.0000s
930 -- execute("SET statement_timeout TO 0")
931 -> 0.0003s
932 -- transaction()
933 -- add_column(:ci_runners, :public_projects_minutes_cost_factor, :float, {:default=>nil})
934 -> 0.0369s
935 -- change_column_default(:ci_runners, :public_projects_minutes_cost_factor, 0.0)
936 -> 0.0043s
937 -> 0.0766s
938 -- columns(:ci_runners)
939 -> 0.0054s
940 -- transaction_open?()
941 -> 0.0000s
942 -- exec_query("SELECT COUNT(*) AS count FROM \"ci_runners\"")
943 -> 0.0013s
944 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1")
945 -> 0.0007s
946 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 58 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
947 -> 0.0006s
948 -- execute("UPDATE \"ci_runners\" SET \"public_projects_minutes_cost_factor\" = 0.0 WHERE \"ci_runners\".\"id\" >= 58 AND \"ci_runners\".\"id\" < 70")
949 -> 0.0015s
950 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 70 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
951 -> 0.0005s
952 -- execute("UPDATE \"ci_runners\" SET \"public_projects_minutes_cost_factor\" = 0.0 WHERE \"ci_runners\".\"id\" >= 70 AND \"ci_runners\".\"id\" < 75")
953 -> 0.0024s
954 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 75 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
955 -> 0.0005s
956 -- execute("UPDATE \"ci_runners\" SET \"public_projects_minutes_cost_factor\" = 0.0 WHERE \"ci_runners\".\"id\" >= 75 AND \"ci_runners\".\"id\" < 80")
957 -> 0.0010s
958 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 80 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
959 -> 0.0004s
960 -- execute("UPDATE \"ci_runners\" SET \"public_projects_minutes_cost_factor\" = 0.0 WHERE \"ci_runners\".\"id\" >= 80 AND \"ci_runners\".\"id\" < 128")
961 -> 0.0009s
962 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 128 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
963 -> 0.0004s
964 -- execute("UPDATE \"ci_runners\" SET \"public_projects_minutes_cost_factor\" = 0.0 WHERE \"ci_runners\".\"id\" >= 128 AND \"ci_runners\".\"id\" < 130")
965 -> 0.0009s
966 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 130 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
967 -> 0.0004s
968 -- execute("UPDATE \"ci_runners\" SET \"public_projects_minutes_cost_factor\" = 0.0 WHERE \"ci_runners\".\"id\" >= 130 AND \"ci_runners\".\"id\" < 233")
969 -> 0.0009s
970 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 233 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
971 -> 0.0005s
972 -- execute("UPDATE \"ci_runners\" SET \"public_projects_minutes_cost_factor\" = 0.0 WHERE \"ci_runners\".\"id\" >= 233 AND \"ci_runners\".\"id\" < 337")
973 -> 0.0011s
974 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 337 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
975 -> 0.0005s
976 -- execute("UPDATE \"ci_runners\" SET \"public_projects_minutes_cost_factor\" = 0.0 WHERE \"ci_runners\".\"id\" >= 337 AND \"ci_runners\".\"id\" < 388")
977 -> 0.0010s
978 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 388 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
979 -> 0.0005s
980 -- execute("UPDATE \"ci_runners\" SET \"public_projects_minutes_cost_factor\" = 0.0 WHERE \"ci_runners\".\"id\" >= 388 AND \"ci_runners\".\"id\" < 392")
981 -> 0.0013s
982 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 392 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
983 -> 0.0005s
984 -- execute("UPDATE \"ci_runners\" SET \"public_projects_minutes_cost_factor\" = 0.0 WHERE \"ci_runners\".\"id\" >= 392 AND \"ci_runners\".\"id\" < 394")
985 -> 0.0015s
986 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 394 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
987 -> 0.0005s
988 -- execute("UPDATE \"ci_runners\" SET \"public_projects_minutes_cost_factor\" = 0.0 WHERE \"ci_runners\".\"id\" >= 394 AND \"ci_runners\".\"id\" < 398")
989 -> 0.0010s
990 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 398 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
991 -> 0.0004s
992 -- execute("UPDATE \"ci_runners\" SET \"public_projects_minutes_cost_factor\" = 0.0 WHERE \"ci_runners\".\"id\" >= 398 AND \"ci_runners\".\"id\" < 400")
993 -> 0.0010s
994 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 400 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
995 -> 0.0005s
996 -- execute("UPDATE \"ci_runners\" SET \"public_projects_minutes_cost_factor\" = 0.0 WHERE \"ci_runners\".\"id\" >= 400")
997 -> 0.0010s
998 -- change_column_null(:ci_runners, :public_projects_minutes_cost_factor, false)
999 -> 0.0009s
1000 -- execute("RESET ALL")
1001 -> 0.0002s
1002 -- transaction_open?()
1003 -> 0.0000s
1004 -- execute("SET statement_timeout TO 0")
1005 -> 0.0002s
1006 -- transaction()
1007 -- add_column(:ci_runners, :private_projects_minutes_cost_factor, :float, {:default=>nil})
1008 -> 0.0010s
1009 -- change_column_default(:ci_runners, :private_projects_minutes_cost_factor, 1.0)
1010 -> 0.0029s
1011 -> 0.0059s
1012 -- columns(:ci_runners)
1013 -> 0.0020s
1014 -- transaction_open?()
1015 -> 0.0000s
1016 -- exec_query("SELECT COUNT(*) AS count FROM \"ci_runners\"")
1017 -> 0.0004s
1018 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1")
1019 -> 0.0004s
1020 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 58 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
1021 -> 0.0004s
1022 -- execute("UPDATE \"ci_runners\" SET \"private_projects_minutes_cost_factor\" = 1.0 WHERE \"ci_runners\".\"id\" >= 58 AND \"ci_runners\".\"id\" < 70")
1023 -> 0.0009s
1024 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 70 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
1025 -> 0.0004s
1026 -- execute("UPDATE \"ci_runners\" SET \"private_projects_minutes_cost_factor\" = 1.0 WHERE \"ci_runners\".\"id\" >= 70 AND \"ci_runners\".\"id\" < 75")
1027 -> 0.0009s
1028 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 75 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
1029 -> 0.0004s
1030 -- execute("UPDATE \"ci_runners\" SET \"private_projects_minutes_cost_factor\" = 1.0 WHERE \"ci_runners\".\"id\" >= 75 AND \"ci_runners\".\"id\" < 80")
1031 -> 0.0009s
1032 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 80 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
1033 -> 0.0004s
1034 -- execute("UPDATE \"ci_runners\" SET \"private_projects_minutes_cost_factor\" = 1.0 WHERE \"ci_runners\".\"id\" >= 80 AND \"ci_runners\".\"id\" < 128")
1035 -> 0.0007s
1036 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 128 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
1037 -> 0.0003s
1038 -- execute("UPDATE \"ci_runners\" SET \"private_projects_minutes_cost_factor\" = 1.0 WHERE \"ci_runners\".\"id\" >= 128 AND \"ci_runners\".\"id\" < 130")
1039 -> 0.0008s
1040 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 130 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
1041 -> 0.0003s
1042 -- execute("UPDATE \"ci_runners\" SET \"private_projects_minutes_cost_factor\" = 1.0 WHERE \"ci_runners\".\"id\" >= 130 AND \"ci_runners\".\"id\" < 233")
1043 -> 0.0008s
1044 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 233 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
1045 -> 0.0003s
1046 -- execute("UPDATE \"ci_runners\" SET \"private_projects_minutes_cost_factor\" = 1.0 WHERE \"ci_runners\".\"id\" >= 233 AND \"ci_runners\".\"id\" < 337")
1047 -> 0.0011s
1048 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 337 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
1049 -> 0.0004s
1050 -- execute("UPDATE \"ci_runners\" SET \"private_projects_minutes_cost_factor\" = 1.0 WHERE \"ci_runners\".\"id\" >= 337 AND \"ci_runners\".\"id\" < 388")
1051 -> 0.0010s
1052 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 388 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
1053 -> 0.0003s
1054 -- execute("UPDATE \"ci_runners\" SET \"private_projects_minutes_cost_factor\" = 1.0 WHERE \"ci_runners\".\"id\" >= 388 AND \"ci_runners\".\"id\" < 392")
1055 -> 0.0009s
1056 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 392 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
1057 -> 0.0003s
1058 -- execute("UPDATE \"ci_runners\" SET \"private_projects_minutes_cost_factor\" = 1.0 WHERE \"ci_runners\".\"id\" >= 392 AND \"ci_runners\".\"id\" < 394")
1059 -> 0.0008s
1060 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 394 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
1061 -> 0.0003s
1062 -- execute("UPDATE \"ci_runners\" SET \"private_projects_minutes_cost_factor\" = 1.0 WHERE \"ci_runners\".\"id\" >= 394 AND \"ci_runners\".\"id\" < 398")
1063 -> 0.0008s
1064 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 398 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
1065 -> 0.0003s
1066 -- execute("UPDATE \"ci_runners\" SET \"private_projects_minutes_cost_factor\" = 1.0 WHERE \"ci_runners\".\"id\" >= 398 AND \"ci_runners\".\"id\" < 400")
1067 -> 0.0008s
1068 -- exec_query("SELECT \"ci_runners\".\"id\" FROM \"ci_runners\" WHERE \"ci_runners\".\"id\" >= 400 ORDER BY \"ci_runners\".\"id\" ASC LIMIT 1 OFFSET 2")
1069 -> 0.0003s
1070 -- execute("UPDATE \"ci_runners\" SET \"private_projects_minutes_cost_factor\" = 1.0 WHERE \"ci_runners\".\"id\" >= 400")
1071 -> 0.0009s
1072 -- change_column_null(:ci_runners, :private_projects_minutes_cost_factor, false)
1073 -> 0.0010s
1074 -- execute("RESET ALL")
1075 -> 0.0001s
1076 == 20200320112455 AddCostFactorFiledsToCiRunners: migrated (0.1432s) ==========
1077
1078 == 20200320123839 AddLetsencryptErrorsToPagesDomains: migrating ===============
1079 -- transaction_open?()
1080 -> 0.0000s
1081 -- execute("SET statement_timeout TO 0")
1082 -> 0.0004s
1083 -- transaction()
1084 -- add_column(:pages_domains, :auto_ssl_failed, :boolean, {:default=>nil})
1085 -> 0.0342s
1086 -- change_column_default(:pages_domains, :auto_ssl_failed, false)
1087 -> 0.0043s
1088 -> 0.0414s
1089 -- columns(:pages_domains)
1090 -> 0.0028s
1091 -- transaction_open?()
1092 -> 0.0000s
1093 -- exec_query("SELECT COUNT(*) AS count FROM \"pages_domains\"")
1094 -> 0.0013s
1095 -- change_column_null(:pages_domains, :auto_ssl_failed, false)
1096 -> 0.0022s
1097 -- execute("RESET ALL")
1098 -> 0.0002s
1099 == 20200320123839 AddLetsencryptErrorsToPagesDomains: migrated (0.0489s) ======
1100
1101 == 20200323011225 CompleteMigrateSecurityScans: migrating =====================
1102 == 20200323011225 CompleteMigrateSecurityScans: migrated (0.0011s) ============
1103
1104 == 20200323011955 RemoveIndexUsedForScanMigration: migrating ==================
1105 -- index_exists?(:ci_job_artifacts, [:id, :file_type, :job_id, :created_at, :updated_at], {:name=>"job_artifacts_secure_reports_temp_index"})
1106 -> 0.0067s
1107 -- transaction_open?()
1108 -> 0.0000s
1109 -- index_exists?(:ci_job_artifacts, [:id, :file_type, :job_id, :created_at, :updated_at], {:name=>"job_artifacts_secure_reports_temp_index", :algorithm=>:concurrently})
1110 -> 0.0049s
1111 -- execute("SET statement_timeout TO 0")
1112 -> 0.0002s
1113 -- remove_index(:ci_job_artifacts, {:name=>"job_artifacts_secure_reports_temp_index", :algorithm=>:concurrently, :column=>[:id, :file_type, :job_id, :created_at, :updated_at]})
1114 -> 0.0251s
1115 -- execute("RESET ALL")
1116 -> 0.0003s
1117 == 20200323011955 RemoveIndexUsedForScanMigration: migrated (0.0374s) =========
1118
1119 == 20200323071918 AddBioToUserDetails: migrating ==============================
1120 -- transaction_open?()
1121 -> 0.0000s
1122 -- execute("SET statement_timeout TO 0")
1123 -> 0.0003s
1124 -- transaction()
1125 -- add_column(:user_details, :bio, :string, {:default=>nil, :limit=>255})
1126 -> 0.0190s
1127 -- change_column_default(:user_details, :bio, "")
1128 -> 0.0019s
1129 -> 0.0828s
1130 -- columns(:user_details)
1131 -> 0.0030s
1132 -- transaction_open?()
1133 -> 0.0000s
1134 -- exec_query("SELECT COUNT(*) AS count FROM \"user_details\"")
1135 -> 0.0018s
1136 -- exec_query("SELECT \"user_details\".\"user_id\" FROM \"user_details\" ORDER BY \"user_details\".\"user_id\" ASC LIMIT 1")
1137 -> 0.0010s
1138 -- exec_query("SELECT \"user_details\".\"user_id\" FROM \"user_details\" WHERE \"user_details\".\"user_id\" >= 79 ORDER BY \"user_details\".\"user_id\" ASC LIMIT 1 OFFSET 1")
1139 -> 0.0008s
1140 -- execute("UPDATE \"user_details\" SET \"bio\" = '' WHERE \"user_details\".\"user_id\" >= 79 AND \"user_details\".\"user_id\" < 98")
1141 -> 0.0014s
1142 -- exec_query("SELECT \"user_details\".\"user_id\" FROM \"user_details\" WHERE \"user_details\".\"user_id\" >= 98 ORDER BY \"user_details\".\"user_id\" ASC LIMIT 1 OFFSET 1")
1143 -> 0.0006s
1144 -- execute("UPDATE \"user_details\" SET \"bio\" = '' WHERE \"user_details\".\"user_id\" >= 98 AND \"user_details\".\"user_id\" < 247")
1145 -> 0.0010s
1146 -- exec_query("SELECT \"user_details\".\"user_id\" FROM \"user_details\" WHERE \"user_details\".\"user_id\" >= 247 ORDER BY \"user_details\".\"user_id\" ASC LIMIT 1 OFFSET 1")
1147 -> 0.0005s
1148 -- execute("UPDATE \"user_details\" SET \"bio\" = '' WHERE \"user_details\".\"user_id\" >= 247 AND \"user_details\".\"user_id\" < 286")
1149 -> 0.0023s
1150 -- exec_query("SELECT \"user_details\".\"user_id\" FROM \"user_details\" WHERE \"user_details\".\"user_id\" >= 286 ORDER BY \"user_details\".\"user_id\" ASC LIMIT 1 OFFSET 1")
1151 -> 0.0021s
1152 -- execute("UPDATE \"user_details\" SET \"bio\" = '' WHERE \"user_details\".\"user_id\" >= 286 AND \"user_details\".\"user_id\" < 300")
1153 -> 0.0010s
1154 -- exec_query("SELECT \"user_details\".\"user_id\" FROM \"user_details\" WHERE \"user_details\".\"user_id\" >= 300 ORDER BY \"user_details\".\"user_id\" ASC LIMIT 1 OFFSET 1")
1155 -> 0.0004s
1156 -- execute("UPDATE \"user_details\" SET \"bio\" = '' WHERE \"user_details\".\"user_id\" >= 300 AND \"user_details\".\"user_id\" < 302")
1157 -> 0.0009s
1158 -- exec_query("SELECT \"user_details\".\"user_id\" FROM \"user_details\" WHERE \"user_details\".\"user_id\" >= 302 ORDER BY \"user_details\".\"user_id\" ASC LIMIT 1 OFFSET 1")
1159 -> 0.0004s
1160 -- execute("UPDATE \"user_details\" SET \"bio\" = '' WHERE \"user_details\".\"user_id\" >= 302 AND \"user_details\".\"user_id\" < 397")
1161 -> 0.0009s
1162 -- exec_query("SELECT \"user_details\".\"user_id\" FROM \"user_details\" WHERE \"user_details\".\"user_id\" >= 397 ORDER BY \"user_details\".\"user_id\" ASC LIMIT 1 OFFSET 1")
1163 -> 0.0004s
1164 -- execute("UPDATE \"user_details\" SET \"bio\" = '' WHERE \"user_details\".\"user_id\" >= 397")
1165 -> 0.0008s
1166 -- change_column_null(:user_details, :bio, false)
1167 -> 0.0009s
1168 -- execute("RESET ALL")
1169 -> 0.0002s
1170 == 20200323071918 AddBioToUserDetails: migrated (0.1071s) =====================
1171
1172 == 20200323074147 AddTempIndexOnUsersBio: migrating ===========================
1173 -- transaction_open?()
1174 -> 0.0000s
1175 -- index_exists?(:users, :id, {:where=>"(COALESCE(bio, '') IS DISTINCT FROM '')", :name=>"tmp_idx_on_user_id_where_bio_is_filled", :algorithm=>:concurrently})
1176 -> 0.0165s
1177 -- execute("SET statement_timeout TO 0")
1178 -> 0.0004s
1179 -- add_index(:users, :id, {:where=>"(COALESCE(bio, '') IS DISTINCT FROM '')", :name=>"tmp_idx_on_user_id_where_bio_is_filled", :algorithm=>:concurrently})
1180 -> 0.0148s
1181 -- execute("RESET ALL")
1182 -> 0.0002s
1183 == 20200323074147 AddTempIndexOnUsersBio: migrated (0.0322s) ==================
1184
1185 == 20200323075043 AddMaxPersonalAccessTokenLifetimeToNamespaces: migrating ====
1186 -- add_column(:namespaces, :max_personal_access_token_lifetime, :integer)
1187 -> 0.0005s
1188 == 20200323075043 AddMaxPersonalAccessTokenLifetimeToNamespaces: migrated (0.0016s)
1189
1190 == 20200323080714 TriggerBackgroundMigrationForUsersBio: migrating ============
1191 == 20200323080714 TriggerBackgroundMigrationForUsersBio: migrated (0.0438s) ===
1192
1193 == 20200323122201 AddIndexOnUserAndCreatedAtToCiBuilds: migrating =============
1194 -- transaction_open?()
1195 -> 0.0000s
1196 -- index_exists?(:ci_builds, [:user_id, :created_at], {:where=>"type = 'Ci::Build'", :name=>"index_ci_builds_on_user_id_and_created_at_and_type_eq_ci_build", :algorithm=>:concurrently})
1197 -> 0.0135s
1198 -- execute("SET statement_timeout TO 0")
1199 -> 0.0001s
1200 -- add_index(:ci_builds, [:user_id, :created_at], {:where=>"type = 'Ci::Build'", :name=>"index_ci_builds_on_user_id_and_created_at_and_type_eq_ci_build", :algorithm=>:concurrently})
1201 -> 48.1995s
1202 -- execute("RESET ALL")
1203 -> 0.0003s
1204 == 20200323122201 AddIndexOnUserAndCreatedAtToCiBuilds: migrated (48.2138s) ===
1205
1206 == 20200323134519 AddApiIndexesForArchivedProjects: migrating =================
1207 -- transaction_open?()
1208 -> 0.0000s
1209 -- index_exists?(:projects, [:created_at, :id], {:where=>"archived = true AND visibility_level = 20 AND pending_delete = false", :name=>"index_projects_api_created_at_id_for_archived_vis20", :algorithm=>:concurrently})
1210 -> 0.0144s
1211 -- execute("SET statement_timeout TO 0")
1212 -> 0.0002s
1213 -- add_index(:projects, [:created_at, :id], {:where=>"archived = true AND visibility_level = 20 AND pending_delete = false", :name=>"index_projects_api_created_at_id_for_archived_vis20", :algorithm=>:concurrently})
1214 -> 0.0096s
1215 -- execute("RESET ALL")
1216 -> 0.0002s
1217 -- transaction_open?()
1218 -> 0.0000s
1219 -- index_exists?(:projects, [:created_at, :id], {:where=>"archived = true AND pending_delete = false", :name=>"index_projects_api_created_at_id_for_archived", :algorithm=>:concurrently})
1220 -> 0.0149s
1221 -- execute("SET statement_timeout TO 0")
1222 -> 0.0001s
1223 -- add_index(:projects, [:created_at, :id], {:where=>"archived = true AND pending_delete = false", :name=>"index_projects_api_created_at_id_for_archived", :algorithm=>:concurrently})
1224 -> 0.0115s
1225 -- execute("RESET ALL")
1226 -> 0.0002s
1227 == 20200323134519 AddApiIndexesForArchivedProjects: migrated (0.0515s) ========
1228
1229 == 20200324093258 AddIndexOnIdCreatorIdAndCreatedAtToProjectsTable: migrating =
1230 -- transaction_open?()
1231 -> 0.0000s
1232 -- index_exists?(:projects, [:id, :creator_id, :created_at], {:where=>"\"projects\".\"service_desk_enabled\" = TRUE", :name=>"index_service_desk_enabled_projects_on_id_creator_id_created_at", :algorithm=>:concurrently})
1233 -> 0.0187s
1234 -- execute("SET statement_timeout TO 0")
1235 -> 0.0002s
1236 -- add_index(:projects, [:id, :creator_id, :created_at], {:where=>"\"projects\".\"service_desk_enabled\" = TRUE", :name=>"index_service_desk_enabled_projects_on_id_creator_id_created_at", :algorithm=>:concurrently})
1237 -> 0.0085s
1238 -- execute("RESET ALL")
1239 -> 0.0002s
1240 == 20200324093258 AddIndexOnIdCreatorIdAndCreatedAtToProjectsTable: migrated (0.0278s)
1241
1242 == 20200324115359 AddNamespaceStorageSizeLimitToApplicationSettings: migrating
1243 -- transaction_open?()
1244 -> 0.0000s
1245 -- execute("SET statement_timeout TO 0")
1246 -> 0.0002s
1247 -- transaction()
1248 -- add_column(:application_settings, :namespace_storage_size_limit, :bigint, {:default=>nil})
1249 -> 0.0019s
1250 -- change_column_default(:application_settings, :namespace_storage_size_limit, 0)
1251 -> 0.0502s
1252 -> 0.0542s
1253 -- columns(:application_settings)
1254 -> 0.0301s
1255 -- transaction_open?()
1256 -> 0.0000s
1257 -- exec_query("SELECT COUNT(*) AS count FROM \"application_settings\"")
1258 -> 0.0005s
1259 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" ORDER BY \"application_settings\".\"id\" ASC LIMIT 1")
1260 -> 0.0003s
1261 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 1 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
1262 -> 0.0003s
1263 -- execute("UPDATE \"application_settings\" SET \"namespace_storage_size_limit\" = 0 WHERE \"application_settings\".\"id\" >= 1 AND \"application_settings\".\"id\" < 2")
1264 -> 0.0030s
1265 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 2 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
1266 -> 0.0003s
1267 -- execute("UPDATE \"application_settings\" SET \"namespace_storage_size_limit\" = 0 WHERE \"application_settings\".\"id\" >= 2 AND \"application_settings\".\"id\" < 3")
1268 -> 0.0019s
1269 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 3 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
1270 -> 0.0003s
1271 -- execute("UPDATE \"application_settings\" SET \"namespace_storage_size_limit\" = 0 WHERE \"application_settings\".\"id\" >= 3 AND \"application_settings\".\"id\" < 4")
1272 -> 0.0010s
1273 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 4 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
1274 -> 0.0003s
1275 -- execute("UPDATE \"application_settings\" SET \"namespace_storage_size_limit\" = 0 WHERE \"application_settings\".\"id\" >= 4 AND \"application_settings\".\"id\" < 5")
1276 -> 0.0009s
1277 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 5 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
1278 -> 0.0003s
1279 -- execute("UPDATE \"application_settings\" SET \"namespace_storage_size_limit\" = 0 WHERE \"application_settings\".\"id\" >= 5 AND \"application_settings\".\"id\" < 6")
1280 -> 0.0009s
1281 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 6 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
1282 -> 0.0003s
1283 -- execute("UPDATE \"application_settings\" SET \"namespace_storage_size_limit\" = 0 WHERE \"application_settings\".\"id\" >= 6")
1284 -> 0.0021s
1285 -- change_column_null(:application_settings, :namespace_storage_size_limit, false)
1286 -> 0.0008s
1287 -- execute("RESET ALL")
1288 -> 0.0001s
1289 == 20200324115359 AddNamespaceStorageSizeLimitToApplicationSettings: migrated (0.0998s)
1290
1291 == 20200325104755 AddPushRulesIdToProjectSettings: migrating ==================
1292 -- add_column(:project_settings, :push_rule_id, :bigint)
1293 -> 0.0086s
1294 == 20200325104755 AddPushRulesIdToProjectSettings: migrated (0.0096s) =========
1295
1296 == 20200325104756 AddPushRulesForeignKeyToProjectSettings: migrating ==========
1297 -- transaction_open?()
1298 -> 0.0000s
1299 -- index_exists?(:project_settings, :push_rule_id, {:unique=>true, :algorithm=>:concurrently})
1300 -> 0.0007s
1301 -- execute("SET statement_timeout TO 0")
1302 -> 0.0001s
1303 -- add_index(:project_settings, :push_rule_id, {:unique=>true, :algorithm=>:concurrently})
1304 -> 0.0596s
1305 -- execute("RESET ALL")
1306 -> 0.0004s
1307 -- transaction_open?()
1308 -> 0.0000s
1309 -- foreign_keys(:project_settings)
1310 -> 0.0069s
1311 -- execute("ALTER TABLE project_settings\nADD CONSTRAINT fk_413a953e20\nFOREIGN KEY (push_rule_id)\nREFERENCES push_rules (id)\nON DELETE CASCADE\nNOT VALID;\n")
1312 -> 0.0201s
1313 -- execute("SET statement_timeout TO 0")
1314 -> 0.0002s
1315 -- execute("ALTER TABLE project_settings VALIDATE CONSTRAINT fk_413a953e20;")
1316 -> 0.0518s
1317 -- execute("RESET ALL")
1318 -> 0.0002s
1319 == 20200325104756 AddPushRulesForeignKeyToProjectSettings: migrated (0.1451s) =
1320
1321 == 20200325104833 AddPushRulesIdToApplicationSettings: migrating ==============
1322 -- add_column(:application_settings, :push_rule_id, :bigint)
1323 -> 0.0011s
1324 == 20200325104833 AddPushRulesIdToApplicationSettings: migrated (0.0023s) =====
1325
1326 == 20200325104834 AddPushRulesForeignKeyToApplicationSettings: migrating ======
1327 -- transaction_open?()
1328 -> 0.0000s
1329 -- index_exists?(:application_settings, :push_rule_id, {:unique=>true, :algorithm=>:concurrently})
1330 -> 0.0066s
1331 -- execute("SET statement_timeout TO 0")
1332 -> 0.0001s
1333 -- add_index(:application_settings, :push_rule_id, {:unique=>true, :algorithm=>:concurrently})
1334 -> 0.0406s
1335 -- execute("RESET ALL")
1336 -> 0.0003s
1337 -- transaction_open?()
1338 -> 0.0000s
1339 -- foreign_keys(:application_settings)
1340 -> 0.0040s
1341 -- execute("ALTER TABLE application_settings\nADD CONSTRAINT fk_693b8795e4\nFOREIGN KEY (push_rule_id)\nREFERENCES push_rules (id)\nON DELETE SET NULL\nNOT VALID;\n")
1342 -> 0.0014s
1343 -- execute("SET statement_timeout TO 0")
1344 -> 0.0018s
1345 -- execute("ALTER TABLE application_settings VALIDATE CONSTRAINT fk_693b8795e4;")
1346 -> 0.0029s
1347 -- execute("RESET ALL")
1348 -> 0.0002s
1349 == 20200325104834 AddPushRulesForeignKeyToApplicationSettings: migrated (0.0625s)
1350
1351 == 20200325111432 AddIssuesCreateLimitToApplicationSettings: migrating ========
1352 -- add_column(:application_settings, :issues_create_limit, :integer, {:default=>300, :null=>false})
1353 -> 0.1390s
1354 == 20200325111432 AddIssuesCreateLimitToApplicationSettings: migrated (0.1391s)
1355
1356 == 20200325160952 AddIndexOnNameTypeEqCiBuildToCiBuilds: migrating ============
1357 -- transaction_open?()
1358 -> 0.0000s
1359 -- index_exists?(:ci_builds, [:name, :id], {:name=>"index_ci_builds_on_name_and_security_type_eq_ci_build", :where=>"((name)::text = ANY (ARRAY[('container_scanning'::character varying)::text, ('dast'::character varying)::text, ('dependency_scanning'::character varying)::text, ('license_management'::character varying)::text, ('sast'::character varying)::text, ('license_scanning'::character varying)::text])) AND ((type)::text = 'Ci::Build'::text)", :algorithm=>:concurrently})
1360 -> 0.0361s
1361 -- execute("SET statement_timeout TO 0")
1362 -> 0.0001s
1363 -- add_index(:ci_builds, [:name, :id], {:name=>"index_ci_builds_on_name_and_security_type_eq_ci_build", :where=>"((name)::text = ANY (ARRAY[('container_scanning'::character varying)::text, ('dast'::character varying)::text, ('dependency_scanning'::character varying)::text, ('license_management'::character varying)::text, ('sast'::character varying)::text, ('license_scanning'::character varying)::text])) AND ((type)::text = 'Ci::Build'::text)", :algorithm=>:concurrently})
1364 -> 1.6094s
1365 -- execute("RESET ALL")
1366 -> 0.0003s
1367 == 20200325160952 AddIndexOnNameTypeEqCiBuildToCiBuilds: migrated (1.6464s) ===
1368
1369 == 20200325162730 ScheduleBackfillPushRulesIdInProjects: migrating ============
1370 == 20200325162730 ScheduleBackfillPushRulesIdInProjects: migrated (0.0092s) ===
1371
1372 == 20200325183636 AddApiIndexForInternalProjects: migrating ===================
1373 -- transaction_open?()
1374 -> 0.0000s
1375 -- index_exists?(:projects, [:created_at, :id], {:where=>"visibility_level = 10 AND pending_delete = false", :name=>"index_projects_api_created_at_id_for_vis10", :algorithm=>:concurrently})
1376 -> 0.0129s
1377 -- execute("SET statement_timeout TO 0")
1378 -> 0.0001s
1379 -- add_index(:projects, [:created_at, :id], {:where=>"visibility_level = 10 AND pending_delete = false", :name=>"index_projects_api_created_at_id_for_vis10", :algorithm=>:concurrently})
1380 -> 0.0135s
1381 -- execute("RESET ALL")
1382 -> 0.0001s
1383 == 20200325183636 AddApiIndexForInternalProjects: migrated (0.0269s) ==========
1384
1385 == 20200326114443 CreateJiraImportsTable: migrating ===========================
1386 -- create_table(:jira_imports)
1387 -> 0.0113s
1388 -- add_index(:jira_imports, [:project_id, :jira_project_key], {:name=>"index_jira_imports_on_project_id_and_jira_project_key"})
1389 -> 0.0068s
1390 == 20200326114443 CreateJiraImportsTable: migrated (0.0181s) ==================
1391
1392 == 20200326122700 CreateDiffNotePositions: migrating ==========================
1393 -- create_table(:diff_note_positions)
1394 -> 0.0199s
1395 == 20200326122700 CreateDiffNotePositions: migrated (0.0214s) =================
1396
1397 == 20200326124443 AddProjectsFkToJiraImportsTable: migrating ==================
1398 -- add_foreign_key(:jira_imports, :projects, {:on_delete=>:cascade})
1399 -> 0.0027s
1400 == 20200326124443 AddProjectsFkToJiraImportsTable: migrated (0.0042s) =========
1401
1402 == 20200326134443 AddUsersFkToJiraImportsTable: migrating =====================
1403 -- add_foreign_key(:jira_imports, :users, {:on_delete=>:nullify})
1404 -> 0.0014s
1405 == 20200326134443 AddUsersFkToJiraImportsTable: migrated (0.0025s) ============
1406
1407 == 20200326135443 AddUsersFkIndexOnJiraImportsTable: migrating ================
1408 -- transaction_open?()
1409 -> 0.0000s
1410 -- index_exists?(:jira_imports, :user_id, {:algorithm=>:concurrently})
1411 -> 0.0014s
1412 -- execute("SET statement_timeout TO 0")
1413 -> 0.0001s
1414 -- add_index(:jira_imports, :user_id, {:algorithm=>:concurrently})
1415 -> 0.0061s
1416 -- execute("RESET ALL")
1417 -> 0.0001s
1418 == 20200326135443 AddUsersFkIndexOnJiraImportsTable: migrated (0.0079s) =======
1419
1420 == 20200326144443 AddLabelsFkToJiraImportsTable: migrating ====================
1421 -- add_foreign_key(:jira_imports, :labels, {:on_delete=>:nullify})
1422 -> 0.0011s
1423 == 20200326144443 AddLabelsFkToJiraImportsTable: migrated (0.0019s) ===========
1424
1425 == 20200326145443 AddLabelsFkIndexOnJiraImportsTable: migrating ===============
1426 -- transaction_open?()
1427 -> 0.0000s
1428 -- index_exists?(:jira_imports, :label_id, {:algorithm=>:concurrently})
1429 -> 0.0014s
1430 -- execute("SET statement_timeout TO 0")
1431 -> 0.0001s
1432 -- add_index(:jira_imports, :label_id, {:algorithm=>:concurrently})
1433 -> 0.0054s
1434 -- execute("RESET ALL")
1435 -> 0.0001s
1436 == 20200326145443 AddLabelsFkIndexOnJiraImportsTable: migrated (0.0072s) ======
1437
1438 == 20200330074719 AddIndexForGroupVsmUsagePing: migrating =====================
1439 -- transaction_open?()
1440 -> 0.0000s
1441 -- index_exists?(:analytics_cycle_analytics_group_stages, :id, {:where=>"custom = true", :name=>"index_analytics_cycle_analytics_group_stages_custom_only", :algorithm=>:concurrently})
1442 -> 0.0021s
1443 -- execute("SET statement_timeout TO 0")
1444 -> 0.0001s
1445 -- add_index(:analytics_cycle_analytics_group_stages, :id, {:where=>"custom = true", :name=>"index_analytics_cycle_analytics_group_stages_custom_only", :algorithm=>:concurrently})
1446 -> 0.0273s
1447 -- execute("RESET ALL")
1448 -> 0.0002s
1449 == 20200330074719 AddIndexForGroupVsmUsagePing: migrated (0.0299s) ============
1450
1451 == 20200330121000 AddConfidentialAttributeToEpics: migrating ==================
1452 -- transaction_open?()
1453 -> 0.0000s
1454 -- execute("SET statement_timeout TO 0")
1455 -> 0.0002s
1456 -- transaction()
1457 -- add_column(:epics, :confidential, :boolean, {:default=>nil})
1458 -> 0.0010s
1459 -- change_column_default(:epics, :confidential, false)
1460 -> 0.0027s
1461 -> 0.0057s
1462 -- columns(:epics)
1463 -> 0.0021s
1464 -- transaction_open?()
1465 -> 0.0000s
1466 -- exec_query("SELECT COUNT(*) AS count FROM \"epics\"")
1467 -> 0.1410s
1468 -- change_column_null(:epics, :confidential, false)
1469 -> 0.0033s
1470 -- execute("RESET ALL")
1471 -> 0.0006s
1472 == 20200330121000 AddConfidentialAttributeToEpics: migrated (0.1536s) =========
1473
1474 == 20200330123739 RemoveIndexCiBuildsOnNameForSecurityReportsValues: migrating
1475 -- transaction_open?()
1476 -> 0.0000s
1477 -- indexes(:ci_builds)
1478 -> 0.0170s
1479 -- execute("SET statement_timeout TO 0")
1480 -> 0.0002s
1481 -- remove_index(:ci_builds, {:algorithm=>:concurrently, :name=>"index_ci_builds_on_name_for_security_reports_values"})
1482 -> 0.0119s
1483 -- execute("RESET ALL")
1484 -> 0.0001s
1485 == 20200330123739 RemoveIndexCiBuildsOnNameForSecurityReportsValues: migrated (0.0294s)
1486
1487 == 20200330132913 AddIndexOnAuthorIdAndCreatedAtAndIdToNotes: migrating =======
1488 -- transaction_open?()
1489 -> 0.0000s
1490 -- index_exists?(:notes, [:author_id, :created_at, :id], {:algorithm=>:concurrently})
1491 -> 0.0042s
1492 -- execute("SET statement_timeout TO 0")
1493 -> 0.0001s
1494 -- add_index(:notes, [:author_id, :created_at, :id], {:algorithm=>:concurrently})
1495 -> 13.9276s
1496 -- execute("RESET ALL")
1497 -> 0.0002s
1498 -- transaction_open?()
1499 -> 0.0000s
1500 -- index_exists?(:notes, [:author_id, :created_at], {:algorithm=>:concurrently})
1501 -> 0.0041s
1502 -- execute("SET statement_timeout TO 0")
1503 -> 0.0001s
1504 -- remove_index(:notes, {:algorithm=>:concurrently, :column=>[:author_id, :created_at]})
1505 -> 0.0283s
1506 -- execute("RESET ALL")
1507 -> 0.0003s
1508 == 20200330132913 AddIndexOnAuthorIdAndCreatedAtAndIdToNotes: migrated (13.9653s)
1509
1510 == 20200331132103 AddProjectComplianceFrameworkSettingsTable: migrating =======
1511 -- create_table(:project_compliance_framework_settings, {:id=>false})
1512 -> 0.0121s
1513 == 20200331132103 AddProjectComplianceFrameworkSettingsTable: migrated (0.0139s)
1514
1515 == 20200331195952 AddContainerExpirationPoliciesEnableHistoricEntriesToApplicationSettings: migrating
1516 -- transaction_open?()
1517 -> 0.0000s
1518 -- execute("SET statement_timeout TO 0")
1519 -> 0.0004s
1520 -- transaction()
1521 -- add_column(:application_settings, :container_expiration_policies_enable_historic_entries, :boolean, {:default=>nil})
1522 -> 0.0019s
1523 -- change_column_default(:application_settings, :container_expiration_policies_enable_historic_entries, false)
1524 -> 0.0464s
1525 -> 0.0538s
1526 -- columns(:application_settings)
1527 -> 0.0394s
1528 -- transaction_open?()
1529 -> 0.0000s
1530 -- exec_query("SELECT COUNT(*) AS count FROM \"application_settings\"")
1531 -> 0.0008s
1532 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" ORDER BY \"application_settings\".\"id\" ASC LIMIT 1")
1533 -> 0.0005s
1534 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 1 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
1535 -> 0.0003s
1536 -- execute("UPDATE \"application_settings\" SET \"container_expiration_policies_enable_historic_entries\" = FALSE WHERE \"application_settings\".\"id\" >= 1 AND \"application_settings\".\"id\" < 2")
1537 -> 0.0030s
1538 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 2 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
1539 -> 0.0004s
1540 -- execute("UPDATE \"application_settings\" SET \"container_expiration_policies_enable_historic_entries\" = FALSE WHERE \"application_settings\".\"id\" >= 2 AND \"application_settings\".\"id\" < 3")
1541 -> 0.0015s
1542 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 3 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
1543 -> 0.0003s
1544 -- execute("UPDATE \"application_settings\" SET \"container_expiration_policies_enable_historic_entries\" = FALSE WHERE \"application_settings\".\"id\" >= 3 AND \"application_settings\".\"id\" < 4")
1545 -> 0.0011s
1546 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 4 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
1547 -> 0.0003s
1548 -- execute("UPDATE \"application_settings\" SET \"container_expiration_policies_enable_historic_entries\" = FALSE WHERE \"application_settings\".\"id\" >= 4 AND \"application_settings\".\"id\" < 5")
1549 -> 0.0011s
1550 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 5 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
1551 -> 0.0003s
1552 -- execute("UPDATE \"application_settings\" SET \"container_expiration_policies_enable_historic_entries\" = FALSE WHERE \"application_settings\".\"id\" >= 5 AND \"application_settings\".\"id\" < 6")
1553 -> 0.0009s
1554 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 6 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
1555 -> 0.0004s
1556 -- execute("UPDATE \"application_settings\" SET \"container_expiration_policies_enable_historic_entries\" = FALSE WHERE \"application_settings\".\"id\" >= 6")
1557 -> 0.0018s
1558 -- change_column_null(:application_settings, :container_expiration_policies_enable_historic_entries, false)
1559 -> 0.0010s
1560 -- execute("RESET ALL")
1561 -> 0.0001s
1562 == 20200331195952 AddContainerExpirationPoliciesEnableHistoricEntriesToApplicationSettings: migrated (0.1099s)
1563
1564 == 20200331220930 EnableContainerExpirationPoliciesByDefault: migrating =======
1565 -- change_column_default(:container_expiration_policies, :enabled, true)
1566 -> 0.0406s
1567 == 20200331220930 EnableContainerExpirationPoliciesByDefault: migrated (0.0433s)
1568
1569 == 20200401095430 AddJsonbToGeoNodeStatusTable: migrating =====================
1570 -- change_table(:geo_node_statuses)
1571 -> 0.0449s
1572 == 20200401095430 AddJsonbToGeoNodeStatusTable: migrated (0.0450s) ============
1573
1574 == 20200401211005 CreateOperationsUserLists: migrating ========================
1575 -- create_table(:operations_user_lists)
1576 -> 0.0264s
1577 == 20200401211005 CreateOperationsUserLists: migrated (0.0264s) ===============
1578
1579 == 20200402123926 AddLineMetricsToMrMetrics: migrating ========================
1580 -- add_column(:merge_request_metrics, :added_lines, :integer)
1581 -> 0.0402s
1582 -- add_column(:merge_request_metrics, :removed_lines, :integer)
1583 -> 0.0007s
1584 == 20200402123926 AddLineMetricsToMrMetrics: migrated (0.0437s) ===============
1585
1586 == 20200402124802 AddCorrelationIdToProjectImportState: migrating =============
1587 -- add_column(:project_mirror_data, :correlation_id_value, :string, {:limit=>128})
1588 -> 0.0394s
1589 == 20200402124802 AddCorrelationIdToProjectImportState: migrated (0.0415s) ====
1590
1591 == 20200402135250 AddDeleteStatusToContainerRepository: migrating =============
1592 -- add_column(:container_repositories, :status, :integer, {:limit=>2})
1593 -> 0.0155s
1594 == 20200402135250 AddDeleteStatusToContainerRepository: migrated (0.0156s) ====
1595
1596 == 20200402185044 CreateClustersApplicationsFluentd: migrating ================
1597 -- create_table(:clusters_applications_fluentd)
1598 -> 0.0288s
1599 == 20200402185044 CreateClustersApplicationsFluentd: migrated (0.0289s) =======
1600
1601 == 20200403184110 AddPartialIndexOnIdToCiJobArtifacts: migrating ==============
1602 -- transaction_open?()
1603 -> 0.0000s
1604 -- index_exists?(:ci_job_artifacts, :id, {:where=>"file_store IS NULL", :name=>"index_ci_job_artifacts_file_store_is_null", :algorithm=>:concurrently})
1605 -> 0.0033s
1606 -- execute("SET statement_timeout TO 0")
1607 -> 0.0003s
1608 -- add_index(:ci_job_artifacts, :id, {:where=>"file_store IS NULL", :name=>"index_ci_job_artifacts_file_store_is_null", :algorithm=>:concurrently})
1609 -> 35.9818s
1610 -- execute("RESET ALL")
1611 -> 0.0002s
1612 == 20200403184110 AddPartialIndexOnIdToCiJobArtifacts: migrated (35.9861s) ====
1613
1614 == 20200403185127 AddPartialIndexOnIdToLfsObjects: migrating ==================
1615 -- transaction_open?()
1616 -> 0.0000s
1617 -- index_exists?(:lfs_objects, :id, {:where=>"file_store IS NULL", :name=>"index_lfs_objects_file_store_is_null", :algorithm=>:concurrently})
1618 -> 0.0018s
1619 -- execute("SET statement_timeout TO 0")
1620 -> 0.0002s
1621 -- add_index(:lfs_objects, :id, {:where=>"file_store IS NULL", :name=>"index_lfs_objects_file_store_is_null", :algorithm=>:concurrently})
1622 -> 0.0070s
1623 -- execute("RESET ALL")
1624 -> 0.0001s
1625 == 20200403185127 AddPartialIndexOnIdToLfsObjects: migrated (0.0093s) =========
1626
1627 == 20200403185422 AddPartialIndexOnIdToUploads: migrating =====================
1628 -- transaction_open?()
1629 -> 0.0000s
1630 -- index_exists?(:uploads, :id, {:where=>"store IS NULL", :name=>"index_uploads_store_is_null", :algorithm=>:concurrently})
1631 -> 0.0021s
1632 -- execute("SET statement_timeout TO 0")
1633 -> 0.0001s
1634 -- add_index(:uploads, :id, {:where=>"store IS NULL", :name=>"index_uploads_store_is_null", :algorithm=>:concurrently})
1635 -> 0.0352s
1636 -- execute("RESET ALL")
1637 -> 0.0004s
1638 == 20200403185422 AddPartialIndexOnIdToUploads: migrated (0.0380s) ============
1639
1640 == 20200406102111 AddIndexToDeploymentsWhereClusterIdIsNotNull: migrating =====
1641 -- transaction_open?()
1642 -> 0.0000s
1643 -- index_exists?(:deployments, :id, {:where=>"cluster_id IS NOT NULL", :name=>"index_deployments_on_id_where_cluster_id_present", :algorithm=>:concurrently})
1644 -> 0.0111s
1645 -- execute("SET statement_timeout TO 0")
1646 -> 0.0002s
1647 -- add_index(:deployments, :id, {:where=>"cluster_id IS NOT NULL", :name=>"index_deployments_on_id_where_cluster_id_present", :algorithm=>:concurrently})
1648 -> 1.0583s
1649 -- execute("RESET ALL")
1650 -> 0.0022s
1651 == 20200406102111 AddIndexToDeploymentsWhereClusterIdIsNotNull: migrated (1.0722s)
1652
1653 == 20200406102120 BackfillDeploymentClustersFromDeployments: migrating ========
1654 -- Scheduling `BackfillDeploymentClustersFromDeployments` jobs
1655 == 20200406102120 BackfillDeploymentClustersFromDeployments: migrated (0.0158s)
1656
1657 == 20200406135648 AddIndexToCreatedAtOnResourceMilestoneEvents: migrating =====
1658 -- transaction_open?()
1659 -> 0.0000s
1660 -- index_exists?(:resource_milestone_events, :created_at, {:name=>"index_resource_milestone_events_created_at", :algorithm=>:concurrently})
1661 -> 0.0021s
1662 -- execute("SET statement_timeout TO 0")
1663 -> 0.0001s
1664 -- add_index(:resource_milestone_events, :created_at, {:name=>"index_resource_milestone_events_created_at", :algorithm=>:concurrently})
1665 -> 0.0069s
1666 -- execute("RESET ALL")
1667 -> 0.0002s
1668 == 20200406135648 AddIndexToCreatedAtOnResourceMilestoneEvents: migrated (0.0095s)
1669
1670 == 20200406192059 AddWriteRegistryToDeployTokens: migrating ===================
1671 -- transaction_open?()
1672 -> 0.0000s
1673 -- execute("SET statement_timeout TO 0")
1674 -> 0.0002s
1675 -- transaction()
1676 -- add_column(:deploy_tokens, :write_registry, :boolean, {:default=>nil})
1677 -> 0.0269s
1678 -- change_column_default(:deploy_tokens, :write_registry, false)
1679 -> 0.0037s
1680 -> 0.0339s
1681 -- columns(:deploy_tokens)
1682 -> 0.0024s
1683 -- transaction_open?()
1684 -> 0.0000s
1685 -- exec_query("SELECT COUNT(*) AS count FROM \"deploy_tokens\"")
1686 -> 0.0009s
1687 -- exec_query("SELECT \"deploy_tokens\".\"id\" FROM \"deploy_tokens\" ORDER BY \"deploy_tokens\".\"id\" ASC LIMIT 1")
1688 -> 0.0006s
1689 -- exec_query("SELECT \"deploy_tokens\".\"id\" FROM \"deploy_tokens\" WHERE \"deploy_tokens\".\"id\" >= 1 ORDER BY \"deploy_tokens\".\"id\" ASC LIMIT 1 OFFSET 2")
1690 -> 0.0006s
1691 -- execute("UPDATE \"deploy_tokens\" SET \"write_registry\" = FALSE WHERE \"deploy_tokens\".\"id\" >= 1 AND \"deploy_tokens\".\"id\" < 3")
1692 -> 0.0025s
1693 -- exec_query("SELECT \"deploy_tokens\".\"id\" FROM \"deploy_tokens\" WHERE \"deploy_tokens\".\"id\" >= 3 ORDER BY \"deploy_tokens\".\"id\" ASC LIMIT 1 OFFSET 2")
1694 -> 0.0006s
1695 -- execute("UPDATE \"deploy_tokens\" SET \"write_registry\" = FALSE WHERE \"deploy_tokens\".\"id\" >= 3 AND \"deploy_tokens\".\"id\" < 5")
1696 -> 0.0011s
1697 -- exec_query("SELECT \"deploy_tokens\".\"id\" FROM \"deploy_tokens\" WHERE \"deploy_tokens\".\"id\" >= 5 ORDER BY \"deploy_tokens\".\"id\" ASC LIMIT 1 OFFSET 2")
1698 -> 0.0003s
1699 -- execute("UPDATE \"deploy_tokens\" SET \"write_registry\" = FALSE WHERE \"deploy_tokens\".\"id\" >= 5 AND \"deploy_tokens\".\"id\" < 7")
1700 -> 0.0008s
1701 -- exec_query("SELECT \"deploy_tokens\".\"id\" FROM \"deploy_tokens\" WHERE \"deploy_tokens\".\"id\" >= 7 ORDER BY \"deploy_tokens\".\"id\" ASC LIMIT 1 OFFSET 2")
1702 -> 0.0003s
1703 -- execute("UPDATE \"deploy_tokens\" SET \"write_registry\" = FALSE WHERE \"deploy_tokens\".\"id\" >= 7 AND \"deploy_tokens\".\"id\" < 9")
1704 -> 0.0023s
1705 -- exec_query("SELECT \"deploy_tokens\".\"id\" FROM \"deploy_tokens\" WHERE \"deploy_tokens\".\"id\" >= 9 ORDER BY \"deploy_tokens\".\"id\" ASC LIMIT 1 OFFSET 2")
1706 -> 0.0004s
1707 -- execute("UPDATE \"deploy_tokens\" SET \"write_registry\" = FALSE WHERE \"deploy_tokens\".\"id\" >= 9 AND \"deploy_tokens\".\"id\" < 11")
1708 -> 0.0011s
1709 -- exec_query("SELECT \"deploy_tokens\".\"id\" FROM \"deploy_tokens\" WHERE \"deploy_tokens\".\"id\" >= 11 ORDER BY \"deploy_tokens\".\"id\" ASC LIMIT 1 OFFSET 2")
1710 -> 0.0004s
1711 -- execute("UPDATE \"deploy_tokens\" SET \"write_registry\" = FALSE WHERE \"deploy_tokens\".\"id\" >= 11 AND \"deploy_tokens\".\"id\" < 13")
1712 -> 0.0011s
1713 -- exec_query("SELECT \"deploy_tokens\".\"id\" FROM \"deploy_tokens\" WHERE \"deploy_tokens\".\"id\" >= 13 ORDER BY \"deploy_tokens\".\"id\" ASC LIMIT 1 OFFSET 2")
1714 -> 0.0003s
1715 -- execute("UPDATE \"deploy_tokens\" SET \"write_registry\" = FALSE WHERE \"deploy_tokens\".\"id\" >= 13 AND \"deploy_tokens\".\"id\" < 15")
1716 -> 0.0008s
1717 -- exec_query("SELECT \"deploy_tokens\".\"id\" FROM \"deploy_tokens\" WHERE \"deploy_tokens\".\"id\" >= 15 ORDER BY \"deploy_tokens\".\"id\" ASC LIMIT 1 OFFSET 2")
1718 -> 0.0003s
1719 -- execute("UPDATE \"deploy_tokens\" SET \"write_registry\" = FALSE WHERE \"deploy_tokens\".\"id\" >= 15 AND \"deploy_tokens\".\"id\" < 17")
1720 -> 0.0007s
1721 -- exec_query("SELECT \"deploy_tokens\".\"id\" FROM \"deploy_tokens\" WHERE \"deploy_tokens\".\"id\" >= 17 ORDER BY \"deploy_tokens\".\"id\" ASC LIMIT 1 OFFSET 2")
1722 -> 0.0003s
1723 -- execute("UPDATE \"deploy_tokens\" SET \"write_registry\" = FALSE WHERE \"deploy_tokens\".\"id\" >= 17 AND \"deploy_tokens\".\"id\" < 19")
1724 -> 0.0007s
1725 -- exec_query("SELECT \"deploy_tokens\".\"id\" FROM \"deploy_tokens\" WHERE \"deploy_tokens\".\"id\" >= 19 ORDER BY \"deploy_tokens\".\"id\" ASC LIMIT 1 OFFSET 2")
1726 -> 0.0003s
1727 -- execute("UPDATE \"deploy_tokens\" SET \"write_registry\" = FALSE WHERE \"deploy_tokens\".\"id\" >= 19 AND \"deploy_tokens\".\"id\" < 21")
1728 -> 0.0008s
1729 -- exec_query("SELECT \"deploy_tokens\".\"id\" FROM \"deploy_tokens\" WHERE \"deploy_tokens\".\"id\" >= 21 ORDER BY \"deploy_tokens\".\"id\" ASC LIMIT 1 OFFSET 2")
1730 -> 0.0003s
1731 -- execute("UPDATE \"deploy_tokens\" SET \"write_registry\" = FALSE WHERE \"deploy_tokens\".\"id\" >= 21 AND \"deploy_tokens\".\"id\" < 23")
1732 -> 0.0007s
1733 -- exec_query("SELECT \"deploy_tokens\".\"id\" FROM \"deploy_tokens\" WHERE \"deploy_tokens\".\"id\" >= 23 ORDER BY \"deploy_tokens\".\"id\" ASC LIMIT 1 OFFSET 2")
1734 -> 0.0003s
1735 -- execute("UPDATE \"deploy_tokens\" SET \"write_registry\" = FALSE WHERE \"deploy_tokens\".\"id\" >= 23 AND \"deploy_tokens\".\"id\" < 25")
1736 -> 0.0009s
1737 -- exec_query("SELECT \"deploy_tokens\".\"id\" FROM \"deploy_tokens\" WHERE \"deploy_tokens\".\"id\" >= 25 ORDER BY \"deploy_tokens\".\"id\" ASC LIMIT 1 OFFSET 2")
1738 -> 0.0003s
1739 -- execute("UPDATE \"deploy_tokens\" SET \"write_registry\" = FALSE WHERE \"deploy_tokens\".\"id\" >= 25 AND \"deploy_tokens\".\"id\" < 27")
1740 -> 0.0007s
1741 -- exec_query("SELECT \"deploy_tokens\".\"id\" FROM \"deploy_tokens\" WHERE \"deploy_tokens\".\"id\" >= 27 ORDER BY \"deploy_tokens\".\"id\" ASC LIMIT 1 OFFSET 2")
1742 -> 0.0003s
1743 -- execute("UPDATE \"deploy_tokens\" SET \"write_registry\" = FALSE WHERE \"deploy_tokens\".\"id\" >= 27 AND \"deploy_tokens\".\"id\" < 29")
1744 -> 0.0007s
1745 -- exec_query("SELECT \"deploy_tokens\".\"id\" FROM \"deploy_tokens\" WHERE \"deploy_tokens\".\"id\" >= 29 ORDER BY \"deploy_tokens\".\"id\" ASC LIMIT 1 OFFSET 2")
1746 -> 0.0003s
1747 -- execute("UPDATE \"deploy_tokens\" SET \"write_registry\" = FALSE WHERE \"deploy_tokens\".\"id\" >= 29 AND \"deploy_tokens\".\"id\" < 31")
1748 -> 0.0007s
1749 -- exec_query("SELECT \"deploy_tokens\".\"id\" FROM \"deploy_tokens\" WHERE \"deploy_tokens\".\"id\" >= 31 ORDER BY \"deploy_tokens\".\"id\" ASC LIMIT 1 OFFSET 2")
1750 -> 0.0003s
1751 -- execute("UPDATE \"deploy_tokens\" SET \"write_registry\" = FALSE WHERE \"deploy_tokens\".\"id\" >= 31")
1752 -> 0.0007s
1753 -- change_column_null(:deploy_tokens, :write_registry, false)
1754 -> 0.0007s
1755 -- execute("RESET ALL")
1756 -> 0.0001s
1757 == 20200406192059 AddWriteRegistryToDeployTokens: migrated (0.0654s) ==========
1758
1759 == 20200406193427 AddIndexToIssuesHealthStatus: migrating =====================
1760 -- transaction_open?()
1761 -> 0.0000s
1762 -- index_exists?(:issues, :health_status, {:where=>"health_status IS NOT NULL", :name=>"idx_issues_on_health_status_not_null", :algorithm=>:concurrently})
1763 -> 0.0064s
1764 -- execute("SET statement_timeout TO 0")
1765 -> 0.0001s
1766 -- add_index(:issues, :health_status, {:where=>"health_status IS NOT NULL", :name=>"idx_issues_on_health_status_not_null", :algorithm=>:concurrently})
1767 -> 0.0161s
1768 -- execute("RESET ALL")
1769 -> 0.0001s
1770 == 20200406193427 AddIndexToIssuesHealthStatus: migrated (0.0229s) ============
1771
1772 == 20200407094005 DropVulnerabilitySeverityIndex: migrating ===================
1773 -- transaction_open?()
1774 -> 0.0000s
1775 -- indexes(:vulnerability_occurrences)
1776 -> 0.0025s
1777 -- execute("SET statement_timeout TO 0")
1778 -> 0.0001s
1779 -- remove_index(:vulnerability_occurrences, {:algorithm=>:concurrently, :name=>"undefined_vulnerabilities"})
1780 -> 0.0134s
1781 -- execute("RESET ALL")
1782 -> 0.0006s
1783 == 20200407094005 DropVulnerabilitySeverityIndex: migrated (0.0167s) ==========
1784
1785 == 20200407094923 DropVulnerabilitiesSeverityIndex: migrating =================
1786 -- transaction_open?()
1787 -> 0.0000s
1788 -- indexes(:vulnerabilities)
1789 -> 0.0047s
1790 -- execute("SET statement_timeout TO 0")
1791 -> 0.0001s
1792 -- remove_index(:vulnerabilities, {:algorithm=>:concurrently, :name=>"undefined_vulnerability"})
1793 -> 0.0146s
1794 -- execute("RESET ALL")
1795 -> 0.0003s
1796 == 20200407094923 DropVulnerabilitiesSeverityIndex: migrated (0.0199s) ========
1797
1798 == 20200407120000 AddPushRuleIdToGroups: migrating ============================
1799 -- add_column(:namespaces, :push_rule_id, :bigint)
1800 -> 0.0007s
1801 == 20200407120000 AddPushRuleIdToGroups: migrated (0.0036s) ===================
1802
1803 == 20200407121321 AddPushRuleForeignKeyToGroups: migrating ====================
1804 -- transaction_open?()
1805 -> 0.0000s
1806 -- index_exists?(:namespaces, :push_rule_id, {:unique=>true, :algorithm=>:concurrently})
1807 -> 0.0069s
1808 -- execute("SET statement_timeout TO 0")
1809 -> 0.0002s
1810 -- add_index(:namespaces, :push_rule_id, {:unique=>true, :algorithm=>:concurrently})
1811 -> 0.0084s
1812 -- execute("RESET ALL")
1813 -> 0.0002s
1814 -- transaction_open?()
1815 -> 0.0000s
1816 -- foreign_keys(:namespaces)
1817 -> 0.0055s
1818 -- execute("ALTER TABLE namespaces\nADD CONSTRAINT fk_3448c97865\nFOREIGN KEY (push_rule_id)\nREFERENCES push_rules (id)\nON DELETE SET NULL\nNOT VALID;\n")
1819 -> 0.0013s
1820 -- execute("SET statement_timeout TO 0")
1821 -> 0.0001s
1822 -- execute("ALTER TABLE namespaces VALIDATE CONSTRAINT fk_3448c97865;")
1823 -> 0.0018s
1824 -- execute("RESET ALL")
1825 -> 0.0001s
1826 == 20200407121321 AddPushRuleForeignKeyToGroups: migrated (0.0279s) ===========
1827
1828 == 20200407171133 AddProtectedTagCreateAccessLevelsUserIdForeignKey: migrating
1829 -- add_foreign_key(:protected_tag_create_access_levels, :users, {:on_delete=>:cascade, :validate=>false, :name=>"fk_protected_tag_create_access_levels_user_id"})
1830 -> 0.0102s
1831 -- foreign_keys(:protected_tag_create_access_levels)
1832 -> 0.0042s
1833 -- remove_foreign_key(:protected_tag_create_access_levels, {:column=>:user_id, :on_delete=>nil})
1834 -> 0.0272s
1835 == 20200407171133 AddProtectedTagCreateAccessLevelsUserIdForeignKey: migrated (0.0461s)
1836
1837 == 20200407171417 ValidateProtectedTagCreateAccessLevelsUserIdForeignKey: migrating
1838 -- foreign_keys(:protected_tag_create_access_levels)
1839 -> 0.0080s
1840 -- execute("SET statement_timeout TO 0")
1841 -> 0.0003s
1842 -- execute("ALTER TABLE protected_tag_create_access_levels VALIDATE CONSTRAINT fk_protected_tag_create_access_levels_user_id;")
1843 -> 0.0607s
1844 -- execute("RESET ALL")
1845 -> 0.0003s
1846 == 20200407171417 ValidateProtectedTagCreateAccessLevelsUserIdForeignKey: migrated (0.0696s)
1847
1848 == 20200408110856 AddNginxFiveHundredPercentageMetric: migrating ==============
1849 == 20200408110856 AddNginxFiveHundredPercentageMetric: migrated (0.1723s) =====
1850
1851 == 20200408133211 AddIndexOnRoutePathTrigram: migrating =======================
1852 -- transaction_open?()
1853 -> 0.0000s
1854 -- index_exists?(:routes, :path, {:name=>"index_routes_on_path_trigram", :using=>:gin, :opclass=>{:path=>:gin_trgm_ops}, :algorithm=>:concurrently})
1855 -> 0.0043s
1856 -- execute("SET statement_timeout TO 0")
1857 -> 0.0003s
1858 -- add_index(:routes, :path, {:name=>"index_routes_on_path_trigram", :using=>:gin, :opclass=>{:path=>:gin_trgm_ops}, :algorithm=>:concurrently})
1859 -> 0.0473s
1860 -- execute("RESET ALL")
1861 -> 0.0003s
1862 == 20200408133211 AddIndexOnRoutePathTrigram: migrated (0.0526s) ==============
1863
1864 == 20200408153842 AddIndexOnCreatorIdAndIdOnProjects: migrating ===============
1865 -- transaction_open?()
1866 -> 0.0000s
1867 -- index_exists?(:projects, [:creator_id, :id], {:algorithm=>:concurrently})
1868 -> 0.0208s
1869 -- execute("SET statement_timeout TO 0")
1870 -> 0.0001s
1871 -- add_index(:projects, [:creator_id, :id], {:algorithm=>:concurrently})
1872 -> 0.0093s
1873 -- execute("RESET ALL")
1874 -> 0.0001s
1875 == 20200408153842 AddIndexOnCreatorIdAndIdOnProjects: migrated (0.0305s) ======
1876
1877 == 20200408154331 AddProtectedBranchMergeAccessLevelsUserIdForeignKey: migrating
1878 -- add_foreign_key(:protected_branch_merge_access_levels, :users, {:on_delete=>:cascade, :validate=>false, :name=>"fk_protected_branch_merge_access_levels_user_id"})
1879 -> 0.0009s
1880 -- foreign_keys(:protected_branch_merge_access_levels)
1881 -> 0.0024s
1882 -- remove_foreign_key(:protected_branch_merge_access_levels, {:column=>:user_id, :on_delete=>nil})
1883 -> 0.0123s
1884 == 20200408154331 AddProtectedBranchMergeAccessLevelsUserIdForeignKey: migrated (0.0196s)
1885
1886 == 20200408154349 ValidateProtectedBranchMergeAccessLevelsUserIdForeignKey: migrating
1887 -- foreign_keys(:protected_branch_merge_access_levels)
1888 -> 0.0032s
1889 -- execute("SET statement_timeout TO 0")
1890 -> 0.0002s
1891 -- execute("ALTER TABLE protected_branch_merge_access_levels VALIDATE CONSTRAINT fk_protected_branch_merge_access_levels_user_id;")
1892 -> 0.0027s
1893 -- execute("RESET ALL")
1894 -> 0.0002s
1895 == 20200408154349 ValidateProtectedBranchMergeAccessLevelsUserIdForeignKey: migrated (0.0064s)
1896
1897 == 20200408154411 AddPathLocksUserIdForeignKey: migrating =====================
1898 -- add_foreign_key(:path_locks, :users, {:on_delete=>:cascade, :validate=>false, :name=>"fk_path_locks_user_id"})
1899 -> 0.0010s
1900 -- foreign_keys(:path_locks)
1901 -> 0.0031s
1902 -- remove_foreign_key(:path_locks, {:column=>:user_id, :on_delete=>nil})
1903 -> 0.0042s
1904 == 20200408154411 AddPathLocksUserIdForeignKey: migrated (0.0124s) ============
1905
1906 == 20200408154428 ValidatePathLocksUserIdForeignKey: migrating ================
1907 -- foreign_keys(:path_locks)
1908 -> 0.0029s
1909 -- execute("SET statement_timeout TO 0")
1910 -> 0.0003s
1911 -- execute("ALTER TABLE path_locks VALIDATE CONSTRAINT fk_path_locks_user_id;")
1912 -> 0.0644s
1913 -- execute("RESET ALL")
1914 -> 0.0003s
1915 == 20200408154428 ValidatePathLocksUserIdForeignKey: migrated (0.0682s) =======
1916
1917 == 20200408154455 AddProtectedBranchPushAccessLevelsUserIdForeignKey: migrating
1918 -- add_foreign_key(:protected_branch_push_access_levels, :users, {:on_delete=>:cascade, :validate=>false, :name=>"fk_protected_branch_push_access_levels_user_id"})
1919 -> 0.0020s
1920 -- foreign_keys(:protected_branch_push_access_levels)
1921 -> 0.0070s
1922 -- remove_foreign_key(:protected_branch_push_access_levels, {:column=>:user_id, :on_delete=>nil})
1923 -> 0.0195s
1924 == 20200408154455 AddProtectedBranchPushAccessLevelsUserIdForeignKey: migrated (0.0333s)
1925
1926 == 20200408154533 ValidateProtectedBranchPushAccessLevelsUserIdForeignKey: migrating
1927 -- foreign_keys(:protected_branch_push_access_levels)
1928 -> 0.0064s
1929 -- execute("SET statement_timeout TO 0")
1930 -> 0.0003s
1931 -- execute("ALTER TABLE protected_branch_push_access_levels VALIDATE CONSTRAINT fk_protected_branch_push_access_levels_user_id;")
1932 -> 0.0734s
1933 -- execute("RESET ALL")
1934 -> 0.0004s
1935 == 20200408154533 ValidateProtectedBranchPushAccessLevelsUserIdForeignKey: migrated (0.0808s)
1936
1937 == 20200408154604 AddU2fRegistrationsUserIdForeignKey: migrating ==============
1938 -- add_foreign_key(:u2f_registrations, :users, {:on_delete=>:cascade, :validate=>false, :name=>"fk_u2f_registrations_user_id"})
1939 -> 0.0022s
1940 -- foreign_keys(:u2f_registrations)
1941 -> 0.0071s
1942 -- remove_foreign_key(:u2f_registrations, {:column=>:user_id, :on_delete=>nil})
1943 -> 0.0075s
1944 == 20200408154604 AddU2fRegistrationsUserIdForeignKey: migrated (0.0214s) =====
1945
1946 == 20200408154624 ValidateU2fRegistrationsUserIdForeignKey: migrating =========
1947 -- foreign_keys(:u2f_registrations)
1948 -> 0.0034s
1949 -- execute("SET statement_timeout TO 0")
1950 -> 0.0003s
1951 -- execute("ALTER TABLE u2f_registrations VALIDATE CONSTRAINT fk_u2f_registrations_user_id;")
1952 -> 0.0010s
1953 -- execute("RESET ALL")
1954 -> 0.0002s
1955 == 20200408154624 ValidateU2fRegistrationsUserIdForeignKey: migrated (0.0050s)
1956
1957 == 20200408175424 AddIndexOnCreatorIdCreatedAtIdToProjectsTable: migrating ====
1958 -- transaction_open?()
1959 -> 0.0000s
1960 -- index_exists?(:projects, [:creator_id, :created_at, :id], {:algorithm=>:concurrently})
1961 -> 0.0166s
1962 -- execute("SET statement_timeout TO 0")
1963 -> 0.0001s
1964 -- add_index(:projects, [:creator_id, :created_at, :id], {:algorithm=>:concurrently})
1965 -> 0.0122s
1966 -- execute("RESET ALL")
1967 -> 0.0002s
1968 == 20200408175424 AddIndexOnCreatorIdCreatedAtIdToProjectsTable: migrated (0.0294s)
1969
1970 == 20200408212219 AddStatusPageUrlToStatusPageSettings: migrating =============
1971 -- add_column(:status_page_settings, :status_page_url, :text)
1972 -> 0.0428s
1973 -- transaction_open?()
1974 -> 0.0000s
1975 -- execute("ALTER TABLE status_page_settings\nADD CONSTRAINT check_75a79cd992\nCHECK ( char_length(status_page_url) <= 1024 )\nNOT VALID;\n")
1976 -> 0.0010s
1977 -- execute("SET statement_timeout TO 0")
1978 -> 0.0003s
1979 -- execute("ALTER TABLE status_page_settings VALIDATE CONSTRAINT check_75a79cd992;")
1980 -> 0.0010s
1981 -- execute("RESET ALL")
1982 -> 0.0002s
1983 == 20200408212219 AddStatusPageUrlToStatusPageSettings: migrated (0.0526s) ====
1984
1985 == 20200409085956 AddPartialIndexOnImportFailuresRetryCount: migrating ========
1986 -- transaction_open?()
1987 -> 0.0000s
1988 -- index_exists?(:import_failures, [:project_id, :correlation_id_value], {:where=>"retry_count = 0", :algorithm=>:concurrently})
1989 -> 0.0040s
1990 -- execute("SET statement_timeout TO 0")
1991 -> 0.0003s
1992 -- add_index(:import_failures, [:project_id, :correlation_id_value], {:where=>"retry_count = 0", :algorithm=>:concurrently})
1993 -> 0.0456s
1994 -- execute("RESET ALL")
1995 -> 0.0003s
1996 == 20200409085956 AddPartialIndexOnImportFailuresRetryCount: migrated (0.0505s)
1997
1998 == 20200409211607 MigrateLegacyAttachments: migrating =========================
1999 == 20200409211607 MigrateLegacyAttachments: migrated (0.0150s) ================NOTICE: constraint "lfs_objects_file_store_not_null" of relation "lfs_objects" does not exist, skipping
2000 NOTICE: constraint "ci_job_artifacts_file_store_not_null" of relation "ci_job_artifacts" does not exist, skipping
2001 NOTICE: constraint "uploads_store_not_null" of relation "uploads" does not exist, skipping
2002
2003
2004 == 20200410232012 AddMetricsDashboardAccessLevelToProjectFeature: migrating ===
2005 -- add_column(:project_features, :metrics_dashboard_access_level, :integer)
2006 -> 0.0142s
2007 == 20200410232012 AddMetricsDashboardAccessLevelToProjectFeature: migrated (0.0160s)
2008
2009 == 20200413072059 AddGroupOwnersCanManageDefaultBranchProtectionToApplicationSettings: migrating
2010 -- transaction_open?()
2011 -> 0.0000s
2012 -- execute("SET statement_timeout TO 0")
2013 -> 0.0003s
2014 -- transaction()
2015 -- add_column(:application_settings, :group_owners_can_manage_default_branch_protection, :boolean, {:default=>nil})
2016 -> 0.0012s
2017 -- change_column_default(:application_settings, :group_owners_can_manage_default_branch_protection, true)
2018 -> 0.0381s
2019 -> 0.0430s
2020 -- columns(:application_settings)
2021 -> 0.0338s
2022 -- transaction_open?()
2023 -> 0.0000s
2024 -- exec_query("SELECT COUNT(*) AS count FROM \"application_settings\"")
2025 -> 0.0005s
2026 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" ORDER BY \"application_settings\".\"id\" ASC LIMIT 1")
2027 -> 0.0003s
2028 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 1 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
2029 -> 0.0003s
2030 -- execute("UPDATE \"application_settings\" SET \"group_owners_can_manage_default_branch_protection\" = TRUE WHERE \"application_settings\".\"id\" >= 1 AND \"application_settings\".\"id\" < 2")
2031 -> 0.0036s
2032 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 2 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
2033 -> 0.0004s
2034 -- execute("UPDATE \"application_settings\" SET \"group_owners_can_manage_default_branch_protection\" = TRUE WHERE \"application_settings\".\"id\" >= 2 AND \"application_settings\".\"id\" < 3")
2035 -> 0.0017s
2036 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 3 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
2037 -> 0.0003s
2038 -- execute("UPDATE \"application_settings\" SET \"group_owners_can_manage_default_branch_protection\" = TRUE WHERE \"application_settings\".\"id\" >= 3 AND \"application_settings\".\"id\" < 4")
2039 -> 0.0011s
2040 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 4 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
2041 -> 0.0003s
2042 -- execute("UPDATE \"application_settings\" SET \"group_owners_can_manage_default_branch_protection\" = TRUE WHERE \"application_settings\".\"id\" >= 4 AND \"application_settings\".\"id\" < 5")
2043 -> 0.0010s
2044 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 5 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
2045 -> 0.0003s
2046 -- execute("UPDATE \"application_settings\" SET \"group_owners_can_manage_default_branch_protection\" = TRUE WHERE \"application_settings\".\"id\" >= 5 AND \"application_settings\".\"id\" < 6")
2047 -> 0.0009s
2048 -- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 6 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
2049 -> 0.0003s
2050 -- execute("UPDATE \"application_settings\" SET \"group_owners_can_manage_default_branch_protection\" = TRUE WHERE \"application_settings\".\"id\" >= 6")
2051 -> 0.0010s
2052 -- change_column_null(:application_settings, :group_owners_can_manage_default_branch_protection, false)
2053 -> 0.0009s
2054 -- execute("RESET ALL")
2055 -> 0.0001s
2056 == 20200413072059 AddGroupOwnersCanManageDefaultBranchProtectionToApplicationSettings: migrated (0.0925s)
2057
2058 == 20200414144547 RemoveIndexProjectsOnCreatorIdAndCreatedAtFromProjects: migrating
2059 -- transaction_open?()
2060 -> 0.0000s
2061 -- indexes(:projects)
2062 -> 0.0161s
2063 -- execute("SET statement_timeout TO 0")
2064 -> 0.0002s
2065 -- remove_index(:projects, {:algorithm=>:concurrently, :name=>"index_projects_on_creator_id_and_created_at"})
2066 -> 0.0102s
2067 -- execute("RESET ALL")
2068 -> 0.0002s
2069 == 20200414144547 RemoveIndexProjectsOnCreatorIdAndCreatedAtFromProjects: migrated (0.0269s)
2070
2071 == 20200415160722 RemoveNotNullLfsObjectsConstraint: migrating ================
2072 -- execute("ALTER TABLE lfs_objects DROP CONSTRAINT IF EXISTS lfs_objects_file_store_not_null;\n")
2073 -> 0.0003s
2074 == 20200415160722 RemoveNotNullLfsObjectsConstraint: migrated (0.0016s) =======
2075
2076 == 20200415161021 RemoveNotNullCiJobArtifactsConstraint: migrating ============
2077 -- execute("ALTER TABLE ci_job_artifacts DROP CONSTRAINT IF EXISTS ci_job_artifacts_file_store_not_null;\n")
2078 -> 0.0002s
2079 == 20200415161021 RemoveNotNullCiJobArtifactsConstraint: migrated (0.0015s) ===
2080
2081 == 20200415161206 RemoveNotNullUploadsConstraint: migrating ===================
2082 -- execute("ALTER TABLE uploads DROP CONSTRAINT IF EXISTS uploads_store_not_null;\n")
2083 -> 0.0002s
2084 == 20200415161206 RemoveNotNullUploadsConstraint: migrated (0.0016s) ==========
2085
2086 == 20200415192656 AddNameRegexKeepToContainerExpirationPolicies: migrating ====
2087 -- add_column(:container_expiration_policies, :name_regex_keep, :text)
2088 -> 0.0076s
2089 -- transaction_open?()
2090 -> 0.0000s
2091 -- execute("ALTER TABLE container_expiration_policies\nADD CONSTRAINT container_expiration_policies_name_regex_keep\nCHECK ( char_length(name_regex_keep) <= 255 )\nNOT VALID;\n")
2092 -> 0.0007s
2093 -- execute("SET statement_timeout TO 0")
2094 -> 0.0002s
2095 -- execute("ALTER TABLE container_expiration_policies VALIDATE CONSTRAINT container_expiration_policies_name_regex_keep;")
2096 -> 0.0010s
2097 -- execute("RESET ALL")
2098 -> 0.0002s
2099 == 20200415192656 AddNameRegexKeepToContainerExpirationPolicies: migrated (0.0128s)
2100
2101 == 20200416120128 AddColumnsToTerraformState: migrating =======================
2102 -- add_column(:terraform_states, :lock_xid, :string, {:limit=>255})
2103 -> 0.0059s
2104 -- add_column(:terraform_states, :locked_at, :datetime_with_timezone)
2105 -> 0.0009s
2106 -- add_column(:terraform_states, :locked_by_user_id, :bigint)
2107 -> 0.0007s
2108 -- add_column(:terraform_states, :uuid, :string, {:limit=>32, :null=>false})
2109 -> 0.0007s
2110 -- add_column(:terraform_states, :name, :string, {:limit=>255})
2111 -> 0.0007s
2112 -- add_index(:terraform_states, :locked_by_user_id)
2113 -> 0.0073s
2114 -- add_index(:terraform_states, :uuid, {:unique=>true})
2115 -> 0.0050s
2116 -- add_index(:terraform_states, [:project_id, :name], {:unique=>true})
2117 -> 0.0057s
2118 -- remove_index(:terraform_states, :project_id)
2119 -> 0.0058s
2120 == 20200416120128 AddColumnsToTerraformState: migrated (0.0332s) ==============
2121
2122 == 20200416120354 AddLockedByUserIdForeignKeyToTerraformState: migrating ======
2123 -- add_foreign_key(:terraform_states, :users, {:column=>:locked_by_user_id})
2124 -> 0.0013s
2125 == 20200416120354 AddLockedByUserIdForeignKeyToTerraformState: migrated (0.0022s)
2126
2127 - execute "bash" "/tmp/chef-script20200423-4545-ko0xpr"
2128Recipe: gitlab::gitlab-rails
2129 * execute[clear the gitlab-rails cache] action run
2130 - execute /opt/gitlab/bin/gitlab-rake cache:clear
2131Recipe: gitlab::unicorn
2132 * runit_service[unicorn] action restart (up to date)
2133 * runit_service[unicorn] action restart (up to date)
2134Recipe: gitlab::sidekiq
2135 * runit_service[sidekiq] action restart (up to date)
2136Recipe: gitlab::database_migrations
2137 * bash[set ownership of old migration log files] action run
2138 - execute "bash" "/tmp/chef-script20200423-4545-uq1rb0"
2139Recipe: gitlab::logrotate_folders_and_configs
2140 * directory[/var/opt/gitlab/logrotate] action create (up to date)
2141 * directory[/var/opt/gitlab/logrotate/logrotate.d] action create (up to date)
2142 * directory[/var/log/gitlab/logrotate] action create (up to date)
2143 * template[/var/opt/gitlab/logrotate/logrotate.conf] action create (up to date)
2144 * template[/var/opt/gitlab/logrotate/logrotate.d/nginx] action create
2145 - update content in file /var/opt/gitlab/logrotate/logrotate.d/nginx from 07c13b to 85cdbe
2146 --- /var/opt/gitlab/logrotate/logrotate.d/nginx 2019-08-30 06:17:18.866346666 +0200
2147 +++ /var/opt/gitlab/logrotate/logrotate.d/.chef-nginx20200423-4545-1of3ci0 2020-04-23 07:37:18.576564307 +0200
2148 @@ -2,7 +2,7 @@
2149 # Modifications will be overwritten!
2150
2151 /var/log/gitlab/nginx/*.log {
2152 - su root gitlab-www
2153 + su root root
2154 daily
2155
2156
2157 * template[/var/opt/gitlab/logrotate/logrotate.d/puma] action create (up to date)
2158 * template[/var/opt/gitlab/logrotate/logrotate.d/unicorn] action create (up to date)
2159 * template[/var/opt/gitlab/logrotate/logrotate.d/gitlab-rails] action create (up to date)
2160 * template[/var/opt/gitlab/logrotate/logrotate.d/gitlab-shell] action create (up to date)
2161 * template[/var/opt/gitlab/logrotate/logrotate.d/gitlab-workhorse] action create (up to date)
2162 * template[/var/opt/gitlab/logrotate/logrotate.d/gitlab-pages] action create (up to date)
2163Recipe: gitlab::unicorn
2164 * directory[/var/log/gitlab/unicorn] action create (up to date)
2165 * directory[/opt/gitlab/var/unicorn] action create (up to date)
2166 * directory[/var/opt/gitlab/gitlab-rails/sockets] action create (up to date)
2167 * directory[/var/opt/gitlab/gitlab-rails/etc] action create (up to date)
2168 * template[/var/opt/gitlab/gitlab-rails/etc/unicorn.rb] action create (up to date)
2169Recipe: <Dynamically Defined Resource>
2170 * service[unicorn] action nothing (skipped due to action :nothing)
2171Recipe: gitlab::unicorn
2172 * runit_service[unicorn] action enable
2173 * ruby_block[restart_service] action nothing (skipped due to action :nothing)
2174 * ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
2175 * ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
2176 * directory[/opt/gitlab/sv/unicorn] action create (up to date)
2177 * template[/opt/gitlab/sv/unicorn/run] action create (up to date)
2178 * directory[/opt/gitlab/sv/unicorn/log] action create (up to date)
2179 * directory[/opt/gitlab/sv/unicorn/log/main] action create (up to date)
2180 * template[/opt/gitlab/sv/unicorn/log/run] action create (up to date)
2181 * template[/var/log/gitlab/unicorn/config] action create (up to date)
2182 * ruby_block[verify_chown_persisted_on_unicorn] action nothing (skipped due to action :nothing)
2183 * directory[/opt/gitlab/sv/unicorn/env] action create (up to date)
2184 * ruby_block[Delete unmanaged env files for unicorn service] action run (skipped due to only_if)
2185 * template[/opt/gitlab/sv/unicorn/check] action create (skipped due to only_if)
2186 * template[/opt/gitlab/sv/unicorn/finish] action create (skipped due to only_if)
2187 * directory[/opt/gitlab/sv/unicorn/control] action create (up to date)
2188 * template[/opt/gitlab/sv/unicorn/control/t] action create (up to date)
2189 * link[/opt/gitlab/init/unicorn] action create (up to date)
2190 * file[/opt/gitlab/sv/unicorn/down] action delete (up to date)
2191 * directory[/opt/gitlab/service] action create (up to date)
2192 * link[/opt/gitlab/service/unicorn] action create (up to date)
2193 * ruby_block[wait for unicorn service socket] action run (skipped due to not_if)
2194 (up to date)
2195 * runit_service[unicorn] action enable
2196 * ruby_block[restart_service] action nothing (skipped due to action :nothing)
2197 * ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
2198 * ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
2199 * directory[/opt/gitlab/sv/unicorn] action create (up to date)
2200 * template[/opt/gitlab/sv/unicorn/run] action create (up to date)
2201 * directory[/opt/gitlab/sv/unicorn/log] action create (up to date)
2202 * directory[/opt/gitlab/sv/unicorn/log/main] action create (up to date)
2203 * template[/opt/gitlab/sv/unicorn/log/run] action create (up to date)
2204 * template[/var/log/gitlab/unicorn/config] action create (up to date)
2205 * ruby_block[verify_chown_persisted_on_unicorn] action nothing (skipped due to action :nothing)
2206 * directory[/opt/gitlab/sv/unicorn/env] action create (up to date)
2207 * ruby_block[Delete unmanaged env files for unicorn service] action run (skipped due to only_if)
2208 * template[/opt/gitlab/sv/unicorn/check] action create (skipped due to only_if)
2209 * template[/opt/gitlab/sv/unicorn/finish] action create (skipped due to only_if)
2210 * directory[/opt/gitlab/sv/unicorn/control] action create (up to date)
2211 * template[/opt/gitlab/sv/unicorn/control/t] action create (up to date)
2212 * link[/opt/gitlab/init/unicorn] action create (up to date)
2213 * file[/opt/gitlab/sv/unicorn/down] action delete (up to date)
2214 * directory[/opt/gitlab/service] action create (up to date)
2215 * link[/opt/gitlab/service/unicorn] action create (up to date)
2216 * ruby_block[wait for unicorn service socket] action run (skipped due to not_if)
2217 (up to date)
2218 * consul_service[rails] action delete
2219 * file[/var/opt/gitlab/consul/config.d/rails-service.json] action delete (up to date)
2220 (up to date)
2221 * gitlab_sysctl[net.core.somaxconn] action create
2222 * directory[create /etc/sysctl.d for net.core.somaxconn] action create (up to date)
2223 * file[create /opt/gitlab/embedded/etc/90-omnibus-gitlab-net.core.somaxconn.conf net.core.somaxconn] action create (up to date)
2224 * link[/etc/sysctl.d/90-omnibus-gitlab-net.core.somaxconn.conf] action create (up to date)
2225 * execute[load sysctl conf net.core.somaxconn] action nothing (skipped due to action :nothing)
2226 (up to date)
2227Recipe: <Dynamically Defined Resource>
2228 * service[puma] action nothing (skipped due to action :nothing)
2229Recipe: gitlab::puma_disable
2230 * runit_service[puma] action disable
2231 * ruby_block[disable puma] action run (skipped due to only_if)
2232 (up to date)
2233 * consul_service[rails] action delete (skipped due to not_if)
2234Recipe: gitlab::sidekiq
2235 * directory[/var/log/gitlab/sidekiq] action create (up to date)
2236Recipe: <Dynamically Defined Resource>
2237 * service[sidekiq] action nothing (skipped due to action :nothing)
2238Recipe: gitlab::sidekiq
2239 * runit_service[sidekiq] action enable
2240 * ruby_block[restart_service] action nothing (skipped due to action :nothing)
2241 * ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
2242 * ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
2243 * directory[/opt/gitlab/sv/sidekiq] action create (up to date)
2244 * template[/opt/gitlab/sv/sidekiq/run] action create (up to date)
2245 * directory[/opt/gitlab/sv/sidekiq/log] action create (up to date)
2246 * directory[/opt/gitlab/sv/sidekiq/log/main] action create (up to date)
2247 * template[/opt/gitlab/sv/sidekiq/log/run] action create (up to date)
2248 * template[/var/log/gitlab/sidekiq/config] action create (up to date)
2249 * ruby_block[verify_chown_persisted_on_sidekiq] action nothing (skipped due to action :nothing)
2250 * directory[/opt/gitlab/sv/sidekiq/env] action create (up to date)
2251 * ruby_block[Delete unmanaged env files for sidekiq service] action run (skipped due to only_if)
2252 * template[/opt/gitlab/sv/sidekiq/check] action create (skipped due to only_if)
2253 * template[/opt/gitlab/sv/sidekiq/finish] action create (skipped due to only_if)
2254 * directory[/opt/gitlab/sv/sidekiq/control] action create (up to date)
2255 * link[/opt/gitlab/init/sidekiq] action create (up to date)
2256 * file[/opt/gitlab/sv/sidekiq/down] action delete (up to date)
2257 * directory[/opt/gitlab/service] action create (up to date)
2258 * link[/opt/gitlab/service/sidekiq] action create (up to date)
2259 * ruby_block[wait for sidekiq service socket] action run (skipped due to not_if)
2260 (up to date)
2261 * consul_service[sidekiq] action delete
2262 * file[/var/opt/gitlab/consul/config.d/sidekiq-service.json] action delete (up to date)
2263 (up to date)
2264Recipe: <Dynamically Defined Resource>
2265 * service[sidekiq-cluster] action nothing (skipped due to action :nothing)
2266Recipe: gitlab::sidekiq-cluster_disable
2267 * runit_service[sidekiq-cluster] action disable
2268 * ruby_block[disable sidekiq-cluster] action run (skipped due to only_if)
2269 (up to date)
2270Recipe: gitlab::gitlab-workhorse
2271 * directory[/var/opt/gitlab/gitlab-workhorse] action create (up to date)
2272 * directory[/var/log/gitlab/gitlab-workhorse] action create (up to date)
2273 * directory[/opt/gitlab/etc/gitlab-workhorse] action create (up to date)
2274 * env_dir[/opt/gitlab/etc/gitlab-workhorse/env] action create
2275 * directory[/opt/gitlab/etc/gitlab-workhorse/env] action create (up to date)
2276 * file[/opt/gitlab/etc/gitlab-workhorse/env/PATH] action create (up to date)
2277 * file[/opt/gitlab/etc/gitlab-workhorse/env/HOME] action create (up to date)
2278 * file[/opt/gitlab/etc/gitlab-workhorse/env/SSL_CERT_DIR] action create (up to date)
2279 (up to date)
2280Recipe: <Dynamically Defined Resource>
2281 * service[gitlab-workhorse] action nothing (skipped due to action :nothing)
2282Recipe: gitlab::gitlab-workhorse
2283 * runit_service[gitlab-workhorse] action enable
2284 * ruby_block[restart_service] action nothing (skipped due to action :nothing)
2285 * ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
2286 * ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
2287 * directory[/opt/gitlab/sv/gitlab-workhorse] action create (up to date)
2288 * template[/opt/gitlab/sv/gitlab-workhorse/run] action create (up to date)
2289 * directory[/opt/gitlab/sv/gitlab-workhorse/log] action create (up to date)
2290 * directory[/opt/gitlab/sv/gitlab-workhorse/log/main] action create (up to date)
2291 * template[/opt/gitlab/sv/gitlab-workhorse/log/run] action create (up to date)
2292 * template[/var/log/gitlab/gitlab-workhorse/config] action create (up to date)
2293 * ruby_block[verify_chown_persisted_on_gitlab-workhorse] action nothing (skipped due to action :nothing)
2294 * directory[/opt/gitlab/sv/gitlab-workhorse/env] action create (up to date)
2295 * ruby_block[Delete unmanaged env files for gitlab-workhorse service] action run (skipped due to only_if)
2296 * template[/opt/gitlab/sv/gitlab-workhorse/check] action create (skipped due to only_if)
2297 * template[/opt/gitlab/sv/gitlab-workhorse/finish] action create (skipped due to only_if)
2298 * directory[/opt/gitlab/sv/gitlab-workhorse/control] action create (up to date)
2299 * link[/opt/gitlab/init/gitlab-workhorse] action create (up to date)
2300 * file[/opt/gitlab/sv/gitlab-workhorse/down] action delete (up to date)
2301 * directory[/opt/gitlab/service] action create (up to date)
2302 * link[/opt/gitlab/service/gitlab-workhorse] action create (up to date)
2303 * ruby_block[wait for gitlab-workhorse service socket] action run (skipped due to not_if)
2304 (up to date)
2305 * consul_service[workhorse] action delete
2306 * file[/var/opt/gitlab/consul/config.d/workhorse-service.json] action delete (up to date)
2307 (up to date)
2308 * file[/var/opt/gitlab/gitlab-workhorse/VERSION] action create
2309 - update content in file /var/opt/gitlab/gitlab-workhorse/VERSION from 084ebc to 583984
2310 --- /var/opt/gitlab/gitlab-workhorse/VERSION 2020-04-21 05:34:46.563278364 +0200
2311 +++ /var/opt/gitlab/gitlab-workhorse/.chef-VERSION20200423-4545-1ewn0k0 2020-04-23 07:37:18.948576011 +0200
2312 @@ -1,2 +1,2 @@
2313 -gitlab-workhorse v8.25.2-20200417.094502
2314 +gitlab-workhorse v8.30.1-20200422.085707
2315 * template[/var/opt/gitlab/gitlab-workhorse/config.toml] action create (up to date)
2316Recipe: <Dynamically Defined Resource>
2317 * service[mailroom] action nothing (skipped due to action :nothing)
2318Recipe: gitlab::mailroom_disable
2319 * runit_service[mailroom] action disable
2320 * ruby_block[disable mailroom] action run (skipped due to only_if)
2321 (up to date)
2322Recipe: gitlab::nginx
2323 * directory[/var/opt/gitlab/nginx] action create (up to date)
2324 * directory[/var/opt/gitlab/nginx/conf] action create (up to date)
2325 * directory[/var/log/gitlab/nginx] action create (up to date)
2326 * link[/var/opt/gitlab/nginx/logs] action create (up to date)
2327 * template[/var/opt/gitlab/nginx/conf/gitlab-http.conf] action create (up to date)
2328 * template[/var/opt/gitlab/nginx/conf/gitlab-smartcard-http.conf] action delete (up to date)
2329 * template[/var/opt/gitlab/nginx/conf/gitlab-health.conf] action create (up to date)
2330 * template[/var/opt/gitlab/nginx/conf/gitlab-pages.conf] action create (up to date)
2331 * template[/var/opt/gitlab/nginx/conf/gitlab-registry.conf] action delete (up to date)
2332 * template[/var/opt/gitlab/nginx/conf/gitlab-mattermost-http.conf] action delete (up to date)
2333 * template[/var/opt/gitlab/nginx/conf/nginx-status.conf] action create (up to date)
2334 * consul_service[nginx] action delete
2335 * file[/var/opt/gitlab/consul/config.d/nginx-service.json] action delete (up to date)
2336 (up to date)
2337 * template[/var/opt/gitlab/nginx/conf/nginx.conf] action create (up to date)
2338Recipe: <Dynamically Defined Resource>
2339 * service[nginx] action nothing (skipped due to action :nothing)
2340Recipe: nginx::enable
2341 * runit_service[nginx] action enable
2342 * ruby_block[restart_service] action nothing (skipped due to action :nothing)
2343 * ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
2344 * ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
2345 * directory[/opt/gitlab/sv/nginx] action create (up to date)
2346 * template[/opt/gitlab/sv/nginx/run] action create (up to date)
2347 * directory[/opt/gitlab/sv/nginx/log] action create (up to date)
2348 * directory[/opt/gitlab/sv/nginx/log/main] action create (up to date)
2349 * template[/opt/gitlab/sv/nginx/log/run] action create (up to date)
2350 * template[/var/log/gitlab/nginx/config] action create (up to date)
2351 * ruby_block[verify_chown_persisted_on_nginx] action nothing (skipped due to action :nothing)
2352 * directory[/opt/gitlab/sv/nginx/env] action create (up to date)
2353 * ruby_block[Delete unmanaged env files for nginx service] action run (skipped due to only_if)
2354 * template[/opt/gitlab/sv/nginx/check] action create (skipped due to only_if)
2355 * template[/opt/gitlab/sv/nginx/finish] action create (skipped due to only_if)
2356 * directory[/opt/gitlab/sv/nginx/control] action create (up to date)
2357 * link[/opt/gitlab/init/nginx] action create (up to date)
2358 * file[/opt/gitlab/sv/nginx/down] action delete (up to date)
2359 * directory[/opt/gitlab/service] action create (up to date)
2360 * link[/opt/gitlab/service/nginx] action create (up to date)
2361 * ruby_block[wait for nginx service socket] action run (skipped due to not_if)
2362 (up to date)
2363 * execute[reload nginx] action nothing (skipped due to action :nothing)
2364Recipe: <Dynamically Defined Resource>
2365 * service[remote-syslog] action nothing (skipped due to action :nothing)
2366Recipe: gitlab::remote-syslog_disable
2367 * runit_service[remote-syslog] action disable
2368 * ruby_block[disable remote-syslog] action run (skipped due to only_if)
2369 (up to date)
2370Recipe: <Dynamically Defined Resource>
2371 * service[logrotate] action nothing (skipped due to action :nothing)
2372Recipe: gitlab::logrotate
2373 * runit_service[logrotate] action enable
2374 * ruby_block[restart_service] action nothing (skipped due to action :nothing)
2375 * ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
2376 * ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
2377 * directory[/opt/gitlab/sv/logrotate] action create (up to date)
2378 * template[/opt/gitlab/sv/logrotate/run] action create (up to date)
2379 * directory[/opt/gitlab/sv/logrotate/log] action create (up to date)
2380 * directory[/opt/gitlab/sv/logrotate/log/main] action create (up to date)
2381 * template[/opt/gitlab/sv/logrotate/log/run] action create (up to date)
2382 * template[/var/log/gitlab/logrotate/config] action create (up to date)
2383 * ruby_block[verify_chown_persisted_on_logrotate] action nothing (skipped due to action :nothing)
2384 * directory[/opt/gitlab/sv/logrotate/env] action create (up to date)
2385 * ruby_block[Delete unmanaged env files for logrotate service] action run (skipped due to only_if)
2386 * template[/opt/gitlab/sv/logrotate/check] action create (skipped due to only_if)
2387 * template[/opt/gitlab/sv/logrotate/finish] action create (skipped due to only_if)
2388 * directory[/opt/gitlab/sv/logrotate/control] action create (up to date)
2389 * template[/opt/gitlab/sv/logrotate/control/t] action create (up to date)
2390 * link[/opt/gitlab/init/logrotate] action create (up to date)
2391 * file[/opt/gitlab/sv/logrotate/down] action delete (up to date)
2392 * directory[/opt/gitlab/service] action create (up to date)
2393 * link[/opt/gitlab/service/logrotate] action create (up to date)
2394 * ruby_block[wait for logrotate service socket] action run (skipped due to not_if)
2395 (up to date)
2396Recipe: gitlab::gitlab-pages
2397 * directory[/var/opt/gitlab/gitlab-pages] action create (up to date)
2398 * directory[/var/log/gitlab/gitlab-pages] action create (up to date)
2399 * directory[/opt/gitlab/etc/gitlab-pages] action create (up to date)
2400 * ruby_block[authorize pages with gitlab] action run (skipped due to not_if)
2401 * ruby_block[re-populate GitLab Pages configuration options] action run
2402 - execute the ruby block re-populate GitLab Pages configuration options
2403 * file[/var/opt/gitlab/gitlab-pages/VERSION] action create (up to date)
2404 * file[/var/opt/gitlab/gitlab-pages/admin.secret] action delete (up to date)
2405 * template[/var/opt/gitlab/gitlab-pages/.gitlab_pages_secret] action create (up to date)
2406 * template[/var/opt/gitlab/gitlab-pages/gitlab-pages-config] action create (up to date)
2407Recipe: <Dynamically Defined Resource>
2408 * service[gitlab-pages] action nothing (skipped due to action :nothing)
2409Recipe: gitlab::gitlab-pages
2410 * runit_service[gitlab-pages] action enable
2411 * ruby_block[restart_service] action nothing (skipped due to action :nothing)
2412 * ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
2413 * ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
2414 * directory[/opt/gitlab/sv/gitlab-pages] action create (up to date)
2415 * template[/opt/gitlab/sv/gitlab-pages/run] action create (up to date)
2416 * directory[/opt/gitlab/sv/gitlab-pages/log] action create (up to date)
2417 * directory[/opt/gitlab/sv/gitlab-pages/log/main] action create (up to date)
2418 * template[/opt/gitlab/sv/gitlab-pages/log/run] action create (up to date)
2419 * template[/var/log/gitlab/gitlab-pages/config] action create (up to date)
2420 * ruby_block[verify_chown_persisted_on_gitlab-pages] action nothing (skipped due to action :nothing)
2421 * directory[/opt/gitlab/sv/gitlab-pages/env] action create (up to date)
2422 * ruby_block[Delete unmanaged env files for gitlab-pages service] action run (skipped due to only_if)
2423 * template[/opt/gitlab/sv/gitlab-pages/check] action create (skipped due to only_if)
2424 * template[/opt/gitlab/sv/gitlab-pages/finish] action create (skipped due to only_if)
2425 * directory[/opt/gitlab/sv/gitlab-pages/control] action create (up to date)
2426 * link[/opt/gitlab/init/gitlab-pages] action create (up to date)
2427 * file[/opt/gitlab/sv/gitlab-pages/down] action delete (up to date)
2428 * directory[/opt/gitlab/service] action create (up to date)
2429 * link[/opt/gitlab/service/gitlab-pages] action create (up to date)
2430 * ruby_block[wait for gitlab-pages service socket] action run (skipped due to not_if)
2431 (up to date)
2432Recipe: <Dynamically Defined Resource>
2433 * service[storage-check] action nothing (skipped due to action :nothing)
2434Recipe: gitlab::storage-check_disable
2435 * runit_service[storage-check] action disable
2436 * ruby_block[disable storage-check] action run (skipped due to only_if)
2437 (up to date)
2438Recipe: <Dynamically Defined Resource>
2439 * service[registry] action nothing (skipped due to action :nothing)
2440Recipe: registry::disable
2441 * runit_service[registry] action disable
2442 * ruby_block[disable registry] action run (skipped due to only_if)
2443 (up to date)
2444Recipe: <Dynamically Defined Resource>
2445 * service[mattermost] action nothing (skipped due to action :nothing)
2446Recipe: mattermost::disable
2447 * runit_service[mattermost] action disable
2448 * ruby_block[disable mattermost] action run (skipped due to only_if)
2449 (up to date)
2450Recipe: gitlab::gitlab-healthcheck
2451 * template[/opt/gitlab/etc/gitlab-healthcheck-rc] action create (up to date)
2452Recipe: monitoring::user
2453 * account[Prometheus user and group] action create
2454 * group[Prometheus user and group] action create (up to date)
2455 * linux_user[Prometheus user and group] action create (up to date)
2456 (up to date)
2457Recipe: monitoring::node-exporter
2458 * directory[/var/log/gitlab/node-exporter] action create (up to date)
2459 * directory[/opt/gitlab/etc/node-exporter/env] action create (up to date)
2460 * env_dir[/opt/gitlab/etc/node-exporter/env] action create
2461 * directory[/opt/gitlab/etc/node-exporter/env] action create (up to date)
2462 * file[/opt/gitlab/etc/node-exporter/env/SSL_CERT_DIR] action create (up to date)
2463 (up to date)
2464 * directory[/var/opt/gitlab/node-exporter/textfile_collector] action create (up to date)
2465Recipe: <Dynamically Defined Resource>
2466 * service[node-exporter] action nothing (skipped due to action :nothing)
2467Recipe: monitoring::node-exporter
2468 * runit_service[node-exporter] action enable
2469 * ruby_block[restart_service] action nothing (skipped due to action :nothing)
2470 * ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
2471 * ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
2472 * directory[/opt/gitlab/sv/node-exporter] action create (up to date)
2473 * template[/opt/gitlab/sv/node-exporter/run] action create (up to date)
2474 * directory[/opt/gitlab/sv/node-exporter/log] action create (up to date)
2475 * directory[/opt/gitlab/sv/node-exporter/log/main] action create (up to date)
2476 * template[/opt/gitlab/sv/node-exporter/log/run] action create (up to date)
2477 * template[/var/log/gitlab/node-exporter/config] action create (up to date)
2478 * ruby_block[verify_chown_persisted_on_node-exporter] action nothing (skipped due to action :nothing)
2479 * directory[/opt/gitlab/sv/node-exporter/env] action create (up to date)
2480 * ruby_block[Delete unmanaged env files for node-exporter service] action run (skipped due to only_if)
2481 * template[/opt/gitlab/sv/node-exporter/check] action create (skipped due to only_if)
2482 * template[/opt/gitlab/sv/node-exporter/finish] action create (skipped due to only_if)
2483 * directory[/opt/gitlab/sv/node-exporter/control] action create (up to date)
2484 * link[/opt/gitlab/init/node-exporter] action create (up to date)
2485 * file[/opt/gitlab/sv/node-exporter/down] action delete (up to date)
2486 * directory[/opt/gitlab/service] action create (up to date)
2487 * link[/opt/gitlab/service/node-exporter] action create (up to date)
2488 * ruby_block[wait for node-exporter service socket] action run (skipped due to not_if)
2489 (up to date)
2490 * consul_service[node-exporter] action delete
2491 * file[/var/opt/gitlab/consul/config.d/node-exporter-service.json] action delete (up to date)
2492 (up to date)
2493Recipe: monitoring::gitlab-exporter
2494 * directory[/var/opt/gitlab/gitlab-exporter] action create (up to date)
2495Recipe: <Dynamically Defined Resource>
2496 * service[gitlab-monitor] action nothing (skipped due to action :nothing)
2497Recipe: monitoring::gitlab-exporter
2498 * runit_service[gitlab-monitor] action disable
2499 * ruby_block[disable gitlab-monitor] action run (skipped due to only_if)
2500 (up to date)
2501 * directory[/var/opt/gitlab/gitlab-monitor] action delete (up to date)
2502 * directory[/var/log/gitlab/gitlab-exporter] action create (up to date)
2503 * template[/var/opt/gitlab/gitlab-exporter/gitlab-exporter.yml] action create (up to date)
2504 * file[/var/opt/gitlab/gitlab-exporter/RUBY_VERSION] action create (up to date)
2505Recipe: <Dynamically Defined Resource>
2506 * service[gitlab-exporter] action nothing (skipped due to action :nothing)
2507Recipe: monitoring::gitlab-exporter
2508 * runit_service[gitlab-exporter] action enable
2509 * ruby_block[restart_service] action nothing (skipped due to action :nothing)
2510 * ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
2511 * ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
2512 * directory[/opt/gitlab/sv/gitlab-exporter] action create (up to date)
2513 * template[/opt/gitlab/sv/gitlab-exporter/run] action create (up to date)
2514 * directory[/opt/gitlab/sv/gitlab-exporter/log] action create (up to date)
2515 * directory[/opt/gitlab/sv/gitlab-exporter/log/main] action create (up to date)
2516 * template[/opt/gitlab/sv/gitlab-exporter/log/run] action create (up to date)
2517 * template[/var/log/gitlab/gitlab-exporter/config] action create (up to date)
2518 * ruby_block[verify_chown_persisted_on_gitlab-exporter] action nothing (skipped due to action :nothing)
2519 * directory[/opt/gitlab/sv/gitlab-exporter/env] action create (up to date)
2520 * ruby_block[Delete unmanaged env files for gitlab-exporter service] action run (skipped due to only_if)
2521 * template[/opt/gitlab/sv/gitlab-exporter/check] action create (skipped due to only_if)
2522 * template[/opt/gitlab/sv/gitlab-exporter/finish] action create (skipped due to only_if)
2523 * directory[/opt/gitlab/sv/gitlab-exporter/control] action create (up to date)
2524 * link[/opt/gitlab/init/gitlab-exporter] action create (up to date)
2525 * file[/opt/gitlab/sv/gitlab-exporter/down] action delete (up to date)
2526 * directory[/opt/gitlab/service] action create (up to date)
2527 * link[/opt/gitlab/service/gitlab-exporter] action create (up to date)
2528 * ruby_block[wait for gitlab-exporter service socket] action run (skipped due to not_if)
2529 (up to date)
2530Recipe: monitoring::redis-exporter
2531 * directory[/var/log/gitlab/redis-exporter] action create (up to date)
2532 * directory[/opt/gitlab/etc/redis-exporter/env] action create (up to date)
2533 * env_dir[/opt/gitlab/etc/redis-exporter/env] action create
2534 * directory[/opt/gitlab/etc/redis-exporter/env] action create (up to date)
2535 * file[/opt/gitlab/etc/redis-exporter/env/SSL_CERT_DIR] action create (up to date)
2536 (up to date)
2537Recipe: <Dynamically Defined Resource>
2538 * service[redis-exporter] action nothing (skipped due to action :nothing)
2539Recipe: monitoring::redis-exporter
2540 * runit_service[redis-exporter] action enable
2541 * ruby_block[restart_service] action nothing (skipped due to action :nothing)
2542 * ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
2543 * ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
2544 * directory[/opt/gitlab/sv/redis-exporter] action create (up to date)
2545 * template[/opt/gitlab/sv/redis-exporter/run] action create (up to date)
2546 * directory[/opt/gitlab/sv/redis-exporter/log] action create (up to date)
2547 * directory[/opt/gitlab/sv/redis-exporter/log/main] action create (up to date)
2548 * template[/opt/gitlab/sv/redis-exporter/log/run] action create (up to date)
2549 * template[/var/log/gitlab/redis-exporter/config] action create (up to date)
2550 * ruby_block[verify_chown_persisted_on_redis-exporter] action nothing (skipped due to action :nothing)
2551 * directory[/opt/gitlab/sv/redis-exporter/env] action create (up to date)
2552 * ruby_block[Delete unmanaged env files for redis-exporter service] action run (skipped due to only_if)
2553 * template[/opt/gitlab/sv/redis-exporter/check] action create (skipped due to only_if)
2554 * template[/opt/gitlab/sv/redis-exporter/finish] action create (skipped due to only_if)
2555 * directory[/opt/gitlab/sv/redis-exporter/control] action create (up to date)
2556 * link[/opt/gitlab/init/redis-exporter] action create (up to date)
2557 * file[/opt/gitlab/sv/redis-exporter/down] action delete (up to date)
2558 * directory[/opt/gitlab/service] action create (up to date)
2559 * link[/opt/gitlab/service/redis-exporter] action create (up to date)
2560 * ruby_block[wait for redis-exporter service socket] action run (skipped due to not_if)
2561 (up to date)
2562 * consul_service[redis-exporter] action delete
2563 * file[/var/opt/gitlab/consul/config.d/redis-exporter-service.json] action delete (up to date)
2564 (up to date)
2565Recipe: monitoring::prometheus
2566 * directory[/var/opt/gitlab/prometheus] action create (up to date)
2567 * directory[/var/opt/gitlab/prometheus/rules] action create (up to date)
2568 * directory[/var/log/gitlab/prometheus] action create (up to date)
2569 * directory[/opt/gitlab/etc/prometheus/env] action create (up to date)
2570 * env_dir[/opt/gitlab/etc/prometheus/env] action create
2571 * directory[/opt/gitlab/etc/prometheus/env] action create (up to date)
2572 * file[/opt/gitlab/etc/prometheus/env/SSL_CERT_DIR] action create (up to date)
2573 (up to date)
2574 * execute[reload prometheus] action nothing (skipped due to action :nothing)
2575 * file[Prometheus config] action create (up to date)
2576Recipe: <Dynamically Defined Resource>
2577 * service[prometheus] action nothing (skipped due to action :nothing)
2578Recipe: monitoring::prometheus
2579 * runit_service[prometheus] action enable
2580 * ruby_block[restart_service] action nothing (skipped due to action :nothing)
2581 * ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
2582 * ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
2583 * directory[/opt/gitlab/sv/prometheus] action create (up to date)
2584 * template[/opt/gitlab/sv/prometheus/run] action create (up to date)
2585 * directory[/opt/gitlab/sv/prometheus/log] action create (up to date)
2586 * directory[/opt/gitlab/sv/prometheus/log/main] action create (up to date)
2587 * template[/opt/gitlab/sv/prometheus/log/run] action create (up to date)
2588 * template[/var/log/gitlab/prometheus/config] action create (up to date)
2589 * ruby_block[verify_chown_persisted_on_prometheus] action nothing (skipped due to action :nothing)
2590 * directory[/opt/gitlab/sv/prometheus/env] action create (up to date)
2591 * ruby_block[Delete unmanaged env files for prometheus service] action run (skipped due to only_if)
2592 * template[/opt/gitlab/sv/prometheus/check] action create (skipped due to only_if)
2593 * template[/opt/gitlab/sv/prometheus/finish] action create (skipped due to only_if)
2594 * directory[/opt/gitlab/sv/prometheus/control] action create (up to date)
2595 * link[/opt/gitlab/init/prometheus] action create (up to date)
2596 * file[/opt/gitlab/sv/prometheus/down] action delete (up to date)
2597 * directory[/opt/gitlab/service] action create (up to date)
2598 * link[/opt/gitlab/service/prometheus] action create (up to date)
2599 * ruby_block[wait for prometheus service socket] action run (skipped due to not_if)
2600 (up to date)
2601 * consul_service[prometheus] action delete
2602 * file[/var/opt/gitlab/consul/config.d/prometheus-service.json] action delete (up to date)
2603 (up to date)
2604 * template[/var/opt/gitlab/prometheus/rules/gitlab.rules] action create (up to date)
2605 * template[/var/opt/gitlab/prometheus/rules/node.rules] action create (up to date)
2606Recipe: monitoring::alertmanager
2607 * directory[/var/opt/gitlab/alertmanager] action create (up to date)
2608 * directory[/var/log/gitlab/alertmanager] action create (up to date)
2609 * directory[/opt/gitlab/etc/alertmanager/env] action create (up to date)
2610 * env_dir[/opt/gitlab/etc/alertmanager/env] action create
2611 * directory[/opt/gitlab/etc/alertmanager/env] action create (up to date)
2612 * file[/opt/gitlab/etc/alertmanager/env/SSL_CERT_DIR] action create (up to date)
2613 (up to date)
2614 * file[Alertmanager config] action create (up to date)
2615Recipe: <Dynamically Defined Resource>
2616 * service[alertmanager] action nothing (skipped due to action :nothing)
2617Recipe: monitoring::alertmanager
2618 * runit_service[alertmanager] action enable
2619 * ruby_block[restart_service] action nothing (skipped due to action :nothing)
2620 * ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
2621 * ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
2622 * directory[/opt/gitlab/sv/alertmanager] action create (up to date)
2623 * template[/opt/gitlab/sv/alertmanager/run] action create (up to date)
2624 * directory[/opt/gitlab/sv/alertmanager/log] action create (up to date)
2625 * directory[/opt/gitlab/sv/alertmanager/log/main] action create (up to date)
2626 * template[/opt/gitlab/sv/alertmanager/log/run] action create (up to date)
2627 * template[/var/log/gitlab/alertmanager/config] action create (up to date)
2628 * ruby_block[verify_chown_persisted_on_alertmanager] action nothing (skipped due to action :nothing)
2629 * directory[/opt/gitlab/sv/alertmanager/env] action create (up to date)
2630 * ruby_block[Delete unmanaged env files for alertmanager service] action run (skipped due to only_if)
2631 * template[/opt/gitlab/sv/alertmanager/check] action create (skipped due to only_if)
2632 * template[/opt/gitlab/sv/alertmanager/finish] action create (skipped due to only_if)
2633 * directory[/opt/gitlab/sv/alertmanager/control] action create (up to date)
2634 * link[/opt/gitlab/init/alertmanager] action create (up to date)
2635 * file[/opt/gitlab/sv/alertmanager/down] action delete (up to date)
2636 * directory[/opt/gitlab/service] action create (up to date)
2637 * link[/opt/gitlab/service/alertmanager] action create (up to date)
2638 * ruby_block[wait for alertmanager service socket] action run (skipped due to not_if)
2639 (up to date)
2640Recipe: monitoring::postgres-exporter
2641 * directory[/var/log/gitlab/postgres-exporter] action create (up to date)
2642 * directory[/var/opt/gitlab/postgres-exporter] action create (up to date)
2643 * env_dir[/opt/gitlab/etc/postgres-exporter/env] action create
2644 * directory[/opt/gitlab/etc/postgres-exporter/env] action create (up to date)
2645 * file[/opt/gitlab/etc/postgres-exporter/env/SSL_CERT_DIR] action create (up to date)
2646 * file[/opt/gitlab/etc/postgres-exporter/env/DATA_SOURCE_NAME] action create (up to date)
2647 (up to date)
2648Recipe: <Dynamically Defined Resource>
2649 * service[postgres-exporter] action nothing (skipped due to action :nothing)
2650Recipe: monitoring::postgres-exporter
2651 * runit_service[postgres-exporter] action enable
2652 * ruby_block[restart_service] action nothing (skipped due to action :nothing)
2653 * ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
2654 * ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
2655 * directory[/opt/gitlab/sv/postgres-exporter] action create (up to date)
2656 * template[/opt/gitlab/sv/postgres-exporter/run] action create (up to date)
2657 * directory[/opt/gitlab/sv/postgres-exporter/log] action create (up to date)
2658 * directory[/opt/gitlab/sv/postgres-exporter/log/main] action create (up to date)
2659 * template[/opt/gitlab/sv/postgres-exporter/log/run] action create (up to date)
2660 * template[/var/log/gitlab/postgres-exporter/config] action create (up to date)
2661 * ruby_block[verify_chown_persisted_on_postgres-exporter] action nothing (skipped due to action :nothing)
2662 * directory[/opt/gitlab/sv/postgres-exporter/env] action create (up to date)
2663 * ruby_block[Delete unmanaged env files for postgres-exporter service] action run (skipped due to only_if)
2664 * template[/opt/gitlab/sv/postgres-exporter/check] action create (skipped due to only_if)
2665 * template[/opt/gitlab/sv/postgres-exporter/finish] action create (skipped due to only_if)
2666 * directory[/opt/gitlab/sv/postgres-exporter/control] action create (up to date)
2667 * link[/opt/gitlab/init/postgres-exporter] action create (up to date)
2668 * file[/opt/gitlab/sv/postgres-exporter/down] action delete (up to date)
2669 * directory[/opt/gitlab/service] action create (up to date)
2670 * link[/opt/gitlab/service/postgres-exporter] action create (up to date)
2671 * ruby_block[wait for postgres-exporter service socket] action run (skipped due to not_if)
2672 (up to date)
2673 * template[/var/opt/gitlab/postgres-exporter/queries.yaml] action create (up to date)
2674 * consul_service[postgres-exporter] action delete
2675 * file[/var/opt/gitlab/consul/config.d/postgres-exporter-service.json] action delete (up to date)
2676 (up to date)
2677Recipe: monitoring::grafana
2678 * directory[/var/log/gitlab/grafana] action create (up to date)
2679 * directory[/var/opt/gitlab/grafana] action create (up to date)
2680 * directory[/var/opt/gitlab/grafana/provisioning] action create (up to date)
2681 * directory[/var/opt/gitlab/grafana/provisioning/dashboards] action create (up to date)
2682 * directory[/var/opt/gitlab/grafana/provisioning/datasources] action create (up to date)
2683 * directory[/var/opt/gitlab/grafana/provisioning/notifiers] action create (up to date)
2684 * file[/var/opt/gitlab/grafana/CVE_reset_status] action create (up to date)
2685 * link[/var/opt/gitlab/grafana/conf] action create (up to date)
2686 * link[/var/opt/gitlab/grafana/public] action create (up to date)
2687 * directory[/opt/gitlab/etc/grafana/env] action create (up to date)
2688 * ruby_block[populate Grafana configuration options] action run
2689 - execute the ruby block populate Grafana configuration options
2690 * env_dir[/opt/gitlab/etc/grafana/env] action create
2691 * directory[/opt/gitlab/etc/grafana/env] action create (up to date)
2692 * file[/opt/gitlab/etc/grafana/env/SSL_CERT_DIR] action create (up to date)
2693 (up to date)
2694 * template[/var/opt/gitlab/grafana/grafana.ini] action create (up to date)
2695 * file[/var/opt/gitlab/grafana/provisioning/dashboards/gitlab_dashboards.yml] action create (up to date)
2696 * file[/var/opt/gitlab/grafana/provisioning/datasources/gitlab_datasources.yml] action create (up to date)
2697Recipe: <Dynamically Defined Resource>
2698 * service[grafana] action nothing (skipped due to action :nothing)
2699Recipe: monitoring::grafana
2700 * runit_service[grafana] action enable
2701 * ruby_block[restart_service] action nothing (skipped due to action :nothing)
2702 * ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
2703 * ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
2704 * directory[/opt/gitlab/sv/grafana] action create (up to date)
2705 * template[/opt/gitlab/sv/grafana/run] action create (up to date)
2706 * directory[/opt/gitlab/sv/grafana/log] action create (up to date)
2707 * directory[/opt/gitlab/sv/grafana/log/main] action create (up to date)
2708 * template[/opt/gitlab/sv/grafana/log/run] action create (up to date)
2709 * template[/var/log/gitlab/grafana/config] action create (up to date)
2710 * ruby_block[verify_chown_persisted_on_grafana] action nothing (skipped due to action :nothing)
2711 * directory[/opt/gitlab/sv/grafana/env] action create (up to date)
2712 * ruby_block[Delete unmanaged env files for grafana service] action run (skipped due to only_if)
2713 * template[/opt/gitlab/sv/grafana/check] action create (skipped due to only_if)
2714 * template[/opt/gitlab/sv/grafana/finish] action create (skipped due to only_if)
2715 * directory[/opt/gitlab/sv/grafana/control] action create (up to date)
2716 * link[/opt/gitlab/init/grafana] action create (up to date)
2717 * file[/opt/gitlab/sv/grafana/down] action delete (up to date)
2718 * directory[/opt/gitlab/service] action create (up to date)
2719 * link[/opt/gitlab/service/grafana] action create (up to date)
2720 * ruby_block[wait for grafana service socket] action run (skipped due to not_if)
2721 (up to date)
2722Recipe: gitlab::unicorn
2723 * runit_service[unicorn] action restart (up to date)
2724 * runit_service[unicorn] action restart (up to date)
2725Recipe: gitlab::sidekiq
2726 * runit_service[sidekiq] action restart (up to date)
2727Recipe: gitlab::gitlab-rails
2728 * execute[clear the gitlab-rails cache] action run
2729 - execute /opt/gitlab/bin/gitlab-rake cache:clear
2730Recipe: gitlab::gitlab-pages
2731 * runit_service[gitlab-pages] action restart (up to date)
2732Recipe: gitaly::enable
2733 * runit_service[gitaly] action hup
2734 - send hup to runit_service[gitaly]
2735Recipe: gitlab::gitlab-workhorse
2736 * runit_service[gitlab-workhorse] action restart (up to date)
2737
2738Running handlers:
2739Running handlers complete
2740Chef Client finished, 28/780 resources updated in 02 minutes 44 seconds
2741gitlab Reconfigured!