could not find a function named "table_sync_function from version 13.7.7 to 13.8.0. (duplicate GitLab schema)
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 `<main>' 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 `<main>' 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 `<main>' 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 >
issue