rspec migration pg11 2/5
Passed Started
by
@patrickbajao
Patrick Bajao
1Running with gitlab-runner 13.9.0-rc2 (69c049fd)2 on docker-auto-scale-com 8a6210b83 feature flags: FF_GITLAB_REGISTRY_HELPER_IMAGE:true6Using Docker executor with image registry.gitlab.com/gitlab-org/gitlab-build-images:ruby-2.7.2.patched-golang-1.14-git-2.29-lfs-2.9-chrome-87-node-14.15-yarn-1.22-postgresql-11-graphicsmagick-1.3.34 ...7Starting service postgres:11.6 ...8Pulling docker image postgres:11.6 ...9Using docker image sha256:2c963c0eb8c6efa49bb8352ea446f248d208d674cfc34fc9ea275b5f99f8dedd for postgres:11.6 with digest postgres@sha256:6f2062ab11d720f4756f17da4d0a64534346cce33b7cdea9d7ac4f43eed9fc02 ...10Starting service redis:5.0-alpine ...11Pulling docker image redis:5.0-alpine ...12Using docker image sha256:f5b24aafdf93a05581fac6db4430badb2024b27c7d6c29eb3144b01828ac5a07 for redis:5.0-alpine with digest redis@sha256:6151b520d9ac29c1524d9637e0b3dc69cba7dbef27a427d6dba355652fff8306 ...13Waiting for services to be up and running...14Authenticating with credentials from job payload (GitLab Registry)15Pulling docker image registry.gitlab.com/gitlab-org/gitlab-build-images:ruby-2.7.2.patched-golang-1.14-git-2.29-lfs-2.9-chrome-87-node-14.15-yarn-1.22-postgresql-11-graphicsmagick-1.3.34 ...16Using docker image sha256:4d23ed899afed063085b02cb83fa639d1a880dc4059e6c7f0af9ee9b713ba41b for registry.gitlab.com/gitlab-org/gitlab-build-images:ruby-2.7.2.patched-golang-1.14-git-2.29-lfs-2.9-chrome-87-node-14.15-yarn-1.22-postgresql-11-graphicsmagick-1.3.34 with digest registry.gitlab.com/gitlab-org/gitlab-build-images@sha256:d70df1af0359f58b269fab0d70a090bca324eba3a03e465146b10aef05de3273 ...18Running on runner-8a6210b8-project-278964-concurrent-0 via runner-8a6210b8-gsrm-1614768834-fae3bd3d...20$ eval "$CI_PRE_CLONE_SCRIPT"21Downloading archived master...22Connecting to storage.googleapis.com (172.217.193.128:443)23saving to '/tmp/gitlab.tar.gz'24gitlab.tar.gz 46% |************** | 182M 0:00:01 ETA25gitlab.tar.gz 99% |******************************* | 394M 0:00:00 ETA26gitlab.tar.gz 100% |********************************| 396M 0:00:00 ETA27'/tmp/gitlab.tar.gz' saved28Extracting tarball into /builds/gitlab-org/gitlab...29Fetching changes with git depth set to 20...30Reinitialized existing Git repository in /builds/gitlab-org/gitlab/.git/31remote: Enumerating objects: 1210, done. 32remote: Counting objects: 100% (645/645), done. 33remote: Compressing objects: 100% (248/248), done. 34remote: Total 320 (delta 256), reused 130 (delta 68), pack-reused 035Receiving objects: 100% (320/320), 40.40 KiB | 1.04 MiB/s, done.36Resolving deltas: 100% (256/256), completed with 120 local objects.38 * [new ref] 4996f4cc3b5cc82b8b493bfd2a4ced37e8cf757c -> refs/pipelines/26473258739Checking out 4996f4cc as refs/merge-requests/55046/merge...40Skipping Git submodules setup42Checking cache for rails-v4-3...43cache.zip is up to date 44WARNING: vendor/ruby/2.7.0/gems/deprecation_toolkit-1.5.1/gemfiles/test/deprecations: chmod vendor/ruby/2.7.0/gems/deprecation_toolkit-1.5.1/gemfiles/test/deprecations: no such file or directory (suppressing repeats) 45Successfully extracted cache47Downloading artifacts for compile-test-assets (1069711722)...48Downloading artifacts from coordinator... ok id=1069711722 responseStatus=200 OK token=cQ-zkx2s49Downloading artifacts for detect-tests (1069711729)...50Downloading artifacts from coordinator... ok id=1069711729 responseStatus=200 OK token=4KJ6tsyT51Downloading artifacts for retrieve-tests-metadata (1069711731)...52Downloading artifacts from coordinator... ok id=1069711731 responseStatus=200 OK token=nMSW8ysV53Downloading artifacts for setup-test-env (1069711725)...54Downloading artifacts from coordinator... ok id=1069711725 responseStatus=200 OK token=fSmN9Jtk55WARNING: tmp/tests/gitlab-shell/.gitlab_shell_secret: chmod tmp/tests/gitlab-shell/.gitlab_shell_secret: no such file or directory (suppressing repeats) 57Using docker image sha256:4d23ed899afed063085b02cb83fa639d1a880dc4059e6c7f0af9ee9b713ba41b for registry.gitlab.com/gitlab-org/gitlab-build-images:ruby-2.7.2.patched-golang-1.14-git-2.29-lfs-2.9-chrome-87-node-14.15-yarn-1.22-postgresql-11-graphicsmagick-1.3.34 with digest registry.gitlab.com/gitlab-org/gitlab-build-images@sha256:d70df1af0359f58b269fab0d70a090bca324eba3a03e465146b10aef05de3273 ...58$ [ "$FOSS_ONLY" = "1" ] && rm -rf ee/ qa/spec/ee/ qa/qa/specs/features/ee/ qa/qa/ee/ qa/qa/ee.rb59$ export GOPATH=$CI_PROJECT_DIR/.go60$ mkdir -p $GOPATH61$ source scripts/utils.sh62$ source scripts/prepare_build.sh63Bundler version 2.1.464$ bundle install --without=production development --jobs=2 --path=vendor --retry=3 --quiet65==> 'bundle install --without=production development --jobs=2 --path=vendor --retry=3 --quiet' succeeded in 1 seconds.66$ bundle check67The Gemfile's dependencies are satisfied68==> 'bundle check' succeeded in 0 seconds.69$ bundle pristine pg70Installing pg 1.2.3 with native extensions71==> 'bundle pristine pg' succeeded in 11 seconds.72$ setup_db_user_only73CREATE ROLE74GRANT75==> 'setup_db_user_only' succeeded in 0 seconds.76$ bundle exec rake db:drop db:create db:structure:load db:migrate gitlab:db:setup_ee77Dropped database 'gitlabhq_test'78Created database 'gitlabhq_test'79Dropped database 'gitlabhq_geo_test'80Created database 'gitlabhq_geo_test'81==> 'bundle exec rake db:drop db:create db:structure:load db:migrate gitlab:db:setup_ee' succeeded in 28 seconds.82$ run_timed_command "gem install knapsack --no-document"83$ gem install knapsack --no-document84Successfully installed knapsack-1.20.0851 gem installed86==> 'gem install knapsack --no-document' succeeded in 1 seconds.87$ run_timed_command "scripts/gitaly-test-spawn"88$ scripts/gitaly-test-spawn89Settings are listed in order of priority. The top value will be used.90retry91Set for your local app (/builds/gitlab-org/gitlab/tmp/tests/gitaly/ruby/.bundle/config/config): 392path93Set for your local app (/builds/gitlab-org/gitlab/tmp/tests/gitaly/ruby/.bundle/config/config): "/builds/gitlab-org/gitlab/vendor/gitaly-ruby"94jobs95Set for your local app (/builds/gitlab-org/gitlab/tmp/tests/gitaly/ruby/.bundle/config/config): 496app_config97Set via BUNDLE_APP_CONFIG: "/builds/gitlab-org/gitlab/tmp/tests/gitaly/ruby/.bundle/config"98gemfile99Set via BUNDLE_GEMFILE: "/builds/gitlab-org/gitlab/tmp/tests/gitaly/ruby/Gemfile"100flags101Set via BUNDLE_FLAGS: "--jobs=4 --retry=3 --path=/builds/gitlab-org/gitlab/vendor/gitaly-ruby"102Don't run Bundler as root. Bundler can ask for sudo if it is needed, and103installing your bundle as root will break this application for all non-root104users on this machine.105Using abstract_type 0.0.7106Using concurrent-ruby 1.1.7107Using i18n 1.8.5108Using minitest 5.14.2109Using thread_safe 0.3.6110Using tzinfo 1.2.9111Using zeitwerk 2.4.2112Using activesupport 6.0.3.4113Using builder 3.2.4114Using erubi 1.10.0115Using mini_portile2 2.5.0116Using racc 1.5.2117Using nokogiri 1.11.1 (x86_64-linux)118Using rails-dom-testing 2.0.3119Using crass 1.0.6120Using loofah 2.9.0121Using rails-html-sanitizer 1.3.0122Using actionview 6.0.3.4123Using rack 2.2.3124Using rack-test 1.1.0125Using actionpack 6.0.3.4126Using ice_nine 0.11.2127Using memoizable 0.4.2128Using adamantium 0.2.0129Using public_suffix 4.0.6130Using addressable 2.7.0131Using ast 2.4.1132Using binding_ninja 0.2.3133Using bundler 2.1.4134Using charlock_holmes 0.7.7135Using coderay 1.1.2136Using equalizer 0.0.11137Using concord 0.1.5138Using diff-lcs 1.3139Using dotenv 2.7.6140Using escape_utils 1.2.1141Using factory_bot 5.0.2142Using multipart-post 2.1.1143Using faraday 1.0.1144Using ffi 1.13.1145Using json 2.5.1146Using gemojione 3.3.0147Using mini_mime 1.0.2148Using rugged 1.0.1149Using github-linguist 7.12.1150Using github-markup 1.7.0151Using mime-types-data 3.2020.1104152Using mime-types 3.3.1153Using gitlab-gollum-rugged_adapter 0.4.4.3.gitlab.1154Using rouge 3.26.0155Using nokogumbo 1.5.0156Using sanitize 4.6.6157Using stringex 2.8.5158Using gitlab-gollum-lib 4.2.7.10.gitlab.1159Using google-protobuf 3.12.4 (x86_64-linux)160Using googleapis-common-protos-types 1.0.5161Using grpc 1.30.2 (x86_64-linux)162Using opentracing 0.5.0163Using thrift 0.13.0164Using jaeger-client 1.1.0165Using pg_query 1.3.0166Using redis 4.2.5167Using gitlab-labkit 0.15.0168Using gitlab-markup 1.7.1169Using grpc-tools 1.30.2170Using sawyer 0.8.2171Using octokit 4.20.0172Using reverse_markdown 1.4.0173Using thor 1.1.0174Using licensee 9.14.1175Using method_source 0.9.2176Using msgpack 1.3.3177Using optimist 3.0.1178Using parallel 1.19.2179Using parser 2.7.2.0180Using procto 0.0.3181Using unparser 0.4.7182Using proc_to_ast 0.1.0183Using pry 0.12.2184Using rainbow 3.0.0185Using rbtrace 0.4.14186Using rdoc 6.2.0187Using regexp_parser 1.8.1188Using rexml 3.2.4189Using rspec-support 3.8.0190Using rspec-core 3.8.0191Using rspec-expectations 3.8.3192Using rspec-mocks 3.8.0193Using rspec 3.8.0194Using rspec-parameterized 0.4.2195Using rubocop-ast 0.2.0196Using ruby-progressbar 1.10.1197Using unicode-display_width 1.7.0198Using rubocop 0.86.0199Using sentry-raven 3.0.4200Using timecop 0.9.1201Bundle complete! 21 Gemfile dependencies, 96 gems now installed.202Bundled gems are installed into `/builds/gitlab-org/gitlab/vendor/gitaly-ruby`203Checking gitaly-ruby Gemfile...204Checking gitaly-ruby bundle...205The Gemfile's dependencies are satisfied206Trying to connect to gitaly: ........ OK207Trying to connect to gitaly2: .................. OK208Trying to connect to praefect: .......... OK209==> 'scripts/gitaly-test-spawn' succeeded in 5 seconds.210$ source ./scripts/rspec_helpers.sh211$ rspec_paralellized_job "--tag ~quarantine --tag ~geo --tag level:migration"212KNAPSACK_TEST_FILE_PATTERN: spec/{migrations,lib/gitlab/background_migration,lib/ee/gitlab/background_migration}{,/**/}*_spec.rb213Knapsack report generator started!214WARNING: `around(:context)` hooks are not supported and behave like `around(:example). Called from /builds/gitlab-org/gitlab/spec/support/omniauth_strategy.rb:36:in `block in <top (required)>'.215Run options:216 include {:focus=>true, :level=>"migration"}217 exclude {:quarantine=>true, :geo=>true}218==> Setting up GitLab Workhorse...219 GitLab Workhorse set up in 66.142072585 seconds...220==> Setting up gitlab-test bare repository in /builds/gitlab-org/gitlab/tmp/tests/gitlab-test_bare...221 /builds/gitlab-org/gitlab/tmp/tests/gitlab-test_bare set up in 0.03563593 seconds...222Gitlab::BackgroundMigration::LegacyUploadMover223 when no note found for the upload224 behaves like legacy upload deletion225DEPRECATION WARNING: /builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/sanitized_file.rb:316: warning: Using the last argument as keyword parameters is deprecated; maybe ** should be added to the call226/usr/local/lib/ruby/2.7.0/fileutils.rb:206: warning: The called method `mkdir_p' is defined here227 (called from cache! at /builds/gitlab-org/gitlab/app/uploaders/object_storage.rb:369)228 removes the upload record229 when upload does not belong to a note230 does not remove the upload231 when the upload move fails232 behaves like move error233 does not remove the upload file234 when the upload is in local storage235 when the upload file does not exist on the filesystem236 behaves like legacy upload deletion237/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil238/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil239 removes the upload record240 when an upload belongs to a legacy_diff_note241 when the file does not exist for the upload242 behaves like move error243 does not remove the upload file244 when the file does not exist on expected path245 behaves like move error246 does not remove the upload file247 when the file path does not include system/note/attachment248 behaves like move error249 does not remove the upload file250 when the file move raises an error251 behaves like move error252 does not remove the upload file253 when upload has mount_point nil254 behaves like migrates the file correctly255/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil256/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil257 creates a new upload record correctly, updates the legacy upload note so that it references the file in the markdown, removes the attachment from the note model, removes the file, moves legacy uploads to the correct location, removes the upload record258 when the file can be handled correctly259 behaves like migrates the file correctly260/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil261/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil262 creates a new upload record correctly, updates the legacy upload note so that it references the file in the markdown, removes the attachment from the note model, removes the file, moves legacy uploads to the correct location, removes the upload record263 when object storage is disabled for FileUploader264 when the file belongs to a legacy project265 behaves like migrates the file correctly266/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil267/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil268 creates a new upload record correctly, updates the legacy upload note so that it references the file in the markdown, removes the attachment from the note model, removes the file, moves legacy uploads to the correct location, removes the upload record269 when the file belongs to a hashed project270 behaves like migrates the file correctly271/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil272/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil273 creates a new upload record correctly, updates the legacy upload note so that it references the file in the markdown, removes the attachment from the note model, removes the file, moves legacy uploads to the correct location, removes the upload record274 when object storage is enabled for FileUploader275 when the file belongs to a legacy project276 behaves like migrates the file correctly277/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil278/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil279 creates a new upload record correctly, updates the legacy upload note so that it references the file in the markdown, removes the attachment from the note model, removes the file, moves legacy uploads to the correct location, removes the upload record280 when the file belongs to a hashed project281 behaves like migrates the file correctly282/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil283/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil284 creates a new upload record correctly, updates the legacy upload note so that it references the file in the markdown, removes the attachment from the note model, removes the file, moves legacy uploads to the correct location, removes the upload record285 when legacy uploads are stored in object storage286 when the upload file does not exist on the filesystem287 behaves like legacy upload deletion288/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil289/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil290 removes the upload record291 when the file belongs to a legacy project292 behaves like migrates the file correctly293/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil294/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil295 creates a new upload record correctly, updates the legacy upload note so that it references the file in the markdown, removes the attachment from the note model, removes the file, moves legacy uploads to the correct location, removes the upload record296 when the file belongs to a hashed project297 behaves like migrates the file correctly298/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil299/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.1/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil300 creates a new upload record correctly, updates the legacy upload note so that it references the file in the markdown, removes the attachment from the note model, removes the file, moves legacy uploads to the correct location, removes the upload record301RemoveDuplicateLabelsFromGroup302NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping303NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping304NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping305NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping306DEPRECATION WARNING: /builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:890: warning: Using the last argument as keyword parameters is deprecated; maybe ** should be added to the call307/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/connection_adapters/abstract/schema_statements.rb:1026: warning: The called method `remove_foreign_key' is defined here308 (called from remove_foreign_key_without_error at /builds/gitlab-org/gitlab/lib/gitlab/database/migration_helpers.rb:1175)309NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping310NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping311NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping312NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping313NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping314 removing full duplicates315 when there are no duplicate labels316-- transaction()317 -> 0.0046s318-- transaction()319 -> 0.0020s320 does not remove anything321-- transaction()322 -> 0.0037s323-- transaction()324 -> 0.0018s325 restores removed records when rolling back - no change326 with duplicates with no relationships327-- transaction()328 -> 0.0104s329 -> 2 rows330-- transaction()331 -> 0.0020s332 creates a backup record for each removed record333-- transaction()334 -> 0.0110s335 -> 2 rows336-- transaction()337 -> 0.0019s338 creates the correct backup records with `create` restore_action339-- transaction()340 -> 0.0110s341 -> 2 rows342-- transaction()343 -> 0.0019s344 deletes all but one345-- transaction()346 -> 0.0110s347 -> 2 rows348-- transaction()349 -> 0.0020s350 restores removed records on rollback351 two duplicate records, one of which has a relationship352-- transaction()353 -> 0.0034s354-- transaction()355 -> 0.0069s356 does not remove anything357-- transaction()358 -> 0.0032s359-- transaction()360 -> 0.0044s361 does not create a backup record with `create` restore_action362-- transaction()363 -> 0.0039s364-- transaction()365 -> 0.0061s366 restores removed records when rolling back - no change367 multiple duplicates, a subset of which have relationships368-- transaction()369 -> 0.0084s370 -> 1 rows371-- transaction()372 -> 0.0042s373 creates a backup record with `create` restore_action for each removed record374-- transaction()375 -> 0.0106s376 -> 1 rows377-- transaction()378 -> 0.0048s379 creates the correct backup records380-- transaction()381 -> 0.0108s382 -> 1 rows383-- transaction()384 -> 0.0048s385 deletes the duplicate record386-- transaction()387 -> 0.0103s388 -> 1 rows389-- transaction()390 -> 0.0046s391 restores removed records on rollback392 renaming partial duplicates393 when there are no duplicate labels394-- transaction()395 -> 0.0035s396-- transaction()397 -> 0.0019s398 does not rename anything399 with duplicates with no relationships400-- transaction()401 -> 0.0035s402-- transaction()403 -> 0.0054s404 creates a backup record for each renamed record405-- transaction()406 -> 0.0036s407-- transaction()408 -> 0.0068s409 creates the correct backup records with `rename` restore_action410-- transaction()411 -> 0.0034s412-- transaction()413 -> 0.0071s414 modifies the titles of the partial duplicates415-- transaction()416 -> 0.0033s417-- transaction()418 -> 0.0070s419 restores renamed records on rollback420 when the labels have a long title that might overflow421-- transaction()422 -> 0.0036s423-- transaction()424 -> 0.0072s425 keeps the length within the limit426NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping427NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping428NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"429NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"430NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"431NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"432NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"433NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"434NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"435NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"436NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"437NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"438NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"439NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"440NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"441NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"442NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"443NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"444NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping445NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping446NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping447NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping448NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"449NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"450NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping451NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping452NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping453NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping454FixWrongPagesAccessLevel455NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping456NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping457NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping458NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping459NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping460NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping461NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping462NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping463NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping464NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping465NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping466NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping467NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping468NOTICE: trigger "trigger_5e971e2e2c26" for relation "pages_domains" does not exist, skipping469NOTICE: trigger "trigger_e856257b2421" for relation "commit_user_mentions" does not exist, skipping470NOTICE: trigger "trigger_5299882abc4c" for relation "software_license_policies" does not exist, skipping471NOTICE: trigger "trigger_4821f661bf92" for relation "application_settings" does not exist, skipping472NOTICE: trigger "trigger_97893debd1d4" for relation "design_management_versions" does not exist, skipping473NOTICE: trigger "trigger_36edafd19664" for relation "epics" does not exist, skipping474NOTICE: trigger "trigger_dd1443fbd36e" for relation "application_settings" does not exist, skipping475NOTICE: trigger "trigger_806273a4d8be" for relation "application_settings" does not exist, skipping476== 20190703185326 FixWrongPagesAccessLevel: migrating =========================477-- Scheduled 1 FixPagesAccessLevel jobs with a maximum of 20000 records per batch and an interval of 120 seconds.478The migration is expected to take at least 120 seconds. Expect all jobs to have completed after 2021-03-03 12:07:52 UTC."479== 20190703185326 FixWrongPagesAccessLevel: migrated (0.0177s) ================480 correctly schedules background migrations481 project_visibility: 20, pages_access_level: 30, access_control_is_enabled: true, pages_deployed: true, resulting_pages_access_level: 20482== 20190703185326 FixWrongPagesAccessLevel: migrating =========================483-- Scheduled 1 FixPagesAccessLevel jobs with a maximum of 20000 records per batch and an interval of 120 seconds.484The migration is expected to take at least 120 seconds. Expect all jobs to have completed after 2021-03-03 12:07:53 UTC."485== 20190703185326 FixWrongPagesAccessLevel: migrated (0.0476s) ================486 sets proper pages_access_level487 project_visibility: 20, pages_access_level: 30, access_control_is_enabled: false, pages_deployed: true, resulting_pages_access_level: 20488== 20190703185326 FixWrongPagesAccessLevel: migrating =========================489-- Scheduled 1 FixPagesAccessLevel jobs with a maximum of 20000 records per batch and an interval of 120 seconds.490The migration is expected to take at least 120 seconds. Expect all jobs to have completed after 2021-03-03 12:07:53 UTC."491== 20190703185326 FixWrongPagesAccessLevel: migrated (0.0477s) ================492 sets proper pages_access_level493 project_visibility: 0, pages_access_level: 30, access_control_is_enabled: true, pages_deployed: true, resulting_pages_access_level: 30494== 20190703185326 FixWrongPagesAccessLevel: migrating =========================495-- Scheduled 1 FixPagesAccessLevel jobs with a maximum of 20000 records per batch and an interval of 120 seconds.496The migration is expected to take at least 120 seconds. Expect all jobs to have completed after 2021-03-03 12:07:54 UTC."497== 20190703185326 FixWrongPagesAccessLevel: migrated (0.0292s) ================498 sets proper pages_access_level499 project_visibility: 10, pages_access_level: 30, access_control_is_enabled: true, pages_deployed: true, resulting_pages_access_level: 30500== 20190703185326 FixWrongPagesAccessLevel: migrating =========================501-- Scheduled 1 FixPagesAccessLevel jobs with a maximum of 20000 records per batch and an interval of 120 seconds.502The migration is expected to take at least 120 seconds. Expect all jobs to have completed after 2021-03-03 12:07:55 UTC."503== 20190703185326 FixWrongPagesAccessLevel: migrated (0.0291s) ================504 sets proper pages_access_level505 project_visibility: 10, pages_access_level: 20, access_control_is_enabled: false, pages_deployed: true, resulting_pages_access_level: 30506== 20190703185326 FixWrongPagesAccessLevel: migrating =========================507-- Scheduled 1 FixPagesAccessLevel jobs with a maximum of 20000 records per batch and an interval of 120 seconds.508The migration is expected to take at least 120 seconds. Expect all jobs to have completed after 2021-03-03 12:07:56 UTC."509== 20190703185326 FixWrongPagesAccessLevel: migrated (0.1753s) ================510 sets proper pages_access_level511 project_visibility: 10, pages_access_level: 20, access_control_is_enabled: true, pages_deployed: true, resulting_pages_access_level: 20512== 20190703185326 FixWrongPagesAccessLevel: migrating =========================513-- Scheduled 1 FixPagesAccessLevel jobs with a maximum of 20000 records per batch and an interval of 120 seconds.514The migration is expected to take at least 120 seconds. Expect all jobs to have completed after 2021-03-03 12:07:56 UTC."515== 20190703185326 FixWrongPagesAccessLevel: migrated (0.0288s) ================516 sets proper pages_access_level517 project_visibility: 10, pages_access_level: 20, access_control_is_enabled: true, pages_deployed: false, resulting_pages_access_level: 20518== 20190703185326 FixWrongPagesAccessLevel: migrating =========================519-- Scheduled 1 FixPagesAccessLevel jobs with a maximum of 20000 records per batch and an interval of 120 seconds.520The migration is expected to take at least 120 seconds. Expect all jobs to have completed after 2021-03-03 12:07:57 UTC."521== 20190703185326 FixWrongPagesAccessLevel: migrated (0.0313s) ================522 sets proper pages_access_level523 project_visibility: 0, pages_access_level: 20, access_control_is_enabled: true, pages_deployed: true, resulting_pages_access_level: 10524== 20190703185326 FixWrongPagesAccessLevel: migrating =========================525-- Scheduled 1 FixPagesAccessLevel jobs with a maximum of 20000 records per batch and an interval of 120 seconds.526The migration is expected to take at least 120 seconds. Expect all jobs to have completed after 2021-03-03 12:07:58 UTC."527== 20190703185326 FixWrongPagesAccessLevel: migrated (0.0460s) ================528 sets proper pages_access_level529 project_visibility: 0, pages_access_level: 20, access_control_is_enabled: true, pages_deployed: false, resulting_pages_access_level: 10530== 20190703185326 FixWrongPagesAccessLevel: migrating =========================531-- Scheduled 1 FixPagesAccessLevel jobs with a maximum of 20000 records per batch and an interval of 120 seconds.532The migration is expected to take at least 120 seconds. Expect all jobs to have completed after 2021-03-03 12:07:58 UTC."533== 20190703185326 FixWrongPagesAccessLevel: migrated (0.0427s) ================534 sets proper pages_access_level535 project_visibility: 0, pages_access_level: 20, access_control_is_enabled: false, pages_deployed: true, resulting_pages_access_level: 30536== 20190703185326 FixWrongPagesAccessLevel: migrating =========================537-- Scheduled 1 FixPagesAccessLevel jobs with a maximum of 20000 records per batch and an interval of 120 seconds.538The migration is expected to take at least 120 seconds. Expect all jobs to have completed after 2021-03-03 12:07:59 UTC."539== 20190703185326 FixWrongPagesAccessLevel: migrated (0.2396s) ================540 sets proper pages_access_level541 project_visibility: 0, pages_access_level: 20, access_control_is_enabled: false, pages_deployed: false, resulting_pages_access_level: 10542== 20190703185326 FixWrongPagesAccessLevel: migrating =========================543-- Scheduled 1 FixPagesAccessLevel jobs with a maximum of 20000 records per batch and an interval of 120 seconds.544The migration is expected to take at least 120 seconds. Expect all jobs to have completed after 2021-03-03 12:08:00 UTC."545== 20190703185326 FixWrongPagesAccessLevel: migrated (0.1542s) ================546 sets proper pages_access_level547NOTICE: trigger "trigger_806273a4d8be" for relation "application_settings" does not exist, skipping548NOTICE: trigger "trigger_dd1443fbd36e" for relation "application_settings" does not exist, skipping549NOTICE: trigger "trigger_84853438aac0" for relation "epics" does not exist, skipping550NOTICE: trigger "trigger_97893debd1d4" for relation "design_management_versions" does not exist, skipping551NOTICE: trigger "trigger_4821f661bf92" for relation "application_settings" does not exist, skipping552DEPRECATION WARNING: Class level methods will no longer inherit scoping from `with_unique_issue_ids` in Rails 6.1. To continue using the scoped relation, pass it into the block directly. To instead access the full set of models, as Rails 6.1 will, use `BackfillVersionAuthorAndCreatedAt::Version.default_scoped`. (called from block in <class:Version> at /builds/gitlab-org/gitlab/db/post_migrate/20191030223057_backfill_version_author_and_created_at.rb:32)553NOTICE: trigger "trigger_5299882abc4c" for relation "software_license_policies" does not exist, skipping554NOTICE: trigger "trigger_e856257b2421" for relation "commit_user_mentions" does not exist, skipping555DEPRECATION WARNING: /builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:890: warning: Using the last argument as keyword parameters is deprecated; maybe ** should be added to the call556/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/connection_adapters/postgresql/schema_statements.rb:393: warning: The called method `add_column' is defined here557 (called from block in add_timestamps_with_timezone at /builds/gitlab-org/gitlab/lib/gitlab/database/migration_helpers.rb:53)558NOTICE: trigger "trigger_5e971e2e2c26" for relation "pages_domains" does not exist, skipping559NOTICE: table "deployment_clusters" does not exist, skipping560NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping561NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping562NOTICE: constraint "lfs_objects_file_store_not_null" of relation "lfs_objects" does not exist, skipping563NOTICE: constraint "ci_job_artifacts_file_store_not_null" of relation "ci_job_artifacts" does not exist, skipping564NOTICE: constraint "uploads_store_not_null" of relation "uploads" does not exist, skipping565NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping566NOTICE: schema "partitions_dynamic" does not exist, skipping567NOTICE: table "untracked_files_for_uploads" does not exist, skipping568NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping569NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping570NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"571NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"572NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"573NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"574NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"575NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"576NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"577NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"578NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"579NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"580NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"581NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"582NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"583NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"584NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"585NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"586NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping587NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping588NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping589NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"590NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"591NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping592NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping593NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping594NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping595Gitlab::BackgroundMigration596 .queue597 returns background migration worker queue598 .steal599 when there are enqueued jobs present600 when queue contains unprocessed jobs601 steals jobs from a queue602 does not steal job that has already been taken603 does not steal jobs for a different migration604 when a custom predicate is given605 steals jobs that match the predicate606 does not steal jobs that do not match the predicate607 when one of the jobs raises an error608 enqueues the migration again and re-raises the error609 when there are scheduled jobs present610 steals all jobs from the scheduled sets611 when there are enqueued and scheduled jobs present612 steals from the scheduled sets queue first613 when retry_dead_jobs is true614 steals from the dead and retry queue615 .perform616 performs a background migration617 backward compatibility618 performs a background migration for fully-qualified job classes619 .remaining620 when there are jobs remaining621 returns the enqueued jobs plus the scheduled jobs622 when there are no jobs remaining623 returns zero624 .exists?625 when there are enqueued jobs present626 returns true if specific job exists627 returns false if specific job does not exist628 when there are scheduled jobs present629 returns true if specific job exists630 returns false if specific job does not exist631 .dead_jobs?632 when there are dead jobs present633 returns true if specific job exists634 returns false if specific job does not exist635 .retrying_jobs?636 when there are dead jobs present637 returns true if specific job exists638 returns false if specific job does not exist639Gitlab::BackgroundMigration::UserMentions::CreateResourceUserMention640NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping641NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping642NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping643NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping644NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping645NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping646NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping647NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping648NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping649NOTICE: constraint "check_fcfb4a93ff" of relation "epics" does not exist, skipping650NOTICE: constraint "check_970d272570" of relation "merge_requests" does not exist, skipping651NOTICE: constraint "check_fba63f706d" of relation "issues" does not exist, skipping652NOTICE: constraint "check_81b431e49b" of relation "ci_stages" does not exist, skipping653NOTICE: constraint "check_1e2fbd1b39" of relation "ci_builds" does not exist, skipping654NOTICE: constraint "check_d7e99a025e" of relation "ci_pipelines" does not exist, skipping655NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping656NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping657NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping658NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping659 when migrating data660 migrate merge request mentions661 behaves like resource mentions migration662 migrates resource mentions663 when FF disabled664 behaves like resource migration not run665 does not migrate mentions666 migrate commit mentions667 behaves like resource notes mentions migration668 migrates mentions from note669 when FF disabled670 behaves like resource notes migration not run671 does not migrate mentions672 checks no_quote_columns673 has correct no_quote_columns674 commit has correct no_quote_columns675NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping676NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping677NOTICE: constraint "lfs_objects_file_store_not_null" of relation "lfs_objects" does not exist, skipping678NOTICE: constraint "ci_job_artifacts_file_store_not_null" of relation "ci_job_artifacts" does not exist, skipping679NOTICE: constraint "uploads_store_not_null" of relation "uploads" does not exist, skipping680NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping681NOTICE: schema "partitions_dynamic" does not exist, skipping682NOTICE: table "untracked_files_for_uploads" does not exist, skipping683NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping684NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping685NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"686NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"687NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"688NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"689NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"690NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"691NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"692NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"693NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"694NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"695NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"696NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"697NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"698NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"699NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"700NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"701NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping702NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping703NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping704NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"705NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"706NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping707NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping708NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping709NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping710SaveInstanceAdministratorsGroupId711NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping712NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping713NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping714NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping715NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping716NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping717NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping718NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping719NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping720NOTICE: constraint "check_fcfb4a93ff" of relation "epics" does not exist, skipping721NOTICE: constraint "check_970d272570" of relation "merge_requests" does not exist, skipping722NOTICE: constraint "check_fba63f706d" of relation "issues" does not exist, skipping723NOTICE: constraint "check_81b431e49b" of relation "ci_stages" does not exist, skipping724NOTICE: constraint "check_1e2fbd1b39" of relation "ci_builds" does not exist, skipping725NOTICE: constraint "check_d7e99a025e" of relation "ci_pipelines" does not exist, skipping726NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping727NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping728NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping729NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping730 when project ID is saved but group ID is not731== 20200210092405 SaveInstanceAdministratorsGroupId: migrating ================732-- execute(" UPDATE\n application_settings\n SET\n instance_administrators_group_id = (\n SELECT\n namespace_id\n FROM\n projects\n WHERE\n id = application_settings.instance_administration_project_id\n )\n WHERE\n instance_administrators_group_id IS NULL\n AND\n instance_administration_project_id IS NOT NULL\n AND\n ID in (\n SELECT\n max(id)\n FROM\n application_settings\n )\n")733 -> 0.0030s734== 20200210092405 SaveInstanceAdministratorsGroupId: migrated (0.0033s) =======735 saves instance administrators group ID736 when group ID is saved but project ID is not737== 20200210092405 SaveInstanceAdministratorsGroupId: migrating ================738-- execute(" UPDATE\n application_settings\n SET\n instance_administrators_group_id = (\n SELECT\n namespace_id\n FROM\n projects\n WHERE\n id = application_settings.instance_administration_project_id\n )\n WHERE\n instance_administrators_group_id IS NULL\n AND\n instance_administration_project_id IS NOT NULL\n AND\n ID in (\n SELECT\n max(id)\n FROM\n application_settings\n )\n")739 -> 0.0028s740== 20200210092405 SaveInstanceAdministratorsGroupId: migrated (0.0029s) =======741 does not make changes742 when group ID and project ID are both saved743== 20200210092405 SaveInstanceAdministratorsGroupId: migrating ================744-- execute(" UPDATE\n application_settings\n SET\n instance_administrators_group_id = (\n SELECT\n namespace_id\n FROM\n projects\n WHERE\n id = application_settings.instance_administration_project_id\n )\n WHERE\n instance_administrators_group_id IS NULL\n AND\n instance_administration_project_id IS NOT NULL\n AND\n ID in (\n SELECT\n max(id)\n FROM\n application_settings\n )\n")745 -> 0.0024s746== 20200210092405 SaveInstanceAdministratorsGroupId: migrated (0.0025s) =======747 does not make changes748 when neither group ID nor project ID is saved749== 20200210092405 SaveInstanceAdministratorsGroupId: migrating ================750-- execute(" UPDATE\n application_settings\n SET\n instance_administrators_group_id = (\n SELECT\n namespace_id\n FROM\n projects\n WHERE\n id = application_settings.instance_administration_project_id\n )\n WHERE\n instance_administrators_group_id IS NULL\n AND\n instance_administration_project_id IS NOT NULL\n AND\n ID in (\n SELECT\n max(id)\n FROM\n application_settings\n )\n")751 -> 0.0030s752== 20200210092405 SaveInstanceAdministratorsGroupId: migrated (0.0031s) =======753 does not make changes754 when application_settings table has no rows755== 20200210092405 SaveInstanceAdministratorsGroupId: migrating ================756-- execute(" UPDATE\n application_settings\n SET\n instance_administrators_group_id = (\n SELECT\n namespace_id\n FROM\n projects\n WHERE\n id = application_settings.instance_administration_project_id\n )\n WHERE\n instance_administrators_group_id IS NULL\n AND\n instance_administration_project_id IS NOT NULL\n AND\n ID in (\n SELECT\n max(id)\n FROM\n application_settings\n )\n")757 -> 0.0035s758== 20200210092405 SaveInstanceAdministratorsGroupId: migrated (0.0036s) =======759 does not fail760NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping761NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping762NOTICE: constraint "lfs_objects_file_store_not_null" of relation "lfs_objects" does not exist, skipping763NOTICE: constraint "ci_job_artifacts_file_store_not_null" of relation "ci_job_artifacts" does not exist, skipping764NOTICE: constraint "uploads_store_not_null" of relation "uploads" does not exist, skipping765NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping766NOTICE: schema "partitions_dynamic" does not exist, skipping767NOTICE: table "untracked_files_for_uploads" does not exist, skipping768NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping769NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping770NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"771NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"772NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"773NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"774NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"775NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"776NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"777NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"778NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"779NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"780NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"781NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"782NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"783NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"784NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"785NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"786NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping787NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping788NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping789NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"790NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"791NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping792NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping793NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping794NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping795GenerateMissingRoutesForBots796NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping797NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping798NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping799NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping800NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping801NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping802NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping803NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping804NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping805== 20200703064117 GenerateMissingRoutesForBots: migrating =====================806== 20200703064117 GenerateMissingRoutesForBots: migrated (0.0090s) ============807 does not create routes for bot users with existing routes808== 20200703064117 GenerateMissingRoutesForBots: migrating =====================809== 20200703064117 GenerateMissingRoutesForBots: migrated (0.0858s) ============810 does not create routes for human users without an existing route811== 20200703064117 GenerateMissingRoutesForBots: migrating =====================812== 20200703064117 GenerateMissingRoutesForBots: migrated (0.0813s) ============813 does not create route for a bot user with a missing route, if a human user with the same path already exists814 for bot users without an existing route815== 20200703064117 GenerateMissingRoutesForBots: migrating =====================816== 20200703064117 GenerateMissingRoutesForBots: migrated (0.0790s) ============817 creates new routes818== 20200703064117 GenerateMissingRoutesForBots: migrating =====================819== 20200703064117 GenerateMissingRoutesForBots: migrated (0.0741s) ============820 creates new routes with the same path and name as their namespace821NOTICE: table "untracked_files_for_uploads" does not exist, skipping822NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping823NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping824NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"825NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"826NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"827NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"828NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"829NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"830NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"831NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"832NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"833NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"834NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"835NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"836NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"837NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"838NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"839NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"840NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping841NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping842NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping843NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping844NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"845NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"846NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping847NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping848NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping849NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping850Gitlab::BackgroundMigration::PopulateCanonicalEmails851NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping852NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping853NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping854NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping855NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping856NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping857NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping858NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping859NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping860NOTICE: constraint "check_fcfb4a93ff" of relation "epics" does not exist, skipping861NOTICE: constraint "check_970d272570" of relation "merge_requests" does not exist, skipping862NOTICE: constraint "check_fba63f706d" of relation "issues" does not exist, skipping863NOTICE: constraint "check_81b431e49b" of relation "ci_stages" does not exist, skipping864NOTICE: constraint "check_1e2fbd1b39" of relation "ci_builds" does not exist, skipping865NOTICE: constraint "check_d7e99a025e" of relation "ci_pipelines" does not exist, skipping866NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping867NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping868 gmail users869 original_email: "legitimateuser@gmail.com", expected_result: "legitimateuser@gmail.com"870 generates the correct canonical email871 original_email: "userwithplus+somestuff@gmail.com", expected_result: "userwithplus@gmail.com"872 generates the correct canonical email873 original_email: "user.with.periods@gmail.com", expected_result: "userwithperiods@gmail.com"874 generates the correct canonical email875 original_email: "user.with.periods.and.plus+someotherstuff@gmail.com", expected_result: "userwithperiodsandplus@gmail.com"876 generates the correct canonical email877 non gmail.com domain users878 does not generate a canonical email879 does not generate a canonical email880 does not generate a canonical email881 does not generate a canonical email882 gracefully handles missing records883 is expected not to raise Exception884 gracefully handles existing records, some of which may have an already-existing identical canonical_email field885 only creates one record886NOTICE: constraint "lfs_objects_file_store_not_null" of relation "lfs_objects" does not exist, skipping887NOTICE: constraint "ci_job_artifacts_file_store_not_null" of relation "ci_job_artifacts" does not exist, skipping888NOTICE: constraint "uploads_store_not_null" of relation "uploads" does not exist, skipping889NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping890NOTICE: schema "partitions_dynamic" does not exist, skipping891NOTICE: table "untracked_files_for_uploads" does not exist, skipping892NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping893NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping894NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"895NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"896NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"897NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"898NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"899NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"900NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"901NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"902NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"903NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"904NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"905NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"906NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"907NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"908NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"909NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"910NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping911NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping912NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping913NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"914NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"915NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping916NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping917NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping918NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping919UpdateApplicationSettingNpmPackageRequestsForwardingDefault920NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping921NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping922NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping923NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping924NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping925NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping926NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping927NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping928NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping929NOTICE: constraint "check_fcfb4a93ff" of relation "epics" does not exist, skipping930NOTICE: constraint "check_970d272570" of relation "merge_requests" does not exist, skipping931NOTICE: constraint "check_fba63f706d" of relation "issues" does not exist, skipping932NOTICE: constraint "check_81b431e49b" of relation "ci_stages" does not exist, skipping933NOTICE: constraint "check_1e2fbd1b39" of relation "ci_builds" does not exist, skipping934NOTICE: constraint "check_d7e99a025e" of relation "ci_pipelines" does not exist, skipping935NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping936NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping937NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping938NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping939== 20200221105436 UpdateApplicationSettingNpmPackageRequestsForwardingDefault: migrating 940-- change_column_default(:application_settings, :npm_package_requests_forwarding, true)941 -> 0.0479s942-- execute("UPDATE application_settings SET npm_package_requests_forwarding = TRUE")943 -> 0.0016s944== 20200221105436 UpdateApplicationSettingNpmPackageRequestsForwardingDefault: migrated (0.0497s) 945 correctly migrates the application setting946== 20200221105436 UpdateApplicationSettingNpmPackageRequestsForwardingDefault: migrating 947-- change_column_default(:application_settings, :npm_package_requests_forwarding, true)948 -> 0.0479s949-- execute("UPDATE application_settings SET npm_package_requests_forwarding = TRUE")950 -> 0.0016s951== 20200221105436 UpdateApplicationSettingNpmPackageRequestsForwardingDefault: migrated (0.0496s) 952 correctly migrates up and down the application setting953NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping954NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping955NOTICE: constraint "lfs_objects_file_store_not_null" of relation "lfs_objects" does not exist, skipping956NOTICE: constraint "ci_job_artifacts_file_store_not_null" of relation "ci_job_artifacts" does not exist, skipping957NOTICE: constraint "uploads_store_not_null" of relation "uploads" does not exist, skipping958NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping959NOTICE: schema "partitions_dynamic" does not exist, skipping960NOTICE: table "untracked_files_for_uploads" does not exist, skipping961NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping962NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping963NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"964NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"965NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"966NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"967NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"968NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"969NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"970NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"971NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"972NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"973NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"974NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"975NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"976NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"977NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"978NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"979NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping980NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping981NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping982NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"983NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"984NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping985NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping986NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping987NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping988Gitlab::BackgroundMigration::PopulateHasVulnerabilities989NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping990NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping991NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping992NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping993 #perform994 sets `has_vulnerabilities` attribute of project_settings995 writes info log message996 when non-existing project_id is given997 populates only for the existing projects998 when an error happens999 writes error log message1000NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping1001NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"1002NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"1003NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1004NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1005NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1006NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1007ScheduleCalculateWikiSizes1008NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1009NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1010NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1011NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1012NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1013NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1014NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1015NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1016NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1017NOTICE: constraint "check_fcfb4a93ff" of relation "epics" does not exist, skipping1018NOTICE: constraint "check_970d272570" of relation "merge_requests" does not exist, skipping1019NOTICE: constraint "check_fba63f706d" of relation "issues" does not exist, skipping1020NOTICE: constraint "check_81b431e49b" of relation "ci_stages" does not exist, skipping1021NOTICE: constraint "check_1e2fbd1b39" of relation "ci_builds" does not exist, skipping1022NOTICE: constraint "check_d7e99a025e" of relation "ci_pipelines" does not exist, skipping1023NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping1024NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping1025NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping1026NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping1027NOTICE: trigger "trigger_5e971e2e2c26" for relation "pages_domains" does not exist, skipping1028NOTICE: trigger "trigger_e856257b2421" for relation "commit_user_mentions" does not exist, skipping1029NOTICE: trigger "trigger_5299882abc4c" for relation "software_license_policies" does not exist, skipping1030NOTICE: trigger "trigger_4821f661bf92" for relation "application_settings" does not exist, skipping1031NOTICE: trigger "trigger_97893debd1d4" for relation "design_management_versions" does not exist, skipping1032NOTICE: trigger "trigger_36edafd19664" for relation "epics" does not exist, skipping1033NOTICE: trigger "trigger_dd1443fbd36e" for relation "application_settings" does not exist, skipping1034NOTICE: trigger "trigger_806273a4d8be" for relation "application_settings" does not exist, skipping1035 when missing wiki sizes exist1036== 20190527194900 ScheduleCalculateWikiSizes: migrating =======================1037-- Scheduled 1 CalculateWikiSizes jobs with a maximum of 100000 records per batch and an interval of 300 seconds.1038The migration is expected to take at least 300 seconds. Expect all jobs to have completed after 2021-03-03 12:15:14 UTC."1039== 20190527194900 ScheduleCalculateWikiSizes: migrated (0.0188s) ==============1040 schedules a background migration1041== 20190527194900 ScheduleCalculateWikiSizes: migrating =======================1042-- Scheduled 1 CalculateWikiSizes jobs with a maximum of 100000 records per batch and an interval of 300 seconds.1043The migration is expected to take at least 300 seconds. Expect all jobs to have completed after 2021-03-03 12:15:16 UTC."1044== 20190527194900 ScheduleCalculateWikiSizes: migrated (0.2244s) ==============1045 calculates missing wiki sizes1046 when missing wiki sizes do not exist1047== 20190527194900 ScheduleCalculateWikiSizes: migrating =======================1048-- Scheduled 0 CalculateWikiSizes jobs with a maximum of 100000 records per batch and an interval of 300 seconds.1049The migration is expected to take at least 0 seconds. Expect all jobs to have completed after 2021-03-03 12:10:16 UTC."1050== 20190527194900 ScheduleCalculateWikiSizes: migrated (0.0025s) ==============1051 does not schedule a background migration1052NOTICE: table "geo_container_repository_updated_events" does not exist, skipping1053NOTICE: trigger "trigger_806273a4d8be" for relation "application_settings" does not exist, skipping1054NOTICE: trigger "trigger_dd1443fbd36e" for relation "application_settings" does not exist, skipping1055NOTICE: trigger "trigger_84853438aac0" for relation "epics" does not exist, skipping1056NOTICE: trigger "trigger_97893debd1d4" for relation "design_management_versions" does not exist, skipping1057NOTICE: trigger "trigger_4821f661bf92" for relation "application_settings" does not exist, skipping1058DEPRECATION WARNING: Class level methods will no longer inherit scoping from `with_unique_issue_ids` in Rails 6.1. To continue using the scoped relation, pass it into the block directly. To instead access the full set of models, as Rails 6.1 will, use `BackfillVersionAuthorAndCreatedAt::Version.default_scoped`. (called from block in <class:Version> at /builds/gitlab-org/gitlab/db/post_migrate/20191030223057_backfill_version_author_and_created_at.rb:32)1059NOTICE: trigger "trigger_5299882abc4c" for relation "software_license_policies" does not exist, skipping1060NOTICE: trigger "trigger_e856257b2421" for relation "commit_user_mentions" does not exist, skipping1061NOTICE: trigger "trigger_5e971e2e2c26" for relation "pages_domains" does not exist, skipping1062NOTICE: table "deployment_clusters" does not exist, skipping1063NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping1064NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping1065NOTICE: constraint "lfs_objects_file_store_not_null" of relation "lfs_objects" does not exist, skipping1066NOTICE: constraint "ci_job_artifacts_file_store_not_null" of relation "ci_job_artifacts" does not exist, skipping1067NOTICE: constraint "uploads_store_not_null" of relation "uploads" does not exist, skipping1068NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping1069NOTICE: schema "partitions_dynamic" does not exist, skipping1070NOTICE: table "untracked_files_for_uploads" does not exist, skipping1071NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1072NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1073NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"1074NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"1075NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"1076NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"1077NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"1078NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"1079NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"1080NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"1081NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"1082NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"1083NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"1084NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"1085NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"1086NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"1087NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"1088NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"1089NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1090NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1091NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1092NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"1093NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"1094NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1095NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1096NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1097NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1098ConfirmProjectBotUsers1099NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1100NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1101NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1102NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1103NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1104NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1105NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1106NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1107NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1108 project bot users that are currently unconfirmed1109== 20200713071042 ConfirmProjectBotUsers: migrating ===========================1110== 20200713071042 ConfirmProjectBotUsers: migrated (0.1042s) ==================1111 updates their `confirmed_at` attribute1112== 20200713071042 ConfirmProjectBotUsers: migrating ===========================1113== 20200713071042 ConfirmProjectBotUsers: migrated (0.0891s) ==================1114 sets `confirmed_at` to be the same as their `created_at` attribute1115 project bot users that are currently confirmed1116== 20200713071042 ConfirmProjectBotUsers: migrating ===========================1117== 20200713071042 ConfirmProjectBotUsers: migrated (0.0100s) ==================1118 does not update their `confirmed_at` attribute1119 human users that are currently unconfirmed1120== 20200713071042 ConfirmProjectBotUsers: migrating ===========================1121== 20200713071042 ConfirmProjectBotUsers: migrated (0.0104s) ==================1122 does not update their `confirmed_at` attribute1123NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1124NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1125NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"1126NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"1127NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"1128NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"1129NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"1130NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"1131NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"1132NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"1133NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"1134NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"1135NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"1136NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"1137NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"1138NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"1139NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"1140NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"1141NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1142NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1143NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1144NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping1145NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"1146NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"1147NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1148NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1149NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1150NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1151FillFileStoreCiJobArtifacts1152NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1153NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1154NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1155NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1156NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1157NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1158NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1159NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1160NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1161NOTICE: constraint "check_fcfb4a93ff" of relation "epics" does not exist, skipping1162NOTICE: constraint "check_970d272570" of relation "merge_requests" does not exist, skipping1163NOTICE: constraint "check_fba63f706d" of relation "issues" does not exist, skipping1164NOTICE: constraint "check_81b431e49b" of relation "ci_stages" does not exist, skipping1165NOTICE: constraint "check_1e2fbd1b39" of relation "ci_builds" does not exist, skipping1166NOTICE: constraint "check_d7e99a025e" of relation "ci_pipelines" does not exist, skipping1167 when file_store is nil1168== 20200513235532 FillFileStoreCiJobArtifacts: migrating ======================1169-- transaction_open?()1170 -> 0.0000s1171-- exec_query("SELECT COUNT(*) AS count FROM \"ci_job_artifacts\" WHERE \"ci_job_artifacts\".\"file_store\" IS NULL")1172 -> 0.0009s1173-- exec_query("SELECT \"ci_job_artifacts\".\"id\" FROM \"ci_job_artifacts\" WHERE \"ci_job_artifacts\".\"file_store\" IS NULL ORDER BY \"ci_job_artifacts\".\"id\" ASC LIMIT 1")1174 -> 0.0009s1175-- exec_query("SELECT \"ci_job_artifacts\".\"id\" FROM \"ci_job_artifacts\" WHERE \"ci_job_artifacts\".\"id\" >= 1 AND \"ci_job_artifacts\".\"file_store\" IS NULL ORDER BY \"ci_job_artifacts\".\"id\" ASC LIMIT 1 OFFSET 1")1176 -> 0.0009s1177-- execute("UPDATE \"ci_job_artifacts\" SET \"file_store\" = 1 WHERE \"ci_job_artifacts\".\"id\" >= 1 AND \"ci_job_artifacts\".\"file_store\" IS NULL")1178 -> 0.0008s1179== 20200513235532 FillFileStoreCiJobArtifacts: migrated (0.0056s) =============1180 updates file_store to local1181 when file_store is set to local1182== 20200513235532 FillFileStoreCiJobArtifacts: migrating ======================1183-- transaction_open?()1184 -> 0.0000s1185-- exec_query("SELECT COUNT(*) AS count FROM \"ci_job_artifacts\" WHERE \"ci_job_artifacts\".\"file_store\" IS NULL")1186 -> 0.0009s1187== 20200513235532 FillFileStoreCiJobArtifacts: migrated (0.0016s) =============1188 does not update file_store1189 when file_store is set to object storage1190== 20200513235532 FillFileStoreCiJobArtifacts: migrating ======================1191-- transaction_open?()1192 -> 0.0000s1193-- exec_query("SELECT COUNT(*) AS count FROM \"ci_job_artifacts\" WHERE \"ci_job_artifacts\".\"file_store\" IS NULL")1194 -> 0.0007s1195== 20200513235532 FillFileStoreCiJobArtifacts: migrated (0.0011s) =============1196 does not update file_store1197NOTICE: constraint "check_5ebd0515a0" of relation "ci_instance_variables" does not exist, skipping1198NOTICE: schema "partitions_dynamic" does not exist, skipping1199NOTICE: table "untracked_files_for_uploads" does not exist, skipping1200NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1201NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1202NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"1203NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"1204NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"1205NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"1206NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"1207NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"1208NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"1209NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"1210NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"1211NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"1212NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"1213NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"1214NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"1215NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"1216NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"1217NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"1218NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1219NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1220NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1221NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping1222NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"1223NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"1224NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1225NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1226NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1227NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1228Gitlab::BackgroundMigration::SetDefaultIterationCadences1229NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1230NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1231NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1232 #perform1233 when no iteration cadences exists1234 creates iterations_cadence records for the requested groups1235 assigns the iteration cadences to the iterations correctly1236 does not call Group class1237 when an iteration cadence exists for a group1238 does not create a new iterations_cadence1239 assigns iteration cadences to iterations if needed1240NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1241NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1242NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1243DropMergeRequestsRequireCodeOwnerApprovalFromProjects1244NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1245NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1246NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1247NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1248NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1249NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1250NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1251NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1252NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1253NOTICE: constraint "check_fcfb4a93ff" of relation "epics" does not exist, skipping1254NOTICE: constraint "check_970d272570" of relation "merge_requests" does not exist, skipping1255NOTICE: constraint "check_fba63f706d" of relation "issues" does not exist, skipping1256NOTICE: constraint "check_81b431e49b" of relation "ci_stages" does not exist, skipping1257NOTICE: constraint "check_1e2fbd1b39" of relation "ci_builds" does not exist, skipping1258NOTICE: constraint "check_d7e99a025e" of relation "ci_pipelines" does not exist, skipping1259NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping1260NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping1261NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping1262NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping1263NOTICE: trigger "trigger_5e971e2e2c26" for relation "pages_domains" does not exist, skipping1264NOTICE: trigger "trigger_e856257b2421" for relation "commit_user_mentions" does not exist, skipping1265NOTICE: trigger "trigger_5299882abc4c" for relation "software_license_policies" does not exist, skipping1266NOTICE: trigger "trigger_4821f661bf92" for relation "application_settings" does not exist, skipping1267 without running the migration1268 project_table has a :merge_requests_require_code_owner_approval column1269 project_table has a :projects_requiring_code_owner_approval index1270 #up1271== 20191015154408 DropMergeRequestsRequireCodeOwnerApprovalFromProjects: migrating 1272-- remove_column(:projects, :merge_requests_require_code_owner_approval, :boolean)1273 -> 0.0020s1274== 20191015154408 DropMergeRequestsRequireCodeOwnerApprovalFromProjects: migrated (0.0022s) 1275 drops the :merge_requests_require_code_owner_approval column1276== 20191015154408 DropMergeRequestsRequireCodeOwnerApprovalFromProjects: migrating 1277-- remove_column(:projects, :merge_requests_require_code_owner_approval, :boolean)1278 -> 0.0027s1279== 20191015154408 DropMergeRequestsRequireCodeOwnerApprovalFromProjects: migrated (0.0028s) 1280 drops the :projects_requiring_code_owner_approval index1281 #down1282-- remove_column(:projects, :merge_requests_require_code_owner_approval, :boolean)1283 -> 0.0032s1284-- add_column(:projects, :merge_requests_require_code_owner_approval, :boolean)1285 -> 0.0015s1286-- transaction_open?()1287 -> 0.0002s1288-- 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})1289 -> 0.0152s1290-- 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})1291 -> 0.0043s1292 project_table has a :merge_requests_require_code_owner_approval column1293-- remove_column(:projects, :merge_requests_require_code_owner_approval, :boolean)1294 -> 0.0025s1295-- add_column(:projects, :merge_requests_require_code_owner_approval, :boolean)1296 -> 0.0014s1297-- transaction_open?()1298 -> 0.0001s1299-- 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})1300 -> 0.0150s1301-- 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})1302 -> 0.0045s1303 project_table has a :projects_requiring_code_owner_approval index1304NOTICE: trigger "trigger_4821f661bf92" for relation "application_settings" does not exist, skipping1305DEPRECATION WARNING: Class level methods will no longer inherit scoping from `with_unique_issue_ids` in Rails 6.1. To continue using the scoped relation, pass it into the block directly. To instead access the full set of models, as Rails 6.1 will, use `BackfillVersionAuthorAndCreatedAt::Version.default_scoped`. (called from block in <class:Version> at /builds/gitlab-org/gitlab/db/post_migrate/20191030223057_backfill_version_author_and_created_at.rb:32)1306NOTICE: trigger "trigger_5299882abc4c" for relation "software_license_policies" does not exist, skipping1307NOTICE: trigger "trigger_e856257b2421" for relation "commit_user_mentions" does not exist, skipping1308NOTICE: trigger "trigger_5e971e2e2c26" for relation "pages_domains" does not exist, skipping1309NOTICE: table "deployment_clusters" does not exist, skipping1310NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping1311NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping1312NOTICE: constraint "lfs_objects_file_store_not_null" of relation "lfs_objects" does not exist, skipping1313NOTICE: constraint "ci_job_artifacts_file_store_not_null" of relation "ci_job_artifacts" does not exist, skipping1314NOTICE: constraint "uploads_store_not_null" of relation "uploads" does not exist, skipping1315NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping1316NOTICE: schema "partitions_dynamic" does not exist, skipping1317NOTICE: table "untracked_files_for_uploads" does not exist, skipping1318NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1319NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1320NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"1321NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"1322NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"1323NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"1324NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"1325NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"1326NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"1327NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"1328NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"1329NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"1330NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"1331NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"1332NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"1333NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"1334NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"1335NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"1336NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1337NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1338NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1339NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"1340NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"1341NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1342NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1343NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1344NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1345The application_settings table has 1310 columns.1346Recreating the database1347Dropped database 'gitlabhq_test'1348Created database 'gitlabhq_test'1349Database re-creation done in 4.6565351579993151350NullifyUsersRole1351NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1352NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1353NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1354NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1355NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1356NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1357NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1358NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1359NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1360NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping1361NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping1362NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping1363NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping1364NOTICE: trigger "trigger_5e971e2e2c26" for relation "pages_domains" does not exist, skipping1365NOTICE: trigger "trigger_e856257b2421" for relation "commit_user_mentions" does not exist, skipping1366NOTICE: trigger "trigger_5299882abc4c" for relation "software_license_policies" does not exist, skipping1367== 20191104142124 NullifyUsersRole: migrating =================================1368-- transaction_open?()1369 -> 0.0000s1370-- index_exists?(:users, :updated_at, {:where=>"role = 0", :name=>"partial_index_users_updated_at_for_cleaning_mistaken_values", :algorithm=>:concurrently})1371 -> 0.0128s1372-- add_index(:users, :updated_at, {:where=>"role = 0", :name=>"partial_index_users_updated_at_for_cleaning_mistaken_values", :algorithm=>:concurrently})1373 -> 0.0035s1374-- transaction_open?()1375 -> 0.0000s1376-- exec_query("SELECT COUNT(*) AS count FROM \"users\" WHERE \"users\".\"updated_at\" < '2019-11-05 12:08:00' AND \"users\".\"role\" = 0")1377 -> 0.0014s1378-- exec_query("SELECT \"users\".\"id\" FROM \"users\" WHERE \"users\".\"updated_at\" < '2019-11-05 12:08:00' AND \"users\".\"role\" = 0 ORDER BY \"users\".\"id\" ASC LIMIT 1")1379 -> 0.0009s1380-- exec_query("SELECT \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 1 AND \"users\".\"updated_at\" < '2019-11-05 12:08:00' AND \"users\".\"role\" = 0 ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 1")1381 -> 0.0009s1382-- execute("UPDATE \"users\" SET \"role\" = NULL WHERE \"users\".\"id\" >= 1 AND \"users\".\"updated_at\" < '2019-11-05 12:08:00' AND \"users\".\"role\" = 0")1383 -> 0.0013s1384-- transaction_open?()1385 -> 0.0000s1386-- indexes(:users)1387 -> 0.0134s1388-- remove_index(:users, {:algorithm=>:concurrently, :name=>"partial_index_users_updated_at_for_cleaning_mistaken_values"})1389 -> 0.0018s1390== 20191104142124 NullifyUsersRole: migrated (0.0403s) ========================1391 nullifies the role of the user with updated_at < 2019-11-05 12:08:00 and a role of 01392== 20191104142124 NullifyUsersRole: migrating =================================1393-- transaction_open?()1394 -> 0.0001s1395-- index_exists?(:users, :updated_at, {:where=>"role = 0", :name=>"partial_index_users_updated_at_for_cleaning_mistaken_values", :algorithm=>:concurrently})1396 -> 0.0134s1397-- add_index(:users, :updated_at, {:where=>"role = 0", :name=>"partial_index_users_updated_at_for_cleaning_mistaken_values", :algorithm=>:concurrently})1398 -> 0.0036s1399-- transaction_open?()1400 -> 0.0000s1401-- exec_query("SELECT COUNT(*) AS count FROM \"users\" WHERE \"users\".\"updated_at\" < '2019-11-05 12:08:00' AND \"users\".\"role\" = 0")1402 -> 0.0013s1403-- exec_query("SELECT \"users\".\"id\" FROM \"users\" WHERE \"users\".\"updated_at\" < '2019-11-05 12:08:00' AND \"users\".\"role\" = 0 ORDER BY \"users\".\"id\" ASC LIMIT 1")1404 -> 0.0009s1405-- exec_query("SELECT \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 4 AND \"users\".\"updated_at\" < '2019-11-05 12:08:00' AND \"users\".\"role\" = 0 ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 1")1406 -> 0.0010s1407-- execute("UPDATE \"users\" SET \"role\" = NULL WHERE \"users\".\"id\" >= 4 AND \"users\".\"updated_at\" < '2019-11-05 12:08:00' AND \"users\".\"role\" = 0")1408 -> 0.0011s1409-- transaction_open?()1410 -> 0.0000s1411-- indexes(:users)1412 -> 0.0137s1413-- remove_index(:users, {:algorithm=>:concurrently, :name=>"partial_index_users_updated_at_for_cleaning_mistaken_values"})1414 -> 0.0013s1415== 20191104142124 NullifyUsersRole: migrated (0.0402s) ========================1416 leaves the user with role of 11417== 20191104142124 NullifyUsersRole: migrating =================================1418-- transaction_open?()1419 -> 0.0000s1420-- index_exists?(:users, :updated_at, {:where=>"role = 0", :name=>"partial_index_users_updated_at_for_cleaning_mistaken_values", :algorithm=>:concurrently})1421 -> 0.0129s1422-- add_index(:users, :updated_at, {:where=>"role = 0", :name=>"partial_index_users_updated_at_for_cleaning_mistaken_values", :algorithm=>:concurrently})1423 -> 0.0035s1424-- transaction_open?()1425 -> 0.0000s1426-- exec_query("SELECT COUNT(*) AS count FROM \"users\" WHERE \"users\".\"updated_at\" < '2019-11-05 12:08:00' AND \"users\".\"role\" = 0")1427 -> 0.0012s1428-- exec_query("SELECT \"users\".\"id\" FROM \"users\" WHERE \"users\".\"updated_at\" < '2019-11-05 12:08:00' AND \"users\".\"role\" = 0 ORDER BY \"users\".\"id\" ASC LIMIT 1")1429 -> 0.0008s1430-- exec_query("SELECT \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 7 AND \"users\".\"updated_at\" < '2019-11-05 12:08:00' AND \"users\".\"role\" = 0 ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 1")1431 -> 0.0009s1432-- execute("UPDATE \"users\" SET \"role\" = NULL WHERE \"users\".\"id\" >= 7 AND \"users\".\"updated_at\" < '2019-11-05 12:08:00' AND \"users\".\"role\" = 0")1433 -> 0.0010s1434-- transaction_open?()1435 -> 0.0000s1436-- indexes(:users)1437 -> 0.0134s1438-- remove_index(:users, {:algorithm=>:concurrently, :name=>"partial_index_users_updated_at_for_cleaning_mistaken_values"})1439 -> 0.0013s1440== 20191104142124 NullifyUsersRole: migrated (0.0391s) ========================1441 leaves the user with updated_at > 2019-11-05 12:08:001442NOTICE: trigger "trigger_5299882abc4c" for relation "software_license_policies" does not exist, skipping1443NOTICE: trigger "trigger_e856257b2421" for relation "commit_user_mentions" does not exist, skipping1444NOTICE: trigger "trigger_5e971e2e2c26" for relation "pages_domains" does not exist, skipping1445NOTICE: table "deployment_clusters" does not exist, skipping1446NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping1447NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping1448NOTICE: constraint "lfs_objects_file_store_not_null" of relation "lfs_objects" does not exist, skipping1449NOTICE: constraint "ci_job_artifacts_file_store_not_null" of relation "ci_job_artifacts" does not exist, skipping1450NOTICE: constraint "uploads_store_not_null" of relation "uploads" does not exist, skipping1451NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping1452NOTICE: schema "partitions_dynamic" does not exist, skipping1453NOTICE: table "untracked_files_for_uploads" does not exist, skipping1454NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1455NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1456NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"1457NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"1458NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"1459NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"1460NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"1461NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"1462NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"1463NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"1464NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"1465NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"1466NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"1467NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"1468NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"1469NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"1470NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"1471NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"1472NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1473NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1474NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1475NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"1476NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"1477NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1478NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1479NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1480NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1481MigrateAllMergeRequestUserMentionsToDb1482NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1483NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1484NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1485NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1486NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1487NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1488NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1489NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1490NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1491NOTICE: constraint "check_fcfb4a93ff" of relation "epics" does not exist, skipping1492NOTICE: constraint "check_970d272570" of relation "merge_requests" does not exist, skipping1493NOTICE: constraint "check_fba63f706d" of relation "issues" does not exist, skipping1494NOTICE: constraint "check_81b431e49b" of relation "ci_stages" does not exist, skipping1495NOTICE: constraint "check_1e2fbd1b39" of relation "ci_builds" does not exist, skipping1496NOTICE: constraint "check_d7e99a025e" of relation "ci_pipelines" does not exist, skipping1497 behaves like schedules resource mentions migration1498== 20200601120434 MigrateAllMergeRequestUserMentionsToDb: migrating ===========1499== 20200601120434 MigrateAllMergeRequestUserMentionsToDb: migrated (0.0707s) ==1500 schedules background migrations1501NOTICE: constraint "check_5ebd0515a0" of relation "ci_instance_variables" does not exist, skipping1502NOTICE: schema "partitions_dynamic" does not exist, skipping1503NOTICE: table "untracked_files_for_uploads" does not exist, skipping1504NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1505NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1506NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"1507NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"1508NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"1509NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"1510NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"1511NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"1512NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"1513NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"1514NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"1515NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"1516NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"1517NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"1518NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"1519NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"1520NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"1521NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"1522NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1523NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1524NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1525NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping1526NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"1527NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"1528NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1529NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1530NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1531NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1532MigrateCreateCommitSignatureWorkerSidekiqQueue1533NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1534NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1535NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1536NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1537NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1538NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1539NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1540NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1541NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1542NOTICE: constraint "check_fcfb4a93ff" of relation "epics" does not exist, skipping1543NOTICE: constraint "check_970d272570" of relation "merge_requests" does not exist, skipping1544NOTICE: constraint "check_fba63f706d" of relation "issues" does not exist, skipping1545NOTICE: constraint "check_81b431e49b" of relation "ci_stages" does not exist, skipping1546NOTICE: constraint "check_1e2fbd1b39" of relation "ci_builds" does not exist, skipping1547NOTICE: constraint "check_d7e99a025e" of relation "ci_pipelines" does not exist, skipping1548NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping1549NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping1550NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping1551NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping1552 when there are jobs in the queue1553 correctly migrates queue when migrating up1554 correctly migrates queue when migrating down1555 when there are no jobs in the queues1556 does not raise error when migrating up1557 does not raise error when migrating down1558NOTICE: table "deployment_clusters" does not exist, skipping1559NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping1560NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping1561NOTICE: constraint "lfs_objects_file_store_not_null" of relation "lfs_objects" does not exist, skipping1562NOTICE: constraint "ci_job_artifacts_file_store_not_null" of relation "ci_job_artifacts" does not exist, skipping1563NOTICE: constraint "uploads_store_not_null" of relation "uploads" does not exist, skipping1564NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping1565NOTICE: schema "partitions_dynamic" does not exist, skipping1566NOTICE: table "untracked_files_for_uploads" does not exist, skipping1567NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1568NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1569NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"1570NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"1571NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"1572NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"1573NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"1574NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"1575NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"1576NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"1577NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"1578NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"1579NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"1580NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"1581NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"1582NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"1583NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"1584NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"1585NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1586NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1587NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1588NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"1589NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"1590NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1591NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1592NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1593NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1594MigrateDiscussionIdOnPromotedEpics1595NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1596NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1597NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1598NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1599NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1600NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1601NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1602NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1603NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1604NOTICE: constraint "check_fcfb4a93ff" of relation "epics" does not exist, skipping1605NOTICE: constraint "check_970d272570" of relation "merge_requests" does not exist, skipping1606NOTICE: constraint "check_fba63f706d" of relation "issues" does not exist, skipping1607NOTICE: constraint "check_81b431e49b" of relation "ci_stages" does not exist, skipping1608NOTICE: constraint "check_1e2fbd1b39" of relation "ci_builds" does not exist, skipping1609NOTICE: constraint "check_d7e99a025e" of relation "ci_pipelines" does not exist, skipping1610NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping1611NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping1612NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping1613NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping1614NOTICE: trigger "trigger_5e971e2e2c26" for relation "pages_domains" does not exist, skipping1615NOTICE: trigger "trigger_e856257b2421" for relation "commit_user_mentions" does not exist, skipping1616NOTICE: trigger "trigger_5299882abc4c" for relation "software_license_policies" does not exist, skipping1617NOTICE: trigger "trigger_4821f661bf92" for relation "application_settings" does not exist, skipping1618NOTICE: trigger "trigger_97893debd1d4" for relation "design_management_versions" does not exist, skipping1619NOTICE: trigger "trigger_36edafd19664" for relation "epics" does not exist, skipping1620NOTICE: trigger "trigger_dd1443fbd36e" for relation "application_settings" does not exist, skipping1621NOTICE: trigger "trigger_806273a4d8be" for relation "application_settings" does not exist, skipping1622 with promoted epic1623== 20190715193142 MigrateDiscussionIdOnPromotedEpics: migrating ===============1624-- transaction_open?()1625 -> 0.0000s1626-- index_exists?(:system_note_metadata, :note_id, {:where=>"action='moved'", :name=>"temp_index_system_note_metadata_on_moved_note_id", :algorithm=>:concurrently})1627 -> 0.0019s1628-- add_index(:system_note_metadata, :note_id, {:where=>"action='moved'", :name=>"temp_index_system_note_metadata_on_moved_note_id", :algorithm=>:concurrently})1629 -> 0.0028s1630-- transaction_open?()1631 -> 0.0000s1632-- index_exists?(:notes, [:id, :noteable_id], {:where=>"noteable_type='Epic' AND system", :name=>"temp_index_notes_on_id_and_noteable_id", :algorithm=>:concurrently})1633 -> 0.0085s1634-- add_index(:notes, [:id, :noteable_id], {:where=>"noteable_type='Epic' AND system", :name=>"temp_index_notes_on_id_and_noteable_id", :algorithm=>:concurrently})1635 -> 0.0029s1636-- transaction_open?()1637 -> 0.0000s1638-- index_exists?(:system_note_metadata, :note_id, {:where=>"action='moved'", :name=>"temp_index_system_note_metadata_on_moved_note_id", :algorithm=>:concurrently})1639 -> 0.0024s1640-- remove_index(:system_note_metadata, {:where=>"action='moved'", :name=>"temp_index_system_note_metadata_on_moved_note_id", :algorithm=>:concurrently, :column=>:note_id})1641 -> 0.0033s1642-- transaction_open?()1643 -> 0.0000s1644-- index_exists?(:notes, [:id, :noteable_id], {:where=>"noteable_type='Epic' AND system", :name=>"temp_index_notes_on_id_and_noteable_id", :algorithm=>:concurrently})1645 -> 0.0088s1646-- remove_index(:notes, {:where=>"noteable_type='Epic' AND system", :name=>"temp_index_notes_on_id_and_noteable_id", :algorithm=>:concurrently, :column=>[:id, :noteable_id]})1647 -> 0.0098s1648== 20190715193142 MigrateDiscussionIdOnPromotedEpics: migrated (0.0511s) ======1649 correctly schedules background migrations in batches1650== 20190715193142 MigrateDiscussionIdOnPromotedEpics: migrating ===============1651-- transaction_open?()1652 -> 0.0002s1653-- index_exists?(:system_note_metadata, :note_id, {:where=>"action='moved'", :name=>"temp_index_system_note_metadata_on_moved_note_id", :algorithm=>:concurrently})1654 -> 0.0018s1655-- add_index(:system_note_metadata, :note_id, {:where=>"action='moved'", :name=>"temp_index_system_note_metadata_on_moved_note_id", :algorithm=>:concurrently})1656 -> 0.0030s1657-- transaction_open?()1658 -> 0.0000s1659-- index_exists?(:notes, [:id, :noteable_id], {:where=>"noteable_type='Epic' AND system", :name=>"temp_index_notes_on_id_and_noteable_id", :algorithm=>:concurrently})1660 -> 0.0087s1661-- add_index(:notes, [:id, :noteable_id], {:where=>"noteable_type='Epic' AND system", :name=>"temp_index_notes_on_id_and_noteable_id", :algorithm=>:concurrently})1662 -> 0.0030s1663-- transaction_open?()1664 -> 0.0000s1665-- index_exists?(:system_note_metadata, :note_id, {:where=>"action='moved'", :name=>"temp_index_system_note_metadata_on_moved_note_id", :algorithm=>:concurrently})1666 -> 0.0024s1667-- remove_index(:system_note_metadata, {:where=>"action='moved'", :name=>"temp_index_system_note_metadata_on_moved_note_id", :algorithm=>:concurrently, :column=>:note_id})1668 -> 0.0033s1669-- transaction_open?()1670 -> 0.0002s1671-- index_exists?(:notes, [:id, :noteable_id], {:where=>"noteable_type='Epic' AND system", :name=>"temp_index_notes_on_id_and_noteable_id", :algorithm=>:concurrently})1672 -> 0.0098s1673-- remove_index(:notes, {:where=>"noteable_type='Epic' AND system", :name=>"temp_index_notes_on_id_and_noteable_id", :algorithm=>:concurrently, :column=>[:id, :noteable_id]})1674 -> 0.0099s1675== 20190715193142 MigrateDiscussionIdOnPromotedEpics: migrated (0.0527s) ======1676 schedules only promoted epics1677NOTICE: trigger "trigger_806273a4d8be" for relation "application_settings" does not exist, skipping1678NOTICE: trigger "trigger_dd1443fbd36e" for relation "application_settings" does not exist, skipping1679NOTICE: trigger "trigger_84853438aac0" for relation "epics" does not exist, skipping1680NOTICE: trigger "trigger_97893debd1d4" for relation "design_management_versions" does not exist, skipping1681NOTICE: trigger "trigger_4821f661bf92" for relation "application_settings" does not exist, skipping1682DEPRECATION WARNING: Class level methods will no longer inherit scoping from `with_unique_issue_ids` in Rails 6.1. To continue using the scoped relation, pass it into the block directly. To instead access the full set of models, as Rails 6.1 will, use `BackfillVersionAuthorAndCreatedAt::Version.default_scoped`. (called from block in <class:Version> at /builds/gitlab-org/gitlab/db/post_migrate/20191030223057_backfill_version_author_and_created_at.rb:32)1683NOTICE: trigger "trigger_5299882abc4c" for relation "software_license_policies" does not exist, skipping1684NOTICE: trigger "trigger_e856257b2421" for relation "commit_user_mentions" does not exist, skipping1685NOTICE: trigger "trigger_5e971e2e2c26" for relation "pages_domains" does not exist, skipping1686NOTICE: table "deployment_clusters" does not exist, skipping1687NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping1688NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping1689NOTICE: constraint "lfs_objects_file_store_not_null" of relation "lfs_objects" does not exist, skipping1690NOTICE: constraint "ci_job_artifacts_file_store_not_null" of relation "ci_job_artifacts" does not exist, skipping1691NOTICE: constraint "uploads_store_not_null" of relation "uploads" does not exist, skipping1692NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping1693NOTICE: schema "partitions_dynamic" does not exist, skipping1694NOTICE: table "untracked_files_for_uploads" does not exist, skipping1695NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1696NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1697NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"1698NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"1699NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"1700NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"1701NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"1702NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"1703NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"1704NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"1705NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"1706NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"1707NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"1708NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"1709NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"1710NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"1711NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"1712NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"1713NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1714NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1715NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1716NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"1717NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"1718NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1719NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1720NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1721NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1722SchedulePopulateHasVulnerabilities1723NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1724NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1725NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1726NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1727== 20201103192526 SchedulePopulateHasVulnerabilities: migrating ===============1728== 20201103192526 SchedulePopulateHasVulnerabilities: migrated (0.0410s) ======1729 schedules the background jobs1730NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping1731NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"1732NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"1733NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1734NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1735NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1736NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1737FillFileStoreLfsObjects1738NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1739NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1740NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1741NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1742NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1743NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1744NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1745NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1746NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1747NOTICE: constraint "check_fcfb4a93ff" of relation "epics" does not exist, skipping1748NOTICE: constraint "check_970d272570" of relation "merge_requests" does not exist, skipping1749NOTICE: constraint "check_fba63f706d" of relation "issues" does not exist, skipping1750NOTICE: constraint "check_81b431e49b" of relation "ci_stages" does not exist, skipping1751NOTICE: constraint "check_1e2fbd1b39" of relation "ci_builds" does not exist, skipping1752NOTICE: constraint "check_d7e99a025e" of relation "ci_pipelines" does not exist, skipping1753 when file_store is nil1754== 20200513234502 FillFileStoreLfsObjects: migrating ==========================1755-- transaction_open?()1756 -> 0.0000s1757-- exec_query("SELECT COUNT(*) AS count FROM \"lfs_objects\" WHERE \"lfs_objects\".\"file_store\" IS NULL")1758 -> 0.0009s1759-- exec_query("SELECT \"lfs_objects\".\"id\" FROM \"lfs_objects\" WHERE \"lfs_objects\".\"file_store\" IS NULL ORDER BY \"lfs_objects\".\"id\" ASC LIMIT 1")1760 -> 0.0008s1761-- exec_query("SELECT \"lfs_objects\".\"id\" FROM \"lfs_objects\" WHERE \"lfs_objects\".\"id\" >= 1 AND \"lfs_objects\".\"file_store\" IS NULL ORDER BY \"lfs_objects\".\"id\" ASC LIMIT 1 OFFSET 1")1762 -> 0.0008s1763-- execute("UPDATE \"lfs_objects\" SET \"file_store\" = 1 WHERE \"lfs_objects\".\"id\" >= 1 AND \"lfs_objects\".\"file_store\" IS NULL")1764 -> 0.0006s1765== 20200513234502 FillFileStoreLfsObjects: migrated (0.0045s) =================1766 updates file_store to local1767 when file_store is set to local1768== 20200513234502 FillFileStoreLfsObjects: migrating ==========================1769-- transaction_open?()1770 -> 0.0001s1771-- exec_query("SELECT COUNT(*) AS count FROM \"lfs_objects\" WHERE \"lfs_objects\".\"file_store\" IS NULL")1772 -> 0.0007s1773== 20200513234502 FillFileStoreLfsObjects: migrated (0.0015s) =================1774 does not update file_store1775 when file_store is set to object storage1776== 20200513234502 FillFileStoreLfsObjects: migrating ==========================1777-- transaction_open?()1778 -> 0.0000s1779-- exec_query("SELECT COUNT(*) AS count FROM \"lfs_objects\" WHERE \"lfs_objects\".\"file_store\" IS NULL")1780 -> 0.0007s1781== 20200513234502 FillFileStoreLfsObjects: migrated (0.0011s) =================1782 does not update file_store1783NOTICE: constraint "check_5ebd0515a0" of relation "ci_instance_variables" does not exist, skipping1784NOTICE: schema "partitions_dynamic" does not exist, skipping1785NOTICE: table "untracked_files_for_uploads" does not exist, skipping1786NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1787NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1788NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"1789NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"1790NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"1791NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"1792NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"1793NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"1794NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"1795NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"1796NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"1797NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"1798NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"1799NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"1800NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"1801NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"1802NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"1803NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"1804NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1805NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1806NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1807NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping1808NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"1809NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"1810NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1811NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1812NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1813NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1814CreateInitialVersionsForPreVersioningTerraformStates1815NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1816NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1817NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1818NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1819NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1820NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1821NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1822 #up1823 for a state that is already versioned1824== 20200929052138 CreateInitialVersionsForPreVersioningTerraformStates: migrating 1825-- execute(" INSERT INTO terraform_state_versions (terraform_state_id, created_at, updated_at, version, file_store, file)\n SELECT id, NOW(), NOW(), 0, file_store, file\n FROM terraform_states\n WHERE versioning_enabled = FALSE\n ON CONFLICT (terraform_state_id, version) DO NOTHING\n")1826 -> 0.0013s1827== 20200929052138 CreateInitialVersionsForPreVersioningTerraformStates: migrated (0.0014s) 1828 does not insert a version record1829 for a state that is not yet versioned1830== 20200929052138 CreateInitialVersionsForPreVersioningTerraformStates: migrating 1831-- execute(" INSERT INTO terraform_state_versions (terraform_state_id, created_at, updated_at, version, file_store, file)\n SELECT id, NOW(), NOW(), 0, file_store, file\n FROM terraform_states\n WHERE versioning_enabled = FALSE\n ON CONFLICT (terraform_state_id, version) DO NOTHING\n")1832 -> 0.0016s1833== 20200929052138 CreateInitialVersionsForPreVersioningTerraformStates: migrated (0.0019s) 1834 creates a version using the current state data1835NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"1836NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"1837NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"1838NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"1839NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"1840NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"1841NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"1842NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"1843NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"1844NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"1845NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"1846NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"1847NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"1848NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"1849NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"1850NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"1851NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1852NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1853NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1854NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping1855NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"1856NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"1857NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1858NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1859NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1860NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1861ReplaceUniqueIndexOnCycleAnalyticsStages1862NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1863NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1864NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1865NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1866NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1867NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1868NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1869NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1870NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1871 #down1872-- transaction_open?()1873 -> 0.0001s1874-- index_exists?(:analytics_cycle_analytics_group_stages, [:group_id, :group_value_stream_id, :name], {:unique=>true, :name=>"index_group_stages_on_group_id_group_value_stream_id_and_name", :algorithm=>:concurrently})1875 -> 0.0063s1876-- transaction_open?()1877 -> 0.0001s1878-- indexes(:analytics_cycle_analytics_group_stages)1879 -> 0.0050s1880-- current_schema()1881 -> 0.0005s1882-- execute(" DELETE FROM analytics_cycle_analytics_group_stages\n USING (\n SELECT group_id, name, MIN(id) as min_id\n FROM analytics_cycle_analytics_group_stages\n GROUP BY group_id, name\n HAVING COUNT(id) > 1\n ) as analytics_cycle_analytics_group_stages_name_duplicates\n WHERE analytics_cycle_analytics_group_stages_name_duplicates.group_id = analytics_cycle_analytics_group_stages.group_id\n AND analytics_cycle_analytics_group_stages_name_duplicates.name = analytics_cycle_analytics_group_stages.name\n AND analytics_cycle_analytics_group_stages_name_duplicates.min_id <> analytics_cycle_analytics_group_stages.id\n")1883 -> 0.0013s1884-- transaction_open?()1885 -> 0.0000s1886-- index_exists?(:analytics_cycle_analytics_group_stages, [:group_id, :name], {:unique=>true, :name=>"index_analytics_ca_group_stages_on_group_id_and_name", :algorithm=>:concurrently})1887 -> 0.0051s1888-- add_index(:analytics_cycle_analytics_group_stages, [:group_id, :name], {:unique=>true, :name=>"index_analytics_ca_group_stages_on_group_id_and_name", :algorithm=>:concurrently})1889 -> 0.0031s1890-- transaction_open?()1891 -> 0.0000s1892-- indexes(:analytics_cycle_analytics_group_stages)1893 -> 0.0057s1894-- remove_index(:analytics_cycle_analytics_group_stages, {:algorithm=>:concurrently, :name=>"index_group_stages_on_group_id_group_value_stream_id_and_name"})1895 -> 0.0012s1896 removes duplicated stage records1897-- transaction_open?()1898 -> 0.0001s1899-- index_exists?(:analytics_cycle_analytics_group_stages, [:group_id, :group_value_stream_id, :name], {:unique=>true, :name=>"index_group_stages_on_group_id_group_value_stream_id_and_name", :algorithm=>:concurrently})1900 -> 0.0058s1901-- add_index(:analytics_cycle_analytics_group_stages, [:group_id, :group_value_stream_id, :name], {:unique=>true, :name=>"index_group_stages_on_group_id_group_value_stream_id_and_name", :algorithm=>:concurrently})1902 -> 0.0030s1903-- transaction_open?()1904 -> 0.0001s1905-- indexes(:analytics_cycle_analytics_group_stages)1906 -> 0.0057s1907-- remove_index(:analytics_cycle_analytics_group_stages, {:algorithm=>:concurrently, :name=>"index_analytics_ca_group_stages_on_group_id_and_name"})1908 -> 0.0013s1909-- execute(" DELETE FROM analytics_cycle_analytics_group_stages\n USING (\n SELECT group_id, name, MIN(id) as min_id\n FROM analytics_cycle_analytics_group_stages\n GROUP BY group_id, name\n HAVING COUNT(id) > 1\n ) as analytics_cycle_analytics_group_stages_name_duplicates\n WHERE analytics_cycle_analytics_group_stages_name_duplicates.group_id = analytics_cycle_analytics_group_stages.group_id\n AND analytics_cycle_analytics_group_stages_name_duplicates.name = analytics_cycle_analytics_group_stages.name\n AND analytics_cycle_analytics_group_stages_name_duplicates.min_id <> analytics_cycle_analytics_group_stages.id\n")1910 -> 0.0011s1911-- transaction_open?()1912 -> 0.0002s1913-- index_exists?(:analytics_cycle_analytics_group_stages, [:group_id, :name], {:unique=>true, :name=>"index_analytics_ca_group_stages_on_group_id_and_name", :algorithm=>:concurrently})1914 -> 0.0051s1915-- add_index(:analytics_cycle_analytics_group_stages, [:group_id, :name], {:unique=>true, :name=>"index_analytics_ca_group_stages_on_group_id_and_name", :algorithm=>:concurrently})1916 -> 0.0030s1917-- transaction_open?()1918 -> 0.0000s1919-- indexes(:analytics_cycle_analytics_group_stages)1920 -> 0.0055s1921-- remove_index(:analytics_cycle_analytics_group_stages, {:algorithm=>:concurrently, :name=>"index_group_stages_on_group_id_group_value_stream_id_and_name"})1922 -> 0.0013s1923 does not change the first duplicated stage record1924-- transaction_open?()1925 -> 0.0001s1926-- index_exists?(:analytics_cycle_analytics_group_stages, [:group_id, :group_value_stream_id, :name], {:unique=>true, :name=>"index_group_stages_on_group_id_group_value_stream_id_and_name", :algorithm=>:concurrently})1927 -> 0.0075s1928-- add_index(:analytics_cycle_analytics_group_stages, [:group_id, :group_value_stream_id, :name], {:unique=>true, :name=>"index_group_stages_on_group_id_group_value_stream_id_and_name", :algorithm=>:concurrently})1929 -> 0.0035s1930-- transaction_open?()1931 -> 0.0000s1932-- indexes(:analytics_cycle_analytics_group_stages)1933 -> 0.0062s1934-- remove_index(:analytics_cycle_analytics_group_stages, {:algorithm=>:concurrently, :name=>"index_analytics_ca_group_stages_on_group_id_and_name"})1935 -> 0.0013s1936-- execute(" DELETE FROM analytics_cycle_analytics_group_stages\n USING (\n SELECT group_id, name, MIN(id) as min_id\n FROM analytics_cycle_analytics_group_stages\n GROUP BY group_id, name\n HAVING COUNT(id) > 1\n ) as analytics_cycle_analytics_group_stages_name_duplicates\n WHERE analytics_cycle_analytics_group_stages_name_duplicates.group_id = analytics_cycle_analytics_group_stages.group_id\n AND analytics_cycle_analytics_group_stages_name_duplicates.name = analytics_cycle_analytics_group_stages.name\n AND analytics_cycle_analytics_group_stages_name_duplicates.min_id <> analytics_cycle_analytics_group_stages.id\n")1937 -> 0.0011s1938-- transaction_open?()1939 -> 0.0000s1940-- index_exists?(:analytics_cycle_analytics_group_stages, [:group_id, :name], {:unique=>true, :name=>"index_analytics_ca_group_stages_on_group_id_and_name", :algorithm=>:concurrently})1941 -> 0.0054s1942-- add_index(:analytics_cycle_analytics_group_stages, [:group_id, :name], {:unique=>true, :name=>"index_analytics_ca_group_stages_on_group_id_and_name", :algorithm=>:concurrently})1943 -> 0.0029s1944-- transaction_open?()1945 -> 0.0000s1946-- indexes(:analytics_cycle_analytics_group_stages)1947 -> 0.0057s1948-- remove_index(:analytics_cycle_analytics_group_stages, {:algorithm=>:concurrently, :name=>"index_group_stages_on_group_id_group_value_stream_id_and_name"})1949 -> 0.0013s1950 does not change not duplicated stage record1951NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1952NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1953NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"1954NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"1955NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"1956NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"1957NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"1958NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"1959NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"1960NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"1961NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"1962NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"1963NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"1964NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"1965NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"1966NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"1967NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"1968NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"1969NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1970NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1971NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1972NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping1973NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"1974NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"1975NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1976NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1977NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1978NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1979CleanupOptimisticLockingNulls1980NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping1981NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping1982NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping1983NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping1984NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping1985NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping1986NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping1987NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping1988NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping1989NOTICE: constraint "check_fcfb4a93ff" of relation "epics" does not exist, skipping1990NOTICE: constraint "check_970d272570" of relation "merge_requests" does not exist, skipping1991NOTICE: constraint "check_fba63f706d" of relation "issues" does not exist, skipping1992NOTICE: constraint "check_81b431e49b" of relation "ci_stages" does not exist, skipping1993NOTICE: constraint "check_1e2fbd1b39" of relation "ci_builds" does not exist, skipping1994NOTICE: constraint "check_d7e99a025e" of relation "ci_pipelines" does not exist, skipping1995NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping1996NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping1997NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping1998NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping1999NOTICE: trigger "trigger_5e971e2e2c26" for relation "pages_domains" does not exist, skipping2000== 20200128210353 CleanupOptimisticLockingNulls: migrating ====================2001-- transaction_open?()2002 -> 0.0000s2003-- index_exists?(:epics, :lock_version, {:where=>"lock_version IS NULL", :algorithm=>:concurrently})2004 -> 0.0077s2005-- add_index(:epics, :lock_version, {:where=>"lock_version IS NULL", :algorithm=>:concurrently})2006 -> 0.0034s2007-- Scheduled 1 CleanupOptimisticLockingNulls jobs with a maximum of 10000 records per batch and an interval of 120 seconds.2008The migration is expected to take at least 120 seconds. Expect all jobs to have completed after 2021-03-03 12:18:28 UTC."2009-- transaction_open?()2010 -> 0.0000s2011-- index_exists?(:merge_requests, :lock_version, {:where=>"lock_version IS NULL", :algorithm=>:concurrently})2012 -> 0.0161s2013-- add_index(:merge_requests, :lock_version, {:where=>"lock_version IS NULL", :algorithm=>:concurrently})2014 -> 0.0036s2015-- Scheduled 1 CleanupOptimisticLockingNulls jobs with a maximum of 10000 records per batch and an interval of 120 seconds.2016The migration is expected to take at least 120 seconds. Expect all jobs to have completed after 2021-03-03 12:18:28 UTC."2017-- transaction_open?()2018 -> 0.0000s2019-- index_exists?(:issues, :lock_version, {:where=>"lock_version IS NULL", :algorithm=>:concurrently})2020 -> 0.0147s2021-- add_index(:issues, :lock_version, {:where=>"lock_version IS NULL", :algorithm=>:concurrently})2022 -> 0.0035s2023-- Scheduled 1 CleanupOptimisticLockingNulls jobs with a maximum of 10000 records per batch and an interval of 120 seconds.2024The migration is expected to take at least 120 seconds. Expect all jobs to have completed after 2021-03-03 12:18:28 UTC."2025== 20200128210353 CleanupOptimisticLockingNulls: migrated (0.2024s) ===========2026 correctly migrates nullified lock_version column2027NOTICE: trigger "trigger_5e971e2e2c26" for relation "pages_domains" does not exist, skipping2028NOTICE: table "deployment_clusters" does not exist, skipping2029NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping2030NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping2031NOTICE: constraint "lfs_objects_file_store_not_null" of relation "lfs_objects" does not exist, skipping2032NOTICE: constraint "ci_job_artifacts_file_store_not_null" of relation "ci_job_artifacts" does not exist, skipping2033NOTICE: constraint "uploads_store_not_null" of relation "uploads" does not exist, skipping2034NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping2035NOTICE: schema "partitions_dynamic" does not exist, skipping2036NOTICE: table "untracked_files_for_uploads" does not exist, skipping2037NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping2038NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping2039NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"2040NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"2041NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"2042NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"2043NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"2044NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"2045NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"2046NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"2047NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"2048NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"2049NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"2050NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"2051NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"2052NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"2053NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"2054NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"2055NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping2056NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping2057NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping2058NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"2059NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"2060NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping2061NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping2062NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping2063NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping2064TruncateUserFullname2065NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping2066NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping2067NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping2068NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping2069NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping2070NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping2071NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping2072NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping2073NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping2074NOTICE: constraint "check_fcfb4a93ff" of relation "epics" does not exist, skipping2075NOTICE: constraint "check_970d272570" of relation "merge_requests" does not exist, skipping2076NOTICE: constraint "check_fba63f706d" of relation "issues" does not exist, skipping2077NOTICE: constraint "check_81b431e49b" of relation "ci_stages" does not exist, skipping2078NOTICE: constraint "check_1e2fbd1b39" of relation "ci_builds" does not exist, skipping2079NOTICE: constraint "check_d7e99a025e" of relation "ci_pipelines" does not exist, skipping2080NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping2081NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping2082NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping2083NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping2084NOTICE: trigger "trigger_5e971e2e2c26" for relation "pages_domains" does not exist, skipping2085NOTICE: trigger "trigger_e856257b2421" for relation "commit_user_mentions" does not exist, skipping2086NOTICE: trigger "trigger_5299882abc4c" for relation "software_license_policies" does not exist, skipping2087NOTICE: trigger "trigger_4821f661bf92" for relation "application_settings" does not exist, skipping2088NOTICE: trigger "trigger_97893debd1d4" for relation "design_management_versions" does not exist, skipping2089NOTICE: trigger "trigger_36edafd19664" for relation "epics" does not exist, skipping2090NOTICE: trigger "trigger_dd1443fbd36e" for relation "application_settings" does not exist, skipping2091NOTICE: trigger "trigger_806273a4d8be" for relation "application_settings" does not exist, skipping2092== 20190325080727 TruncateUserFullname: migrating =============================2093-- transaction_open?()2094 -> 0.0000s2095-- exec_query("SELECT COUNT(*) AS count FROM \"users\" WHERE LENGTH(name) > 128")2096 -> 0.0011s2097-- exec_query("SELECT \"users\".\"id\" FROM \"users\" WHERE LENGTH(name) > 128 ORDER BY \"users\".\"id\" ASC LIMIT 1")2098 -> 0.0010s2099-- exec_query("SELECT \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 18 AND LENGTH(name) > 128 ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 1")2100 -> 0.0009s2101-- execute("UPDATE \"users\" SET \"name\" = SUBSTRING(name from 1 for 128) WHERE \"users\".\"id\" >= 18 AND LENGTH(name) > 128")2102 -> 0.0013s2103== 20190325080727 TruncateUserFullname: migrated (0.0057s) ====================2104 truncates user full name to the first 128 characters2105== 20190325080727 TruncateUserFullname: migrating =============================2106-- transaction_open?()2107 -> 0.0002s2108-- exec_query("SELECT COUNT(*) AS count FROM \"users\" WHERE LENGTH(name) > 128")2109 -> 0.0009s2110== 20190325080727 TruncateUserFullname: migrated (0.0016s) ====================2111 does not truncate short names2112NOTICE: table "design_management_designs" does not exist, skipping2113NOTICE: table "design_management_designs_versions" does not exist, skipping2114NOTICE: table "design_management_versions" does not exist, skipping2115NOTICE: table "geo_container_repository_updated_events" does not exist, skipping2116NOTICE: trigger "trigger_806273a4d8be" for relation "application_settings" does not exist, skipping2117NOTICE: trigger "trigger_dd1443fbd36e" for relation "application_settings" does not exist, skipping2118NOTICE: trigger "trigger_84853438aac0" for relation "epics" does not exist, skipping2119NOTICE: trigger "trigger_97893debd1d4" for relation "design_management_versions" does not exist, skipping2120NOTICE: trigger "trigger_4821f661bf92" for relation "application_settings" does not exist, skipping2121DEPRECATION WARNING: Class level methods will no longer inherit scoping from `with_unique_issue_ids` in Rails 6.1. To continue using the scoped relation, pass it into the block directly. To instead access the full set of models, as Rails 6.1 will, use `BackfillVersionAuthorAndCreatedAt::Version.default_scoped`. (called from block in <class:Version> at /builds/gitlab-org/gitlab/db/post_migrate/20191030223057_backfill_version_author_and_created_at.rb:32)2122NOTICE: trigger "trigger_5299882abc4c" for relation "software_license_policies" does not exist, skipping2123NOTICE: trigger "trigger_e856257b2421" for relation "commit_user_mentions" does not exist, skipping2124NOTICE: trigger "trigger_5e971e2e2c26" for relation "pages_domains" does not exist, skipping2125NOTICE: table "deployment_clusters" does not exist, skipping2126NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping2127NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping2128NOTICE: constraint "lfs_objects_file_store_not_null" of relation "lfs_objects" does not exist, skipping2129NOTICE: constraint "ci_job_artifacts_file_store_not_null" of relation "ci_job_artifacts" does not exist, skipping2130NOTICE: constraint "uploads_store_not_null" of relation "uploads" does not exist, skipping2131NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping2132NOTICE: schema "partitions_dynamic" does not exist, skipping2133NOTICE: table "untracked_files_for_uploads" does not exist, skipping2134NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping2135NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping2136NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"2137NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"2138NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"2139NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"2140NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"2141NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"2142NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"2143NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"2144NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"2145NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"2146NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"2147NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"2148NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"2149NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"2150NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"2151NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"2152NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping2153NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping2154NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping2155NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"2156NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"2157NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping2158NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping2159NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping2160NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping2161Gitlab::BackgroundMigration::PopulateMergeRequestAssigneesTable2162NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping2163NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping2164NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping2165NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping2166NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping2167NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping2168NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping2169NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping2170NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping2171NOTICE: constraint "check_fcfb4a93ff" of relation "epics" does not exist, skipping2172NOTICE: constraint "check_970d272570" of relation "merge_requests" does not exist, skipping2173NOTICE: constraint "check_fba63f706d" of relation "issues" does not exist, skipping2174NOTICE: constraint "check_81b431e49b" of relation "ci_stages" does not exist, skipping2175NOTICE: constraint "check_1e2fbd1b39" of relation "ci_builds" does not exist, skipping2176NOTICE: constraint "check_d7e99a025e" of relation "ci_pipelines" does not exist, skipping2177NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping2178NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping2179NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping2180NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping2181NOTICE: trigger "trigger_5e971e2e2c26" for relation "pages_domains" does not exist, skipping2182NOTICE: trigger "trigger_e856257b2421" for relation "commit_user_mentions" does not exist, skipping2183NOTICE: trigger "trigger_5299882abc4c" for relation "software_license_policies" does not exist, skipping2184NOTICE: trigger "trigger_4821f661bf92" for relation "application_settings" does not exist, skipping2185NOTICE: trigger "trigger_97893debd1d4" for relation "design_management_versions" does not exist, skipping2186NOTICE: trigger "trigger_36edafd19664" for relation "epics" does not exist, skipping2187NOTICE: trigger "trigger_dd1443fbd36e" for relation "application_settings" does not exist, skipping2188NOTICE: trigger "trigger_806273a4d8be" for relation "application_settings" does not exist, skipping2189 #perform2190 creates merge_request_assignees rows according to merge_requests2191 #perform_all_sync2192 executes peform for all merge requests in batches2193NOTICE: table "design_management_designs" does not exist, skipping2194NOTICE: table "design_management_designs_versions" does not exist, skipping2195NOTICE: table "design_management_versions" does not exist, skipping2196NOTICE: table "geo_container_repository_updated_events" does not exist, skipping2197NOTICE: trigger "trigger_806273a4d8be" for relation "application_settings" does not exist, skipping2198NOTICE: trigger "trigger_dd1443fbd36e" for relation "application_settings" does not exist, skipping2199NOTICE: trigger "trigger_84853438aac0" for relation "epics" does not exist, skipping2200NOTICE: trigger "trigger_97893debd1d4" for relation "design_management_versions" does not exist, skipping2201NOTICE: trigger "trigger_4821f661bf92" for relation "application_settings" does not exist, skipping2202DEPRECATION WARNING: Class level methods will no longer inherit scoping from `with_unique_issue_ids` in Rails 6.1. To continue using the scoped relation, pass it into the block directly. To instead access the full set of models, as Rails 6.1 will, use `BackfillVersionAuthorAndCreatedAt::Version.default_scoped`. (called from block in <class:Version> at /builds/gitlab-org/gitlab/db/post_migrate/20191030223057_backfill_version_author_and_created_at.rb:32)2203NOTICE: trigger "trigger_5299882abc4c" for relation "software_license_policies" does not exist, skipping2204NOTICE: trigger "trigger_e856257b2421" for relation "commit_user_mentions" does not exist, skipping2205NOTICE: trigger "trigger_5e971e2e2c26" for relation "pages_domains" does not exist, skipping2206NOTICE: table "deployment_clusters" does not exist, skipping2207NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping2208NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping2209NOTICE: constraint "lfs_objects_file_store_not_null" of relation "lfs_objects" does not exist, skipping2210NOTICE: constraint "ci_job_artifacts_file_store_not_null" of relation "ci_job_artifacts" does not exist, skipping2211NOTICE: constraint "uploads_store_not_null" of relation "uploads" does not exist, skipping2212NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping2213NOTICE: schema "partitions_dynamic" does not exist, skipping2214NOTICE: table "untracked_files_for_uploads" does not exist, skipping2215NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping2216NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping2217NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"2218NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"2219NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"2220NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"2221NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"2222NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"2223NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"2224NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"2225NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"2226NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"2227NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"2228NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"2229NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"2230NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"2231NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"2232NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"2233NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping2234NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping2235NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping2236NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"2237NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"2238NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping2239NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping2240NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping2241NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping2242The application_settings table has 1371 columns.2243Recreating the database2244Dropped database 'gitlabhq_test'2245Created database 'gitlabhq_test'2246Database re-creation done in 4.5519596389995062247Gitlab::BackgroundMigration::RecalculateProjectAuthorizationsWithMinMaxUserId2248NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping2249NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping2250NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping2251NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping2252NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping2253NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping2254NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping2255NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping2256NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping2257NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping2258NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping2259NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping2260NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping2261 #perform2262 initializes Users::RefreshAuthorizedProjectsService with correct users2263 executes Users::RefreshAuthorizedProjectsService2264NOTICE: table "deployment_clusters" does not exist, skipping2265NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping2266NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping2267NOTICE: constraint "lfs_objects_file_store_not_null" of relation "lfs_objects" does not exist, skipping2268NOTICE: constraint "ci_job_artifacts_file_store_not_null" of relation "ci_job_artifacts" does not exist, skipping2269NOTICE: constraint "uploads_store_not_null" of relation "uploads" does not exist, skipping2270NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping2271NOTICE: schema "partitions_dynamic" does not exist, skipping2272NOTICE: table "untracked_files_for_uploads" does not exist, skipping2273NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping2274NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping2275NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"2276NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"2277NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"2278NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"2279NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"2280NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"2281NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"2282NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"2283NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"2284NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"2285NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"2286NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"2287NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"2288NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"2289NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"2290NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"2291NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping2292NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping2293NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping2294NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"2295NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"2296NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping2297NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping2298NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping2299NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping2300ScheduleBlockedByLinksReplacementSecondTry2301NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping2302NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping2303NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping2304NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping2305== 20201102073808 ScheduleBlockedByLinksReplacementSecondTry: migrating =======2306-- Scheduled 2 ReplaceBlockedByLinks jobs with a maximum of 1 records per batch and an interval of 120 seconds.2307The migration is expected to take at least 240 seconds. Expect all jobs to have completed after 2021-03-03 12:23:29 UTC."2308== 20201102073808 ScheduleBlockedByLinksReplacementSecondTry: migrated (0.0172s) 2309 schedules jobs for blocked_by links2310NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping2311NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"2312NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"2313NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping2314NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping2315NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping2316NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping2317DropActivatePrometheusServicesBackgroundJobs2318NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping2319NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping2320NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping2321NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping2322NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping2323NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping2324NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping2325NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping2326NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping2327NOTICE: constraint "check_fcfb4a93ff" of relation "epics" does not exist, skipping2328NOTICE: constraint "check_970d272570" of relation "merge_requests" does not exist, skipping2329NOTICE: constraint "check_fba63f706d" of relation "issues" does not exist, skipping2330NOTICE: constraint "check_81b431e49b" of relation "ci_stages" does not exist, skipping2331NOTICE: constraint "check_1e2fbd1b39" of relation "ci_builds" does not exist, skipping2332NOTICE: constraint "check_d7e99a025e" of relation "ci_pipelines" does not exist, skipping2333NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping2334NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping2335NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping2336NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping2337 #up2338 there are only affected jobs on the queue2339 removes enqueued ActivatePrometheusServicesForSharedClusterApplications background jobs2340 there aren't any affected jobs on the queue2341 skips other enqueued jobs2342 there are multiple types of jobs on the queue2343 skips other enqueued jobs2344 other queues2345 does not modify them2346NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping2347NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping2348NOTICE: constraint "lfs_objects_file_store_not_null" of relation "lfs_objects" does not exist, skipping2349NOTICE: constraint "ci_job_artifacts_file_store_not_null" of relation "ci_job_artifacts" does not exist, skipping2350NOTICE: constraint "uploads_store_not_null" of relation "uploads" does not exist, skipping2351NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping2352NOTICE: schema "partitions_dynamic" does not exist, skipping2353NOTICE: table "untracked_files_for_uploads" does not exist, skipping2354NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping2355NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping2356NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"2357NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"2358NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"2359NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"2360NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"2361NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"2362NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"2363NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"2364NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"2365NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"2366NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"2367NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"2368NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"2369NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"2370NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"2371NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"2372NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping2373NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping2374NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping2375NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"2376NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"2377NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping2378NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping2379NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping2380NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping2381SchedulePopulateMissingDismissalInformationForVulnerabilities2382NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping2383NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping2384NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping2385NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping2386NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping2387NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping2388NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping2389== 20201028160832 SchedulePopulateMissingDismissalInformationForVulnerabilities: migrating 2390== 20201028160832 SchedulePopulateMissingDismissalInformationForVulnerabilities: migrated (0.0488s) 2391 schedules the background jobs2392NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping2393NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping2394NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping2395NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping2396NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"2397NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"2398NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping2399NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping2400NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping2401NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping2402FixMaxPagesSize2403NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping2404NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping2405NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping2406NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping2407NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping2408NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping2409NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping2410NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping2411NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping2412NOTICE: constraint "check_fcfb4a93ff" of relation "epics" does not exist, skipping2413NOTICE: constraint "check_970d272570" of relation "merge_requests" does not exist, skipping2414NOTICE: constraint "check_fba63f706d" of relation "issues" does not exist, skipping2415NOTICE: constraint "check_81b431e49b" of relation "ci_stages" does not exist, skipping2416NOTICE: constraint "check_1e2fbd1b39" of relation "ci_builds" does not exist, skipping2417NOTICE: constraint "check_d7e99a025e" of relation "ci_pipelines" does not exist, skipping2418NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping2419NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping2420NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping2421NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping2422NOTICE: trigger "trigger_5e971e2e2c26" for relation "pages_domains" does not exist, skipping2423== 20191213120427 FixMaxPagesSize: migrating ==================================2424== 20191213120427 FixMaxPagesSize: migrated (0.0091s) =========================2425 correctly updates settings only if needed2426NOTICE: trigger "trigger_5e971e2e2c26" for relation "pages_domains" does not exist, skipping2427NOTICE: table "deployment_clusters" does not exist, skipping2428NOTICE: trigger "trigger_27c6ea5cb43e" for relation "vulnerabilities" does not exist, skipping2429NOTICE: trigger "trigger_9ab19b89128a" for relation "vulnerabilities" does not exist, skipping2430NOTICE: constraint "lfs_objects_file_store_not_null" of relation "lfs_objects" does not exist, skipping2431NOTICE: constraint "ci_job_artifacts_file_store_not_null" of relation "ci_job_artifacts" does not exist, skipping2432NOTICE: constraint "uploads_store_not_null" of relation "uploads" does not exist, skipping2433NOTICE: trigger "trigger_f14363ffbcd3" for relation "sprints" does not exist, skipping2434NOTICE: schema "partitions_dynamic" does not exist, skipping2435NOTICE: table "untracked_files_for_uploads" does not exist, skipping2436NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping2437NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping2438NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"2439NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"2440NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"2441NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"2442NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"2443NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"2444NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"2445NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"2446NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"2447NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"2448NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"2449NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"2450NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"2451NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"2452NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"2453NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"2454NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping2455NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping2456NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping2457NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"2458NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"2459NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping2460NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping2461NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping2462NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping2463Gitlab::BackgroundMigration::AddModifiedToApprovalMergeRequestRule2464NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping2465NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping2466NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping2467NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping2468NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping2469NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping2470NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping2471NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping2472NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping2473 #perform2474 changes the correct rules2475NOTICE: trigger "trigger_d5eb03a59792" for relation "packages_pypi_metadata" does not exist, skipping2476NOTICE: trigger "trigger_8fe85065a3f9" for relation "application_settings" does not exist, skipping2477NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_authorizations_on_user_id_project_id_access_level" to "project_authorizations_pkey"2478NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "analytics_repository_languages_unique_index" to "analytics_language_trend_repository_languages_pkey"2479NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_approval_project_rules_protected_branches_unique" to "approval_project_rules_protected_branches_pkey"2480NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_ci_build_trace_sections_on_build_id_and_section_name_id" to "ci_build_trace_sections_pkey"2481NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "idx_deployment_merge_requests_unique_index" to "deployment_merge_requests_pkey"2482NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_issue_assignees_on_issue_id_and_user_id" to "issue_assignees_pkey"2483NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_prometheus_alert_event_id_index" to "issues_prometheus_alert_events_pkey"2484NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "issue_id_self_managed_prometheus_alert_event_id_index" to "issues_self_managed_prometheus_alert_events_pkey"2485NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_commits_on_mr_diff_id_and_order" to "merge_request_diff_commits_pkey"2486NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_merge_request_diff_files_on_mr_diff_id_and_order" to "merge_request_diff_files_pkey"2487NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_miletone_releases_on_milestone_and_release" to "milestone_releases_pkey"2488NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_project_pages_metadata_on_project_id" to "project_pages_metadata_pkey"2489NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_push_event_payloads_on_event_id" to "push_event_payloads_pkey"2490NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_repository_languages_on_project_and_languages_id" to "repository_languages_pkey"2491NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_user_interacted_projects_on_project_id_and_user_id" to "user_interacted_projects_pkey"2492NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "users_security_dashboard_projects_unique_index" to "users_security_dashboard_projects_pkey"2493NOTICE: trigger "trigger_1f0ae12498d3" for relation "application_settings" does not exist, skipping2494NOTICE: trigger "trigger_72b785aa2f14" for relation "application_settings" does not exist, skipping2495NOTICE: trigger "trigger_3d531acd472b" for relation "application_settings" does not exist, skipping2496NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping2497NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"2498NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"2499NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping2500NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping2501NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping2502NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping2503ScheduleRemoveDuplicateVulnerabilitiesFindings2504NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping2505NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping2506NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping2507NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping2508== 20201112130710 ScheduleRemoveDuplicateVulnerabilitiesFindings: migrating ===2509-- transaction_open?()2510 -> 0.0000s2511-- index_exists?(:vulnerability_occurrences, [:project_id, :report_type, :location_fingerprint, :primary_identifier_id, :id], {:name=>"tmp_idx_deduplicate_vulnerability_occurrences", :algorithm=>:concurrently})2512 -> 0.0049s2513-- add_index(:vulnerability_occurrences, [:project_id, :report_type, :location_fingerprint, :primary_identifier_id, :id], {:name=>"tmp_idx_deduplicate_vulnerability_occurrences", :algorithm=>:concurrently})2514 -> 0.0033s2515-- Scheduling RemoveDuplicateVulnerabilitiesFindings jobs2516-- Scheduled 4 RemoveDuplicateVulnerabilitiesFindings jobs with a maximum of 1 records per batch and an interval of 120 seconds.2517The migration is expected to take at least 480 seconds. Expect all jobs to have completed after 2021-03-03 12:29:19 UTC."2518== 20201112130710 ScheduleRemoveDuplicateVulnerabilitiesFindings: migrated (0.0423s) 2519 schedules background migration2520NOTICE: constraint "check_242f0cc65c" of relation "webauthn_registrations" does not exist, skipping2521NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_projects_on_project_id" to "elasticsearch_indexed_projects_pkey"2522NOTICE: ALTER TABLE / ADD CONSTRAINT USING INDEX will rename index "index_elasticsearch_indexed_namespaces_on_namespace_id" to "elasticsearch_indexed_namespaces_pkey"2523NOTICE: trigger "trigger_448e14608510" for relation "pages_deployments" does not exist, skipping2524NOTICE: trigger "trigger_9a96291bb38d" for relation "application_settings" does not exist, skipping2525NOTICE: trigger "trigger_22a39c5c25f3" for relation "application_settings" does not exist, skipping2526NOTICE: trigger "trigger_1572cbc9a15f" for relation "application_settings" does not exist, skipping2527Knapsack report was generated. Preview:2528{2529 "spec/lib/gitlab/background_migration/legacy_upload_mover_spec.rb": 25.25434684753418,2530 "spec/migrations/remove_duplicate_labels_from_groups_spec.rb": 10.408758640289307,2531 "spec/migrations/fix_wrong_pages_access_level_spec.rb": 6.334364414215088,2532 "spec/lib/gitlab/background_migration_spec.rb": 5.246359825134277,2533 "spec/lib/gitlab/background_migration/user_mentions/create_resource_user_mention_spec.rb": 3.9383704662323,2534 "spec/migrations/save_instance_administrators_group_id_spec.rb": 3.2226130962371826,2535 "spec/migrations/generate_missing_routes_for_bots_spec.rb": 3.112025499343872,2536 "spec/lib/gitlab/background_migration/populate_canonical_emails_spec.rb": 2.605976104736328,2537 "spec/migrations/update_application_setting_npm_package_requests_forwarding_default_spec.rb": 2.6109261512756348,2538 "spec/lib/gitlab/background_migration/populate_has_vulnerabilities_spec.rb": 2.356391191482544,2539 "spec/migrations/schedule_calculate_wiki_sizes_spec.rb": 2.0598857402801514,2540 "spec/migrations/confirm_project_bot_users_spec.rb": 2.06064772605896,2541 "spec/migrations/fill_file_store_ci_job_artifacts_spec.rb": 1.8799924850463867,2542 "spec/lib/gitlab/background_migration/set_default_iteration_cadences_spec.rb": 1.773332118988037,2543 "spec/migrations/20191015154408_drop_merge_requests_require_code_owner_approval_from_projects_spec.rb": 1.7481460571289062,2544 "spec/migrations/nullify_users_role_spec.rb": 1.493004322052002,2545 "spec/migrations/migrate_all_merge_request_user_mentions_to_db_spec.rb": 1.2763361930847168,2546 "spec/migrations/migrate_create_commit_signature_worker_sidekiq_queue_spec.rb": 1.0042872428894043,2547 "spec/migrations/migrate_discussion_id_on_promoted_epics_spec.rb": 1.2008607387542725,2548 "spec/migrations/schedule_populate_has_vulnerabilities_spec.rb": 0.6923353672027588,2549 "spec/migrations/fill_file_store_lfs_objects_spec.rb": 1.1726438999176025,2550 "spec/migrations/20200929052138_create_initial_versions_for_pre_versioning_terraform_states_spec.rb": 1.070225715637207,2551 "spec/migrations/20200728080250_replace_unique_index_on_cycle_analytics_stages_spec.rb": 1.0532646179199219,2552 "spec/migrations/cleanup_optimistic_locking_nulls_spec.rb": 0.9055399894714355,2553 "spec/migrations/truncate_user_fullname_spec.rb": 0.9087951183319092,2554 "spec/lib/gitlab/background_migration/populate_merge_request_assignees_table_spec.rb": 1.013784408569336,2555 "spec/lib/gitlab/background_migration/recalculate_project_authorizations_with_min_max_user_id_spec.rb": 1.375952959060669,2556 "spec/migrations/schedule_blocked_by_links_replacement_second_try_spec.rb": 0.7608680725097656,2557 "spec/migrations/drop_activate_prometheus_services_background_jobs_spec.rb": 0.764054536819458,2558 "spec/migrations/schedule_populate_missing_dismissal_information_for_vulnerabilities_spec.rb": 0.8411295413970947,2559 "spec/migrations/fix_max_pages_size_spec.rb": 0.7159943580627441,2560 "spec/lib/gitlab/background_migration/add_modified_to_approval_merge_request_rule_spec.rb": 0.6341733932495117,2561 "spec/migrations/20201112130710_schedule_remove_duplicate_vulnerabilities_findings_spec.rb": 0.70761656761169432562}2563Knapsack global time execution for tests: 01m 32s2564Finished in 18 minutes 10 seconds (files took 55.55 seconds to load)2565158 examples, 0 failures2566Wed 03 Mar 2021 12:21:36 PM UTC2568Not uploading cache rails-v4-3 due to policy2570Uploading artifacts...2571coverage/: found 5 matching files and directories 2572WARNING: crystalball/: no matching files 2573deprecations/: found 13 matching files and directories 2574knapsack/: found 3 matching files and directories 2575rspec_flaky/: found 4 matching files and directories 2576rspec_profiling/: found 1 matching files and directories 2577WARNING: tmp/capybara/: no matching files 2578tmp/memory_test/: found 2 matching files and directories 2579tmp/feature_flags/: found 17 matching files and directories 2580log/*.log: found 14 matching files and directories 2581Uploading artifacts as "archive" to coordinator... ok id=1069711825 responseStatus=201 Created token=KdfNwiuP2582Uploading artifacts...2583junit_rspec.xml: found 1 matching files and directories 2584Uploading artifacts as "junit" to coordinator... ok id=1069711825 responseStatus=201 Created token=KdfNwiuP2586Job succeeded