rspec migration pg13 single-db 7/8
Passed Started
by
@fabiopitino
Fabio Pitino
1Running with gitlab-runner 16.1.0~beta.5.gf131a6a2 (f131a6a2)2 on blue-1.private.runners-manager.gitlab.com/gitlab.com/gitlab-org 1zzGUpzq, system ID: s_fc31da7ae46e3 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-1zzgupzq-project-278964-concurrent-0 via runner-1zzgupzq-private-1685686882-130dc148...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 92035 (delta 39894), pack-reused 0 34Receiving objects: 100% (139970/139970), 123.36 MiB | 32.24 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_JyuFb48Downloading artifacts for detect-tests (4400964025)...49Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4400964025 responseStatus=200 OK token=64_JyuFb50Downloading artifacts for retrieve-tests-metadata (4400964028)...51Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4400964028 responseStatus=200 OK token=64_JyuFb52Downloading artifacts for setup-test-env (4400964019)...53Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4400964019 responseStatus=200 OK token=64_JyuFb55Using 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$ echo -e "\e[0Ksection_start:`date +%s`:gitaly-test-spawn[collapsed=true]\r\e[0KStarting Gitaly"737==> 'gem install knapsack --no-document' succeeded in 0 seconds.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_7_8_report.json753FLAKY_RSPEC_SUITE_REPORT_PATH: rspec/flaky/report-suite.json754FLAKY_RSPEC_REPORT_PATH: rspec/flaky/all_rspec_migration_pg13_single-db_7_8_report.json755NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg13_single-db_7_8_report.json756SKIPPED_TESTS_REPORT_PATH: rspec/skipped_tests_rspec_migration_pg13_single-db_7_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 0.718326415 seconds765SyncNewAmountUsedWithAmountUsed766 # order random767 #up768 doesnt change new_amount_used values769 #down770 updates `new_amount_used` with values from `amount_used`771FixPartitionIdsForCiJobArtifact772 # order random773 when on saas774 #up775main: == [advisory_lock_connection] object_id: 14906440, pg_backend_pid: 117776main: == 20230208103009 FixPartitionIdsForCiJobArtifact: migrating ==================777main: == 20230208103009 FixPartitionIdsForCiJobArtifact: migrated (0.0614s) =========778main: == [advisory_lock_connection] object_id: 14906440, pg_backend_pid: 117779 schedules background jobs for each batch of ci_job_artifacts780 #down781main: == [advisory_lock_connection] object_id: 15515180, pg_backend_pid: 119782main: == 20230208103009 FixPartitionIdsForCiJobArtifact: migrating ==================783main: == 20230208103009 FixPartitionIdsForCiJobArtifact: migrated (0.0614s) =========784main: == [advisory_lock_connection] object_id: 15515180, pg_backend_pid: 119785 deletes all batched migration records786 when on self-managed instance787 #up788 does not schedule background job789 #down790 does not delete background job791TruncateErrorTrackingTables792 # order random793 when on self-managed794 when using Main db795 does not truncate the table796 when uses CI db797 does not truncate the table798 when on GitLab.com799 when using Main db800main: -- execute("TRUNCATE table error_tracking_errors CASCADE")801main: -> 0.0002s802 truncates the table803 when uses CI db804 does not truncate the table (PENDING: Skipping because none of the extra databases [:ci] are setup)805ScheduleFixingSecurityScanStatuses806 # order random807 #down808main: == [advisory_lock_connection] object_id: 31270880, pg_backend_pid: 138809main: == 20221128120634 ScheduleFixingSecurityScanStatuses: migrating ===============810main: == 20221128120634 ScheduleFixingSecurityScanStatuses: migrated (0.0004s) ======811main: == [advisory_lock_connection] object_id: 31270880, pg_backend_pid: 138812 deletes all batched migration records813 #up814 when the migration does not run on GitLab.com or development environment815main: == [advisory_lock_connection] object_id: 31926900, pg_backend_pid: 141816main: == 20221128120634 ScheduleFixingSecurityScanStatuses: migrating ===============817main: == 20221128120634 ScheduleFixingSecurityScanStatuses: migrated (0.0006s) ======818main: == [advisory_lock_connection] object_id: 31926900, pg_backend_pid: 141819 does not schedule the migration820 when the migration runs on GitLab.com821 behaves like scheduler for fixing the security scans status822main: == [advisory_lock_connection] object_id: 32076140, pg_backend_pid: 143823main: == 20221128120634 ScheduleFixingSecurityScanStatuses: migrating ===============824main: == 20221128120634 ScheduleFixingSecurityScanStatuses: migrated (0.0486s) ======825main: == [advisory_lock_connection] object_id: 32076140, pg_backend_pid: 143826 schedules background job827 when the migration runs on dev environment828 behaves like scheduler for fixing the security scans status829main: == [advisory_lock_connection] object_id: 32261200, pg_backend_pid: 145830main: == 20221128120634 ScheduleFixingSecurityScanStatuses: migrating ===============831main: == 20221128120634 ScheduleFixingSecurityScanStatuses: migrated (0.0558s) ======832main: == [advisory_lock_connection] object_id: 32261200, pg_backend_pid: 145833 schedules background job834CreateSecondPartitionForBuildsMetadata835 # order random836 #down837 when on sass838main: == [advisory_lock_connection] object_id: 44908500, pg_backend_pid: 152839main: == 20221102090943 CreateSecondPartitionForBuildsMetadata: migrating ===========840main: == 20221102090943 CreateSecondPartitionForBuildsMetadata: migrated (0.0111s) ==841main: == [advisory_lock_connection] object_id: 44908500, pg_backend_pid: 152842 removes the partition843 when self-managed844main: == [advisory_lock_connection] object_id: 45812420, pg_backend_pid: 154845main: == 20221102090943 CreateSecondPartitionForBuildsMetadata: migrating ===========846main: == 20221102090943 CreateSecondPartitionForBuildsMetadata: migrated (0.0002s) ==847main: == [advisory_lock_connection] object_id: 45812420, pg_backend_pid: 154848 does not change the partitions count849 #up850 when on sass851main: == [advisory_lock_connection] object_id: 45920400, pg_backend_pid: 156852main: == 20221102090943 CreateSecondPartitionForBuildsMetadata: migrating ===========853main: == 20221102090943 CreateSecondPartitionForBuildsMetadata: migrated (0.0127s) ==854main: == [advisory_lock_connection] object_id: 45920400, pg_backend_pid: 156855 creates a new partition856 when self-managed857main: == [advisory_lock_connection] object_id: 46044140, pg_backend_pid: 158858main: == 20221102090943 CreateSecondPartitionForBuildsMetadata: migrating ===========859main: == 20221102090943 CreateSecondPartitionForBuildsMetadata: migrated (0.0003s) ==860main: == [advisory_lock_connection] object_id: 46044140, pg_backend_pid: 158861 does not create the partition862QueueBackfillUserDetailsFields863 # order random864main: == [advisory_lock_connection] object_id: 59904980, pg_backend_pid: 165865main: == 20221019002459 QueueBackfillUserDetailsFields: migrating ===================866main: == 20221019002459 QueueBackfillUserDetailsFields: migrated (0.0461s) ==========867main: == [advisory_lock_connection] object_id: 59904980, pg_backend_pid: 165868 schedules a new batched migration869AddTextLimitToDefaultPreferredLanguageOnApplicationSettings870 # order random871 #up872main: == [advisory_lock_connection] object_id: 74684100, pg_backend_pid: 174873main: == 20221101032600 AddTextLimitToDefaultPreferredLanguageOnApplicationSettings: migrating 874main: -- execute("ALTER TABLE application_settings\nADD CONSTRAINT check_e2692d7523\nCHECK ( char_length(default_preferred_language) <= 32 )\nNOT VALID;\n")875main: -> 0.0035s876main: -- execute("ALTER TABLE application_settings VALIDATE CONSTRAINT check_e2692d7523;")877main: -> 0.0037s878main: == 20221101032600 AddTextLimitToDefaultPreferredLanguageOnApplicationSettings: migrated (0.0214s) 879main: == [advisory_lock_connection] object_id: 74684100, pg_backend_pid: 174880 adds text limit to default_preferred_language881 #down882main: == [advisory_lock_connection] object_id: 75592400, pg_backend_pid: 176883main: == 20221101032600 AddTextLimitToDefaultPreferredLanguageOnApplicationSettings: migrating 884main: -- execute("ALTER TABLE application_settings\nADD CONSTRAINT check_e2692d7523\nCHECK ( char_length(default_preferred_language) <= 32 )\nNOT VALID;\n")885main: -> 0.0024s886main: -- execute("ALTER TABLE application_settings VALIDATE CONSTRAINT check_e2692d7523;")887main: -> 0.0021s888main: == 20221101032600 AddTextLimitToDefaultPreferredLanguageOnApplicationSettings: migrated (0.0152s) 889main: == [advisory_lock_connection] object_id: 75592400, pg_backend_pid: 176890 deletes text limit to default_preferred_language891ScheduleCreateVulnerabilityLinksMigration892 # order random893 #down894main: == [advisory_lock_connection] object_id: 87429160, pg_backend_pid: 184895main: == 20230130182412 ScheduleCreateVulnerabilityLinksMigration: migrating ========896main: == 20230130182412 ScheduleCreateVulnerabilityLinksMigration: migrated (0.0673s) 897main: == [advisory_lock_connection] object_id: 87429160, pg_backend_pid: 184898 deletes all batched migration records899 #up900main: == [advisory_lock_connection] object_id: 87927440, pg_backend_pid: 187901main: == 20230130182412 ScheduleCreateVulnerabilityLinksMigration: migrating ========902main: == 20230130182412 ScheduleCreateVulnerabilityLinksMigration: migrated (0.0625s) 903main: == [advisory_lock_connection] object_id: 87927440, pg_backend_pid: 187904 schedules background jobs for each batch of Vulnerabilities::Feedback905QueuePopulateProjectsStarCount906 # order random907main: == [advisory_lock_connection] object_id: 98851560, pg_backend_pid: 194908main: == 20221019105041 QueuePopulateProjectsStarCount: migrating ===================909main: == 20221019105041 QueuePopulateProjectsStarCount: migrated (0.0540s) ==========910main: == [advisory_lock_connection] object_id: 98851560, pg_backend_pid: 194911 schedules a new batched migration912AddProjectIdNameIdVersionIndexToInstallableNpmPackages913 # order random914main: == [advisory_lock_connection] object_id: 111971020, pg_backend_pid: 202915main: == 20230131125844 AddProjectIdNameIdVersionIndexToInstallableNpmPackages: migrating 916main: -- view_exists?(:postgres_partitions)917main: -> 0.0018s918main: -- index_exists?(:packages_packages, [:project_id, :name, :id, :version], {:name=>"idx_packages_on_project_id_name_id_version_when_installable_npm", :where=>"package_type = 2 AND status IN (0, 1)", :algorithm=>:concurrently})919main: -> 0.0170s920main: -- add_index(:packages_packages, [:project_id, :name, :id, :version], {:name=>"idx_packages_on_project_id_name_id_version_when_installable_npm", :where=>"package_type = 2 AND status IN (0, 1)", :algorithm=>:concurrently})921main: -> 0.0019s922main: == 20230131125844 AddProjectIdNameIdVersionIndexToInstallableNpmPackages: migrated (0.0419s) 923main: == [advisory_lock_connection] object_id: 111971020, pg_backend_pid: 202924 schedules an index creation925NullifyLastErrorFromProjectMirrorData926 # order random927 #down928main: == [advisory_lock_connection] object_id: 121095740, pg_backend_pid: 210929main: == 20230208131808 NullifyLastErrorFromProjectMirrorData: migrating ============930main: == 20230208131808 NullifyLastErrorFromProjectMirrorData: migrated (0.0607s) ===931main: == [advisory_lock_connection] object_id: 121095740, pg_backend_pid: 210932 deletes all batched migration records933 #up934main: == [advisory_lock_connection] object_id: 121701660, pg_backend_pid: 213935main: == 20230208131808 NullifyLastErrorFromProjectMirrorData: migrating ============936main: == 20230208131808 NullifyLastErrorFromProjectMirrorData: migrated (0.0497s) ===937main: == [advisory_lock_connection] object_id: 121701660, pg_backend_pid: 213938 schedules background jobs for each batch of projects939The application_settings (main) table has 1257 columns.940Recreating the database941Dropped database 'gitlabhq_test'942Created database 'gitlabhq_test'943main: == [advisory_lock_connection] object_id: 121743140, pg_backend_pid: 219944main: == [advisory_lock_connection] object_id: 121743140, pg_backend_pid: 219945Databases re-creation done in 4.629946411000105946ScheduleMigrateSharedVulnerabilityIdentifiers947 # order random948 #up949main: == [advisory_lock_connection] object_id: 124580440, pg_backend_pid: 223950main: == 20230221093536 ScheduleMigrateSharedVulnerabilityIdentifiers: migrating ====951main: == 20230221093536 ScheduleMigrateSharedVulnerabilityIdentifiers: migrated (0.0523s) 952main: == [advisory_lock_connection] object_id: 124580440, pg_backend_pid: 223953 schedules954 #down955 deletes956AddCurrentUserTodosWorkItemWidget957 # order random958 behaves like migration that adds widget to work items definitions959 #up960main: == [advisory_lock_connection] object_id: 131773820, pg_backend_pid: 232961main: == 20230317162059 AddCurrentUserTodosWorkItemWidget: migrating ================962main: == 20230317162059 AddCurrentUserTodosWorkItemWidget: migrated (0.0341s) =======963main: == [advisory_lock_connection] object_id: 131773820, pg_backend_pid: 232964 creates widget definition in all types965main: == [advisory_lock_connection] object_id: 132340280, pg_backend_pid: 234966main: == 20230317162059 AddCurrentUserTodosWorkItemWidget: migrating ================967main: == 20230317162059 AddCurrentUserTodosWorkItemWidget: migrated (0.0485s) =======968main: == [advisory_lock_connection] object_id: 132340280, pg_backend_pid: 234969 logs a warning if the type is missing970 #down971main: == [advisory_lock_connection] object_id: 132489500, pg_backend_pid: 236972main: == 20230317162059 AddCurrentUserTodosWorkItemWidget: migrating ================973main: == 20230317162059 AddCurrentUserTodosWorkItemWidget: migrated (0.0516s) =======974main: == [advisory_lock_connection] object_id: 132489500, pg_backend_pid: 236975 removes definitions for widget976RemoveUserNamespaceRecordsFromVsaAggregation977 # order random978 #down979main: == [advisory_lock_connection] object_id: 138052780, pg_backend_pid: 242980main: == 20230322085041 RemoveUserNamespaceRecordsFromVsaAggregation: migrating =====981main: == 20230322085041 RemoveUserNamespaceRecordsFromVsaAggregation: migrated (0.0293s) 982main: == [advisory_lock_connection] object_id: 138052780, pg_backend_pid: 242983 does nothing984 #up985main: == [advisory_lock_connection] object_id: 138544460, pg_backend_pid: 245986main: == 20230322085041 RemoveUserNamespaceRecordsFromVsaAggregation: migrating =====987main: == 20230322085041 RemoveUserNamespaceRecordsFromVsaAggregation: migrated (0.0311s) 988main: == [advisory_lock_connection] object_id: 138544460, pg_backend_pid: 245989 deletes the non-group namespace aggregation records990SwapSnippetUserMentionsNoteIdToBigintForGitlabDotCom991 # order random992 #up993 swaps the integer and bigint columns for GitLab.com, dev, or test994 is a no-op for other instances995SwapEpicUserMentionsNoteIdToBigintForGitlabDotCom996 # order random997 #up998 swaps the integer and bigint columns for GitLab.com, dev, or test999 is a no-op for other instances1000BackfillCurrentValueWithProgressWorkItemProgresses1001 # order random1002 #up1003main: == [advisory_lock_connection] object_id: 155336040, pg_backend_pid: 2721004main: == 20230316073726 BackfillCurrentValueWithProgressWorkItemProgresses: migrating 1005main: -- execute("UPDATE work_item_progresses SET current_value = progress\nWHERE issue_id BETWEEN 1 AND 2\n")1006main: -> 0.0013s1007main: == 20230316073726 BackfillCurrentValueWithProgressWorkItemProgresses: migrated (0.0182s) 1008main: == [advisory_lock_connection] object_id: 155336040, pg_backend_pid: 2721009 back fills current_value from progress columns1010RescheduleLinksAvoidingDuplication1011 # order random1012 #up1013main: == [advisory_lock_connection] object_id: 160630120, pg_backend_pid: 2781014main: == 20230412141541 RescheduleLinksAvoidingDuplication: migrating ===============1015main: == 20230412141541 RescheduleLinksAvoidingDuplication: migrated (0.0658s) ======1016main: == [advisory_lock_connection] object_id: 160630120, pg_backend_pid: 2781017 schedules a batched background migration1018 #down1019main: == [advisory_lock_connection] object_id: 161195020, pg_backend_pid: 2801020main: == 20230412141541 RescheduleLinksAvoidingDuplication: migrating ===============1021main: == 20230412141541 RescheduleLinksAvoidingDuplication: migrated (0.0558s) ======1022main: == [advisory_lock_connection] object_id: 161195020, pg_backend_pid: 2801023 deletes all batched migration records1024AddProjectIdForeignKeyToPackagesNpmMetadataCaches1025 # order random1026main: -- foreign_keys(:packages_npm_metadata_caches)1027main: -> 0.0046s1028main: == [advisory_lock_connection] object_id: 165719080, pg_backend_pid: 2871029main: == 20230322145403 AddProjectIdForeignKeyToPackagesNpmMetadataCaches: migrating 1030main: -- execute("ALTER TABLE packages_npm_metadata_caches ADD CONSTRAINT fk_ada23b1d30 FOREIGN KEY (project_id) REFERENCES projects (id) ON DELETE SET NULL NOT VALID;")1031main: -> 0.0024s1032main: -- execute("ALTER TABLE packages_npm_metadata_caches VALIDATE CONSTRAINT fk_ada23b1d30;")1033main: -> 0.0023s1034main: == 20230322145403 AddProjectIdForeignKeyToPackagesNpmMetadataCaches: migrated (0.0428s) 1035main: == [advisory_lock_connection] object_id: 165719080, pg_backend_pid: 2871036main: -- foreign_keys(:packages_npm_metadata_caches)1037main: -> 0.0044s1038main: -- foreign_keys(:packages_npm_metadata_caches)1039main: -> 0.0044s1040 creates and drops the foreign key1041RemoveOldAsyncIndexTableNameLengthConstraint1042 # order random1043 .up1044main: -- transaction_open?()1045main: -> 0.0007s1046main: -- transaction_open?()1047main: -> 0.0004s1048main: -- execute(" ALTER TABLE postgres_async_indexes\n DROP CONSTRAINT IF EXISTS check_e64ff4359e\n")1049main: -> 0.0018s1050 allows inserting longer table names1051 .down1052main: -- transaction_open?()1053main: -> 0.0001s1054main: -- transaction_open?()1055main: -> 0.0001s1056main: -- execute("ALTER TABLE postgres_async_indexes\nADD CONSTRAINT check_e64ff4359e\nCHECK ( char_length(table_name) <= 63 )\nNOT VALID;\n")1057main: -> 0.0013s1058main: -- execute("ALTER TABLE postgres_async_indexes VALIDATE CONSTRAINT check_e64ff4359e;")1059main: -> 0.0011s1060 disallows inserting longer table names1061main: -- transaction_open?()1062main: -> 0.0002s1063main: -- transaction_open?()1064main: -> 0.0002s1065main: -- execute(" ALTER TABLE postgres_async_indexes\n DROP CONSTRAINT IF EXISTS check_e64ff4359e\n")1066main: -> 0.0013s1067main: -- transaction_open?()1068main: -> 0.0001s1069main: -- transaction_open?()1070main: -> 0.0001s1071main: -- execute("ALTER TABLE postgres_async_indexes\nADD CONSTRAINT check_e64ff4359e\nCHECK ( char_length(table_name) <= 63 )\nNOT VALID;\n")1072main: -> 0.0015s1073main: -- execute("ALTER TABLE postgres_async_indexes VALIDATE CONSTRAINT check_e64ff4359e;")1074main: -> 0.0011s1075 cleans up records with too long table_name1076RequeueBackfillAdminModeScopeForPersonalAccessTokens1077 # order random1078 #up1079main: == [advisory_lock_connection] object_id: 172551260, pg_backend_pid: 3011080main: == 20230406093640 RequeueBackfillAdminModeScopeForPersonalAccessTokens: migrating 1081main: == 20230406093640 RequeueBackfillAdminModeScopeForPersonalAccessTokens: migrated (0.0626s) 1082main: == [advisory_lock_connection] object_id: 172551260, pg_backend_pid: 3011083 schedules background migration1084FinalizeUserTypeMigration1085 # order random1086main: == [advisory_lock_connection] object_id: 175861320, pg_backend_pid: 3071087main: == 20230523101514 FinalizeUserTypeMigration: migrating ========================1088main: == 20230523101514 FinalizeUserTypeMigration: migrated (0.0053s) ===============1089main: == [advisory_lock_connection] object_id: 175861320, pg_backend_pid: 3071090 finalizes MigrateHumanUserType migration1091Knapsack report was generated. Preview:1092{1093 "spec/migrations/20221222092958_sync_new_amount_used_with_amount_used_spec.rb": 28.144303596000043,1094 "spec/migrations/20230208103009_fix_partition_ids_for_ci_job_artifact_spec.rb": 22.467569277999985,1095 "spec/migrations/20230328100534_truncate_error_tracking_tables_spec.rb": 17.916789378999965,1096 "spec/migrations/schedule_fixing_security_scan_statuses_spec.rb": 30.572758786999998,1097 "spec/migrations/20221102090943_create_second_partition_for_builds_metadata_spec.rb": 30.295182386000022,1098 "spec/migrations/queue_backfill_user_details_fields_spec.rb": 28.178252767000004,1099 "spec/migrations/20221101032600_add_text_limit_to_default_preferred_language_on_application_settings_spec.rb": 30.810618878000014,1100 "spec/migrations/20230130182412_schedule_create_vulnerability_links_migration_spec.rb": 23.650912201999972,1101 "spec/migrations/queue_populate_projects_star_count_spec.rb": 29.8539504769999,1102 "spec/migrations/20230131125844_add_project_id_name_id_version_index_to_installable_npm_packages_spec.rb": 22.16121754900007,1103 "spec/migrations/nullify_last_error_from_project_mirror_data_spec.rb": 22.67387447400006,1104 "spec/migrations/schedule_migrate_shared_vulnerability_identifiers_spec.rb": 18.976045961999944,1105 "spec/migrations/20230317162059_add_current_user_todos_work_item_widget_spec.rb": 16.987717905000068,1106 "spec/migrations/20230322085041_remove_user_namespace_records_from_vsa_aggregation_spec.rb": 15.868075653999995,1107 "spec/migrations/swap_snippet_user_mentions_note_id_to_bigint_for_gitlab_dot_com_spec.rb": 16.097646112000007,1108 "spec/migrations/swap_epic_user_mentions_note_id_to_bigint_for_gitlab_dot_com_spec.rb": 15.876514252999868,1109 "spec/migrations/backfill_current_value_with_progress_work_item_progresses_spec.rb": 17.63966943699984,1110 "spec/migrations/20230412141541_reschedule_links_avoiding_duplication_spec.rb": 15.505112444000133,1111 "spec/migrations/20230322145403_add_project_id_foreign_key_to_packages_npm_metadata_caches_spec.rb": 15.972183522000023,1112 "spec/migrations/remove_old_async_index_table_name_length_constraint_spec.rb": 11.33647668499998,1113 "spec/migrations/requeue_backfill_admin_mode_scope_for_personal_access_tokens_spec.rb": 14.843554397999924,1114 "spec/migrations/20230523101514_finalize_user_type_migration_spec.rb": 10.0192901410000561115}1116Knapsack global time execution for tests: 07m 35s1117Pending: (Failures listed here are expected and do not affect your suite's status)1118 1) TruncateErrorTrackingTables when on GitLab.com when uses CI db does not truncate the table1119 # Skipping because none of the extra databases [:ci] are setup1120 # ./spec/migrations/20230328100534_truncate_error_tracking_tables_spec.rb:271121Finished in 17 minutes 1 second (files took 41.46 seconds to load)112247 examples, 0 failures, 1 pending1123Randomized with seed 333181124[TEST PROF INFO] Time spent in factories: 00:00.297 (0.03% of total time)1125RSpec exited with 0.1126No examples to retry, congrats!1128Not uploading cache ruby-gems-debian-bullseye-ruby-3.0-16 due to policy1130Uploading artifacts...1131coverage/: found 5 matching artifact files and directories 1132crystalball/: found 2 matching artifact files and directories 1133WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 1134knapsack/: found 4 matching artifact files and directories 1135WARNING: query_recorder/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 1136rspec/: found 16 matching artifact files and directories 1137WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 1138log/*.log: found 13 matching artifact files and directories 1139WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/4400964154/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com1140WARNING: Retrying... context=artifacts-uploader error=request redirected1141Uploading artifacts as "archive" to coordinator... 201 Created id=4400964154 responseStatus=201 Created token=64_JyuFb1142Uploading artifacts...1143rspec/rspec-*.xml: found 1 matching artifact files and directories 1144WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/4400964154/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com1145WARNING: Retrying... context=artifacts-uploader error=request redirected1146Uploading artifacts as "junit" to coordinator... 201 Created id=4400964154 responseStatus=201 Created token=64_JyuFb1148Job succeeded