Hi!
I encountered an error while creating a merge request using web interface
Steps to reproduce the error:
- open new merge request
- choose assignee and reviewer same person
- hit create button
- http 500 error and an empty merge request after reloading page
Found an error in the logs via gitlab-ctl tail | grep error
"error_message":"PG::UniqueViolation: ERROR: duplicate key value violates unique constraint \"index_system_note_metadata_on_note_id_convert_to_bigint\"\nDETAIL: Key (note_id_convert_to_bigint)=(0) already exists.\n","error_class":"ActiveRecord::RecordNotUnique","failed_at":"2023-06-22T12:47:27.421Z","retry_count":1,"retried_at":"2023-06-22T12:47:54.463Z","job_size_bytes":13,"pid":2297,"message":"MergeRequests::HandleAssigneesChangeWorker JID-11bca695faec4522679bd108: fail: 0.108919 sec","job_status":"fail","scheduling_latency_s":0.002644,"redis_calls":1,"redis_duration_s":0.000309,"redis_read_bytes":1,"redis_write_bytes":123,"redis_queues_calls":1,"redis_queues_duration_s":0.000309,"redis_queues_read_bytes":1,"redis_queues_write_bytes":123,"db_count":8,"db_write_count":2,"db_cached_count":0,"db_replica_count":0,"db_primary_count":8,"db_main_count":8,"db_ci_count":0,"db_main_replica_count":0,"db_ci_replica_count":0,"db_replica_cached_count":0,"db_primary_cached_count":0,"db_main_cached_count":0,"db_ci_cached_count":0,"db_main_replica_cached_count":0,"db_ci_replica_cached_count":0,"db_replica_wal_count":0,"db_primary_wal_count":0,"db_main_wal_count":0,"db_ci_wal_count":0,"db_main_replica_wal_count":0,"db_ci_replica_wal_count":0,"db_replica_wal_cached_count":0,"db_primary_wal_cached_count":0,"db_main_wal_cached_count":0,"db_ci_wal_cached_count":0,"db_main_replica_wal_cached_count":0,"db_ci_replica_wal_cached_count":0,"db_replica_duration_s":0.0,"db_primary_duration_s":0.051,"db_main_duration_s":0.051,"db_ci_duration_s":0.0,"db_main_replica_duration_s":0.0,"db_ci_replica_duration_s":0.0,"cpu_s":0.055213,"mem_objects":12543,"mem_bytes":1592336,"mem_mallocs":5668,"mem_total_bytes":2094056,"worker_id":"sidekiq_0","rate_limiting_gates":[],"duration_s":0.108919,"completed_at":"2023-06-22T12:48:22.555Z","load_balancing_strategy":"primary","exception.class":"ActiveRecord::RecordNotUnique","exception.message":"PG::UniqueViolation: ERROR: duplicate key value violates unique constraint \"index_system_note_metadata_on_note_id_convert_to_bigint\"\nDETAIL: Key (note_id_convert_to_bigint)=(0) already exists.\n"
My setup is Ubuntu 22.04, Gitlab 15.11 (same behavior after update to v16.0), Postgresql 15.3