Skip to content
Snippets Groups Projects

rspec migration pg12 9/9

Passed Started by
Lee Tickett
@leetickett
1Running with gitlab-runner 15.1.0~beta.20.g62206bb2 (62206bb2)
2 on blue-1.shared-gitlab-org.runners-manager.gitlab.com/default KzYhZxBv
3 feature flags: FF_USE_FASTZIP:true
4 Resolving secrets 00:00
5 Preparing the "docker+machine" executor 00:09
6Using Docker executor with image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-2.7.patched-golang-1.17-node-16.14-postgresql-12:rubygems-3.2-git-2.36-lfs-2.9-chrome-101-yarn-1.22-graphicsmagick-1.3.36 ...
7Starting service postgres:12 ...
8Pulling docker image postgres:12 ...
9Using docker image sha256:ac3b8cd6a8b42e839456256bc514d6230b5a2538c738b3d522e1384a2a172b96 for postgres:12 with digest postgres@sha256:e6ffad42c91a4d5a29257a27ac4e160c3ae7196696b37bf2e80410024ed95951 ...
10Starting service redis:6.0-alpine ...
11Pulling docker image redis:6.0-alpine ...
12Using docker image sha256:09401fed2a421bf0019f96dcec70c85f82ec7b76beb1ae589547b0dc302d6b76 for redis:6.0-alpine with digest redis@sha256:217a9db40a914cc3f6206a143a4d750da0607500cc013a147a4979e08e40beff ...
13Waiting for services to be up and running (timeout 30 seconds)...
14Authenticating with credentials from job payload (GitLab Registry)
15Pulling docker image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-2.7.patched-golang-1.17-node-16.14-postgresql-12:rubygems-3.2-git-2.36-lfs-2.9-chrome-101-yarn-1.22-graphicsmagick-1.3.36 ...
16Using docker image sha256:642191311550aaa03aba1d11d8d921042ead8ee5afeb833fc7e4e3f933b7ed04 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-2.7.patched-golang-1.17-node-16.14-postgresql-12:rubygems-3.2-git-2.36-lfs-2.9-chrome-101-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-2.7.patched-golang-1.17-node-16.14-postgresql-12@sha256:f0990c59018be757dd56365bb2cc6791d65f3f4bf99a431c3b26e3df08260f6a ...
17 Preparing environment 00:01
18Running on runner-kzyhzxbv-project-278964-concurrent-0 via runner-kzyhzxbv-shared-gitlab-org-1656912558-55810d1b...
19 Getting source from Git repository 00:24
20$ eval "$CI_PRE_CLONE_SCRIPT"
21Fetching changes with git depth set to 20...
22Initialized empty Git repository in /builds/gitlab-org/gitlab/.git/
23Created fresh repository.
24remote: Enumerating objects: 115982, done.
25remote: Counting objects: 100% (115982/115982), done.
26remote: Compressing objects: 100% (81018/81018), done.
27remote: Total 115982 (delta 48513), reused 75495 (delta 30560), pack-reused 0
28Receiving objects: 100% (115982/115982), 108.44 MiB | 28.60 MiB/s, done.
29Resolving deltas: 100% (48513/48513), done.
30From https://git-us-east1-c.ci-gateway.int.gprd.gitlab.net:8989/gitlab-org/gitlab
31 * [new ref] refs/pipelines/579176392 -> refs/pipelines/579176392
32Checking out 204b4379 as refs/merge-requests/91556/merge...
33Skipping Git submodules setup
34$ git remote set-url origin "${CI_REPOSITORY_URL}"
35 Restoring cache 00:22
36Checking cache for ruby-gems-debian-bullseye-ruby-2.7-10...
37cache.zip is up to date
38Successfully extracted cache
39Checking cache for gitaly-ruby-gems-debian-bullseye-ruby-2.7-10...
40cache.zip is up to date
41Successfully extracted cache
42 Downloading artifacts 00:18
43Downloading artifacts for compile-test-assets (2673336706)...
44Downloading artifacts from coordinator... ok id=2673336706 responseStatus=200 OK token=4hXsmR-o
45Downloading artifacts for detect-tests (2673336715)...
46Downloading artifacts from coordinator... ok id=2673336715 responseStatus=200 OK token=4hXsmR-o
47Downloading artifacts for retrieve-tests-metadata (2673336722)...
48Downloading artifacts from coordinator... ok id=2673336722 responseStatus=200 OK token=4hXsmR-o
49Downloading artifacts for setup-test-env (2673336712)...
50Downloading artifacts from coordinator... ok id=2673336712 responseStatus=200 OK token=4hXsmR-o
51 Executing "step_script" stage of the job script 22:40
52Using docker image sha256:642191311550aaa03aba1d11d8d921042ead8ee5afeb833fc7e4e3f933b7ed04 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-2.7.patched-golang-1.17-node-16.14-postgresql-12:rubygems-3.2-git-2.36-lfs-2.9-chrome-101-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-2.7.patched-golang-1.17-node-16.14-postgresql-12@sha256:f0990c59018be757dd56365bb2cc6791d65f3f4bf99a431c3b26e3df08260f6a ...
53$ echo $FOSS_ONLY
54$ [ "$FOSS_ONLY" = "1" ] && rm -rf ee/ qa/spec/ee/ qa/qa/specs/features/ee/ qa/qa/ee/ qa/qa/ee.rb
55$ export GOPATH=$CI_PROJECT_DIR/.go
56$ mkdir -p $GOPATH
57$ source scripts/utils.sh
58$ source scripts/prepare_build.sh
593.2.33
60Bundler version 2.2.33
61Successfully installed bundler-2.3.15
621 gem installed
63production:development
64Settings are listed in order of priority. The top value will be used.
65clean
66Set for your local app (/builds/gitlab-org/gitlab/.bundle/config): true
67frozen
68Set via BUNDLE_FROZEN: true
69install_flags
70Set via BUNDLE_INSTALL_FLAGS: "--jobs=$(nproc) --retry=3 --quiet"
71path
72Set for your local app (/builds/gitlab-org/gitlab/.bundle/config): "/builds/gitlab-org/gitlab/vendor"
73without
74Set via BUNDLE_WITHOUT: [:production, :development]
75$ bundle install --jobs=$(nproc) --retry=3 --quiet && bundle check
76Don't run Bundler as root. Bundler can ask for sudo if it is needed, and
77installing your bundle as root will break this application for all non-root
78users on this machine.
79The Gemfile's dependencies are satisfied
80==> 'bundle install --jobs=$(nproc) --retry=3 --quiet && bundle check' succeeded in 2 seconds.
81$ bundle pristine pg
82Installing pg 1.3.5 with native extensions
83==> 'bundle pristine pg' succeeded in 11 seconds.
84Using decomposed database config (config/database.yml.decomposed-postgresql)
85$ setup_db_user_only
86CREATE ROLE
87GRANT
88==> 'setup_db_user_only' succeeded in 0 seconds.
89$ bundle exec rake db:drop db:create db:schema:load db:migrate
90Dropped database 'gitlabhq_test'
91Dropped database 'gitlabhq_test_ci'
92Dropped database 'gitlabhq_geo_test'
93Created database 'gitlabhq_test'
94Created database 'gitlabhq_test_ci'
95Created database 'gitlabhq_geo_test'
96==> 'bundle exec rake db:drop db:create db:schema:load db:migrate' succeeded in 41 seconds.
97$ setup_db_praefect
98SELECT pg_catalog.set_config('search_path', '', false);
99CREATE DATABASE praefect_test ENCODING 'UTF8';
100==> 'setup_db_praefect' succeeded in 0 seconds.
101$ run_timed_command "gem install knapsack --no-document"
102$ gem install knapsack --no-document
103Successfully installed knapsack-4.0.0
1041 gem installed
105==> 'gem install knapsack --no-document' succeeded in 0 seconds.
106$ run_timed_command "scripts/gitaly-test-spawn"
107$ scripts/gitaly-test-spawn
108find: ‘/builds/gitlab-org/gitlab/tmp/tests/gitaly/cmd’: No such file or directory
109Don't run Bundler as root. Bundler can ask for sudo if it is needed, and
110installing your bundle as root will break this application for all non-root
111users on this machine.
112Using abstract_type 0.0.7
113Using concurrent-ruby 1.1.10
114Using i18n 1.10.0
115Using minitest 5.15.0
116Using tzinfo 2.0.4
117Using zeitwerk 2.5.4
118Using activesupport 6.1.4.7
119Using builder 3.2.4
120Using erubi 1.10.0
121Using mini_portile2 2.8.0
122Using racc 1.6.0
123Using nokogiri 1.13.6 (x86_64-linux)
124Using rails-dom-testing 2.0.3
125Using crass 1.0.6
126Using loofah 2.16.0
127Using rails-html-sanitizer 1.4.2
128Using actionview 6.1.4.7
129Using rack 2.2.3
130Using rack-test 1.1.0
131Using actionpack 6.1.4.7
132Using ice_nine 0.11.2
133Using thread_safe 0.3.6
134Using memoizable 0.4.2
135Using adamantium 0.2.0
136Using public_suffix 4.0.6
137Using addressable 2.7.0
138Using ast 2.4.2
139Using binding_ninja 0.2.3
140Using bundler 2.3.15
141Using charlock_holmes 0.7.7
142Using coderay 1.1.2
143Using equalizer 0.0.11
144Using concord 0.1.5
145Using diff-lcs 1.3
146Using dotenv 2.7.6
147Using escape_utils 1.2.1
148Using factory_bot 5.0.2
149Using multipart-post 2.1.1
150Using faraday 1.0.1
151Using ffi 1.15.3
152Using json 2.5.1
153Using gemojione 3.3.0
154Using mini_mime 1.0.2
155Using rugged 1.2.0
156Using github-linguist 7.12.1
157Using github-markup 1.7.0
158Using mime-types-data 3.2020.1104
159Using mime-types 3.3.1
160Using gitlab-gollum-rugged_adapter 0.4.4.4.gitlab.1
161Using rouge 3.27.0
162Using sanitize 6.0.0
163Using stringex 2.8.5
164Using gitlab-gollum-lib 4.2.7.10.gitlab.2
165Using google-protobuf 3.19.1 (x86_64-linux)
166Using googleapis-common-protos-types 1.3.0
167Using grpc 1.42.0 (x86_64-linux)
168Using opentracing 0.5.0
169Using thrift 0.15.0
170Using jaeger-client 1.1.0
171Using pg_query 2.1.1
172Using redis 4.4.0
173Using gitlab-labkit 0.23.0
174Using rubyzip 2.3.2
175Using thor 1.1.0
176Using tomlrb 2.0.1
177Using with_env 1.1.0
178Using rexml 3.2.5
179Using xml-simple 1.1.9
180Using gitlab-license_finder 6.14.2.1
181Using gitlab-markup 1.7.1
182Using grpc-tools 1.42.0
183Using sawyer 0.8.2
184Using octokit 4.20.0
185Using reverse_markdown 1.4.0
186Using licensee 9.14.1
187Using method_source 0.9.2
188Using msgpack 1.3.3
189Using optimist 3.0.1
190Using parallel 1.19.2
191Using parser 3.0.3.2
192Using procto 0.0.3
193Using unparser 0.4.7
194Using proc_to_ast 0.1.0
195Using pry 0.12.2
196Using rainbow 3.0.0
197Using rbtrace 0.4.14
198Using rdoc 6.3.2
199Using regexp_parser 1.8.1
200Using rspec-support 3.8.0
201Using rspec-core 3.8.0
202Using rspec-expectations 3.8.3
203Using rspec-mocks 3.8.0
204Using rspec 3.8.0
205Using rspec-parameterized 0.4.2
206Using rubocop-ast 0.2.0
207Using ruby-progressbar 1.10.1
208Using unicode-display_width 1.7.0
209Using rubocop 0.86.0
210Using sentry-raven 3.0.4
211Using timecop 0.9.1
212Bundle complete! 22 Gemfile dependencies, 100 gems now installed.
213Gems in the groups 'production' and 'development' were not installed.
214Bundled gems are installed into `/builds/gitlab-org/gitlab/vendor/gitaly-ruby`
215Checking gitaly-ruby Gemfile...
216Checking gitaly-ruby bundle...
217The Gemfile's dependencies are satisfied
218Trying to connect to gitaly: ................................................... OK
219Trying to connect to gitaly2: ................................................................. OK
220Starting Praefect with in-memory election strategyTrying to connect to praefect: ......... OK
221$ source ./scripts/rspec_helpers.sh
222==> 'scripts/gitaly-test-spawn' succeeded in 14 seconds.
223$ rspec_paralellized_job "--tag ~quarantine --tag level:migration"
224SKIP_FLAKY_TESTS_AUTOMATICALLY: true
225RETRY_FAILED_TESTS_IN_NEW_PROCESS: true
226KNAPSACK_GENERATE_REPORT: true
227FLAKY_RSPEC_GENERATE_REPORT: true
228KNAPSACK_TEST_FILE_PATTERN: spec/{migrations,lib/gitlab/background_migration,lib/ee/gitlab/background_migration}{,/**/}*_spec.rb
229KNAPSACK_LOG_LEVEL: debug
230KNAPSACK_REPORT_PATH: knapsack/rspec_migration_pg12_9_9_report.json
231FLAKY_RSPEC_SUITE_REPORT_PATH: rspec/flaky/report-suite.json
232FLAKY_RSPEC_REPORT_PATH: rspec/flaky/all_rspec_migration_pg12_9_9_report.json
233NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg12_9_9_report.json
234SKIPPED_FLAKY_TESTS_REPORT_PATH: rspec/flaky/skipped_flaky_tests_rspec_migration_pg12_9_9_report.txt
235RETRIED_TESTS_REPORT_PATH: rspec/flaky/retried_tests_rspec_migration_pg12_9_9_report.txt
236CRYSTALBALL:
237Knapsack report generator started!
238DEPRECATION WARNING: /builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/activerecord-6.1.4.7/lib/active_record/connection_adapters/postgresql_adapter.rb:78: warning: Using the last argument as keyword parameters is deprecated; maybe ** should be added to the call
239/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/pg-1.3.5/lib/pg.rb:68: warning: The called method `connect' is defined here
240 (called from new_client at /builds/gitlab-org/gitlab/config/initializers/00_connection_logger.rb:21)
241Run options:
242 include {:level=>"migration"}
243 exclude {:quarantine=>true}
244Test environment set up in 0.517684493 seconds
245AddPremiumAndUltimatePlanLimits
246 #up
247 when not .com?
248 behaves like a migration that does not alter plans or plan limits
249== 20210706213537 AddPremiumAndUltimatePlanLimits: migrating ==================
250== 20210706213537 AddPremiumAndUltimatePlanLimits: migrated (0.0002s) =========
251 is expected not to change result
252 when .com?
253 when source plan does not exist
254 behaves like a migration that does not alter plans or plan limits
255== 20210706213537 AddPremiumAndUltimatePlanLimits: migrating ==================
256== 20210706213537 AddPremiumAndUltimatePlanLimits: migrated (0.0124s) =========
257 is expected not to change result
258 when target plan does not exist
259 behaves like a migration that does not alter plans or plan limits
260== 20210706213537 AddPremiumAndUltimatePlanLimits: migrating ==================
261== 20210706213537 AddPremiumAndUltimatePlanLimits: migrated (0.0104s) =========
262 is expected not to change result
263 when source and target plans exist
264 when target has plan limits
265== 20210706213537 AddPremiumAndUltimatePlanLimits: migrating ==================
266== 20210706213537 AddPremiumAndUltimatePlanLimits: migrated (0.0977s) =========
267 does not overwrite the limits
268 when target has no plan limits
269== 20210706213537 AddPremiumAndUltimatePlanLimits: migrating ==================
270== 20210706213537 AddPremiumAndUltimatePlanLimits: migrated (0.0686s) =========
271 creates plan limits from the source plan
272AddNewTrailPlans
273 #up
274== 20210329102724 AddNewTrailPlans: migrating =================================
275== 20210329102724 AddNewTrailPlans: migrated (0.1347s) ========================
276 creates 2 entries within the plans table
277== 20210329102724 AddNewTrailPlans: migrating =================================
278== 20210329102724 AddNewTrailPlans: migrated (0.0980s) ========================
279 creates 2 entries for plan limits
280 when the plan limits for gold and silver exists
281== 20210329102724 AddNewTrailPlans: migrating =================================
282== 20210329102724 AddNewTrailPlans: migrated (0.0645s) ========================
283 duplicates the gold and silvers plan limits entries
284 when the instance is not SaaS
285== 20210329102724 AddNewTrailPlans: migrating =================================
286== 20210329102724 AddNewTrailPlans: migrated (0.0070s) ========================
287 does not create plans and plan limits and returns
288 #down
289 when the instance is SaaS
290== 20210329102724 AddNewTrailPlans: migrating =================================
291== 20210329102724 AddNewTrailPlans: migrated (0.0916s) ========================
292 removes the newly added ultimate and premium trial entries
293 when the instance is not SaaS
294== 20210329102724 AddNewTrailPlans: migrating =================================
295== 20210329102724 AddNewTrailPlans: migrated (0.0004s) ========================
296 does not delete plans and plan limits and returns
297Gitlab::BackgroundMigration::BackfillJiraTrackerDeploymentType2
298 #perform
299
300 ignores if deployment already set
301 ignores if no url is set
302 when tracker is valid
303 sets the proper deployment_type
304 behaves like marks background migration job records
305 marks each job record as succeeded after processing
306 returns the number of job records marked as succeeded
307RemoveBuildsEmailServiceFromServices
308== 20210603222333 RemoveBuildsEmailServiceFromServices: migrating =============
309-- execute("DELETE from services WHERE type = 'BuildsEmailService'")
310 -> 0.0047s
311== 20210603222333 RemoveBuildsEmailServiceFromServices: migrated (0.0048s) ====
312 correctly deletes `BuildsEmailService` services
313Gitlab::BackgroundMigration::UpdateTimelogsProjectId
314 #perform
315 when timelogs belong to issues
316 sets correct project_id
317 when timelogs belong to merge requests
318 sets correct project ids
319 when timelogs already belong to projects
320 does not update the project id
321DeleteSecurityFindingsWithoutUuid
322== 20210318134427 DeleteSecurityFindingsWithoutUuid: migrating ================
323== 20210318134427 DeleteSecurityFindingsWithoutUuid: migrated (0.0084s) =======
324 successfully runs and does not schedule any job
325BackfillProjectsWithCoverage
326 #up
327== 20210818185845 BackfillProjectsWithCoverage: migrating =====================
328-- Scheduled 2 BackfillProjectsWithCoverage jobs with a maximum of 2 records per batch and an interval of 120 seconds.
329The migration is expected to take at least 240 seconds. Expect all jobs to have completed after 2022-07-04 07:21:42 UTC."
330== 20210818185845 BackfillProjectsWithCoverage: migrated (0.0197s) ============
331 schedules BackfillProjectsWithCoverage background jobs
332The application_settings (main) table has 1258 columns.
333Recreating the database
334Dropped database 'gitlabhq_test'
335Dropped database 'gitlabhq_test_ci'
336Dropped database 'gitlabhq_geo_test'
337Created database 'gitlabhq_test'
338Created database 'gitlabhq_test_ci'
339Created database 'gitlabhq_geo_test'
340Databases re-creation done in 11.816743979999956
341UpdateIntegrationsTriggerTypeNewOnInsert
342 #up
343 INSERT trigger with dynamic mapping
344== 20210818175949 UpdateIntegrationsTriggerTypeNewOnInsert: migrating =========
345-- execute("CREATE OR REPLACE FUNCTION integrations_set_type_new()\nRETURNS TRIGGER AS\n$$\nBEGIN\nUPDATE integrations SET type_new = regexp_replace(NEW.type, '\\A(.+)Service\\Z', 'Integrations::\\1')\nWHERE integrations.id = NEW.id;\nRETURN NULL;\n\nEND\n$$ LANGUAGE PLPGSQL\n")
346 -> 0.0024s
347== 20210818175949 UpdateIntegrationsTriggerTypeNewOnInsert: migrated (0.0025s)
348 transforms unknown types if it ends in "Service"
349== 20210818175949 UpdateIntegrationsTriggerTypeNewOnInsert: migrating =========
350-- execute("CREATE OR REPLACE FUNCTION integrations_set_type_new()\nRETURNS TRIGGER AS\n$$\nBEGIN\nUPDATE integrations SET type_new = regexp_replace(NEW.type, '\\A(.+)Service\\Z', 'Integrations::\\1')\nWHERE integrations.id = NEW.id;\nRETURN NULL;\n\nEND\n$$ LANGUAGE PLPGSQL\n")
351 -> 0.0027s
352== 20210818175949 UpdateIntegrationsTriggerTypeNewOnInsert: migrated (0.0029s)
353 ignores "Service" occurring elsewhere in the type
354== 20210818175949 UpdateIntegrationsTriggerTypeNewOnInsert: migrating =========
355-- execute("CREATE OR REPLACE FUNCTION integrations_set_type_new()\nRETURNS TRIGGER AS\n$$\nBEGIN\nUPDATE integrations SET type_new = regexp_replace(NEW.type, '\\A(.+)Service\\Z', 'Integrations::\\1')\nWHERE integrations.id = NEW.id;\nRETURN NULL;\n\nEND\n$$ LANGUAGE PLPGSQL\n")
356 -> 0.0025s
357== 20210818175949 UpdateIntegrationsTriggerTypeNewOnInsert: migrated (0.0026s)
358 copies unknown types if it does not end with "Service"
359 behaves like transforms known types
360== 20210818175949 UpdateIntegrationsTriggerTypeNewOnInsert: migrating =========
361-- execute("CREATE OR REPLACE FUNCTION integrations_set_type_new()\nRETURNS TRIGGER AS\n$$\nBEGIN\nUPDATE integrations SET type_new = regexp_replace(NEW.type, '\\A(.+)Service\\Z', 'Integrations::\\1')\nWHERE integrations.id = NEW.id;\nRETURN NULL;\n\nEND\n$$ LANGUAGE PLPGSQL\n")
362 -> 0.0033s
363== 20210818175949 UpdateIntegrationsTriggerTypeNewOnInsert: migrated (0.0034s)
364 sets `type_new` to the transformed `type` class name
365 #down
366 INSERT trigger with static mapping
367-- execute("CREATE OR REPLACE FUNCTION integrations_set_type_new()\nRETURNS TRIGGER AS\n$$\nBEGIN\nUPDATE integrations SET type_new = regexp_replace(NEW.type, '\\A(.+)Service\\Z', 'Integrations::\\1')\nWHERE integrations.id = NEW.id;\nRETURN NULL;\n\nEND\n$$ LANGUAGE PLPGSQL\n")
368 -> 0.0018s
369-- execute("CREATE OR REPLACE FUNCTION integrations_set_type_new()\nRETURNS TRIGGER AS\n$$\nBEGIN\nWITH mapping(old_type, new_type) AS (VALUES\n ('AsanaService', 'Integrations::Asana'),\n ('AssemblaService', 'Integrations::Assembla'),\n ('BambooService', 'Integrations::Bamboo'),\n ('BugzillaService', 'Integrations::Bugzilla'),\n ('BuildkiteService', 'Integrations::Buildkite'),\n ('CampfireService', 'Integrations::Campfire'),\n ('ConfluenceService', 'Integrations::Confluence'),\n ('CustomIssueTrackerService', 'Integrations::CustomIssueTracker'),\n ('DatadogService', 'Integrations::Datadog'),\n ('DiscordService', 'Integrations::Discord'),\n ('DroneCiService', 'Integrations::DroneCi'),\n ('EmailsOnPushService', 'Integrations::EmailsOnPush'),\n ('EwmService', 'Integrations::Ewm'),\n ('ExternalWikiService', 'Integrations::ExternalWiki'),\n ('FlowdockService', 'Integrations::Flowdock'),\n ('HangoutsChatService', 'Integrations::HangoutsChat'),\n ('IrkerService', 'Integrations::Irker'),\n ('JenkinsService', 'Integrations::Jenkins'),\n ('JiraService', 'Integrations::Jira'),\n ('MattermostService', 'Integrations::Mattermost'),\n ('MattermostSlashCommandsService', 'Integrations::MattermostSlashCommands'),\n ('MicrosoftTeamsService', 'Integrations::MicrosoftTeams'),\n ('MockCiService', 'Integrations::MockCi'),\n ('MockMonitoringService', 'Integrations::MockMonitoring'),\n ('PackagistService', 'Integrations::Packagist'),\n ('PipelinesEmailService', 'Integrations::PipelinesEmail'),\n ('PivotaltrackerService', 'Integrations::Pivotaltracker'),\n ('PrometheusService', 'Integrations::Prometheus'),\n ('PushoverService', 'Integrations::Pushover'),\n ('RedmineService', 'Integrations::Redmine'),\n ('SlackService', 'Integrations::Slack'),\n ('SlackSlashCommandsService', 'Integrations::SlackSlashCommands'),\n ('TeamcityService', 'Integrations::Teamcity'),\n ('UnifyCircuitService', 'Integrations::UnifyCircuit'),\n ('YoutrackService', 'Integrations::Youtrack'),\n ('WebexTeamsService', 'Integrations::WebexTeams'),\n\n -- EE-only integrations\n ('GithubService', 'Integrations::Github'),\n ('GitlabSlackApplicationService', 'Integrations::GitlabSlackApplication')\n)\n\nUPDATE integrations SET type_new = mapping.new_type\nFROM mapping\nWHERE integrations.id = NEW.id\n AND mapping.old_type = NEW.type;\nRETURN NULL;\n\nEND\n$$ LANGUAGE PLPGSQL\n")
370 -> 0.0016s
371 ignores types that are already namespaced
372-- execute("CREATE OR REPLACE FUNCTION integrations_set_type_new()\nRETURNS TRIGGER AS\n$$\nBEGIN\nUPDATE integrations SET type_new = regexp_replace(NEW.type, '\\A(.+)Service\\Z', 'Integrations::\\1')\nWHERE integrations.id = NEW.id;\nRETURN NULL;\n\nEND\n$$ LANGUAGE PLPGSQL\n")
373 -> 0.0025s
374-- execute("CREATE OR REPLACE FUNCTION integrations_set_type_new()\nRETURNS TRIGGER AS\n$$\nBEGIN\nWITH mapping(old_type, new_type) AS (VALUES\n ('AsanaService', 'Integrations::Asana'),\n ('AssemblaService', 'Integrations::Assembla'),\n ('BambooService', 'Integrations::Bamboo'),\n ('BugzillaService', 'Integrations::Bugzilla'),\n ('BuildkiteService', 'Integrations::Buildkite'),\n ('CampfireService', 'Integrations::Campfire'),\n ('ConfluenceService', 'Integrations::Confluence'),\n ('CustomIssueTrackerService', 'Integrations::CustomIssueTracker'),\n ('DatadogService', 'Integrations::Datadog'),\n ('DiscordService', 'Integrations::Discord'),\n ('DroneCiService', 'Integrations::DroneCi'),\n ('EmailsOnPushService', 'Integrations::EmailsOnPush'),\n ('EwmService', 'Integrations::Ewm'),\n ('ExternalWikiService', 'Integrations::ExternalWiki'),\n ('FlowdockService', 'Integrations::Flowdock'),\n ('HangoutsChatService', 'Integrations::HangoutsChat'),\n ('IrkerService', 'Integrations::Irker'),\n ('JenkinsService', 'Integrations::Jenkins'),\n ('JiraService', 'Integrations::Jira'),\n ('MattermostService', 'Integrations::Mattermost'),\n ('MattermostSlashCommandsService', 'Integrations::MattermostSlashCommands'),\n ('MicrosoftTeamsService', 'Integrations::MicrosoftTeams'),\n ('MockCiService', 'Integrations::MockCi'),\n ('MockMonitoringService', 'Integrations::MockMonitoring'),\n ('PackagistService', 'Integrations::Packagist'),\n ('PipelinesEmailService', 'Integrations::PipelinesEmail'),\n ('PivotaltrackerService', 'Integrations::Pivotaltracker'),\n ('PrometheusService', 'Integrations::Prometheus'),\n ('PushoverService', 'Integrations::Pushover'),\n ('RedmineService', 'Integrations::Redmine'),\n ('SlackService', 'Integrations::Slack'),\n ('SlackSlashCommandsService', 'Integrations::SlackSlashCommands'),\n ('TeamcityService', 'Integrations::Teamcity'),\n ('UnifyCircuitService', 'Integrations::UnifyCircuit'),\n ('YoutrackService', 'Integrations::Youtrack'),\n ('WebexTeamsService', 'Integrations::WebexTeams'),\n\n -- EE-only integrations\n ('GithubService', 'Integrations::Github'),\n ('GitlabSlackApplicationService', 'Integrations::GitlabSlackApplication')\n)\n\nUPDATE integrations SET type_new = mapping.new_type\nFROM mapping\nWHERE integrations.id = NEW.id\n AND mapping.old_type = NEW.type;\nRETURN NULL;\n\nEND\n$$ LANGUAGE PLPGSQL\n")
375 -> 0.0021s
376 ignores types that are unknown
377 behaves like transforms known types
378-- execute("CREATE OR REPLACE FUNCTION integrations_set_type_new()\nRETURNS TRIGGER AS\n$$\nBEGIN\nUPDATE integrations SET type_new = regexp_replace(NEW.type, '\\A(.+)Service\\Z', 'Integrations::\\1')\nWHERE integrations.id = NEW.id;\nRETURN NULL;\n\nEND\n$$ LANGUAGE PLPGSQL\n")
379 -> 0.0019s
380-- execute("CREATE OR REPLACE FUNCTION integrations_set_type_new()\nRETURNS TRIGGER AS\n$$\nBEGIN\nWITH mapping(old_type, new_type) AS (VALUES\n ('AsanaService', 'Integrations::Asana'),\n ('AssemblaService', 'Integrations::Assembla'),\n ('BambooService', 'Integrations::Bamboo'),\n ('BugzillaService', 'Integrations::Bugzilla'),\n ('BuildkiteService', 'Integrations::Buildkite'),\n ('CampfireService', 'Integrations::Campfire'),\n ('ConfluenceService', 'Integrations::Confluence'),\n ('CustomIssueTrackerService', 'Integrations::CustomIssueTracker'),\n ('DatadogService', 'Integrations::Datadog'),\n ('DiscordService', 'Integrations::Discord'),\n ('DroneCiService', 'Integrations::DroneCi'),\n ('EmailsOnPushService', 'Integrations::EmailsOnPush'),\n ('EwmService', 'Integrations::Ewm'),\n ('ExternalWikiService', 'Integrations::ExternalWiki'),\n ('FlowdockService', 'Integrations::Flowdock'),\n ('HangoutsChatService', 'Integrations::HangoutsChat'),\n ('IrkerService', 'Integrations::Irker'),\n ('JenkinsService', 'Integrations::Jenkins'),\n ('JiraService', 'Integrations::Jira'),\n ('MattermostService', 'Integrations::Mattermost'),\n ('MattermostSlashCommandsService', 'Integrations::MattermostSlashCommands'),\n ('MicrosoftTeamsService', 'Integrations::MicrosoftTeams'),\n ('MockCiService', 'Integrations::MockCi'),\n ('MockMonitoringService', 'Integrations::MockMonitoring'),\n ('PackagistService', 'Integrations::Packagist'),\n ('PipelinesEmailService', 'Integrations::PipelinesEmail'),\n ('PivotaltrackerService', 'Integrations::Pivotaltracker'),\n ('PrometheusService', 'Integrations::Prometheus'),\n ('PushoverService', 'Integrations::Pushover'),\n ('RedmineService', 'Integrations::Redmine'),\n ('SlackService', 'Integrations::Slack'),\n ('SlackSlashCommandsService', 'Integrations::SlackSlashCommands'),\n ('TeamcityService', 'Integrations::Teamcity'),\n ('UnifyCircuitService', 'Integrations::UnifyCircuit'),\n ('YoutrackService', 'Integrations::Youtrack'),\n ('WebexTeamsService', 'Integrations::WebexTeams'),\n\n -- EE-only integrations\n ('GithubService', 'Integrations::Github'),\n ('GitlabSlackApplicationService', 'Integrations::GitlabSlackApplication')\n)\n\nUPDATE integrations SET type_new = mapping.new_type\nFROM mapping\nWHERE integrations.id = NEW.id\n AND mapping.old_type = NEW.type;\nRETURN NULL;\n\nEND\n$$ LANGUAGE PLPGSQL\n")
381 -> 0.0015s
382 sets `type_new` to the transformed `type` class name
383FinalizeCiBuildsBigintConversion
384 with an unexpected FK fk_3f0c88d7dc
385main: -- add_foreign_key(:ci_sources_pipelines, :ci_builds, {:column=>:source_job_id, :name=>"fk_3f0c88d7dc"})
386main: -> 0.0035s
387main: -- foreign_keys(:ci_sources_pipelines)
388main: -> 0.0047s
389main: == 20210907211557 FinalizeCiBuildsBigintConversion: migrating =================
390main: -- foreign_keys(:dep_ci_build_trace_sections)
391main: -> 0.0052s
392main: -- foreign_keys(:ci_resources)
393main: -> 0.0052s
394main: -- foreign_keys(:ci_sources_pipelines)
395main: -> 0.0054s
396main: -- remove_foreign_key(:ci_sources_pipelines, "ci_builds", {:column=>:source_job_id, :name=>"fk_3f0c88d7dc"})
397main: -> 0.0072s
398main: -- index_exists?("ci_builds", :id_convert_to_bigint, {:unique=>true, :name=>"index_ci_builds_on_converted_id", :algorithm=>:concurrently})
399main: -> 0.0244s
400main: -- add_index("ci_builds", :id_convert_to_bigint, {:unique=>true, :name=>"index_ci_builds_on_converted_id", :algorithm=>:concurrently})
401main: -> 0.0025s
402main: -- index_exists?("ci_builds", [:commit_id, :artifacts_expire_at, :id_convert_to_bigint], {:where=>"type::text = 'Ci::Build'::text\n AND (retried = false OR retried IS NULL)\n AND (name::text = ANY (ARRAY['sast'::character varying::text,\n 'secret_detection'::character varying::text,\n 'dependency_scanning'::character varying::text,\n 'container_scanning'::character varying::text,\n 'dast'::character varying::text]))", :name=>:index_ci_builds_on_commit_id_expire_at_and_converted_id, :algorithm=>:concurrently})
403main: -> 0.0304s
404main: -- add_index("ci_builds", [:commit_id, :artifacts_expire_at, :id_convert_to_bigint], {:where=>"type::text = 'Ci::Build'::text\n AND (retried = false OR retried IS NULL)\n AND (name::text = ANY (ARRAY['sast'::character varying::text,\n 'secret_detection'::character varying::text,\n 'dependency_scanning'::character varying::text,\n 'container_scanning'::character varying::text,\n 'dast'::character varying::text]))", :name=>:index_ci_builds_on_commit_id_expire_at_and_converted_id, :algorithm=>:concurrently})
405main: -> 0.0031s
406main: -- index_exists?("ci_builds", [:project_id, :id_convert_to_bigint], {:name=>:index_ci_builds_on_project_and_converted_id, :algorithm=>:concurrently})
407main: -> 0.0315s
408main: -- add_index("ci_builds", [:project_id, :id_convert_to_bigint], {:name=>:index_ci_builds_on_project_and_converted_id, :algorithm=>:concurrently})
409main: -> 0.0027s
410main: -- index_exists?("ci_builds", [:runner_id, :id_convert_to_bigint], {:order=>{:id_convert_to_bigint=>:desc}, :name=>:index_ci_builds_on_runner_id_and_converted_id_desc, :algorithm=>:concurrently})
411main: -> 0.0706s
412main: -- add_index("ci_builds", [:runner_id, :id_convert_to_bigint], {:order=>{:id_convert_to_bigint=>:desc}, :name=>:index_ci_builds_on_runner_id_and_converted_id_desc, :algorithm=>:concurrently})
413main: -> 0.0026s
414main: -- index_exists?("ci_builds", [:resource_group_id, :id_convert_to_bigint], {:where=>"resource_group_id IS NOT NULL", :name=>:index_ci_builds_on_resource_group_and_converted_id, :algorithm=>:concurrently})
415main: -> 0.0318s
416main: -- add_index("ci_builds", [:resource_group_id, :id_convert_to_bigint], {:where=>"resource_group_id IS NOT NULL", :name=>:index_ci_builds_on_resource_group_and_converted_id, :algorithm=>:concurrently})
417main: -> 0.0024s
418main: -- index_exists?("ci_builds", [:name, :id_convert_to_bigint], {:where=>"(name::text = ANY (ARRAY['container_scanning'::character varying::text,\n 'dast'::character varying::text,\n 'dependency_scanning'::character varying::text,\n 'license_management'::character varying::text,\n 'sast'::character varying::text,\n 'secret_detection'::character varying::text,\n 'coverage_fuzzing'::character varying::text,\n 'license_scanning'::character varying::text])\n ) AND type::text = 'Ci::Build'::text", :name=>:index_security_ci_builds_on_name_and_converted_id_parser, :algorithm=>:concurrently})
419main: -> 0.0331s
420main: -- add_index("ci_builds", [:name, :id_convert_to_bigint], {:where=>"(name::text = ANY (ARRAY['container_scanning'::character varying::text,\n 'dast'::character varying::text,\n 'dependency_scanning'::character varying::text,\n 'license_management'::character varying::text,\n 'sast'::character varying::text,\n 'secret_detection'::character varying::text,\n 'coverage_fuzzing'::character varying::text,\n 'license_scanning'::character varying::text])\n ) AND type::text = 'Ci::Build'::text", :name=>:index_security_ci_builds_on_name_and_converted_id_parser, :algorithm=>:concurrently})
421main: -> 0.0028s
422main: -- index_name_exists?("ci_builds", :index_ci_builds_runner_id_and_converted_id_pending_covering)
423main: -> 0.0017s
424main: -- execute("CREATE INDEX CONCURRENTLY index_ci_builds_runner_id_and_converted_id_pending_covering\nON ci_builds (runner_id, id_convert_to_bigint) INCLUDE (project_id)\nWHERE status::text = 'pending'::text AND type::text = 'Ci::Build'::text\n")
425main: -> 0.0023s
426main: -- foreign_keys(:ci_build_needs)
427main: -> 0.0048s
428main: -- foreign_keys(:ci_build_needs)
429main: -> 0.0046s
430main: -- execute("LOCK TABLE ci_builds, ci_build_needs IN SHARE ROW EXCLUSIVE MODE")
431main: -> 0.0012s
432main: -- execute("ALTER TABLE ci_build_needs\nADD CONSTRAINT fk_rails_3cf221d4ed_tmp\nFOREIGN KEY (build_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE CASCADE\nNOT VALID;\n")
433main: -> 0.0018s
434main: -- execute("ALTER TABLE ci_build_needs VALIDATE CONSTRAINT fk_rails_3cf221d4ed_tmp;")
435main: -> 0.0022s
436main: -- foreign_keys(:ci_build_pending_states)
437main: -> 0.0045s
438main: -- foreign_keys(:ci_build_pending_states)
439main: -> 0.0047s
440main: -- execute("LOCK TABLE ci_builds, ci_build_pending_states IN SHARE ROW EXCLUSIVE MODE")
441main: -> 0.0012s
442main: -- execute("ALTER TABLE ci_build_pending_states\nADD CONSTRAINT fk_rails_0bbbfeaf9d_tmp\nFOREIGN KEY (build_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE CASCADE\nNOT VALID;\n")
443main: -> 0.0018s
444main: -- execute("ALTER TABLE ci_build_pending_states VALIDATE CONSTRAINT fk_rails_0bbbfeaf9d_tmp;")
445main: -> 0.0017s
446main: -- foreign_keys(:ci_build_report_results)
447main: -> 0.0044s
448main: -- foreign_keys(:ci_build_report_results)
449main: -> 0.0046s
450main: -- execute("LOCK TABLE ci_builds, ci_build_report_results IN SHARE ROW EXCLUSIVE MODE")
451main: -> 0.0013s
452main: -- execute("ALTER TABLE ci_build_report_results\nADD CONSTRAINT fk_rails_16cb1ff064_tmp\nFOREIGN KEY (build_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE CASCADE\nNOT VALID;\n")
453main: -> 0.0018s
454main: -- execute("ALTER TABLE ci_build_report_results VALIDATE CONSTRAINT fk_rails_16cb1ff064_tmp;")
455main: -> 0.0018s
456main: -- foreign_keys(:ci_build_trace_chunks)
457main: -> 0.0049s
458main: -- foreign_keys(:ci_build_trace_chunks)
459main: -> 0.0048s
460main: -- execute("LOCK TABLE ci_builds, ci_build_trace_chunks IN SHARE ROW EXCLUSIVE MODE")
461main: -> 0.0009s
462main: -- execute("ALTER TABLE ci_build_trace_chunks\nADD CONSTRAINT fk_rails_1013b761f2_tmp\nFOREIGN KEY (build_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE CASCADE\nNOT VALID;\n")
463main: -> 0.0015s
464main: -- execute("ALTER TABLE ci_build_trace_chunks VALIDATE CONSTRAINT fk_rails_1013b761f2_tmp;")
465main: -> 0.0018s
466main: -- foreign_keys(:ci_build_trace_metadata)
467main: -> 0.0046s
468main: -- foreign_keys(:ci_build_trace_metadata)
469main: -> 0.0046s
470main: -- execute("LOCK TABLE ci_builds, ci_build_trace_metadata IN SHARE ROW EXCLUSIVE MODE")
471main: -> 0.0009s
472main: -- execute("ALTER TABLE ci_build_trace_metadata\nADD CONSTRAINT fk_rails_aebc78111f_tmp\nFOREIGN KEY (build_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE CASCADE\nNOT VALID;\n")
473main: -> 0.0017s
474main: -- execute("ALTER TABLE ci_build_trace_metadata VALIDATE CONSTRAINT fk_rails_aebc78111f_tmp;")
475main: -> 0.0020s
476main: -- foreign_keys(:ci_builds_runner_session)
477main: -> 0.0047s
478main: -- foreign_keys(:ci_builds_runner_session)
479main: -> 0.0053s
480main: -- execute("LOCK TABLE ci_builds, ci_builds_runner_session IN SHARE ROW EXCLUSIVE MODE")
481main: -> 0.0013s
482main: -- execute("ALTER TABLE ci_builds_runner_session\nADD CONSTRAINT fk_rails_70707857d3_tmp\nFOREIGN KEY (build_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE CASCADE\nNOT VALID;\n")
483main: -> 0.0018s
484main: -- execute("ALTER TABLE ci_builds_runner_session VALIDATE CONSTRAINT fk_rails_70707857d3_tmp;")
485main: -> 0.0020s
486main: -- foreign_keys(:ci_builds_metadata)
487main: -> 0.0046s
488main: -- foreign_keys(:ci_builds_metadata)
489main: -> 0.0046s
490main: -- execute("LOCK TABLE ci_builds, ci_builds_metadata IN SHARE ROW EXCLUSIVE MODE")
491main: -> 0.0021s
492main: -- execute("ALTER TABLE ci_builds_metadata\nADD CONSTRAINT fk_e20479742e_tmp\nFOREIGN KEY (build_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE CASCADE\nNOT VALID;\n")
493main: -> 0.0020s
494main: -- execute("ALTER TABLE ci_builds_metadata VALIDATE CONSTRAINT fk_e20479742e_tmp;")
495main: -> 0.0022s
496main: -- foreign_keys(:ci_job_artifacts)
497main: -> 0.0046s
498main: -- foreign_keys(:ci_job_artifacts)
499main: -> 0.0045s
500main: -- execute("LOCK TABLE ci_builds, ci_job_artifacts IN SHARE ROW EXCLUSIVE MODE")
501main: -> 0.0013s
502main: -- execute("ALTER TABLE ci_job_artifacts\nADD CONSTRAINT fk_rails_c5137cb2c1_tmp\nFOREIGN KEY (job_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE CASCADE\nNOT VALID;\n")
503main: -> 0.0019s
504main: -- execute("ALTER TABLE ci_job_artifacts VALIDATE CONSTRAINT fk_rails_c5137cb2c1_tmp;")
505main: -> 0.0023s
506main: -- foreign_keys(:ci_job_variables)
507main: -> 0.0048s
508main: -- foreign_keys(:ci_job_variables)
509main: -> 0.0048s
510main: -- execute("LOCK TABLE ci_builds, ci_job_variables IN SHARE ROW EXCLUSIVE MODE")
511main: -> 0.0013s
512main: -- execute("ALTER TABLE ci_job_variables\nADD CONSTRAINT fk_rails_fbf3b34792_tmp\nFOREIGN KEY (job_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE CASCADE\nNOT VALID;\n")
513main: -> 0.0019s
514main: -- execute("ALTER TABLE ci_job_variables VALIDATE CONSTRAINT fk_rails_fbf3b34792_tmp;")
515main: -> 0.0022s
516main: -- foreign_keys(:ci_pending_builds)
517main: -> 0.0045s
518main: -- foreign_keys(:ci_pending_builds)
519main: -> 0.0053s
520main: -- execute("LOCK TABLE ci_builds, ci_pending_builds IN SHARE ROW EXCLUSIVE MODE")
521main: -> 0.0010s
522main: -- execute("ALTER TABLE ci_pending_builds\nADD CONSTRAINT fk_rails_725a2644a3_tmp\nFOREIGN KEY (build_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE CASCADE\nNOT VALID;\n")
523main: -> 0.0017s
524main: -- execute("ALTER TABLE ci_pending_builds VALIDATE CONSTRAINT fk_rails_725a2644a3_tmp;")
525main: -> 0.0021s
526main: -- foreign_keys(:ci_resources)
527main: -> 0.0054s
528main: -- foreign_keys(:ci_resources)
529main: -> 0.0049s
530main: -- execute("LOCK TABLE ci_builds, ci_resources IN SHARE ROW EXCLUSIVE MODE")
531main: -> 0.0012s
532main: -- execute("ALTER TABLE ci_resources\nADD CONSTRAINT fk_e169a8e3d5_tmp\nFOREIGN KEY (build_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE SET NULL\nNOT VALID;\n")
533main: -> 0.0019s
534main: -- execute("ALTER TABLE ci_resources VALIDATE CONSTRAINT fk_e169a8e3d5_tmp;")
535main: -> 0.0021s
536main: -- foreign_keys(:ci_running_builds)
537main: -> 0.0044s
538main: -- foreign_keys(:ci_running_builds)
539main: -> 0.0049s
540main: -- execute("LOCK TABLE ci_builds, ci_running_builds IN SHARE ROW EXCLUSIVE MODE")
541main: -> 0.0011s
542main: -- execute("ALTER TABLE ci_running_builds\nADD CONSTRAINT fk_rails_da45cfa165_tmp\nFOREIGN KEY (build_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE CASCADE\nNOT VALID;\n")
543main: -> 0.0019s
544main: -- execute("ALTER TABLE ci_running_builds VALIDATE CONSTRAINT fk_rails_da45cfa165_tmp;")
545main: -> 0.0020s
546main: -- foreign_keys(:ci_sources_pipelines)
547main: -> 0.0051s
548main: -- foreign_keys(:ci_sources_pipelines)
549main: -> 0.0050s
550main: -- execute("LOCK TABLE ci_builds, ci_sources_pipelines IN SHARE ROW EXCLUSIVE MODE")
551main: -> 0.0010s
552main: -- execute("ALTER TABLE ci_sources_pipelines\nADD CONSTRAINT fk_be5624bf37_tmp\nFOREIGN KEY (source_job_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE CASCADE\nNOT VALID;\n")
553main: -> 0.0021s
554main: -- execute("ALTER TABLE ci_sources_pipelines VALIDATE CONSTRAINT fk_be5624bf37_tmp;")
555main: -> 0.0020s
556main: -- foreign_keys(:ci_unit_test_failures)
557main: -> 0.0050s
558main: -- foreign_keys(:ci_unit_test_failures)
559main: -> 0.0051s
560main: -- execute("LOCK TABLE ci_builds, ci_unit_test_failures IN SHARE ROW EXCLUSIVE MODE")
561main: -> 0.0010s
562main: -- execute("ALTER TABLE ci_unit_test_failures\nADD CONSTRAINT fk_0f09856e1f_tmp\nFOREIGN KEY (build_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE CASCADE\nNOT VALID;\n")
563main: -> 0.0017s
564main: -- execute("ALTER TABLE ci_unit_test_failures VALIDATE CONSTRAINT fk_0f09856e1f_tmp;")
565main: -> 0.0020s
566main: -- foreign_keys(:dast_scanner_profiles_builds)
567main: -> 0.0051s
568main: -- foreign_keys(:dast_scanner_profiles_builds)
569main: -> 0.0052s
570main: -- execute("LOCK TABLE ci_builds, dast_scanner_profiles_builds IN SHARE ROW EXCLUSIVE MODE")
571main: -> 0.0012s
572main: -- execute("ALTER TABLE dast_scanner_profiles_builds\nADD CONSTRAINT fk_e4c49200f8_tmp\nFOREIGN KEY (ci_build_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE CASCADE\nNOT VALID;\n")
573main: -> 0.0017s
574main: -- execute("ALTER TABLE dast_scanner_profiles_builds VALIDATE CONSTRAINT fk_e4c49200f8_tmp;")
575main: -> 0.0020s
576main: -- foreign_keys(:dast_site_profiles_builds)
577main: -> 0.0049s
578main: -- foreign_keys(:dast_site_profiles_builds)
579main: -> 0.0048s
580main: -- execute("LOCK TABLE ci_builds, dast_site_profiles_builds IN SHARE ROW EXCLUSIVE MODE")
581main: -> 0.0011s
582main: -- execute("ALTER TABLE dast_site_profiles_builds\nADD CONSTRAINT fk_a325505e99_tmp\nFOREIGN KEY (ci_build_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE CASCADE\nNOT VALID;\n")
583main: -> 0.0026s
584main: -- execute("ALTER TABLE dast_site_profiles_builds VALIDATE CONSTRAINT fk_a325505e99_tmp;")
585main: -> 0.0020s
586main: -- foreign_keys(:pages_deployments)
587main: -> 0.0049s
588main: -- foreign_keys(:pages_deployments)
589main: -> 0.0050s
590main: -- execute("LOCK TABLE ci_builds, pages_deployments IN SHARE ROW EXCLUSIVE MODE")
591main: -> 0.0010s
592main: -- execute("ALTER TABLE pages_deployments\nADD CONSTRAINT fk_rails_c3a90cf29b_tmp\nFOREIGN KEY (ci_build_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE SET NULL\nNOT VALID;\n")
593main: -> 0.0019s
594main: -- execute("ALTER TABLE pages_deployments VALIDATE CONSTRAINT fk_rails_c3a90cf29b_tmp;")
595main: -> 0.0022s
596main: -- foreign_keys(:requirements_management_test_reports)
597main: -> 0.0053s
598main: -- foreign_keys(:requirements_management_test_reports)
599main: -> 0.0055s
600main: -- execute("LOCK TABLE ci_builds, requirements_management_test_reports IN SHARE ROW EXCLUSIVE MODE")
601main: -> 0.0011s
602main: -- execute("ALTER TABLE requirements_management_test_reports\nADD CONSTRAINT fk_rails_e67d085910_tmp\nFOREIGN KEY (build_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE SET NULL\nNOT VALID;\n")
603main: -> 0.0020s
604main: -- execute("ALTER TABLE requirements_management_test_reports VALIDATE CONSTRAINT fk_rails_e67d085910_tmp;")
605main: -> 0.0022s
606main: -- foreign_keys(:security_scans)
607main: -> 0.0052s
608main: -- foreign_keys(:security_scans)
609main: -> 0.0054s
610main: -- execute("LOCK TABLE ci_builds, security_scans IN SHARE ROW EXCLUSIVE MODE")
611main: -> 0.0012s
612main: -- execute("ALTER TABLE security_scans\nADD CONSTRAINT fk_rails_4ef1e6b4c6_tmp\nFOREIGN KEY (build_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE CASCADE\nNOT VALID;\n")
613main: -> 0.0022s
614main: -- execute("ALTER TABLE security_scans VALIDATE CONSTRAINT fk_rails_4ef1e6b4c6_tmp;")
615main: -> 0.0021s
616main: -- foreign_keys(:terraform_state_versions)
617main: -> 0.0052s
618main: -- foreign_keys(:terraform_state_versions)
619main: -> 0.0051s
620main: -- execute("LOCK TABLE ci_builds, terraform_state_versions IN SHARE ROW EXCLUSIVE MODE")
621main: -> 0.0013s
622main: -- execute("ALTER TABLE terraform_state_versions\nADD CONSTRAINT fk_04b91e4a9f_tmp\nFOREIGN KEY (ci_build_id)\nREFERENCES ci_builds (id_convert_to_bigint)\nON DELETE SET NULL\nNOT VALID;\n")
623main: -> 0.0020s
624main: -- execute("ALTER TABLE terraform_state_versions VALIDATE CONSTRAINT fk_04b91e4a9f_tmp;")
625main: -> 0.0023s
626main: -- foreign_keys(:ci_build_needs)
627main: -> 0.0048s
628main: -- execute("LOCK TABLE ci_builds, ci_build_needs IN ACCESS EXCLUSIVE MODE")
629main: -> 0.0014s
630main: -- remove_foreign_key(:ci_build_needs, "ci_builds", {:column=>:build_id, :primary_key=>:id, :name=>"fk_rails_3cf221d4ed"})
631main: -> 0.0067s
632main: -- quote_table_name(:ci_build_needs)
633main: -> 0.0000s
634main: -- quote_column_name("fk_rails_3cf221d4ed_tmp")
635main: -> 0.0000s
636main: -- quote_column_name("fk_rails_3cf221d4ed")
637main: -> 0.0000s
638main: -- execute("ALTER TABLE \"ci_build_needs\"\nRENAME CONSTRAINT \"fk_rails_3cf221d4ed_tmp\" TO \"fk_rails_3cf221d4ed\"\n")
639main: -> 0.0012s
640main: -- foreign_keys(:ci_build_pending_states)
641main: -> 0.0047s
642main: -- execute("LOCK TABLE ci_builds, ci_build_pending_states IN ACCESS EXCLUSIVE MODE")
643main: -> 0.0014s
644main: -- remove_foreign_key(:ci_build_pending_states, "ci_builds", {:column=>:build_id, :primary_key=>:id, :name=>"fk_rails_0bbbfeaf9d"})
645main: -> 0.0071s
646main: -- quote_table_name(:ci_build_pending_states)
647main: -> 0.0000s
648main: -- quote_column_name("fk_rails_0bbbfeaf9d_tmp")
649main: -> 0.0000s
650main: -- quote_column_name("fk_rails_0bbbfeaf9d")
651main: -> 0.0000s
652main: -- execute("ALTER TABLE \"ci_build_pending_states\"\nRENAME CONSTRAINT \"fk_rails_0bbbfeaf9d_tmp\" TO \"fk_rails_0bbbfeaf9d\"\n")
653main: -> 0.0013s
654main: -- foreign_keys(:ci_build_report_results)
655main: -> 0.0050s
656main: -- execute("LOCK TABLE ci_builds, ci_build_report_results IN ACCESS EXCLUSIVE MODE")
657main: -> 0.0013s
658main: -- remove_foreign_key(:ci_build_report_results, "ci_builds", {:column=>:build_id, :primary_key=>:id, :name=>"fk_rails_16cb1ff064"})
659main: -> 0.0068s
660main: -- quote_table_name(:ci_build_report_results)
661main: -> 0.0000s
662main: -- quote_column_name("fk_rails_16cb1ff064_tmp")
663main: -> 0.0000s
664main: -- quote_column_name("fk_rails_16cb1ff064")
665main: -> 0.0000s
666main: -- execute("ALTER TABLE \"ci_build_report_results\"\nRENAME CONSTRAINT \"fk_rails_16cb1ff064_tmp\" TO \"fk_rails_16cb1ff064\"\n")
667main: -> 0.0012s
668main: -- foreign_keys(:ci_build_trace_chunks)
669main: -> 0.0050s
670main: -- execute("LOCK TABLE ci_builds, ci_build_trace_chunks IN ACCESS EXCLUSIVE MODE")
671main: -> 0.0013s
672main: -- remove_foreign_key(:ci_build_trace_chunks, "ci_builds", {:column=>:build_id, :primary_key=>:id, :name=>"fk_rails_1013b761f2"})
673main: -> 0.0070s
674main: -- quote_table_name(:ci_build_trace_chunks)
675main: -> 0.0000s
676main: -- quote_column_name("fk_rails_1013b761f2_tmp")
677main: -> 0.0000s
678main: -- quote_column_name("fk_rails_1013b761f2")
679main: -> 0.0000s
680main: -- execute("ALTER TABLE \"ci_build_trace_chunks\"\nRENAME CONSTRAINT \"fk_rails_1013b761f2_tmp\" TO \"fk_rails_1013b761f2\"\n")
681main: -> 0.0013s
682main: -- foreign_keys(:ci_build_trace_metadata)
683main: -> 0.0056s
684main: -- execute("LOCK TABLE ci_builds, ci_build_trace_metadata IN ACCESS EXCLUSIVE MODE")
685main: -> 0.0013s
686main: -- remove_foreign_key(:ci_build_trace_metadata, "ci_builds", {:column=>:build_id, :primary_key=>:id, :name=>"fk_rails_aebc78111f"})
687main: -> 0.0070s
688main: -- quote_table_name(:ci_build_trace_metadata)
689main: -> 0.0000s
690main: -- quote_column_name("fk_rails_aebc78111f_tmp")
691main: -> 0.0000s
692main: -- quote_column_name("fk_rails_aebc78111f")
693main: -> 0.0000s
694main: -- execute("ALTER TABLE \"ci_build_trace_metadata\"\nRENAME CONSTRAINT \"fk_rails_aebc78111f_tmp\" TO \"fk_rails_aebc78111f\"\n")
695main: -> 0.0013s
696main: -- foreign_keys(:ci_builds_runner_session)
697main: -> 0.0048s
698main: -- execute("LOCK TABLE ci_builds, ci_builds_runner_session IN ACCESS EXCLUSIVE MODE")
699main: -> 0.0013s
700main: -- remove_foreign_key(:ci_builds_runner_session, "ci_builds", {:column=>:build_id, :primary_key=>:id, :name=>"fk_rails_70707857d3"})
701main: -> 0.0071s
702main: -- quote_table_name(:ci_builds_runner_session)
703main: -> 0.0000s
704main: -- quote_column_name("fk_rails_70707857d3_tmp")
705main: -> 0.0000s
706main: -- quote_column_name("fk_rails_70707857d3")
707main: -> 0.0000s
708main: -- execute("ALTER TABLE \"ci_builds_runner_session\"\nRENAME CONSTRAINT \"fk_rails_70707857d3_tmp\" TO \"fk_rails_70707857d3\"\n")
709main: -> 0.0013s
710main: -- foreign_keys(:ci_builds_metadata)
711main: -> 0.0050s
712main: -- execute("LOCK TABLE ci_builds, ci_builds_metadata IN ACCESS EXCLUSIVE MODE")
713main: -> 0.0013s
714main: -- remove_foreign_key(:ci_builds_metadata, "ci_builds", {:column=>:build_id, :primary_key=>:id, :name=>"fk_e20479742e"})
715main: -> 0.0068s
716main: -- quote_table_name(:ci_builds_metadata)
717main: -> 0.0000s
718main: -- quote_column_name("fk_e20479742e_tmp")
719main: -> 0.0000s
720main: -- quote_column_name("fk_e20479742e")
721main: -> 0.0000s
722main: -- execute("ALTER TABLE \"ci_builds_metadata\"\nRENAME CONSTRAINT \"fk_e20479742e_tmp\" TO \"fk_e20479742e\"\n")
723main: -> 0.0013s
724main: -- foreign_keys(:ci_job_artifacts)
725main: -> 0.0049s
726main: -- execute("LOCK TABLE ci_builds, ci_job_artifacts IN ACCESS EXCLUSIVE MODE")
727main: -> 0.0014s
728main: -- remove_foreign_key(:ci_job_artifacts, "ci_builds", {:column=>:job_id, :primary_key=>:id, :name=>"fk_rails_c5137cb2c1"})
729main: -> 0.0071s
730main: -- quote_table_name(:ci_job_artifacts)
731main: -> 0.0000s
732main: -- quote_column_name("fk_rails_c5137cb2c1_tmp")
733main: -> 0.0000s
734main: -- quote_column_name("fk_rails_c5137cb2c1")
735main: -> 0.0000s
736main: -- execute("ALTER TABLE \"ci_job_artifacts\"\nRENAME CONSTRAINT \"fk_rails_c5137cb2c1_tmp\" TO \"fk_rails_c5137cb2c1\"\n")
737main: -> 0.0013s
738main: -- foreign_keys(:ci_job_variables)
739main: -> 0.0052s
740main: -- execute("LOCK TABLE ci_builds, ci_job_variables IN ACCESS EXCLUSIVE MODE")
741main: -> 0.0011s
742main: -- remove_foreign_key(:ci_job_variables, "ci_builds", {:column=>:job_id, :primary_key=>:id, :name=>"fk_rails_fbf3b34792"})
743main: -> 0.0068s
744main: -- quote_table_name(:ci_job_variables)
745main: -> 0.0000s
746main: -- quote_column_name("fk_rails_fbf3b34792_tmp")
747main: -> 0.0001s
748main: -- quote_column_name("fk_rails_fbf3b34792")
749main: -> 0.0000s
750main: -- execute("ALTER TABLE \"ci_job_variables\"\nRENAME CONSTRAINT \"fk_rails_fbf3b34792_tmp\" TO \"fk_rails_fbf3b34792\"\n")
751main: -> 0.0011s
752main: -- foreign_keys(:ci_pending_builds)
753main: -> 0.0049s
754main: -- execute("LOCK TABLE ci_builds, ci_pending_builds IN ACCESS EXCLUSIVE MODE")
755main: -> 0.0012s
756main: -- remove_foreign_key(:ci_pending_builds, "ci_builds", {:column=>:build_id, :primary_key=>:id, :name=>"fk_rails_725a2644a3"})
757main: -> 0.0068s
758main: -- quote_table_name(:ci_pending_builds)
759main: -> 0.0000s
760main: -- quote_column_name("fk_rails_725a2644a3_tmp")
761main: -> 0.0000s
762main: -- quote_column_name("fk_rails_725a2644a3")
763main: -> 0.0000s
764main: -- execute("ALTER TABLE \"ci_pending_builds\"\nRENAME CONSTRAINT \"fk_rails_725a2644a3_tmp\" TO \"fk_rails_725a2644a3\"\n")
765main: -> 0.0011s
766main: -- foreign_keys(:ci_resources)
767main: -> 0.0050s
768main: -- execute("LOCK TABLE ci_builds, ci_resources IN ACCESS EXCLUSIVE MODE")
769main: -> 0.0011s
770main: -- remove_foreign_key(:ci_resources, "ci_builds", {:column=>:build_id, :primary_key=>:id, :name=>"fk_e169a8e3d5"})
771main: -> 0.0069s
772main: -- quote_table_name(:ci_resources)
773main: -> 0.0000s
774main: -- quote_column_name("fk_e169a8e3d5_tmp")
775main: -> 0.0000s
776main: -- quote_column_name("fk_e169a8e3d5")
777main: -> 0.0000s
778main: -- execute("ALTER TABLE \"ci_resources\"\nRENAME CONSTRAINT \"fk_e169a8e3d5_tmp\" TO \"fk_e169a8e3d5\"\n")
779main: -> 0.0012s
780main: -- foreign_keys(:ci_running_builds)
781main: -> 0.0052s
782main: -- execute("LOCK TABLE ci_builds, ci_running_builds IN ACCESS EXCLUSIVE MODE")
783main: -> 0.0012s
784main: -- remove_foreign_key(:ci_running_builds, "ci_builds", {:column=>:build_id, :primary_key=>:id, :name=>"fk_rails_da45cfa165"})
785main: -> 0.0069s
786main: -- quote_table_name(:ci_running_builds)
787main: -> 0.0000s
788main: -- quote_column_name("fk_rails_da45cfa165_tmp")
789main: -> 0.0000s
790main: -- quote_column_name("fk_rails_da45cfa165")
791main: -> 0.0000s
792main: -- execute("ALTER TABLE \"ci_running_builds\"\nRENAME CONSTRAINT \"fk_rails_da45cfa165_tmp\" TO \"fk_rails_da45cfa165\"\n")
793main: -> 0.0011s
794main: -- foreign_keys(:ci_sources_pipelines)
795main: -> 0.0049s
796main: -- execute("LOCK TABLE ci_builds, ci_sources_pipelines IN ACCESS EXCLUSIVE MODE")
797main: -> 0.0010s
798main: -- remove_foreign_key(:ci_sources_pipelines, "ci_builds", {:column=>:source_job_id, :primary_key=>:id, :name=>"fk_be5624bf37"})
799main: -> 0.0063s
800main: -- quote_table_name(:ci_sources_pipelines)
801main: -> 0.0000s
802main: -- quote_column_name("fk_be5624bf37_tmp")
803main: -> 0.0000s
804main: -- quote_column_name("fk_be5624bf37")
805main: -> 0.0000s
806main: -- execute("ALTER TABLE \"ci_sources_pipelines\"\nRENAME CONSTRAINT \"fk_be5624bf37_tmp\" TO \"fk_be5624bf37\"\n")
807main: -> 0.0011s
808main: -- foreign_keys(:ci_unit_test_failures)
809main: -> 0.0047s
810main: -- execute("LOCK TABLE ci_builds, ci_unit_test_failures IN ACCESS EXCLUSIVE MODE")
811main: -> 0.0009s
812main: -- remove_foreign_key(:ci_unit_test_failures, "ci_builds", {:column=>:build_id, :primary_key=>:id, :name=>"fk_0f09856e1f"})
813main: -> 0.0062s
814main: -- quote_table_name(:ci_unit_test_failures)
815main: -> 0.0000s
816main: -- quote_column_name("fk_0f09856e1f_tmp")
817main: -> 0.0000s
818main: -- quote_column_name("fk_0f09856e1f")
819main: -> 0.0000s
820main: -- execute("ALTER TABLE \"ci_unit_test_failures\"\nRENAME CONSTRAINT \"fk_0f09856e1f_tmp\" TO \"fk_0f09856e1f\"\n")
821main: -> 0.0009s
822main: -- foreign_keys(:dast_scanner_profiles_builds)
823main: -> 0.0047s
824main: -- execute("LOCK TABLE ci_builds, dast_scanner_profiles_builds IN ACCESS EXCLUSIVE MODE")
825main: -> 0.0009s
826main: -- remove_foreign_key(:dast_scanner_profiles_builds, "ci_builds", {:column=>:ci_build_id, :primary_key=>:id, :name=>"fk_e4c49200f8"})
827main: -> 0.0061s
828main: -- quote_table_name(:dast_scanner_profiles_builds)
829main: -> 0.0000s
830main: -- quote_column_name("fk_e4c49200f8_tmp")
831main: -> 0.0000s
832main: -- quote_column_name("fk_e4c49200f8")
833main: -> 0.0000s
834main: -- execute("ALTER TABLE \"dast_scanner_profiles_builds\"\nRENAME CONSTRAINT \"fk_e4c49200f8_tmp\" TO \"fk_e4c49200f8\"\n")
835main: -> 0.0009s
836main: -- foreign_keys(:dast_site_profiles_builds)
837main: -> 0.0047s
838main: -- execute("LOCK TABLE ci_builds, dast_site_profiles_builds IN ACCESS EXCLUSIVE MODE")
839main: -> 0.0009s
840main: -- remove_foreign_key(:dast_site_profiles_builds, "ci_builds", {:column=>:ci_build_id, :primary_key=>:id, :name=>"fk_a325505e99"})
841main: -> 0.0063s
842main: -- quote_table_name(:dast_site_profiles_builds)
843main: -> 0.0000s
844main: -- quote_column_name("fk_a325505e99_tmp")
845main: -> 0.0000s
846main: -- quote_column_name("fk_a325505e99")
847main: -> 0.0000s
848main: -- execute("ALTER TABLE \"dast_site_profiles_builds\"\nRENAME CONSTRAINT \"fk_a325505e99_tmp\" TO \"fk_a325505e99\"\n")
849main: -> 0.0010s
850main: -- foreign_keys(:pages_deployments)
851main: -> 0.0049s
852main: -- execute("LOCK TABLE ci_builds, pages_deployments IN ACCESS EXCLUSIVE MODE")
853main: -> 0.0012s
854main: -- remove_foreign_key(:pages_deployments, "ci_builds", {:column=>:ci_build_id, :primary_key=>:id, :name=>"fk_rails_c3a90cf29b"})
855main: -> 0.0064s
856main: -- quote_table_name(:pages_deployments)
857main: -> 0.0000s
858main: -- quote_column_name("fk_rails_c3a90cf29b_tmp")
859main: -> 0.0000s
860main: -- quote_column_name("fk_rails_c3a90cf29b")
861main: -> 0.0000s
862main: -- execute("ALTER TABLE \"pages_deployments\"\nRENAME CONSTRAINT \"fk_rails_c3a90cf29b_tmp\" TO \"fk_rails_c3a90cf29b\"\n")
863main: -> 0.0010s
864main: -- foreign_keys(:requirements_management_test_reports)
865main: -> 0.0048s
866main: -- execute("LOCK TABLE ci_builds, requirements_management_test_reports IN ACCESS EXCLUSIVE MODE")
867main: -> 0.0009s
868main: -- remove_foreign_key(:requirements_management_test_reports, "ci_builds", {:column=>:build_id, :primary_key=>:id, :name=>"fk_rails_e67d085910"})
869main: -> 0.0059s
870main: -- quote_table_name(:requirements_management_test_reports)
871main: -> 0.0000s
872main: -- quote_column_name("fk_rails_e67d085910_tmp")
873main: -> 0.0000s
874main: -- quote_column_name("fk_rails_e67d085910")
875main: -> 0.0000s
876main: -- execute("ALTER TABLE \"requirements_management_test_reports\"\nRENAME CONSTRAINT \"fk_rails_e67d085910_tmp\" TO \"fk_rails_e67d085910\"\n")
877main: -> 0.0009s
878main: -- foreign_keys(:security_scans)
879main: -> 0.0042s
880main: -- execute("LOCK TABLE ci_builds, security_scans IN ACCESS EXCLUSIVE MODE")
881main: -> 0.0012s
882main: -- remove_foreign_key(:security_scans, "ci_builds", {:column=>:build_id, :primary_key=>:id, :name=>"fk_rails_4ef1e6b4c6"})
883main: -> 0.0057s
884main: -- quote_table_name(:security_scans)
885main: -> 0.0000s
886main: -- quote_column_name("fk_rails_4ef1e6b4c6_tmp")
887main: -> 0.0000s
888main: -- quote_column_name("fk_rails_4ef1e6b4c6")
889main: -> 0.0000s
890main: -- execute("ALTER TABLE \"security_scans\"\nRENAME CONSTRAINT \"fk_rails_4ef1e6b4c6_tmp\" TO \"fk_rails_4ef1e6b4c6\"\n")
891main: -> 0.0012s
892main: -- foreign_keys(:terraform_state_versions)
893main: -> 0.0043s
894main: -- execute("LOCK TABLE ci_builds, terraform_state_versions IN ACCESS EXCLUSIVE MODE")
895main: -> 0.0012s
896main: -- remove_foreign_key(:terraform_state_versions, "ci_builds", {:column=>:ci_build_id, :primary_key=>:id, :name=>"fk_04b91e4a9f"})
897main: -> 0.0059s
898main: -- quote_table_name(:terraform_state_versions)
899main: -> 0.0000s
900main: -- quote_column_name("fk_04b91e4a9f_tmp")
901main: -> 0.0000s
902main: -- quote_column_name("fk_04b91e4a9f")
903main: -> 0.0000s
904main: -- execute("ALTER TABLE \"terraform_state_versions\"\nRENAME CONSTRAINT \"fk_04b91e4a9f_tmp\" TO \"fk_04b91e4a9f\"\n")
905main: -> 0.0012s
906main: -- quote_table_name("ci_builds")
907main: -> 0.0000s
908main: -- quote_column_name(:id)
909main: -> 0.0000s
910main: -- quote_column_name("id_tmp")
911main: -> 0.0000s
912main: -- execute("ALTER TABLE \"ci_builds\" RENAME COLUMN \"id\" TO \"id_tmp\"")
913main: -> 0.0012s
914main: -- quote_column_name(:id_convert_to_bigint)
915main: -> 0.0000s
916main: -- quote_column_name(:id)
917main: -> 0.0000s
918main: -- execute("ALTER TABLE \"ci_builds\" RENAME COLUMN \"id_convert_to_bigint\" TO \"id\"")
919main: -> 0.0011s
920main: -- quote_column_name("id_tmp")
921main: -> 0.0000s
922main: -- quote_column_name(:id_convert_to_bigint)
923main: -> 0.0000s
924main: -- execute("ALTER TABLE \"ci_builds\" RENAME COLUMN \"id_tmp\" TO \"id_convert_to_bigint\"")
925main: -> 0.0012s
926main: -- quote_table_name("trigger_3f6129be01d2")
927main: -> 0.0000s
928main: -- execute("ALTER FUNCTION \"trigger_3f6129be01d2\" RESET ALL")
929main: -> 0.0011s
930main: -- execute("ALTER SEQUENCE ci_builds_id_seq OWNED BY ci_builds.id")
931main: -> 0.0012s
932main: -- change_column_default("ci_builds", :id, #<Proc:0x00007f5f03077dd0 /builds/gitlab-org/gitlab/db/post_migrate/20210907211557_finalize_ci_builds_bigint_conversion.rb:145 (lambda)>)
933main: -> 0.0075s
934main: -- change_column_default("ci_builds", :id_convert_to_bigint, 0)
935main: -> 0.0072s
936main: -- execute("ALTER TABLE \"ci_builds\" DROP CONSTRAINT ci_builds_pkey")
937main: -> 0.0016s
938main: -- rename_index("ci_builds", "index_ci_builds_on_converted_id", "ci_builds_pkey")
939main: -> 0.0013s
940main: -- execute("ALTER TABLE \"ci_builds\" ADD CONSTRAINT ci_builds_pkey PRIMARY KEY USING INDEX ci_builds_pkey")
941main: -> 0.0014s
942main: -- remove_index("ci_builds", {:name=>:index_ci_builds_on_commit_id_artifacts_expired_at_and_id})
943main: -> 0.0013s
944main: -- rename_index("ci_builds", :index_ci_builds_on_commit_id_expire_at_and_converted_id, :index_ci_builds_on_commit_id_artifacts_expired_at_and_id)
945main: -> 0.0012s
946main: -- remove_index("ci_builds", {:name=>:index_ci_builds_on_project_id_and_id})
947main: -> 0.0014s
948main: -- rename_index("ci_builds", :index_ci_builds_on_project_and_converted_id, :index_ci_builds_on_project_id_and_id)
949main: -> 0.0012s
950main: -- remove_index("ci_builds", {:name=>:index_ci_builds_on_runner_id_and_id_desc})
951main: -> 0.0014s
952main: -- rename_index("ci_builds", :index_ci_builds_on_runner_id_and_converted_id_desc, :index_ci_builds_on_runner_id_and_id_desc)
953main: -> 0.0012s
954main: -- remove_index("ci_builds", {:name=>:index_for_resource_group})
955main: -> 0.0014s
956main: -- rename_index("ci_builds", :index_ci_builds_on_resource_group_and_converted_id, :index_for_resource_group)
957main: -> 0.0011s
958main: -- remove_index("ci_builds", {:name=>:index_security_ci_builds_on_name_and_id_parser_features})
959main: -> 0.0014s
960main: -- rename_index("ci_builds", :index_security_ci_builds_on_name_and_converted_id_parser, :index_security_ci_builds_on_name_and_id_parser_features)
961main: -> 0.0012s
962main: -- remove_index("ci_builds", {:name=>:index_ci_builds_runner_id_pending_covering})
963main: -> 0.0013s
964main: -- rename_index("ci_builds", :index_ci_builds_runner_id_and_converted_id_pending_covering, :index_ci_builds_runner_id_pending_covering)
965main: -> 0.0011s
966main: == 20210907211557 FinalizeCiBuildsBigintConversion: migrated (1.2023s) ========
967main: -- foreign_keys(:ci_sources_pipelines)
968main: -> 0.0066s
969main: -- foreign_keys(:ci_sources_pipelines)
970main: -> 0.0054s
971 removes the FK and migrates successfully
972RescheduleDeleteOrphanedDeployments
973== 20210722010101 RescheduleDeleteOrphanedDeployments: migrating ==============
974-- Scheduled 7 DeleteOrphanedDeployments jobs with a maximum of 1 records per batch and an interval of 120 seconds.
975The migration is expected to take at least 840 seconds. Expect all jobs to have completed after 2022-07-04 07:34:25 UTC."
976== 20210722010101 RescheduleDeleteOrphanedDeployments: migrated (0.1164s) =====
977 steal existing background migration jobs
978== 20210722010101 RescheduleDeleteOrphanedDeployments: migrating ==============
979-- Scheduled 7 DeleteOrphanedDeployments jobs with a maximum of 1 records per batch and an interval of 120 seconds.
980The migration is expected to take at least 840 seconds. Expect all jobs to have completed after 2022-07-04 07:34:29 UTC."
981== 20210722010101 RescheduleDeleteOrphanedDeployments: migrated (0.0708s) =====
982 cleans up background migration jobs tracking records
983== 20210722010101 RescheduleDeleteOrphanedDeployments: migrating ==============
984-- Scheduled 7 DeleteOrphanedDeployments jobs with a maximum of 1 records per batch and an interval of 120 seconds.
985The migration is expected to take at least 840 seconds. Expect all jobs to have completed after 2022-07-04 07:34:32 UTC."
986== 20210722010101 RescheduleDeleteOrphanedDeployments: migrated (0.1197s) =====
987 schedules DeleteOrphanedDeployments background jobs
988Gitlab::BackgroundMigration::BackfillProjectsWithCoverage
989 #perform
990 creates entries per project and default_branch combination in the given range
991 when an entry for the project and default branch combination already exists
992 does not create a new entry
993BackfillClustersIntegrationPrometheusEnabled
994 #up
995== 20210519104931 BackfillClustersIntegrationPrometheusEnabled: migrating =====
996== 20210519104931 BackfillClustersIntegrationPrometheusEnabled: migrated (0.0034s)
997 backfills the enabled status and alert manager credentials from clusters_applications_prometheus
998Gitlab::BackgroundMigration::BackfillCiQueuingTables
999 #perform
1000 creates ci_pending_builds for all pending builds in range
1001 skips builds that already have ci_pending_builds
1002 upserts values in case of conflicts
1003 Ci::Build
1004 .each_batch
1005 yields an ActiveRecord::Relation when a block is given
1006 yields a batch index as the second argument
1007 accepts a custom batch size
1008 does not include ORDER BYs in the yielded relations
1009 orders ascending
1010UpdateExternalProjectBots
1011== 20210811122206 UpdateExternalProjectBots: migrating ========================
1012-- index_exists?("users", "id", {:name=>"tmp_idx_update_external_project_bots", :where=>"external = true", :algorithm=>:concurrently})
1013 -> 0.0290s
1014-- add_index("users", "id", {:name=>"tmp_idx_update_external_project_bots", :where=>"external = true", :algorithm=>:concurrently})
1015 -> 0.0038s
1016-- indexes("users")
1017 -> 0.0300s
1018-- remove_index("users", {:algorithm=>:concurrently, :name=>"tmp_idx_update_external_project_bots"})
1019 -> 0.0020s
1020== 20210811122206 UpdateExternalProjectBots: migrated (0.0891s) ===============
1021 sets bot users as external if were created by external users
1022DropInt4ColumnForCiSourcesPipelines
1023main: == 20210922025631 DropInt4ColumnForCiSourcesPipelines: migrating ==============
1024main: -- remove_column(:ci_sources_pipelines, :source_job_id_convert_to_bigint, :integer)
1025main: -> 0.0012s
1026main: == 20210922025631 DropInt4ColumnForCiSourcesPipelines: migrated (0.0016s) =====
1027 correctly migrates up and down
1028Gitlab::BackgroundMigration::PopulateTopicsTotalProjectsCountCache
1029 correctly populates total projects count cache
1030The application_settings (main) table has 1253 columns.
1031Recreating the database
1032Dropped database 'gitlabhq_test'
1033Dropped database 'gitlabhq_test_ci'
1034Dropped database 'gitlabhq_geo_test'
1035Created database 'gitlabhq_test'
1036Created database 'gitlabhq_test_ci'
1037Created database 'gitlabhq_geo_test'
1038Databases re-creation done in 11.082681326000056
1039EncryptStaticObjectToken
1040main: == 20211210140629 EncryptStaticObjectToken: migrating =========================
1041main: -- Scheduled 2 EncryptStaticObjectToken jobs with a maximum of 1 records per batch and an interval of 120 seconds.
1042The migration is expected to take at least 240 seconds. Expect all jobs to have completed after 2022-07-04 07:29:41 UTC."
1043main: == 20211210140629 EncryptStaticObjectToken: migrated (0.1259s) ================
1044 schedules background migrations
1045BackfillProjectNamespacesForGroup
1046 #up
1047main: == 20211209103048 BackfillProjectNamespacesForGroup: migrating ================
1048main: == 20211209103048 BackfillProjectNamespacesForGroup: migrated (0.0696s) =======
1049 schedules background jobs for each batch of namespaces
1050 #down
1051main: == 20211209103048 BackfillProjectNamespacesForGroup: migrating ================
1052main: == 20211209103048 BackfillProjectNamespacesForGroup: migrated (0.0133s) =======
1053 deletes all batched migration records
1054RemoveJobsForRecalculateVulnerabilitiesOccurrencesUuid
1055 when RecalculateVulnerabilitiesOccurrencesUuid jobs are present
1056main: == 20211207125331 RemoveJobsForRecalculateVulnerabilitiesOccurrencesUuid: migrating
1057main: == 20211207125331 RemoveJobsForRecalculateVulnerabilitiesOccurrencesUuid: migrated (0.0147s)
1058 removes all jobs
1059ScheduleUpdateTimelogsNullSpentAt
1060main: == 20211215090620 ScheduleUpdateTimelogsNullSpentAt: migrating ================
1061main: -- Scheduled 2 UpdateTimelogsNullSpentAt jobs with a maximum of 2 records per batch and an interval of 120 seconds.
1062The migration is expected to take at least 240 seconds. Expect all jobs to have completed after 2022-07-04 07:31:08 UTC."
1063main: == 20211215090620 ScheduleUpdateTimelogsNullSpentAt: migrated (0.0546s) =======
1064 correctly schedules background migrations
1065BackfillDeploymentsFinishedAt
1066 #up
1067 when a deployment row does not have a value for finished_at
1068 and deployment succeeded
1069main: == 20220426185933 BackfillDeploymentsFinishedAt: migrating ====================
1070main: == 20220426185933 BackfillDeploymentsFinishedAt: migrated (0.0202s) ===========
1071 copies created_at to finished_at
1072 and deployment does not have status: success
1073main: == 20220426185933 BackfillDeploymentsFinishedAt: migrating ====================
1074main: == 20220426185933 BackfillDeploymentsFinishedAt: migrated (0.0046s) ===========
1075 does not fill finished_at
1076 when a deployment row has value for finished_at
1077main: == 20220426185933 BackfillDeploymentsFinishedAt: migrating ====================
1078main: == 20220426185933 BackfillDeploymentsFinishedAt: migrated (0.0052s) ===========
1079 does not affect existing value
1080Gitlab::BackgroundMigration::BackfillNamespaceIdForNamespaceRoute
1081 backfills `type` for the selected records
1082 tracks timings of queries
1083BackfillGroupFeatures
1084 #up
1085main: == 20220302114046 BackfillGroupFeatures: migrating ============================
1086main: == 20220302114046 BackfillGroupFeatures: migrated (0.0793s) ===================
1087 schedules background jobs for each batch of namespaces
1088 #down
1089main: == 20220302114046 BackfillGroupFeatures: migrating ============================
1090main: == 20220302114046 BackfillGroupFeatures: migrated (0.0522s) ===================
1091 deletes all batched migration records
1092RemoveDanglingRunningBuilds
1093main: == 20220128155251 RemoveDanglingRunningBuilds: migrating ======================
1094main: -- execute("DELETE FROM ci_running_builds\n USING ci_builds\n WHERE ci_builds.id = ci_running_builds.build_id\n AND ci_builds.status = 'failed'\n AND ci_builds.type = 'Ci::Build'\n AND ci_running_builds.id BETWEEN 1 AND 2\n")
1095main: -> 0.0027s
1096main: == 20220128155251 RemoveDanglingRunningBuilds: migrated (0.0200s) =============
1097 removes failed builds
1098Gitlab::BackgroundMigration::CleanupDraftDataFromFaultyRegex
1099 mr.draft == true, and title matches the leaky regex and not the corrected regex
1100 updates all open draft merge request's draft field to true
1101 marks successful slices as completed
1102RemoveDependencyListUsageDataFromRedis
1103 #up
1104main: == 20220310141349 RemoveDependencyListUsageDataFromRedis: migrating ===========
1105main: == 20220310141349 RemoveDependencyListUsageDataFromRedis: migrated (0.0009s) ==
1106 removes the hash from redis
1107AddEpicsRelativePosition
1108main: == 20220407135820 AddEpicsRelativePosition: migrating =========================
1109main: -- table_exists?(:epics)
1110main: -> 0.0037s
1111main: -- column_exists?(:epics, :relative_position)
1112main: -> 0.0063s
1113main: == 20220407135820 AddEpicsRelativePosition: migrated (0.0103s) ================
1114 does nothing if epics table contains relative_position
1115main: == 20220407135820 AddEpicsRelativePosition: migrating =========================
1116main: -- table_exists?(:epics)
1117main: -> 0.0033s
1118main: -- column_exists?(:epics, :relative_position)
1119main: -> 0.0061s
1120main: -- add_column(:epics, :relative_position, :integer)
1121main: -> 0.0021s
1122main: -- execute("UPDATE epics SET relative_position=id*500")
1123main: -> 0.0020s
1124main: == 20220407135820 AddEpicsRelativePosition: migrated (0.0142s) ================
1125 adds relative_position if missing and backfills it with ID value
1126ScheduleBackfillTopicsTitle
1127main: == 20220331133802 ScheduleBackfillTopicsTitle: migrating ======================
1128main: -- Scheduled 2 BackfillTopicsTitle jobs with a maximum of 2 records per batch and an interval of 120 seconds.
1129The migration is expected to take at least 240 seconds. Expect all jobs to have completed after 2022-07-04 07:33:58 UTC."
1130main: == 20220331133802 ScheduleBackfillTopicsTitle: migrated (0.0387s) =============
1131 correctly schedules background migrations
1132Gitlab::BackgroundMigration::MergeTopicsWithSameName
1133/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.2/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil
1134/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.2/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil
1135/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.2/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil
1136/builds/gitlab-org/gitlab/vendor/ruby/2.7.0/gems/carrierwave-1.3.2/lib/carrierwave/mounter.rb:113: warning: deprecated Object#=~ is called on TrueClass; it always returns nil
1137 merges project topics with same case insensitive name
1138Gitlab::BackgroundMigration::EncryptIntegrationProperties
1139 ensures all properties are encrypted
1140Gitlab::BackgroundMigration::FixMergeRequestDiffCommitUsers
1141 #perform
1142 when the project exists
1143 does nothing
1144 when the project does not exist
1145 does nothing
1146UpdateLastRunDateForIterationsCadences
1147main: == 20220620132300 UpdateLastRunDateForIterationsCadences: migrating ===========
1148main: -- execute("UPDATE iterations_cadences SET last_run_date=CURRENT_DATE WHERE automatic=true;\n")
1149main: -> 0.0030s
1150main: == 20220620132300 UpdateLastRunDateForIterationsCadences: migrated (0.0034s) ==
1151 sets last_run_date to CURRENT_DATE for iterations cadences with automatic=true
1152Gitlab::BackgroundMigration::BackfillNoteDiscussionId
1153 updates records in the specified batch
1154Knapsack report was generated. Preview:
1155{
1156 "spec/migrations/add_premium_and_ultimate_plan_limits_spec.rb": 59.23542006700063,
1157 "spec/migrations/add_new_trail_plans_spec.rb": 77.68114095300007,
1158 "spec/lib/gitlab/background_migration/backfill_jira_tracker_deployment_type2_spec.rb": 68.76319674800015,
1159 "spec/migrations/20210603222333_remove_builds_email_service_from_services_spec.rb": 49.54301455899986,
1160 "spec/lib/gitlab/background_migration/update_timelogs_project_id_spec.rb": 59.897086058999776,
1161 "spec/migrations/delete_security_findings_without_uuid_spec.rb": 56.232293831999414,
1162 "spec/migrations/20210818185845_backfill_projects_with_coverage_spec.rb": 44.121406570000545,
1163 "spec/migrations/update_integrations_trigger_type_new_on_insert_spec.rb": 58.720323905999976,
1164 "spec/migrations/20210907211557_finalize_ci_builds_bigint_conversion_spec.rb": 38.981992250000076,
1165 "spec/migrations/reschedule_delete_orphaned_deployments_spec.rb": 54.24142300699987,
1166 "spec/lib/gitlab/background_migration/backfill_projects_with_coverage_spec.rb": 44.36156433799988,
1167 "spec/migrations/backfill_clusters_integration_prometheus_enabled_spec.rb": 49.90466976700009,
1168 "spec/lib/gitlab/background_migration/backfill_ci_queuing_tables_spec.rb": 39.37470910799948,
1169 "spec/migrations/20210811122206_update_external_project_bots_spec.rb": 41.877415038000436,
1170 "spec/migrations/20210922025631_drop_int4_column_for_ci_sources_pipelines_spec.rb": 35.864185061999706,
1171 "spec/lib/gitlab/background_migration/populate_topics_total_projects_count_cache_spec.rb": 33.89059278199966,
1172 "spec/migrations/20211210140629_encrypt_static_object_token_spec.rb": 24.747054061999734,
1173 "spec/migrations/backfill_project_namespaces_for_group_spec.rb": 29.04782376700041,
1174 "spec/migrations/20211207125331_remove_jobs_for_recalculate_vulnerabilities_occurrences_uuid_spec.rb": 25.273738075999972,
1175 "spec/migrations/schedule_update_timelogs_null_spent_at_spec.rb": 24.708198092000202,
1176 "spec/migrations/20220426185933_backfill_deployments_finished_at_spec.rb": 17.431595194999318,
1177 "spec/lib/gitlab/background_migration/backfill_namespace_id_for_namespace_route_spec.rb": 24.119724602000133,
1178 "spec/migrations/backfill_group_features_spec.rb": 20.31891216599979,
1179 "spec/migrations/20220128155251_remove_dangling_running_builds_spec.rb": 20.319083865999346,
1180 "spec/lib/gitlab/background_migration/cleanup_draft_data_from_faulty_regex_spec.rb": 16.547720775000016,
1181 "spec/migrations/20220310141349_remove_dependency_list_usage_data_from_redis_spec.rb": 17.20590661300048,
1182 "spec/migrations/add_epics_relative_position_spec.rb": 16.735657784000068,
1183 "spec/migrations/20220331133802_schedule_backfill_topics_title_spec.rb": 13.898120744000153,
1184 "spec/lib/gitlab/background_migration/merge_topics_with_same_name_spec.rb": 14.902745303999836,
1185 "spec/lib/gitlab/background_migration/encrypt_integration_properties_spec.rb": 11.573946008000348,
1186 "spec/lib/gitlab/background_migration/fix_merge_request_diff_commit_users_spec.rb": 8.096009967999635,
1187 "spec/migrations/20220620132300_update_last_run_date_for_iterations_cadences_spec.rb": 5.104021145000843,
1188 "spec/lib/gitlab/background_migration/backfill_note_discussion_id_spec.rb": 4.096204565000335
1189}
1190Knapsack global time execution for tests: 18m 26s
1191Finished in 20 minutes 5 seconds (files took 1 minute 8.99 seconds to load)
119272 examples, 0 failures
1193RSpec exited with 0.
1194No examples to retry, congrats!
1195 Saving cache for successful job 00:02
1196Not uploading cache ruby-gems-debian-bullseye-ruby-2.7-10 due to policy
1197Not uploading cache gitaly-ruby-gems-debian-bullseye-ruby-2.7-10 due to policy
1198 Uploading artifacts for successful job 00:06
1199Uploading artifacts...
1200coverage/: found 5 matching files and directories
1201crystalball/: found 2 matching files and directories
1202WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory
1203knapsack/: found 3 matching files and directories
1204rspec/: found 8 matching files and directories
1205WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory
1206log/*.log: found 15 matching files and directories
1207WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/2673336906/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com
1208WARNING: Retrying... context=artifacts-uploader error=request redirected
1209Uploading artifacts as "archive" to coordinator... 201 Created id=2673336906 responseStatus=201 Created token=4hXsmR-o
1210Uploading artifacts...
1211rspec/junit_rspec.xml: found 1 matching files and directories
1212WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/2673336906/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com
1213WARNING: Retrying... context=artifacts-uploader error=request redirected
1214Uploading artifacts as "junit" to coordinator... 201 Created id=2673336906 responseStatus=201 Created token=4hXsmR-o
1215 Cleaning up project directory and file based variables 00:01
1216Job succeeded