Upgrade from 11.11.5 to 12.0.0 Omnibus

Summary

(Summarize the bug encountered concisely)

When upgrading from 11.11.5 to 12.0.0 using apt upgrade I see a failure that generates enough of a log it scrolls off the screen.

If I look in the logs the first problem I encounter is:

Caused by:
ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR:  column "cache_invalidation_event_id" referenced in foreign key constraint does not exist

Steps to reproduce

(How one can reproduce the issue - this is very important)

My installation hadn't been upgraded for a while due to proxy issues. When I resolved them apt immediately went to upgrade from 11.11.2 to 12.1.1.

I rolled this back to 11.11.2 and began using apt pinning to progress one version at a time until I got to the top of the 11.11's to 11.11.5 - which worked fine.

Now when I try to move up to 12.0.0 it fails.

I suspect that it may be related to a very early error I captured:

Running handlers:
There was an error running gitlab-ctl reconfigure:

bash[migrate gitlab-rails database] (gitlab::database_migrations line 53) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'
---- Begin output of "bash"  "/tmp/chef-script20190725-6314-r2i87k" ----
STDOUT: rake aborted!
Exception: Your database is missing the 'cache_invalidation_event_id' column from the 'geo_event_log' table that is present for GitLab EE.
Even though it looks like you're running a CE installation, it appears
you may have installed GitLab EE at some point. To migrate to GitLab 12.0:

1. Install GitLab 11.11.3 EE
2. Install GitLab 12.0.x CE

It was a while ago but I seem to recall that we may have install EE initially.

Example Project

(If possible, please create an example project here on GitLab.com that exhibits the problematic behavior, and link to it here in the bug report)

(If you are using an older version of GitLab, this will also determine whether the bug is fixed in a more recent version)

What is the current bug behavior?

(What actually happens)

What is the expected correct behavior?

(What you should see instead)

Upgrade to succeed.

Relevant logs and/or screenshots

