Skip to content
Snippets Groups Projects

rspec background_migration pg14 4/4

Passed Started by
Lukas Eipert
@leipert
1Running with gitlab-runner 16.1.0~beta.59.g83c66823 (83c66823)
2 on green-1.private.runners-manager.gitlab.com/gitlab.com/gitlab-org 4bq1s9yM, system ID: s_9d15f3e4e7ae
3 feature flags: FF_NETWORK_PER_BUILD:true, FF_USE_FASTZIP:true, FF_USE_IMPROVED_URL_MASKING:true
4 Resolving secrets 00:00
5 Preparing the "docker+machine" executor 00:17
6Using Docker executor with image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.20-rust-1.65-node-18.16-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-113-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:2e09e9db92541ed81b1c00f1d5186f8c262d8b84e8d1755676ea4b25614f30c4 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:afc7bd7a60824044709543a6a700385e412d750d9ab4fc72b427e335e1d0f3ec ...
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:a9a90ece30d9630d694ab1997cd103ea8ec729789451b983a75c7b58b0062d45 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:7ef36177d5d0bc554fbb63d8210ae751bcc538bea7905b51d078d9ab90a755fa ...
17Starting service redis:6.2-alpine ...
18Pulling docker image redis:6.2-alpine ...
19Using docker image sha256:b9cad9a5aff99063a48d14d26e9f31dcf1768b8e65c4687a8e3bc995c02749f3 for redis:6.2-alpine with digest redis@sha256:70a7a5b641117670beae0d80658430853896b5ef269ccf00d1827427e3263fa3 ...
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-bullseye-ruby-3.0.patched-golang-1.20-rust-1.65-node-18.16-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-113-yarn-1.22-graphicsmagick-1.3.36 ...
23Using docker image sha256:f47b23bf3b9e02a2837ddb6fe9a0b728c270e7a7d815dc582fd17281be34f20d for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.20-rust-1.65-node-18.16-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-113-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.20-rust-1.65-node-18.16-postgresql-14@sha256:4db9bc427d7eb1bd075d76b4e5e3e59eb0d96c2e788e6275e628f0026dd30039 ...
24 Preparing environment 00:00
25Running on runner-4bq1s9ym-project-278964-concurrent-0 via runner-4bq1s9ym-private-1687788789-6eb9d4b2...
26 Getting source from Git repository 00:27
27Fetching changes with git depth set to 20...
28Initialized empty Git repository in /builds/gitlab-org/gitlab/.git/
29Created fresh repository.
30remote: Enumerating objects: 126566, done.
31remote: Counting objects: 100% (126566/126566), done.
32remote: Compressing objects: 100% (87596/87596), done.
33remote: Total 126566 (delta 50477), reused 83712 (delta 34367), pack-reused 0
34Receiving objects: 100% (126566/126566), 114.65 MiB | 29.83 MiB/s, done.
35Resolving deltas: 100% (50477/50477), done.
36From https://git-us-east1-c.ci-gateway.int.gprd.gitlab.net:8989/gitlab-org/gitlab
37 * [new ref] refs/pipelines/912039887 -> refs/pipelines/912039887
38 * [new branch] master -> origin/master
39Checking out 04f47f21 as detached HEAD (ref is master)...
40Skipping Git submodules setup
41$ git remote set-url origin "${CI_REPOSITORY_URL}"
42 Restoring cache 00:16
43Checking cache for ruby-gems-debian-bullseye-ruby-3.0-16...
44Downloading cache.zip from https://storage.googleapis.com/gitlab-com-runners-cache/project/278964/ruby-gems-debian-bullseye-ruby-3.0-16
45Successfully extracted cache
46 Downloading artifacts 00:22
47Downloading artifacts for compile-test-assets (4541357536)...
48Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4541357536 responseStatus=200 OK token=64_F6Gcb
49Downloading artifacts for retrieve-tests-metadata (4541357542)...
50Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4541357542 responseStatus=200 OK token=64_F6Gcb
51Downloading artifacts for setup-test-env (4541357540)...
52Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4541357540 responseStatus=200 OK token=64_F6Gcb
53 Executing "step_script" stage of the job script 21:36
54Using docker image sha256:f47b23bf3b9e02a2837ddb6fe9a0b728c270e7a7d815dc582fd17281be34f20d for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.20-rust-1.65-node-18.16-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-113-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.20-rust-1.65-node-18.16-postgresql-14@sha256:4db9bc427d7eb1bd075d76b4e5e3e59eb0d96c2e788e6275e628f0026dd30039 ...
55$ echo $FOSS_ONLY
56$ [ "$FOSS_ONLY" = "1" ] && rm -rf ee/ qa/spec/ee/ qa/qa/specs/features/ee/ qa/qa/ee/ qa/qa/ee.rb
57$ export GOPATH=$CI_PROJECT_DIR/.go
58$ mkdir -p $GOPATH
59$ source scripts/utils.sh
60$ source scripts/prepare_build.sh
61 Installing gems 00:12
719Using decomposed database config (config/database.yml.decomposed-postgresql)
720Geo DB won't be set up.
721Embedding DB won't be set up.
722 Setting up DBs 00:47
733$ source ./scripts/rspec_helpers.sh
734$ run_timed_command "gem install knapsack --no-document"
735$ gem install knapsack --no-document
736Successfully installed knapsack-4.0.0
7371 gem installed
738==> 'gem install knapsack --no-document' succeeded in 1 seconds.
739$ echo -e "\e[0Ksection_start:`date +%s`:gitaly-test-spawn[collapsed=true]\r\e[0KStarting Gitaly"
740 Starting Gitaly 00:08
741$ section_start "gitaly-test-spawn" "Spawning Gitaly"; scripts/gitaly-test-spawn; section_end "gitaly-test-spawn"
742 Spawning Gitaly 00:08
746$ echo -e "\e[0Ksection_end:`date +%s`:gitaly-test-spawn\r\e[0K"
747$ rspec_paralellized_job "--fail-fast=${RSPEC_FAIL_FAST_THRESHOLD} --tag ~quarantine --tag ~zoekt"
748SKIP_FLAKY_TESTS_AUTOMATICALLY:
749RETRY_FAILED_TESTS_IN_NEW_PROCESS: true
750KNAPSACK_GENERATE_REPORT: true
751FLAKY_RSPEC_GENERATE_REPORT: true
752KNAPSACK_TEST_FILE_PATTERN: spec/{lib/gitlab/background_migration,lib/ee/gitlab/background_migration}{,/**/}*_spec.rb
753KNAPSACK_LOG_LEVEL: debug
754KNAPSACK_REPORT_PATH: knapsack/rspec_background_migration_pg14_4_4_report.json
755FLAKY_RSPEC_SUITE_REPORT_PATH: rspec/flaky/report-suite.json
756FLAKY_RSPEC_REPORT_PATH: rspec/flaky/all_rspec_background_migration_pg14_4_4_report.json
757NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_background_migration_pg14_4_4_report.json
758SKIPPED_TESTS_REPORT_PATH: rspec/skipped_tests_rspec_background_migration_pg14_4_4.txt
759CRYSTALBALL:
760RSPEC_TESTS_MAPPING_ENABLED:
761RSPEC_TESTS_FILTER_FILE:
762Knapsack report generator started!
763Run options: exclude {:quarantine=>true, :zoekt=>true}
764Test environment set up in 0.56662527 seconds
765Gitlab::BackgroundMigration::JobCoordinator
766 .for_tracking_database
767 returns an executor with the correct worker class and database
768 when an invalid value is given
769 raises an error
770 #queue
771 returns background migration worker queue
772 #with_shared_connection
773 yields to the block after properly configuring SharedModel
774 #pending_jobs
775 when there are enqueued jobs
776 does not include jobs for other workers
777 when not including dead jobs
778 includes current and future jobs
779 when including dead jobs
780 includes current and future jobs, and also dead and retry jobs
781 #steal
782 when there are enqueued jobs present
783 when queue contains unprocessed jobs
784 steals jobs from a queue
785 sets up the shared connection while stealing jobs
786 does not steal job that has already been taken
787 does not steal jobs for a different migration
788 when a custom predicate is given
789 steals jobs that match the predicate
790 does not steal jobs that do not match the predicate
791 when one of the jobs raises an error
792 enqueues the migration again and re-raises the error
793 when there are scheduled jobs present
794 steals all jobs from the scheduled sets
795 when there are enqueued and scheduled jobs present
796 steals from the scheduled sets queue first
797 when retry_dead_jobs is true
798 steals from the dead and retry queue
799 #perform
800 when the background migration does not inherit from BaseJob
801 performs a background migration with the configured shared connection
802 when the background migration inherits from BaseJob
803 passes the correct connection when constructing the migration
804 .remaining
805 when there are jobs remaining
806 returns the enqueued jobs plus the scheduled jobs
807 when there are no jobs remaining
808 returns zero
809 .exists?
810 when there are enqueued jobs present
811 returns true if specific job exists
812 returns false if specific job does not exist
813 when there are scheduled jobs present
814 returns true if specific job exists
815 returns false if specific job does not exist
816 .dead_jobs?
817 when there are dead jobs present
818 returns true if specific job exists
819 returns false if specific job does not exist
820 .retrying_jobs?
821 when there are dead jobs present
822 returns true if specific job exists
823 returns false if specific job does not exist
824Gitlab::BackgroundMigration::BackfillRootStorageStatisticsForkStorageSizes
825 # order random
826 #perform
827 updates the public_forks_storage_size
828 totals the size of public forks in the namespace
829 updates the internal_forks_storage_size
830 totals the size of internal forks in the namespace
831 updates the private_forks_storage_size
832 totals the size of private forks in the namespace
833 counts only the size of forks
834 sums forks for multiple namespaces
835 counts the size of forks in subgroups
836 counts the size of forks in more nested subgroups
837 counts forks of forks
838 counts multiple forks of the same project
839 updates a namespace with no forks
840 skips the update if the public_forks_storage_size has already been set
841 skips the update if the internal_forks_storage_size has already been set
842 skips the update if the private_forks_storage_size has already been set
843 skips the update if the namespace is not found
844I, [2023-06-26T14:28:32.592995 #327] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
845Gitlab::BackgroundMigration::BackfillIntegrationsEnableSslVerification
846 enables SSL verification for known-good hostnames
847 only updates records within the given ID range
848 marks the job as succeeded
849I, [2023-06-26T14:29:48.650069 #327] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
850I, [2023-06-26T14:29:54.866081 #327] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
851I, [2023-06-26T14:29:55.165206 #327] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
852I, [2023-06-26T14:30:07.618967 #327] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
853I, [2023-06-26T14:30:11.726933 #327] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
854I, [2023-06-26T14:30:11.728148 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
855I, [2023-06-26T14:30:11.729022 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
856I, [2023-06-26T14:30:25.443481 #327] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
857Gitlab::BackgroundMigration::BackfillTopicsTitle
858 correctly backfills the title of the topics
859I, [2023-06-26T14:31:38.035626 #327] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
860I, [2023-06-26T14:31:44.525409 #327] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
861I, [2023-06-26T14:31:44.785201 #327] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
862I, [2023-06-26T14:31:57.040150 #327] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
863I, [2023-06-26T14:32:01.215980 #327] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
864I, [2023-06-26T14:32:01.217244 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
865I, [2023-06-26T14:32:01.218150 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
866I, [2023-06-26T14:32:15.384570 #327] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
867Gitlab::BackgroundMigration::CleanupOrphanedRoutes
868 cleans orphaned routes
869 tracks timings of queries
870I, [2023-06-26T14:33:24.361568 #327] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
871I, [2023-06-26T14:33:30.995947 #327] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
872I, [2023-06-26T14:33:31.241197 #327] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
873I, [2023-06-26T14:33:44.067991 #327] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
874I, [2023-06-26T14:33:47.471186 #327] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
875I, [2023-06-26T14:33:47.472283 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
876I, [2023-06-26T14:33:47.473059 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
877I, [2023-06-26T14:34:02.322986 #327] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
878Gitlab::BackgroundMigration::BackfillInternalOnNotes
879 # order random
880 #perform
881 backfills internal column on notes when confidential
882I, [2023-06-26T14:34:56.374094 #327] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
883I, [2023-06-26T14:35:02.869802 #327] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
884I, [2023-06-26T14:35:03.102467 #327] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
885I, [2023-06-26T14:35:15.473018 #327] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
886I, [2023-06-26T14:35:18.831414 #327] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
887I, [2023-06-26T14:35:18.832753 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
888I, [2023-06-26T14:35:18.833630 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
889I, [2023-06-26T14:35:33.811430 #327] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
890Gitlab::BackgroundMigration::DisableLegacyOpenSourceLicenseForNoIssuesNoRepoProjects
891 sets `legacy_open_source_license_available` to false only for public projects with no issues and no repo
892I, [2023-06-26T14:36:34.740953 #327] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
893I, [2023-06-26T14:36:41.543638 #327] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
894I, [2023-06-26T14:36:41.806968 #327] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
895I, [2023-06-26T14:36:53.619878 #327] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
896I, [2023-06-26T14:36:58.100018 #327] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
897I, [2023-06-26T14:36:58.101261 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
898I, [2023-06-26T14:36:58.102137 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
899I, [2023-06-26T14:37:13.430621 #327] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
900Gitlab::BackgroundMigration::DisableLegacyOpenSourceLicenseForProjectsLessThanFiveMb
901 # order random
902 sets `legacy_open_source_license_available` to false only for projects less than 5 MiB
903I, [2023-06-26T14:38:06.044420 #327] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
904I, [2023-06-26T14:38:12.743154 #327] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
905I, [2023-06-26T14:38:13.001147 #327] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
906I, [2023-06-26T14:38:24.706287 #327] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
907I, [2023-06-26T14:38:29.049668 #327] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
908I, [2023-06-26T14:38:29.050925 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
909I, [2023-06-26T14:38:29.051822 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
910I, [2023-06-26T14:38:44.925719 #327] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
911Gitlab::BackgroundMigration::BackfillProjectRepositories
912 Gitlab::BackgroundMigration::BackfillProjectRepositories::ShardFinder
913 #find_shard_id
914 creates a new shard when it does not exist yet
915 returns the shard when it exists
916 only queries the database once to retrieve shards
917 Gitlab::BackgroundMigration::BackfillProjectRepositories::Project
918 .on_hashed_storage
919 finds projects with repository on hashed storage
920 .on_legacy_storage
921 finds projects with repository on legacy storage
922 .without_project_repository
923 finds projects which do not have a projects_repositories entry
924 #disk_path
925 for projects on hashed storage
926 returns the correct disk_path
927 for projects on legacy storage
928 returns the correct disk_path
929 returns the correct disk_path using the route entry
930 raises OrphanedNamespaceError when any parent namespace does not exist
931The application_settings (main) table has 1281 columns.
932Recreating the database
933Dropped database 'gitlabhq_test'
934Dropped database 'gitlabhq_test_ci'
935Created database 'gitlabhq_test'
936Created database 'gitlabhq_test_ci'
937main: == [advisory_lock_connection] object_id: 172796900, pg_backend_pid: 310
938main: == [advisory_lock_connection] object_id: 172796900, pg_backend_pid: 310
939ci: == [advisory_lock_connection] object_id: 172843620, pg_backend_pid: 312
940ci: == [advisory_lock_connection] object_id: 172843620, pg_backend_pid: 312
941Databases re-creation done in 10.347045827999864
942Gitlab::BackgroundMigration::BackfillAdminModeScopeForPersonalAccessTokens
943 # order random
944 adds `admin_mode` scope to active personal access tokens of administrators
945I, [2023-06-26T14:40:18.878455 #327] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
946I, [2023-06-26T14:40:19.161750 #327] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
947I, [2023-06-26T14:40:30.716999 #327] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
948I, [2023-06-26T14:40:34.877603 #327] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
949I, [2023-06-26T14:40:34.878870 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
950I, [2023-06-26T14:40:34.879720 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
951I, [2023-06-26T14:40:48.520499 #327] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
952Gitlab::BackgroundMigration::DeleteOrphanedPackagesDependencies
953 # order random
954 executes 3 queries
955 deletes only orphaned dependencies
956I, [2023-06-26T14:41:33.170515 #327] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
957I, [2023-06-26T14:41:37.498202 #327] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
958I, [2023-06-26T14:41:37.499370 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
959I, [2023-06-26T14:41:37.500144 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
960I, [2023-06-26T14:41:51.041788 #327] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
961Gitlab::BackgroundMigration::BackfillProjectWikiRepositories
962 # order random
963 #perform
964 creates project_wiki_repositories entries for all projects in range
965 does nothing if project_id already exist in project_wiki_repositories
966I, [2023-06-26T14:42:34.335621 #327] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
967I, [2023-06-26T14:42:38.794015 #327] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
968I, [2023-06-26T14:42:38.795514 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
969I, [2023-06-26T14:42:38.796374 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
970I, [2023-06-26T14:42:52.605223 #327] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
971Gitlab::BackgroundMigration::MigrateHumanUserType
972 # order random
973 perform
974 updates user with `nil` user type only
975I, [2023-06-26T14:43:30.347019 #327] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
976I, [2023-06-26T14:43:33.611318 #327] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
977I, [2023-06-26T14:43:33.612638 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
978I, [2023-06-26T14:43:33.613434 #327] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
979I, [2023-06-26T14:43:47.856295 #327] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
980Gitlab::BackgroundMigration::BackfillCodeSuggestionsNamespaceSettings
981 # order random
982 updates the code suggestions values only for group and user namespace
983I, [2023-06-26T14:44:25.139394 #327] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
984Gitlab::BackgroundMigration::BatchingStrategies::LooseIndexScanBatchingStrategy#next_batch
985 is expected to be < Gitlab::BackgroundMigration::BatchingStrategies::BaseStrategy
986 when starting on the first batch
987 returns the bounds of the next batch
988 when additional batches remain
989 returns the bounds of the next batch
990 when on the final batch
991 returns the bounds of the next batch
992 when no additional batches remain
993 returns nil
994Gitlab::BackgroundMigration::ResetStatusOnContainerRepositories
995 # order random
996 #perform
997 resets status of container repositories with tags
998 with the registry disabled
999 behaves like resetting status of all container repositories scheduled for deletion
1000 resets all statuses
1001 with the registry api url not defined
1002 behaves like resetting status of all container repositories scheduled for deletion
1003 resets all statuses
1004 with a faraday error
1005 behaves like resetting status of all container repositories scheduled for deletion
1006 resets all statuses
1007 #filter_batch
1008 scopes the relation to delete scheduled container repositories
1009Gitlab::BackgroundMigration::BackfillPartitionedTable
1010 # order random
1011 #perform
1012 without the destination table
1013 raises an exception
1014 with destination table being not partitioned
1015 raises an exception
1016 when the destination table exists
1017WARNING: Active Record does not support composite primary key.
1018_test_source_table_partitioned has composite primary key. Composite primary key is ignored.
1019 copies data into the destination table idempotently
1020 breaks the assigned batch into smaller sub batches
1021Gitlab::BackgroundMigration::PruneStaleProjectExportJobs
1022 # order random
1023 removes export jobs and associated relations older than 7 days
1024Gitlab::BackgroundMigration::IssuesInternalIdScopeUpdater
1025 # order random
1026 backfills internal_ids records and removes related project records
1027Gitlab::BackgroundMigration::EncryptCiTriggerToken
1028 # order random
1029 ensures all unencrypted tokens are encrypted
1030Gitlab::BackgroundMigration::UpdateJiraTrackerDataDeploymentTypeBasedOnUrl
1031 changes unknown deployment_types based on URL
1032Gitlab::BackgroundMigration::BatchingStrategies::BackfillProjectStatisticsWithContainerRegistrySizeBatchingStrategy
1033 is expected to be < Gitlab::BackgroundMigration::BatchingStrategies::PrimaryKeyBatchingStrategy
1034Knapsack report was generated. Preview:
1035{
1036 "spec/lib/gitlab/background_migration/job_coordinator_spec.rb": 46.873939157999985,
1037 "spec/lib/gitlab/background_migration/backfill_root_storage_statistics_fork_storage_sizes_spec.rb": 44.111516252,
1038 "spec/lib/gitlab/background_migration/backfill_integrations_enable_ssl_verification_spec.rb": 50.39203611700009,
1039 "spec/lib/gitlab/background_migration/backfill_topics_title_spec.rb": 45.994663898,
1040 "spec/lib/gitlab/background_migration/cleanup_orphaned_routes_spec.rb": 44.599690177000184,
1041 "spec/lib/gitlab/background_migration/backfill_internal_on_notes_spec.rb": 37.64845204400012,
1042 "spec/lib/gitlab/background_migration/disable_legacy_open_source_license_for_no_issues_no_repo_projects_spec.rb": 40.351076608000085,
1043 "spec/lib/gitlab/background_migration/disable_legacy_open_source_license_for_projects_less_than_five_mb_spec.rb": 37.54933033900011,
1044 "spec/lib/gitlab/background_migration/backfill_project_repositories_spec.rb": 37.51238513299995,
1045 "spec/lib/gitlab/background_migration/backfill_admin_mode_scope_for_personal_access_tokens_spec.rb": 31.89886333100003,
1046 "spec/lib/gitlab/background_migration/delete_orphaned_packages_dependencies_spec.rb": 27.27846460899991,
1047 "spec/lib/gitlab/background_migration/backfill_project_wiki_repositories_spec.rb": 26.554602667999916,
1048 "spec/lib/gitlab/background_migration/migrate_human_user_type_spec.rb": 23.254892575999975,
1049 "spec/lib/gitlab/background_migration/backfill_code_suggestions_namespace_settings_spec.rb": 16.615816603999974,
1050 "spec/lib/gitlab/background_migration/batching_strategies/loose_index_scan_batching_strategy_spec.rb": 10.335520087000077,
1051 "spec/lib/gitlab/background_migration/reset_status_on_container_repositories_spec.rb": 10.985315541000091,
1052 "spec/lib/gitlab/background_migration/backfill_partitioned_table_spec.rb": 7.775082754999858,
1053 "spec/lib/gitlab/background_migration/prune_stale_project_export_jobs_spec.rb": 2.292407513999933,
1054 "spec/lib/gitlab/background_migration/issues_internal_id_scope_updater_spec.rb": 2.2582706260000123,
1055 "spec/lib/gitlab/background_migration/encrypt_ci_trigger_token_spec.rb": 2.0806700880000335,
1056 "spec/lib/gitlab/background_migration/update_jira_tracker_data_deployment_type_based_on_url_spec.rb": 2.1042147260000093,
1057 "spec/lib/gitlab/background_migration/batching_strategies/backfill_project_statistics_with_container_registry_size_batching_strategy_spec.rb": 1.979056423999964
1058}
1059Knapsack global time execution for tests: 09m 10s
1060Finished in 19 minutes 9 seconds (files took 1 minute 7.76 seconds to load)
106191 examples, 0 failures
1062Randomized with seed 61234
1063[TEST PROF INFO] Time spent in factories: 00:20.751 (1.76% of total time)
1064RSpec exited with 0.
1065No examples to retry, congrats!
1066 Running after_script 00:03
1067Running after script...
1068$ echo -e "\e[0Ksection_start:`date +%s`:report_results_section[collapsed=true]\r\e[0KReport results"
1069 Report results 00:03
1074 Saving cache for successful job 00:01
1075Not uploading cache ruby-gems-debian-bullseye-ruby-3.0-16 due to policy
1076 Uploading artifacts for successful job 00:04
1077Uploading artifacts...
1078coverage/: found 5 matching artifact files and directories
1079WARNING: crystalball/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1080WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1081knapsack/: found 4 matching artifact files and directories
1082query_recorder/: found 2 matching artifact files and directories
1083rspec/: found 10 matching artifact files and directories
1084WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1085log/*.log: found 13 matching artifact files and directories
1086WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/4541357724/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com
1087WARNING: Retrying... context=artifacts-uploader error=request redirected
1088Uploading artifacts as "archive" to coordinator... 201 Created id=4541357724 responseStatus=201 Created token=64_F6Gcb
1089Uploading artifacts...
1090rspec/rspec-*.xml: found 1 matching artifact files and directories
1091WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/4541357724/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com
1092WARNING: Retrying... context=artifacts-uploader error=request redirected
1093Uploading artifacts as "junit" to coordinator... 201 Created id=4541357724 responseStatus=201 Created token=64_F6Gcb
1094 Cleaning up project directory and file based variables 00:00
1095Job succeeded