upgrade GitLab 13.4.2 -> 13.8.3

When upgrading the GitLab 13.4.2 -> 13.8.3 error is thrown PG::UndefinedTable: ERROR: relation "audit_events_part_5fc467ac26" does not exist during the migrations part of the upgrade.

No error.

Recipe: gitlab::database_migrations
  * bash[migrate gitlab-rails database] action run
    [execute] == 20200716234259 RemoveDuplicateLabelsFromGroup: migrating ===================
              -- transaction()
                 -> 0.9660s
              -- transaction()
                 -> 0.0019s
              == 20200716234259 RemoveDuplicateLabelsFromGroup: migrated (1.0474s) ==========
              == 20200716234518 AddUniquenessIndexToLabelTitleAndGroup: migrating ===========
              -- transaction_open?()
                 -> 0.0000s
              -- index_exists?(:labels, [:group_id, :title], {:where=>"labels.project_id IS NULL", :unique=>true, :name=>"index_labels_on_group_id_and_title_unique", :algorithm=>:concurrently})
                 -> 0.0059s
              -- execute("SET statement_timeout TO 0")
                 -> 0.0005s
              -- add_index(:labels, [:group_id, :title], {:where=>"labels.project_id IS NULL", :unique=>true, :name=>"index_labels_on_group_id_and_title_unique", :algorithm=>:concurrently})
                 -> 0.0074s
              -- execute("RESET ALL")
                 -> 0.0004s
              -- transaction_open?()
                 -> 0.0000s
              -- index_exists?(:labels, [:group_id, :title], {:name=>"index_labels_on_group_id_and_title", :algorithm=>:concurrently})
                 -> 0.0056s
              == 20200716234518 AddUniquenessIndexToLabelTitleAndGroup: migrated (0.0211s) ==
              == 20200901170135 BackfillModifiedColumnForApprovalMergeRequestRules: migrating
              -- Scheduled 3 AddModifiedToApprovalMergeRequestRule jobs with a maximum of 10000 records per batch and an interval of 120 seconds.
              The migration is expected to take at least 360 seconds. Expect all jobs to have completed after 2021-02-11 12:01:06 UTC."
              == 20200901170135 BackfillModifiedColumnForApprovalMergeRequestRules: migrated (3.3287s)
              == 20200907092715 AddNotNullConstraintToUserOnGroupImportStates: migrating ====
              -- current_schema()
                 -> 0.0009s
              -- transaction_open?()
                 -> 0.0000s
              -- current_schema()
                 -> 0.0007s
              -- execute("ALTER TABLE group_import_states\nADD CONSTRAINT check_cda75c7c3f\nCHECK ( user_id IS NOT NULL )\nNOT VALID;\n")
                 -> 0.0015s
              == 20200907092715 AddNotNullConstraintToUserOnGroupImportStates: migrated (0.2544s)
              == 20200908064229 AddPartialIndexToCiBuildsTableOnUserIdName: migrating =======
              -- transaction_open?()
                 -> 0.0000s
              -- index_exists?(:ci_builds, [:user_id, :name], {:where=>"(((type)::text = 'Ci::Build'::text) AND\n  ((name)::text = ANY (\n    ARRAY[\n      ('container_scanning'::character varying)::text,\n      ('dast'::character varying)::text,\n      ('dependency_scanning'::character varying)::text,\n      ('license_management'::character varying)::text,\n      ('license_scanning'::character varying)::text,\n      ('sast'::character varying)::text,\n      ('coverage_fuzzing'::character varying)::text,\n      ('secret_detection'::character varying)::text\n    ]\n  ))\n)\n", :name=>"index_partial_ci_builds_on_user_id_name_parser_features", :algorithm=>:concurrently})
                 -> 0.0171s
              -- execute("SET statement_timeout TO 0")
                 -> 0.0004s
              -- add_index(:ci_builds, [:user_id, :name], {:where=>"(((type)::text = 'Ci::Build'::text) AND\n  ((name)::text = ANY (\n    ARRAY[\n      ('container_scanning'::character varying)::text,\n      ('dast'::character varying)::text,\n      ('dependency_scanning'::character varying)::text,\n      ('license_management'::character varying)::text,\n      ('license_scanning'::character varying)::text,\n      ('sast'::character varying)::text,\n      ('coverage_fuzzing'::character varying)::text,\n      ('secret_detection'::character varying)::text\n    ]\n  ))\n)\n", :name=>"index_partial_ci_builds_on_user_id_name_parser_features", :algorithm=>:concurrently})
                 -> 96.4112s
              -- execute("RESET ALL")
                 -> 0.0018s
              == 20200908064229 AddPartialIndexToCiBuildsTableOnUserIdName: migrated (96.4315s)
              == 20200909161624 CleanupGroupImportStatesWithNullUserId: migrating ===========
              == 20200909161624 CleanupGroupImportStatesWithNullUserId: migrated (0.0270s) ==
              == 20200910155617 BackfillJiraTrackerDeploymentType: migrating ================
              == 20200910155617 BackfillJiraTrackerDeploymentType: migrated (0.0000s) =======
              == 20200912153218 CleanupAdminNotificationEmailApplicationSettingRename: migrating
              -- execute("DROP TRIGGER IF EXISTS trigger_8fe85065a3f9 ON application_settings")
                 -> 0.0195s
              -- execute("DROP FUNCTION IF EXISTS trigger_8fe85065a3f9()")
                 -> 0.0037s
              -- remove_column(:application_settings, :admin_notification_email)
                 -> 0.0070s
              == 20200912153218 CleanupAdminNotificationEmailApplicationSettingRename: migrated (0.0327s)
              == 20200915185707 EnsureFilledFileStoreOnPackageFiles: migrating ==============
              == 20200915185707 EnsureFilledFileStoreOnPackageFiles: migrated (0.7037s) =====
              == 20200915191156 ValidateNotNullFileStoreOnPackageFiles: migrating ===========
              -- current_schema()
                 -> 0.0005s
              -- execute("SET statement_timeout TO 0")
                 -> 0.0005s
              -- execute("ALTER TABLE packages_package_files VALIDATE CONSTRAINT check_4c5e6bb0b3;")
                 -> 0.0018s
              -- execute("RESET ALL")
                 -> 0.0004s
              -- transaction_open?()
                 -> 0.0000s
              -- indexes(:packages_package_files)
                 -> 0.0072s
              -- execute("SET statement_timeout TO 0")
                 -> 0.0005s
              -- remove_index(:packages_package_files, {:algorithm=>:concurrently, :name=>"index_packages_package_files_file_store_is_null"})
                 -> 0.0143s
              -- execute("RESET ALL")
                 -> 0.0006s
              == 20200915191156 ValidateNotNullFileStoreOnPackageFiles: migrated (0.0282s) ==
              == 20200917135802 RemoveDuplicatedCsFindingsWithoutVulnerabilityId: migrating =
              == 20200917135802 RemoveDuplicatedCsFindingsWithoutVulnerabilityId: migrated (0.0001s)
              == 20200917165525 UpdateIndexOnNamespacesForTypeAndId: migrating ==============
              -- transaction_open?()
                 -> 0.0000s
              -- index_exists?(:namespaces, [:type, :id], {:where=>"type IS NOT NULL", :name=>"index_namespaces_on_type_and_id_partial", :algorithm=>:concurrently})
                 -> 0.0147s
              -- execute("SET statement_timeout TO 0")
                 -> 0.0005s
              -- add_index(:namespaces, [:type, :id], {:where=>"type IS NOT NULL", :name=>"index_namespaces_on_type_and_id_partial", :algorithm=>:concurrently})
                 -> 0.0093s
              -- execute("RESET ALL")
                 -> 0.0005s
              -- transaction_open?()
                 -> 0.0000s
              -- indexes(:namespaces)
                 -> 0.0161s
              -- execute("SET statement_timeout TO 0")
                 -> 0.0006s
              -- remove_index(:namespaces, {:algorithm=>:concurrently, :name=>"index_namespaces_on_type_partial"})
                 -> 0.0073s
              -- execute("RESET ALL")
                 -> 0.0007s
              == 20200917165525 UpdateIndexOnNamespacesForTypeAndId: migrated (0.0513s) =====
              == 20200922054642 DropSnowplowIgluRegistryUrlFromApplicationSettings: migrating
              -- remove_column(:application_settings, :snowplow_iglu_registry_url, :string, {:limit=>255})
                 -> 0.0019s
              == 20200922054642 DropSnowplowIgluRegistryUrlFromApplicationSettings: migrated (0.0021s)
              == 20200922095954 RemoveInstanceStatisticsVisibilityPrivateFromApplicationSettings: migrating
              -- remove_column(:application_settings, :instance_statistics_visibility_private)
                 -> 0.0017s
              == 20200922095954 RemoveInstanceStatisticsVisibilityPrivateFromApplicationSettings: migrated (0.0018s)
              == 20200922170907 ChangeIndexOnPipelineStatus: migrating ======================
              -- transaction_open?()
                 -> 0.0000s
              -- index_exists?(:ci_pipelines, [:status, :id], {:name=>"index_ci_pipelines_on_status_and_id", :algorithm=>:concurrently})
                 -> 0.0157s
              -- execute("SET statement_timeout TO 0")
                 -> 0.0003s
              -- add_index(:ci_pipelines, [:status, :id], {:name=>"index_ci_pipelines_on_status_and_id", :algorithm=>:concurrently})
                 -> 1.0047s
              -- execute("RESET ALL")
                 -> 0.0007s
              -- transaction_open?()
                 -> 0.0000s
              -- indexes(:ci_pipelines)
                 -> 0.0129s
              -- execute("SET statement_timeout TO 0")
                 -> 0.0005s
              -- remove_index(:ci_pipelines, {:algorithm=>:concurrently, :name=>"index_ci_pipelines_on_status"})
                 -> 0.0146s
              -- execute("RESET ALL")




    

                 -> 0.0005s
              == 20200922170907 ChangeIndexOnPipelineStatus: migrated (1.0514s) =============
              == 20200922231755 RemoveCreatedByUserIdFromClusterProvidersAws: migrating =====
              -- remove_column(:cluster_providers_aws, :created_by_user_id)
                 -> 0.0362s
              == 20200922231755 RemoveCreatedByUserIdFromClusterProvidersAws: migrated (0.0438s)
              == 20200929052138 CreateInitialVersionsForPreVersioningTerraformStates: migrating
              -- execute("      INSERT INTO terraform_state_versions (terraform_state_id, created_at, updated_at, version, file_store, file)\n      SELECT id, NOW(), NOW(), 0, file_store, file\n      FROM terraform_states\n      WHERE versioning_enabled = FALSE\n      ON CONFLICT (terraform_state_id, version) DO NOTHING\n")rake aborted!
              StandardError: An error has occurred, this and all later migrations canceled:
              PG::UndefinedTable: ERROR:  relation "audit_events_part_5fc467ac26" does not exist
              /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20200929113254_remove_type_from_audit_events.rb:64:in `block in up'
              /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:121:in `run_block'
              /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:130:in `block in run_block_with_transaction'
              /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:125:in `run_block_with_transaction'
              /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:95:in `run'
              /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:394:in `with_lock_retries'
              /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20200929113254_remove_type_from_audit_events.rb:13:in `up'
              /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:59:in `block (3 levels) in <top (required)>'
              /opt/gitlab/embedded/bin/bundle:23:in `load'
              /opt/gitlab/embedded/bin/bundle:23:in `<main>'
              Caused by:
              ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR:  relation "audit_events_part_5fc467ac26" does not exist
              /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20200929113254_remove_type_from_audit_events.rb:64:in `block in up'
              /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:121:in `run_block'
              /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:130:in `block in run_block_with_transaction'
              /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:125:in `run_block_with_transaction'
              /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:95:in `run'
              /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:394:in `with_lock_retries'
              /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20200929113254_remove_type_from_audit_events.rb:13:in `up'
              /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:59:in `block (3 levels) in <top (required)>'
              /opt/gitlab/embedded/bin/bundle:23:in `load'
              /opt/gitlab/embedded/bin/bundle:23:in `<main>'
              Caused by:
              PG::UndefinedTable: ERROR:  relation "audit_events_part_5fc467ac26" does not exist
              /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20200929113254_remove_type_from_audit_events.rb:64:in `block in up'
              /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:121:in `run_block'
              /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:130:in `block in run_block_with_transaction'
              /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:125:in `run_block_with_transaction'
              /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/with_lock_retries.rb:95:in `run'
              /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/migration_helpers.rb:394:in `with_lock_retries'
              /opt/gitlab/embedded/service/gitlab-rails/db/post_migrate/20200929113254_remove_type_from_audit_events.rb:13:in `up'
              /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:59:in `block (3 levels) in <top (required)>'
              /opt/gitlab/embedded/bin/bundle:23:in `load'
              /opt/gitlab/embedded/bin/bundle:23:in `<main>'
              Tasks: TOP => db:migrate
              (See full trace by running task with --trace)
                 -> 0.0168s
              == 20200929052138 CreateInitialVersionsForPreVersioningTerraformStates: migrated (0.0169s)
              == 20200929113254 RemoveTypeFromAuditEvents: migrating ========================
              -- remove_column("audit_events", :type)
                 -> 0.0073s
              -- execute("CREATE OR REPLACE FUNCTION table_sync_function_2be879775d()\nRETURNS TRIGGER AS\n$$\nBEGIN\nIF (TG_OP = 'DELETE') THEN\n  DELETE FROM audit_events_part_5fc467ac26 where id = OLD.id;\nELSIF (TG_OP = 'UPDATE') THEN\n  UPDATE audit_events_part_5fc467ac26\n  SET author_id = NEW.author_id,\n    entity_id = NEW.entity_id,\n    entity_type = NEW.entity_type,\n    details = NEW.details,\n    ip_address = NEW.ip_address,\n    author_name = NEW.author_name,\n    entity_path = NEW.entity_path,\n    target_details = NEW.target_details,\n    target_type = NEW.target_type,\n    target_id = NEW.target_id,\n    created_at = NEW.created_at\n  WHERE audit_events_part_5fc467ac26.id = NEW.id;\nELSIF (TG_OP = 'INSERT') THEN\n  INSERT INTO audit_events_part_5fc467ac26 (id,\n    author_id,\n    entity_id,\n    entity_type,\n    details,\n    ip_address,\n    author_name,\n    entity_path,\n    target_details,\n    target_type,\n    target_id,\n    created_at)\n  VALUES (NEW.id,\n    NEW.author_id,\n    NEW.entity_id,\n    NEW.entity_type,\n    NEW.details,\n    NEW.ip_address,\n    NEW.author_name,\n    NEW.entity_path,\n    NEW.target_details,\n    NEW.target_type,\n    NEW.target_id,\n    NEW.created_at);\nEND IF;\nRETURN NULL;\n\nEND\n$$ LANGUAGE PLPGSQL\n")
                 -> 0.0072s
              -- remove_column("audit_events_part_5fc467ac26", :type)
    ================================================================================
    Error executing action `run` on resource 'bash[migrate gitlab-rails database]'
    ================================================================================
    Mixlib::ShellOut::ShellCommandFailed
    ------------------------------------
    Expected process to exit with [0], but received '1'
    ---- Begin output of "bash"  "/tmp/chef-script20210211-22659-rn63px" ----
    STDOUT: == 20200716234259 RemoveDuplicateLabelsFromGroup: migrating ===================
    -- transaction()
       -> 0.9660s
    -- transaction()
       -> 0.0019s
    == 20200716234259 RemoveDuplicateLabelsFromGroup: migrated (1.0474s) ==========

Skip the migration 20200929113254 and remove the column :type manually from the audit_events tables.