Unable to create merge requests due to duplicate key value violates unique constraint "any_approver_merge_request_rule_type_unique_index"
https://sentry.gitlab.net/gitlab/gitlabcom/issues/2080664/?referrer=gitlab_plugin
PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "any_approver_merge_request_rule_type_unique_index"
DETAIL: Key (merge_request_id, rule_type)=(76020548, 4) already exists.
active_record/connection_adapters/postgresql_adapter.rb:675:in `exec_params'
@connection.exec_params(sql, type_casted_binds)
active_record/persistence.rb:905:in `create_or_update'
result = new_record? ? _create_record(&block) : _update_record(&block)
active_record/callbacks.rb:327:in `block in create_or_update'
_run_save_callbacks { super }
active_support/callbacks.rb:135:in `run_callbacks'
env.value = !env.halted && (!block_given? || yield)
active_support/callbacks.rb:825:in `_run_save_callbacks'
run_callbacks #{name.inspect}, &block
...
(245 additional frame(s) were not displayed)
ActiveRecord::RecordNotUnique: PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "any_approver_merge_request_rule_type_unique_index"
DETAIL: Key (merge_request_id, rule_type)=(76020548, 4) already exists.
Zendesk Reports (GitLab Internal)
Edited by Tristan