Unable to upgrade GitLab-EE from version 13.7.7 to 13.8.0.
Hi, We are using self-hosted GitLab docker image "gitlab/gitlab-ee:13.7.7-ee.0" and we are trying to upgrade to the version 13.8.0 but we are getting below error,
ALTER TABLE "gitlab_partitions_dynamic"."audit_events_part_5fc467ac26_202108" RENAME CONSTRAINT "audit_events_part_5fc467ac26_202108_pkey" TO "audit_events_202108_pkey";
ALTER TABLE "gitlab_partitions_dynamic"."audit_events_part_5fc467ac26_202108" RENAME TO "audit_events_202108"")rake aborted! StandardError: An error has occurred, this and all later migrations canceled:
PG::UndefinedFunction: ERROR: could not find a function named "table_sync_function_2be879775d"
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/schema_helpers.rb:57:in create_comment' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:324:in create_trigger_to_sync_tables'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:429:in block in replace_table' /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/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:422:in replace_table' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:206:in replace_with_partitioned_table'
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20201112215132_swap_partitioned_audit_events.rb:9: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 '
Caused by:
ActiveRecord::StatementInvalid: PG::UndefinedFunction: ERROR: could not find a function named "table_sync_function_2be879775d"
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/schema_helpers.rb:57:in create_comment' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:324:in create_trigger_to_sync_tables'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:429:in block in replace_table' /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/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:422:in replace_table' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:206:in replace_with_partitioned_table'
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20201112215132_swap_partitioned_audit_events.rb:9: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 '
Caused by:
PG::UndefinedFunction: ERROR: could not find a function named "table_sync_function_2be879775d"
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/schema_helpers.rb:57:in create_comment' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:324:in create_trigger_to_sync_tables'
/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:429:in block in replace_table' /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/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:422:in replace_table' /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/partitioning_migration_helpers/table_management_helpers.rb:206:in replace_with_partitioned_table'
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20201112215132_swap_partitioned_audit_events.rb:9: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 '
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
-- execute("COMMENT ON FUNCTION table_sync_function_2be879775d IS 'Partitioning migration: table sync for audit_events table'") STDERR: ---- End output of "bash" "/tmp/chef-script20210223-28-11ww5tb" ---- Ran "bash" "/tmp/chef-script20210223-28-11ww5tb" returned 1