400 server error after upgrading from GitLab 13.5.4-ee.0 to 13.6.1-ee.0 on Ubuntu 18.04
On Ubuntu Server 18.04, after upgrading the package gitlab-ee from 13.5.4-ee.0 to 13.6.1-ee.0, I have the error "Cannot connect to the remote repository" on push and on clone. The server returns a 400 error code. This happens on all my Gitlab repositories on my Ubuntu Server.
In the following logs, for privacy reasons, I replaced my actual host with "mysubdomain.mydomain.com", my actual project with "myproject" and I hided the IP.
Before the upgrade:
git clone https://root@mysubdomain.mydomain.com/myproject/client.git
Cloning into 'client'...
Password for 'https://root@mysubdomain.mydomain.com':
remote: Enumerating objects: 83, done.
remote: Counting objects: 100% (83/83), done.
remote: Compressing objects: 100% (71/71), done.
Ricezione degli oggetti: 6% (268/4402), 3.44 MiB | 869.00 KiB/s Immediately after the upgrade to 13.6.1-ee.0, with no other changes:
git clone https://root@mysubdomain.mydomain.com/myproject/client.git
Cloning into 'client'...
Password for 'https://root@mysubdomain.mydomain.com':
remote: Bad Request
fatal: unable to access 'https://root@mysubdomain.mydomain.com/myproject/client.git/': The requested URL returned error: 400Note that gitlab-ctl restart or a server reboot don't help.
No other changes were done to the server configuration and to the repositories configuration and permissions.
Luckily, I temporarily circumvented this issue restoring the old package 13.5.4-ee.0 (since I had a server snapshot). I confirm that upgrading again to 13.6.1-ee.0 reproduces the issue, so this update is bugged.
This is the full server log of the package update:
puciosino@miaomiao ~ $ ssh root@mysubdomain.mydomain.com
Welcome to Ubuntu 18.04.5 LTS (GNU/Linux 4.15.0-124-generic x86_64)
* Documentation: https://help.ubuntu.com
* Management: https://landscape.canonical.com
* Support: https://ubuntu.com/advantage
System information as of Thu Nov 26 11:48:53 CET 2020
System load: 0.57 Processes: 185
Usage of /: 13.8% of 77.25GB Users logged in: 0
Memory usage: 67% IP address for eth0: xx.xxx.xxx.xxx
Swap usage: 0%
* Introducing self-healing high availability clustering for MicroK8s!
Super simple, hardened and opinionated Kubernetes for production.
https://microk8s.io/high-availability
* Canonical Livepatch is available for installation.
- Reduce system reboots and improve kernel security. Activate at:
https://ubuntu.com/livepatch
0 packages can be updated.
0 updates are security updates.
New release '20.04.1 LTS' available.
Run 'do-release-upgrade' to upgrade to it.
Last login: Thu Nov 26 11:30:24 2020 from 79.53.198.195
root@Gitlab:~# apt-mark unhold gitlab-ee
Canceled hold on gitlab-ee.
root@Gitlab:~# apt update
Get:1 http://security.ubuntu.com/ubuntu bionic-security InRelease [88.7 kB]
Hit:2 http://it.archive.ubuntu.com/ubuntu bionic InRelease
Hit:3 http://it.archive.ubuntu.com/ubuntu bionic-updates InRelease
Hit:4 http://it.archive.ubuntu.com/ubuntu bionic-backports InRelease
Hit:5 https://packages.gitlab.com/gitlab/gitlab-ee/ubuntu bionic InRelease
Fetched 88.7 kB in 1s (63.4 kB/s)
Reading package lists... Done
Building dependency tree
Reading state information... Done
1 package can be upgraded. Run 'apt list --upgradable' to see it.
root@Gitlab:~# apt upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
The following packages will be upgraded:
gitlab-ee
1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 898 MB of archives.
After this operation, 50.9 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 https://packages.gitlab.com/gitlab/gitlab-ee/ubuntu bionic/main amd64 gitlab-ee amd64 13.6.1-ee.0 [898 MB]
Fetched 898 MB in 23s (38.2 MB/s)
(Reading database ... 155697 files and directories currently installed.)
Preparing to unpack .../gitlab-ee_13.6.1-ee.0_amd64.deb ...
gitlab preinstall: Automatically backing up only the GitLab SQL database (excluding everything else!)
2020-11-26 11:50:15 +0100 -- Dumping database ...
Dumping PostgreSQL database gitlabhq_production ... [DONE]
2020-11-26 11:50:18 +0100 -- done
2020-11-26 11:50:18 +0100 -- Dumping repositories ...
2020-11-26 11:50:18 +0100 -- [SKIPPED]
2020-11-26 11:50:18 +0100 -- Dumping uploads ...
2020-11-26 11:50:18 +0100 -- [SKIPPED]
2020-11-26 11:50:18 +0100 -- Dumping builds ...
2020-11-26 11:50:18 +0100 -- [SKIPPED]
2020-11-26 11:50:18 +0100 -- Dumping artifacts ...
2020-11-26 11:50:18 +0100 -- [SKIPPED]
2020-11-26 11:50:18 +0100 -- Dumping pages ...
2020-11-26 11:50:18 +0100 -- [SKIPPED]
2020-11-26 11:50:18 +0100 -- Dumping lfs objects ...
2020-11-26 11:50:18 +0100 -- [SKIPPED]
2020-11-26 11:50:18 +0100 -- Dumping container registry images ...
2020-11-26 11:50:18 +0100 -- [SKIPPED]
Creating backup archive: 1606387818_2020_11_26_13.5.4-ee_gitlab_backup.tar ... done
Uploading backup archive to remote storage ... skipped
Deleting tmp directories ... done
done
Deleting old backups ... skipping
Warning: Your gitlab.rb and gitlab-secrets.json files contain sensitive data
and are not included in this backup. You will need these files to restore a backup.
Please back them up manually.
Backup task is done.
gitlab preinstall: Automatically backing up /etc/gitlab
Running configuration backup
Creating configuration backup archive: gitlab_config_1606387819_2020_11_26.tar
/etc/gitlab/
/etc/gitlab/gitlab.rb
/etc/gitlab/gitlab-secrets.json
/etc/gitlab/trusted-certs/
/etc/gitlab/ssl/
/etc/gitlab/ssl/mysubdomain.mydomain.com.key-staging
/etc/gitlab/ssl/mysubdomain.mydomain.com.crt-staging
/etc/gitlab/ssl/mysubdomain.mydomain.com.crt
/etc/gitlab/ssl/mysubdomain.mydomain.com.key
Configuration backup archive complete: /etc/gitlab/config_backup/gitlab_config_1606387819_2020_11_26.tar
Unpacking gitlab-ee (13.6.1-ee.0) over (13.5.4-ee.0) ...
Setting up gitlab-ee (13.6.1-ee.0) ...
Checking PostgreSQL executables:Starting Chef Infra Client, version 15.14.0
resolving cookbooks for run list: ["gitlab-ee::config", "postgresql::bin"]
Synchronizing Cookbooks:
- gitlab-ee (0.0.1)
- postgresql (0.1.0)
- package (0.1.0)
- gitlab (0.0.1)
- consul (0.1.0)
- repmgr (0.1.0)
- runit (5.1.3)
- patroni (0.1.0)
- logrotate (0.0.0)
- registry (0.1.0)
- mattermost (0.1.0)
- redis (0.1.0)
- praefect (0.1.0)
- gitlab-kas (0.1.0)
- gitaly (0.1.0)
- acme (4.1.1)
- letsencrypt (0.1.0)
- crond (0.1.0)
- monitoring (0.1.0)
- nginx (0.1.0)
Installing Cookbook Gems:
Compiling Cookbooks...
Converging 3 resources
Recipe: postgresql::bin
* ruby_block[check_postgresql_version] action run (skipped due to not_if)
* ruby_block[check_postgresql_version_is_deprecated] action run (skipped due to not_if)
* ruby_block[Link postgresql bin files to the correct version] action run (skipped due to only_if)
Running handlers:
Running handlers complete
Chef Infra Client finished, 0/3 resources updated in 08 seconds
Checking PostgreSQL executables: OK
Checking for an omnibus managed postgresql: OKlable and attempting automatic upgrade to it:
Checking if postgresql['version'] is set: OK
Checking if we already upgraded: OK
The latest version 11.9 is already running, nothing to do
Checking if a newer PostgreSQL version is available and attempting automatic upgrade to it: OK
Shutting down all GitLab services except those needed for migrations
ok: down: alertmanager: 1s, normally up, want up
ok: down: crond: 0s, normally up
ok: down: gitlab-exporter: 0s, normally up
ok: down: gitlab-workhorse: 1s, normally up
ok: down: grafana: 0s, normally up
ok: down: logrotate: 1s, normally up
ok: down: nginx: 0s, normally up
ok: down: node-exporter: 1s, normally up
ok: down: postgres-exporter: 0s, normally up
ok: down: prometheus: 0s, normally up
ok: down: puma: 0s, normally up
ok: down: redis-exporter: 1s, normally up
ok: down: registry: 0s, normally up
ok: down: sidekiq: 0s, normally up
Ensuring the required services are running
ok: run: postgresql: (pid 1460) 565s
ok: run: redis: (pid 1465) 565s
ok: run: gitaly: (pid 1365) 567s
run: postgresql: (pid 1460) 565s; run: log: (pid 1364) 567s
run: redis: (pid 1465) 565s; run: log: (pid 1374) 567s
run: gitaly: (pid 1365) 567s; run: log: (pid 1342) 567s
Ensuring Prometheus is updated:Already running Prometheus version 2.
Ensuring Prometheus is updated: OK
Reconfigure GitLab to apply migrations
Starting Chef Infra Client, version 15.14.0
resolving cookbooks for run list: ["gitlab-ee"]
Synchronizing Cookbooks:
- package (0.1.0)
- gitlab-ee (0.0.1)
- patroni (0.1.0)
- runit (5.1.3)
- logrotate (0.0.0)
- redis (0.1.0)
- consul (0.1.0)
- gitlab (0.0.1)
- mattermost (0.1.0)
- gitaly (0.1.0)
- gitlab-kas (0.1.0)
- letsencrypt (0.1.0)
- repmgr (0.1.0)
- acme (4.1.1)
- registry (0.1.0)
- praefect (0.1.0)
- crond (0.1.0)
- postgresql (0.1.0)
- nginx (0.1.0)
- monitoring (0.1.0)
Installing Cookbook Gems:
Compiling Cookbooks...
Recipe: gitlab::default
* directory[/etc/gitlab] action create (up to date)
Converging 309 resources
* directory[/etc/gitlab] action create (up to date)
* directory[Create /var/opt/gitlab] action create (up to date)
* directory[Create /var/log/gitlab] action create (up to date)
* directory[/opt/gitlab/embedded/etc] action create (up to date)
* template[/opt/gitlab/embedded/etc/gitconfig] action create (up to date)
Recipe: gitlab::web-server
* account[Webserver user and group] action create
* group[Webserver user and group] action create (up to date)
* linux_user[Webserver user and group] action create (up to date)
(up to date)
Recipe: gitlab::users
* directory[/var/opt/gitlab] action create (up to date)
* account[GitLab user and group] action create
* group[GitLab user and group] action create (up to date)
* linux_user[GitLab user and group] action create (up to date)
(up to date)
* template[/var/opt/gitlab/.gitconfig] action create (up to date)
* directory[/var/opt/gitlab/.bundle] action create (up to date)
Recipe: gitlab::gitlab-shell
* storage_directory[/var/opt/gitlab/.ssh] action create
* ruby_block[directory resource: /var/opt/gitlab/.ssh] action run (skipped due to not_if)
(up to date)
* directory[/var/log/gitlab/gitlab-shell/] action create (up to date)
* directory[/var/opt/gitlab/gitlab-shell] action create (up to date)
* templatesymlink[Create a config.yml and create a symlink to Rails root] action create
* template[/var/opt/gitlab/gitlab-shell/config.yml] action create
- update content in file /var/opt/gitlab/gitlab-shell/config.yml from f6da37 to 301fbf
--- /var/opt/gitlab/gitlab-shell/config.yml 2020-10-23 16:38:43.635067465 +0200
+++ /var/opt/gitlab/gitlab-shell/.chef-config20201126-15996-15aiqr8.yml 2020-11-26 11:53:05.259010445 +0100
@@ -21,6 +21,10 @@
# File used as authorized_keys for gitlab user
auth_file: "/var/opt/gitlab/.ssh/authorized_keys"
+# SSL certificate dir where custom certificates can be placed
+# https://golang.org/pkg/crypto/x509/
+ssl_cert_dir: "/opt/gitlab/embedded/ssl/certs/"
+
# Log file.
# Default is gitlab-shell.log in the root directory.
log_file: "/var/log/gitlab/gitlab-shell/gitlab-shell.log"
* link[Link /opt/gitlab/embedded/service/gitlab-shell/config.yml to /var/opt/gitlab/gitlab-shell/config.yml] action create (up to date)
* link[/opt/gitlab/embedded/service/gitlab-shell/.gitlab_shell_secret] action create (up to date)
* file[/var/opt/gitlab/.ssh/authorized_keys] action create_if_missing (up to date)
Recipe: gitlab::gitlab-rails
* storage_directory[/var/opt/gitlab/git-data] action create
* ruby_block[directory resource: /var/opt/gitlab/git-data] action run (skipped due to not_if)
(up to date)
* storage_directory[/var/opt/gitlab/git-data/repositories] action create
* ruby_block[directory resource: /var/opt/gitlab/git-data/repositories] action run (skipped due to not_if)
(up to date)
Recipe: gitlab::rails_pages_shared_path
* storage_directory[/var/opt/gitlab/gitlab-rails/shared] action create
* ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared] action run (skipped due to not_if)
(up to date)
* storage_directory[/var/opt/gitlab/gitlab-rails/shared/pages] action create
* ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared/pages] action run (skipped due to not_if)
(up to date)
Recipe: gitlab::gitlab-rails
* storage_directory[/var/opt/gitlab/gitlab-rails/shared/artifacts] action create
* ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared/artifacts] action run (skipped due to not_if)
(up to date)
* storage_directory[/var/opt/gitlab/gitlab-rails/shared/external-diffs] action create
* ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared/external-diffs] action run (skipped due to not_if)
(up to date)
* storage_directory[/var/opt/gitlab/gitlab-rails/shared/lfs-objects] action create
* ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared/lfs-objects] action run (skipped due to not_if)
(up to date)
* storage_directory[/var/opt/gitlab/gitlab-rails/shared/packages] action create
* ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared/packages] action run (skipped due to not_if)
(up to date)
* storage_directory[/var/opt/gitlab/gitlab-rails/shared/dependency_proxy] action create
* ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared/dependency_proxy] action run (skipped due to not_if)
(up to date)
* storage_directory[/var/opt/gitlab/gitlab-rails/shared/terraform_state] action create
* ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared/terraform_state] action run (skipped due to not_if)
(up to date)
* storage_directory[/var/opt/gitlab/gitlab-rails/uploads] action create
* ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/uploads] action run (skipped due to not_if)
(up to date)
* storage_directory[/var/opt/gitlab/gitlab-ci/builds] action create
* ruby_block[directory resource: /var/opt/gitlab/gitlab-ci/builds] action run (skipped due to not_if)
(up to date)
* storage_directory[/var/opt/gitlab/gitlab-rails/shared/cache] action create
* ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared/cache] action run (skipped due to not_if)
(up to date)
* storage_directory[/var/opt/gitlab/gitlab-rails/shared/tmp] action create
* ruby_block[directory resource: /var/opt/gitlab/gitlab-rails/shared/tmp] action run (skipped due to not_if)
(up to date)
* storage_directory[/opt/gitlab/embedded/service/gitlab-rails/public] action create (skipped due to only_if)
* directory[create /var/opt/gitlab/gitlab-rails/etc] action create (up to date)
* directory[create /opt/gitlab/etc/gitlab-rails] action create (up to date)
* directory[create /var/opt/gitlab/gitlab-rails/working] action create (up to date)
* directory[create /var/opt/gitlab/gitlab-rails/tmp] action create (up to date)
* directory[create /var/opt/gitlab/gitlab-rails/upgrade-status] action create (up to date)
* directory[create /var/log/gitlab/gitlab-rails] action create (up to date)
* storage_directory[/var/opt/gitlab/backups] action create
* ruby_block[directory resource: /var/opt/gitlab/backups] action run (skipped due to not_if)
(up to date)
* directory[/var/opt/gitlab/gitlab-rails] action create (up to date)
* directory[/var/opt/gitlab/gitlab-ci] action create (up to date)
* file[/var/opt/gitlab/gitlab-rails/etc/gitlab-registry.key] action create (up to date)
* template[/opt/gitlab/etc/gitlab-rails/gitlab-rails-rc] action create (up to date)
* file[/opt/gitlab/embedded/service/gitlab-rails/.secret] action delete (up to date)
* file[/var/opt/gitlab/gitlab-rails/etc/secret] action delete (up to date)
* templatesymlink[Create a database.yml and create a symlink to Rails root] action create
* template[/var/opt/gitlab/gitlab-rails/etc/database.yml] action create (up to date)
* 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)
(up to date)
* templatesymlink[Create a secrets.yml and create a symlink to Rails root] action create
* template[/var/opt/gitlab/gitlab-rails/etc/secrets.yml] action create (up to date)
* 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)
(up to date)
* templatesymlink[Create a resque.yml and create a symlink to Rails root] action create
* template[/var/opt/gitlab/gitlab-rails/etc/resque.yml] action create (up to date)
* 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)
(up to date)
* templatesymlink[Create a cable.yml and create a symlink to Rails root] action create
* template[/var/opt/gitlab/gitlab-rails/etc/cable.yml] action create (up to date)
* link[Link /opt/gitlab/embedded/service/gitlab-rails/config/cable.yml to /var/opt/gitlab/gitlab-rails/etc/cable.yml] action create (up to date)
(up to date)
* templatesymlink[Create a redis.cache.yml and create a symlink to Rails root] action create (skipped due to not_if)
* file[/opt/gitlab/embedded/service/gitlab-rails/config/redis.cache.yml] action delete (up to date)
* file[/var/opt/gitlab/gitlab-rails/etc/redis.cache.yml] action delete (up to date)
* templatesymlink[Create a redis.queues.yml and create a symlink to Rails root] action create (skipped due to not_if)
* file[/opt/gitlab/embedded/service/gitlab-rails/config/redis.queues.yml] action delete (up to date)
* file[/var/opt/gitlab/gitlab-rails/etc/redis.queues.yml] action delete (up to date)
* templatesymlink[Create a redis.shared_state.yml and create a symlink to Rails root] action create (skipped due to not_if)
* file[/opt/gitlab/embedded/service/gitlab-rails/config/redis.shared_state.yml] action delete (up to date)
* file[/var/opt/gitlab/gitlab-rails/etc/redis.shared_state.yml] action delete (up to date)
* templatesymlink[Create a smtp_settings.rb and create a symlink to Rails root] action delete
* file[/var/opt/gitlab/gitlab-rails/etc/smtp_settings.rb] action delete (up to date)
* link[/opt/gitlab/embedded/service/gitlab-rails/config/initializers/smtp_settings.rb] action delete (up to date)
(up to date)
* templatesymlink[Create a gitlab.yml and create a symlink to Rails root] action create
* template[/var/opt/gitlab/gitlab-rails/etc/gitlab.yml] action create
- update content in file /var/opt/gitlab/gitlab-rails/etc/gitlab.yml from f55a9f to 5b4ed2
--- /var/opt/gitlab/gitlab-rails/etc/gitlab.yml 2020-10-23 16:38:45.111061435 +0200
+++ /var/opt/gitlab/gitlab-rails/etc/.chef-gitlab20201126-15996-1x6auw5.yml 2020-11-26 11:53:06.575000755 +0100
@@ -741,6 +741,7 @@
extra:
+
rack_attack:
git_basic_auth:
* 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)
* templatesymlink[Create a gitlab_workhorse_secret and create a symlink to Rails root] action create
* template[/var/opt/gitlab/gitlab-rails/etc/gitlab_workhorse_secret] action create (up to date)
* 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)
(up to date)
* templatesymlink[Create a gitlab_shell_secret and create a symlink to Rails root] action create
* template[/var/opt/gitlab/gitlab-rails/etc/gitlab_shell_secret] action create (up to date)
* 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)
(up to date)
* templatesymlink[Create a gitlab_pages_secret and create a symlink to Rails root] action create
* template[/var/opt/gitlab/gitlab-rails/etc/gitlab_pages_secret] action create (up to date)
* 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)
(up to date)
* templatesymlink[Create a gitlab_kas_secret and create a symlink to Rails root] action create
* template[/var/opt/gitlab/gitlab-rails/etc/gitlab_kas_secret] action create (up to date)
* link[Link /opt/gitlab/embedded/service/gitlab-rails/.gitlab_kas_secret to /var/opt/gitlab/gitlab-rails/etc/gitlab_kas_secret] action create
- unlink existing symlink to file at /opt/gitlab/embedded/service/gitlab-rails/.gitlab_kas_secret
- create symlink at /opt/gitlab/embedded/service/gitlab-rails/.gitlab_kas_secret to /var/opt/gitlab/gitlab-rails/etc/gitlab_kas_secret
* link[/opt/gitlab/embedded/service/gitlab-rails/config/initializers/relative_url.rb] action delete (up to date)
* file[/var/opt/gitlab/gitlab-rails/etc/relative_url.rb] action delete (up to date)
* env_dir[/opt/gitlab/etc/gitlab-rails/env] action create
* directory[/opt/gitlab/etc/gitlab-rails/env] action create (up to date)
* file[/opt/gitlab/etc/gitlab-rails/env/HOME] action create (up to date)
* file[/opt/gitlab/etc/gitlab-rails/env/RAILS_ENV] action create (up to date)
* file[/opt/gitlab/etc/gitlab-rails/env/LD_PRELOAD] action create (up to date)
* file[/opt/gitlab/etc/gitlab-rails/env/SIDEKIQ_MEMORY_KILLER_MAX_RSS] action create (up to date)
* file[/opt/gitlab/etc/gitlab-rails/env/BUNDLE_GEMFILE] action create (up to date)
* file[/opt/gitlab/etc/gitlab-rails/env/PATH] action create (up to date)
* file[/opt/gitlab/etc/gitlab-rails/env/ICU_DATA] action create (up to date)
* file[/opt/gitlab/etc/gitlab-rails/env/PYTHONPATH] action create (up to date)
* file[/opt/gitlab/etc/gitlab-rails/env/EXECJS_RUNTIME] action create (up to date)
* file[/opt/gitlab/etc/gitlab-rails/env/TZ] action create (up to date)
(up to date)
* link[/opt/gitlab/embedded/service/gitlab-rails/tmp] action create (up to date)
* link[/opt/gitlab/embedded/service/gitlab-rails/public/uploads] action create (up to date)
* link[/opt/gitlab/embedded/service/gitlab-rails/log] action create (up to date)
* link[/var/log/gitlab/gitlab-rails/sidekiq.log] action delete (skipped due to only_if)
* file[/opt/gitlab/embedded/service/gitlab-rails/db/structure.sql] action create
- change owner from 'root' to 'git'
* remote_file[/var/opt/gitlab/gitlab-rails/VERSION] action create/opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/chef-15.14.0/lib/chef/provider/remote_file/local_file.rb:43: warning: URI.unescape is obsolete
- update content in file /var/opt/gitlab/gitlab-rails/VERSION from 26bdce to c4d072
--- /var/opt/gitlab/gitlab-rails/VERSION 2020-11-16 15:45:41.009421244 +0100
+++ /var/opt/gitlab/gitlab-rails/.chef-VERSION20201126-15996-1ngk0cj 2020-11-26 11:53:07.030997401 +0100
@@ -1 +1 @@
-13.5.4-ee
+13.6.1-ee
* remote_file[/var/opt/gitlab/gitlab-rails/REVISION] action create/opt/gitlab/embedded/lib/ruby/gems/2.7.0/gems/chef-15.14.0/lib/chef/provider/remote_file/local_file.rb:43: warning: URI.unescape is obsolete
- update content in file /var/opt/gitlab/gitlab-rails/REVISION from e1f286 to e2dd35
--- /var/opt/gitlab/gitlab-rails/REVISION 2020-11-16 15:45:41.033421159 +0100
+++ /var/opt/gitlab/gitlab-rails/.chef-REVISION20201126-15996-pn367m 2020-11-26 11:53:07.058997198 +0100
@@ -1 +1 @@
-1a38002e630
+a0e59de39b3
* version_file[Create version file for Rails] action create
* file[/var/opt/gitlab/gitlab-rails/RUBY_VERSION] action create
- update content in file /var/opt/gitlab/gitlab-rails/RUBY_VERSION from d89bae to 22dcc2
--- /var/opt/gitlab/gitlab-rails/RUBY_VERSION 2020-06-07 11:34:12.581452264 +0200
+++ /var/opt/gitlab/gitlab-rails/.chef-RUBY_VERSION20201126-15996-sjjxmv 2020-11-26 11:53:07.114996792 +0100
@@ -1 +1 @@
-ruby 2.6.6p146 (2020-03-31 revision 67876) [x86_64-linux]
+ruby 2.7.2p137 (2020-10-01 revision 5445e04352) [x86_64-linux]
* execute[clear the gitlab-rails cache] action nothing (skipped due to action :nothing)
* file[/var/opt/gitlab/gitlab-rails/config.ru] action delete (up to date)
Recipe: gitlab::selinux
* bash[Set proper security context on ssh files for selinux] action nothing (skipped due to action :nothing)
Recipe: gitlab::add_trusted_certs
* directory[/etc/gitlab/trusted-certs] action create (up to date)
* directory[/opt/gitlab/embedded/ssl/certs] action create (up to date)
* file[/opt/gitlab/embedded/ssl/certs/README] action create (up to date)
* ruby_block[Move existing certs and link to /opt/gitlab/embedded/ssl/certs] action run
* Moving existing certificates found in /opt/gitlab/embedded/ssl/certs
* Symlinking existing certificates found in /etc/gitlab/trusted-certs
- execute the ruby block Move existing certs and link to /opt/gitlab/embedded/ssl/certs
Recipe: gitlab::default
* service[create a temporary unicorn service] action nothing (skipped due to action :nothing)
* service[create a temporary puma service] action nothing (skipped due to action :nothing)
* service[create a temporary actioncable service] action nothing (skipped due to action :nothing)
* service[create a temporary sidekiq service] action nothing (skipped due to action :nothing)
* service[create a temporary mailroom service] action nothing (skipped due to action :nothing)
Recipe: package::runit_systemd
* directory[/usr/lib/systemd/system] action create (up to date)
* template[/usr/lib/systemd/system/gitlab-runsvdir.service] action create (up to date)
* file[/etc/systemd/system/default.target.wants/gitlab-runsvdir.service] action delete (up to date)
* file[/etc/systemd/system/basic.target.wants/gitlab-runsvdir.service] action delete (up to date)
* execute[systemctl daemon-reload] action nothing (skipped due to action :nothing)
* execute[systemctl enable gitlab-runsvdir] action nothing (skipped due to action :nothing)
* execute[systemctl start gitlab-runsvdir] action nothing (skipped due to action :nothing)
Recipe: package::sysctl
* execute[reload all sysctl conf] action nothing (skipped due to action :nothing)
Recipe: postgresql::bin
* ruby_block[check_postgresql_version] action run (skipped due to not_if)
* ruby_block[check_postgresql_version_is_deprecated] action run (skipped due to not_if)
* ruby_block[Link postgresql bin files to the correct version] action run (skipped due to only_if)
Recipe: redis::enable
* redis_service[redis] action create
* account[user and group for redis] action create
* group[user and group for redis] action create (up to date)
* linux_user[user and group for redis] action create (up to date)
(up to date)
* group[Socket group] action create (up to date)
* directory[/var/opt/gitlab/redis] action create (up to date)
* directory[/var/log/gitlab/redis] action create (up to date)
* template[/var/opt/gitlab/redis/redis.conf] action create (up to date)
Recipe: <Dynamically Defined Resource>
* service[redis] action nothing (skipped due to action :nothing)
* runit_service[redis] action enable
* ruby_block[restart_service] action nothing (skipped due to action :nothing)
* ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
* ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/sv/redis] action create (up to date)
* template[/opt/gitlab/sv/redis/run] action create (up to date)
* directory[/opt/gitlab/sv/redis/log] action create (up to date)
* directory[/opt/gitlab/sv/redis/log/main] action create (up to date)
* template[/opt/gitlab/sv/redis/log/config] action create (up to date)
* ruby_block[verify_chown_persisted_on_redis] action nothing (skipped due to action :nothing)
* link[/var/log/gitlab/redis/config] action create (up to date)
* template[/opt/gitlab/sv/redis/log/run] action create (up to date)
* directory[/opt/gitlab/sv/redis/env] action create (up to date)
* ruby_block[Delete unmanaged env files for redis service] action run (skipped due to only_if)
* template[/opt/gitlab/sv/redis/check] action create (skipped due to only_if)
* template[/opt/gitlab/sv/redis/finish] action create (skipped due to only_if)
* directory[/opt/gitlab/sv/redis/control] action create (up to date)
* link[/opt/gitlab/init/redis] action create (up to date)
* file[/opt/gitlab/sv/redis/down] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/service] action create (up to date)
* link[/opt/gitlab/service/redis] action create (up to date)
* ruby_block[wait for redis service socket] action run (skipped due to not_if)
(up to date)
* ruby_block[warn pending redis restart] action run (skipped due to only_if)
(up to date)
Recipe: redis::enable
* template[/opt/gitlab/etc/gitlab-redis-cli-rc] action create (up to date)
Recipe: gitaly::enable
* directory[/var/opt/gitlab/gitaly] action create (up to date)
* directory[/var/log/gitlab/gitaly] action create (up to date)
* directory[/var/opt/gitlab/gitaly/internal_sockets] action create (up to date)
* env_dir[/opt/gitlab/etc/gitaly/env] action create
* directory[/opt/gitlab/etc/gitaly/env] action create (up to date)
* file[/opt/gitlab/etc/gitaly/env/HOME] action create (up to date)
* file[/opt/gitlab/etc/gitaly/env/PATH] action create (up to date)
* file[/opt/gitlab/etc/gitaly/env/TZ] action create (up to date)
* file[/opt/gitlab/etc/gitaly/env/PYTHONPATH] action create (up to date)
* file[/opt/gitlab/etc/gitaly/env/ICU_DATA] action create (up to date)
* file[/opt/gitlab/etc/gitaly/env/SSL_CERT_DIR] action create (up to date)
* file[/opt/gitlab/etc/gitaly/env/GITALY_PID_FILE] action create (up to date)
* file[/opt/gitlab/etc/gitaly/env/WRAPPER_JSON_LOGGING] action create (up to date)
(up to date)
* template[Create Gitaly config.toml] action create (up to date)
* service[gitaly] action nothing (skipped due to action :nothing)
* runit_service[gitaly] action enable
* ruby_block[restart_service] action nothing (skipped due to action :nothing)
* ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
* ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/sv/gitaly] action create (up to date)
* template[/opt/gitlab/sv/gitaly/run] action create (up to date)
* directory[/opt/gitlab/sv/gitaly/log] action create (up to date)
* directory[/opt/gitlab/sv/gitaly/log/main] action create (up to date)
* template[/opt/gitlab/sv/gitaly/log/config] action create (up to date)
* ruby_block[verify_chown_persisted_on_gitaly] action nothing (skipped due to action :nothing)
* link[/var/log/gitlab/gitaly/config] action create (up to date)
* template[/opt/gitlab/sv/gitaly/log/run] action create (up to date)
* directory[/opt/gitlab/sv/gitaly/env] action create (up to date)
* ruby_block[Delete unmanaged env files for gitaly service] action run (skipped due to only_if)
* template[/opt/gitlab/sv/gitaly/check] action create (skipped due to only_if)
* template[/opt/gitlab/sv/gitaly/finish] action create (skipped due to only_if)
* directory[/opt/gitlab/sv/gitaly/control] action create (up to date)
* link[/opt/gitlab/init/gitaly] action create (up to date)
* file[/opt/gitlab/sv/gitaly/down] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/service] action create (up to date)
* link[/opt/gitlab/service/gitaly] action create (up to date)
* ruby_block[wait for gitaly service socket] action run (skipped due to not_if)
(up to date)
* version_file[Create version file for Gitaly] action create
* file[/var/opt/gitlab/gitaly/VERSION] action create
- update content in file /var/opt/gitlab/gitaly/VERSION from 22d435 to 330fe7
--- /var/opt/gitlab/gitaly/VERSION 2020-11-16 15:45:42.257416819 +0100
+++ /var/opt/gitlab/gitaly/.chef-VERSION20201126-15996-ken0gs 2020-11-26 11:53:08.362987737 +0100
@@ -1 +1 @@
-Gitaly, version 13.5.4
+Gitaly, version 13.6.1
* version_file[Create Ruby version file for Gitaly] action create
* file[/var/opt/gitlab/gitaly/RUBY_VERSION] action create
- create new file /var/opt/gitlab/gitaly/RUBY_VERSION
- update content in file /var/opt/gitlab/gitaly/RUBY_VERSION from none to 22dcc2
--- /var/opt/gitlab/gitaly/RUBY_VERSION 2020-11-26 11:53:08.422987302 +0100
+++ /var/opt/gitlab/gitaly/.chef-RUBY_VERSION20201126-15996-1q9nn4z 2020-11-26 11:53:08.422987302 +0100
@@ -1 +1,2 @@
+ruby 2.7.2p137 (2020-10-01 revision 5445e04352) [x86_64-linux]
* consul_service[gitaly] action delete
* file[/var/opt/gitlab/consul/config.d/gitaly-service.json] action delete (up to date)
(up to date)
Recipe: praefect::disable
* service[praefect] action nothing (skipped due to action :nothing)
* runit_service[praefect] action disable
* ruby_block[disable praefect] action run (skipped due to only_if)
(up to date)
* consul_service[praefect] action delete
* file[/var/opt/gitlab/consul/config.d/praefect-service.json] action delete (up to date)
(up to date)
Recipe: postgresql::user
* account[Postgresql user and group] action create
* group[Postgresql user and group] action create (up to date)
* linux_user[Postgresql user and group] action create (up to date)
(up to date)
* directory[/var/opt/gitlab/postgresql] action create (up to date)
* file[/var/opt/gitlab/postgresql/.profile] action create (up to date)
Recipe: postgresql::enable
* directory[/var/opt/gitlab/postgresql] action create (up to date)
* directory[/var/opt/gitlab/postgresql/data] action create (up to date)
* directory[/var/log/gitlab/postgresql] action create (up to date)
* directory[/var/opt/gitlab/postgresql/data] action create (up to date)
* link[/var/opt/gitlab/postgresql/data] action create (skipped due to not_if)
* gitlab_sysctl[kernel.shmmax] action create
* directory[create /etc/sysctl.d for kernel.shmmax] action create (up to date)
* file[create /opt/gitlab/embedded/etc/90-omnibus-gitlab-kernel.shmmax.conf kernel.shmmax] action create (up to date)
* link[/etc/sysctl.d/90-omnibus-gitlab-kernel.shmmax.conf] action create (up to date)
* execute[load sysctl conf kernel.shmmax] action nothing (skipped due to action :nothing)
(up to date)
* gitlab_sysctl[kernel.shmall] action create
* directory[create /etc/sysctl.d for kernel.shmall] action create (up to date)
* file[create /opt/gitlab/embedded/etc/90-omnibus-gitlab-kernel.shmall.conf kernel.shmall] action create (up to date)
* link[/etc/sysctl.d/90-omnibus-gitlab-kernel.shmall.conf] action create (up to date)
* execute[load sysctl conf kernel.shmall] action nothing (skipped due to action :nothing)
(up to date)
* gitlab_sysctl[kernel.sem] action create
* directory[create /etc/sysctl.d for kernel.sem] action create (up to date)
* file[create /opt/gitlab/embedded/etc/90-omnibus-gitlab-kernel.sem.conf kernel.sem] action create (up to date)
* link[/etc/sysctl.d/90-omnibus-gitlab-kernel.sem.conf] action create (up to date)
* execute[load sysctl conf kernel.sem] action nothing (skipped due to action :nothing)
(up to date)
* execute[/opt/gitlab/embedded/bin/initdb -D /var/opt/gitlab/postgresql/data -E UTF8] action run (skipped due to not_if)
* template[/opt/gitlab/etc/gitlab-psql-rc] action create (up to date)
* file[/var/opt/gitlab/postgresql/data/server.crt] action create (up to date)
* file[/var/opt/gitlab/postgresql/data/server.key] action create (up to date)
* postgresql_config[gitlab] action create
* template[/var/opt/gitlab/postgresql/data/postgresql.conf] action create (up to date)
* template[/var/opt/gitlab/postgresql/data/runtime.conf] action create (up to date)
* template[/var/opt/gitlab/postgresql/data/pg_hba.conf] action create (up to date)
* template[/var/opt/gitlab/postgresql/data/pg_ident.conf] action create (up to date)
(up to date)
* service[postgresql] action nothing (skipped due to action :nothing)
* runit_service[postgresql] action enable
* ruby_block[restart_service] action nothing (skipped due to action :nothing)
* ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
* ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/sv/postgresql] action create (up to date)
* template[/opt/gitlab/sv/postgresql/run] action create (up to date)
* directory[/opt/gitlab/sv/postgresql/log] action create (up to date)
* directory[/opt/gitlab/sv/postgresql/log/main] action create (up to date)
* template[/opt/gitlab/sv/postgresql/log/config] action create (up to date)
* ruby_block[verify_chown_persisted_on_postgresql] action nothing (skipped due to action :nothing)
* link[/var/log/gitlab/postgresql/config] action create (up to date)
* template[/opt/gitlab/sv/postgresql/log/run] action create (up to date)
* directory[/opt/gitlab/sv/postgresql/env] action create (up to date)
* ruby_block[Delete unmanaged env files for postgresql service] action run (skipped due to only_if)
* template[/opt/gitlab/sv/postgresql/check] action create (skipped due to only_if)
* template[/opt/gitlab/sv/postgresql/finish] action create (skipped due to only_if)
* directory[/opt/gitlab/sv/postgresql/control] action create (up to date)
* template[/opt/gitlab/sv/postgresql/control/t] action create (up to date)
* link[/opt/gitlab/init/postgresql] action create (up to date)
* file[/opt/gitlab/sv/postgresql/down] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/service] action create (up to date)
* link[/opt/gitlab/service/postgresql] action create (up to date)
* ruby_block[wait for postgresql service socket] action run (skipped due to not_if)
* directory[/opt/gitlab/service/postgresql/supervise] action create (up to date)
* directory[/opt/gitlab/service/postgresql/log/supervise] action create (up to date)
* file[/opt/gitlab/service/postgresql/supervise/ok] action touch (skipped due to only_if)
* file[/opt/gitlab/service/postgresql/log/supervise/ok] action touch (skipped due to only_if)
* file[/opt/gitlab/service/postgresql/supervise/status] action touch
- change owner from 'root' to 'gitlab-psql'
- change group from 'root' to 'gitlab-psql'
- update utime on file /opt/gitlab/service/postgresql/supervise/status
* file[/opt/gitlab/service/postgresql/log/supervise/status] action touch
- change owner from 'root' to 'gitlab-psql'
- change group from 'root' to 'gitlab-psql'
- update utime on file /opt/gitlab/service/postgresql/log/supervise/status
* file[/opt/gitlab/service/postgresql/supervise/control] action touch (skipped due to only_if)
* file[/opt/gitlab/service/postgresql/log/supervise/control] action touch (skipped due to only_if)
* database_objects[postgresql] action create
* postgresql_user[gitlab] action create
* execute[create gitlab postgresql user] action run (skipped due to not_if)
(up to date)
* postgresql_user[gitlab_replicator] action create
* execute[create gitlab_replicator postgresql user] action run (skipped due to not_if)
* execute[set options for gitlab_replicator postgresql user] action run (skipped due to not_if)
(up to date)
* execute[create gitlabhq_production database] action run (skipped due to only_if)
* postgresql_extension[pg_trgm] action enable
* postgresql_query[enable pg_trgm extension] action run (skipped due to only_if)
(up to date)
* postgresql_extension[btree_gist] action enable
* postgresql_query[enable btree_gist extension] action run (skipped due to only_if)
(up to date)
(up to date)
* ruby_block[warn pending postgresql restart] action run (skipped due to only_if)
* execute[reload postgresql] action nothing (skipped due to action :nothing)
* execute[start postgresql] action nothing (skipped due to action :nothing)
Recipe: gitlab-kas::disable
* service[gitlab-kas] action nothing (skipped due to action :nothing)
* runit_service[gitlab-kas] action disable
* ruby_block[disable gitlab-kas] action run (skipped due to only_if)
(up to date)
Recipe: gitlab::database_migrations
* bash[migrate gitlab-rails database] action run
[execute] NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"
NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"
NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"
NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"
== 20200908212414 AddFeatureFlagEventsToWebHooks: migrating ===================
-- add_column(:web_hooks, :feature_flag_events, :boolean, {:null=>false, :default=>false})
-> 0.0153s
== 20200908212414 AddFeatureFlagEventsToWebHooks: migrated (0.0154s) ==========
== 20200920130356 AddContainerExpirationPolicyWorkerSettingsToApplicationSettings: migrating
-- column_exists?(:application_settings, :container_registry_expiration_policies_worker_capacity)
-> 0.0621s
-- add_column(:application_settings, :container_registry_expiration_policies_worker_capacity, :integer, {:default=>0, :null=>false})
-> 0.0040s
== 20200920130356 AddContainerExpirationPolicyWorkerSettingsToApplicationSettings: migrated (0.0663s)
== 20200928123510 AddExpirationPolicyCleanupStatusToContainerRepositories: migrating
-- column_exists?(:container_repositories, :expiration_policy_cleanup_status)
-> 0.0022s
-- add_column(:container_repositories, :expiration_policy_cleanup_status, :integer, {:limit=>2, :default=>0, :null=>false})
-> 0.0077s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:container_repositories, [:expiration_policy_cleanup_status, :expiration_policy_started_at], {:name=>"idx_container_repositories_on_exp_cleanup_status_and_start_date", :algorithm=>:concurrently})
-> 0.0083s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:container_repositories, [:expiration_policy_cleanup_status, :expiration_policy_started_at], {:name=>"idx_container_repositories_on_exp_cleanup_status_and_start_date", :algorithm=>:concurrently})
-> 0.0138s
-- execute("RESET ALL")
-> 0.0003s
== 20200928123510 AddExpirationPolicyCleanupStatusToContainerRepositories: migrated (0.0333s)
== 20201008011523 AddCiJwtSigningKeyToApplicationSettings: migrating ==========
-- add_column(:application_settings, :encrypted_ci_jwt_signing_key, :text)
-> 0.0017s
-- add_column(:application_settings, :encrypted_ci_jwt_signing_key_iv, :text)
-> 0.0009s
== 20201008011523 AddCiJwtSigningKeyToApplicationSettings: migrated (0.0027s) =
== 20201008011937 AddTextLimitToApplicationSettingsEncryptedCiJwtSigningKeyIv: migrating
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0003s
-- execute("ALTER TABLE application_settings\nADD CONSTRAINT check_85a39b68ff\nCHECK ( char_length(encrypted_ci_jwt_signing_key_iv) <= 255 )\nNOT VALID;\n")
-> 0.0089s
-- current_schema()
-> 0.0004s
-- execute("SET statement_timeout TO 0")
-> 0.0004s
-- execute("ALTER TABLE application_settings VALIDATE CONSTRAINT check_85a39b68ff;")
-> 0.0013s
-- execute("RESET ALL")
-> 0.0002s
== 20201008011937 AddTextLimitToApplicationSettingsEncryptedCiJwtSigningKeyIv: migrated (0.0354s)
== 20201008013434 GenerateCiJwtSigningKey: migrating ==========================
== 20201008013434 GenerateCiJwtSigningKey: migrated (0.6534s) =================
== 20201008075620 AddReleasesEventsToWebHooks: migrating ======================
-- add_column(:web_hooks, :releases_events, :boolean, {:null=>false, :default=>false})
-> 0.0014s
== 20201008075620 AddReleasesEventsToWebHooks: migrated (0.0015s) =============
== 20201008125643 CreateCsvIssueImports: migrating ============================
-- create_table(:csv_issue_imports)
-> 0.0287s
== 20201008125643 CreateCsvIssueImports: migrated (0.0288s) ===================
== 20201008144854 SetRegexDefaultsOnContainerExpirationPolicies: migrating ====
-- change_column_default(:container_expiration_policies, :name_regex, ".*")
-> 0.0030s
-- change_column_default(:container_expiration_policies, :enabled, false)
-> 0.0028s
== 20201008144854 SetRegexDefaultsOnContainerExpirationPolicies: migrated (0.0078s)
== 20201008224441 AddPositionIntoSecurityFindings: migrating ==================
-- add_column(:security_findings, :position, :integer)
-> 0.0010s
== 20201008224441 AddPositionIntoSecurityFindings: migrated (0.0027s) =========
== 20201012073022 RemoveNotNullConstraintOnFramework: migrating ===============
-- change_column_null(:project_compliance_framework_settings, :framework, true)
-> 0.0011s
== 20201012073022 RemoveNotNullConstraintOnFramework: migrated (0.0012s) ======
== 20201012122428 AddContainerRegistryExpirationPoliciesWorkerCapacityConstraint: migrating
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0003s
-- execute("ALTER TABLE application_settings\nADD CONSTRAINT app_settings_registry_exp_policies_worker_capacity_positive\nCHECK ( container_registry_expiration_policies_worker_capacity >= 0 )\nNOT VALID;\n")
-> 0.0013s
-- current_schema()
-> 0.0002s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE application_settings VALIDATE CONSTRAINT app_settings_registry_exp_policies_worker_capacity_positive;")
-> 0.0012s
-- execute("RESET ALL")
-> 0.0002s
== 20201012122428 AddContainerRegistryExpirationPoliciesWorkerCapacityConstraint: migrated (0.0078s)
== 20201012134230 CreateCiTestCases: migrating ================================
-- table_exists?(:ci_test_cases)
-> 0.0007s
-- create_table(:ci_test_cases)
-> 0.0311s
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0003s
-- execute("ALTER TABLE ci_test_cases\nADD CONSTRAINT check_dd3c5d1c15\nCHECK ( char_length(key_hash) <= 64 )\nNOT VALID;\n")
-> 0.0005s
-- current_schema()
-> 0.0002s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE ci_test_cases VALIDATE CONSTRAINT check_dd3c5d1c15;")
-> 0.0005s
-- execute("RESET ALL")
-> 0.0002s
== 20201012134230 CreateCiTestCases: migrated (0.0377s) =======================
== 20201012135330 CreateCiTestCaseFailures: migrating =========================
-- create_table(:ci_test_case_failures)
-> 0.0257s
== 20201012135330 CreateCiTestCaseFailures: migrated (0.0258s) ================
== 20201012140110 AddProjectsFkToCiTestCases: migrating =======================
-- transaction_open?()
-> 0.0000s
-- foreign_keys(:ci_test_cases)
-> 0.0071s
-- execute("ALTER TABLE ci_test_cases\nADD CONSTRAINT fk_0526c30ded\nFOREIGN KEY (project_id)\nREFERENCES projects (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0032s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE ci_test_cases VALIDATE CONSTRAINT fk_0526c30ded;")
-> 0.0033s
-- execute("RESET ALL")
-> 0.0002s
== 20201012140110 AddProjectsFkToCiTestCases: migrated (0.0166s) ==============
== 20201012140452 AddCiBuildsFkToCiTestCaseFailures: migrating ================
-- transaction_open?()
-> 0.0000s
-- foreign_keys(:ci_test_case_failures)
-> 0.0054s
-- execute("ALTER TABLE ci_test_case_failures\nADD CONSTRAINT fk_d69404d827\nFOREIGN KEY (build_id)\nREFERENCES ci_builds (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0026s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE ci_test_case_failures VALIDATE CONSTRAINT fk_d69404d827;")
-> 0.0028s
-- execute("RESET ALL")
-> 0.0002s
== 20201012140452 AddCiBuildsFkToCiTestCaseFailures: migrated (0.0136s) =======
== 20201014163633 SpecifyPrimaryKeyWhereMissing: migrating ====================
-- indexes(:project_authorizations)
-> 0.0025s
-- execute("ALTER TABLE project_authorizations ADD CONSTRAINT project_authorizations_pkey PRIMARY KEY USING INDEX index_project_authorizations_on_user_id_project_id_access_level")
-> 0.0025s
-- indexes(:analytics_language_trend_repository_languages)
-> 0.0024s
-- execute("ALTER TABLE analytics_language_trend_repository_languages ADD CONSTRAINT analytics_language_trend_repository_languages_pkey PRIMARY KEY USING INDEX analytics_repository_languages_unique_index")
-> 0.0011s
-- indexes(:approval_project_rules_protected_branches)
-> 0.0021s
-- execute("ALTER TABLE approval_project_rules_protected_branches ADD CONSTRAINT approval_project_rules_protected_branches_pkey PRIMARY KEY USING INDEX index_approval_project_rules_protected_branches_unique")
-> 0.0012s
-- indexes(:ci_build_trace_sections)
-> 0.0025s
-- execute("ALTER TABLE ci_build_trace_sections ADD CONSTRAINT ci_build_trace_sections_pkey PRIMARY KEY USING INDEX index_ci_build_trace_sections_on_build_id_and_section_name_id")
-> 0.0010sNOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"
NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"
NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"
NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"
NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"
NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"
NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"
NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"
NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"
NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"
NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"
NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"
-- indexes(:deployment_merge_requests)
-> 0.0034s
-- execute("ALTER TABLE deployment_merge_requests ADD CONSTRAINT deployment_merge_requests_pkey PRIMARY KEY USING INDEX idx_deployment_merge_requests_unique_index")
-> 0.0009s
-- indexes(:issue_assignees)
-> 0.0023s
-- execute("ALTER TABLE issue_assignees ADD CONSTRAINT issue_assignees_pkey PRIMARY KEY USING INDEX index_issue_assignees_on_issue_id_and_user_id")
-> 0.0013s
-- indexes(:issues_prometheus_alert_events)
-> 0.0023s
-- execute("ALTER TABLE issues_prometheus_alert_events ADD CONSTRAINT issues_prometheus_alert_events_pkey PRIMARY KEY USING INDEX issue_id_prometheus_alert_event_id_index")
-> 0.0010s
-- indexes(:issues_self_managed_prometheus_alert_events)
-> 0.0021s
-- execute("ALTER TABLE issues_self_managed_prometheus_alert_events ADD CONSTRAINT issues_self_managed_prometheus_alert_events_pkey PRIMARY KEY USING INDEX issue_id_self_managed_prometheus_alert_event_id_index")
-> 0.0008s
-- indexes(:merge_request_diff_commits)
-> 0.0019s
-- execute("ALTER TABLE merge_request_diff_commits ADD CONSTRAINT merge_request_diff_commits_pkey PRIMARY KEY USING INDEX index_merge_request_diff_commits_on_mr_diff_id_and_order")
-> 0.0017s
-- indexes(:merge_request_diff_files)
-> 0.0015s
-- execute("ALTER TABLE merge_request_diff_files ADD CONSTRAINT merge_request_diff_files_pkey PRIMARY KEY USING INDEX index_merge_request_diff_files_on_mr_diff_id_and_order")
-> 0.0007s
-- indexes(:milestone_releases)
-> 0.0022s
-- execute("ALTER TABLE milestone_releases ADD CONSTRAINT milestone_releases_pkey PRIMARY KEY USING INDEX index_miletone_releases_on_milestone_and_release")
-> 0.0009s
-- indexes(:project_pages_metadata)
-> 0.0032s
-- execute("ALTER TABLE project_pages_metadata ADD CONSTRAINT project_pages_metadata_pkey PRIMARY KEY USING INDEX index_project_pages_metadata_on_project_id")
-> 0.0012s
-- indexes(:push_event_payloads)
-> 0.0015s
-- execute("ALTER TABLE push_event_payloads ADD CONSTRAINT push_event_payloads_pkey PRIMARY KEY USING INDEX index_push_event_payloads_on_event_id")
-> 0.0010s
-- indexes(:repository_languages)
-> 0.0015s
-- execute("ALTER TABLE repository_languages ADD CONSTRAINT repository_languages_pkey PRIMARY KEY USING INDEX index_repository_languages_on_project_and_languages_id")
-> 0.0007s
-- indexes(:user_interacted_projects)
-> 0.0021s
-- execute("ALTER TABLE user_interacted_projects ADD CONSTRAINT user_interacted_projects_pkey PRIMARY KEY USING INDEX index_user_interacted_projects_on_project_id_and_user_id")
-> 0.0009s
-- indexes(:users_security_dashboard_projects)
-> 0.0021s
-- execute("ALTER TABLE users_security_dashboard_projects ADD CONSTRAINT users_security_dashboard_projects_pkey PRIMARY KEY USING INDEX users_security_dashboard_projects_unique_index")
-> 0.0008s
== 20201014163633 SpecifyPrimaryKeyWhereMissing: migrated (0.0933s) ===========
== 20201015121805 AddProjectForeignKeyToCsvIssueImports: migrating ============
-- transaction_open?()
-> 0.0000s
-- foreign_keys(:csv_issue_imports)
-> 0.0049s
-- execute("ALTER TABLE csv_issue_imports\nADD CONSTRAINT fk_e71c0ae362\nFOREIGN KEY (project_id)\nREFERENCES projects (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0013s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE csv_issue_imports VALIDATE CONSTRAINT fk_e71c0ae362;")
-> 0.0017s
-- execute("RESET ALL")
-> 0.0002s
== 20201015121805 AddProjectForeignKeyToCsvIssueImports: migrated (0.0111s) ===
== 20201015121825 AddUserForeignKeyToCsvIssueImports: migrating ===============
-- transaction_open?()
-> 0.0000s
-- foreign_keys(:csv_issue_imports)
-> 0.0051s
-- execute("ALTER TABLE csv_issue_imports\nADD CONSTRAINT fk_5e1572387c\nFOREIGN KEY (user_id)\nREFERENCES users (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0019s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE csv_issue_imports VALIDATE CONSTRAINT fk_5e1572387c;")
-> 0.0018s
-- execute("RESET ALL")
-> 0.0002s
== 20201015121825 AddUserForeignKeyToCsvIssueImports: migrated (0.0118s) ======
== 20201015194852 AddIndexOnStateForDastSiteValidations: migrating ============
-- transaction_open?()
-> 0.0000s
-- index_exists?(:dast_site_validations, [:url_base, :state], {:name=>"index_dast_site_validations_on_url_base_and_state", :algorithm=>:concurrently})
-> 0.0024s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:dast_site_validations, [:url_base, :state], {:name=>"index_dast_site_validations_on_url_base_and_state", :algorithm=>:concurrently})
-> 0.0041s
-- execute("RESET ALL")
-> 0.0002s
-- transaction_open?()
-> 0.0000s
-- indexes(:dast_site_validations)
-> 0.0024s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- remove_index(:dast_site_validations, {:algorithm=>:concurrently, :name=>"index_dast_site_validations_on_url_base"})
-> 0.0076s
-- execute("RESET ALL")
-> 0.0002s
== 20201015194852 AddIndexOnStateForDastSiteValidations: migrated (0.0185s) ===
== 20201015231049 AddCiBuildIdToTerraformStateVersions: migrating =============
-- column_exists?(:terraform_state_versions, :ci_build_id)
-> 0.0023s
-- add_column(:terraform_state_versions, :ci_build_id, :bigint)
-> 0.0012s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:terraform_state_versions, :ci_build_id, {:name=>"index_terraform_state_versions_on_ci_build_id", :algorithm=>:concurrently})
-> 0.0030s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:terraform_state_versions, :ci_build_id, {:name=>"index_terraform_state_versions_on_ci_build_id", :algorithm=>:concurrently})
-> 0.0062s
-- execute("RESET ALL")
-> 0.0002s
-- transaction_open?()
-> 0.0000s
-- foreign_keys(:terraform_state_versions)
-> 0.0051s
-- execute("ALTER TABLE terraform_state_versions\nADD CONSTRAINT fk_04b91e4a9f\nFOREIGN KEY (ci_build_id)\nREFERENCES ci_builds (id)\nON DELETE SET NULL\nNOT VALID;\n")
-> 0.0023s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE terraform_state_versions VALIDATE CONSTRAINT fk_04b91e4a9f;")
-> 0.0026s
-- execute("RESET ALL")
-> 0.0002s
== 20201015231049 AddCiBuildIdToTerraformStateVersions: migrated (0.0265s) ====
== 20201016074302 AddIndexProjectIdAndIdToContainerRepositories: migrating ====
-- transaction_open?()
-> 0.0000s
-- index_exists?(:container_repositories, [:project_id, :id], {:name=>"index_container_repositories_on_project_id_and_id", :algorithm=>:concurrently})
-> 0.0034s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:container_repositories, [:project_id, :id], {:name=>"index_container_repositories_on_project_id_and_id", :algorithm=>:concurrently})
-> 0.0032s
-- execute("RESET ALL")
-> 0.0002s
== 20201016074302 AddIndexProjectIdAndIdToContainerRepositories: migrated (0.0076s)
== 20201019091307 AddUniqueIndexOnScanIdAndPositionOfSecurityFindings: migrating
-- transaction_open?()
-> 0.0000s
-- index_exists?(:security_findings, [:scan_id, :position], {:unique=>true, :name=>"index_security_findings_on_scan_id_and_position", :algorithm=>:concurrently})
-> 0.0039s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:security_findings, [:scan_id, :position], {:unique=>true, :name=>"index_security_findings_on_scan_id_and_position", :algorithm=>:concurrently})
-> 0.0034s
-- execute("RESET ALL")
-> 0.0002s
== 20201019091307 AddUniqueIndexOnScanIdAndPositionOfSecurityFindings: migrated (0.0083s)
== 20201019094741 RenameSitemapRootNamespaces: migrating ======================
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("RESET ALL")
-> 0.0003s
== 20201019094741 RenameSitemapRootNamespaces: migrated (0.0658s) =============
== 20201019101549 AddEsCustomAnalyzersSettings: migrating =====================
-- add_column(:application_settings, :elasticsearch_analyzers_smartcn_enabled, :bool, {:null=>false, :default=>false})
-> 0.0029s
-- add_column(:application_settings, :elasticsearch_analyzers_smartcn_search, :bool, {:null=>false, :default=>false})
-> 0.0021s
-- add_column(:application_settings, :elasticsearch_analyzers_kuromoji_enabled, :bool, {:null=>false, :default=>false})
-> 0.0045s
-- add_column(:application_settings, :elasticsearch_analyzers_kuromoji_search, :bool, {:null=>false, :default=>false})
-> 0.0022s
== 20201019101549 AddEsCustomAnalyzersSettings: migrated (0.0120s) ============
== 20201019111952 AddSha256AndFilecountToPagesDeployments: migrating ==========
-- execute("DELETE FROM pages_deployments")
-> 0.0018s
-- add_column(:pages_deployments, :file_count, :integer, {:null=>false})
-> 0.0006s
-- add_column(:pages_deployments, :file_sha256, :binary, {:null=>false})
-> 0.0007s
== 20201019111952 AddSha256AndFilecountToPagesDeployments: migrated (0.0033s) =
== 20201019113009 AddNewUserSignupsCapToApplicationSettings: migrating ========
-- add_column(:application_settings, :new_user_signups_cap, :integer)
-> 0.0023s
== 20201019113009 AddNewUserSignupsCapToApplicationSettings: migrated (0.0024s)
== 20201019130244 RemoveLicenseComplianceTempIndex: migrating =================
-- transaction_open?()
-> 0.0000s
-- indexes(:ci_job_artifacts)
-> 0.0059s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- remove_index(:ci_job_artifacts, {:algorithm=>:concurrently, :name=>"index_ci_job_artifacts_on_license_compliance_file_types"})
-> 0.0021s
-- execute("RESET ALL")
-> 0.0003s
== 20201019130244 RemoveLicenseComplianceTempIndex: migrated (0.0091s) ========
== 20201019152046 AddDefaultBranchToDailyBuildGroupReportResult: migrating ====
-- add_column(:ci_daily_build_group_report_results, :default_branch, :boolean, {:default=>false, :null=>false})
-> 0.0019s
== 20201019152046 AddDefaultBranchToDailyBuildGroupReportResult: migrated (0.0019s)
== 20201019161924 AddPartitionedTableView: migrating ==========================
-- execute("CREATE OR REPLACE VIEW postgres_partitioned_tables AS\nSELECT\n pg_namespace.nspname::text || '.'::text || pg_class.relname::text AS identifier,\n pg_class.oid AS oid,\n pg_namespace.nspname AS schema,\n pg_class.relname AS name,\n CASE partitioned_tables.partstrat\n WHEN 'l' THEN 'list'\n WHEN 'r' THEN 'range'\n WHEN 'h' THEN 'hash'\n END as strategy,\n array_agg(pg_attribute.attname) as key_columns\n FROM (\n SELECT\n partrelid,\n partstrat,\n unnest(partattrs) as column_position\n FROM pg_partitioned_table\n ) partitioned_tables\n INNER JOIN pg_class\n ON partitioned_tables.partrelid = pg_class.oid\n INNER JOIN pg_namespace\n ON pg_class.relnamespace = pg_namespace.oid\n INNER JOIN pg_attribute\n ON pg_attribute.attrelid = pg_class.oid\n AND pg_attribute.attnum = partitioned_tables.column_position\n WHERE pg_namespace.nspname = current_schema()\n GROUP BY identifier, pg_class.oid, schema, name, strategy;\n")
-> 0.0058s
== 20201019161924 AddPartitionedTableView: migrated (0.0059s) =================
== 20201019172704 AddPartitionsView: migrating ================================
-- execute("CREATE OR REPLACE VIEW postgres_partitions AS\nSELECT\n pg_namespace.nspname::text || '.'::text || pg_class.relname::text AS identifier,\n pg_class.oid AS oid,\n pg_namespace.nspname AS schema,\n pg_class.relname AS name,\n parent_namespace.nspname::text || '.'::text || parent_class.relname::text AS parent_identifier,\n pg_get_expr(pg_class.relpartbound, pg_inherits.inhrelid) AS condition\nFROM pg_class\nINNER JOIN pg_namespace\nON pg_namespace.oid = pg_class.relnamespace\nINNER JOIN pg_inherits\nON pg_class.oid = pg_inherits.inhrelid\nINNER JOIN pg_class parent_class\nON pg_inherits.inhparent = parent_class.oid\nINNER JOIN pg_namespace parent_namespace\nON parent_class.relnamespace = parent_namespace.oid\nWHERE pg_class.relispartition\nAND pg_namespace.nspname IN (\n current_schema(),\n 'gitlab_partitions_dynamic',\n 'gitlab_partitions_static'\n)\n")
-> 0.0034s
== 20201019172704 AddPartitionsView: migrated (0.0035s) =======================
== 20201020102551 RemoveIndexServiceForUsageData: migrating ===================
-- transaction_open?()
-> 0.0000s
-- indexes(:services)
-> 0.0061s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- remove_index(:services, {:algorithm=>:concurrently, :name=>"index_services_on_type_id_when_active_not_instance_not_template"})
-> 0.0027s
-- execute("RESET ALL")
-> 0.0003s
== 20201020102551 RemoveIndexServiceForUsageData: migrated (0.0102s) ==========
== 20201021085007 CreateAnalyticsDevopsAdoptionSegments: migrating ============
-- create_table(:analytics_devops_adoption_segments, {:if_not_exists=>true})
-> 0.0324s
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0006s
-- execute("ALTER TABLE analytics_devops_adoption_segments\nADD CONSTRAINT check_4be7a006fd\nCHECK ( char_length(name) <= 255 )\nNOT VALID;\n")
-> 0.0015s
-- current_schema()
-> 0.0003s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- execute("ALTER TABLE analytics_devops_adoption_segments VALIDATE CONSTRAINT check_4be7a006fd;")
-> 0.0006s
-- execute("RESET ALL")
-> 0.0002s
== 20201021085007 CreateAnalyticsDevopsAdoptionSegments: migrated (0.0407s) ===
== 20201021101956 AddIndexRouteOnNameTrigramToRoute: migrating ================
-- transaction_open?()
-> 0.0000s
-- index_exists?(:routes, :name, {:name=>"index_route_on_name_trigram", :using=>:gin, :opclass=>{:name=>:gin_trgm_ops}, :algorithm=>:concurrently})
-> 0.0042s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- add_index(:routes, :name, {:name=>"index_route_on_name_trigram", :using=>:gin, :opclass=>{:name=>:gin_trgm_ops}, :algorithm=>:concurrently})
-> 0.0044s
-- execute("RESET ALL")
-> 0.0003s
== 20201021101956 AddIndexRouteOnNameTrigramToRoute: migrated (0.0099s) =======
== 20201021102554 CreateAnalyticsDevopsAdoptionSegmentSelections: migrating ===
-- create_table(:analytics_devops_adoption_segment_selections)
-> 0.0376s
== 20201021102554 CreateAnalyticsDevopsAdoptionSegmentSelections: migrated (0.0376s)
== 20201021105347 AddForeignKeyProjectIdToSegmentSelection: migrating =========
-- transaction_open?()
-> 0.0000s
-- foreign_keys(:analytics_devops_adoption_segment_selections)
-> 0.0050s
-- execute("ALTER TABLE analytics_devops_adoption_segment_selections\nADD CONSTRAINT fk_f1472b95f3\nFOREIGN KEY (project_id)\nREFERENCES projects (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0012s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE analytics_devops_adoption_segment_selections VALIDATE CONSTRAINT fk_f1472b95f3;")
-> 0.0016s
-- execute("RESET ALL")
-> 0.0002s
== 20201021105347 AddForeignKeyProjectIdToSegmentSelection: migrated (0.0110s)
== 20201021105600 AddForeignKeyGroupIdToSegmentSelection: migrating ===========
-- transaction_open?()
-> 0.0000s
-- foreign_keys(:analytics_devops_adoption_segment_selections)
-> 0.0052s
-- execute("ALTER TABLE analytics_devops_adoption_segment_selections\nADD CONSTRAINT fk_ded7fe0344\nFOREIGN KEY (group_id)\nREFERENCES namespaces (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0013s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE analytics_devops_adoption_segment_selections VALIDATE CONSTRAINT fk_ded7fe0344;")
-> 0.0010s
-- execute("RESET ALL")
-> 0.0002s
== 20201021105600 AddForeignKeyGroupIdToSegmentSelection: migrated (0.0103s) ==
== 20201021105959 AddCheckConstraintToSegmentSelection: migrating =============
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0004s
-- execute("ALTER TABLE analytics_devops_adoption_segment_selections\nADD CONSTRAINT segment_selection_project_id_or_group_id_required\nCHECK ( (project_id != NULL AND group_id IS NULL) OR (group_id != NULL AND project_id IS NULL) )\nNOT VALID;\n")
-> 0.0006s
-- current_schema()
-> 0.0002s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE analytics_devops_adoption_segment_selections VALIDATE CONSTRAINT segment_selection_project_id_or_group_id_required;")
-> 0.0006s
-- execute("RESET ALL")
-> 0.0002s
== 20201021105959 AddCheckConstraintToSegmentSelection: migrated (0.0062s) ====
== 20201021142812 AddIndexToCiDailyBuildGroupReportResults: migrating =========
-- transaction_open?()
-> 0.0000s
-- index_exists?(:ci_daily_build_group_report_results, [:project_id, :date], {:order=>{:date=>:desc}, :where=>"default_branch = TRUE AND (data -> 'coverage') IS NOT NULL", :name=>"index_ci_daily_build_group_report_results_on_project_and_date", :algorithm=>:concurrently})
-> 0.0026s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:ci_daily_build_group_report_results, [:project_id, :date], {:order=>{:date=>:desc}, :where=>"default_branch = TRUE AND (data -> 'coverage') IS NOT NULL", :name=>"index_ci_daily_build_group_report_results_on_project_and_date", :algorithm=>:concurrently})
-> 0.0038s
-- execute("RESET ALL")
-> 0.0002s
== 20201021142812 AddIndexToCiDailyBuildGroupReportResults: migrated (0.0150s)
== 20201021152210 AddSecretDetectionTokenRevocationApplicationSettings: migrating
-- add_column(:application_settings, :secret_detection_token_revocation_enabled, :boolean, {:default=>false, :null=>false})
-> 0.0028s
-- add_column(:application_settings, :secret_detection_token_revocation_url, :text, {:null=>true})
-> 0.0008s
-- add_column(:application_settings, :encrypted_secret_detection_token_revocation_token, :text)
-> 0.0008s
-- add_column(:application_settings, :encrypted_secret_detection_token_revocation_token_iv, :text)
-> 0.0008s
== 20201021152210 AddSecretDetectionTokenRevocationApplicationSettings: migrated (0.0054s)
== 20201021190539 AddTextLimitToSecretDetectionTokenRevocationApplicationSettings: migrating
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0003s
-- execute("ALTER TABLE application_settings\nADD CONSTRAINT check_9a719834eb\nCHECK ( char_length(secret_detection_token_revocation_url) <= 255 )\nNOT VALID;\n")
-> 0.0016s
-- current_schema()
-> 0.0002s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE application_settings VALIDATE CONSTRAINT check_9a719834eb;")
-> 0.0012s
-- execute("RESET ALL")
-> 0.0002s
== 20201021190539 AddTextLimitToSecretDetectionTokenRevocationApplicationSettings: migrated (0.0075s)
== 20201021220101 AddMergeTrainsEnabled: migrating ============================
-- add_column(:project_ci_cd_settings, :merge_trains_enabled, :boolean, {:default=>false, :allow_null=>false})
-> 0.0016s
== 20201021220101 AddMergeTrainsEnabled: migrated (0.0017s) ===================
== 20201022080802 AddRepositoryReadOnlyToSnippets: migrating ==================
-- add_column(:snippets, :repository_read_only, :boolean, {:default=>false, :null=>false})
-> 0.0015s
== 20201022080802 AddRepositoryReadOnlyToSnippets: migrated (0.0015s) =========
== 20201022094845 AddHistoricalDataRecordedAt: migrating ======================
-- add_column(:historical_data, :recorded_at, :timestamptz)
-> 0.0010s
== 20201022094845 AddHistoricalDataRecordedAt: migrated (0.0010s) =============
== 20201022094846 UpdateHistoricalDataRecordedAt: migrating ===================
-- transaction_open?()
-> 0.0000s
-- exec_query("SELECT COUNT(*) AS count FROM \"historical_data\" WHERE \"historical_data\".\"recorded_at\" IS NULL")
-> 0.0009s
-- current_schema()
-> 0.0002s
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0003s
-- execute("ALTER TABLE historical_data\nADD CONSTRAINT check_640e8cf66c\nCHECK ( recorded_at IS NOT NULL )\nNOT VALID;\n")
-> 0.0005s
-- current_schema()
-> 0.0002s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE historical_data VALIDATE CONSTRAINT check_640e8cf66c;")
-> 0.0005s
-- execute("RESET ALL")
-> 0.0002s
-- change_column_null(:historical_data, :date, true)
-> 0.0006s
== 20201022094846 UpdateHistoricalDataRecordedAt: migrated (0.0161s) ==========
== 20201022103304 AddAvailabilityToUserStatuses: migrating ====================
-- add_column(:user_statuses, :availability, :integer, {:limit=>2, :default=>0, :null=>false})
-> 0.0015s
== 20201022103304 AddAvailabilityToUserStatuses: migrated (0.0016s) ===========
== 20201022144501 CreateSnippetRepositoryStorageMove: migrating ===============
-- table_exists?(:snippet_repository_storage_moves)
-> 0.0010s
-- create_table(:snippet_repository_storage_moves)
-> 0.0220s
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0003s
-- execute("ALTER TABLE snippet_repository_storage_moves\nADD CONSTRAINT snippet_repository_storage_moves_source_storage_name\nCHECK ( char_length(source_storage_name) <= 255 )\nNOT VALID;\n")
-> 0.0006s
-- current_schema()
-> 0.0002s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE snippet_repository_storage_moves VALIDATE CONSTRAINT snippet_repository_storage_moves_source_storage_name;")
-> 0.0005s
-- execute("RESET ALL")
-> 0.0002s
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0002s
-- execute("ALTER TABLE snippet_repository_storage_moves\nADD CONSTRAINT snippet_repository_storage_moves_destination_storage_name\nCHECK ( char_length(destination_storage_name) <= 255 )\nNOT VALID;\n")
-> 0.0005s
-- current_schema()
-> 0.0002s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE snippet_repository_storage_moves VALIDATE CONSTRAINT snippet_repository_storage_moves_destination_storage_name;")
-> 0.0005s
-- execute("RESET ALL")
-> 0.0002s
== 20201022144501 CreateSnippetRepositoryStorageMove: migrated (0.0437s) ======
== 20201022191817 AddHasVulnerabilitiesIntoProjectSettings: migrating =========
-- add_column(:project_settings, :has_vulnerabilities, :boolean, {:default=>false, :null=>false})
-> 0.0011s
== 20201022191817 AddHasVulnerabilitiesIntoProjectSettings: migrated (0.0029s)
== 20201022192254 IndexProjectSettingsOnProjectIdPartially: migrating =========
-- transaction_open?()
-> 0.0000s
-- index_exists?(:project_settings, :project_id, {:name=>"index_project_settings_on_project_id_partially", :where=>"has_vulnerabilities IS TRUE", :algorithm=>:concurrently})
-> 0.0021s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:project_settings, :project_id, {:name=>"index_project_settings_on_project_id_partially", :where=>"has_vulnerabilities IS TRUE", :algorithm=>:concurrently})
-> 0.0036s
-- execute("RESET ALL")
-> 0.0002s
== 20201022192254 IndexProjectSettingsOnProjectIdPartially: migrated (0.0067s)
== 20201023114628 CreateMergeRequestCleanupSchedules: migrating ===============
-- create_table(:merge_request_cleanup_schedules, {:id=>false})
-> 0.0245s
== 20201023114628 CreateMergeRequestCleanupSchedules: migrated (0.0264s) ======
== 20201026051643 RemoveScannedResourcesCountFromSecurityScans: migrating =====
-- remove_column(:security_scans, :scanned_resources_count)
-> 0.0016s
== 20201026051643 RemoveScannedResourcesCountFromSecurityScans: migrated (0.0017s)
== 20201026182253 SchedulePopulateVulnerabilityFeedbackPipelineId: migrating ==
-- exec_query("SELECT DISTINCT \"vulnerability_feedback\".\"project_id\"\nFROM \"vulnerability_feedback\"\nWHERE \"vulnerability_feedback\".\"pipeline_id\" IS NULL\nORDER BY \"vulnerability_feedback\".\"project_id\" ASC\n")
-> 0.0038s
== 20201026182253 SchedulePopulateVulnerabilityFeedbackPipelineId: migrated (0.0039s)
== 20201026200736 SeedMergeTrainsEnabled: migrating ===========================
-- transaction_open?()
-> 0.0000s
-- exec_query("SELECT COUNT(*) AS count FROM \"project_ci_cd_settings\" WHERE \"project_ci_cd_settings\".\"merge_pipelines_enabled\" = TRUE")
-> 0.0015s
== 20201026200736 SeedMergeTrainsEnabled: migrated (0.0020s) ==================
== 20201027002551 MigrateServicesToHttpIntegrations: migrating ================
-- select_all("SELECT * FROM services\nJOIN alerts_service_data\nON (services.id = alerts_service_data.service_id)\nWHERE type = 'AlertsService'\nAND active = TRUE\n")
-> 0.0075s
== 20201027002551 MigrateServicesToHttpIntegrations: migrated (0.0078s) =======
== 20201027135651 AddAutoRollbackSetting: migrating ===========================
-- add_column(:project_ci_cd_settings, :auto_rollback_enabled, :boolean, {:default=>false, :null=>false})
-> 0.0012s
== 20201027135651 AddAutoRollbackSetting: migrated (0.0032s) ==================
== 20201027210127 AddIndexToOauthAccessGrantsResourceOwnerId: migrating =======
-- transaction_open?()
-> 0.0000s
-- index_exists?(:oauth_access_grants, [:resource_owner_id, :application_id, :created_at], {:name=>"index_oauth_access_grants_on_resource_owner_id", :algorithm=>:concurrently})NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping
NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping
NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping
-> 0.0022s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- add_index(:oauth_access_grants, [:resource_owner_id, :application_id, :created_at], {:name=>"index_oauth_access_grants_on_resource_owner_id", :algorithm=>:concurrently})
-> 0.0039s
-- execute("RESET ALL")
-> 0.0002s
== 20201027210127 AddIndexToOauthAccessGrantsResourceOwnerId: migrated (0.0157s)
== 20201027211138 IncreaseDefaultDiffMaxPatchBytes: migrating =================
-- change_column_default(:application_settings, :diff_max_patch_bytes, {:from=>102400, :to=>204800})
-> 0.0694s
== 20201027211138 IncreaseDefaultDiffMaxPatchBytes: migrated (0.0695s) ========
== 20201028160831 AddTemporaryIndexToVulnerabilitiesTable: migrating ==========
-- transaction_open?()
-> 0.0000s
-- index_exists?(:vulnerabilities, :id, {:where=>"state = 2 AND (dismissed_at IS NULL OR dismissed_by_id IS NULL)", :name=>"temporary_index_vulnerabilities_on_id", :algorithm=>:concurrently})
-> 0.0065s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:vulnerabilities, :id, {:where=>"state = 2 AND (dismissed_at IS NULL OR dismissed_by_id IS NULL)", :name=>"temporary_index_vulnerabilities_on_id", :algorithm=>:concurrently})
-> 0.0037s
-- execute("RESET ALL")
-> 0.0002s
== 20201028160831 AddTemporaryIndexToVulnerabilitiesTable: migrated (0.0112s) =
== 20201028160832 SchedulePopulateMissingDismissalInformationForVulnerabilities: migrating
== 20201028160832 SchedulePopulateMissingDismissalInformationForVulnerabilities: migrated (0.0268s)
== 20201028182809 BackfillJiraTrackerDeploymentType2: migrating ===============
== 20201028182809 BackfillJiraTrackerDeploymentType2: migrated (0.0235s) ======
== 20201028184640 AddHelmMajorVersionToClusters: migrating ====================
-- add_column(:clusters, :helm_major_version, :integer, {:default=>2, :null=>false})
-> 0.0018s
== 20201028184640 AddHelmMajorVersionToClusters: migrated (0.0019s) ===========
== 20201028204306 MigrateDefaultDiffMaxPatchBytesToMinimum200kb: migrating ====
== 20201028204306 MigrateDefaultDiffMaxPatchBytesToMinimum200kb: migrated (0.0088s)
== 20201029052241 MigrateGeoBlobVerificationPrimaryWorkerSidekiqQueue: migrating
== 20201029052241 MigrateGeoBlobVerificationPrimaryWorkerSidekiqQueue: migrated (0.0006s)
== 20201029143650 RenameApplicationSettingsToAllowDenyNames: migrating ========
-- column_exists?(:application_settings, :id)
-> 0.0661s
-- transaction_open?()
-> 0.0000s
-- columns(:application_settings)
-> 0.0640s
-- add_column(:application_settings, :domain_denylist_enabled, :boolean, {:limit=>nil, :precision=>nil, :scale=>nil})
-> 0.0019s
-- change_column_default(:application_settings, :domain_denylist_enabled, "false")
-> 0.0673s
-- transaction_open?()
-> 0.0000s
-- exec_query("SELECT COUNT(*) AS count FROM \"application_settings\"")
-> 0.0010s
-- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" ORDER BY \"application_settings\".\"id\" ASC LIMIT 1")
-> 0.0005s
-- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 1 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
-> 0.0005s
-- execute("UPDATE \"application_settings\" SET \"domain_denylist_enabled\" = \"application_settings\".\"domain_blacklist_enabled\" WHERE \"application_settings\".\"id\" >= 1")
-> 0.0009s
-- indexes(:application_settings)
-> 0.0055s
-- foreign_keys(:application_settings)
-> 0.0049s
-- transaction_open?()
-> 0.0000s
-- column_exists?(:application_settings, :domain_blacklist_enabled)
-> 0.0644s
-- column_exists?(:application_settings, :domain_denylist_enabled)
-> 0.0660s
-- current_schema()
-> 0.0004s
-- quote_table_name(:application_settings)
-> 0.0000s
-- quote_column_name(:domain_blacklist_enabled)
-> 0.0000s
-- quote_column_name(:domain_denylist_enabled)
-> 0.0000s
-- execute("CREATE OR REPLACE FUNCTION trigger_1f0ae12498d3()\nRETURNS trigger AS\n$BODY$\nBEGIN\n NEW.\"domain_denylist_enabled\" := NEW.\"domain_blacklist_enabled\";\n RETURN NEW;\nEND;\n$BODY$\nLANGUAGE 'plpgsql'\nVOLATILE\n")
-> 0.0058s
-- execute("DROP TRIGGER IF EXISTS trigger_1f0ae12498d3\nON \"application_settings\"\n")
-> 0.0008s
-- execute("CREATE TRIGGER trigger_1f0ae12498d3\nBEFORE INSERT OR UPDATE\nON \"application_settings\"\nFOR EACH ROW\nEXECUTE FUNCTION trigger_1f0ae12498d3()\n")
-> 0.0010s
-- column_exists?(:application_settings, :id)
-> 0.0651s
-- transaction_open?()
-> 0.0000s
-- columns(:application_settings)
-> 0.0643s
-- add_column(:application_settings, :domain_denylist, :text, {:limit=>nil, :precision=>nil, :scale=>nil})
-> 0.0014s
-- transaction_open?()
-> 0.0000s
-- exec_query("SELECT COUNT(*) AS count FROM \"application_settings\"")
-> 0.0010s
-- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" ORDER BY \"application_settings\".\"id\" ASC LIMIT 1")
-> 0.0005s
-- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 1 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
-> 0.0013s
-- execute("UPDATE \"application_settings\" SET \"domain_denylist\" = \"application_settings\".\"domain_blacklist\" WHERE \"application_settings\".\"id\" >= 1")
-> 0.0017s
-- indexes(:application_settings)
-> 0.0060s
-- foreign_keys(:application_settings)
-> 0.0045s
-- transaction_open?()
-> 0.0000s
-- column_exists?(:application_settings, :domain_blacklist)
-> 0.0632s
-- column_exists?(:application_settings, :domain_denylist)
-> 0.0637s
-- current_schema()
-> 0.0004s
-- quote_table_name(:application_settings)
-> 0.0000s
-- quote_column_name(:domain_blacklist)
-> 0.0000s
-- quote_column_name(:domain_denylist)
-> 0.0000s
-- execute("CREATE OR REPLACE FUNCTION trigger_72b785aa2f14()\nRETURNS trigger AS\n$BODY$\nBEGIN\n NEW.\"domain_denylist\" := NEW.\"domain_blacklist\";\n RETURN NEW;\nEND;\n$BODY$\nLANGUAGE 'plpgsql'\nVOLATILE\n")
-> 0.0008s
-- execute("DROP TRIGGER IF EXISTS trigger_72b785aa2f14\nON \"application_settings\"\n")
-> 0.0009s
-- execute("CREATE TRIGGER trigger_72b785aa2f14\nBEFORE INSERT OR UPDATE\nON \"application_settings\"\nFOR EACH ROW\nEXECUTE FUNCTION trigger_72b785aa2f14()\n")
-> 0.0006s
-- column_exists?(:application_settings, :id)
-> 0.0651s
-- transaction_open?()
-> 0.0000s
-- columns(:application_settings)
-> 0.0648s
-- add_column(:application_settings, :domain_allowlist, :text, {:limit=>nil, :precision=>nil, :scale=>nil})
-> 0.0014s
-- transaction_open?()
-> 0.0000s
-- exec_query("SELECT COUNT(*) AS count FROM \"application_settings\"")
-> 0.0010s
-- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" ORDER BY \"application_settings\".\"id\" ASC LIMIT 1")
-> 0.0005s
-- exec_query("SELECT \"application_settings\".\"id\" FROM \"application_settings\" WHERE \"application_settings\".\"id\" >= 1 ORDER BY \"application_settings\".\"id\" ASC LIMIT 1 OFFSET 1")
-> 0.0005s
-- execute("UPDATE \"application_settings\" SET \"domain_allowlist\" = \"application_settings\".\"domain_whitelist\" WHERE \"application_settings\".\"id\" >= 1")
-> 0.0011s
-- indexes(:application_settings)
-> 0.0061s
-- foreign_keys(:application_settings)
-> 0.0048s
-- transaction_open?()
-> 0.0000s
-- column_exists?(:application_settings, :domain_whitelist)
-> 0.0682s
-- column_exists?(:application_settings, :domain_allowlist)
-> 0.0643s
-- current_schema()
-> 0.0004s
-- quote_table_name(:application_settings)
-> 0.0000s
-- quote_column_name(:domain_whitelist)
-> 0.0000s
-- quote_column_name(:domain_allowlist)
-> 0.0000s
-- execute("CREATE OR REPLACE FUNCTION trigger_3d531acd472b()\nRETURNS trigger AS\n$BODY$\nBEGIN\n NEW.\"domain_allowlist\" := NEW.\"domain_whitelist\";\n RETURN NEW;\nEND;\n$BODY$\nLANGUAGE 'plpgsql'\nVOLATILE\n")
-> 0.0010s
-- execute("DROP TRIGGER IF EXISTS trigger_3d531acd472b\nON \"application_settings\"\n")
-> 0.0012s
-- execute("CREATE TRIGGER trigger_3d531acd472b\nBEFORE INSERT OR UPDATE\nON \"application_settings\"\nFOR EACH ROW\nEXECUTE FUNCTION trigger_3d531acd472b()\n")
-> 0.0007s
== 20201029143650 RenameApplicationSettingsToAllowDenyNames: migrated (0.9903s)
== 20201029144157 CleanupApplicationSettingsToAllowDenyRename: migrating ======
-- execute("DROP TRIGGER IF EXISTS trigger_1f0ae12498d3 ON application_settings")
-> 0.0009s
-- execute("DROP FUNCTION IF EXISTS trigger_1f0ae12498d3()")
-> 0.0005s
-- remove_column(:application_settings, :domain_blacklist_enabled)
-> 0.0018s
-- execute("DROP TRIGGER IF EXISTS trigger_72b785aa2f14 ON application_settings")
-> 0.0008s
-- execute("DROP FUNCTION IF EXISTS trigger_72b785aa2f14()")
-> 0.0004s
-- remove_column(:application_settings, :domain_blacklist)
-> 0.0013s
-- execute("DROP TRIGGER IF EXISTS trigger_3d531acd472b ON application_settings")
-> 0.0008s
-- execute("DROP FUNCTION IF EXISTS trigger_3d531acd472b()")
-> 0.0004s
-- remove_column(:application_settings, :domain_whitelist)
-> 0.0012s
== 20201029144157 CleanupApplicationSettingsToAllowDenyRename: migrated (0.0096s)
== 20201029144444 CreateVulnerabilityFindingLinks: migrating ==================
-- create_table(:vulnerability_finding_links, {:if_not_exists=>true})
-> 0.0317s
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0003s
-- execute("ALTER TABLE vulnerability_finding_links\nADD CONSTRAINT check_55f0a95439\nCHECK ( char_length(name) <= 255 )\nNOT VALID;\n")
-> 0.0010s
-- current_schema()
-> 0.0002s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE vulnerability_finding_links VALIDATE CONSTRAINT check_55f0a95439;")
-> 0.0006s
-- execute("RESET ALL")
-> 0.0002s
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0002s
-- execute("ALTER TABLE vulnerability_finding_links\nADD CONSTRAINT check_b7fe886df6\nCHECK ( char_length(url) <= 2048 )\nNOT VALID;\n")
-> 0.0005s
-- current_schema()
-> 0.0002s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE vulnerability_finding_links VALIDATE CONSTRAINT check_b7fe886df6;")
-> 0.0005s
-- execute("RESET ALL")
-> 0.0002s
== 20201029144444 CreateVulnerabilityFindingLinks: migrated (0.0440s) =========
== 20201030092151 AddRequirementsAccessLevelToProjectFeatures: migrating ======
-- column_exists?(:project_features, :requirements_access_level)
-> 0.0022s
-- add_column(:project_features, :requirements_access_level, :integer, {:default=>20, :null=>false})
-> 0.0010s
== 20201030092151 AddRequirementsAccessLevelToProjectFeatures: migrated (0.0048s)
== 20201030200115 AddIidToDesignManagementDesign: migrating ===================
-- add_column(:design_management_designs, :iid, :integer)
-> 0.0012s
== 20201030200115 AddIidToDesignManagementDesign: migrated (0.0012s) ==========
== 20201030200539 AddIndexOnDesignManagementDesignsIidProjectId: migrating ====
-- transaction_open?()
-> 0.0000s
-- index_exists?(:design_management_designs, [:project_id, :iid], {:name=>"index_design_management_designs_on_iid_and_project_id", :unique=>true, :algorithm=>:concurrently})
-> 0.0035s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- add_index(:design_management_designs, [:project_id, :iid], {:name=>"index_design_management_designs_on_iid_and_project_id", :unique=>true, :algorithm=>:concurrently})
-> 0.0036s
-- execute("RESET ALL")
-> 0.0002s
== 20201030200539 AddIndexOnDesignManagementDesignsIidProjectId: migrated (0.0083s)
== 20201030203854 BackfillDesignIids: migrating ===============================
== 20201030203854 BackfillDesignIids: migrated (0.0076s) ======================
== 20201102073808 ScheduleBlockedByLinksReplacementSecondTry: migrating =======
== 20201102073808 ScheduleBlockedByLinksReplacementSecondTry: migrated (0.0206s)
== 20201102112206 RenameSitemapNamespace: migrating ===========================
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("RESET ALL")
-> 0.0002s
== 20201102112206 RenameSitemapNamespace: migrated (0.0036s) ==================
== 20201102114018 RemoveStorageSizeLimitFromApplicationSettings: migrating ====
-- remove_column(:application_settings, :namespace_storage_size_limit)
-> 0.0024s
== 20201102114018 RemoveStorageSizeLimitFromApplicationSettings: migrated (0.0025s)
== 20201102152554 AddNotNullCheckOnIidOnDesignManangementDesigns: migrating ===
-- current_schema()
-> 0.0004s
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0003s
-- execute("ALTER TABLE design_management_designs\nADD CONSTRAINT check_cfb92df01a\nCHECK ( iid IS NOT NULL )\nNOT VALID;\n")
-> 0.0005s
-- current_schema()
-> 0.0002s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE design_management_designs VALIDATE CONSTRAINT check_cfb92df01a;")
-> 0.0006s
-- execute("RESET ALL")
-> 0.0002s
== 20201102152554 AddNotNullCheckOnIidOnDesignManangementDesigns: migrated (0.0107s)
== 20201102152945 TruncateSecurityFindingsTable: migrating ====================
== 20201102152945 TruncateSecurityFindingsTable: migrated (0.0000s) ===========
== 20201102184743 AddIndexToIncidentIssuesOnProjectAndCreatedAt: migrating ====
-- transaction_open?()
-> 0.0000s
-- index_exists?(:issues, [:project_id, :created_at], {:where=>"issue_type = 1", :name=>"index_issues_on_project_id_and_created_at_issue_type_incident", :algorithm=>:concurrently})
-> 0.0165s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:issues, [:project_id, :created_at], {:where=>"issue_type = 1", :name=>"index_issues_on_project_id_and_created_at_issue_type_incident", :algorithm=>:concurrently})
-> 0.0044s
-- execute("RESET ALL")
-> 0.0002s
-- transaction_open?()
-> 0.0000s
-- indexes(:issues)
-> 0.0143s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- remove_index(:issues, {:algorithm=>:concurrently, :name=>"index_issues_project_id_issue_type_incident"})
-> 0.0022s
-- execute("RESET ALL")
-> 0.0002s
== 20201102184743 AddIndexToIncidentIssuesOnProjectAndCreatedAt: migrated (0.0397s)
== 20201103013242 RemoveTerraformStateVerificationColumns: migrating ==========
-- transaction()
-- remove_column(:terraform_states, :verification_retry_at, :datetime_with_timezone)
-> 0.0014s
-- remove_column(:terraform_states, :verified_at, :datetime_with_timezone)
-> 0.0004s
-- remove_column(:terraform_states, :verification_retry_count, :integer, {:limit=>2})
-> 0.0005s
-- remove_column(:terraform_states, :verification_checksum, :binary, {:using=>"verification_checksum::bytea"})
-> 0.0004s
-- remove_column(:terraform_states, :verification_failure, :text)
-> 0.0005s
-> 0.0041s
== 20201103013242 RemoveTerraformStateVerificationColumns: migrated (0.0042s) =
== 20201103095752 AddIssuesClosedAtIndex: migrating ===========================
-- transaction_open?()
-> 0.0000s
-- index_exists?(:issues, [:project_id, :closed_at], {:algorithm=>:concurrently})
-> 0.0140s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:issues, [:project_id, :closed_at], {:algorithm=>:concurrently})
-> 0.0042s
-- execute("RESET ALL")
-> 0.0002s
== 20201103095752 AddIssuesClosedAtIndex: migrated (0.0192s) ==================
== 20201103110018 ScheduleMergeRequestCleanupSchedulesBackfill: migrating =====
-- transaction_open?()
-> 0.0000s
-- index_exists?(:merge_requests, :id, {:name=>"merge_requests_state_id_temp_index", :where=>"state_id IN (2, 3)", :algorithm=>:concurrently})
-> 0.0143s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:merge_requests, :id, {:name=>"merge_requests_state_id_temp_index", :where=>"state_id IN (2, 3)", :algorithm=>:concurrently})
-> 0.0042s
-- execute("RESET ALL")
-> 0.0002s
== 20201103110018 ScheduleMergeRequestCleanupSchedulesBackfill: migrated (0.0478s)
== 20201103171537 AddIndexActiveBillableUsersToUser: migrating ================
-- transaction_open?()
-> 0.0000s
-- index_exists?(:users, :id, {:name=>"active_billable_users", :where=>"(state = 'active' AND (user_type is NULL or user_type in (NULL, 6, 4))) and ((users.user_type IS NULL) OR (users.user_type <> ALL ('{2,6,1,3,7,8}')))", :algorithm=>:concurrently})
-> 0.0118s
-- execute("SET statement_timeout TO 0")
-> 0.0034s
-- add_index(:users, :id, {:name=>"active_billable_users", :where=>"(state = 'active' AND (user_type is NULL or user_type in (NULL, 6, 4))) and ((users.user_type IS NULL) OR (users.user_type <> ALL ('{2,6,1,3,7,8}')))", :algorithm=>:concurrently})
-> 0.0051s
-- execute("RESET ALL")
-> 0.0002s
== 20201103171537 AddIndexActiveBillableUsersToUser: migrated (0.0212s) =======
== 20201103184333 CreatePackagesPackageFileBuildInfos: migrating ==============
-- table_exists?(:packages_package_file_build_infos)
-> 0.0010s
-- create_table(:packages_package_file_build_infos)
-> 0.0240s
== 20201103184333 CreatePackagesPackageFileBuildInfos: migrated (0.0268s) =====
== 20201103192526 SchedulePopulateHasVulnerabilities: migrating ===============
== 20201103192526 SchedulePopulateHasVulnerabilities: migrated (0.0052s) ======
== 20201103202213 UpdatePackagesBuildInfosIndex: migrating ====================
-- transaction_open?()
-> 0.0000s
-- index_exists?(:packages_build_infos, :package_id, {:name=>"idx_packages_build_infos_on_package_id", :algorithm=>:concurrently})
-> 0.0031s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- add_index(:packages_build_infos, :package_id, {:name=>"idx_packages_build_infos_on_package_id", :algorithm=>:concurrently})
-> 0.0042s
-- execute("RESET ALL")
-> 0.0003s
-- transaction_open?()
-> 0.0000s
-- indexes(:packages_build_infos)
-> 0.0029s
-- execute("SET statement_timeout TO 0")
-> 0.0004s
-- remove_index(:packages_build_infos, {:algorithm=>:concurrently, :name=>"index_packages_build_infos_on_package_id"})
-> 0.0048s
-- execute("RESET ALL")
-> 0.0003s
== 20201103202213 UpdatePackagesBuildInfosIndex: migrated (0.0182s) ===========
== 20201104204739 CreateBulkImportTrackers: migrating =========================
-- table_exists?(:bulk_import_trackers)
-> 0.0007s
-- create_table(:bulk_import_trackers)
-> 0.0213s
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0003s
-- execute("ALTER TABLE bulk_import_trackers\nADD CONSTRAINT check_next_page_requirement\nCHECK ( (has_next_page IS FALSE or next_page IS NOT NULL) )\nNOT VALID;\n")
-> 0.0006s
-- current_schema()
-> 0.0003s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE bulk_import_trackers VALIDATE CONSTRAINT check_next_page_requirement;")
-> 0.0006s
-- execute("RESET ALL")
-> 0.0002s
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0002s
-- execute("ALTER TABLE bulk_import_trackers\nADD CONSTRAINT check_2d45cae629\nCHECK ( char_length(relation) <= 255 )\nNOT VALID;\n")
-> 0.0005s
-- current_schema()
-> 0.0002s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE bulk_import_trackers VALIDATE CONSTRAINT check_2d45cae629;")
-> 0.0006s
-- execute("RESET ALL")
-> 0.0003s
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0002s
-- execute("ALTER TABLE bulk_import_trackers\nADD CONSTRAINT check_40aeaa600b\nCHECK ( char_length(next_page) <= 255 )\nNOT VALID;\n")
-> 0.0005s
-- current_schema()
-> 0.0003s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE bulk_import_trackers VALIDATE CONSTRAINT check_40aeaa600b;")
-> 0.0006s
-- execute("RESET ALL")
-> 0.0002s
== 20201104204739 CreateBulkImportTrackers: migrated (0.0501s) ================
== 20201105021637 AddUploadsSizeToProjectStatistics: migrating ================
-- add_column(:project_statistics, :uploads_size, :bigint, {:default=>0, :null=>false})
-> 0.0014s
== 20201105021637 AddUploadsSizeToProjectStatistics: migrated (0.0015s) =======
== 20201105024127 AddUploadsSizeToNamespaceRootStorageStatistics: migrating ===
-- add_column(:namespace_root_storage_statistics, :uploads_size, :bigint, {:default=>0, :null=>false})
-> 0.0020s
== 20201105024127 AddUploadsSizeToNamespaceRootStorageStatistics: migrated (0.0020s)
== 20201105135051 ChangeDefaultValueOfCiMaxArtifactSizeLsifOfPlanLimitsFrom20To100: migrating
-- change_column_default(:plan_limits, :ci_max_artifact_size_lsif, 100)
-> 0.0055s
-- execute("UPDATE plan_limits SET ci_max_artifact_size_lsif = 100 WHERE ci_max_artifact_size_lsif = 20")
-> 0.0013s
== 20201105135051 ChangeDefaultValueOfCiMaxArtifactSizeLsifOfPlanLimitsFrom20To100: migrated (0.0089s)
== 20201105143211 AddVulnerabilitiesEnabledAndIssuetypeToJiraTrackerData: migrating
-- add_column(:jira_tracker_data, :vulnerabilities_issuetype, :text)
-> 0.0013s
-- add_column(:jira_tracker_data, :vulnerabilities_enabled, :boolean, {:default=>false, :null=>false})
-> 0.0014s
== 20201105143211 AddVulnerabilitiesEnabledAndIssuetypeToJiraTrackerData: migrated (0.0028s)
== 20201105143312 AddTextLimitToJiraTrackerDataIssuetype: migrating ===========
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0006s
-- execute("ALTER TABLE jira_tracker_data\nADD CONSTRAINT check_0bf84b76e9\nCHECK ( char_length(vulnerabilities_issuetype) <= 255 )\nNOT VALID;\n")
-> 0.0007s
-- current_schema()
-> 0.0003s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE jira_tracker_data VALIDATE CONSTRAINT check_0bf84b76e9;")
-> 0.0006s
-- execute("RESET ALL")
-> 0.0002s
== 20201105143312 AddTextLimitToJiraTrackerDataIssuetype: migrated (0.0073s) ==
== 20201106082723 AddMergeRequestJiraReferenceIndexes: migrating ==============
-- transaction_open?()
-> 0.0000s
-- index_exists?(:merge_requests, [:target_project_id, :iid], {:name=>"index_merge_requests_on_target_project_id_and_iid_jira_title", :using=>:btree, :where=>"(merge_requests.title)::text ~ '[A-Z][A-Z_0-9]+-\\d+'::text", :algorithm=>:concurrently})
-> 0.0156s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- add_index(:merge_requests, [:target_project_id, :iid], {:name=>"index_merge_requests_on_target_project_id_and_iid_jira_title", :using=>:btree, :where=>"(merge_requests.title)::text ~ '[A-Z][A-Z_0-9]+-\\d+'::text", :algorithm=>:concurrently})
-> 0.0041s
-- execute("RESET ALL")
-> 0.0002s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:merge_requests, [:target_project_id, :iid], {:name=>"index_merge_requests_on_target_project_id_iid_jira_description", :using=>:btree, :where=>"(merge_requests.description)::text ~ '[A-Z][A-Z_0-9]+-\\d+'::text", :algorithm=>:concurrently})
-> 0.0159s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:merge_requests, [:target_project_id, :iid], {:name=>"index_merge_requests_on_target_project_id_iid_jira_description", :using=>:btree, :where=>"(merge_requests.description)::text ~ '[A-Z][A-Z_0-9]+-\\d+'::text", :algorithm=>:concurrently})
-> 0.0041s
-- execute("RESET ALL")
-> 0.0002s
== 20201106082723 AddMergeRequestJiraReferenceIndexes: migrated (0.0420s) =====
== 20201106134139 AddPipelinesCreatedIndex: migrating =========================
-- transaction_open?()
-> 0.0000s
-- index_exists?(:ci_pipelines, [:project_id, :status, :created_at], {:name=>:index_ci_pipelines_on_project_id_and_status_and_created_at, :algorithm=>:concurrently})
-> 0.0115s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:ci_pipelines, [:project_id, :status, :created_at], {:name=>:index_ci_pipelines_on_project_id_and_status_and_created_at, :algorithm=>:concurrently})
-> 0.0048s
-- execute("RESET ALL")
-> 0.0002s
== 20201106134139 AddPipelinesCreatedIndex: migrated (0.0174s) ================
== 20201106134950 DeduplicateEpicIids: migrating ==============================
-- transaction_open?()
-> 0.0000s
-- index_exists?(:epics, [:group_id, :iid], {:unique=>true, :name=>"index_epics_on_group_id_and_iid", :algorithm=>:concurrently})
-> 0.0085s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:epics, [:group_id, :iid], {:unique=>true, :name=>"index_epics_on_group_id_and_iid", :algorithm=>:concurrently})
-> 0.0041s
-- execute("RESET ALL")
-> 0.0002s
== 20201106134950 DeduplicateEpicIids: migrated (0.0191s) =====================
== 20201107032257 AddDefaultTrueRequireAdminApprovalAfterUserSignupToApplicationSettings: migrating
-- change_column_default(:application_settings, :require_admin_approval_after_user_signup, {:from=>false, :to=>true})
-> 0.0770s
== 20201107032257 AddDefaultTrueRequireAdminApprovalAfterUserSignupToApplicationSettings: migrated (0.0827s)
== 20201109144634 AddRegionFieldToAwsRole: migrating ==========================
-- column_exists?(:aws_roles, :region)
-> 0.0016s
-- add_column(:aws_roles, :region, :text)
-> 0.0011s
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0003s
-- execute("ALTER TABLE aws_roles\nADD CONSTRAINT check_57adedab55\nCHECK ( char_length(region) <= 255 )\nNOT VALID;\n")
-> 0.0006s
-- current_schema()
-> 0.0003s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE aws_roles VALIDATE CONSTRAINT check_57adedab55;")
-> 0.0005s
-- execute("RESET ALL")
-> 0.0002s
== 20201109144634 AddRegionFieldToAwsRole: migrated (0.0089s) =================
== 20201109180311 AddSecretDetectionRevocationTokenTypesApplicationSettings: migrating
-- add_column(:application_settings, :secret_detection_revocation_token_types_url, :text, {:null=>true})
-> 0.0016s
== 20201109180311 AddSecretDetectionRevocationTokenTypesApplicationSettings: migrated (0.0017s)
== 20201109184023 AddTextLimitToSecretDetectionRevocationTokenTypesApplicationSettings: migrating
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0004s
-- execute("ALTER TABLE application_settings\nADD CONSTRAINT check_a5704163cc\nCHECK ( char_length(secret_detection_revocation_token_types_url) <= 255 )\nNOT VALID;\n")
-> 0.0018s
-- current_schema()
-> 0.0002s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE application_settings VALIDATE CONSTRAINT check_a5704163cc;")
-> 0.0013s
-- execute("RESET ALL")
-> 0.0002s
== 20201109184023 AddTextLimitToSecretDetectionRevocationTokenTypesApplicationSettings: migrated (0.0083s)
== 20201110035029 CreatedIndexForVulnerabilityOccurrencesOnProjectFingerprint: migrating
-- transaction_open?()
-> 0.0000s
-- index_exists?(:vulnerability_occurrences, :project_fingerprint, {:name=>"index_vulnerability_occurrences_on_project_fingerprint", :algorithm=>:concurrently})
-> 0.0039s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:vulnerability_occurrences, :project_fingerprint, {:name=>"index_vulnerability_occurrences_on_project_fingerprint", :algorithm=>:concurrently})
-> 0.0036s
-- execute("RESET ALL")
-> 0.0002s
== 20201110035029 CreatedIndexForVulnerabilityOccurrencesOnProjectFingerprint: migrated (0.0085s)
== 20201110110454 ExtendPostgresIndexesView: migrating ========================
-- execute("DROP VIEW postgres_indexes;\n\nCREATE VIEW postgres_indexes AS\nSELECT (pg_namespace.nspname::text || '.'::text) || pg_class.relname::text AS identifier,\n pg_index.indexrelid,\n pg_namespace.nspname AS schema,\n pg_class.relname AS name,\n pg_index.indisunique AS \"unique\",\n pg_index.indisvalid AS valid_index,\n pg_class.relispartition AS partitioned,\n pg_index.indisexclusion AS exclusion,\n pg_index.indexprs IS NOT NULL as expression,\n pg_index.indpred IS NOT NULL as partial,\n pg_indexes.indexdef AS definition,\n pg_relation_size(pg_class.oid::regclass) AS ondisk_size_bytes\nFROM pg_index\n JOIN pg_class ON pg_class.oid = pg_index.indexrelid\n JOIN pg_namespace ON pg_class.relnamespace = pg_namespace.oid\n JOIN pg_indexes ON pg_class.relname = pg_indexes.indexname\nWHERE pg_namespace.nspname <> 'pg_catalog'::name\n AND (pg_namespace.nspname = ANY (ARRAY[\"current_schema\"(), 'gitlab_partitions_dynamic'::name, 'gitlab_partitions_static'::name]));\n")
-> 0.0049s
== 20201110110454 ExtendPostgresIndexesView: migrated (0.0050s) ===============
== 20201110133629 ChangeIndexMrMetricsTargetProjectId: migrating ==============
-- transaction_open?()
-> 0.0000s
-- index_exists?(:merge_request_metrics, [:target_project_id, :merged_at, :id], {:order=>{:merged_at=>"DESC NULLS LAST", :id=>"DESC"}, :name=>"index_mr_metrics_on_target_project_id_merged_at_nulls_last", :algorithm=>:concurrently})
-> 0.0073s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- add_index(:merge_request_metrics, [:target_project_id, :merged_at, :id], {:order=>{:merged_at=>"DESC NULLS LAST", :id=>"DESC"}, :name=>"index_mr_metrics_on_target_project_id_merged_at_nulls_last", :algorithm=>:concurrently})
-> 0.0035s
-- execute("RESET ALL")
-> 0.0002s
-- transaction_open?()
-> 0.0000s
-- indexes(:merge_request_metrics)
-> 0.0059s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- remove_index(:merge_request_metrics, {:algorithm=>:concurrently, :name=>"index_merge_request_metrics_on_target_project_id_merged_at"})
-> 0.0019s
-- execute("RESET ALL")
-> 0.0003s
== 20201110133629 ChangeIndexMrMetricsTargetProjectId: migrated (0.0210s) =====
== 20201111110318 AddCloudLicenseAuthTokenToSettings: migrating ===============
-- add_column(:application_settings, :encrypted_cloud_license_auth_token, :text)
-> 0.0015s
-- add_column(:application_settings, :encrypted_cloud_license_auth_token_iv, :text)
-> 0.0008s
== 20201111110318 AddCloudLicenseAuthTokenToSettings: migrated (0.0024s) ======
== 20201111110918 AddCloudLicenseAuthTokenApplicationSettingsTextLimit: migrating
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0003s
-- execute("ALTER TABLE application_settings\nADD CONSTRAINT check_ef6176834f\nCHECK ( char_length(encrypted_cloud_license_auth_token_iv) <= 255 )\nNOT VALID;\n")
-> 0.0017s
-- current_schema()
-> 0.0003s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE application_settings VALIDATE CONSTRAINT check_ef6176834f;")
-> 0.0012s
-- execute("RESET ALL")
-> 0.0002s
== 20201111110918 AddCloudLicenseAuthTokenApplicationSettingsTextLimit: migrated (0.0078s)
== 20201111152859 AddMissingExpressionIndexes: migrating ======================
-- index_name_exists?(:namespaces, :index_on_namespaces_lower_name)
-> 0.0013s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:namespaces, "LOWER(name)", {:name=>:index_on_namespaces_lower_name, :algorithm=>:concurrently})
-> 0.0105s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:namespaces, "LOWER(name)", {:name=>:index_on_namespaces_lower_name, :algorithm=>:concurrently})
-> 0.0046s
-- execute("RESET ALL")
-> 0.0003s
-- index_name_exists?(:namespaces, :index_on_namespaces_lower_path)
-> 0.0010s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:namespaces, "LOWER(path)", {:name=>:index_on_namespaces_lower_path, :algorithm=>:concurrently})
-> 0.0099s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:namespaces, "LOWER(path)", {:name=>:index_on_namespaces_lower_path, :algorithm=>:concurrently})
-> 0.0046s
-- execute("RESET ALL")
-> 0.0002s
-- index_name_exists?(:projects, :index_on_projects_lower_path)
-> 0.0008s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:projects, "LOWER(path)", {:name=>:index_on_projects_lower_path, :algorithm=>:concurrently})
-> 0.0548s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:projects, "LOWER(path)", {:name=>:index_on_projects_lower_path, :algorithm=>:concurrently})
-> 0.0134s
-- execute("RESET ALL")
-> 0.0003s
-- index_name_exists?(:routes, :index_on_routes_lower_path)
-> 0.0011s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:routes, "LOWER(path)", {:name=>:index_on_routes_lower_path, :algorithm=>:concurrently})
-> 0.0040s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:routes, "LOWER(path)", {:name=>:index_on_routes_lower_path, :algorithm=>:concurrently})
-> 0.0031s
-- execute("RESET ALL")
-> 0.0002s
-- index_name_exists?(:users, :index_on_users_lower_username)
-> 0.0008s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:users, "LOWER(username)", {:name=>:index_on_users_lower_username, :algorithm=>:concurrently})
-> 0.0114s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:users, "LOWER(username)", {:name=>:index_on_users_lower_username, :algorithm=>:concurrently})
-> 0.0041s
-- execute("RESET ALL")
-> 0.0002s
-- index_name_exists?(:users, :index_on_users_lower_email)
-> 0.0008s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:users, "LOWER(email)", {:name=>:index_on_users_lower_email, :algorithm=>:concurrently})
-> 0.0164s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:users, "LOWER(email)", {:name=>:index_on_users_lower_email, :algorithm=>:concurrently})
-> 0.0055s
-- execute("RESET ALL")
-> 0.0003s
-- execute("ANALYZE namespaces")
-> 0.0100s
-- execute("ANALYZE projects")
-> 0.0030s
-- execute("ANALYZE routes")
-> 0.0009s
-- execute("ANALYZE users")
-> 0.0028s
== 20201111152859 AddMissingExpressionIndexes: migrated (0.1712s) =============
== 20201112195322 ReseedMergeTrainsEnabled: migrating =========================
-- transaction_open?()
-> 0.0000s
-- exec_query("SELECT COUNT(*) AS count FROM \"project_ci_cd_settings\" WHERE \"project_ci_cd_settings\".\"merge_pipelines_enabled\" = TRUE")
-> 0.0007s
== 20201112195322 ReseedMergeTrainsEnabled: migrated (0.0010s) ================
- execute "bash" "/tmp/chef-script20201126-15996-1maofdi"
Recipe: gitlab::gitlab-rails
* execute[clear the gitlab-rails cache] action run
- execute /opt/gitlab/bin/gitlab-rake cache:clear
Recipe: logrotate::folders_and_configs
* directory[/var/opt/gitlab/logrotate] action create (up to date)
* directory[/var/opt/gitlab/logrotate/logrotate.d] action create (up to date)
* directory[/var/log/gitlab/logrotate] action create (up to date)
* template[/var/opt/gitlab/logrotate/logrotate.conf] action create
- update content in file /var/opt/gitlab/logrotate/logrotate.conf from 3dfefa to 8068c8
--- /var/opt/gitlab/logrotate/logrotate.conf 2020-10-23 16:39:43.510822769 +0200
+++ /var/opt/gitlab/logrotate/.chef-logrotate20201126-15996-1l92ok3.conf 2020-11-26 11:54:06.594633038 +0100
@@ -10,4 +10,5 @@
include /var/opt/gitlab/logrotate/logrotate.d/gitlab-workhorse
include /var/opt/gitlab/logrotate/logrotate.d/gitlab-pages
include /var/opt/gitlab/logrotate/logrotate.d/gitlab-kas
+include /var/opt/gitlab/logrotate/logrotate.d/gitaly
* template[/var/opt/gitlab/logrotate/logrotate.d/nginx] action create
- update content in file /var/opt/gitlab/logrotate/logrotate.d/nginx from 85cdbe to e17e19
--- /var/opt/gitlab/logrotate/logrotate.d/nginx 2020-04-22 18:59:10.426570193 +0200
+++ /var/opt/gitlab/logrotate/logrotate.d/.chef-nginx20201126-15996-17t0s1e 2020-11-26 11:54:06.622632895 +0100
@@ -10,6 +10,7 @@
compress
copytruncate
missingok
+ notifempty
postrotate
endscript
* template[/var/opt/gitlab/logrotate/logrotate.d/puma] action create
- update content in file /var/opt/gitlab/logrotate/logrotate.d/puma from 488f46 to 44ad27
--- /var/opt/gitlab/logrotate/logrotate.d/puma 2020-04-22 18:59:10.438569904 +0200
+++ /var/opt/gitlab/logrotate/logrotate.d/.chef-puma20201126-15996-2sqet2 2020-11-26 11:54:06.646632773 +0100
@@ -10,6 +10,7 @@
compress
copytruncate
missingok
+ notifempty
postrotate
endscript
* template[/var/opt/gitlab/logrotate/logrotate.d/actioncable] action create
- update content in file /var/opt/gitlab/logrotate/logrotate.d/actioncable from cc6937 to e09d23
--- /var/opt/gitlab/logrotate/logrotate.d/actioncable 2020-06-07 11:35:02.653190313 +0200
+++ /var/opt/gitlab/logrotate/logrotate.d/.chef-actioncable20201126-15996-1lxhtz8 2020-11-26 11:54:06.674632630 +0100
@@ -10,6 +10,7 @@
compress
copytruncate
missingok
+ notifempty
postrotate
endscript
* template[/var/opt/gitlab/logrotate/logrotate.d/unicorn] action create
- update content in file /var/opt/gitlab/logrotate/logrotate.d/unicorn from 5bb132 to ca6456
--- /var/opt/gitlab/logrotate/logrotate.d/unicorn 2020-04-22 18:59:10.446569712 +0200
+++ /var/opt/gitlab/logrotate/logrotate.d/.chef-unicorn20201126-15996-172rujl 2020-11-26 11:54:06.698632507 +0100
@@ -10,6 +10,7 @@
compress
copytruncate
missingok
+ notifempty
postrotate
endscript
* template[/var/opt/gitlab/logrotate/logrotate.d/gitlab-rails] action create
- update content in file /var/opt/gitlab/logrotate/logrotate.d/gitlab-rails from 46f691 to 26254a
--- /var/opt/gitlab/logrotate/logrotate.d/gitlab-rails 2020-04-22 18:59:10.458569423 +0200
+++ /var/opt/gitlab/logrotate/logrotate.d/.chef-gitlab-rails20201126-15996-y72d12 2020-11-26 11:54:06.722632384 +0100
@@ -10,6 +10,7 @@
compress
copytruncate
missingok
+ notifempty
postrotate
endscript
* template[/var/opt/gitlab/logrotate/logrotate.d/gitlab-shell] action create
- update content in file /var/opt/gitlab/logrotate/logrotate.d/gitlab-shell from d296e1 to 3a880d
--- /var/opt/gitlab/logrotate/logrotate.d/gitlab-shell 2020-04-22 18:59:10.466569231 +0200
+++ /var/opt/gitlab/logrotate/logrotate.d/.chef-gitlab-shell20201126-15996-294qxg 2020-11-26 11:54:06.750632241 +0100
@@ -10,6 +10,7 @@
compress
copytruncate
missingok
+ notifempty
postrotate
endscript
* template[/var/opt/gitlab/logrotate/logrotate.d/gitlab-workhorse] action create
- update content in file /var/opt/gitlab/logrotate/logrotate.d/gitlab-workhorse from 6f35eb to 3453f6
--- /var/opt/gitlab/logrotate/logrotate.d/gitlab-workhorse 2020-04-22 18:59:10.478568942 +0200
+++ /var/opt/gitlab/logrotate/logrotate.d/.chef-gitlab-workhorse20201126-15996-13hhbez 2020-11-26 11:54:06.778632098 +0100
@@ -10,6 +10,7 @@
compress
copytruncate
missingok
+ notifempty
postrotate
endscript
* template[/var/opt/gitlab/logrotate/logrotate.d/gitlab-pages] action create
- update content in file /var/opt/gitlab/logrotate/logrotate.d/gitlab-pages from 59438b to 3c118a
--- /var/opt/gitlab/logrotate/logrotate.d/gitlab-pages 2020-04-22 18:59:10.490568653 +0200
+++ /var/opt/gitlab/logrotate/logrotate.d/.chef-gitlab-pages20201126-15996-1xgok0n 2020-11-26 11:54:06.806631955 +0100
@@ -10,6 +10,7 @@
compress
copytruncate
missingok
+ notifempty
postrotate
endscript
* template[/var/opt/gitlab/logrotate/logrotate.d/gitlab-kas] action create
- update content in file /var/opt/gitlab/logrotate/logrotate.d/gitlab-kas from e1790e to 0ba4f0
--- /var/opt/gitlab/logrotate/logrotate.d/gitlab-kas 2020-10-23 16:39:43.730821869 +0200
+++ /var/opt/gitlab/logrotate/logrotate.d/.chef-gitlab-kas20201126-15996-pvutr1 2020-11-26 11:54:06.834631812 +0100
@@ -10,6 +10,7 @@
compress
copytruncate
missingok
+ notifempty
postrotate
endscript
* template[/var/opt/gitlab/logrotate/logrotate.d/gitaly] action create
- create new file /var/opt/gitlab/logrotate/logrotate.d/gitaly
- update content in file /var/opt/gitlab/logrotate/logrotate.d/gitaly from none to 02bda7
--- /var/opt/gitlab/logrotate/logrotate.d/gitaly 2020-11-26 11:54:06.858631689 +0100
+++ /var/opt/gitlab/logrotate/logrotate.d/.chef-gitaly20201126-15996-1ocarg3 2020-11-26 11:54:06.858631689 +0100
@@ -1,17 +1,34 @@
+# Generated by gitlab-ctl reconfigure
+# Modifications will be overwritten!
+
+/var/log/gitlab/gitaly/*.log {
+ su git git
+ daily
+
+
+ rotate 30
+ compress
+ copytruncate
+ missingok
+ notifempty
+ postrotate
+
+ endscript
+}
Recipe: gitlab::unicorn_disable
* unicorn_service[unicorn] action disable
Recipe: <Dynamically Defined Resource>
* service[unicorn] action nothing (skipped due to action :nothing)
* runit_service[unicorn] action disable
* ruby_block[disable unicorn] action run (skipped due to only_if)
(up to date)
(up to date)
Recipe: gitlab::unicorn_disable
* consul_service[rails] action delete (skipped due to not_if)
Recipe: gitlab::puma
* directory[/var/log/gitlab/puma] action create (up to date)
* directory[/opt/gitlab/var/puma] action create (up to date)
* directory[/var/opt/gitlab/gitlab-rails/sockets] action create (up to date)
* puma_config[/var/opt/gitlab/gitlab-rails/etc/puma.rb] action create
* directory[/var/opt/gitlab/gitlab-rails/etc] action create (up to date)
* template[/var/opt/gitlab/gitlab-rails/etc/puma.rb] action create (up to date)
(up to date)
* service[puma] action nothing (skipped due to action :nothing)
* runit_service[puma] action enable
* ruby_block[restart_service] action nothing (skipped due to action :nothing)
* ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
* ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/sv/puma] action create (up to date)
* template[/opt/gitlab/sv/puma/run] action create (up to date)
* directory[/opt/gitlab/sv/puma/log] action create (up to date)
* directory[/opt/gitlab/sv/puma/log/main] action create (up to date)
* template[/opt/gitlab/sv/puma/log/config] action create (up to date)
* ruby_block[verify_chown_persisted_on_puma] action nothing (skipped due to action :nothing)
* link[/var/log/gitlab/puma/config] action create (up to date)
* template[/opt/gitlab/sv/puma/log/run] action create (up to date)
* directory[/opt/gitlab/sv/puma/env] action create (up to date)
* ruby_block[Delete unmanaged env files for puma service] action run (skipped due to only_if)
* template[/opt/gitlab/sv/puma/check] action create (skipped due to only_if)
* template[/opt/gitlab/sv/puma/finish] action create (skipped due to only_if)
* directory[/opt/gitlab/sv/puma/control] action create (up to date)
* template[/opt/gitlab/sv/puma/control/t] action create (up to date)
* template[/opt/gitlab/sv/puma/control/h] action create (up to date)
* link[/opt/gitlab/init/puma] action create (up to date)
* file[/opt/gitlab/sv/puma/down] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/service] action create (up to date)
* link[/opt/gitlab/service/puma] action create (up to date)
* ruby_block[wait for puma service socket] action run (skipped due to not_if)
(up to date)
* runit_service[puma] action enable
* ruby_block[restart_service] action nothing (skipped due to action :nothing)
* ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
* ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/sv/puma] action create (up to date)
* template[/opt/gitlab/sv/puma/run] action create (up to date)
* directory[/opt/gitlab/sv/puma/log] action create (up to date)
* directory[/opt/gitlab/sv/puma/log/main] action create (up to date)
* template[/opt/gitlab/sv/puma/log/config] action create (up to date)
* ruby_block[verify_chown_persisted_on_puma] action nothing (skipped due to action :nothing)
* link[/var/log/gitlab/puma/config] action create (up to date)
* template[/opt/gitlab/sv/puma/log/run] action create (up to date)
* directory[/opt/gitlab/sv/puma/env] action create (up to date)
* ruby_block[Delete unmanaged env files for puma service] action run (skipped due to only_if)
* template[/opt/gitlab/sv/puma/check] action create (skipped due to only_if)
* template[/opt/gitlab/sv/puma/finish] action create (skipped due to only_if)
* directory[/opt/gitlab/sv/puma/control] action create (up to date)
* template[/opt/gitlab/sv/puma/control/t] action create (up to date)
* template[/opt/gitlab/sv/puma/control/h] action create (up to date)
* link[/opt/gitlab/init/puma] action create (up to date)
* file[/opt/gitlab/sv/puma/down] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/service] action create (up to date)
* link[/opt/gitlab/service/puma] action create (up to date)
* ruby_block[wait for puma service socket] action run (skipped due to not_if)
(up to date)
* consul_service[rails] action delete
* file[/var/opt/gitlab/consul/config.d/rails-service.json] action delete (up to date)
(up to date)
* gitlab_sysctl[net.core.somaxconn] action create
* directory[create /etc/sysctl.d for net.core.somaxconn] action create (up to date)
* file[create /opt/gitlab/embedded/etc/90-omnibus-gitlab-net.core.somaxconn.conf net.core.somaxconn] action create (up to date)
* link[/etc/sysctl.d/90-omnibus-gitlab-net.core.somaxconn.conf] action create (up to date)
* execute[load sysctl conf net.core.somaxconn] action nothing (skipped due to action :nothing)
(up to date)
Recipe: gitlab::sidekiq-cluster
* sidekiq_service[sidekiq] action enable
* directory[/var/log/gitlab/sidekiq] action create (up to date)
Recipe: <Dynamically Defined Resource>
* service[sidekiq] action nothing (skipped due to action :nothing)
* runit_service[sidekiq] action enable
* ruby_block[restart_service] action nothing (skipped due to action :nothing)
* ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
* ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/sv/sidekiq] action create (up to date)
* template[/opt/gitlab/sv/sidekiq/run] action create (up to date)
* directory[/opt/gitlab/sv/sidekiq/log] action create (up to date)
* directory[/opt/gitlab/sv/sidekiq/log/main] action create (up to date)
* template[/opt/gitlab/sv/sidekiq/log/config] action create (up to date)
* ruby_block[verify_chown_persisted_on_sidekiq] action nothing (skipped due to action :nothing)
* link[/var/log/gitlab/sidekiq/config] action create (up to date)
* template[/opt/gitlab/sv/sidekiq/log/run] action create (up to date)
* directory[/opt/gitlab/sv/sidekiq/env] action create (up to date)
* ruby_block[Delete unmanaged env files for sidekiq service] action run (skipped due to only_if)
* template[/opt/gitlab/sv/sidekiq/check] action create (skipped due to only_if)
* template[/opt/gitlab/sv/sidekiq/finish] action create (skipped due to only_if)
* directory[/opt/gitlab/sv/sidekiq/control] action create (up to date)
* link[/opt/gitlab/init/sidekiq] action create (up to date)
* file[/opt/gitlab/sv/sidekiq/down] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/service] action create (up to date)
* link[/opt/gitlab/service/sidekiq] action create (up to date)
* ruby_block[wait for sidekiq service socket] action run (skipped due to not_if)
(up to date)
(up to date)
Recipe: gitlab::sidekiq-cluster
* consul_service[sidekiq] action delete
* file[/var/opt/gitlab/consul/config.d/sidekiq-service.json] action delete (up to date)
(up to date)
* service[sidekiq-cluster] action nothing (skipped due to action :nothing)
* runit_service[sidekiq-cluster] action disable
* ruby_block[disable sidekiq-cluster] action run (skipped due to only_if)
(up to date)
Recipe: gitlab::gitlab-workhorse
* directory[/var/opt/gitlab/gitlab-workhorse] action create (up to date)
* directory[/var/opt/gitlab/gitlab-workhorse/sockets] action create (up to date)
* directory[/var/log/gitlab/gitlab-workhorse] action create (up to date)
* directory[/opt/gitlab/etc/gitlab-workhorse] action create (up to date)
* env_dir[/opt/gitlab/etc/gitlab-workhorse/env] action create
* directory[/opt/gitlab/etc/gitlab-workhorse/env] action create (up to date)
* file[/opt/gitlab/etc/gitlab-workhorse/env/PATH] action create (up to date)
* file[/opt/gitlab/etc/gitlab-workhorse/env/HOME] action create (up to date)
* file[/opt/gitlab/etc/gitlab-workhorse/env/SSL_CERT_DIR] action create (up to date)
(up to date)
* service[gitlab-workhorse] action nothing (skipped due to action :nothing)
* runit_service[gitlab-workhorse] action enable
* ruby_block[restart_service] action nothing (skipped due to action :nothing)
* ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
* ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/sv/gitlab-workhorse] action create (up to date)
* template[/opt/gitlab/sv/gitlab-workhorse/run] action create (up to date)
* directory[/opt/gitlab/sv/gitlab-workhorse/log] action create (up to date)
* directory[/opt/gitlab/sv/gitlab-workhorse/log/main] action create (up to date)
* template[/opt/gitlab/sv/gitlab-workhorse/log/config] action create (up to date)
* ruby_block[verify_chown_persisted_on_gitlab-workhorse] action nothing (skipped due to action :nothing)
* link[/var/log/gitlab/gitlab-workhorse/config] action create (up to date)
* template[/opt/gitlab/sv/gitlab-workhorse/log/run] action create (up to date)
* directory[/opt/gitlab/sv/gitlab-workhorse/env] action create (up to date)
* ruby_block[Delete unmanaged env files for gitlab-workhorse service] action run (skipped due to only_if)
* template[/opt/gitlab/sv/gitlab-workhorse/check] action create (skipped due to only_if)
* template[/opt/gitlab/sv/gitlab-workhorse/finish] action create (skipped due to only_if)
* directory[/opt/gitlab/sv/gitlab-workhorse/control] action create (up to date)
* link[/opt/gitlab/init/gitlab-workhorse] action create (up to date)
* file[/opt/gitlab/sv/gitlab-workhorse/down] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/service] action create (up to date)
* link[/opt/gitlab/service/gitlab-workhorse] action create (up to date)
* ruby_block[wait for gitlab-workhorse service socket] action run (skipped due to not_if)
(up to date)
* consul_service[workhorse] action delete
* file[/var/opt/gitlab/consul/config.d/workhorse-service.json] action delete (up to date)
(up to date)
* version_file[Create version file for Workhorse] action create
* file[/var/opt/gitlab/gitlab-workhorse/VERSION] action create
- update content in file /var/opt/gitlab/gitlab-workhorse/VERSION from c4687a to 4102cb
--- /var/opt/gitlab/gitlab-workhorse/VERSION 2020-11-08 17:51:58.510849289 +0100
+++ /var/opt/gitlab/gitlab-workhorse/.chef-VERSION20201126-15996-1eo3st5 2020-11-26 11:54:07.830626723 +0100
@@ -1 +1 @@
-gitlab-workhorse v8.51.0-20201103.222745
+gitlab-workhorse v8.54.0-20201119.094428
* template[/var/opt/gitlab/gitlab-workhorse/config.toml] action create
- update content in file /var/opt/gitlab/gitlab-workhorse/config.toml from 90963c to 402ba0
--- /var/opt/gitlab/gitlab-workhorse/config.toml 2020-08-10 17:10:08.029568369 +0200
+++ /var/opt/gitlab/gitlab-workhorse/.chef-config20201126-15996-1uhpb3j.toml 2020-11-26 11:54:07.858626580 +0100
@@ -2,4 +2,8 @@
URL = "unix:/var/opt/gitlab/redis/redis.socket"
Password = ""
+
+[image_resizer]
+ max_scaler_procs = 2
+ max_filesize = 250000
Recipe: gitlab::mailroom_disable
* service[mailroom] action nothing (skipped due to action :nothing)
* runit_service[mailroom] action disable
* ruby_block[disable mailroom] action run (skipped due to only_if)
(up to date)
Recipe: gitlab::nginx
* directory[/var/opt/gitlab/nginx] action create (up to date)
* directory[/var/opt/gitlab/nginx/conf] action create (up to date)
* directory[/var/log/gitlab/nginx] action create (up to date)
* link[/var/opt/gitlab/nginx/logs] action create (up to date)
* template[/var/opt/gitlab/nginx/conf/gitlab-http.conf] action create (up to date)
* template[/var/opt/gitlab/nginx/conf/gitlab-smartcard-http.conf] action delete (up to date)
* template[/var/opt/gitlab/nginx/conf/gitlab-health.conf] action create (up to date)
* template[/var/opt/gitlab/nginx/conf/gitlab-pages.conf] action delete (up to date)
* template[/var/opt/gitlab/nginx/conf/gitlab-registry.conf] action create (up to date)
* template[/var/opt/gitlab/nginx/conf/gitlab-mattermost-http.conf] action delete (up to date)
* template[/var/opt/gitlab/nginx/conf/nginx-status.conf] action create (up to date)
* consul_service[nginx] action delete
* file[/var/opt/gitlab/consul/config.d/nginx-service.json] action delete (up to date)
(up to date)
* template[/var/opt/gitlab/nginx/conf/nginx.conf] action create (up to date)
Recipe: nginx::enable
* service[nginx] action nothing (skipped due to action :nothing)
* runit_service[nginx] action enable
* ruby_block[restart_service] action nothing (skipped due to action :nothing)
* ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
* ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/sv/nginx] action create (up to date)
* template[/opt/gitlab/sv/nginx/run] action create (up to date)
* directory[/opt/gitlab/sv/nginx/log] action create (up to date)
* directory[/opt/gitlab/sv/nginx/log/main] action create (up to date)
* template[/opt/gitlab/sv/nginx/log/config] action create (up to date)
* ruby_block[verify_chown_persisted_on_nginx] action nothing (skipped due to action :nothing)
* link[/var/log/gitlab/nginx/config] action create (up to date)
* template[/opt/gitlab/sv/nginx/log/run] action create (up to date)
* directory[/opt/gitlab/sv/nginx/env] action create (up to date)
* ruby_block[Delete unmanaged env files for nginx service] action run (skipped due to only_if)
* template[/opt/gitlab/sv/nginx/check] action create (skipped due to only_if)
* template[/opt/gitlab/sv/nginx/finish] action create (skipped due to only_if)
* directory[/opt/gitlab/sv/nginx/control] action create (up to date)
* link[/opt/gitlab/init/nginx] action create (up to date)
* file[/opt/gitlab/sv/nginx/down] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/service] action create (up to date)
* link[/opt/gitlab/service/nginx] action create (up to date)
* ruby_block[wait for nginx service socket] action run (skipped due to not_if)
(up to date)
* execute[reload nginx] action nothing (skipped due to action :nothing)
Recipe: gitlab::remote-syslog_disable
* service[remote-syslog] action nothing (skipped due to action :nothing)
* runit_service[remote-syslog] action disable
* ruby_block[disable remote-syslog] action run (skipped due to only_if)
(up to date)
Recipe: gitlab::gitlab-pages_disable
* service[gitlab-pages] action nothing (skipped due to action :nothing)
* runit_service[gitlab-pages] action disable
* ruby_block[disable gitlab-pages] action run (skipped due to only_if)
(up to date)
Recipe: gitlab::storage-check_disable
* service[storage-check] action nothing (skipped due to action :nothing)
* runit_service[storage-check] action disable
* ruby_block[disable storage-check] action run (skipped due to only_if)
(up to date)
Recipe: gitlab::actioncable_disable
* service[actioncable] action nothing (skipped due to action :nothing)
* runit_service[actioncable] action disable
* ruby_block[disable actioncable] action run (skipped due to only_if)
(up to date)
* consul_service[actioncable] action delete
* file[/var/opt/gitlab/consul/config.d/actioncable-service.json] action delete (up to date)
(up to date)
Recipe: logrotate::enable
* service[logrotate] action nothing (skipped due to action :nothing)
* runit_service[logrotate] action enable
* ruby_block[restart_service] action nothing (skipped due to action :nothing)
* ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
* ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/sv/logrotate] action create (up to date)
* template[/opt/gitlab/sv/logrotate/run] action create (up to date)
* directory[/opt/gitlab/sv/logrotate/log] action create (up to date)
* directory[/opt/gitlab/sv/logrotate/log/main] action create (up to date)
* template[/opt/gitlab/sv/logrotate/log/config] action create (up to date)
* ruby_block[verify_chown_persisted_on_logrotate] action nothing (skipped due to action :nothing)
* link[/var/log/gitlab/logrotate/config] action create (up to date)
* template[/opt/gitlab/sv/logrotate/log/run] action create (up to date)
* directory[/opt/gitlab/sv/logrotate/env] action create (up to date)
* ruby_block[Delete unmanaged env files for logrotate service] action run (skipped due to only_if)
* template[/opt/gitlab/sv/logrotate/check] action create (skipped due to only_if)
* template[/opt/gitlab/sv/logrotate/finish] action create (skipped due to only_if)
* directory[/opt/gitlab/sv/logrotate/control] action create (up to date)
* template[/opt/gitlab/sv/logrotate/control/t] action create (up to date)
* link[/opt/gitlab/init/logrotate] action create (up to date)
* file[/opt/gitlab/sv/logrotate/down] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/service] action create (up to date)
* link[/opt/gitlab/service/logrotate] action create (up to date)
* ruby_block[wait for logrotate service socket] action run (skipped due to not_if)
(up to date)
Recipe: registry::enable
* directory[create /var/opt/gitlab/registry] action create (up to date)
* account[Docker registry user and group] action create
* group[Docker registry user and group] action create (up to date)
* linux_user[Docker registry user and group] action create (up to date)
(up to date)
* directory[create /var/opt/gitlab/registry and set the owner] action create (up to date)
* directory[create /var/log/gitlab/registry and set the owner] action create (up to date)
* env_dir[/opt/gitlab/etc/registry/env] action create
* directory[/opt/gitlab/etc/registry/env] action create (up to date)
* file[/opt/gitlab/etc/registry/env/SSL_CERT_DIR] action create (up to date)
(up to date)
* directory[/var/opt/gitlab/gitlab-rails/shared/registry] action create (up to date)
* file[/var/opt/gitlab/registry/gitlab-registry.crt] action create (up to date)
* template[/var/opt/gitlab/registry/config.yml] action create (up to date)
* service[registry] action nothing (skipped due to action :nothing)
* runit_service[registry] action enable
* ruby_block[restart_service] action nothing (skipped due to action :nothing)
* ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
* ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/sv/registry] action create (up to date)
* template[/opt/gitlab/sv/registry/run] action create (up to date)
* directory[/opt/gitlab/sv/registry/log] action create (up to date)
* directory[/opt/gitlab/sv/registry/log/main] action create (up to date)
* template[/opt/gitlab/sv/registry/log/config] action create (up to date)
* ruby_block[verify_chown_persisted_on_registry] action nothing (skipped due to action :nothing)
* link[/var/log/gitlab/registry/config] action create (up to date)
* template[/opt/gitlab/sv/registry/log/run] action create (up to date)
* directory[/opt/gitlab/sv/registry/env] action create (up to date)
* ruby_block[Delete unmanaged env files for registry service] action run (skipped due to only_if)
* template[/opt/gitlab/sv/registry/check] action create (skipped due to only_if)
* template[/opt/gitlab/sv/registry/finish] action create (skipped due to only_if)
* directory[/opt/gitlab/sv/registry/control] action create (up to date)
* link[/opt/gitlab/init/registry] action create (up to date)
* file[/opt/gitlab/sv/registry/down] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/service] action create (up to date)
* link[/opt/gitlab/service/registry] action create (up to date)
* ruby_block[wait for registry service socket] action run (skipped due to not_if)
(up to date)
* version_file[Create version file for Registry] action create
* file[/var/opt/gitlab/registry/VERSION] action create
- update content in file /var/opt/gitlab/registry/VERSION from acf493 to 02e546
--- /var/opt/gitlab/registry/VERSION 2020-08-25 11:44:23.441394072 +0200
+++ /var/opt/gitlab/registry/.chef-VERSION20201126-15996-skm9sk 2020-11-26 11:54:08.686622423 +0100
@@ -1 +1 @@
-/opt/gitlab/embedded/bin/registry github.com/docker/distribution v2.10.1-gitlab
+/opt/gitlab/embedded/bin/registry github.com/docker/distribution v2.11.0-gitlab
Recipe: mattermost::disable
* service[mattermost] action nothing (skipped due to action :nothing)
* runit_service[mattermost] action disable
* ruby_block[disable mattermost] action run (skipped due to only_if)
(up to date)
Recipe: gitlab::gitlab-healthcheck
* template[/opt/gitlab/etc/gitlab-healthcheck-rc] action create (up to date)
Recipe: monitoring::user
* account[Prometheus user and group] action create
* group[Prometheus user and group] action create (up to date)
* linux_user[Prometheus user and group] action create (up to date)
(up to date)
Recipe: monitoring::node-exporter
* directory[/var/log/gitlab/node-exporter] action create (up to date)
* directory[/opt/gitlab/etc/node-exporter/env] action create (up to date)
* env_dir[/opt/gitlab/etc/node-exporter/env] action create
* directory[/opt/gitlab/etc/node-exporter/env] action create (up to date)
* file[/opt/gitlab/etc/node-exporter/env/SSL_CERT_DIR] action create (up to date)
(up to date)
* directory[/var/opt/gitlab/node-exporter/textfile_collector] action create (up to date)
* service[node-exporter] action nothing (skipped due to action :nothing)
* runit_service[node-exporter] action enable
* ruby_block[restart_service] action nothing (skipped due to action :nothing)
* ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
* ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/sv/node-exporter] action create (up to date)
* template[/opt/gitlab/sv/node-exporter/run] action create (up to date)
* directory[/opt/gitlab/sv/node-exporter/log] action create (up to date)
* directory[/opt/gitlab/sv/node-exporter/log/main] action create (up to date)
* template[/opt/gitlab/sv/node-exporter/log/config] action create (up to date)
* ruby_block[verify_chown_persisted_on_node-exporter] action nothing (skipped due to action :nothing)
* link[/var/log/gitlab/node-exporter/config] action create (up to date)
* template[/opt/gitlab/sv/node-exporter/log/run] action create (up to date)
* directory[/opt/gitlab/sv/node-exporter/env] action create (up to date)
* ruby_block[Delete unmanaged env files for node-exporter service] action run (skipped due to only_if)
* template[/opt/gitlab/sv/node-exporter/check] action create (skipped due to only_if)
* template[/opt/gitlab/sv/node-exporter/finish] action create (skipped due to only_if)
* directory[/opt/gitlab/sv/node-exporter/control] action create (up to date)
* link[/opt/gitlab/init/node-exporter] action create (up to date)
* file[/opt/gitlab/sv/node-exporter/down] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/service] action create (up to date)
* link[/opt/gitlab/service/node-exporter] action create (up to date)
* ruby_block[wait for node-exporter service socket] action run (skipped due to not_if)
(up to date)
* consul_service[node-exporter] action delete
* file[/var/opt/gitlab/consul/config.d/node-exporter-service.json] action delete (up to date)
(up to date)
Recipe: monitoring::gitlab-exporter
* directory[/var/opt/gitlab/gitlab-exporter] action create (up to date)
* directory[/var/log/gitlab/gitlab-exporter] action create (up to date)
* template[/var/opt/gitlab/gitlab-exporter/gitlab-exporter.yml] action create (up to date)
* version_file[Create version file for GitLab-Exporter] action create
* file[/var/opt/gitlab/gitlab-exporter/RUBY_VERSION] action create
- update content in file /var/opt/gitlab/gitlab-exporter/RUBY_VERSION from d89bae to 22dcc2
--- /var/opt/gitlab/gitlab-exporter/RUBY_VERSION 2020-06-07 11:35:14.285127697 +0200
+++ /var/opt/gitlab/gitlab-exporter/.chef-RUBY_VERSION20201126-15996-1lnzcwg 2020-11-26 11:54:08.990620902 +0100
@@ -1 +1 @@
-ruby 2.6.6p146 (2020-03-31 revision 67876) [x86_64-linux]
+ruby 2.7.2p137 (2020-10-01 revision 5445e04352) [x86_64-linux]
* service[gitlab-exporter] action nothing (skipped due to action :nothing)
* runit_service[gitlab-exporter] action enable
* ruby_block[restart_service] action nothing (skipped due to action :nothing)
* ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
* ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/sv/gitlab-exporter] action create (up to date)
* template[/opt/gitlab/sv/gitlab-exporter/run] action create (up to date)
* directory[/opt/gitlab/sv/gitlab-exporter/log] action create (up to date)
* directory[/opt/gitlab/sv/gitlab-exporter/log/main] action create (up to date)
* template[/opt/gitlab/sv/gitlab-exporter/log/config] action create (up to date)
* ruby_block[verify_chown_persisted_on_gitlab-exporter] action nothing (skipped due to action :nothing)
* link[/var/log/gitlab/gitlab-exporter/config] action create (up to date)
* template[/opt/gitlab/sv/gitlab-exporter/log/run] action create (up to date)
* directory[/opt/gitlab/sv/gitlab-exporter/env] action create (up to date)
* ruby_block[Delete unmanaged env files for gitlab-exporter service] action run (skipped due to only_if)
* template[/opt/gitlab/sv/gitlab-exporter/check] action create (skipped due to only_if)
* template[/opt/gitlab/sv/gitlab-exporter/finish] action create (skipped due to only_if)
* directory[/opt/gitlab/sv/gitlab-exporter/control] action create (up to date)
* link[/opt/gitlab/init/gitlab-exporter] action create (up to date)
* file[/opt/gitlab/sv/gitlab-exporter/down] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/service] action create (up to date)
* link[/opt/gitlab/service/gitlab-exporter] action create (up to date)
* ruby_block[wait for gitlab-exporter service socket] action run (skipped due to not_if)
(up to date)
Recipe: monitoring::redis-exporter
* directory[/var/log/gitlab/redis-exporter] action create (up to date)
* directory[/opt/gitlab/etc/redis-exporter/env] action create (up to date)
* env_dir[/opt/gitlab/etc/redis-exporter/env] action create
* directory[/opt/gitlab/etc/redis-exporter/env] action create (up to date)
* file[/opt/gitlab/etc/redis-exporter/env/SSL_CERT_DIR] action create (up to date)
(up to date)
* service[redis-exporter] action nothing (skipped due to action :nothing)
* runit_service[redis-exporter] action enable
* ruby_block[restart_service] action nothing (skipped due to action :nothing)
* ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
* ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/sv/redis-exporter] action create (up to date)
* template[/opt/gitlab/sv/redis-exporter/run] action create (up to date)
* directory[/opt/gitlab/sv/redis-exporter/log] action create (up to date)
* directory[/opt/gitlab/sv/redis-exporter/log/main] action create (up to date)
* template[/opt/gitlab/sv/redis-exporter/log/config] action create (up to date)
* ruby_block[verify_chown_persisted_on_redis-exporter] action nothing (skipped due to action :nothing)
* link[/var/log/gitlab/redis-exporter/config] action create (up to date)
* template[/opt/gitlab/sv/redis-exporter/log/run] action create (up to date)
* directory[/opt/gitlab/sv/redis-exporter/env] action create (up to date)
* ruby_block[Delete unmanaged env files for redis-exporter service] action run (skipped due to only_if)
* template[/opt/gitlab/sv/redis-exporter/check] action create (skipped due to only_if)
* template[/opt/gitlab/sv/redis-exporter/finish] action create (skipped due to only_if)
* directory[/opt/gitlab/sv/redis-exporter/control] action create (up to date)
* link[/opt/gitlab/init/redis-exporter] action create (up to date)
* file[/opt/gitlab/sv/redis-exporter/down] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/service] action create (up to date)
* link[/opt/gitlab/service/redis-exporter] action create (up to date)
* ruby_block[wait for redis-exporter service socket] action run (skipped due to not_if)
(up to date)
* consul_service[redis-exporter] action delete
* file[/var/opt/gitlab/consul/config.d/redis-exporter-service.json] action delete (up to date)
(up to date)
Recipe: monitoring::prometheus
* directory[/var/opt/gitlab/prometheus] action create (up to date)
* directory[/var/opt/gitlab/prometheus/rules] action create (up to date)
* directory[/var/log/gitlab/prometheus] action create (up to date)
* directory[/opt/gitlab/etc/prometheus/env] action create (up to date)
* env_dir[/opt/gitlab/etc/prometheus/env] action create
* directory[/opt/gitlab/etc/prometheus/env] action create (up to date)
* file[/opt/gitlab/etc/prometheus/env/SSL_CERT_DIR] action create (up to date)
(up to date)
* execute[reload prometheus] action nothing (skipped due to action :nothing)
* file[Prometheus config] action create (up to date)
* service[prometheus] action nothing (skipped due to action :nothing)
* runit_service[prometheus] action enable
* ruby_block[restart_service] action nothing (skipped due to action :nothing)
* ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
* ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/sv/prometheus] action create (up to date)
* template[/opt/gitlab/sv/prometheus/run] action create (up to date)
* directory[/opt/gitlab/sv/prometheus/log] action create (up to date)
* directory[/opt/gitlab/sv/prometheus/log/main] action create (up to date)
* template[/opt/gitlab/sv/prometheus/log/config] action create (up to date)
* ruby_block[verify_chown_persisted_on_prometheus] action nothing (skipped due to action :nothing)
* link[/var/log/gitlab/prometheus/config] action create (up to date)
* template[/opt/gitlab/sv/prometheus/log/run] action create (up to date)
* directory[/opt/gitlab/sv/prometheus/env] action create (up to date)
* ruby_block[Delete unmanaged env files for prometheus service] action run (skipped due to only_if)
* template[/opt/gitlab/sv/prometheus/check] action create (skipped due to only_if)
* template[/opt/gitlab/sv/prometheus/finish] action create (skipped due to only_if)
* directory[/opt/gitlab/sv/prometheus/control] action create (up to date)
* link[/opt/gitlab/init/prometheus] action create (up to date)
* file[/opt/gitlab/sv/prometheus/down] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/service] action create (up to date)
* link[/opt/gitlab/service/prometheus] action create (up to date)
* ruby_block[wait for prometheus service socket] action run (skipped due to not_if)
(up to date)
* consul_service[prometheus] action delete
* file[/var/opt/gitlab/consul/config.d/prometheus-service.json] action delete (up to date)
(up to date)
* template[/var/opt/gitlab/prometheus/rules/gitlab.rules] action create (up to date)
* template[/var/opt/gitlab/prometheus/rules/node.rules] action create (up to date)
Recipe: monitoring::alertmanager
* directory[/var/opt/gitlab/alertmanager] action create (up to date)
* directory[/var/log/gitlab/alertmanager] action create (up to date)
* directory[/opt/gitlab/etc/alertmanager/env] action create (up to date)
* env_dir[/opt/gitlab/etc/alertmanager/env] action create
* directory[/opt/gitlab/etc/alertmanager/env] action create (up to date)
* file[/opt/gitlab/etc/alertmanager/env/SSL_CERT_DIR] action create (up to date)
(up to date)
* file[Alertmanager config] action create (up to date)
* service[alertmanager] action nothing (skipped due to action :nothing)
* runit_service[alertmanager] action enable
* ruby_block[restart_service] action nothing (skipped due to action :nothing)
* ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
* ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/sv/alertmanager] action create (up to date)
* template[/opt/gitlab/sv/alertmanager/run] action create (up to date)
* directory[/opt/gitlab/sv/alertmanager/log] action create (up to date)
* directory[/opt/gitlab/sv/alertmanager/log/main] action create (up to date)
* template[/opt/gitlab/sv/alertmanager/log/config] action create (up to date)
* ruby_block[verify_chown_persisted_on_alertmanager] action nothing (skipped due to action :nothing)
* link[/var/log/gitlab/alertmanager/config] action create (up to date)
* template[/opt/gitlab/sv/alertmanager/log/run] action create (up to date)
* directory[/opt/gitlab/sv/alertmanager/env] action create (up to date)
* ruby_block[Delete unmanaged env files for alertmanager service] action run (skipped due to only_if)
* template[/opt/gitlab/sv/alertmanager/check] action create (skipped due to only_if)
* template[/opt/gitlab/sv/alertmanager/finish] action create (skipped due to only_if)
* directory[/opt/gitlab/sv/alertmanager/control] action create (up to date)
* link[/opt/gitlab/init/alertmanager] action create (up to date)
* file[/opt/gitlab/sv/alertmanager/down] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/service] action create (up to date)
* link[/opt/gitlab/service/alertmanager] action create (up to date)
* ruby_block[wait for alertmanager service socket] action run (skipped due to not_if)
(up to date)
Recipe: monitoring::postgres-exporter
* directory[/var/log/gitlab/postgres-exporter] action create (up to date)
* directory[/var/opt/gitlab/postgres-exporter] action create (up to date)
* env_dir[/opt/gitlab/etc/postgres-exporter/env] action create
* directory[/opt/gitlab/etc/postgres-exporter/env] action create (up to date)
* file[/opt/gitlab/etc/postgres-exporter/env/SSL_CERT_DIR] action create (up to date)
* file[/opt/gitlab/etc/postgres-exporter/env/DATA_SOURCE_NAME] action create (up to date)
(up to date)
* service[postgres-exporter] action nothing (skipped due to action :nothing)
* runit_service[postgres-exporter] action enable
* ruby_block[restart_service] action nothing (skipped due to action :nothing)
* ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
* ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/sv/postgres-exporter] action create (up to date)
* template[/opt/gitlab/sv/postgres-exporter/run] action create (up to date)
* directory[/opt/gitlab/sv/postgres-exporter/log] action create (up to date)
* directory[/opt/gitlab/sv/postgres-exporter/log/main] action create (up to date)
* template[/opt/gitlab/sv/postgres-exporter/log/config] action create (up to date)
* ruby_block[verify_chown_persisted_on_postgres-exporter] action nothing (skipped due to action :nothing)
* link[/var/log/gitlab/postgres-exporter/config] action create (up to date)
* template[/opt/gitlab/sv/postgres-exporter/log/run] action create (up to date)
* directory[/opt/gitlab/sv/postgres-exporter/env] action create (up to date)
* ruby_block[Delete unmanaged env files for postgres-exporter service] action run (skipped due to only_if)
* template[/opt/gitlab/sv/postgres-exporter/check] action create (skipped due to only_if)
* template[/opt/gitlab/sv/postgres-exporter/finish] action create (skipped due to only_if)
* directory[/opt/gitlab/sv/postgres-exporter/control] action create (up to date)
* link[/opt/gitlab/init/postgres-exporter] action create (up to date)
* file[/opt/gitlab/sv/postgres-exporter/down] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/service] action create (up to date)
* link[/opt/gitlab/service/postgres-exporter] action create (up to date)
* ruby_block[wait for postgres-exporter service socket] action run (skipped due to not_if)
(up to date)
* template[/var/opt/gitlab/postgres-exporter/queries.yaml] action create
- update content in file /var/opt/gitlab/postgres-exporter/queries.yaml from 4c23c0 to bb807f
--- /var/opt/gitlab/postgres-exporter/queries.yaml 2020-04-22 19:00:20.421233125 +0200
+++ /var/opt/gitlab/postgres-exporter/.chef-queries20201126-15996-jfv86y.yaml 2020-11-26 11:54:09.858616560 +0100
@@ -15,76 +15,6 @@
usage: "GAUGE"
description: "Time at which postmaster started"
-pg_stat_user_tables:
- query: "SELECT current_database() datname, schemaname, relname, seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, n_mod_since_analyze, COALESCE(last_vacuum, '1970-01-01Z'), COALESCE(last_vacuum, '1970-01-01Z') as last_vacuum, COALESCE(last_autovacuum, '1970-01-01Z') as last_autovacuum, COALESCE(last_analyze, '1970-01-01Z') as last_analyze, COALESCE(last_autoanalyze, '1970-01-01Z') as last_autoanalyze, vacuum_count, autovacuum_count, analyze_count, autoanalyze_count FROM pg_stat_user_tables"
- metrics:
- - datname:
- usage: "LABEL"
- description: "Name of current database"
- - schemaname:
- usage: "LABEL"
- description: "Name of the schema that this table is in"
- - relname:
- usage: "LABEL"
- description: "Name of this table"
- - seq_scan:
- usage: "COUNTER"
- description: "Number of sequential scans initiated on this table"
- - seq_tup_read:
- usage: "COUNTER"
- description: "Number of live rows fetched by sequential scans"
- - idx_scan:
- usage: "COUNTER"
- description: "Number of index scans initiated on this table"
- - idx_tup_fetch:
- usage: "COUNTER"
- description: "Number of live rows fetched by index scans"
- - n_tup_ins:
- usage: "COUNTER"
- description: "Number of rows inserted"
- - n_tup_upd:
- usage: "COUNTER"
- description: "Number of rows updated"
- - n_tup_del:
- usage: "COUNTER"
- description: "Number of rows deleted"
- - n_tup_hot_upd:
- usage: "COUNTER"
- description: "Number of rows HOT updated (i.e., with no separate index update required)"
- - n_live_tup:
- usage: "GAUGE"
- description: "Estimated number of live rows"
- - n_dead_tup:
- usage: "GAUGE"
- description: "Estimated number of dead rows"
- - n_mod_since_analyze:
- usage: "GAUGE"
- description: "Estimated number of rows changed since last analyze"
- - last_vacuum:
- usage: "GAUGE"
- description: "Last time at which this table was manually vacuumed (not counting VACUUM FULL)"
- - last_autovacuum:
- usage: "GAUGE"
- description: "Last time at which this table was vacuumed by the autovacuum daemon"
- - last_analyze:
- usage: "GAUGE"
- description: "Last time at which this table was manually analyzed"
- - last_autoanalyze:
- usage: "GAUGE"
- description: "Last time at which this table was analyzed by the autovacuum daemon"
- - vacuum_count:
- usage: "COUNTER"
- description: "Number of times this table has been manually vacuumed (not counting VACUUM FULL)"
- - autovacuum_count:
- usage: "COUNTER"
- description: "Number of times this table has been vacuumed by the autovacuum daemon"
- - analyze_count:
- usage: "COUNTER"
- description: "Number of times this table has been manually analyzed"
- - autoanalyze_count:
- usage: "COUNTER"
- description: "Number of times this table has been analyzed by the autovacuum daemon"
-
pg_total_relation_size:
query: |
SELECT relnamespace::regnamespace as schemaname,
* consul_service[postgres-exporter] action delete
* file[/var/opt/gitlab/consul/config.d/postgres-exporter-service.json] action delete (up to date)
(up to date)
Recipe: monitoring::grafana
* directory[/var/log/gitlab/grafana] action create (up to date)
* directory[/var/opt/gitlab/grafana] action create (up to date)
* directory[/var/opt/gitlab/grafana/provisioning] action create (up to date)
* directory[/var/opt/gitlab/grafana/provisioning/dashboards] action create (up to date)
* directory[/var/opt/gitlab/grafana/provisioning/datasources] action create (up to date)
* directory[/var/opt/gitlab/grafana/provisioning/notifiers] action create (up to date)
* file[/var/opt/gitlab/grafana/CVE_reset_status] action delete (up to date)
* link[/var/opt/gitlab/grafana/conf] action create (up to date)
* link[/var/opt/gitlab/grafana/public] action create (up to date)
* directory[/opt/gitlab/etc/grafana/env] action create (up to date)
* ruby_block[populate Grafana configuration options] action run
- execute the ruby block populate Grafana configuration options
* env_dir[/opt/gitlab/etc/grafana/env] action create
* directory[/opt/gitlab/etc/grafana/env] action create (up to date)
* file[/opt/gitlab/etc/grafana/env/SSL_CERT_DIR] action create (up to date)
(up to date)
* template[/var/opt/gitlab/grafana/grafana.ini] action create (up to date)
* file[/var/opt/gitlab/grafana/provisioning/dashboards/gitlab_dashboards.yml] action create (up to date)
* file[/var/opt/gitlab/grafana/provisioning/datasources/gitlab_datasources.yml] action create (up to date)
* service[grafana] action nothing (skipped due to action :nothing)
* runit_service[grafana] action enable
* ruby_block[restart_service] action nothing (skipped due to action :nothing)
* ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
* ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/sv/grafana] action create (up to date)
* template[/opt/gitlab/sv/grafana/run] action create (up to date)
* directory[/opt/gitlab/sv/grafana/log] action create (up to date)
* directory[/opt/gitlab/sv/grafana/log/main] action create (up to date)
* template[/opt/gitlab/sv/grafana/log/config] action create (up to date)
* ruby_block[verify_chown_persisted_on_grafana] action nothing (skipped due to action :nothing)
* link[/var/log/gitlab/grafana/config] action create (up to date)
* template[/opt/gitlab/sv/grafana/log/run] action create (up to date)
* directory[/opt/gitlab/sv/grafana/env] action create (up to date)
* ruby_block[Delete unmanaged env files for grafana service] action run (skipped due to only_if)
* template[/opt/gitlab/sv/grafana/check] action create (skipped due to only_if)
* template[/opt/gitlab/sv/grafana/finish] action create (skipped due to only_if)
* directory[/opt/gitlab/sv/grafana/control] action create (up to date)
* link[/opt/gitlab/init/grafana] action create (up to date)
* file[/opt/gitlab/sv/grafana/down] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/service] action create (up to date)
* link[/opt/gitlab/service/grafana] action create (up to date)
* ruby_block[wait for grafana service socket] action run (skipped due to not_if)
(up to date)
Recipe: letsencrypt::enable
* ruby_block[http external-url] action run (skipped due to only_if)
* directory[/etc/gitlab/ssl] action create (up to date)
* acme_selfsigned[mysubdomain.mydomain.com] action create
* file[mysubdomain.mydomain.com SSL selfsigned key] action create_if_missing (up to date)
* file[mysubdomain.mydomain.com SSL selfsigned crt] action create_if_missing (up to date)
* file[mysubdomain.mydomain.com SSL selfsigned chain] action create_if_missing (skipped due to not_if)
(up to date)
Recipe: letsencrypt::http_authorization
* letsencrypt_certificate[mysubdomain.mydomain.com] action create (skipped due to only_if)
Recipe: crond::enable
* directory[/var/log/gitlab/crond] action create (up to date)
* directory[/var/opt/gitlab/crond] action create (up to date)
* service[crond] action nothing (skipped due to action :nothing)
* runit_service[crond] action enable
* ruby_block[restart_service] action nothing (skipped due to action :nothing)
* ruby_block[restart_log_service] action nothing (skipped due to action :nothing)
* ruby_block[reload_log_service] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/sv/crond] action create (up to date)
* template[/opt/gitlab/sv/crond/run] action create (up to date)
* directory[/opt/gitlab/sv/crond/log] action create (up to date)
* directory[/opt/gitlab/sv/crond/log/main] action create (up to date)
* template[/opt/gitlab/sv/crond/log/config] action create (up to date)
* ruby_block[verify_chown_persisted_on_crond] action nothing (skipped due to action :nothing)
* link[/var/log/gitlab/crond/config] action create (up to date)
* template[/opt/gitlab/sv/crond/log/run] action create (up to date)
* directory[/opt/gitlab/sv/crond/env] action create (up to date)
* ruby_block[Delete unmanaged env files for crond service] action run (skipped due to only_if)
* template[/opt/gitlab/sv/crond/check] action create (skipped due to only_if)
* template[/opt/gitlab/sv/crond/finish] action create (skipped due to only_if)
* directory[/opt/gitlab/sv/crond/control] action create (up to date)
* link[/opt/gitlab/init/crond] action create (up to date)
* file[/opt/gitlab/sv/crond/down] action nothing (skipped due to action :nothing)
* directory[/opt/gitlab/service] action create (up to date)
* link[/opt/gitlab/service/crond] action create (up to date)
* ruby_block[wait for crond service socket] action run (skipped due to not_if)
(up to date)
Recipe: letsencrypt::enable
* crond_job[letsencrypt-renew] action create
* file[/var/opt/gitlab/crond/letsencrypt-renew] action create (up to date)
(up to date)
* ruby_block[display_le_message] action nothing (skipped due to action :nothing)
* ruby_block[save_auto_enabled] action run
- execute the ruby block save_auto_enabled
Recipe: gitlab::database_reindexing_disable
* crond_job[database-reindexing] action delete
* file[/var/opt/gitlab/crond/database-reindexing] action delete (up to date)
(up to date)
Recipe: gitlab-ee::sentinel_disable
* sentinel_service[redis] action disable
Recipe: <Dynamically Defined Resource>
* service[sentinel] action nothing (skipped due to action :nothing)
* runit_service[sentinel] action disable
* ruby_block[disable sentinel] action run (skipped due to only_if)
(up to date)
* file[/var/opt/gitlab/sentinel/sentinel.conf] action delete (up to date)
* directory[/var/opt/gitlab/sentinel] action delete (up to date)
(up to date)
Recipe: gitlab-ee::geo-postgresql_disable
* service[geo-postgresql] action nothing (skipped due to action :nothing)
* runit_service[geo-postgresql] action disable
* ruby_block[disable geo-postgresql] action run (skipped due to only_if)
(up to date)
Recipe: gitlab-ee::geo-logcursor_disable
* service[geo-logcursor] action nothing (skipped due to action :nothing)
* runit_service[geo-logcursor] action disable
* ruby_block[disable geo-logcursor] action run (skipped due to only_if)
(up to date)
Recipe: gitlab-ee::pgbouncer_disable
* service[pgbouncer] action nothing (skipped due to action :nothing)
* runit_service[pgbouncer] action disable
* ruby_block[disable pgbouncer] action run (skipped due to only_if)
(up to date)
Recipe: gitlab-ee::pgbouncer-exporter_disable
* service[pgbouncer-exporter] action nothing (skipped due to action :nothing)
* runit_service[pgbouncer-exporter] action disable
* ruby_block[disable pgbouncer-exporter] action run (skipped due to only_if)
(up to date)
Recipe: consul::disable_daemon
* service[consul] action nothing (skipped due to action :nothing)
* runit_service[consul] action disable
* ruby_block[disable consul] action run (skipped due to only_if)
(up to date)
Recipe: repmgr::repmgrd_disable
* service[repmgrd] action nothing (skipped due to action :nothing)
* runit_service[repmgrd] action disable
* ruby_block[disable repmgrd] action run (skipped due to only_if)
(up to date)
Recipe: patroni::disable
* service[patroni] action nothing (skipped due to action :nothing)
* runit_service[patroni] action disable
* ruby_block[disable patroni] action run (skipped due to only_if)
(up to date)
Recipe: gitlab-ee::geo-secondary_disable
* templatesymlink[Removes database_geo.yml symlink] action delete
* file[/var/opt/gitlab/gitlab-rails/etc/database_geo.yml] action delete (up to date)
* link[/opt/gitlab/embedded/service/gitlab-rails/config/database_geo.yml] action delete (up to date)
(up to date)
Recipe: gitlab::gitlab-rails
* execute[clear the gitlab-rails cache] action run
- execute /opt/gitlab/bin/gitlab-rake cache:clear
Recipe: gitaly::enable
* runit_service[gitaly] action hup
- send hup to runit_service[gitaly]
Recipe: gitlab::gitlab-workhorse
* runit_service[gitlab-workhorse] action restart (up to date)
Recipe: registry::enable
* runit_service[registry] action restart (up to date)
Recipe: monitoring::gitlab-exporter
* runit_service[gitlab-exporter] action restart (up to date)
Recipe: monitoring::postgres-exporter
* runit_service[postgres-exporter] action restart (up to date)
Running handlers:
Running handlers complete
Chef Infra Client finished, 44/890 resources updated in 01 minutes 41 seconds
Deprecations:
* sidekiq_cluster['experimental_queue_selector'] has been deprecated since 13.6 and will be removed in 14.0. The experimental_queue_selector option is now called queue_selector.
gitlab Reconfigured!
Restarting previously running GitLab services
ok: run: crond: (pid 16492) 0s
ok: run: gitaly: (pid 16475) 1s
ok: run: gitlab-exporter: (pid 16462) 1s
ok: run: gitlab-workhorse: (pid 16445) 2s
ok: run: grafana: (pid 16506) 1s
ok: run: logrotate: (pid 16515) 0s
ok: run: nginx: (pid 16521) 1s
ok: run: node-exporter: (pid 16527) 0s
ok: run: postgres-exporter: (pid 16484) 3s
ok: run: postgresql: (pid 1460) 674s
ok: run: prometheus: (pid 16534) 1s
ok: run: puma: (pid 16618) 0s
ok: run: redis: (pid 1465) 675s
ok: run: redis-exporter: (pid 16625) 0s
ok: run: registry: (pid 16455) 5s
ok: run: sidekiq: (pid 16633) 1s
_______ __ __ __
/ ____(_) /_/ / ____ _/ /_
/ / __/ / __/ / / __ `/ __ \
/ /_/ / / /_/ /___/ /_/ / /_/ /
\____/_/\__/_____/\__,_/_.___/
Upgrade complete! If your GitLab server is misbehaving try running
sudo gitlab-ctl restart
before anything else.
If you need to roll back to the previous version you can use the database
backup made during the upgrade (scroll up for the filename).
root@Gitlab:~# gitlab-ctl restart
ok: run: alertmanager: (pid 17402) 0s
ok: run: crond: (pid 17411) 0s
ok: run: gitaly: (pid 17425) 0s
ok: run: gitlab-exporter: (pid 17441) 1s
ok: run: gitlab-workhorse: (pid 17444) 0s
ok: run: grafana: (pid 17457) 1s
ok: run: logrotate: (pid 17484) 0s
ok: run: nginx: (pid 17495) 0s
ok: run: node-exporter: (pid 17507) 1s
ok: run: postgres-exporter: (pid 17514) 0s
ok: run: postgresql: (pid 17529) 0s
ok: run: prometheus: (pid 17538) 0s
ok: run: puma: (pid 17630) 0s
ok: run: redis: (pid 17638) 0s
ok: run: redis-exporter: (pid 17643) 1s
ok: run: registry: (pid 17655) 0s
ok: run: sidekiq: (pid 17690) 0s
root@Gitlab:~#