(Paste any relevant logs - please use code blocks (```) to format console output, logs, and code as it's tough to read otherwise.)

1564056078.log

# Logfile created on 2019-07-25 13:01:18 +0100 by logger.rb/66358
[2019-07-25T13:01:19+01:00] INFO: Started chef-zero at chefzero://localhost:1 with repository at /opt/gitlab/embedded
  One version per cookbook
[2019-07-25T13:01:19+01:00] INFO: *** Chef 13.6.4 ***
[2019-07-25T13:01:19+01:00] INFO: Platform: x86_64-linux
[2019-07-25T13:01:19+01:00] INFO: Chef-client pid: 27337
[2019-07-25T13:01:19+01:00] INFO: The plugin path /etc/chef/ohai/plugins does not exist. Skipping...
[2019-07-25T13:01:20+01:00] INFO: Setting the run_list to ["recipe[gitlab]"] from CLI options
[2019-07-25T13:01:20+01:00] INFO: Run List is [recipe[gitlab]]
[2019-07-25T13:01:20+01:00] INFO: Run List expands to [gitlab]
[2019-07-25T13:01:20+01:00] INFO: Starting Chef Run for gitlab.charnwood.local
[2019-07-25T13:01:20+01:00] INFO: Running start handlers
[2019-07-25T13:01:20+01:00] INFO: Start handlers complete.
[2019-07-25T13:01:22+01:00] INFO: Loading cookbooks [gitlab@0.0.1, package@0.1.0, postgresql@0.1.0, redis@0.1.0, registry@0.1.0, mattermost@0.1.0, consul@0.1.0, gitaly@0.1.0, letsencrypt@0.1.0, nginx@0.1.0, runit@4.3.0, acme@3.1.0, crond@0.1.0, compat_resource@12.19.1]
[2019-07-25T13:01:26+01:00] WARN: Selected systemd because systemctl shows .mount units
[2019-07-25T13:01:28+01:00] INFO: The plugin path /etc/chef/ohai/plugins does not exist. Skipping...
[2019-07-25T13:01:29+01:00] INFO: template[/var/opt/gitlab/gitlab-shell/config.yml] backed up to /opt/gitlab/embedded/cookbooks/cache/backup/var/opt/gitlab/gitlab-shell/config.yml.chef-20190725130129.139163
[2019-07-25T13:01:29+01:00] INFO: template[/var/opt/gitlab/gitlab-shell/config.yml] removed backup at /opt/gitlab/embedded/cookbooks/cache/backup/var/opt/gitlab/gitlab-shell/config.yml.chef-20180514115618.181689
[2019-07-25T13:01:29+01:00] INFO: template[/var/opt/gitlab/gitlab-shell/config.yml] updated file contents /var/opt/gitlab/gitlab-shell/config.yml
[2019-07-25T13:01:29+01:00] INFO: execute[/opt/gitlab/embedded/service/gitlab-shell/bin/gitlab-keys check-permissions] ran successfully
[2019-07-25T13:01:29+01:00] INFO: template[/var/opt/gitlab/gitlab-rails/etc/gitlab.yml] backed up to /opt/gitlab/embedded/cookbooks/cache/backup/var/opt/gitlab/gitlab-rails/etc/gitlab.yml.chef-20190725130129.866348
[2019-07-25T13:01:29+01:00] INFO: template[/var/opt/gitlab/gitlab-rails/etc/gitlab.yml] removed backup at /opt/gitlab/embedded/cookbooks/cache/backup/var/opt/gitlab/gitlab-rails/etc/gitlab.yml.chef-20190219110530.496583
[2019-07-25T13:01:29+01:00] INFO: template[/var/opt/gitlab/gitlab-rails/etc/gitlab.yml] updated file contents /var/opt/gitlab/gitlab-rails/etc/gitlab.yml
[2019-07-25T13:01:29+01:00] INFO: file[/opt/gitlab/etc/gitlab-rails/env/PYTHONPATH] backed up to /opt/gitlab/embedded/cookbooks/cache/backup/opt/gitlab/etc/gitlab-rails/env/PYTHONPATH.chef-20190725130129.931051
[2019-07-25T13:01:29+01:00] INFO: file[/opt/gitlab/etc/gitlab-rails/env/PYTHONPATH] updated file contents /opt/gitlab/etc/gitlab-rails/env/PYTHONPATH
[2019-07-25T13:01:29+01:00] INFO: link[/var/log/gitlab/gitlab-rails/sidekiq.log] created
[2019-07-25T13:01:29+01:00] INFO: file[/opt/gitlab/embedded/service/gitlab-rails/db/schema.rb] owner changed to 998
[2019-07-25T13:01:29+01:00] INFO: remote_file[/var/opt/gitlab/gitlab-rails/VERSION] backed up to /opt/gitlab/embedded/cookbooks/cache/backup/var/opt/gitlab/gitlab-rails/VERSION.chef-20190725130129.949641
[2019-07-25T13:01:29+01:00] INFO: remote_file[/var/opt/gitlab/gitlab-rails/VERSION] removed backup at /opt/gitlab/embedded/cookbooks/cache/backup/var/opt/gitlab/gitlab-rails/VERSION.chef-20190605154006.778977
[2019-07-25T13:01:29+01:00] INFO: remote_file[/var/opt/gitlab/gitlab-rails/VERSION] updated file contents /var/opt/gitlab/gitlab-rails/VERSION
[2019-07-25T13:01:29+01:00] INFO: remote_file[/var/opt/gitlab/gitlab-rails/REVISION] backed up to /opt/gitlab/embedded/cookbooks/cache/backup/var/opt/gitlab/gitlab-rails/REVISION.chef-20190725130129.954048
[2019-07-25T13:01:29+01:00] INFO: remote_file[/var/opt/gitlab/gitlab-rails/REVISION] removed backup at /opt/gitlab/embedded/cookbooks/cache/backup/var/opt/gitlab/gitlab-rails/REVISION.chef-20190605154006.788627
[2019-07-25T13:01:29+01:00] INFO: remote_file[/var/opt/gitlab/gitlab-rails/REVISION] updated file contents /var/opt/gitlab/gitlab-rails/REVISION
[2019-07-25T13:01:29+01:00] INFO: file[/var/opt/gitlab/gitlab-rails/RUBY_VERSION] backed up to /opt/gitlab/embedded/cookbooks/cache/backup/var/opt/gitlab/gitlab-rails/RUBY_VERSION.chef-20190725130129.958056
[2019-07-25T13:01:29+01:00] INFO: file[/var/opt/gitlab/gitlab-rails/RUBY_VERSION] removed backup at /opt/gitlab/embedded/cookbooks/cache/backup/var/opt/gitlab/gitlab-rails/RUBY_VERSION.chef-20180523080459.124752
[2019-07-25T13:01:29+01:00] INFO: file[/var/opt/gitlab/gitlab-rails/RUBY_VERSION] updated file contents /var/opt/gitlab/gitlab-rails/RUBY_VERSION
[2019-07-25T13:01:30+01:00] INFO: ruby_block[Move existing certs and link to /opt/gitlab/embedded/ssl/certs] called
[2019-07-25T13:01:30+01:00] INFO: file[/opt/gitlab/etc/gitaly/env/PYTHONPATH] backed up to /opt/gitlab/embedded/cookbooks/cache/backup/opt/gitlab/etc/gitaly/env/PYTHONPATH.chef-20190725130130.236410
[2019-07-25T13:01:30+01:00] INFO: file[/opt/gitlab/etc/gitaly/env/PYTHONPATH] updated file contents /opt/gitlab/etc/gitaly/env/PYTHONPATH
[2019-07-25T13:01:30+01:00] INFO: file[/opt/gitlab/etc/gitaly/env/WRAPPER_JSON_LOGGING] backed up to /opt/gitlab/embedded/cookbooks/cache/backup/opt/gitlab/etc/gitaly/env/WRAPPER_JSON_LOGGING.chef-20190725130130.248916
[2019-07-25T13:01:30+01:00] INFO: file[/opt/gitlab/etc/gitaly/env/WRAPPER_JSON_LOGGING] updated file contents /opt/gitlab/etc/gitaly/env/WRAPPER_JSON_LOGGING
[2019-07-25T13:01:30+01:00] INFO: template[Create Gitaly config.toml] backed up to /opt/gitlab/embedded/cookbooks/cache/backup/var/opt/gitlab/gitaly/config.toml.chef-20190725130130.255810
[2019-07-25T13:01:30+01:00] INFO: template[Create Gitaly config.toml] removed backup at /opt/gitlab/embedded/cookbooks/cache/backup/var/opt/gitlab/gitaly/config.toml.chef-20180111090249.500874
[2019-07-25T13:01:30+01:00] INFO: template[Create Gitaly config.toml] updated file contents /var/opt/gitlab/gitaly/config.toml
[2019-07-25T13:01:30+01:00] INFO: template[/opt/gitlab/sv/gitaly/log/run] backed up to /opt/gitlab/embedded/cookbooks/cache/backup/opt/gitlab/sv/gitaly/log/run.chef-20190725130130.284577
[2019-07-25T13:01:30+01:00] INFO: template[/opt/gitlab/sv/gitaly/log/run] updated file contents /opt/gitlab/sv/gitaly/log/run
[2019-07-25T13:01:30+01:00] INFO: template[/opt/gitlab/sv/gitaly/log/run] sending create action to ruby_block[restart_log_service] (delayed)
[2019-07-25T13:01:30+01:00] INFO: ruby_block[restart_log_service] called
[2019-07-25T13:01:30+01:00] INFO: file[/var/opt/gitlab/gitaly/VERSION] backed up to /opt/gitlab/embedded/cookbooks/cache/backup/var/opt/gitlab/gitaly/VERSION.chef-20190725130130.786611
[2019-07-25T13:01:30+01:00] INFO: file[/var/opt/gitlab/gitaly/VERSION] removed backup at /opt/gitlab/embedded/cookbooks/cache/backup/var/opt/gitlab/gitaly/VERSION.chef-20190605154007.284863
[2019-07-25T13:01:30+01:00] INFO: file[/var/opt/gitlab/gitaly/VERSION] updated file contents /var/opt/gitlab/gitaly/VERSION
[2019-07-25T13:01:30+01:00] INFO: file[/var/opt/gitlab/gitaly/VERSION] not queuing delayed action hup on runit_service[gitaly] (delayed), as it's already been queued
[2019-07-25T13:01:30+01:00] INFO: file[/opt/gitlab/sv/postgresql/supervise/status] owner changed to 996
[2019-07-25T13:01:30+01:00] INFO: file[/opt/gitlab/sv/postgresql/supervise/status] group changed to 996
[2019-07-25T13:01:30+01:00] INFO: file[/opt/gitlab/sv/postgresql/supervise/status] updated atime and mtime to 2019-07-25 13:01:30 +0100
[2019-07-25T13:01:59+01:00] INFO: Running queued delayed notifications before re-raising exception
[2019-07-25T13:01:59+01:00] INFO: templatesymlink[Create a gitlab.yml and create a symlink to Rails root] sending run action to execute[clear the gitlab-rails cache] (delayed)
[2019-07-25T13:02:18+01:00] INFO: execute[clear the gitlab-rails cache] ran successfully
[2019-07-25T13:02:18+01:00] INFO: env_dir[/opt/gitlab/etc/gitaly/env] sending restart action to service[gitaly] (delayed)
[2019-07-25T13:02:19+01:00] INFO: service[gitaly] restarted
[2019-07-25T13:02:19+01:00] INFO: template[Create Gitaly config.toml] sending hup action to runit_service[gitaly] (delayed)
[2019-07-25T13:02:19+01:00] INFO: runit_service[gitaly] signalled (HUP)
[2019-07-25T13:02:19+01:00] INFO: runit_service[gitaly] sent hup
[2019-07-25T13:02:19+01:00] ERROR: Running exception handlers
[2019-07-25T13:02:19+01:00] ERROR: Exception handlers complete
[2019-07-25T13:02:19+01:00] FATAL: Stacktrace dumped to /opt/gitlab/embedded/cookbooks/cache/chef-stacktrace.out
[2019-07-25T13:02:19+01:00] FATAL: Please provide the contents of the stacktrace.out file if you file a bug report
[2019-07-25T13:02:19+01:00] FATAL: Mixlib::ShellOut::ShellCommandFailed: bash[migrate gitlab-rails database] (gitlab::database_migrations line 53) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'
---- Begin output of "bash"  "/tmp/chef-script20190725-27337-17g71bc" ----
STDOUT: == 20190327163904 AddNotificationEmailToNotificationSettings: migrating =======
-- add_column(:notification_settings, :notification_email, :string)
-> 0.1745s
== 20190327163904 AddNotificationEmailToNotificationSettings: migrated (0.1747s)
== 20190402150158 BackportEnterpriseSchema: migrating =========================
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("approval_merge_request_rule_sources", {:id=>:bigserial})
-> 0.4854s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("approval_merge_request_rules", {:id=>:bigserial})
-> 0.0805s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("approval_merge_request_rules_approved_approvers", {:id=>:bigserial})
-> 0.0522s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("approval_merge_request_rules_groups", {:id=>:bigserial})
-> 0.1066s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("approval_merge_request_rules_users", {:id=>:bigserial})
-> 0.0548s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0002s
-- create_table("approval_project_rules", {:id=>:bigserial})
-> 0.0816s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("approval_project_rules_groups", {:id=>:bigserial})
-> 0.0446s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("approval_project_rules_users", {:id=>:bigserial})
-> 0.0462s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("board_assignees", {:id=>:integer})
-> 0.0451s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("board_labels", {:id=>:integer})
-> 0.1225s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("design_management_designs", {:id=>:bigserial, :force=>:cascade})
-> 0.1056s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("design_management_designs_versions", {:id=>false, :force=>:cascade})
-> 0.0593s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("design_management_versions", {:id=>:bigserial, :force=>:cascade})
-> 0.0456s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("draft_notes", {:id=>:bigserial})
-> 0.0695s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("elasticsearch_indexed_namespaces", {:id=>false})
-> 0.0160s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("elasticsearch_indexed_projects", {:id=>false})
-> 0.0177s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("epic_issues", {:id=>:integer})
-> 0.0476s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("epic_metrics", {:id=>:integer})
-> 0.0478s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("epics", {:id=>:integer})
-> 0.1971s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("geo_cache_invalidation_events", {:id=>:bigserial})
-> 0.0375s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("geo_hashed_storage_attachments_events", {:id=>:bigserial})
-> 0.0437s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("geo_hashed_storage_migrated_events", {:id=>:bigserial})
-> 0.0756s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("geo_job_artifact_deleted_events", {:id=>:bigserial})
-> 0.0424s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("geo_lfs_object_deleted_events", {:id=>:bigserial})
-> 0.0422s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("geo_node_statuses", {:id=>:integer})
-> 0.0503s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("geo_reset_checksum_events", {:id=>:bigserial})
-> 0.0296s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("geo_upload_deleted_events", {:id=>:bigserial})
-> 0.0435s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("gitlab_subscriptions", {:id=>:bigserial})
-> 0.0482s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("insights", {:id=>:integer})
-> 0.0467s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("jira_connect_installations", {:id=>:bigserial})
-> 0.0493s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("jira_connect_subscriptions", {:id=>:bigserial})
-> 0.0573s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("operations_feature_flag_scopes", {:id=>:bigserial})
-> 0.0447s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("operations_feature_flags", {:id=>:bigserial})
-> 0.0414s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("operations_feature_flags_clients", {:id=>:bigserial})
-> 0.0406s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("packages_maven_metadata", {:id=>:bigserial})
-> 0.0416s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("packages_package_files", {:id=>:bigserial})
-> 0.0463s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("packages_packages", {:id=>:bigserial})
-> 0.0424s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("project_alerting_settings", {:primary_key=>"project_id", :id=>:integer, :default=>nil})
-> 0.0264s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("project_feature_usages", {:primary_key=>"project_id", :id=>:integer, :default=>nil})
-> 0.0582s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("project_incident_management_settings", {:primary_key=>"project_id", :id=>:integer, :default=>nil})
-> 0.0276s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("project_repository_states", {:id=>:integer})
-> 0.1286s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("project_tracing_settings", {:id=>:bigserial})
-> 0.0537s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("prometheus_alert_events", {:id=>:bigserial})
-> 0.0574s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("prometheus_alerts", {:id=>:integer})
-> 0.0615s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("protected_branch_unprotect_access_levels", {:id=>:integer})
-> 0.0594s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("protected_environment_deploy_access_levels", {:id=>:integer})
-> 0.0703s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("protected_environments", {:id=>:integer})
-> 0.0650s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("reviews", {:id=>:bigserial})
-> 0.0746s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("saml_providers", {:id=>:integer})
-> 0.0442s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("scim_oauth_access_tokens", {:id=>:integer})
-> 0.0438s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("smartcard_identities", {:id=>:bigserial})
-> 0.0716s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("software_license_policies", {:id=>:integer})
-> 0.0446s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("software_licenses", {:id=>:integer})
-> 0.0475s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("users_ops_dashboard_projects", {:id=>:bigserial})
-> 0.0639s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("vulnerability_feedback", {:id=>:integer})
-> 0.1200s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("vulnerability_identifiers", {:id=>:bigserial})
-> 0.0492s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("vulnerability_occurrence_identifiers", {:id=>:bigserial})
-> 0.0662s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("vulnerability_occurrence_pipelines", {:id=>:bigserial})
-> 0.0467s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("vulnerability_occurrences", {:id=>:bigserial})
-> 0.0970s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("vulnerability_scanners", {:id=>:bigserial})
-> 0.0514s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("dependency_proxy_blobs", {:id=>:serial})
-> 0.0421s
-- adapter_name()
-> 0.0000s
-- adapter_name()
-> 0.0000s
-- create_table("dependency_proxy_group_settings", {:id=>:serial})
-> 0.0315s
-- column_exists?(:appearances, :updated_by)
-> 0.0020s
-- change_column_null(:application_settings, :password_authentication_enabled_for_git, false)
-> 0.0119s
-- change_table(:application_settings, {})
-> 0.8052s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:application_settings, :custom_project_templates_group_id, {:algorithm=>:concurrently})
-> 0.0026s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:application_settings, :custom_project_templates_group_id, {:algorithm=>:concurrently})
-> 0.0079s
-- execute("RESET ALL")
-> 0.0003s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:application_settings, :file_template_project_id, {:algorithm=>:concurrently})
-> 0.0024s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- add_index(:application_settings, :file_template_project_id, {:algorithm=>:concurrently})
-> 0.0089s
-- execute("RESET ALL")
-> 0.0002s
-- column_exists?(:boards, :milestone_id)
-> 0.0018s
-- column_exists?(:boards, :weight)
-> 0.0013s
-- add_column(:boards, :weight, :integer)
-> 0.0065s
-- column_exists?(:boards, :name)
-> 0.0014s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:boards, :milestone_id, {:algorithm=>:concurrently})
-> 0.0022s
-- column_exists?(:clusters_applications_prometheus, :encrypted_alert_manager_token)
-> 0.0016s
-- add_column(:clusters_applications_prometheus, :encrypted_alert_manager_token, :string)
-> 0.0084s
-- column_exists?(:clusters_applications_prometheus, :encrypted_alert_manager_token_iv)
-> 0.0016s
-- add_column(:clusters_applications_prometheus, :encrypted_alert_manager_token_iv, :string)
-> 0.0011s
-- column_exists?(:clusters_applications_prometheus, :last_update_started_at)
-> 0.0015s
-- add_column(:clusters_applications_prometheus, :last_update_started_at, :datetime_with_timezone)
-> 0.0010s
-- column_exists?(:identities, :saml_provider_id)
-> 0.0013s
-- add_column(:identities, :saml_provider_id, :integer)
-> 0.0044s
-- column_exists?(:identities, :secondary_extern_uid)
-> 0.0014s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:identities, :saml_provider_id, {:where=>"saml_provider_id IS NOT NULL", :algorithm=>:concurrently})
-> 0.0017s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:identities, :saml_provider_id, {:where=>"saml_provider_id IS NOT NULL", :algorithm=>:concurrently})
-> 0.0171s
-- execute("RESET ALL")
-> 0.0003s
-- column_exists?(:issues, :service_desk_reply_to)
-> 0.0025s
-- column_exists?(:issues, :weight)
-> 0.0021s
-- column_exists?(:lists, :milestone_id)
-> 0.0014s
-- add_column(:lists, :milestone_id, :integer)
-> 0.0111s
-- column_exists?(:lists, :user_id)
-> 0.0021s
-- add_column(:lists, :user_id, :integer)
-> 0.0011s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:lists, :milestone_id, {:algorithm=>:concurrently})
-> 0.0024s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:lists, :milestone_id, {:algorithm=>:concurrently})
-> 0.0077s
-- execute("RESET ALL")
-> 0.0003s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:lists, :user_id, {:algorithm=>:concurrently})
-> 0.0029s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:lists, :user_id, {:algorithm=>:concurrently})
-> 0.0083s
-- execute("RESET ALL")
-> 0.0003s
-- column_exists?(:members, :ldap)
-> 0.0022s
-- column_exists?(:members, :override)
-> 0.0018s
-- column_exists?(:merge_requests, :approvals_before_merge)
-> 0.0033s
-- column_exists?(:notes, :review_id)
-> 0.0021s
-- add_column(:notes, :review_id, :bigint)
-> 0.0015s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:notes, :review_id, {:algorithm=>:concurrently})
-> 0.0055s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:notes, :review_id, {:algorithm=>:concurrently})
-> 0.0075s
-- execute("RESET ALL")
-> 0.0002s
-- 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.0103s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(: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.0190s
-- execute("RESET ALL")
-> 0.0002s
-- index_exists?(:environments, :name, {:name=>"index_environments_on_name_varchar_pattern_ops"})
-> 0.0019s
-- execute("CREATE INDEX CONCURRENTLY index_environments_on_name_varchar_pattern_ops ON environments (name varchar_pattern_ops);")
-> 0.0273s
-- change_table(:namespaces, {})
-> 0.0624s
-- column_exists?(:namespaces, :ldap_sync_status)
-> 0.0027s
-- column_exists?(:namespaces, :membership_lock)
-> 0.0032s
-- indexes(:namespaces)
-> 0.0082s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:namespaces, [:custom_project_templates_group_id, :type], {:where=>"(custom_project_templates_group_id IS NOT NULL)", :algorithm=>:concurrently})
-> 0.0080s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:namespaces, [:custom_project_templates_group_id, :type], {:where=>"(custom_project_templates_group_id IS NOT NULL)", :algorithm=>:concurrently})
-> 0.0087s
-- execute("RESET ALL")
-> 0.0002s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:namespaces, :file_template_project_id, {:algorithm=>:concurrently})
-> 0.0081s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:namespaces, :file_template_project_id, {:algorithm=>:concurrently})
-> 0.0135s
-- execute("RESET ALL")
-> 0.0002s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:namespaces, :ldap_sync_last_successful_update_at, {:algorithm=>:concurrently})
-> 0.0077s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:namespaces, :ldap_sync_last_update_at, {:algorithm=>:concurrently})
-> 0.0075s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:namespaces, :plan_id, {:algorithm=>:concurrently})
-> 0.0078s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:namespaces, :trial_ends_on, {:where=>"(trial_ends_on IS NOT NULL)", :algorithm=>:concurrently})
-> 0.0081s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:namespaces, :trial_ends_on, {:where=>"(trial_ends_on IS NOT NULL)", :algorithm=>:concurrently})
-> 0.0128s
-- execute("RESET ALL")
-> 0.0002s
-- indexes(:namespaces)
-> 0.0095s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:namespaces, [:shared_runners_minutes_limit, :extra_shared_runners_minutes_limit], {:name=>"index_namespaces_on_shared_and_extra_runners_minutes_limit", :algorithm=>:concurrently})
-> 0.0086s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- add_index(:namespaces, [:shared_runners_minutes_limit, :extra_shared_runners_minutes_limit], {:name=>"index_namespaces_on_shared_and_extra_runners_minutes_limit", :algorithm=>:concurrently})
-> 0.0193s
-- execute("RESET ALL")
-> 0.0003s
-- column_exists?(:notification_settings, :new_epic)
-> 0.0022s
-- add_column(:notification_settings, :new_epic, :boolean)
-> 0.0054s
-- change_table(:project_mirror_data, {})
-> 0.0128s
-- column_exists?(:project_mirror_data, :retry_count)
-> 0.0020s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:project_mirror_data, :last_successful_update_at, {:algorithm=>:concurrently})
-> 0.0022s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:project_mirror_data, :last_successful_update_at, {:algorithm=>:concurrently})
-> 0.0151s
-- execute("RESET ALL")
-> 0.0003s
-- 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.0030s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:project_mirror_data, [:next_execution_timestamp, :retry_count], {:name=>"index_mirror_data_on_next_execution_and_retry_count", :algorithm=>:concurrently})
-> 0.0093s
-- execute("RESET ALL")
-> 0.0002s
-- column_exists?(:project_statistics, :shared_runners_seconds)
-> 0.0018s
-- column_exists?(:project_statistics, :shared_runners_seconds_last_reset)
-> 0.0016s
-- change_table(:projects, {})
-> 0.1051s
-- change_column_null(:projects, :merge_requests_rebase_enabled, true)
-> 0.0005s
-- column_exists?(:projects, :mirror)
-> 0.0056s
-- column_exists?(:projects, :mirror_trigger_builds)
-> 0.0053s
-- column_exists?(:projects, :reset_approvals_on_push)
-> 0.0053s
-- column_exists?(:projects, :service_desk_enabled)
-> 0.0067s
-- column_exists?(:projects, :approvals_before_merge)
-> 0.0057s
-- 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.0112s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(: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.0097s
-- execute("RESET ALL")
-> 0.0002s
-- 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.0109s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:projects, [:id, :repository_storage, :last_repository_updated_at], {:name=>"idx_projects_on_repository_storage_last_repository_updated_at", :algorithm=>:concurrently})
-> 0.0100s
-- execute("RESET ALL")
-> 0.0002s
-- 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.0110s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- add_index(: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.0074s
-- execute("RESET ALL")
-> 0.0002s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:projects, :mirror_last_successful_update_at, {:algorithm=>:concurrently})
-> 0.0117s
-- change_column_null(:protected_branch_merge_access_levels, :access_level, true)
-> 0.0004s
-- column_exists?(:protected_branch_merge_access_levels, :group_id)
-> 0.0015s
-- column_exists?(:protected_branch_merge_access_levels, :user_id)
-> 0.0012s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:protected_branch_merge_access_levels, :group_id, {:algorithm=>:concurrently})
-> 0.0018s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:protected_branch_merge_access_levels, :group_id, {:algorithm=>:concurrently})
-> 0.0072s
-- execute("RESET ALL")
-> 0.0003s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:protected_branch_merge_access_levels, :user_id, {:algorithm=>:concurrently})
-> 0.0022s
-- change_column_null(:protected_branch_push_access_levels, :access_level, true)
-> 0.0004s
-- column_exists?(:protected_branch_push_access_levels, :group_id)
-> 0.0013s
-- column_exists?(:protected_branch_push_access_levels, :user_id)
-> 0.0012s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:protected_branch_push_access_levels, :group_id, {:algorithm=>:concurrently})
-> 0.0016s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:protected_branch_push_access_levels, :group_id, {:algorithm=>:concurrently})
-> 0.0078s
-- execute("RESET ALL")
-> 0.0002s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:protected_branch_push_access_levels, :user_id, {:algorithm=>:concurrently})
-> 0.0021s
-- column_exists?(:resource_label_events, :epic_id)
-> 0.0016s
-- add_column(:resource_label_events, :epic_id, :integer)
-> 0.0275s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:resource_label_events, :epic_id, {:algorithm=>:concurrently})
-> 0.0028s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:resource_label_events, :epic_id, {:algorithm=>:concurrently})
-> 0.0171s
-- execute("RESET ALL")
-> 0.0002s
-- column_exists?(:user_preferences, :epic_notes_filter)
-> 0.0017s
-- transaction_open?()
-> 0.0000s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- transaction()
-- add_column(:user_preferences, :epic_notes_filter, :integer, {:default=>nil, :limit=>2})
-> 0.0008s
-- change_column_default(:user_preferences, :epic_notes_filter, 0)
-> 0.0021s
-> 0.0067s
-- transaction_open?()
-> 0.0000s
-- exec_query("SELECT COUNT(*) AS count FROM "user_preferences"")
-> 0.0007s
-- exec_query("SELECT  "user_preferences"."id" FROM "user_preferences" ORDER BY "user_preferences"."id" ASC LIMIT 1")
-> 0.0004s
-- exec_query("SELECT  "user_preferences"."id" FROM "user_preferences" WHERE "user_preferences"."id" >= 1 ORDER BY "user_preferences"."id" ASC LIMIT 1 OFFSET 1")
-> 0.0005s
-- execute("UPDATE "user_preferences" SET "epic_notes_filter" = 0 WHERE "user_preferences"."id" >= 1")
-> 0.0010s
-- change_column_null(:user_preferences, :epic_notes_filter, false)
-> 0.0009s
-- execute("RESET ALL")
-> 0.0003s
-- column_exists?(:user_preferences, :epics_sort)
-> 0.0019s
-- add_column(:user_preferences, :epics_sort, :string)
-> 0.0010s
-- column_exists?(:user_preferences, :roadmap_epics_state)
-> 0.0020s
-- add_column(:user_preferences, :roadmap_epics_state, :integer)
-> 0.0010s
-- column_exists?(:user_preferences, :roadmaps_sort)
-> 0.0016s
-- add_column(:user_preferences, :roadmaps_sort, :string)
-> 0.0010s
-- column_exists?(:users, :auditor)
-> 0.0062s
-- change_table(:users, {})
-> 0.0789s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:users, :group_view, {:algorithm=>:concurrently})
-> 0.0089s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:users, :group_view, {:algorithm=>:concurrently})
-> 0.0111s
-- execute("RESET ALL")
-> 0.0004s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:users, :managing_group_id, {:algorithm=>:concurrently})
-> 0.0118s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- add_index(:users, :managing_group_id, {:algorithm=>:concurrently})
-> 0.0141s
-- execute("RESET ALL")
-> 0.0003s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:users, :support_bot, {:algorithm=>:concurrently})
-> 0.0129s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:users, :bot_type, {:algorithm=>:concurrently})
-> 0.0101s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- add_index(:users, :bot_type, {:algorithm=>:concurrently})
-> 0.0083s
-- execute("RESET ALL")
-> 0.0003s
-- 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.0107s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:users, :state, {:name=>"index_users_on_state_and_internal_attrs", :where=>"((ghost <> true) AND (support_bot <> true))", :algorithm=>:concurrently})
-> 0.0074s
-- execute("RESET ALL")
-> 0.0002s
-- transaction_open?()
-> 0.0000s
-- select_one("SELECT current_setting('server_version_num') AS v")
-> 0.0004s
-- index_exists?(:users, :state, {:name=>"index_users_on_state_and_internal", :algorithm=>:concurrently})
-> 0.0094s
-- 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.0101s
-- 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.0078s
-- execute("RESET ALL")
-> 0.0003s
-- column_exists?(:web_hooks, :group_id)
-> 0.0026s
-- column_exists?(:geo_nodes, :internal_url)
-> 0.0017s
-- add_column(:geo_nodes, :internal_url, :string)
-> 0.0085s
-- foreign_keys("application_settings")
-> 0.0047s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("application_settings")
-> 0.0040s
-- execute("ALTER TABLE application_settings\nADD CONSTRAINT fk_rails_b53e481273\nFOREIGN KEY (custom_project_templates_group_id)\nREFERENCES namespaces (id)\nON DELETE SET NULL\nNOT VALID;\n")
-> 0.1101s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- execute("ALTER TABLE application_settings VALIDATE CONSTRAINT fk_rails_b53e481273;")
-> 0.0030s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("application_settings")
-> 0.0035s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("application_settings")
-> 0.0035s
-- execute("ALTER TABLE application_settings\nADD CONSTRAINT fk_ec757bd087\nFOREIGN KEY (file_template_project_id)\nREFERENCES projects (id)\nON DELETE SET NULL\nNOT VALID;\n")
-> 0.0035s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE application_settings VALIDATE CONSTRAINT fk_ec757bd087;")
-> 0.0028s
-- execute("RESET ALL")
-> 0.0003s
-- foreign_keys("approval_merge_request_rule_sources")
-> 0.0033s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("approval_merge_request_rule_sources")
-> 0.0033s
-- execute("ALTER TABLE approval_merge_request_rule_sources\nADD CONSTRAINT fk_rails_e605a04f76\nFOREIGN KEY (approval_merge_request_rule_id)\nREFERENCES approval_merge_request_rules (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0022s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE approval_merge_request_rule_sources VALIDATE CONSTRAINT fk_rails_e605a04f76;")
-> 0.0016s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("approval_merge_request_rule_sources")
-> 0.0034s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("approval_merge_request_rule_sources")
-> 0.0039s
-- execute("ALTER TABLE approval_merge_request_rule_sources\nADD CONSTRAINT fk_rails_64e8ed3c7e\nFOREIGN KEY (approval_project_rule_id)\nREFERENCES approval_project_rules (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0023s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- execute("ALTER TABLE approval_merge_request_rule_sources VALIDATE CONSTRAINT fk_rails_64e8ed3c7e;")
-> 0.0015s
-- execute("RESET ALL")
-> 0.0003s
-- foreign_keys("approval_merge_request_rules")
-> 0.0036s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("approval_merge_request_rules")
-> 0.0036s
-- execute("ALTER TABLE approval_merge_request_rules\nADD CONSTRAINT fk_rails_004ce82224\nFOREIGN KEY (merge_request_id)\nREFERENCES merge_requests (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0019s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE approval_merge_request_rules VALIDATE CONSTRAINT fk_rails_004ce82224;")
-> 0.0023s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("approval_merge_request_rules_approved_approvers")
-> 0.0035s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("approval_merge_request_rules_approved_approvers")
-> 0.0035s
-- execute("ALTER TABLE approval_merge_request_rules_approved_approvers\nADD CONSTRAINT fk_rails_6577725edb\nFOREIGN KEY (approval_merge_request_rule_id)\nREFERENCES approval_merge_request_rules (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0021s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE approval_merge_request_rules_approved_approvers VALIDATE CONSTRAINT fk_rails_6577725edb;")
-> 0.0065s
-- execute("RESET ALL")
-> 0.0003s
-- foreign_keys("approval_merge_request_rules_approved_approvers")
-> 0.0040s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("approval_merge_request_rules_approved_approvers")
-> 0.0036s
-- execute("ALTER TABLE approval_merge_request_rules_approved_approvers\nADD CONSTRAINT fk_rails_8dc94cff4d\nFOREIGN KEY (user_id)\nREFERENCES users (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0018s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE approval_merge_request_rules_approved_approvers VALIDATE CONSTRAINT fk_rails_8dc94cff4d;")
-> 0.0023s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("approval_merge_request_rules_groups")
-> 0.0036s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("approval_merge_request_rules_groups")
-> 0.0035s
-- execute("ALTER TABLE approval_merge_request_rules_groups\nADD CONSTRAINT fk_rails_5b2ecf6139\nFOREIGN KEY (approval_merge_request_rule_id)\nREFERENCES approval_merge_request_rules (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0023s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE approval_merge_request_rules_groups VALIDATE CONSTRAINT fk_rails_5b2ecf6139;")
-> 0.0013s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("approval_merge_request_rules_groups")
-> 0.0036s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("approval_merge_request_rules_groups")
-> 0.0046s
-- execute("ALTER TABLE approval_merge_request_rules_groups\nADD CONSTRAINT fk_rails_2020a7124a\nFOREIGN KEY (group_id)\nREFERENCES namespaces (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0024s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE approval_merge_request_rules_groups VALIDATE CONSTRAINT fk_rails_2020a7124a;")
-> 0.0016s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("approval_merge_request_rules_users")
-> 0.0037s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("approval_merge_request_rules_users")
-> 0.0036s
-- execute("ALTER TABLE approval_merge_request_rules_users\nADD CONSTRAINT fk_rails_80e6801803\nFOREIGN KEY (approval_merge_request_rule_id)\nREFERENCES approval_merge_request_rules (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0021s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- execute("ALTER TABLE approval_merge_request_rules_users VALIDATE CONSTRAINT fk_rails_80e6801803;")
-> 0.0015s
-- execute("RESET ALL")
-> 0.0003s
-- foreign_keys("approval_merge_request_rules_users")
-> 0.0036s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("approval_merge_request_rules_users")
-> 0.0050s
-- execute("ALTER TABLE approval_merge_request_rules_users\nADD CONSTRAINT fk_rails_bc8972fa55\nFOREIGN KEY (user_id)\nREFERENCES users (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0016s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- execute("ALTER TABLE approval_merge_request_rules_users VALIDATE CONSTRAINT fk_rails_bc8972fa55;")
-> 0.0015s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("approval_project_rules")
-> 0.0035s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("approval_project_rules")
-> 0.0035s
-- execute("ALTER TABLE approval_project_rules\nADD CONSTRAINT fk_rails_5fb4dd100b\nFOREIGN KEY (project_id)\nREFERENCES projects (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0023s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE approval_project_rules VALIDATE CONSTRAINT fk_rails_5fb4dd100b;")
-> 0.0018s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("approval_project_rules_groups")
-> 0.0034s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("approval_project_rules_groups")
-> 0.0034s
-- execute("ALTER TABLE approval_project_rules_groups\nADD CONSTRAINT fk_rails_9071e863d1\nFOREIGN KEY (approval_project_rule_id)\nREFERENCES approval_project_rules (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0131s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- execute("ALTER TABLE approval_project_rules_groups VALIDATE CONSTRAINT fk_rails_9071e863d1;")
-> 0.0014s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("approval_project_rules_groups")
-> 0.0036s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("approval_project_rules_groups")
-> 0.0035s
-- execute("ALTER TABLE approval_project_rules_groups\nADD CONSTRAINT fk_rails_396841e79e\nFOREIGN KEY (group_id)\nREFERENCES namespaces (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0022s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE approval_project_rules_groups VALIDATE CONSTRAINT fk_rails_396841e79e;")
-> 0.0014s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("approval_project_rules_users")
-> 0.0035s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("approval_project_rules_users")
-> 0.0034s
-- execute("ALTER TABLE approval_project_rules_users\nADD CONSTRAINT fk_rails_b9e9394efb\nFOREIGN KEY (approval_project_rule_id)\nREFERENCES approval_project_rules (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0014s
-- execute("SET statement_timeout TO 0")
-> 0.0004s
-- execute("ALTER TABLE approval_project_rules_users VALIDATE CONSTRAINT fk_rails_b9e9394efb;")
-> 0.0014s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("approval_project_rules_users")
-> 0.0044s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("approval_project_rules_users")
-> 0.0036s
-- execute("ALTER TABLE approval_project_rules_users\nADD CONSTRAINT fk_rails_f365da8250\nFOREIGN KEY (user_id)\nREFERENCES users (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0023s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE approval_project_rules_users VALIDATE CONSTRAINT fk_rails_f365da8250;")
-> 0.0014s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("approvals")
-> 0.0036s
-- foreign_keys("approver_groups")
-> 0.0035s
-- foreign_keys("board_assignees")
-> 0.0035s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("board_assignees")
-> 0.0043s
-- execute("ALTER TABLE board_assignees\nADD CONSTRAINT fk_rails_3f6f926bd5\nFOREIGN KEY (board_id)\nREFERENCES boards (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0024s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE board_assignees VALIDATE CONSTRAINT fk_rails_3f6f926bd5;")
-> 0.0438s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("board_assignees")
-> 0.0038s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("board_assignees")
-> 0.0038s
-- execute("ALTER TABLE board_assignees\nADD CONSTRAINT fk_rails_1c0ff59e82\nFOREIGN KEY (assignee_id)\nREFERENCES users (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0015s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE board_assignees VALIDATE CONSTRAINT fk_rails_1c0ff59e82;")
-> 0.0016s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("board_labels")
-> 0.0036s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("board_labels")
-> 0.0034s
-- execute("ALTER TABLE board_labels\nADD CONSTRAINT fk_rails_9374a16edd\nFOREIGN KEY (board_id)\nREFERENCES boards (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0050s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- execute("ALTER TABLE board_labels VALIDATE CONSTRAINT fk_rails_9374a16edd;")
-> 0.0016s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("board_labels")
-> 0.0039s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("board_labels")
-> 0.0034s
-- execute("ALTER TABLE board_labels\nADD CONSTRAINT fk_rails_362b0600a3\nFOREIGN KEY (label_id)\nREFERENCES labels (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0138s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- execute("ALTER TABLE board_labels VALIDATE CONSTRAINT fk_rails_362b0600a3;")
-> 0.0413s
-- execute("RESET ALL")
-> 0.0003s
-- foreign_keys("ci_sources_pipelines")
-> 0.0038s
-- foreign_keys("ci_sources_pipelines")
-> 0.0035s
-- foreign_keys("ci_sources_pipelines")
-> 0.0039s
-- foreign_keys("ci_sources_pipelines")
-> 0.0038s
-- foreign_keys("ci_sources_pipelines")
-> 0.0037s
-- foreign_keys("design_management_designs")
-> 0.0035s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("design_management_designs")
-> 0.0034s
-- execute("ALTER TABLE design_management_designs\nADD CONSTRAINT fk_rails_bfe283ec3c\nFOREIGN KEY (issue_id)\nREFERENCES issues (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0030s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE design_management_designs VALIDATE CONSTRAINT fk_rails_bfe283ec3c;")
-> 0.0029s
-- execute("RESET ALL")
-> 0.0003s
-- foreign_keys("design_management_designs")
-> 0.0037s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("design_management_designs")
-> 0.0035s
-- execute("ALTER TABLE design_management_designs\nADD CONSTRAINT fk_rails_4bb1073360\nFOREIGN KEY (project_id)\nREFERENCES projects (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0042s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- execute("ALTER TABLE design_management_designs VALIDATE CONSTRAINT fk_rails_4bb1073360;")
-> 0.0017s
-- execute("RESET ALL")
-> 0.0003s
-- foreign_keys("design_management_designs_versions")
-> 0.0035s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("design_management_designs_versions")
-> 0.0032s
-- execute("ALTER TABLE design_management_designs_versions\nADD CONSTRAINT fk_03c671965c\nFOREIGN KEY (design_id)\nREFERENCES design_management_designs (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0025s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE design_management_designs_versions VALIDATE CONSTRAINT fk_03c671965c;")
-> 0.0014s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("design_management_designs_versions")
-> 0.0035s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("design_management_designs_versions")
-> 0.0036s
-- execute("ALTER TABLE design_management_designs_versions\nADD CONSTRAINT fk_f4d25ba00c\nFOREIGN KEY (version_id)\nREFERENCES design_management_versions (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0022s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE design_management_designs_versions VALIDATE CONSTRAINT fk_f4d25ba00c;")
-> 0.0014s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("draft_notes")
-> 0.0036s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("draft_notes")
-> 0.0033s
-- execute("ALTER TABLE draft_notes\nADD CONSTRAINT fk_rails_e753681674\nFOREIGN KEY (merge_request_id)\nREFERENCES merge_requests (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0016s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE draft_notes VALIDATE CONSTRAINT fk_rails_e753681674;")rake aborted!
StandardError: An error has occurred, all later migrations canceled:
PG::UndefinedColumn: ERROR:  column "cache_invalidation_event_id" referenced in foreign key constraint does not exist
: ALTER TABLE geo_event_log
ADD CONSTRAINT fk_42c3b54bed
FOREIGN KEY (cache_invalidation_event_id)
REFERENCES geo_cache_invalidation_events (id)
ON DELETE CASCADE
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:1895: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 `'
Caused by:
ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR:  column "cache_invalidation_event_id" referenced in foreign key constraint does not exist
: ALTER TABLE geo_event_log
ADD CONSTRAINT fk_42c3b54bed
FOREIGN KEY (cache_invalidation_event_id)
REFERENCES geo_cache_invalidation_events (id)
ON DELETE CASCADE
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:1895: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 `'
Caused by:
PG::UndefinedColumn: ERROR:  column "cache_invalidation_event_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:1895: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 `'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
-> 0.0069s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("draft_notes")
-> 0.0038s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("draft_notes")
-> 0.0035s
-- execute("ALTER TABLE draft_notes\nADD CONSTRAINT fk_rails_2a8dac9901\nFOREIGN KEY (author_id)\nREFERENCES users (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0025s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE draft_notes VALIDATE CONSTRAINT fk_rails_2a8dac9901;")
-> 0.0015s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("elasticsearch_indexed_namespaces")
-> 0.0035s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("elasticsearch_indexed_namespaces")
-> 0.0033s
-- execute("ALTER TABLE elasticsearch_indexed_namespaces\nADD CONSTRAINT fk_rails_bdcf044f37\nFOREIGN KEY (namespace_id)\nREFERENCES namespaces (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0021s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE elasticsearch_indexed_namespaces VALIDATE CONSTRAINT fk_rails_bdcf044f37;")
-> 0.0015s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("elasticsearch_indexed_projects")
-> 0.0034s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("elasticsearch_indexed_projects")
-> 0.0034s
-- execute("ALTER TABLE elasticsearch_indexed_projects\nADD CONSTRAINT fk_rails_bd13bbdc3d\nFOREIGN KEY (project_id)\nREFERENCES projects (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0020s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- execute("ALTER TABLE elasticsearch_indexed_projects VALIDATE CONSTRAINT fk_rails_bd13bbdc3d;")
-> 0.0016s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("epic_issues")
-> 0.0036s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("epic_issues")
-> 0.0035s
-- execute("ALTER TABLE epic_issues\nADD CONSTRAINT fk_rails_5d942936b4\nFOREIGN KEY (epic_id)\nREFERENCES epics (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0204s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- execute("ALTER TABLE epic_issues VALIDATE CONSTRAINT fk_rails_5d942936b4;")
-> 0.0024s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("epic_issues")
-> 0.0039s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("epic_issues")
-> 0.0034s
-- execute("ALTER TABLE epic_issues\nADD CONSTRAINT fk_rails_4209981af6\nFOREIGN KEY (issue_id)\nREFERENCES issues (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0015s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE epic_issues VALIDATE CONSTRAINT fk_rails_4209981af6;")
-> 0.0013s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("epic_metrics")
-> 0.0034s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("epic_metrics")
-> 0.0033s
-- execute("ALTER TABLE epic_metrics\nADD CONSTRAINT fk_rails_d071904753\nFOREIGN KEY (epic_id)\nREFERENCES epics (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0030s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE epic_metrics VALIDATE CONSTRAINT fk_rails_d071904753;")
-> 0.0014s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("epics")
-> 0.0033s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("epics")
-> 0.0039s
-- execute("ALTER TABLE epics\nADD CONSTRAINT fk_25b99c1be3\nFOREIGN KEY (parent_id)\nREFERENCES epics (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0023s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE epics VALIDATE CONSTRAINT fk_25b99c1be3;")
-> 0.0013s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("epics")
-> 0.0039s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("epics")
-> 0.0038s
-- execute("ALTER TABLE epics\nADD CONSTRAINT fk_rails_1bf671ebb7\nFOREIGN KEY (milestone_id)\nREFERENCES milestones (id)\nON DELETE SET NULL\nNOT VALID;\n")
-> 0.0017s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- execute("ALTER TABLE epics VALIDATE CONSTRAINT fk_rails_1bf671ebb7;")
-> 0.0019s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("epics")
-> 0.0036s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("epics")
-> 0.0036s
-- execute("ALTER TABLE epics\nADD CONSTRAINT fk_f081aa4489\nFOREIGN KEY (group_id)\nREFERENCES namespaces (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0040s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE epics VALIDATE CONSTRAINT fk_f081aa4489;")
-> 0.0017s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("epics")
-> 0.0037s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("epics")
-> 0.0036s
-- execute("ALTER TABLE epics\nADD CONSTRAINT fk_dccd3f98fc\nFOREIGN KEY (assignee_id)\nREFERENCES users (id)\nON DELETE SET NULL\nNOT VALID;\n")
-> 0.0016s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- execute("ALTER TABLE epics VALIDATE CONSTRAINT fk_dccd3f98fc;")
-> 0.0017s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("epics")
-> 0.0040s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("epics")
-> 0.0042s
-- execute("ALTER TABLE epics\nADD CONSTRAINT fk_3654b61b03\nFOREIGN KEY (author_id)\nREFERENCES users (id)\nON DELETE CASCADE\nNOT VALID;\n")
-> 0.0026s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- execute("ALTER TABLE epics VALIDATE CONSTRAINT fk_3654b61b03;")
-> 0.0017s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("epics")
-> 0.0039s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("epics")
-> 0.0041s
-- execute("ALTER TABLE epics\nADD CONSTRAINT fk_aa5798e761\nFOREIGN KEY (closed_by_id)\nREFERENCES users (id)\nON DELETE SET NULL\nNOT VALID;\n")
-> 0.0018s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- execute("ALTER TABLE epics VALIDATE CONSTRAINT fk_aa5798e761;")
-> 0.0027s
-- execute("RESET ALL")
-> 0.0002s
-- foreign_keys("geo_event_log")
-> 0.0038s
-- transaction_open?()
-> 0.0000s
-- foreign_keys("geo_event_log")
-> 0.0038s
-- execute("ALTER TABLE geo_event_log\nADD CONSTRAINT fk_42c3b54bed\nFOREIGN KEY (cache_invalidation_event_id)\nREFERENCES geo_cache_invalidation_events (id)\nON DELETE CASCADE\nNOT VALID;\n")
STDERR:
---- End output of "bash"  "/tmp/chef-script20190725-27337-17g71bc" ----
Ran "bash"  "/tmp/chef-script20190725-27337-17g71bc" returned 1

Output of checks

(If you are reporting a bug on GitLab.com, write: This bug happens on GitLab.com)

Results of GitLab environment info

Expand for output related to GitLab environment info

(For installations with omnibus-gitlab package run and paste the output of:
sudo gitlab-rake gitlab:env:info)
(For installations from source run and paste the output of:
sudo -u git -H bundle exec rake gitlab:env:info RAILS_ENV=production)
System information
System:		Debian 9.9
Current User:	git
Using RVM:	no
Ruby Version:	2.5.3p105
Gem Version:	2.7.9
Bundler Version:1.17.3
Rake Version:	12.3.2
Redis Version:	3.2.12
Git Version:	2.21.0
Sidekiq Version:5.2.7
Go Version:	unknown
GitLab information
Version:	11.11.5
Revision:	b85e6215a85
Directory:	/opt/gitlab/embedded/service/gitlab-rails
DB Adapter:	PostgreSQL
DB Version:	9.6.11
URL:		https://gitlab.charnwood.local
HTTP Clone URL:	https://gitlab.charnwood.local/some-group/some-project.git
SSH Clone URL:	git@gitlab.charnwood.local:some-group/some-project.git
Using LDAP:	no
Using Omniauth:	yes
Omniauth Providers:
GitLab Shell
Version:	9.1.0
Repository storage paths:

• default: /var/opt/gitlab/git-data/repositories GitLab Shell path: /opt/gitlab/embedded/service/gitlab-shell Git: /opt/gitlab/embedded/bin/git

Results of GitLab application Check

Expand for output related to the GitLab application check

(For installations with omnibus-gitlab package run and paste the output of:
sudo gitlab-rake gitlab:check SANITIZE=true)
(For installations from source run and paste the output of:
sudo -u git -H bundle exec rake gitlab:check RAILS_ENV=production SANITIZE=true)
(we will only investigate if the tests are passing)
Checking GitLab subtasks ...
Checking GitLab Shell ...
GitLab Shell: ... GitLab Shell version >= 9.1.0 ? ... OK (9.1.0)
Running /opt/gitlab/embedded/service/gitlab-shell/bin/check
Check GitLab API access: OK
Redis available via internal API: OK
Access to /var/opt/gitlab/.ssh/authorized_keys: OK
gitlab-shell self-check successful
Checking GitLab Shell ... Finished
Checking Gitaly ...
Gitaly: ... default ... OK
Checking Gitaly ... Finished
Checking Sidekiq ...
Sidekiq: ... Running? ... yes
Number of Sidekiq processes ... 1
Checking Sidekiq ... Finished
Checking Incoming Email ...
Incoming Email: ... Reply by email is disabled in config/gitlab.yml
Checking Incoming Email ... Finished
Checking LDAP ...
LDAP: ... LDAP is disabled in config/gitlab.yml
Checking LDAP ... Finished
Checking GitLab App ...
Git configured correctly? ... yes
Database config exists? ... yes
All migrations up? ... yes
Database contains orphaned GroupMembers? ... no
GitLab config exists? ... yes
GitLab config up to date? ... yes
Log directory writable? ... yes
Tmp directory writable? ... yes
Uploads directory exists? ... yes
Uploads directory has correct permissions? ... yes
Uploads directory tmp has correct permissions? ... yes
Init script exists? ... skipped (omnibus-gitlab has no init script)
Init script up-to-date? ... skipped (omnibus-gitlab has no init script)
Projects have namespace: ...
3/1 ... yes
4/2 ... yes
4/3 ... yes
4/4 ... yes
4/5 ... yes
3/8 ... yes
3/9 ... yes
9/10 ... yes
4/11 ... yes
12/12 ... yes
12/13 ... yes
2/14 ... yes
2/15 ... yes
3/16 ... yes
2/17 ... yes
11/18 ... yes
11/19 ... yes
4/20 ... yes
14/21 ... yes
13/22 ... yes
16/23 ... yes
11/24 ... yes
4/25 ... yes
4/26 ... yes
4/28 ... yes
9/29 ... yes
4/30 ... yes
Redis version >= 2.8.0? ... yes
Ruby version >= 2.5.3 ? ... yes (2.5.3)
Git version >= 2.21.0 ? ... yes (2.21.0)
Git user has default SSH configuration? ... yes
Active users: ... 10
Checking GitLab App ... Finished
Checking GitLab subtasks ... Finished

Possible fixes

(If you can, link to the line of code that might be responsible for the problem)