rspec migration pg14 5/26
Passed Started
by
@gitlab-bot

🤖 GitLab Bot 🤖
1Running with gitlab-runner 17.0.0~pre.88.g761ae5dd (761ae5dd)2 on green-1.shared-gitlab-org.runners-manager.gitlab.com/default Mf8beF5G, system ID: s_673deea48c2a3 feature flags: FF_NETWORK_PER_BUILD:true4Resolving secrets6Using Docker executor with image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-123-yarn-1.22-graphicsmagick-1.3.36 ...7Starting service registry.gitlab.com/gitlab-org/gitlab-build-images:postgres-14-pgvector-0.4.1 ...8Authenticating with credentials from job payload (GitLab Registry)9Pulling docker image registry.gitlab.com/gitlab-org/gitlab-build-images:postgres-14-pgvector-0.4.1 ...10Using docker image sha256:82f132c22567f8ce17cc132c14b2f9aa3eaf9bb5424d91c2d966912433f0257d for registry.gitlab.com/gitlab-org/gitlab-build-images:postgres-14-pgvector-0.4.1 with digest registry.gitlab.com/gitlab-org/gitlab-build-images@sha256:c55e1364ee4327b244a9cfa1750f19feea14fc774eaf792b725967d146eb45f5 ...11WARNING: Service registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 is already created. Ignoring.12WARNING: Service registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 is already created. Ignoring.13Starting service registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 ...14Authenticating with credentials from job payload (GitLab Registry)15Pulling docker image registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 ...16Using docker image sha256:5c5ba5b83d6c60cb0b225bd670b7a43be8c238cc72347d24af57e5027c3648f3 for registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 with digest registry.gitlab.com/gitlab-org/gitlab-build-images@sha256:46aceab84c42d0e819c8e7940f2f98ce9e184785cd7b22d95872024a35f52407 ...17Starting service redis:6.2-alpine ...18Pulling docker image redis:6.2-alpine ...19Using docker image sha256:36c1d3cfe18f4b12d4640576f7048068acbfc3625027b6bbb46bba0e31b11831 for redis:6.2-alpine with digest redis@sha256:e3b17ba9479deec4b7d1eeec1548a253acc5374d68d3b27937fcfe4df8d18c7e ...20Waiting for services to be up and running (timeout 30 seconds)...21Authenticating with credentials from job payload (GitLab Registry)22Pulling docker image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-123-yarn-1.22-graphicsmagick-1.3.36 ...23Using docker image sha256:b26253b493531cada33f45ef568f38c50a310442d05c39f517656e0f7d305dc7 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-123-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14@sha256:543339542a02edc250c2c0424c5077b673f1fca2877024fdc5fb670eff44f8cf ...25Running on runner-mf8bef5g-project-278964-concurrent-0 via runner-mf8bef5g-shared-gitlab-org-1722418060-b6000504...27Skipping Git repository setup28Skipping Git checkout29Skipping Git submodules setup31Checking cache for ruby-gems-debian-bookworm-ruby-3.1.5-17...32Downloading cache from https://storage.googleapis.com/gitlab-com-runners-cache/project/278964/ruby-gems-debian-bookworm-ruby-3.1.5-17 33Successfully extracted cache35Downloading artifacts for clone-gitlab-repo (7471344368)...36Downloading artifacts from coordinator... ok host=storage.googleapis.com id=7471344368 responseStatus=200 OK token=glcbt-6637WARNING: Part of .git directory is on the list of files to extract 38WARNING: This may introduce unexpected problems 39Downloading artifacts for compile-test-assets (7471344747)...40Downloading artifacts from coordinator... ok host=storage.googleapis.com id=7471344747 responseStatus=200 OK token=glcbt-6641Downloading artifacts for retrieve-tests-metadata (7471344898)...42Downloading artifacts from coordinator... ok host=storage.googleapis.com id=7471344898 responseStatus=200 OK token=glcbt-6643Downloading artifacts for setup-test-env (7471344810)...44Downloading artifacts from coordinator... ok host=storage.googleapis.com id=7471344810 responseStatus=200 OK token=glcbt-66 45 Executing "step_script" stage of the job script 46Using docker image sha256:b26253b493531cada33f45ef568f38c50a310442d05c39f517656e0f7d305dc7 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-123-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14@sha256:543339542a02edc250c2c0424c5077b673f1fca2877024fdc5fb670eff44f8cf ...47$ echo $FOSS_ONLY48$ [ "$FOSS_ONLY" = "1" ] && rm -rf ee/ qa/spec/ee/ qa/qa/specs/features/ee/ qa/qa/ee/ qa/qa/ee.rb49$ export GOPATH=$CI_PROJECT_DIR/.go50$ mkdir -p $GOPATH51$ source scripts/utils.sh52$ source scripts/prepare_build.sh82Using decomposed database config (config/database.yml.decomposed-postgresql)83Geo DB won't be set up.84Embedding DB won't be set up.96$ source ./scripts/rspec_helpers.sh97$ run_timed_command "gem install knapsack --no-document"98$ gem install knapsack --no-document99Successfully installed knapsack-4.0.01001 gem installed101==> 'gem install knapsack --no-document' succeeded in 1 seconds.102$ section_start "gitaly-test-spawn" "Spawning Gitaly"; scripts/gitaly-test-spawn; section_end "gitaly-test-spawn"107$ export RSPEC_SKIPPED_TESTS_REPORT_PATH="rspec/skipped_tests-${CI_JOB_ID}.txt"108$ export RSPEC_RETRIED_TESTS_REPORT_PATH="rspec/retried_tests-${CI_JOB_ID}.txt"109$ tooling/bin/create_job_metrics_file || true110[job-metrics] Creating the job metrics file for the CI/CD job.111$ rspec_section rspec_parallelized_job "--fail-fast=${RSPEC_FAIL_FAST_THRESHOLD} --tag ~quarantine --tag ~zoekt --tag ~click_house"113[10:16:19] Starting rspec_parallelized_job114RETRY_FAILED_TESTS_IN_NEW_PROCESS: true115KNAPSACK_GENERATE_REPORT: true116FLAKY_RSPEC_GENERATE_REPORT: true117KNAPSACK_TEST_FILE_PATTERN: spec/{migrations}{,/**/}*_spec.rb118KNAPSACK_LOG_LEVEL: debug119KNAPSACK_REPORT_PATH: knapsack/rspec_migration_pg14_5_26_278964_report.json120FLAKY_RSPEC_SUITE_REPORT_PATH: rspec/flaky/report-suite.json121FLAKY_RSPEC_REPORT_PATH: rspec/flaky/all_rspec_migration_pg14_5_26_278964_report.json122NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg14_5_26_278964_report.json123RSPEC_SKIPPED_TESTS_REPORT_PATH: rspec/skipped_tests-7471345400.txt124CRYSTALBALL: true125RSPEC_TESTS_MAPPING_ENABLED: 126RSPEC_TESTS_FILTER_FILE: 127Shell set options (set -o) enabled:128braceexpand on129hashall on130interactive-comments on131pipefail on132Knapsack report generator started!133warning: parser/current is loading parser/ruby31, which recognizes 3.1.6-compliant syntax, but you are running 3.1.5.135Run options: exclude {:quarantine=>true, :zoekt=>true, :click_house=>true}136# [RSpecRunTime] Starting RSpec timer...137[TEST PROF INFO] EventProf enabled (sql.active_record)138unknown OID 2249: failed to recognize type of 'pg_stat_file'. It will be treated as String.139unknown OID 2249: failed to recognize type of 'pg_stat_file'. It will be treated as String.140Test environment set up in 3.387752505 seconds141# [RSpecRunTime] Starting example group spec/migrations/20231218092401_queue_backfill_partition_id_ci_pipeline_chat_data_spec.rb. Expected to take 2 minutes 55.9 seconds.142QueueBackfillPartitionIdCiPipelineChatData143 #down144ci: == [advisory_lock_connection] object_id: 58086600, pg_backend_pid: 1605145ci: == 20231218092401 QueueBackfillPartitionIdCiPipelineChatData: migrating =======146ci: == 20231218092401 QueueBackfillPartitionIdCiPipelineChatData: migrated (0.0930s) 147ci: == [advisory_lock_connection] object_id: 58086600, pg_backend_pid: 1605148 deletes all batched migration records149 #up150 with migration present151 when migration finished successfully152ci: == [advisory_lock_connection] object_id: 60072800, pg_backend_pid: 1612153ci: == 20231218092401 QueueBackfillPartitionIdCiPipelineChatData: migrating =======154ci: == 20231218092401 QueueBackfillPartitionIdCiPipelineChatData: migrated (0.0356s) 155ci: == [advisory_lock_connection] object_id: 60072800, pg_backend_pid: 1612156 does not raise exception157ci: == [advisory_lock_connection] object_id: 60738800, pg_backend_pid: 1618158ci: == 20231218092401 QueueBackfillPartitionIdCiPipelineChatData: migrating =======159ci: == 20231218092401 QueueBackfillPartitionIdCiPipelineChatData: migrated (0.0348s) 160ci: == [advisory_lock_connection] object_id: 60738800, pg_backend_pid: 1618161 schedules background jobs for each batch of ci_pipeline_chat_data162# [RSpecRunTime] RSpec elapsed time: 3 minutes 3.14 seconds. Current RSS: ~1480M. Threads: 2. load average: 1.01 1.11 1.15 1/263 407163.164I, [2024-07-31T10:21:44.835194 #326] INFO -- : Database: 'main', Table: 'ci_job_token_group_scope_links': Lock Writes165INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree166INFO: analyzing "public.ci_pipeline_variables"167INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows168I, [2024-07-31T10:21:47.618248 #326] INFO -- : Database: 'main', Table: 'p_ci_pipeline_variables': Lock Writes169I, [2024-07-31T10:21:47.619965 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}170I, [2024-07-31T10:21:47.620898 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}171INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree172INFO: analyzing "public.ci_pipeline_variables"173INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows174INFO: analyzing "public.p_ci_job_artifacts" inheritance tree175INFO: analyzing "public.ci_job_artifacts"176INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows177I, [2024-07-31T10:21:54.007674 #326] INFO -- : Database: 'main', Table: 'p_ci_job_artifacts': Lock Writes178I, [2024-07-31T10:21:54.008839 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}179I, [2024-07-31T10:21:54.009733 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}180INFO: analyzing "public.p_ci_stages" inheritance tree181INFO: analyzing "public.ci_stages"182INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows183I, [2024-07-31T10:21:57.475508 #326] INFO -- : Database: 'main', Table: 'p_ci_stages': Lock Writes184I, [2024-07-31T10:21:57.476756 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}185I, [2024-07-31T10:21:57.477704 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}186I, [2024-07-31T10:21:58.685269 #326] INFO -- : Database: 'main', Table: 'p_ci_build_names': Lock Writes187I, [2024-07-31T10:22:05.007360 #326] INFO -- : Database: 'main', Table: 'p_ci_builds_execution_configs': Lock Writes188I, [2024-07-31T10:22:18.614660 #326] INFO -- : Database: 'main', Table: 'p_ci_build_sources': Lock Writes189I, [2024-07-31T10:22:18.615847 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}190I, [2024-07-31T10:22:18.616610 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}191I, [2024-07-31T10:22:29.971133 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes192I, [2024-07-31T10:22:36.545408 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes193I, [2024-07-31T10:22:46.700665 #326] INFO -- : Database: 'ci', Table: 'audit_events_group_external_streaming_destinations': Lock Writes194I, [2024-07-31T10:22:46.764384 #326] INFO -- : Database: 'ci', Table: 'packages_terraform_module_metadata': Lock Writes195I, [2024-07-31T10:22:46.798187 #326] INFO -- : Database: 'ci', Table: 'member_approvals': Lock Writes196I, [2024-07-31T10:22:46.830876 #326] INFO -- : Database: 'ci', Table: 'zoekt_repositories': Lock Writes197I, [2024-07-31T10:22:47.912133 #326] INFO -- : Database: 'ci', Table: 'audit_events_instance_external_streaming_destinations': Lock Writes198I, [2024-07-31T10:22:47.943565 #326] INFO -- : Database: 'ci', Table: 'catalog_verified_namespaces': Lock Writes199I, [2024-07-31T10:22:47.976612 #326] INFO -- : Database: 'ci', Table: 'group_saved_replies': Lock Writes200INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree201INFO: analyzing "public.ci_pipeline_variables"202INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows203INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree204INFO: analyzing "public.ci_pipeline_variables"205INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows206I, [2024-07-31T10:22:54.179343 #326] INFO -- : Database: 'ci', Table: 'zoekt_tasks': Lock Writes207I, [2024-07-31T10:22:54.409005 #326] INFO -- : Database: 'ci', Table: 'merge_request_diff_commits_b5377a7a34': Lock Writes208I, [2024-07-31T10:22:54.410215 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}209I, [2024-07-31T10:22:54.411307 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}210I, [2024-07-31T10:22:54.612576 #326] INFO -- : Database: 'ci', Table: 'audit_events_group_streaming_event_type_filters': Lock Writes211I, [2024-07-31T10:22:55.805608 #326] INFO -- : Database: 'ci', Table: 'remote_development_namespace_cluster_agent_mappings': Lock Writes212I, [2024-07-31T10:22:55.806781 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}213I, [2024-07-31T10:22:55.807606 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}214I, [2024-07-31T10:22:56.542835 #326] INFO -- : Database: 'ci', Table: 'p_catalog_resource_component_usages': Lock Writes215INFO: analyzing "public.p_ci_job_artifacts" inheritance tree216INFO: analyzing "public.ci_job_artifacts"217INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows218INFO: analyzing "public.p_ci_stages" inheritance tree219INFO: analyzing "public.ci_stages"220INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows221I, [2024-07-31T10:23:02.474175 #326] INFO -- : Database: 'ci', Table: 'audit_events_instance_streaming_event_type_filters': Lock Writes222I, [2024-07-31T10:23:02.576916 #326] INFO -- : Database: 'ci', Table: 'security_policies': Lock Writes223I, [2024-07-31T10:23:02.607834 #326] INFO -- : Database: 'ci', Table: 'approval_policy_rules': Lock Writes224I, [2024-07-31T10:23:02.800190 #326] INFO -- : Database: 'ci', Table: 'relation_import_trackers': Lock Writes225I, [2024-07-31T10:23:03.120517 #326] INFO -- : Database: 'ci', Table: 'project_saved_replies': Lock Writes226I, [2024-07-31T10:23:08.402404 #326] INFO -- : Database: 'ci', Table: 'import_source_users': Lock Writes227I, [2024-07-31T10:23:08.432237 #326] INFO -- : Database: 'ci', Table: 'audit_events_streaming_instance_namespace_filters': Lock Writes228I, [2024-07-31T10:23:08.513663 #326] INFO -- : Database: 'ci', Table: 'early_access_program_tracking_events': Lock Writes229I, [2024-07-31T10:23:09.048952 #326] INFO -- : Database: 'ci', Table: 'merge_request_diff_files_99208b8fac': Lock Writes230I, [2024-07-31T10:23:09.050198 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}231I, [2024-07-31T10:23:09.051015 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}232I, [2024-07-31T10:23:10.003345 #326] INFO -- : Database: 'ci', Table: 'audit_events_streaming_group_namespace_filters': Lock Writes233I, [2024-07-31T10:23:10.120384 #326] INFO -- : Database: 'ci', Table: 'ai_self_hosted_models': Lock Writes234I, [2024-07-31T10:23:10.151093 #326] INFO -- : Database: 'ci', Table: 'merge_request_requested_changes': Lock Writes235I, [2024-07-31T10:23:10.807592 #326] INFO -- : Database: 'ci', Table: 'custom_software_licenses': Lock Writes236I, [2024-07-31T10:23:10.837605 #326] INFO -- : Database: 'ci', Table: 'ai_vectorizable_files': Lock Writes237I, [2024-07-31T10:23:10.839058 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}238I, [2024-07-31T10:23:10.839874 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}239I, [2024-07-31T10:23:10.871919 #326] INFO -- : Database: 'ci', Table: 'ai_agent_version_attachments': Lock Writes240I, [2024-07-31T10:23:10.873434 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}241I, [2024-07-31T10:23:10.874249 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}242I, [2024-07-31T10:23:24.080533 #326] INFO -- : Database: 'ci', Table: 'ai_feature_settings': Lock Writes243I, [2024-07-31T10:23:24.115199 #326] INFO -- : Database: 'ci', Table: 'user_broadcast_message_dismissals': Lock Writes244I, [2024-07-31T10:23:24.344130 #326] INFO -- : Database: 'ci', Table: 'user_audit_events': Lock Writes245I, [2024-07-31T10:23:24.379511 #326] INFO -- : Database: 'ci', Table: 'group_audit_events': Lock Writes246I, [2024-07-31T10:23:24.416315 #326] INFO -- : Database: 'ci', Table: 'project_audit_events': Lock Writes247I, [2024-07-31T10:23:24.448855 #326] INFO -- : Database: 'ci', Table: 'instance_audit_events': Lock Writes248I, [2024-07-31T10:23:24.550402 #326] INFO -- : Database: 'ci', Table: 'scan_execution_policy_rules': Lock Writes249I, [2024-07-31T10:23:25.327438 #326] INFO -- : Database: 'ci', Table: 'vulnerability_export_parts': Lock Writes250I, [2024-07-31T10:23:25.953776 #326] INFO -- : Database: 'ci', Table: 'security_policy_project_links': Lock Writes251I, [2024-07-31T10:23:26.855845 #326] INFO -- : Database: 'ci', Table: 'zoekt_replicas': Lock Writes252I, [2024-07-31T10:23:26.988021 #326] INFO -- : Database: 'ci', Table: 'ai_testing_terms_acceptances': Lock Writes253I, [2024-07-31T10:23:37.900328 #326] INFO -- : Database: 'ci', Table: 'duo_workflows_workflows': Lock Writes254I, [2024-07-31T10:23:37.903412 #326] INFO -- : Database: 'ci', Table: 'duo_workflows_checkpoints': Lock Writes255I, [2024-07-31T10:23:38.730020 #326] INFO -- : Database: 'ci', Table: 'oauth_device_grants': Lock Writes256I, [2024-07-31T10:23:38.731213 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}257I, [2024-07-31T10:23:38.732023 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}258I, [2024-07-31T10:23:38.940852 #326] INFO -- : Database: 'ci', Table: 'abuse_report_notes': Lock Writes259I, [2024-07-31T10:23:39.622618 #326] INFO -- : Database: 'ci', Table: 'import_source_user_placeholder_references': Lock Writes260I, [2024-07-31T10:23:40.167817 #326] INFO -- : Database: 'ci', Table: 'virtual_registries_packages_maven_registries': Lock Writes261I, [2024-07-31T10:23:40.169119 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}262I, [2024-07-31T10:23:40.169960 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}263I, [2024-07-31T10:23:40.247355 #326] INFO -- : Database: 'ci', Table: 'virtual_registries_packages_maven_upstreams': Lock Writes264I, [2024-07-31T10:23:40.248658 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}265I, [2024-07-31T10:23:40.249495 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}266I, [2024-07-31T10:23:40.283702 #326] INFO -- : Database: 'ci', Table: 'virtual_registries_packages_maven_registry_upstreams': Lock Writes267I, [2024-07-31T10:23:40.284958 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}268I, [2024-07-31T10:23:40.285743 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}269I, [2024-07-31T10:23:40.482244 #326] INFO -- : Database: 'ci', Table: 'country_access_logs': Lock Writes270I, [2024-07-31T10:23:40.657232 #326] INFO -- : Database: 'ci', Table: 'dependency_list_export_parts': Lock Writes271I, [2024-07-31T10:23:40.956515 #326] INFO -- : Database: 'ci', Table: 'namespace_import_users': Lock Writes272I, [2024-07-31T10:23:50.065282 #326] INFO -- : Database: 'ci', Table: 'approval_policy_rule_project_links': Lock Writes273I, [2024-07-31T10:23:50.494877 #326] INFO -- : Database: 'ci', Table: 'virtual_registries_packages_maven_cached_responses': Lock Writes274I, [2024-07-31T10:23:50.496223 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}275I, [2024-07-31T10:23:50.497096 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}276# [RSpecRunTime] Finishing example group spec/migrations/20231218092401_queue_backfill_partition_id_ci_pipeline_chat_data_spec.rb. It took 5 minutes 15.29 seconds. Expected to take 2 minutes 55.9 seconds.277# [RSpecRunTime] RSpec elapsed time: 5 minutes 22.53 seconds. Current RSS: ~1398M. Threads: 2. load average: 1.35 1.15 1.15 1/261 408278.279# [RSpecRunTime] Starting example group spec/migrations/20230809203254_ensure_issue_user_mentions_bigint_backfill_is_finished_for_self_managed_spec.rb. Expected to take 1 minute 42.31 seconds.280EnsureIssueUserMentionsBigintBackfillIsFinishedForSelfManaged281 #up282main: == [advisory_lock_connection] object_id: 112783000, pg_backend_pid: 3083283main: == 20230809203254 EnsureIssueUserMentionsBigintBackfillIsFinishedForSelfManaged: migrating 284main: == 20230809203254 EnsureIssueUserMentionsBigintBackfillIsFinishedForSelfManaged: migrated (0.0099s) 285main: == [advisory_lock_connection] object_id: 112783000, pg_backend_pid: 3083286 ensures the migration is completed for self-managed instances287main: == [advisory_lock_connection] object_id: 113721440, pg_backend_pid: 3085288main: == 20230809203254 EnsureIssueUserMentionsBigintBackfillIsFinishedForSelfManaged: migrating 289main: == 20230809203254 EnsureIssueUserMentionsBigintBackfillIsFinishedForSelfManaged: migrated (0.0090s) 290main: == [advisory_lock_connection] object_id: 113721440, pg_backend_pid: 3085291 skips the check for GitLab.com, dev, or test292# [RSpecRunTime] RSpec elapsed time: 6 minutes 58.79 seconds. Current RSS: ~1452M. Threads: 2. load average: 1.25 1.16 1.15 1/262 409293.294INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree295INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"296INFO: "ci_runner_machine_builds_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows297INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"298INFO: "ci_runner_machine_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows299INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_102"300INFO: "ci_runner_machine_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows301INFO: analyzing "public.p_ci_job_annotations" inheritance tree302INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"303INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows304INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_101"305INFO: "ci_job_annotations_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows306INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_102"307INFO: "ci_job_annotations_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows308INFO: analyzing "public.p_ci_builds_metadata" inheritance tree309INFO: analyzing "public.ci_builds_metadata"310INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows311INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"312INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows313INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_102"314INFO: "ci_builds_metadata_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows315INFO: analyzing "public.p_ci_builds" inheritance tree316INFO: analyzing "public.ci_builds"317INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows318INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"319INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows320INFO: analyzing "gitlab_partitions_dynamic.ci_builds_102"321INFO: "ci_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows322I, [2024-07-31T10:25:40.040144 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes323I, [2024-07-31T10:26:00.103097 #326] INFO -- : Database: 'main', Table: 'ci_job_token_group_scope_links': Lock Writes324INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree325INFO: analyzing "public.ci_pipeline_variables"326INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows327I, [2024-07-31T10:26:01.829795 #326] INFO -- : Database: 'main', Table: 'p_ci_pipeline_variables': Lock Writes328I, [2024-07-31T10:26:01.831017 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}329I, [2024-07-31T10:26:01.831884 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}330INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree331INFO: analyzing "public.ci_pipeline_variables"332INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows333INFO: analyzing "public.p_ci_job_artifacts" inheritance tree334INFO: analyzing "public.ci_job_artifacts"335INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows336I, [2024-07-31T10:26:08.004861 #326] INFO -- : Database: 'main', Table: 'p_ci_job_artifacts': Lock Writes337I, [2024-07-31T10:26:08.006189 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}338I, [2024-07-31T10:26:08.007053 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}339INFO: analyzing "public.p_ci_stages" inheritance tree340INFO: analyzing "public.ci_stages"341INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows342I, [2024-07-31T10:26:11.503477 #326] INFO -- : Database: 'main', Table: 'p_ci_stages': Lock Writes343I, [2024-07-31T10:26:11.504912 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}344I, [2024-07-31T10:26:11.505817 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}345I, [2024-07-31T10:26:12.723533 #326] INFO -- : Database: 'main', Table: 'p_ci_build_names': Lock Writes346I, [2024-07-31T10:26:19.171417 #326] INFO -- : Database: 'main', Table: 'p_ci_builds_execution_configs': Lock Writes347I, [2024-07-31T10:26:32.986472 #326] INFO -- : Database: 'main', Table: 'p_ci_build_sources': Lock Writes348I, [2024-07-31T10:26:32.987629 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}349I, [2024-07-31T10:26:32.988382 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}350I, [2024-07-31T10:26:44.546431 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes351I, [2024-07-31T10:26:51.489514 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes352# [RSpecRunTime] Finishing example group spec/migrations/20230809203254_ensure_issue_user_mentions_bigint_backfill_is_finished_for_self_managed_spec.rb. It took 3 minutes 4.1 seconds. Expected to take 1 minute 42.31 seconds.353# [RSpecRunTime] RSpec elapsed time: 8 minutes 26.68 seconds. Current RSS: ~1371M. Threads: 2. load average: 1.02 1.11 1.14 1/263 411354.355# [RSpecRunTime] Starting example group spec/migrations/20230831084632_queue_sync_scan_result_policies_spec.rb. Expected to take 1 minute 32.58 seconds.356QueueSyncScanResultPolicies357main: == [advisory_lock_connection] object_id: 153661060, pg_backend_pid: 3103358main: == 20230831084632 QueueSyncScanResultPolicies: migrating ======================359main: == 20230831084632 QueueSyncScanResultPolicies: migrated (0.0626s) =============360main: == [advisory_lock_connection] object_id: 153661060, pg_backend_pid: 3103361 schedules a new batched migration362INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree363INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"364INFO: "ci_runner_machine_builds_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows365INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"366INFO: "ci_runner_machine_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows367INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_102"368INFO: "ci_runner_machine_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows369INFO: analyzing "public.p_ci_job_annotations" inheritance tree370INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"371INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows372INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_101"373INFO: "ci_job_annotations_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows374INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_102"375INFO: "ci_job_annotations_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows376INFO: analyzing "public.p_ci_builds_metadata" inheritance tree377INFO: analyzing "public.ci_builds_metadata"378INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows379INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"380INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows381INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_102"382INFO: "ci_builds_metadata_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows383INFO: analyzing "public.p_ci_builds" inheritance tree384INFO: analyzing "public.ci_builds"385INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows386INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"387INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows388INFO: analyzing "gitlab_partitions_dynamic.ci_builds_102"389INFO: "ci_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows390I, [2024-07-31T10:28:33.266880 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes391I, [2024-07-31T10:28:53.118307 #326] INFO -- : Database: 'main', Table: 'ci_job_token_group_scope_links': Lock Writes392INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree393INFO: analyzing "public.ci_pipeline_variables"394INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows395I, [2024-07-31T10:28:54.725747 #326] INFO -- : Database: 'main', Table: 'p_ci_pipeline_variables': Lock Writes396I, [2024-07-31T10:28:54.726872 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}397I, [2024-07-31T10:28:54.727633 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}398INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree399INFO: analyzing "public.ci_pipeline_variables"400INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows401INFO: analyzing "public.p_ci_job_artifacts" inheritance tree402INFO: analyzing "public.ci_job_artifacts"403INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows404I, [2024-07-31T10:29:00.789700 #326] INFO -- : Database: 'main', Table: 'p_ci_job_artifacts': Lock Writes405I, [2024-07-31T10:29:00.790951 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}406I, [2024-07-31T10:29:00.791764 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}407INFO: analyzing "public.p_ci_stages" inheritance tree408INFO: analyzing "public.ci_stages"409INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows410I, [2024-07-31T10:29:04.132992 #326] INFO -- : Database: 'main', Table: 'p_ci_stages': Lock Writes411I, [2024-07-31T10:29:04.134192 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}412I, [2024-07-31T10:29:04.135050 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}413I, [2024-07-31T10:29:05.373164 #326] INFO -- : Database: 'main', Table: 'p_ci_build_names': Lock Writes414I, [2024-07-31T10:29:11.708283 #326] INFO -- : Database: 'main', Table: 'p_ci_builds_execution_configs': Lock Writes415I, [2024-07-31T10:29:25.412448 #326] INFO -- : Database: 'main', Table: 'p_ci_build_sources': Lock Writes416I, [2024-07-31T10:29:25.413711 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}417I, [2024-07-31T10:29:25.414487 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}418I, [2024-07-31T10:29:36.924161 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes419I, [2024-07-31T10:29:43.626005 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes420# [RSpecRunTime] Finishing example group spec/migrations/20230831084632_queue_sync_scan_result_policies_spec.rb. It took 2 minutes 51.46 seconds. Expected to take 1 minute 32.58 seconds.421# [RSpecRunTime] RSpec elapsed time: 11 minutes 18.21 seconds. Current RSS: ~1360M. Threads: 2. load average: 0.88 1.05 1.10 1/265 412422.423# [RSpecRunTime] Starting example group spec/migrations/20240222214106_set_default_organization_visibility_to_public_spec.rb. Expected to take 1 minute 12.74 seconds.424SetDefaultOrganizationVisibilityToPublic425 #down426 when default organization exists427main: == [advisory_lock_connection] object_id: 187289260, pg_backend_pid: 3120428main: == 20240222214106 SetDefaultOrganizationVisibilityToPublic: migrating =========429main: == 20240222214106 SetDefaultOrganizationVisibilityToPublic: migrated (0.0175s) 430main: == [advisory_lock_connection] object_id: 187289260, pg_backend_pid: 3120431 updates only the default organization visibility_level to private432# [RSpecRunTime] RSpec elapsed time: 12 minutes 9.18 seconds. Current RSS: ~1382M. Threads: 2. load average: 0.96 1.04 1.10 1/265 413433.434 when default organization does not exist435 does not error436# [RSpecRunTime] RSpec elapsed time: 12 minutes 17.25 seconds. Current RSS: ~1404M. Threads: 2. load average: 0.97 1.04 1.09 1/265 414437.438 #up439 when default organization exists440main: == [advisory_lock_connection] object_id: 189290560, pg_backend_pid: 3125441main: == 20240222214106 SetDefaultOrganizationVisibilityToPublic: migrating =========442main: == 20240222214106 SetDefaultOrganizationVisibilityToPublic: migrated (0.0154s) 443main: == [advisory_lock_connection] object_id: 189290560, pg_backend_pid: 3125444 updates only the default organization visibility_level to public445# [RSpecRunTime] RSpec elapsed time: 12 minutes 23.47 seconds. Current RSS: ~1422M. Threads: 2. load average: 0.97 1.04 1.09 1/265 415446.447 when default organization does not exist448main: == [advisory_lock_connection] object_id: 189915940, pg_backend_pid: 3128449main: == 20240222214106 SetDefaultOrganizationVisibilityToPublic: migrating =========450main: == 20240222214106 SetDefaultOrganizationVisibilityToPublic: migrated (0.0496s) 451main: == [advisory_lock_connection] object_id: 189915940, pg_backend_pid: 3128452 does not error453# [RSpecRunTime] RSpec elapsed time: 12 minutes 30.65 seconds. Current RSS: ~1467M. Threads: 2. load average: 0.97 1.04 1.09 1/265 416454.455I, [2024-07-31T10:31:08.604966 #326] INFO -- : Database: 'main', Table: 'p_ci_build_names': Lock Writes456I, [2024-07-31T10:31:14.992313 #326] INFO -- : Database: 'main', Table: 'p_ci_builds_execution_configs': Lock Writes457I, [2024-07-31T10:31:28.746960 #326] INFO -- : Database: 'main', Table: 'p_ci_build_sources': Lock Writes458I, [2024-07-31T10:31:28.748191 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}459I, [2024-07-31T10:31:28.748953 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}460I, [2024-07-31T10:31:39.916445 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes461I, [2024-07-31T10:31:46.294574 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes462# [RSpecRunTime] Finishing example group spec/migrations/20240222214106_set_default_organization_visibility_to_public_spec.rb. It took 2 minutes 2.51 seconds. Expected to take 1 minute 12.74 seconds.463# [RSpecRunTime] RSpec elapsed time: 13 minutes 20.78 seconds. Current RSS: ~1379M. Threads: 2. load average: 0.92 1.01 1.08 1/265 417464.465# [RSpecRunTime] Starting example group spec/migrations/20231207194620_backfill_catalog_resources_visibility_level_spec.rb. Expected to take 1 minute 10.6 seconds.466BackfillCatalogResourcesVisibilityLevel467 #up468main: == [advisory_lock_connection] object_id: 218272860, pg_backend_pid: 3142469main: == 20231207194620 BackfillCatalogResourcesVisibilityLevel: migrating ==========470main: -- execute(" UPDATE catalog_resources\n SET visibility_level = projects.visibility_level\n FROM projects\n WHERE catalog_resources.project_id = projects.id\n")471main: -> 0.0024s472main: == 20231207194620 BackfillCatalogResourcesVisibilityLevel: migrated (0.0112s) =473main: == [advisory_lock_connection] object_id: 218272860, pg_backend_pid: 3142474 updates the visibility_level to match the project475# [RSpecRunTime] RSpec elapsed time: 14 minutes 24.35 seconds. Current RSS: ~1395M. Threads: 2. load average: 1.45 1.14 1.12 1/265 418476.477I, [2024-07-31T10:33:07.040671 #326] INFO -- : Database: 'main', Table: 'ci_job_token_group_scope_links': Lock Writes478INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree479INFO: analyzing "public.ci_pipeline_variables"480INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows481I, [2024-07-31T10:33:08.647179 #326] INFO -- : Database: 'main', Table: 'p_ci_pipeline_variables': Lock Writes482I, [2024-07-31T10:33:08.648403 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}483I, [2024-07-31T10:33:08.649239 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}484INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree485INFO: analyzing "public.ci_pipeline_variables"486INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows487INFO: analyzing "public.p_ci_job_artifacts" inheritance tree488INFO: analyzing "public.ci_job_artifacts"489INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows490I, [2024-07-31T10:33:14.573713 #326] INFO -- : Database: 'main', Table: 'p_ci_job_artifacts': Lock Writes491I, [2024-07-31T10:33:14.574846 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}492I, [2024-07-31T10:33:14.575680 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}493INFO: analyzing "public.p_ci_stages" inheritance tree494INFO: analyzing "public.ci_stages"495INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows496I, [2024-07-31T10:33:17.929107 #326] INFO -- : Database: 'main', Table: 'p_ci_stages': Lock Writes497I, [2024-07-31T10:33:17.930211 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}498I, [2024-07-31T10:33:17.931024 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}499I, [2024-07-31T10:33:19.053284 #326] INFO -- : Database: 'main', Table: 'p_ci_build_names': Lock Writes500I, [2024-07-31T10:33:25.206167 #326] INFO -- : Database: 'main', Table: 'p_ci_builds_execution_configs': Lock Writes501I, [2024-07-31T10:33:38.457884 #326] INFO -- : Database: 'main', Table: 'p_ci_build_sources': Lock Writes502I, [2024-07-31T10:33:38.459021 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}503I, [2024-07-31T10:33:38.459782 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}504I, [2024-07-31T10:33:49.517137 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes505I, [2024-07-31T10:33:55.877780 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes506# [RSpecRunTime] Finishing example group spec/migrations/20231207194620_backfill_catalog_resources_visibility_level_spec.rb. It took 2 minutes 9.63 seconds. Expected to take 1 minute 10.6 seconds.507# [RSpecRunTime] RSpec elapsed time: 15 minutes 30.47 seconds. Current RSS: ~1376M. Threads: 2. load average: 1.04 1.08 1.10 1/263 419508.509# [RSpecRunTime] Starting example group spec/migrations/20240403121221_migrate_inputs_to_spec_on_catalog_resource_components_spec.rb. Expected to take 43.5 seconds.510MigrateInputsToSpecOnCatalogResourceComponents511main: == [advisory_lock_connection] object_id: 246115240, pg_backend_pid: 3157512main: == 20240403121221 MigrateInputsToSpecOnCatalogResourceComponents: migrating ===513main: -- execute("UPDATE catalog_resource_components\nSET spec = jsonb_set('{}'::jsonb, '{inputs}', inputs::jsonb)\nWHERE id BETWEEN 1 AND 3\nAND spec = '{}' AND inputs <> '{}'\n")514main: -> 0.0021s515main: == 20240403121221 MigrateInputsToSpecOnCatalogResourceComponents: migrated (0.0347s) 516main: == [advisory_lock_connection] object_id: 246115240, pg_backend_pid: 3157517 fills in the spec column for components with an inputs value and no spec value518I, [2024-07-31T10:34:51.628365 #326] INFO -- : Database: 'main', Table: 'p_ci_builds_execution_configs': Lock Writes519I, [2024-07-31T10:35:05.384469 #326] INFO -- : Database: 'main', Table: 'p_ci_build_sources': Lock Writes520I, [2024-07-31T10:35:05.385810 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}521I, [2024-07-31T10:35:05.386559 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}522I, [2024-07-31T10:35:16.743368 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes523I, [2024-07-31T10:35:23.299030 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes524# [RSpecRunTime] Finishing example group spec/migrations/20240403121221_migrate_inputs_to_spec_on_catalog_resource_components_spec.rb. It took 1 minute 27.35 seconds. Expected to take 43.5 seconds.525# [RSpecRunTime] RSpec elapsed time: 16 minutes 57.88 seconds. Current RSS: ~1359M. Threads: 2. load average: 1.01 1.06 1.09 1/263 420526.527# [RSpecRunTime] Starting example group spec/migrations/20240627122810_queue_queue_backfill_autocancel_partition_id_on_ci_pipelines_spec.rb. Expected to take 30.29 seconds.528QueueQueueBackfillAutocancelPartitionIdOnCiPipelines529ci: == [advisory_lock_connection] object_id: 263333660, pg_backend_pid: 3401530ci: == 20240627122810 QueueQueueBackfillAutocancelPartitionIdOnCiPipelines: migrating 531ci: == 20240627122810 QueueQueueBackfillAutocancelPartitionIdOnCiPipelines: migrated (0.0755s) 532ci: == [advisory_lock_connection] object_id: 263333660, pg_backend_pid: 3401533 schedules a new batched migration534 when executed on .com535ci: == [advisory_lock_connection] object_id: 264942660, pg_backend_pid: 3409536ci: == 20240627122810 QueueQueueBackfillAutocancelPartitionIdOnCiPipelines: migrating 537ci: == 20240627122810 QueueQueueBackfillAutocancelPartitionIdOnCiPipelines: migrated (0.0781s) 538ci: == [advisory_lock_connection] object_id: 264942660, pg_backend_pid: 3409539 schedules a new batched migration540# [RSpecRunTime] RSpec elapsed time: 17 minutes 26.33 seconds. Current RSS: ~1398M. Threads: 2. load average: 1.13 1.08 1.09 1/263 421541.542I, [2024-07-31T10:36:07.001484 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes543I, [2024-07-31T10:36:18.913404 #326] INFO -- : Database: 'ci', Table: 'approval_policy_rule_project_links': Lock Writes544I, [2024-07-31T10:36:19.347484 #326] INFO -- : Database: 'ci', Table: 'virtual_registries_packages_maven_cached_responses': Lock Writes545I, [2024-07-31T10:36:19.348714 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}546I, [2024-07-31T10:36:19.349471 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}547# [RSpecRunTime] Finishing example group spec/migrations/20240627122810_queue_queue_backfill_autocancel_partition_id_on_ci_pipelines_spec.rb. It took 53.02 seconds. Expected to take 30.29 seconds.548# [RSpecRunTime] RSpec elapsed time: 17 minutes 50.95 seconds. Current RSS: ~1357M. Threads: 2. load average: 1.01 1.06 1.08 1/263 422549.550# [RSpecRunTime] Starting example group spec/migrations/20240320193910_queue_backfill_epic_issues_into_work_item_parent_links_spec.rb. Expected to take 21.72 seconds.551QueueBackfillEpicIssuesIntoWorkItemParentLinks552main: == [advisory_lock_connection] object_id: 271568840, pg_backend_pid: 3653553main: == 20240522183910 QueueBackfillEpicIssuesIntoWorkItemParentLinks: migrating ===554main: == 20240522183910 QueueBackfillEpicIssuesIntoWorkItemParentLinks: migrated (0.0619s) 555main: == [advisory_lock_connection] object_id: 271568840, pg_backend_pid: 3653556 schedules a new batched migration557I, [2024-07-31T10:36:56.438456 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes558I, [2024-07-31T10:37:03.095929 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes559# [RSpecRunTime] Finishing example group spec/migrations/20240320193910_queue_backfill_epic_issues_into_work_item_parent_links_spec.rb. It took 46.69 seconds. Expected to take 21.72 seconds.560# [RSpecRunTime] RSpec elapsed time: 18 minutes 37.69 seconds. Current RSS: ~1342M. Threads: 2. load average: 1.04 1.06 1.09 2/263 423561.562# [RSpecRunTime] Starting example group spec/migrations/20240605113250_queue_backfill_project_relation_exports_project_id_spec.rb. Expected to take 19.27 seconds.563QueueBackfillProjectRelationExportsProjectId564main: == [advisory_lock_connection] object_id: 278515540, pg_backend_pid: 3665565main: == 20240605113250 QueueBackfillProjectRelationExportsProjectId: migrating =====566main: == 20240605113250 QueueBackfillProjectRelationExportsProjectId: migrated (0.0577s) 567main: == [advisory_lock_connection] object_id: 278515540, pg_backend_pid: 3665568 schedules a new batched migration569I, [2024-07-31T10:37:38.446128 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes570I, [2024-07-31T10:37:44.868440 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes571# [RSpecRunTime] Finishing example group spec/migrations/20240605113250_queue_backfill_project_relation_exports_project_id_spec.rb. It took 41.64 seconds. Expected to take 19.27 seconds.572# [RSpecRunTime] RSpec elapsed time: 19 minutes 19.39 seconds. Current RSS: ~1337M. Threads: 2. load average: 0.98 1.04 1.08 1/263 424573.574# [RSpecRunTime] Starting example group spec/migrations/re_add_tags_name_unique_index_spec.rb. Expected to take 17.7 seconds.575ReAddTagsNameUniqueIndex576 when the index does not exist577main: -- indexes(:tags)578main: -> 0.0050s579main: -- current_schema(nil)580main: -> 0.0009s581main: -- transaction_open?(nil)582main: -> 0.0002s583main: -- view_exists?(:postgres_partitions)584main: -> 0.0018s585main: -- index_exists?(:tags, :name, {:unique=>true, :name=>"index_tags_on_name", :algorithm=>:concurrently})586main: -> 0.0049s587main: -- add_index(:tags, :name, {:unique=>true, :name=>"index_tags_on_name", :algorithm=>:concurrently})588main: -> 0.0019s589main: -- indexes(:tags)590main: -> 0.0061s591 creates the index592# [RSpecRunTime] RSpec elapsed time: 19 minutes 32.16 seconds. Current RSS: ~1391M. Threads: 2. load average: 0.98 1.04 1.08 1/263 425593.594 when the index already exist595main: -- indexes(:tags)596main: -> 0.0070s597 does not do anything598# [RSpecRunTime] RSpec elapsed time: 19 minutes 36.5 seconds. Current RSS: ~1410M. Threads: 2. load average: 0.98 1.04 1.07 1/263 426599.600I, [2024-07-31T10:38:20.242192 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes601# [RSpecRunTime] Finishing example group spec/migrations/re_add_tags_name_unique_index_spec.rb. It took 35.34 seconds. Expected to take 17.7 seconds.602# [RSpecRunTime] RSpec elapsed time: 19 minutes 54.79 seconds. Current RSS: ~1340M. Threads: 2. load average: 0.99 1.03 1.07 1/263 427603.604# [RSpecRunTime] Starting example group spec/migrations/active_record/schema_spec.rb. Expected to take 8.83 seconds.605ActiveRecord::Schema606 > schema version should equal the latest migration timestamp stored in schema_migrations table607 the schema_migrations table contains all schema versions608# [RSpecRunTime] Finishing example group spec/migrations/active_record/schema_spec.rb. It took 16.39 seconds. Expected to take 8.83 seconds.609# [RSpecRunTime] RSpec elapsed time: 20 minutes 11.24 seconds. Current RSS: ~1380M. Threads: 2. load average: 1.13 1.06 1.08 1/263 428610.611# [RSpecRunTime] Starting example group spec/migrations/20240718085345_queue_delete_packages_composer_cache_file_records_spec.rb. Expected to take 5.51 seconds.612QueueDeletePackagesComposerCacheFileRecords613main: == [advisory_lock_connection] object_id: 288823080, pg_backend_pid: 3697614main: == 20240718085345 QueueDeletePackagesComposerCacheFileRecords: migrating ======615main: == 20240718085345 QueueDeletePackagesComposerCacheFileRecords: migrated (0.0654s) 616main: == [advisory_lock_connection] object_id: 288823080, pg_backend_pid: 3697617 schedules a new batched migration618# [RSpecRunTime] Finishing example group spec/migrations/20240718085345_queue_delete_packages_composer_cache_file_records_spec.rb. It took 13.87 seconds. Expected to take 5.51 seconds.619# [RSpecRunTime] RSpec elapsed time: 20 minutes 25.17 seconds. Current RSS: ~1380M. Threads: 2. load average: 1.18 1.07 1.09 1/263 429620.621auto_explain log contains 968 entries for main, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-5-26.326.main.ndjson.gz622took 29.475422743623auto_explain log contains 970 entries for ci, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-5-26.326.ci.ndjson.gz624took 25.790256561625[TEST PROF INFO] EventProf results for sql.active_record626Total time: 13:18.146 of 20:17.986 (65.53%)627Total events: 643981628Top 5 slowest suites (by time):629QueueBackfill...pelineChatData (./spec/migrations/20231218092401_queue_backfill_partition_id_ci_pipeline_chat_data_spec.rb:6) – 03:20.140 (173787 / 3) of 05:15.350 (63.47%)630EnsureIssueUs...ForSelfManaged (./spec/migrations/20230809203254_ensure_issue_user_mentions_bigint_backfill_is_finished_for_self_managed_spec.rb:6) – 02:04.589 (91308 / 2) of 03:04.158 (67.65%)631QueueSyncScanResultPolicies (./spec/migrations/20230831084632_queue_sync_scan_result_policies_spec.rb:6) – 01:58.998 (87332 / 1) of 02:51.523 (69.38%)632BackfillCatal...isibilityLevel (./spec/migrations/20231207194620_backfill_catalog_resources_visibility_level_spec.rb:6) – 01:33.345 (72109 / 1) of 02:09.686 (71.98%)633SetDefaultOrg...bilityToPublic (./spec/migrations/20240222214106_set_default_organization_visibility_to_public_spec.rb:6) – 01:15.797 (63515 / 4) of 02:02.571 (61.84%)634Knapsack report was generated. Preview:635{636 "spec/migrations/20231218092401_queue_backfill_partition_id_ci_pipeline_chat_data_spec.rb": 177.48624522399996,637 "spec/migrations/20230809203254_ensure_issue_user_mentions_bigint_backfill_is_finished_for_self_managed_spec.rb": 96.40878429399982,638 "spec/migrations/20230831084632_queue_sync_scan_result_policies_spec.rb": 87.81071578800038,639 "spec/migrations/20240222214106_set_default_organization_visibility_to_public_spec.rb": 72.58929476000003,640 "spec/migrations/20231207194620_backfill_catalog_resources_visibility_level_spec.rb": 63.7041273169998,641 "spec/migrations/20240403121221_migrate_inputs_to_spec_on_catalog_resource_components_spec.rb": 42.036208486000305,642 "spec/migrations/20240627122810_queue_queue_backfill_autocancel_partition_id_on_ci_pipelines_spec.rb": 28.588336619000074,643 "spec/migrations/20240320193910_queue_backfill_epic_issues_into_work_item_parent_links_spec.rb": 20.82516807799948,644 "spec/migrations/20240605113250_queue_backfill_project_relation_exports_project_id_spec.rb": 18.554376834999857,645 "spec/migrations/re_add_tags_name_unique_index_spec.rb": 17.244582489000095,646 "spec/migrations/active_record/schema_spec.rb": 8.812014444999477,647 "spec/migrations/20240718085345_queue_delete_packages_composer_cache_file_records_spec.rb": 5.742680045999805648}649Knapsack global time execution for tests: 10m 39s650Finished in 21 minutes 21 seconds (files took 2 minutes 12.7 seconds to load)65121 examples, 0 failures652Randomized with seed 64563653[TEST PROF INFO] Time spent in factories: 00:00.204 (0.02% of total time)654RSpec exited with 0.655No examples to retry, congrats!657Running after script...658$ source scripts/utils.sh659$ bundle exec gem list gitlab_quality-test_tooling660gitlab_quality-test_tooling (1.33.0)661$ section_start "failed-test-issues" "Report test failures" # collapsed multi-line command665$ section_start "flaky-test-issues" "Report test flakiness" # collapsed multi-line command668$ section_start "slow-test-issues" "Report test slowness" # collapsed multi-line command674$ section_start "slow-test-merge-request-report-note" "Report test slowness in MR note" # collapsed multi-line command677$ section_start "knapsack-report-issues" "Report test files close to timing out" # collapsed multi-line command681$ tooling/bin/push_job_metrics || true682[job-metrics] Pushing job metrics file for the CI/CD job.683[job-metrics] Pushed 4 CI job metric entries to InfluxDB.685Not uploading cache ruby-gems-debian-bookworm-ruby-3.1.5-17 due to policy687Uploading artifacts...688auto_explain/: found 3 matching artifact files and directories 689coverage/: found 5 matching artifact files and directories 690crystalball/: found 5 matching artifact files and directories 691WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 692knapsack/: found 4 matching artifact files and directories 693rspec/: found 12 matching artifact files and directories 694WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 695log/*.log: found 13 matching artifact files and directories 696WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/7471345400/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com697WARNING: Retrying... context=artifacts-uploader error=request redirected698Uploading artifacts as "archive" to coordinator... 201 Created id=7471345400 responseStatus=201 Created token=glcbt-66699Uploading artifacts...700rspec/rspec-*.xml: found 1 matching artifact files and directories 701WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/7471345400/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com702WARNING: Retrying... context=artifacts-uploader error=request redirected703Uploading artifacts as "junit" to coordinator... 201 Created id=7471345400 responseStatus=201 Created token=glcbt-66705Job succeeded