Cannot upgrade from Gitlab-CE 11.11.3 to 12.0.0
Summary
Cannot upgrade from Gitlab-CE 11.11.3 to 12.0.0
Steps to reproduce
FYI: We originally started with Gitlab-CE 11.x. We then upgraded to Gitlab-EE for several months. We then had to downgrade back to Gitlab-CE.
- We were running on gitlab-ce 11.10.4. Tried to install gitlab-ce 12.0.0 by running
sudo apt update && sudo apt install gitlab-ce
- Ran into issue saying I needed to upgrade to latest minor revision first. Ran
sudo apt install gitlab-ce=11.11.3-ce.0
. Upgrade to 11.11.3 was successful - Once again tried to upgrade by running
sudo apt install gitlab-ce
. Upgrade failed.
What is the current bug behavior?
Cannot run gitlab-ce. Attempting to access in web browser shows "Deploy in progress".
I attempted to downgrade to 11.11.3-ce.0 so that I could restore our latest backup. Running sudo apt install gitlab-ce=11.11.3-ce.0
fails because the reconfigure continues to fail. I guess I need to uninstall gitlab and reinstall?
What is the expected correct behavior?
Successful upgrade to 12.
Relevant logs
Output from running `sudo gitlab-ctl reconfigure`
Starting Chef Client, version 13.6.4[0m resolving cookbooks for run list: ["gitlab"][0m Synchronizing Cookbooks:[0m - package (0.1.0)[0m - redis (0.1.0)[0m - mattermost (0.1.0)[0m - registry (0.1.0)[0m - gitlab (0.0.1)[0m - postgresql (0.1.0)[0m - letsencrypt (0.1.0)[0m - consul (0.1.0)[0m - gitaly (0.1.0)[0m - nginx (0.1.0)[0m - crond (0.1.0)[0m - runit (4.3.0)[0m - acme (3.1.0)[0m - compat_resource (12.19.1)[0m Installing Cookbook Gems:[0m Compiling Cookbooks...[0m Recipe: gitlab::default[0m * directory[/etc/gitlab] action create (up to date) Converging 244 resources[0m * directory[/etc/gitlab] action create (up to date) * directory[Create /var/opt/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[0m * 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[0m * 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[0m * 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 (up to date) * link[Link /opt/gitlab/embedded/service/gitlab-shell/config.yml to /var/opt/gitlab/gitlab-shell/config.yml] action create (up to date) (up to date) * link[/opt/gitlab/embedded/service/gitlab-shell/.gitlab_shell_secret] action create (up to date) * execute[/opt/gitlab/embedded/service/gitlab-shell/bin/gitlab-keys check-permissions] action run [32m- execute /opt/gitlab/embedded/service/gitlab-shell/bin/gitlab-keys check-permissions[0m [0m * bash[Set proper security context on ssh files for selinux] action run (skipped due to only_if) Recipe: gitlab::gitlab-rails[0m * storage_directory[/var/git] action create * ruby_block[directory resource: /var/git] action run (skipped due to not_if) (up to date) * storage_directory[/var/git/repositories] action create * ruby_block[directory resource: /var/git/repositories] action run (skipped due to not_if) (up to date) * directory[/var/log/gitlab] action create (up to date) * 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/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/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[/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) * 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[/repo_backups] action create * ruby_block[directory resource: /repo_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 (skipped due to only_if) * 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 redis.cache.yml and create a symlink to Rails root] action create (skipped due to not_if) * templatesymlink[Create a redis.queues.yml and create a symlink to Rails root] action create (skipped due to not_if) * templatesymlink[Create a redis.shared_state.yml and create a symlink to Rails root] action create (skipped due to not_if) * templatesymlink[Create a smtp_settings.rb and create a symlink to Rails root] action create * template[/var/opt/gitlab/gitlab-rails/etc/smtp_settings.rb] action create (up to date) * link[Link /opt/gitlab/embedded/service/gitlab-rails/config/initializers/smtp_settings.rb to /var/opt/gitlab/gitlab-rails/etc/smtp_settings.rb] action create (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 (up to date) * 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) (up to date) * templatesymlink[Create a rack_attack.rb and create a symlink to Rails root] action create * template[/var/opt/gitlab/gitlab-rails/etc/rack_attack.rb] action create (up to date) * link[Link /opt/gitlab/embedded/service/gitlab-rails/config/initializers/rack_attack.rb to /var/opt/gitlab/gitlab-rails/etc/rack_attack.rb] action create (up to date) (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 (skipped due to only_if) * 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 create (skipped due to not_if) * file[/opt/gitlab/embedded/service/gitlab-rails/db/schema.rb] action create (up to date) * remote_file[/var/opt/gitlab/gitlab-rails/VERSION] action create (up to date) * remote_file[/var/opt/gitlab/gitlab-rails/REVISION] action create (up to date) * file[/var/opt/gitlab/gitlab-rails/RUBY_VERSION] action create (up to date) * 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::add_trusted_certs[0m * 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 (skipped due to only_if) Recipe: gitlab::default[0m * 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 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[0m * directory[/usr/lib/systemd/system] action create (up to date) * cookbook_file[/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: redis::enable[0m * 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: [0m * service[redis] action nothing (skipped due to action :nothing) Recipe: redis::enable[0m * 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/run] action create (up to date) * template[/var/log/gitlab/redis/config] 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 delete (up to date) * 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) Recipe: gitaly::enable[0m * directory[/var/opt/gitlab/gitaly] action create (up to date) * directory[/var/log/gitlab/gitaly] 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) Recipe: [0m * service[gitaly] action nothing (skipped due to action :nothing) Recipe: gitaly::enable[0m * 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/run] action create (up to date) * template[/var/log/gitlab/gitaly/config] 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 delete (up to date) * 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) * file[/var/opt/gitlab/gitaly/VERSION] action create (up to date) Recipe: postgresql::user[0m * 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) Recipe: postgresql::enable[0m * 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) * link[/var/opt/gitlab/postgresql/data] action create (skipped due to not_if) * file[/var/opt/gitlab/postgresql/.profile] action create (up to date) * 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) * file[delete /etc/sysctl.d/90-postgresql.conf kernel.shmmax] action delete (skipped due to only_if) * file[delete /etc/sysctl.d/90-unicorn.conf kernel.shmmax] action delete (skipped due to only_if) * file[delete /opt/gitlab/embedded/etc/90-omnibus-gitlab.conf kernel.shmmax] action delete (skipped due to only_if) * file[delete /etc/sysctl.d/90-omnibus-gitlab.conf kernel.shmmax] action delete (skipped due to only_if) * execute[load sysctl conf kernel.shmmax] action nothing (skipped due to action :nothing) (up to date) * 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) * file[delete /etc/sysctl.d/90-postgresql.conf kernel.shmall] action delete (skipped due to only_if) * file[delete /etc/sysctl.d/90-unicorn.conf kernel.shmall] action delete (skipped due to only_if) * file[delete /opt/gitlab/embedded/etc/90-omnibus-gitlab.conf kernel.shmall] action delete (skipped due to only_if) * file[delete /etc/sysctl.d/90-omnibus-gitlab.conf kernel.shmall] action delete (skipped due to only_if) * execute[load sysctl conf kernel.shmall] action nothing (skipped due to action :nothing) (up to date) * 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) * file[delete /etc/sysctl.d/90-postgresql.conf kernel.sem] action delete (skipped due to only_if) * file[delete /etc/sysctl.d/90-unicorn.conf kernel.sem] action delete (skipped due to only_if) * file[delete /opt/gitlab/embedded/etc/90-omnibus-gitlab.conf kernel.sem] action delete (skipped due to only_if) * file[delete /etc/sysctl.d/90-omnibus-gitlab.conf kernel.sem] action delete (skipped due to only_if) * 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) * 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) * 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) Recipe: [0m * service[postgresql] action nothing (skipped due to action :nothing) Recipe: postgresql::enable[0m * 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/run] action create (up to date) * template[/var/log/gitlab/postgresql/config] 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 delete (up to date) * 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/sv/postgresql/supervise/ok] action touch (skipped due to only_if) * file[/opt/gitlab/sv/postgresql/log/supervise/ok] action touch (skipped due to only_if) * file[/opt/gitlab/sv/postgresql/supervise/status] action touch (skipped due to only_if) * file[/opt/gitlab/sv/postgresql/log/supervise/status] action touch (skipped due to only_if) * file[/opt/gitlab/sv/postgresql/supervise/control] action touch (skipped due to only_if) * file[/opt/gitlab/sv/postgresql/log/supervise/control] action touch (skipped due to only_if) (up to date) Recipe: postgresql::bin[0m * ruby_block[Link postgresql bin files to the correct version] action run (skipped due to only_if) Recipe: postgresql::enable[0m * template[/opt/gitlab/etc/gitlab-psql-rc] action create (up to date) * postgresql_user[gitlab] action create * execute[create gitlab postgresql user] action run (skipped due to not_if) (up to date) * execute[create gitlabhq_production database] action run (skipped due to not_if) * 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) * postgresql_extension[pg_trgm] action enable * postgresql_query[enable pg_trgm extension] action run (skipped due to only_if) (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::database_migrations[0m * bash[migrate gitlab-rails database] action run [execute] == 20190402150158 BackportEnterpriseSchema: migrating ========================= -- column_exists?(:appearances, :updated_by) -> 0.0015s -- change_column_null(:application_settings, :password_authentication_enabled_for_git, false) -> 0.0003s -- change_table(:application_settings, {}) -> 0.7031s -- transaction_open?() -> 0.0000s -- index_exists?(:application_settings, :custom_project_templates_group_id, {:algorithm=>:concurrently}) -> 0.0030s -- transaction_open?() -> 0.0000s -- index_exists?(:application_settings, :file_template_project_id, {:algorithm=>:concurrently}) -> 0.0019s -- column_exists?(:boards, :milestone_id) -> 0.0012s -- column_exists?(:boards, :weight) -> 0.0010s -- column_exists?(:boards, :name) -> 0.0010s -- transaction_open?() -> 0.0000s -- index_exists?(:boards, :milestone_id, {:algorithm=>:concurrently}) -> 0.0017s -- column_exists?(:clusters_applications_prometheus, :encrypted_alert_manager_token) -> 0.0012s -- column_exists?(:clusters_applications_prometheus, :encrypted_alert_manager_token_iv) -> 0.0011s -- column_exists?(:clusters_applications_prometheus, :last_update_started_at) -> 0.0010s -- column_exists?(:identities, :saml_provider_id) -> 0.0011s -- column_exists?(:identities, :secondary_extern_uid) -> 0.0010s -- transaction_open?() -> 0.0000s -- index_exists?(:identities, :saml_provider_id, {:where=>"saml_provider_id IS NOT NULL", :algorithm=>:concurrently}) -> 0.0018s -- column_exists?(:issues, :service_desk_reply_to) -> 0.0016s -- column_exists?(:issues, :weight) -> 0.0014s -- column_exists?(:lists, :milestone_id) -> 0.0011s -- column_exists?(:lists, :user_id) -> 0.0010s -- transaction_open?() -> 0.0000s -- index_exists?(:lists, :milestone_id, {:algorithm=>:concurrently}) -> 0.0022s -- transaction_open?() -> 0.0000s -- index_exists?(:lists, :user_id, {:algorithm=>:concurrently}) -> 0.0021s -- column_exists?(:members, :ldap) -> 0.0013s -- column_exists?(:members, :override) -> 0.0017s -- column_exists?(:merge_requests, :approvals_before_merge) -> 0.0023s -- column_exists?(:notes, :review_id) -> 0.0015s -- transaction_open?() -> 0.0000s -- index_exists?(:notes, :review_id, {:algorithm=>:concurrently}) -> 0.0042s -- transaction_open?() -> 0.0000s -- index_exists?(:ci_builds, [:name], {:name=>"index_ci_builds_on_name_for_security_products_values", :where=>"\n (\n (name)::text = ANY (\n ARRAY[\n ('container_scanning'::character varying)::text,\n ('dast'::character varying)::text,\n ('dependency_scanning'::character varying)::text,\n ('license_management'::character varying)::text,\n ('sast'::character varying)::text\n ]\n )\n )", :algorithm=>:concurrently}) -> 0.0075s -- index_exists?(:environments, :name, {:name=>"index_environments_on_name_varchar_pattern_ops"}) -> 0.0018s -- change_table(:namespaces, {}) -> 0.0338s -- column_exists?(:namespaces, :ldap_sync_status) -> 0.0031s -- column_exists?(:namespaces, :membership_lock) -> 0.0032s -- indexes(:namespaces) -> 0.0087s -- transaction_open?() -> 0.0000s -- index_exists?(:namespaces, :file_template_project_id, {:algorithm=>:concurrently}) -> 0.0079s -- transaction_open?() -> 0.0000s -- index_exists?(:namespaces, :ldap_sync_last_successful_update_at, {:algorithm=>:concurrently}) -> 0.0080s -- transaction_open?() -> 0.0000s -- index_exists?(:namespaces, :ldap_sync_last_update_at, {:algorithm=>:concurrently}) -> 0.0080s -- transaction_open?() -> 0.0000s -- index_exists?(:namespaces, :plan_id, {:algorithm=>:concurrently}) -> 0.0082s -- transaction_open?() -> 0.0000s -- index_exists?(:namespaces, :trial_ends_on, {:where=>"(trial_ends_on IS NOT NULL)", :algorithm=>:concurrently}) -> 0.0072s -- indexes(:namespaces) -> 0.0070s -- column_exists?(:notification_settings, :new_epic) -> 0.0017s -- change_table(:project_mirror_data, {}) -> 0.0054s -- column_exists?(:project_mirror_data, :retry_count) -> 0.0011s -- transaction_open?() -> 0.0000s -- index_exists?(:project_mirror_data, :last_successful_update_at, {:algorithm=>:concurrently}) -> 0.0023s -- transaction_open?() -> 0.0000s -- index_exists?(:project_mirror_data, [:next_execution_timestamp, :retry_count], {:name=>"index_mirror_data_on_next_execution_and_retry_count", :algorithm=>:concurrently}) -> 0.0021s -- column_exists?(:project_statistics, :shared_runners_seconds) -> 0.0021s -- column_exists?(:project_statistics, :shared_runners_seconds_last_reset) -> 0.0016s -- change_table(:projects, {}) -> 0.0699s -- change_column_null(:projects, :merge_requests_rebase_enabled, true) -> 0.0005s -- column_exists?(:projects, :mirror) -> 0.0384s -- column_exists?(:projects, :mirror_trigger_builds) -> 0.0042s -- column_exists?(:projects, :reset_approvals_on_push) -> 0.0033s -- column_exists?(:projects, :service_desk_enabled) -> 0.0033s -- column_exists?(:projects, :approvals_before_merge) -> 0.0036s -- transaction_open?() -> 0.0000s -- index_exists?(:projects, [:archived, :pending_delete, :merge_requests_require_code_owner_approval], {:name=>"projects_requiring_code_owner_approval", :where=>"((pending_delete = false) AND (archived = false) AND (merge_requests_require_code_owner_approval = true))", :algorithm=>:concurrently}) -> 0.0085s -- transaction_open?() -> 0.0000s -- index_exists?(:projects, [:id, :repository_storage, :last_repository_updated_at], {:name=>"idx_projects_on_repository_storage_last_repository_updated_at", :algorithm=>:concurrently}) -> 0.0085s -- transaction_open?() -> 0.0000s -- index_exists?(:projects, :id, {:name=>"index_projects_on_mirror_and_mirror_trigger_builds_both_true", :where=>"((mirror IS TRUE) AND (mirror_trigger_builds IS TRUE))", :algorithm=>:concurrently}) -> 0.0081s -- transaction_open?() -> 0.0000s -- index_exists?(:projects, :mirror_last_successful_update_at, {:algorithm=>:concurrently}) -> 0.0085s -- change_column_null(:protected_branch_merge_access_levels, :access_level, true) -> 0.0004s -- column_exists?(:protected_branch_merge_access_levels, :group_id) -> 0.0012s -- column_exists?(:protected_branch_merge_access_levels, :user_id) -> 0.0010s -- transaction_open?() -> 0.0000s -- index_exists?(:protected_branch_merge_access_levels, :group_id, {:algorithm=>:concurrently}) -> 0.0018s -- transaction_open?() -> 0.0000s -- index_exists?(:protected_branch_merge_access_levels, :user_id, {:algorithm=>:concurrently}) -> 0.0016s -- change_column_null(:protected_branch_push_access_levels, :access_level, true) -> 0.0003s -- column_exists?(:protected_branch_push_access_levels, :group_id) -> 0.0010s -- column_exists?(:protected_branch_push_access_levels, :user_id) -> 0.0010s -- transaction_open?() -> 0.0000s -- index_exists?(:protected_branch_push_access_levels, :group_id, {:algorithm=>:concurrently}) -> 0.0017s -- transaction_open?() -> 0.0000s -- index_exists?(:protected_branch_push_access_levels, :user_id, {:algorithm=>:concurrently}) -> 0.0022s -- column_exists?(:resource_label_events, :epic_id) -> 0.0017s -- transaction_open?() -> 0.0000s -- index_exists?(:resource_label_events, :epic_id, {:algorithm=>:concurrently}) -> 0.0030s -- column_exists?(:user_preferences, :epic_notes_filter) -> 0.0019s -- column_exists?(:user_preferences, :epics_sort) -> 0.0018s -- column_exists?(:user_preferences, :roadmap_epics_state) -> 0.0017s -- column_exists?(:user_preferences, :roadmaps_sort) -> 0.0017s -- column_exists?(:users, :auditor) -> 0.0053s -- change_table(:users, {}) -> 0.0430s -- transaction_open?() -> 0.0000s -- index_exists?(:users, :group_view, {:algorithm=>:concurrently}) -> 0.0110s -- transaction_open?() -> 0.0000s -- index_exists?(:users, :managing_group_id, {:algorithm=>:concurrently}) -> 0.0085s -- transaction_open?() -> 0.0000s -- index_exists?(:users, :support_bot, {:algorithm=>:concurrently}) -> 0.0070s -- transaction_open?() -> 0.0000s -- index_exists?(:users, :bot_type, {:algorithm=>:concurrently}) -> 0.0089s -- transaction_open?() -> 0.0000s -- index_exists?(:users, :state, {:name=>"index_users_on_state_and_internal_attrs", :where=>"((ghost <> true) AND (support_bot <> true))", :algorithm=>:concurrently}) -> 0.0069s -- transaction_open?() -> 0.0000s -- select_one("SELECT current_setting('server_version_num') AS v") -> 0.0003s -- index_exists?(:users, :state, {:name=>"index_users_on_state_and_internal", :algorithm=>:concurrently}) -> 0.0070s -- execute("SET statement_timeout TO 0") -> 0.0002s -- remove_index(:users, {:name=>"index_users_on_state_and_internal", :algorithm=>:concurrently, :column=>:state}) -> 0.0148s -- execute("RESET ALL") -> 0.0002s -- transaction_open?() -> 0.0000s -- index_exists?(:users, :state, {:name=>"index_users_on_state_and_internal", :where=>"((ghost <> true) AND (bot_type IS NULL))", :algorithm=>:concurrently}) -> 0.0072s -- execute("SET statement_timeout TO 0") -> 0.0002s -- add_index(:users, :state, {:name=>"index_users_on_state_and_internal", :where=>"((ghost <> true) AND (bot_type IS NULL))", :algorithm=>:concurrently}) -> 0.0064s -- execute("RESET ALL") -> 0.0004s -- column_exists?(:web_hooks, :group_id) -> 0.0020s -- column_exists?(:geo_nodes, :internal_url) -> 0.0016s -- foreign_keys("application_settings") -> 0.0035s -- foreign_keys("application_settings") -> 0.0028s -- foreign_keys("approval_merge_request_rule_sources") -> 0.0027s -- foreign_keys("approval_merge_request_rule_sources") -> 0.0026s -- foreign_keys("approval_merge_request_rules") -> 0.0026s -- foreign_keys("approval_merge_request_rules_approved_approvers") -> 0.0027s -- foreign_keys("approval_merge_request_rules_approved_approvers") -> 0.0026s -- foreign_keys("approval_merge_request_rules_groups") -> 0.0026s -- foreign_keys("approval_merge_request_rules_groups") -> 0.0026s -- foreign_keys("approval_merge_request_rules_users") -> 0.0027s -- foreign_keys("approval_merge_request_rules_users") -> 0.0027s -- foreign_keys("approval_project_rules") -> 0.0026s -- foreign_keys("approval_project_rules_groups") -> 0.0026s -- foreign_keys("approval_project_rules_groups") -> 0.0027s -- foreign_keys("approval_project_rules_users") -> 0.0027s -- foreign_keys("approval_project_rules_users") -> 0.0028s -- foreign_keys("approvals") -> 0.0026s -- foreign_keys("approver_groups") -> 0.0027s -- foreign_keys("board_assignees") -> 0.0027s -- foreign_keys("board_assignees") -> 0.0027s -- foreign_keys("board_labels") -> 0.0028s -- foreign_keys("board_labels") -> 0.0029s -- foreign_keys("ci_sources_pipelines") -> 0.0028s -- foreign_keys("ci_sources_pipelines") -> 0.0029s -- foreign_keys("ci_sources_pipelines") -> 0.0038s -- foreign_keys("ci_sources_pipelines") -> 0.0048s -- foreign_keys("ci_sources_pipelines") -> 0.0030s -- foreign_keys("design_management_designs") -> 0.0030s -- foreign_keys("design_management_designs") -> 0.0028s -- foreign_keys("design_management_designs_versions") -> 0.0028s -- foreign_keys("design_management_designs_versions") -> 0.0030s -- foreign_keys("draft_notes") -> 0.0028s -- foreign_keys("draft_notes") -> 0.0029s -- foreign_keys("elasticsearch_indexed_namespaces") -> 0.0027s -- foreign_keys("elasticsearch_indexed_projects") -> 0.0028s -- foreign_keys("epic_issues") -> 0.0030s -- foreign_keys("epic_issues") -> 0.0027s -- foreign_keys("epic_metrics") -> 0.0026s -- foreign_keys("epics") -> 0.0029s -- foreign_keys("epics") -> 0.0029s -- foreign_keys("epics") -> 0.0028s -- foreign_keys("epics") -> 0.0029s -- foreign_keys("epics") -> 0.0029s -- foreign_keys("epics") -> 0.0029s -- foreign_keys("geo_event_log") -> 0.0031s -- foreign_keys("geo_event_log") -> 0.0029s -- foreign_keys("geo_event_log") -> 0.0030s -- foreign_keys("geo_event_log") -> 0.0028s -- foreign_keys("geo_event_log") -> 0.0028s -- foreign_keys("geo_event_log") -> 0.0028s -- foreign_keys("geo_event_log") -> 0.0028s -- foreign_keys("geo_event_log") -> 0.0028s -- foreign_keys("geo_event_log") -> 0.0030s -- foreign_keys("geo_event_log") -> 0.0030s -- foreign_keys("geo_event_log") -> 0.0029s -- foreign_keys("geo_hashed_storage_attachments_events") -> 0.0028s -- foreign_keys("geo_hashed_storage_migrated_events") -> 0.0028s -- foreign_keys("geo_node_namespace_links") -> 0.0028s -- foreign_keys("geo_node_namespace_links") -> 0.0028s -- foreign_keys("geo_node_statuses") -> 0.0028s -- foreign_keys("geo_repositories_changed_events") -> 0.0027s -- foreign_keys("geo_repository_created_events") -> 0.0028s -- foreign_keys("geo_repository_renamed_events") -> 0.0027s -- foreign_keys("geo_repository_updated_events") -> 0.0033s -- foreign_keys("geo_reset_checksum_events") -> 0.0029s -- foreign_keys("gitlab_subscriptions") -> 0.0048s -- foreign_keys("gitlab_subscriptions") -> 0.0052s -- foreign_keys("identities") -> 0.0055s -- foreign_keys("index_statuses") -> 0.0053s -- foreign_keys("insights") -> 0.0052s -- foreign_keys("insights") -> 0.0040s -- foreign_keys("issue_links") -> 0.0033s -- foreign_keys("issue_links") -> 0.0039s -- foreign_keys("lists") -> 0.0046s -- foreign_keys("lists") -> 0.0046s -- foreign_keys("namespace_statistics") -> 0.0040s -- foreign_keys("namespaces") -> 0.0032s -- foreign_keys("namespaces") -> 0.0029s -- foreign_keys("namespaces") -> 0.0029s -- foreign_keys("notes") -> 0.0028s -- foreign_keys("operations_feature_flag_scopes") -> 0.0027s -- foreign_keys("operations_feature_flags") -> 0.0027s -- foreign_keys("operations_feature_flags_clients") -> 0.0027s -- foreign_keys("packages_maven_metadata") -> 0.0029s -- foreign_keys("packages_package_files") -> 0.0026s -- foreign_keys("packages_packages") -> 0.0027s -- foreign_keys("path_locks") -> 0.0028s -- foreign_keys("path_locks") -> 0.0027s -- foreign_keys("project_alerting_settings") -> 0.0026s -- foreign_keys("project_feature_usages") -> 0.0026s -- foreign_keys("project_incident_management_settings") -> 0.0026s -- foreign_keys("project_repository_states") -> 0.0025s -- foreign_keys("project_tracing_settings") -> 0.0025s -- foreign_keys("prometheus_alert_events") -> 0.0026s -- foreign_keys("prometheus_alert_events") -> 0.0026s -- foreign_keys("prometheus_alerts") -> 0.0029s -- foreign_keys("prometheus_alerts") -> 0.0026s -- foreign_keys("prometheus_alerts") -> 0.0026s -- foreign_keys("protected_branch_merge_access_levels") -> 0.0026s -- foreign_keys("protected_branch_merge_access_levels") -> 0.0026s -- foreign_keys("protected_branch_push_access_levels") -> 0.0028s -- foreign_keys("protected_branch_push_access_levels") -> 0.0027s -- foreign_keys("protected_branch_unprotect_access_levels") -> 0.0027s -- foreign_keys("protected_branch_unprotect_access_levels") -> 0.0026s -- foreign_keys("protected_branch_unprotect_access_levels") -> 0.0026s -- foreign_keys("protected_environment_deploy_access_levels") -> 0.0026s -- foreign_keys("protected_environment_deploy_access_levels") -> 0.0027s -- foreign_keys("protected_environment_deploy_access_levels") -> 0.0026s -- foreign_keys("protected_environments") -> 0.0026s -- foreign_keys("push_rules") -> 0.0026s -- foreign_keys("resource_label_events") -> 0.0027s -- foreign_keys("reviews") -> 0.0027s -- foreign_keys("reviews") -> 0.0027s -- foreign_keys("reviews") -> 0.0026s -- foreign_keys("saml_providers") -> 0.0026s -- foreign_keys("scim_oauth_access_tokens") -> 0.0025s -- foreign_keys("slack_integrations") -> 0.0025s -- foreign_keys("smartcard_identities") -> 0.0026s -- foreign_keys("software_license_policies") -> 0.0029s -- foreign_keys("software_license_policies") -> 0.0026s -- foreign_keys("users") -> 0.0026s -- foreign_keys("users_ops_dashboard_projects") -> 0.0026s -- foreign_keys("users_ops_dashboard_projects") -> 0.0026s -- foreign_keys("vulnerability_feedback") -> 0.0027s -- foreign_keys("vulnerability_feedback") -> 0.0030s -- foreign_keys("vulnerability_feedback")rake aborted! StandardError: An error has occurred, all later migrations canceled:PG::UndefinedColumn: ERROR: column "merge_request_id" referenced in foreign key constraint does not exist : ALTER TABLE vulnerability_feedback ADD CONSTRAINT fk_563ff1912e FOREIGN KEY (merge_request_id) REFERENCES merge_requests (id) ON DELETE SET NULL NOT VALID; /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:192:in `add_concurrent_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20190402150158_backport_enterprise_schema.rb:235:in `add_concurrent_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20190402150158_backport_enterprise_schema.rb:1976:in `add_missing_foreign_keys' /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20190402150158_backport_enterprise_schema.rb:147:in `up' /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:56:in `block (3 levels) in <top (required)>' /opt/gitlab/embedded/bin/bundle:23:in `load' /opt/gitlab/embedded/bin/bundle:23:in `<main>' Caused by: ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR: column "merge_request_id" referenced in foreign key constraint does not exist : ALTER TABLE vulnerability_feedback ADD CONSTRAINT fk_563ff1912e FOREIGN KEY (merge_request_id) REFERENCES merge_requests (id) ON DELETE SET NULL NOT VALID; /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:192:in `add_concurrent_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20190402150158_backport_enterprise_schema.rb:235:in `add_concurrent_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20190402150158_backport_enterprise_schema.rb:1976:in `add_missing_foreign_keys' /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20190402150158_backport_enterprise_schema.rb:147:in `up' /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:56:in `block (3 levels) in <top (required)>' /opt/gitlab/embedded/bin/bundle:23:in `load' /opt/gitlab/embedded/bin/bundle:23:in `<main>' Caused by: PG::UndefinedColumn: ERROR: column "merge_request_id" referenced in foreign key constraint does not exist /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:192:in `add_concurrent_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20190402150158_backport_enterprise_schema.rb:235:in `add_concurrent_foreign_key' /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20190402150158_backport_enterprise_schema.rb:1976:in `add_missing_foreign_keys' /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20190402150158_backport_enterprise_schema.rb:147:in `up' /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:56:in `block (3 levels) in <top (required)>' /opt/gitlab/embedded/bin/bundle:23:in `load' /opt/gitlab/embedded/bin/bundle:23:in `<main>' Tasks: TOP => db:migrate (See full trace by running task with --trace) -> 0.0067s -- transaction_open?() -> 0.0000s -- foreign_keys("vulnerability_feedback") -> 0.0034s -- execute("ALTER TABLE vulnerability_feedback\nADD CONSTRAINT fk_563ff1912e\nFOREIGN KEY (merge_request_id)\nREFERENCES merge_requests (id)\nON DELETE SET NULL\nNOT VALID;\n") [0m ================================================================================[0m [31mError executing action `run` on resource 'bash[migrate gitlab-rails database]'[0m ================================================================================[0m
[0m Mixlib::ShellOut::ShellCommandFailed[0m ------------------------------------[0m Expected process to exit with [0], but received '1' [0m ---- Begin output of "bash" "/tmp/chef-script20190624-6157-4f6unv" ---- [0m STDOUT: == 20190402150158 BackportEnterpriseSchema: migrating ========================= [0m -- column_exists?(:appearances, :updated_by) [0m -> 0.0015s [0m -- change_column_null(:application_settings, :password_authentication_enabled_for_git, false) [0m -> 0.0003s [0m -- change_table(:application_settings, {}) [0m -> 0.7031s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:application_settings, :custom_project_templates_group_id, {:algorithm=>:concurrently}) [0m -> 0.0030s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:application_settings, :file_template_project_id, {:algorithm=>:concurrently}) [0m -> 0.0019s [0m -- column_exists?(:boards, :milestone_id) [0m -> 0.0012s [0m -- column_exists?(:boards, :weight) [0m -> 0.0010s [0m -- column_exists?(:boards, :name) [0m -> 0.0010s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:boards, :milestone_id, {:algorithm=>:concurrently}) [0m -> 0.0017s [0m -- column_exists?(:clusters_applications_prometheus, :encrypted_alert_manager_token) [0m -> 0.0012s [0m -- column_exists?(:clusters_applications_prometheus, :encrypted_alert_manager_token_iv) [0m -> 0.0011s [0m -- column_exists?(:clusters_applications_prometheus, :last_update_started_at) [0m -> 0.0010s [0m -- column_exists?(:identities, :saml_provider_id) [0m -> 0.0011s [0m -- column_exists?(:identities, :secondary_extern_uid) [0m -> 0.0010s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:identities, :saml_provider_id, {:where=>"saml_provider_id IS NOT NULL", :algorithm=>:concurrently}) [0m -> 0.0018s [0m -- column_exists?(:issues, :service_desk_reply_to) [0m -> 0.0016s [0m -- column_exists?(:issues, :weight) [0m -> 0.0014s [0m -- column_exists?(:lists, :milestone_id) [0m -> 0.0011s [0m -- column_exists?(:lists, :user_id) [0m -> 0.0010s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:lists, :milestone_id, {:algorithm=>:concurrently}) [0m -> 0.0022s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:lists, :user_id, {:algorithm=>:concurrently}) [0m -> 0.0021s [0m -- column_exists?(:members, :ldap) [0m -> 0.0013s [0m -- column_exists?(:members, :override) [0m -> 0.0017s [0m -- column_exists?(:merge_requests, :approvals_before_merge) [0m -> 0.0023s [0m -- column_exists?(:notes, :review_id) [0m -> 0.0015s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:notes, :review_id, {:algorithm=>:concurrently}) [0m -> 0.0042s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:ci_builds, [:name], {:name=>"index_ci_builds_on_name_for_security_products_values", :where=>"\n (\n (name)::text = ANY (\n ARRAY[\n ('container_scanning'::character varying)::text,\n ('dast'::character varying)::text,\n ('dependency_scanning'::character varying)::text,\n ('license_management'::character varying)::text,\n ('sast'::character varying)::text\n ]\n )\n )", :algorithm=>:concurrently}) [0m -> 0.0075s [0m -- index_exists?(:environments, :name, {:name=>"index_environments_on_name_varchar_pattern_ops"}) [0m -> 0.0018s [0m -- change_table(:namespaces, {}) [0m -> 0.0338s [0m -- column_exists?(:namespaces, :ldap_sync_status) [0m -> 0.0031s [0m -- column_exists?(:namespaces, :membership_lock) [0m -> 0.0032s [0m -- indexes(:namespaces) [0m -> 0.0087s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:namespaces, :file_template_project_id, {:algorithm=>:concurrently}) [0m -> 0.0079s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:namespaces, :ldap_sync_last_successful_update_at, {:algorithm=>:concurrently}) [0m -> 0.0080s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:namespaces, :ldap_sync_last_update_at, {:algorithm=>:concurrently}) [0m -> 0.0080s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:namespaces, :plan_id, {:algorithm=>:concurrently}) [0m -> 0.0082s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:namespaces, :trial_ends_on, {:where=>"(trial_ends_on IS NOT NULL)", :algorithm=>:concurrently}) [0m -> 0.0072s [0m -- indexes(:namespaces) [0m -> 0.0070s [0m -- column_exists?(:notification_settings, :new_epic) [0m -> 0.0017s [0m -- change_table(:project_mirror_data, {}) [0m -> 0.0054s [0m -- column_exists?(:project_mirror_data, :retry_count) [0m -> 0.0011s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:project_mirror_data, :last_successful_update_at, {:algorithm=>:concurrently}) [0m -> 0.0023s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:project_mirror_data, [:next_execution_timestamp, :retry_count], {:name=>"index_mirror_data_on_next_execution_and_retry_count", :algorithm=>:concurrently}) [0m -> 0.0021s [0m -- column_exists?(:project_statistics, :shared_runners_seconds) [0m -> 0.0021s [0m -- column_exists?(:project_statistics, :shared_runners_seconds_last_reset) [0m -> 0.0016s [0m -- change_table(:projects, {}) [0m -> 0.0699s [0m -- change_column_null(:projects, :merge_requests_rebase_enabled, true) [0m -> 0.0005s [0m -- column_exists?(:projects, :mirror) [0m -> 0.0384s [0m -- column_exists?(:projects, :mirror_trigger_builds) [0m -> 0.0042s [0m -- column_exists?(:projects, :reset_approvals_on_push) [0m -> 0.0033s [0m -- column_exists?(:projects, :service_desk_enabled) [0m -> 0.0033s [0m -- column_exists?(:projects, :approvals_before_merge) [0m -> 0.0036s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:projects, [:archived, :pending_delete, :merge_requests_require_code_owner_approval], {:name=>"projects_requiring_code_owner_approval", :where=>"((pending_delete = false) AND (archived = false) AND (merge_requests_require_code_owner_approval = true))", :algorithm=>:concurrently}) [0m -> 0.0085s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:projects, [:id, :repository_storage, :last_repository_updated_at], {:name=>"idx_projects_on_repository_storage_last_repository_updated_at", :algorithm=>:concurrently}) [0m -> 0.0085s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:projects, :id, {:name=>"index_projects_on_mirror_and_mirror_trigger_builds_both_true", :where=>"((mirror IS TRUE) AND (mirror_trigger_builds IS TRUE))", :algorithm=>:concurrently}) [0m -> 0.0081s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:projects, :mirror_last_successful_update_at, {:algorithm=>:concurrently}) [0m -> 0.0085s [0m -- change_column_null(:protected_branch_merge_access_levels, :access_level, true) [0m -> 0.0004s [0m -- column_exists?(:protected_branch_merge_access_levels, :group_id) [0m -> 0.0012s [0m -- column_exists?(:protected_branch_merge_access_levels, :user_id) [0m -> 0.0010s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:protected_branch_merge_access_levels, :group_id, {:algorithm=>:concurrently}) [0m -> 0.0018s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:protected_branch_merge_access_levels, :user_id, {:algorithm=>:concurrently}) [0m -> 0.0016s [0m -- change_column_null(:protected_branch_push_access_levels, :access_level, true) [0m -> 0.0003s [0m -- column_exists?(:protected_branch_push_access_levels, :group_id) [0m -> 0.0010s [0m -- column_exists?(:protected_branch_push_access_levels, :user_id) [0m -> 0.0010s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:protected_branch_push_access_levels, :group_id, {:algorithm=>:concurrently}) [0m -> 0.0017s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:protected_branch_push_access_levels, :user_id, {:algorithm=>:concurrently}) [0m -> 0.0022s [0m -- column_exists?(:resource_label_events, :epic_id) [0m -> 0.0017s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:resource_label_events, :epic_id, {:algorithm=>:concurrently}) [0m -> 0.0030s [0m -- column_exists?(:user_preferences, :epic_notes_filter) [0m -> 0.0019s [0m -- column_exists?(:user_preferences, :epics_sort) [0m -> 0.0018s [0m -- column_exists?(:user_preferences, :roadmap_epics_state) [0m -> 0.0017s [0m -- column_exists?(:user_preferences, :roadmaps_sort) [0m -> 0.0017s [0m -- column_exists?(:users, :auditor) [0m -> 0.0053s [0m -- change_table(:users, {}) [0m -> 0.0430s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:users, :group_view, {:algorithm=>:concurrently}) [0m -> 0.0110s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:users, :managing_group_id, {:algorithm=>:concurrently}) [0m -> 0.0085s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:users, :support_bot, {:algorithm=>:concurrently}) [0m -> 0.0070s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:users, :bot_type, {:algorithm=>:concurrently}) [0m -> 0.0089s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:users, :state, {:name=>"index_users_on_state_and_internal_attrs", :where=>"((ghost <> true) AND (support_bot <> true))", :algorithm=>:concurrently}) [0m -> 0.0069s [0m -- transaction_open?() [0m -> 0.0000s [0m -- select_one("SELECT current_setting('server_version_num') AS v") [0m -> 0.0003s [0m -- index_exists?(:users, :state, {:name=>"index_users_on_state_and_internal", :algorithm=>:concurrently}) [0m -> 0.0070s [0m -- execute("SET statement_timeout TO 0") [0m -> 0.0002s [0m -- remove_index(:users, {:name=>"index_users_on_state_and_internal", :algorithm=>:concurrently, :column=>:state}) [0m -> 0.0148s [0m -- execute("RESET ALL") [0m -> 0.0002s [0m -- transaction_open?() [0m -> 0.0000s [0m -- index_exists?(:users, :state, {:name=>"index_users_on_state_and_internal", :where=>"((ghost <> true) AND (bot_type IS NULL))", :algorithm=>:concurrently}) [0m -> 0.0072s [0m -- execute("SET statement_timeout TO 0") [0m -> 0.0002s [0m -- add_index(:users, :state, {:name=>"index_users_on_state_and_internal", :where=>"((ghost <> true) AND (bot_type IS NULL))", :algorithm=>:concurrently}) [0m -> 0.0064s [0m -- execute("RESET ALL") [0m -> 0.0004s [0m -- column_exists?(:web_hooks, :group_id) [0m -> 0.0020s [0m -- column_exists?(:geo_nodes, :internal_url) [0m -> 0.0016s [0m -- foreign_keys("application_settings") [0m -> 0.0035s [0m -- foreign_keys("application_settings") [0m -> 0.0028s [0m -- foreign_keys("approval_merge_request_rule_sources") [0m -> 0.0027s [0m -- foreign_keys("approval_merge_request_rule_sources") [0m -> 0.0026s [0m -- foreign_keys("approval_merge_request_rules") [0m -> 0.0026s [0m -- foreign_keys("approval_merge_request_rules_approved_approvers") [0m -> 0.0027s [0m -- foreign_keys("approval_merge_request_rules_approved_approvers") [0m -> 0.0026s [0m -- foreign_keys("approval_merge_request_rules_groups") [0m -> 0.0026s [0m -- foreign_keys("approval_merge_request_rules_groups") [0m -> 0.0026s [0m -- foreign_keys("approval_merge_request_rules_users") [0m -> 0.0027s [0m -- foreign_keys("approval_merge_request_rules_users") [0m -> 0.0027s [0m -- foreign_keys("approval_project_rules") [0m -> 0.0026s [0m -- foreign_keys("approval_project_rules_groups") [0m -> 0.0026s [0m -- foreign_keys("approval_project_rules_groups") [0m -> 0.0027s [0m -- foreign_keys("approval_project_rules_users") [0m -> 0.0027s [0m -- foreign_keys("approval_project_rules_users") [0m -> 0.0028s [0m -- foreign_keys("approvals") [0m -> 0.0026s [0m -- foreign_keys("approver_groups") [0m -> 0.0027s [0m -- foreign_keys("board_assignees") [0m -> 0.0027s [0m -- foreign_keys("board_assignees") [0m -> 0.0027s [0m -- foreign_keys("board_labels") [0m -> 0.0028s [0m -- foreign_keys("board_labels") [0m -> 0.0029s [0m -- foreign_keys("ci_sources_pipelines") [0m -> 0.0028s [0m -- foreign_keys("ci_sources_pipelines") [0m -> 0.0029s [0m -- foreign_keys("ci_sources_pipelines") [0m -> 0.0038s [0m -- foreign_keys("ci_sources_pipelines") [0m -> 0.0048s [0m -- foreign_keys("ci_sources_pipelines") [0m -> 0.0030s [0m -- foreign_keys("design_management_designs") [0m -> 0.0030s [0m -- foreign_keys("design_management_designs") [0m -> 0.0028s [0m -- foreign_keys("design_management_designs_versions") [0m -> 0.0028s [0m -- foreign_keys("design_management_designs_versions") [0m -> 0.0030s [0m -- foreign_keys("draft_notes") [0m -> 0.0028s [0m -- foreign_keys("draft_notes") [0m -> 0.0029s [0m -- foreign_keys("elasticsearch_indexed_namespaces") [0m -> 0.0027s [0m -- foreign_keys("elasticsearch_indexed_projects") [0m -> 0.0028s [0m -- foreign_keys("epic_issues") [0m -> 0.0030s [0m -- foreign_keys("epic_issues") [0m -> 0.0027s [0m -- foreign_keys("epic_metrics") [0m -> 0.0026s [0m -- foreign_keys("epics") [0m -> 0.0029s [0m -- foreign_keys("epics") [0m -> 0.0029s [0m -- foreign_keys("epics") [0m -> 0.0028s [0m -- foreign_keys("epics") [0m -> 0.0029s [0m -- foreign_keys("epics") [0m -> 0.0029s [0m -- foreign_keys("epics") [0m -> 0.0029s [0m -- foreign_keys("geo_event_log") [0m -> 0.0031s [0m -- foreign_keys("geo_event_log") [0m -> 0.0029s [0m -- foreign_keys("geo_event_log") [0m -> 0.0030s [0m -- foreign_keys("geo_event_log") [0m -> 0.0028s [0m -- foreign_keys("geo_event_log") [0m -> 0.0028s [0m -- foreign_keys("geo_event_log") [0m -> 0.0028s [0m -- foreign_keys("geo_event_log") [0m -> 0.0028s [0m -- foreign_keys("geo_event_log") [0m -> 0.0028s [0m -- foreign_keys("geo_event_log") [0m -> 0.0030s [0m -- foreign_keys("geo_event_log") [0m -> 0.0030s [0m -- foreign_keys("geo_event_log") [0m -> 0.0029s [0m -- foreign_keys("geo_hashed_storage_attachments_events") [0m -> 0.0028s [0m -- foreign_keys("geo_hashed_storage_migrated_events") [0m -> 0.0028s [0m -- foreign_keys("geo_node_namespace_links") [0m -> 0.0028s [0m -- foreign_keys("geo_node_namespace_links") [0m -> 0.0028s [0m -- foreign_keys("geo_node_statuses") [0m -> 0.0028s [0m -- foreign_keys("geo_repositories_changed_events") [0m -> 0.0027s [0m -- foreign_keys("geo_repository_created_events") [0m -> 0.0028s [0m -- foreign_keys("geo_repository_renamed_events") [0m -> 0.0027s [0m -- foreign_keys("geo_repository_updated_events") [0m -> 0.0033s [0m -- foreign_keys("geo_reset_checksum_events") [0m -> 0.0029s [0m -- foreign_keys("gitlab_subscriptions") [0m -> 0.0048s [0m -- foreign_keys("gitlab_subscriptions") [0m -> 0.0052s [0m -- foreign_keys("identities") [0m -> 0.0055s [0m -- foreign_keys("index_statuses") [0m -> 0.0053s [0m -- foreign_keys("insights") [0m -> 0.0052s [0m -- foreign_keys("insights") [0m -> 0.0040s [0m -- foreign_keys("issue_links") [0m -> 0.0033s [0m -- foreign_keys("issue_links") [0m -> 0.0039s [0m -- foreign_keys("lists") [0m -> 0.0046s [0m -- foreign_keys("lists") [0m -> 0.0046s [0m -- foreign_keys("namespace_statistics") [0m -> 0.0040s [0m -- foreign_keys("namespaces") [0m -> 0.0032s [0m -- foreign_keys("namespaces") [0m -> 0.0029s [0m -- foreign_keys("namespaces") [0m -> 0.0029s [0m -- foreign_keys("notes") [0m -> 0.0028s [0m -- foreign_keys("operations_feature_flag_scopes") [0m -> 0.0027s [0m -- foreign_keys("operations_feature_flags") [0m -> 0.0027s [0m -- foreign_keys("operations_feature_flags_clients") [0m -> 0.0027s [0m -- foreign_keys("packages_maven_metadata") [0m -> 0.0029s [0m -- foreign_keys("packages_package_files") [0m -> 0.0026s [0m -- foreign_keys("packages_packages") [0m -> 0.0027s [0m -- foreign_keys("path_locks") [0m -> 0.0028s [0m -- foreign_keys("path_locks") [0m -> 0.0027s [0m -- foreign_keys("project_alerting_settings") [0m -> 0.0026s [0m -- foreign_keys("project_feature_usages") [0m -> 0.0026s [0m -- foreign_keys("project_incident_management_settings") [0m -> 0.0026s [0m -- foreign_keys("project_repository_states") [0m -> 0.0025s [0m -- foreign_keys("project_tracing_settings") [0m -> 0.0025s [0m -- foreign_keys("prometheus_alert_events") [0m -> 0.0026s [0m -- foreign_keys("prometheus_alert_events") [0m -> 0.0026s [0m -- foreign_keys("prometheus_alerts") [0m -> 0.0029s [0m -- foreign_keys("prometheus_alerts") [0m -> 0.0026s [0m -- foreign_keys("prometheus_alerts") [0m -> 0.0026s [0m -- foreign_keys("protected_branch_merge_access_levels") [0m -> 0.0026s [0m -- foreign_keys("protected_branch_merge_access_levels") [0m -> 0.0026s [0m -- foreign_keys("protected_branch_push_access_levels") [0m -> 0.0028s [0m -- foreign_keys("protected_branch_push_access_levels") [0m -> 0.0027s [0m -- foreign_keys("protected_branch_unprotect_access_levels") [0m -> 0.0027s [0m -- foreign_keys("protected_branch_unprotect_access_levels") [0m -> 0.0026s [0m -- foreign_keys("protected_branch_unprotect_access_levels") [0m -> 0.0026s [0m -- foreign_keys("protected_environment_deploy_access_levels") [0m -> 0.0026s [0m -- foreign_keys("protected_environment_deploy_access_levels") [0m -> 0.0027s [0m -- foreign_keys("protected_environment_deploy_access_levels") [0m -> 0.0026s [0m -- foreign_keys("protected_environments") [0m -> 0.0026s [0m -- foreign_keys("push_rules") [0m -> 0.0026s [0m -- foreign_keys("resource_label_events") [0m -> 0.0027s [0m -- foreign_keys("reviews") [0m -> 0.0027s [0m -- foreign_keys("reviews") [0m -> 0.0027s [0m -- foreign_keys("reviews") [0m -> 0.0026s [0m -- foreign_keys("saml_providers") [0m -> 0.0026s [0m -- foreign_keys("scim_oauth_access_tokens") [0m -> 0.0025s [0m -- foreign_keys("slack_integrations") [0m -> 0.0025s [0m -- foreign_keys("smartcard_identities") [0m -> 0.0026s [0m -- foreign_keys("software_license_policies") [0m -> 0.0029s [0m -- foreign_keys("software_license_policies") [0m -> 0.0026s [0m -- foreign_keys("users") [0m -> 0.0026s [0m -- foreign_keys("users_ops_dashboard_projects") [0m -> 0.0026s [0m -- foreign_keys("users_ops_dashboard_projects") [0m -> 0.0026s [0m -- foreign_keys("vulnerability_feedback") [0m -> 0.0027s [0m -- foreign_keys("vulnerability_feedback") [0m -> 0.0030s [0m -- foreign_keys("vulnerability_feedback")rake aborted! [0m StandardError: An error has occurred, all later migrations canceled: [0m
[0m PG::UndefinedColumn: ERROR: column "merge_request_id" referenced in foreign key constraint does not exist [0m : ALTER TABLE vulnerability_feedback [0m ADD CONSTRAINT fk_563ff1912e [0m FOREIGN KEY (merge_request_id) [0m REFERENCES merge_requests (id) [0m ON DELETE SET NULL [0m NOT VALID; [0m /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:192:inadd_concurrent_foreign_key' [0m /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20190402150158_backport_enterprise_schema.rb:235:in
add_concurrent_foreign_key' [0m /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20190402150158_backport_enterprise_schema.rb:1976:inadd_missing_foreign_keys' [0m /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20190402150158_backport_enterprise_schema.rb:147:in
up' [0m /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:56:inblock (3 levels) in <top (required)>' [0m /opt/gitlab/embedded/bin/bundle:23:in
load' [0m /opt/gitlab/embedded/bin/bundle:23:in<main>' [0m [0m Caused by: [0m ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR: column "merge_request_id" referenced in foreign key constraint does not exist [0m : ALTER TABLE vulnerability_feedback [0m ADD CONSTRAINT fk_563ff1912e [0m FOREIGN KEY (merge_request_id) [0m REFERENCES merge_requests (id) [0m ON DELETE SET NULL [0m NOT VALID; [0m /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:192:in
add_concurrent_foreign_key' [0m /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20190402150158_backport_enterprise_schema.rb:235:inadd_concurrent_foreign_key' [0m /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20190402150158_backport_enterprise_schema.rb:1976:in
add_missing_foreign_keys' [0m /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20190402150158_backport_enterprise_schema.rb:147:inup' [0m /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:56:in
block (3 levels) in <top (required)>' [0m /opt/gitlab/embedded/bin/bundle:23:inload' [0m /opt/gitlab/embedded/bin/bundle:23:in
' [0m
[0m Caused by: [0m PG::UndefinedColumn: ERROR: column "merge_request_id" referenced in foreign key constraint does not exist [0m /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:192:inadd_concurrent_foreign_key' [0m /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20190402150158_backport_enterprise_schema.rb:235:in
add_concurrent_foreign_key' [0m /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20190402150158_backport_enterprise_schema.rb:1976:inadd_missing_foreign_keys' [0m /opt/gitlab/embedded/service/gitlab-rails/db/migrate/20190402150158_backport_enterprise_schema.rb:147:in
up' [0m /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:56:inblock (3 levels) in <top (required)>' [0m /opt/gitlab/embedded/bin/bundle:23:in
load' [0m /opt/gitlab/embedded/bin/bundle:23:in `' [0m Tasks: TOP => db:migrate [0m (See full trace by running task with --trace) [0m
[0m -> 0.0067s [0m -- transaction_open?() [0m -> 0.0000s [0m -- foreign_keys("vulnerability_feedback") [0m -> 0.0034s [0m -- execute("ALTER TABLE vulnerability_feedback\nADD CONSTRAINT fk_563ff1912e\nFOREIGN KEY (merge_request_id)\nREFERENCES merge_requests (id)\nON DELETE SET NULL\nNOT VALID;\n") [0m STDERR: [0m ---- End output of "bash" "/tmp/chef-script20190624-6157-4f6unv" ---- [0m Ran "bash" "/tmp/chef-script20190624-6157-4f6unv" returned 1[0m[0m Resource Declaration:[0m ---------------------[0m # In /opt/gitlab/embedded/cookbooks/cache/cookbooks/gitlab/recipes/database_migrations.rb [0m
[0m 53: bash "migrate gitlab-rails database" do [0m 54: code <<-EOH [0m 55: set -e [0m 56: log_file="#{node['gitlab']['gitlab-rails']['log_directory']}/gitlab-rails-db-migrate-$(date +%Y-%m-%d-%H-%M-%S).log" [0m 57: umask 077 [0m 58: /opt/gitlab/bin/gitlab-rake gitlab:db:configure 2>& 1 | tee ${log_file} [0m 59: STATUS=${PIPESTATUS[0]} [0m 60: echo $STATUS > #{db_migrate_status_file} [0m 61: exit $STATUS [0m 62: EOH [0m 63: environment env_variables unless env_variables.empty? [0m 64: notifies :run, "execute[clear the gitlab-rails cache]", :immediately [0m 65: dependent_services.each do |svc| [0m 66: notifies :restart, svc, :immediately [0m 67: end [0m 68: not_if "(test -f #{db_migrate_status_file}) && (cat #{db_migrate_status_file} | grep -Fx 0)" [0m 69: only_if { node['gitlab']['gitlab-rails']['auto_migrate'] } [0m 70: end [0m
[0m Compiled Resource:[0m ------------------[0m # Declared in /opt/gitlab/embedded/cookbooks/cache/cookbooks/gitlab/recipes/database_migrations.rb:53:in `from_file' [0m
[0m bash("migrate gitlab-rails database") do [0m action [:run] [0m default_guard_interpreter :default [0m command nil [0m backup 5 [0m returns 0 [0m user nil [0m interpreter "bash" [0m declared_type :bash [0m cookbook_name "gitlab" [0m recipe_name "database_migrations" [0m code " set -e\n log_file="/var/log/gitlab/gitlab-rails/gitlab-rails-db-migrate-$(date +%Y-%m-%d-%H-%M-%S).log"\n umask 077\n /opt/gitlab/bin/gitlab-rake gitlab:db:configure 2>& 1 | tee ${log_file}\n STATUS=${PIPESTATUS[0]}\n echo $STATUS > /var/opt/gitlab/gitlab-rails/upgrade-status/db-migrate-873248b1f0d3a7a5535771a3a1635803-f47c7d00472\n exit $STATUS\n" [0m domain nil [0m not_if "(test -f /var/opt/gitlab/gitlab-rails/upgrade-status/db-migrate-873248b1f0d3a7a5535771a3a1635803-f47c7d00472) && (cat /var/opt/gitlab/gitlab-rails/upgrade-status/db-migrate-873248b1f0d3a7a5535771a3a1635803-f47c7d00472 | grep -Fx 0)" [0m only_if { #code block } [0m end [0m
[0m System Info:[0m ------------[0m chef_version=13.6.4 [0m platform=ubuntu [0m platform_version=18.04 [0m ruby=ruby 2.6.3p62 (2019-04-16 revision 67580) [x86_64-linux] [0m program_name=/opt/gitlab/embedded/bin/chef-client [0m executable=/opt/gitlab/embedded/bin/chef-client[0m[0m[0m Running handlers:[0m Running handlers complete [0mChef Client failed. 1 resources updated in 22 seconds[0m
Details of package version
Provide the package version installation details
Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad) ||/ Name Version Architecture Description +++-====================================================-===============================-===============================-============================================================================================================== ii gitlab-ce 12.0.0-ce.0 amd64 GitLab Community Edition (including NGINX, Postgres, Redis) rc gitlab-ee 11.7.0-ee.0 amd64 GitLab Enterprise Edition (including NGINX, Postgres, Redis)
Environment details
- Operating System:
Ubuntu 18.04
- Installation Target, remove incorrect values:
- VM: Internal to our company
- Installation Type, remove incorrect values:
- Upgrade from version
11.10.4
to12.0.0
- Upgrade from version
- Is there any other software running on the machine:
No
- Is this a single or multiple node installation?
Single
- Resources
- CPU:
8 vCPU
- Memory total:
16GB
- CPU:
Configuration details
Provide the relevant sections of `/etc/gitlab/gitlab.rb`
gitlab_rails['time_zone'] = "UTC" gitlab_rails['backup_keep_time'] = 604800 gitlab_rails['gitlab_email_enabled'] = true gitlab_rails['gitlab_default_theme'] = "2" nginx['redirect_http_to_https'] = false nginx['ssl_certificate'] = "/etc/gitlab/ssl/gitlab.crt" nginx['ssl_certificate_key'] = "/etc/gitlab/ssl/gitlab.key" git_data_dirs({"default" => {"path" => "/var/git"} }) gitlab_rails['backup_path'] = "/repo_backups" gitlab_rails['ldap_enabled'] = false gitlab_rails['ldap_host'] = 'example.com' gitlab_rails['ldap_port'] = 389 gitlab_rails['ldap_uid'] = 'sAMAccountName' gitlab_rails['ldap_method'] = 'plain' # 'ssl' or 'plain' gitlab_rails['ldap_bind_dn'] = 'CN=Username,CN=Users,DC=example,DC=com' gitlab_rails['ldap_password'] = 'password' gitlab_rails['ldap_allow_username_or_email_login'] = true gitlab_rails['ldap_base'] = 'DC=example,DC=com' gitlab_rails['smtp_enable'] = true gitlab_rails['smtp_address'] = 'smtp.office365.com' gitlab_rails['smtp_port'] = 587 gitlab_rails['smtp_user_name'] = '###' gitlab_rails['smtp_password'] = '###' gitlab_rails['smtp_domain'] = '###' gitlab_rails['smtp_authentication'] = 'login' gitlab_rails['smtp_enable_starttls_auto'] = true gitlab_rails['smtp_tls'] = false gitlab_rails['smtp_openssl_verify_mode'] = 'peer' gitlab_rails['smtp_ca_path'] = '/etc/ssl/certs' gitlab_rails['smtp_ca_file'] = '/etc/ssl/certs/ca-certificates.crt' gitlab_rails['gitlab_email_from'] = '###' gitlab_rails['pipeline_schedule_worker_cron'] = "* * * * *"