rspec migration pg13 single-db 5/8
Passed Started
by
@fabiopitino
Fabio Pitino
1Running with gitlab-runner 16.1.0~beta.5.gf131a6a2 (f131a6a2)2 on blue-5.private.runners-manager.gitlab.com/gitlab.com/gitlab-org PYwgZLQB, system ID: s_4bff81aff7f73 feature flags: FF_NETWORK_PER_BUILD:true, FF_USE_FASTZIP:true, FF_USE_IMPROVED_URL_MASKING:true6Using Docker executor with image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.19-rust-1.65-node-18.16-postgresql-13: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-13-pgvector-0.4.1 ...8Authenticating with credentials from job payload (GitLab Registry)9Pulling docker image registry.gitlab.com/gitlab-org/gitlab-build-images:postgres-13-pgvector-0.4.1 ...10Using docker image sha256:73740c557807c4bc5d692f263c0e35454270600da4b22bbe952331411426c8b5 for registry.gitlab.com/gitlab-org/gitlab-build-images:postgres-13-pgvector-0.4.1 with digest registry.gitlab.com/gitlab-org/gitlab-build-images@sha256:3174001f839c42e299ac06a42f8ded446edfcb33b0eb820874749a3f53eb799c ...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:85fd7bd884b6493c8eb6f4dffbe5406d97cce56aff84f1580a5eb5b9d841f158 for redis:6.2-alpine with digest redis@sha256:87c44d5d9f472e767c8737f4130c765d77bdc95c7472d6427cfc9d4632f12da6 ...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.19-rust-1.65-node-18.16-postgresql-13:rubygems-3.4-git-2.36-lfs-2.9-chrome-113-yarn-1.22-graphicsmagick-1.3.36 ...23Using docker image sha256:61b59025d0d646cd177f654d8f81df859675be528f37dcc2ce6f39a49c7a5dd9 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.19-rust-1.65-node-18.16-postgresql-13: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.19-rust-1.65-node-18.16-postgresql-13@sha256:25367d41b1034f1ecacfc9cb8eebc70cb30c6fdade3781cf295488255bf61614 ...25Running on runner-pywgzlqb-project-278964-concurrent-0 via runner-pywgzlqb-private-1685686453-f66fd810...27Fetching changes with git depth set to 20...28Initialized empty Git repository in /builds/gitlab-org/gitlab/.git/29Created fresh repository.30remote: Enumerating objects: 139970, done. 31remote: Counting objects: 100% (139970/139970), done. 32remote: Compressing objects: 100% (94736/94736), done. 33remote: Total 139970 (delta 61223), reused 92025 (delta 39894), pack-reused 0 34Receiving objects: 100% (139970/139970), 123.36 MiB | 30.92 MiB/s, done.35Resolving deltas: 100% (61223/61223), done.37 * [new ref] refs/pipelines/887306308 -> refs/pipelines/88730630838Checking out 95754c79 as detached HEAD (ref is refs/merge-requests/122015/merge)...39Skipping Git submodules setup40$ git remote set-url origin "${CI_REPOSITORY_URL}"42Checking cache for ruby-gems-debian-bullseye-ruby-3.0-16...43Downloading cache.zip from https://storage.googleapis.com/gitlab-com-runners-cache/project/278964/ruby-gems-debian-bullseye-ruby-3.0-16 44Successfully extracted cache46Downloading artifacts for compile-test-assets (4400964016)...47Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4400964016 responseStatus=200 OK token=64_2X3wy48Downloading artifacts for detect-tests (4400964025)...49Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4400964025 responseStatus=200 OK token=64_2X3wy50Downloading artifacts for retrieve-tests-metadata (4400964028)...51Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4400964028 responseStatus=200 OK token=64_2X3wy52Downloading artifacts for setup-test-env (4400964019)...53Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4400964019 responseStatus=200 OK token=64_2X3wy55Using docker image sha256:61b59025d0d646cd177f654d8f81df859675be528f37dcc2ce6f39a49c7a5dd9 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.19-rust-1.65-node-18.16-postgresql-13: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.19-rust-1.65-node-18.16-postgresql-13@sha256:25367d41b1034f1ecacfc9cb8eebc70cb30c6fdade3781cf295488255bf61614 ...56$ echo $FOSS_ONLY57$ [ "$FOSS_ONLY" = "1" ] && rm -rf ee/ qa/spec/ee/ qa/qa/specs/features/ee/ qa/qa/ee/ qa/qa/ee.rb58$ export GOPATH=$CI_PROJECT_DIR/.go59$ mkdir -p $GOPATH60$ source scripts/utils.sh61$ source scripts/prepare_build.sh716Using decomposed database config (config/database.yml.postgresql)717Disabling ci connection in config/database.yml718Geo DB won't be set up.719Embedding DB won't be set up.731$ source ./scripts/rspec_helpers.sh732$ run_timed_command "gem install knapsack --no-document"733$ gem install knapsack --no-document734Successfully installed knapsack-4.0.07351 gem installed736==> 'gem install knapsack --no-document' succeeded in 1 seconds.737$ echo -e "\e[0Ksection_start:`date +%s`:gitaly-test-spawn[collapsed=true]\r\e[0KStarting Gitaly"739$ section_start "gitaly-test-spawn" "Spawning Gitaly"; scripts/gitaly-test-spawn; section_end "gitaly-test-spawn"744$ echo -e "\e[0Ksection_end:`date +%s`:gitaly-test-spawn\r\e[0K"745$ rspec_paralellized_job "--tag ~quarantine --tag ~zoekt"746SKIP_FLAKY_TESTS_AUTOMATICALLY: 747RETRY_FAILED_TESTS_IN_NEW_PROCESS: true748KNAPSACK_GENERATE_REPORT: true749FLAKY_RSPEC_GENERATE_REPORT: true750KNAPSACK_TEST_FILE_PATTERN: spec/{migrations}{,/**/}*_spec.rb751KNAPSACK_LOG_LEVEL: debug752KNAPSACK_REPORT_PATH: knapsack/rspec_migration_pg13_single-db_5_8_report.json753FLAKY_RSPEC_SUITE_REPORT_PATH: rspec/flaky/report-suite.json754FLAKY_RSPEC_REPORT_PATH: rspec/flaky/all_rspec_migration_pg13_single-db_5_8_report.json755NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg13_single-db_5_8_report.json756SKIPPED_TESTS_REPORT_PATH: rspec/skipped_tests_rspec_migration_pg13_single-db_5_8.txt757CRYSTALBALL: 758RSPEC_TESTS_MAPPING_ENABLED: 759RSPEC_TESTS_FILTER_FILE: 760Knapsack report generator started!761warning: parser/current is loading parser/ruby30, which recognizes 3.0.5-compliant syntax, but you are running 3.0.6.763Run options: exclude {:quarantine=>true, :zoekt=>true}764Test environment set up in 1.375945127 seconds765FixPartitionIdsForCiBuildMetadata766 # order random767 when on saas768 #up769main: == [advisory_lock_connection] object_id: 3454340, pg_backend_pid: 111770main: == 20230209140102 FixPartitionIdsForCiBuildMetadata: migrating ================771main: == 20230209140102 FixPartitionIdsForCiBuildMetadata: migrated (0.0989s) =======772main: == [advisory_lock_connection] object_id: 3454340, pg_backend_pid: 111773 schedules background jobs for each batch of p_ci_builds_metadata774 #down775main: == [advisory_lock_connection] object_id: 3794040, pg_backend_pid: 113776main: == 20230209140102 FixPartitionIdsForCiBuildMetadata: migrating ================777main: == 20230209140102 FixPartitionIdsForCiBuildMetadata: migrated (0.0442s) =======778main: == [advisory_lock_connection] object_id: 3794040, pg_backend_pid: 113779 deletes all batched migration records780 when on self-managed instance781 #up782 does not schedule background job783 #down784 does not delete background job785FixPartitionIdsForCiBuildReportResult786 # order random787 when on self-managed instance788 #up789 does not schedule background job790 #down791 does not delete background job792 when on saas793 #up794main: == [advisory_lock_connection] object_id: 12888700, pg_backend_pid: 125795main: == 20230209090702 FixPartitionIdsForCiBuildReportResult: migrating ============796main: == 20230209090702 FixPartitionIdsForCiBuildReportResult: migrated (0.0464s) ===797main: == [advisory_lock_connection] object_id: 12888700, pg_backend_pid: 125798 schedules background jobs for each batch of ci_build_report_results799 #down800main: == [advisory_lock_connection] object_id: 13017680, pg_backend_pid: 127801main: == 20230209090702 FixPartitionIdsForCiBuildReportResult: migrating ============802main: == 20230209090702 FixPartitionIdsForCiBuildReportResult: migrated (0.0454s) ===803main: == [advisory_lock_connection] object_id: 13017680, pg_backend_pid: 127804 deletes all batched migration records805FinalizeEncryptCiTriggerToken806 # order random807 #up808 when migration is missing809main: == [advisory_lock_connection] object_id: 19293420, pg_backend_pid: 134810main: == 20230412214119 FinalizeEncryptCiTriggerToken: migrating ====================811main: == 20230412214119 FinalizeEncryptCiTriggerToken: migrated (0.0130s) ===========812main: == [advisory_lock_connection] object_id: 19293420, pg_backend_pid: 134813 warns migration not found814 with migration present815 when migration finished successfully816main: == [advisory_lock_connection] object_id: 19764120, pg_backend_pid: 136817main: == 20230412214119 FinalizeEncryptCiTriggerToken: migrating ====================818main: == 20230412214119 FinalizeEncryptCiTriggerToken: migrated (0.0247s) ===========819main: == [advisory_lock_connection] object_id: 19764120, pg_backend_pid: 136820 does not raise exception821 with different migration statuses822 status: 0, description: "paused"823main: == [advisory_lock_connection] object_id: 19926540, pg_backend_pid: 138824main: == 20230412214119 FinalizeEncryptCiTriggerToken: migrating ====================825main: == 20230412214119 FinalizeEncryptCiTriggerToken: migrated (0.1575s) ===========826main: == [advisory_lock_connection] object_id: 19926540, pg_backend_pid: 138827 finalizes the migration828 status: 1, description: "active"829main: == [advisory_lock_connection] object_id: 20096080, pg_backend_pid: 140830main: == 20230412214119 FinalizeEncryptCiTriggerToken: migrating ====================831main: == 20230412214119 FinalizeEncryptCiTriggerToken: migrated (0.1686s) ===========832main: == [advisory_lock_connection] object_id: 20096080, pg_backend_pid: 140833 finalizes the migration834 status: 4, description: "failed"835main: == [advisory_lock_connection] object_id: 20347700, pg_backend_pid: 142836main: == 20230412214119 FinalizeEncryptCiTriggerToken: migrating ====================837main: == 20230412214119 FinalizeEncryptCiTriggerToken: migrated (0.1596s) ===========838main: == [advisory_lock_connection] object_id: 20347700, pg_backend_pid: 142839 finalizes the migration840 status: 5, description: "finalizing"841main: == [advisory_lock_connection] object_id: 20604780, pg_backend_pid: 144842main: == 20230412214119 FinalizeEncryptCiTriggerToken: migrating ====================843main: == 20230412214119 FinalizeEncryptCiTriggerToken: migrated (0.1436s) ===========844main: == [advisory_lock_connection] object_id: 20604780, pg_backend_pid: 144845 finalizes the migration846DeleteMigrateSharedVulnerabilityScanners847 # order random848 #up849main: == [advisory_lock_connection] object_id: 29748040, pg_backend_pid: 151850main: == 20220919080303 DeleteMigrateSharedVulnerabilityScanners: migrating =========851main: == 20220919080303 DeleteMigrateSharedVulnerabilityScanners: migrated (0.0340s) 852main: == [advisory_lock_connection] object_id: 29748040, pg_backend_pid: 151853 deletes jobs854main: == [advisory_lock_connection] object_id: 30174600, pg_backend_pid: 153855main: == 20220919080303 DeleteMigrateSharedVulnerabilityScanners: migrating =========856main: == 20220919080303 DeleteMigrateSharedVulnerabilityScanners: migrated (0.0227s) 857main: == [advisory_lock_connection] object_id: 30174600, pg_backend_pid: 153858 deletes the migration859 when background migration does not exist860main: == [advisory_lock_connection] object_id: 30320100, pg_backend_pid: 155861main: == 20220919080303 DeleteMigrateSharedVulnerabilityScanners: migrating =========862main: == 20220919080303 DeleteMigrateSharedVulnerabilityScanners: migrated (0.0026s) 863main: == [advisory_lock_connection] object_id: 30320100, pg_backend_pid: 155864 does not delete jobs865main: == [advisory_lock_connection] object_id: 30476080, pg_backend_pid: 157866main: == 20220919080303 DeleteMigrateSharedVulnerabilityScanners: migrating =========867main: == 20220919080303 DeleteMigrateSharedVulnerabilityScanners: migrated (0.0028s) 868main: == [advisory_lock_connection] object_id: 30476080, pg_backend_pid: 157869 does not delete the migration870FinalizeBackfillEnvironmentTierMigration871 # order random872 #up873 when migration is missing874main: == [advisory_lock_connection] object_id: 43687220, pg_backend_pid: 164875main: == 20230201171450 FinalizeBackfillEnvironmentTierMigration: migrating =========876main: == 20230201171450 FinalizeBackfillEnvironmentTierMigration: migrated (0.0126s) 877main: == [advisory_lock_connection] object_id: 43687220, pg_backend_pid: 164878 warns migration not found879 with migration present880 when migration finished successfully881main: == [advisory_lock_connection] object_id: 43934920, pg_backend_pid: 166882main: == 20230201171450 FinalizeBackfillEnvironmentTierMigration: migrating =========883main: == 20230201171450 FinalizeBackfillEnvironmentTierMigration: migrated (0.0217s) 884main: == [advisory_lock_connection] object_id: 43934920, pg_backend_pid: 166885 does not raise exception886 with different migration statuses887 status: 0, description: "paused"888 behaves like finalizes the migration889 finalizes the migration890 status: 1, description: "active"891 behaves like finalizes the migration892 finalizes the migration893 status: 4, description: "failed"894 behaves like finalizes the migration895 finalizes the migration896 status: 5, description: "finalizing"897 behaves like finalizes the migration898 finalizes the migration899RecountEpicCacheCounts900 # order random901 #down902main: == [advisory_lock_connection] object_id: 55014460, pg_backend_pid: 177903main: == 20221107094359 RecountEpicCacheCounts: migrating ===========================904main: == 20221107094359 RecountEpicCacheCounts: migrated (0.0432s) ==================905main: == [advisory_lock_connection] object_id: 55014460, pg_backend_pid: 177906 deletes all batched migration records907 #up908main: == [advisory_lock_connection] object_id: 55623420, pg_backend_pid: 180909main: == 20221107094359 RecountEpicCacheCounts: migrating ===========================910main: == 20221107094359 RecountEpicCacheCounts: migrated (0.0389s) ==================911main: == [advisory_lock_connection] object_id: 55623420, pg_backend_pid: 180912 schedules a batched background migration913MigrateDailyRedisHllEventsToWeeklyAggregation914 # order random915main: == [advisory_lock_connection] object_id: 65987480, pg_backend_pid: 187916main: == 20230317004428 MigrateDailyRedisHllEventsToWeeklyAggregation: migrating ====917main: == 20230317004428 MigrateDailyRedisHllEventsToWeeklyAggregation: migrated (0.2311s) 918main: == [advisory_lock_connection] object_id: 65987480, pg_backend_pid: 187919 calls HLLRedisCounter.known_events to get list of events920 with weekly events921main: == [advisory_lock_connection] object_id: 66419420, pg_backend_pid: 189922main: == 20230317004428 MigrateDailyRedisHllEventsToWeeklyAggregation: migrating ====923main: == 20230317004428 MigrateDailyRedisHllEventsToWeeklyAggregation: migrated (0.0062s) 924main: == [advisory_lock_connection] object_id: 66419420, pg_backend_pid: 189925 does not migrate weekly events926 with daily events927main: == [advisory_lock_connection] object_id: 66554840, pg_backend_pid: 191928main: == 20230317004428 MigrateDailyRedisHllEventsToWeeklyAggregation: migrating ====929main: == 20230317004428 MigrateDailyRedisHllEventsToWeeklyAggregation: migrated (0.0092s) 930main: == [advisory_lock_connection] object_id: 66554840, pg_backend_pid: 191931 migrates with correct parameters932 #redis_key933 with daily aggregation934 returns correct key935 with weekly aggregation936 returns correct key937UpdateActiveBillableUsersIndex938 # order random939main: -- indexes("users")940main: -> 0.0278s941main: -- current_schema()942main: -> 0.0007s943main: -- indexes("users")944main: -> 0.0265s945main: == [advisory_lock_connection] object_id: 75292940, pg_backend_pid: 199946main: == 20221210154044 UpdateActiveBillableUsersIndex: migrating ===================947main: -- view_exists?(:postgres_partitions)948main: -> 0.0016s949main: -- index_exists?("users", [:id], {:where=>"((state)::text = 'active'::text) AND ((user_type IS NULL)\nOR (user_type = ANY (ARRAY[NULL::integer, 6, 4]))) AND ((user_type IS NULL)\nOR (user_type <> ALL ('{1,2,3,4,5,6,7,8,9,11}'::smallint[])))\n", :name=>"index_users_for_active_billable", :algorithm=>:concurrently})950main: -> 0.0278s951main: -- add_index("users", [:id], {:where=>"((state)::text = 'active'::text) AND ((user_type IS NULL)\nOR (user_type = ANY (ARRAY[NULL::integer, 6, 4]))) AND ((user_type IS NULL)\nOR (user_type <> ALL ('{1,2,3,4,5,6,7,8,9,11}'::smallint[])))\n", :name=>"index_users_for_active_billable", :algorithm=>:concurrently})952main: -> 0.0028s953main: -- view_exists?(:postgres_partitions)954main: -> 0.0015s955main: -- indexes("users")956main: -> 0.0289s957main: -- remove_index("users", {:algorithm=>:concurrently, :name=>"active_billable_users"})958main: -> 0.0019s959main: == 20221210154044 UpdateActiveBillableUsersIndex: migrated (0.0981s) ==========960main: == [advisory_lock_connection] object_id: 75292940, pg_backend_pid: 199961main: -- indexes("users")962main: -> 0.0291s963main: -- current_schema()964main: -> 0.0007s965main: -- indexes("users")966main: -> 0.0274s967main: -- indexes("users")968main: -> 0.0284s969main: -- current_schema()970main: -> 0.0008s971main: -- indexes("users")972main: -> 0.0268s973 correctly migrates up and down974ScheduleVulnerabilitiesFeedbackMigration4975 # order random976 #up977main: == [advisory_lock_connection] object_id: 86595920, pg_backend_pid: 207978main: == 20230209171547 ScheduleVulnerabilitiesFeedbackMigration4: migrating ========979main: == 20230209171547 ScheduleVulnerabilitiesFeedbackMigration4: migrated (0.0553s) 980main: == [advisory_lock_connection] object_id: 86595920, pg_backend_pid: 207981 schedules background jobs for each batch of Vulnerabilities::Feedback982 #down983main: == [advisory_lock_connection] object_id: 86941720, pg_backend_pid: 209984main: == 20230209171547 ScheduleVulnerabilitiesFeedbackMigration4: migrating ========985main: == 20230209171547 ScheduleVulnerabilitiesFeedbackMigration4: migrated (0.0564s) 986main: == [advisory_lock_connection] object_id: 86941720, pg_backend_pid: 209987 deletes all batched migration records988SwapMergeRequestUserMentionsNoteIdToBigint2989 # order random990 #up991 swaps the integer and bigint columns for GitLab.com, dev, or test992 is a no-op for other instances993main: == [advisory_lock_connection] object_id: 95210320, pg_backend_pid: 223994main: == 20230310020356 SwapMergeRequestUserMentionsNoteIdToBigint2: migrating ======995main: == 20230310020356 SwapMergeRequestUserMentionsNoteIdToBigint2: migrated (0.0066s) 996main: == [advisory_lock_connection] object_id: 95210320, pg_backend_pid: 223997 is a no-op if columns are already swapped998AddTmpPartialIndexOnVulnerabilityReportTypes999 # order random1000main: == [advisory_lock_connection] object_id: 102179580, pg_backend_pid: 2291001main: == 20230221093533 AddTmpPartialIndexOnVulnerabilityReportTypes: migrating =====1002main: -- index_exists?(:vulnerability_occurrences, :id, {:where=>"report_type IN (7, 99)", :name=>"tmp_idx_vulnerability_occurrences_on_id_where_report_type_7_99", :algorithm=>:concurrently})1003main: -> 0.0079s1004main: -- add_index_options(:vulnerability_occurrences, :id, {:where=>"report_type IN (7, 99)", :name=>"tmp_idx_vulnerability_occurrences_on_id_where_report_type_7_99", :algorithm=>:concurrently})1005main: -> 0.0001s1006main: == 20230221093533 AddTmpPartialIndexOnVulnerabilityReportTypes: migrated (0.0311s) 1007main: == [advisory_lock_connection] object_id: 102179580, pg_backend_pid: 2291008 schedules the index1009QueueBackfillResourceLinkEvents1010 # order random1011 #up1012 when system_note_metadata table has a row with targeted action values1013main: == [advisory_lock_connection] object_id: 108107780, pg_backend_pid: 2371014main: == 20230426085615 QueueBackfillResourceLinkEvents: migrating ==================1015main: == 20230426085615 QueueBackfillResourceLinkEvents: migrated (0.0517s) =========1016main: == [advisory_lock_connection] object_id: 108107780, pg_backend_pid: 2371017 schedules a new batched migration with the lowest system_note_metadat record id1018 when system_note_metadata table has a row with targeted action values1019main: == [advisory_lock_connection] object_id: 108404300, pg_backend_pid: 2401020main: == 20230426085615 QueueBackfillResourceLinkEvents: migrating ==================1021main: == 20230426085615 QueueBackfillResourceLinkEvents: migrated (0.0486s) =========1022main: == [advisory_lock_connection] object_id: 108404300, pg_backend_pid: 2401023 schedules a new batched migration with the lowest system_note_metadat record id1024 when system_note_metadata table does not ahve a row with the targeted action values1025main: == [advisory_lock_connection] object_id: 108680220, pg_backend_pid: 2431026main: == 20230426085615 QueueBackfillResourceLinkEvents: migrating ==================1027main: == 20230426085615 QueueBackfillResourceLinkEvents: migrated (0.0097s) =========1028main: == [advisory_lock_connection] object_id: 108680220, pg_backend_pid: 2431029 does not a new batched migration1030 #down1031main: == [advisory_lock_connection] object_id: 108923440, pg_backend_pid: 2461032main: == 20230426085615 QueueBackfillResourceLinkEvents: migrating ==================1033main: == 20230426085615 QueueBackfillResourceLinkEvents: migrated (0.0097s) =========1034main: == [advisory_lock_connection] object_id: 108923440, pg_backend_pid: 2461035 deletes all batched migration records1036The application_settings (main) table has 1234 columns.1037Recreating the database1038Dropped database 'gitlabhq_test'1039Created database 'gitlabhq_test'1040main: == [advisory_lock_connection] object_id: 109124400, pg_backend_pid: 2531041main: == [advisory_lock_connection] object_id: 109124400, pg_backend_pid: 2531042Databases re-creation done in 5.2828125959999851043QueueDeleteOrphanedPackagesDependencies1044 # order random1045main: == [advisory_lock_connection] object_id: 111953940, pg_backend_pid: 2581046main: == 20230303105806 QueueDeleteOrphanedPackagesDependencies: migrating ==========1047main: == 20230303105806 QueueDeleteOrphanedPackagesDependencies: migrated (0.0511s) =1048main: == [advisory_lock_connection] object_id: 111953940, pg_backend_pid: 2581049 schedules a new batched migration1050InsertDailyInvitesTrialPlanLimits1051 # order random1052 when on self-managed1053main: == [advisory_lock_connection] object_id: 118681900, pg_backend_pid: 2651054main: == 20230316093433 InsertDailyInvitesTrialPlanLimits: migrating ================1055main: == 20230316093433 InsertDailyInvitesTrialPlanLimits: migrated (0.0069s) =======1056main: == [advisory_lock_connection] object_id: 118681900, pg_backend_pid: 2651057 correctly migrates up and down1058 when on gitlab.com1059main: == [advisory_lock_connection] object_id: 119132080, pg_backend_pid: 2681060main: == 20230316093433 InsertDailyInvitesTrialPlanLimits: migrating ================1061main: -- quote_column_name("daily_invites")1062main: -> 0.0000s1063main: -- quote("premium_trial")1064main: -> 0.0000s1065main: -- quote(50)1066main: -> 0.0000s1067main: -- execute("INSERT INTO plan_limits (plan_id, \"daily_invites\")\nSELECT id, '50' FROM plans WHERE name = 'premium_trial' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"daily_invites\" = EXCLUDED.\"daily_invites\";\n")1068main: -> 0.0018s1069main: -- quote_column_name("daily_invites")1070main: -> 0.0000s1071main: -- quote("ultimate_trial")1072main: -> 0.0000s1073main: -- quote(50)1074main: -> 0.0000s1075main: -- execute("INSERT INTO plan_limits (plan_id, \"daily_invites\")\nSELECT id, '50' FROM plans WHERE name = 'ultimate_trial' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"daily_invites\" = EXCLUDED.\"daily_invites\";\n")1076main: -> 0.0015s1077main: == 20230316093433 InsertDailyInvitesTrialPlanLimits: migrated (0.0114s) =======1078main: == [advisory_lock_connection] object_id: 119132080, pg_backend_pid: 2681079 correctly migrates up and down1080BackfillMlCandidatesPackageId1081 # order random1082 #up1083main: -- execute(" UPDATE ml_candidates\n SET package_id = candidate_id_to_package_id.package_id\n FROM (SELECT id as package_id, TRIM(LEADING 'ml_candidates_' FROM name) as candidate_id\n FROM packages_packages\n WHERE name LIKE 'ml_candidate_%'\n and version = '-') AS candidate_id_to_package_id\n WHERE cast(ml_candidates.id as text) = candidate_id_to_package_id.candidate_id\n")1084main: -> 0.0022s1085main: -- execute(" UPDATE ml_candidates\n SET package_id = candidate_id_to_package_id.package_id\n FROM (SELECT id as package_id, TRIM(LEADING 'ml_candidates_' FROM name) as candidate_id\n FROM packages_packages\n WHERE name LIKE 'ml_candidate_%'\n and version = '-') AS candidate_id_to_package_id\n WHERE cast(ml_candidates.id as text) = candidate_id_to_package_id.candidate_id\n")1086main: -> 0.0017s1087 sets the correct package_ids with idempotency1088EnsureSuggestionsNoteIdBigintBackfillIsFinishedForGitlabDotCom1089 # order random1090 #up1091main: == [advisory_lock_connection] object_id: 131023580, pg_backend_pid: 2811092main: == 20230404023648 EnsureSuggestionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrating 1093main: == 20230404023648 EnsureSuggestionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0061s) 1094main: == [advisory_lock_connection] object_id: 131023580, pg_backend_pid: 2811095 ensures the migration is completed for GitLab.com, dev, or test1096main: == [advisory_lock_connection] object_id: 131414880, pg_backend_pid: 2831097main: == 20230404023648 EnsureSuggestionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrating 1098main: == 20230404023648 EnsureSuggestionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0063s) 1099main: == [advisory_lock_connection] object_id: 131414880, pg_backend_pid: 2831100 skips the check for other instances1101AddSecureflagTrainingProvider1102 # order random1103main: == [advisory_lock_connection] object_id: 136286300, pg_backend_pid: 2891104main: == 20230328030101 AddSecureflagTrainingProvider: migrating ====================1105main: == 20230328030101 AddSecureflagTrainingProvider: migrated (0.0282s) ===========1106main: == [advisory_lock_connection] object_id: 136286300, pg_backend_pid: 2891107 adds additional provider1108RequeueBackfillProjectWikiRepositories1109 # order random1110main: == [advisory_lock_connection] object_id: 141256500, pg_backend_pid: 2961111main: == 20230405200858 RequeueBackfillProjectWikiRepositories: migrating ===========1112main: == 20230405200858 RequeueBackfillProjectWikiRepositories: migrated (0.0511s) ==1113main: == [advisory_lock_connection] object_id: 141256500, pg_backend_pid: 2961114 schedules a new batched migration1115BackfillMlCandidatesProjectId1116 # order random1117 #up1118main: -- execute(" UPDATE ml_candidates\n SET project_id = temp.project_id\n FROM (\n SELECT ml_candidates.id AS id, ml_experiments.project_id AS project_id\n FROM ml_candidates INNER JOIN ml_experiments ON ml_candidates.experiment_id = ml_experiments.id\n ) AS temp\n WHERE ml_candidates.id = temp.id\n")1119main: -> 0.0022s1120main: -- execute(" UPDATE ml_candidates\n SET project_id = temp.project_id\n FROM (\n SELECT ml_candidates.id AS id, ml_experiments.project_id AS project_id\n FROM ml_candidates INNER JOIN ml_experiments ON ml_candidates.experiment_id = ml_experiments.id\n ) AS temp\n WHERE ml_candidates.id = temp.id\n")1121main: -> 0.0016s1122 sets the correct project_id with idempotency1123AddPackageIdCreatedAtDescIndexToPackageFiles1124 # order random1125main: == [advisory_lock_connection] object_id: 151996020, pg_backend_pid: 3081126main: == 20230321153035 AddPackageIdCreatedAtDescIndexToPackageFiles: migrating =====1127main: -- view_exists?(:postgres_partitions)1128main: -> 0.0014s1129main: -- index_exists?(:packages_package_files, "package_id, created_at DESC", {:name=>"index_packages_package_files_on_package_id_and_created_at_desc", :algorithm=>:concurrently})1130main: -> 0.0141s1131main: -- add_index(:packages_package_files, "package_id, created_at DESC", {:name=>"index_packages_package_files_on_package_id_and_created_at_desc", :algorithm=>:concurrently})1132main: -> 0.0015s1133main: == 20230321153035 AddPackageIdCreatedAtDescIndexToPackageFiles: migrated (0.0403s) 1134main: == [advisory_lock_connection] object_id: 151996020, pg_backend_pid: 3081135 correctly migrates up and down1136AddTypeToHttpIntegrations1137 # order random1138main: == [advisory_lock_connection] object_id: 156640320, pg_backend_pid: 3151139main: == 20230428165514 AddTypeToHttpIntegrations: migrating ========================1140main: -- add_column(:alert_management_http_integrations, :type_identifier, :integer, {:default=>0, :null=>false, :limit=>2})1141main: -> 0.0020s1142main: == 20230428165514 AddTypeToHttpIntegrations: migrated (0.0097s) ===============1143main: == [advisory_lock_connection] object_id: 156640320, pg_backend_pid: 3151144 correctly migrates up and down1145QueueCleanupPersonalAccessTokensWithNilExpiresAt1146 # order random1147main: == [advisory_lock_connection] object_id: 159495460, pg_backend_pid: 3221148main: == 20230510062503 QueueCleanupPersonalAccessTokensWithNilExpiresAt: migrating =1149main: == 20230510062503 QueueCleanupPersonalAccessTokensWithNilExpiresAt: migrated (0.0519s) 1150main: == [advisory_lock_connection] object_id: 159495460, pg_backend_pid: 3221151 schedules a new batched migration1152Knapsack report was generated. Preview:1153{1154 "spec/migrations/20230209140102_fix_partition_ids_for_ci_build_metadata_spec.rb": 22.247281894000025,1155 "spec/migrations/20230209090702_fix_partition_ids_for_ci_build_report_result_spec.rb": 21.371666946000005,1156 "spec/migrations/20230412214119_finalize_encrypt_ci_trigger_token_spec.rb": 18.031429540999966,1157 "spec/migrations/delete_migrate_shared_vulnerability_scanners_spec.rb": 30.157942099000024,1158 "spec/migrations/20230201171450_finalize_backfill_environment_tier_migration_spec.rb": 24.00708122100002,1159 "spec/migrations/recount_epic_cache_counts_spec.rb": 26.177624650999974,1160 "spec/migrations/20230317004428_migrate_daily_redis_hll_events_to_weekly_aggregation_spec.rb": 20.216483971999992,1161 "spec/migrations/20221210154044_update_active_billable_users_index_spec.rb": 25.835414743,1162 "spec/migrations/20230203122602_schedule_vulnerabilities_feedback_migration4_spec.rb": 21.878920881999875,1163 "spec/migrations/swap_merge_request_user_mentions_note_id_to_bigint_2_spec.rb": 20.30270998700007,1164 "spec/migrations/20230221093533_add_tmp_partial_index_on_vulnerability_report_types_spec.rb": 19.96338971299997,1165 "spec/migrations/20230426085615_queue_backfill_resource_link_events_spec.rb": 18.43682284900001,1166 "spec/migrations/20230303105806_queue_delete_orphaned_packages_dependencies_spec.rb": 17.935715916000163,1167 "spec/migrations/insert_daily_invites_trial_plan_limits_spec.rb": 16.781911648999994,1168 "spec/migrations/20230313142631_backfill_ml_candidates_package_id_spec.rb": 15.89466408699991,1169 "spec/migrations/ensure_suggestions_note_id_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb": 14.999139984000067,1170 "spec/migrations/20230328030101_add_secureflag_training_provider_spec.rb": 14.876943489000041,1171 "spec/migrations/20230405200858_requeue_backfill_project_wiki_repositories_spec.rb": 14.210039308999967,1172 "spec/migrations/20230321163947_backfill_ml_candidates_project_id_spec.rb": 15.268066166999915,1173 "spec/migrations/20230321153035_add_package_id_created_at_desc_index_to_package_files_spec.rb": 15.935624801000131,1174 "spec/migrations/add_type_to_http_integrations_spec.rb": 12.241570211999942,1175 "spec/migrations/20230510062502_queue_cleanup_personal_access_tokens_with_nil_expires_at_spec.rb": 11.9940880049998671176}1177Knapsack global time execution for tests: 06m 58s1178Finished in 15 minutes 36 seconds (files took 38.57 seconds to load)117954 examples, 0 failures1180Randomized with seed 652261181[TEST PROF INFO] Time spent in factories: 00:00.288 (0.03% of total time)1182RSpec exited with 0.1183No examples to retry, congrats!1185Not uploading cache ruby-gems-debian-bullseye-ruby-3.0-16 due to policy1187Uploading artifacts...1188coverage/: found 5 matching artifact files and directories 1189crystalball/: found 2 matching artifact files and directories 1190WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 1191knapsack/: found 4 matching artifact files and directories 1192WARNING: query_recorder/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 1193rspec/: found 16 matching artifact files and directories 1194WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 1195log/*.log: found 14 matching artifact files and directories 1196WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/4400964152/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com1197WARNING: Retrying... context=artifacts-uploader error=request redirected1198Uploading artifacts as "archive" to coordinator... 201 Created id=4400964152 responseStatus=201 Created token=64_2X3wy1199Uploading artifacts...1200rspec/rspec-*.xml: found 1 matching artifact files and directories 1201WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/4400964152/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com1202WARNING: Retrying... context=artifacts-uploader error=request redirected1203Uploading artifacts as "junit" to coordinator... 201 Created id=4400964152 responseStatus=201 Created token=64_2X3wy1205Job succeeded