ActiveRecord::RecordNotUnique happened in InitiativesController#update

[appsignal]

** DEV NOTE **

Issue caused by duplicated records in the subsystem tags attributes. Just need to remove the duplicates before updating the record.

Message

  PG::UniqueViolation: ERROR:  duplicate key value violates unique constraint "idx_initiatives_subsystem_tags_initiative_and_subsystem_tag_id"
DETAIL:  Key (initiative_id, subsystem_tag_id)=(?) already exists.

Backtrace (last 10 lines)

lib/active_record/connection_adapters/postgresql_adapter.rb:768 exec_params
lib/active_record/connection_adapters/postgresql_adapter.rb:768 block (2 levels) in exec_no_cache
lib/active_support/concurrency/share_lock.rb:187 yield_shares
lib/active_support/dependencies/interlock.rb:41 permit_concurrent_loads
lib/active_record/connection_adapters/postgresql_adapter.rb:767 block in exec_no_cache
lib/active_support/concurrency/load_interlock_aware_monitor.rb:25 handle_interrupt
lib/active_support/concurrency/load_interlock_aware_monitor.rb:25 block in synchronize
lib/active_support/concurrency/load_interlock_aware_monitor.rb:21 handle_interrupt
lib/active_support/concurrency/load_interlock_aware_monitor.rb:21 synchronize
lib/active_record/connection_adapters/abstract_adapter.rb:752 block in log

View on AppSignal: https://appsignal.com/eventide-systems-pty-ltd/sites/66cc61b4ecef188d809b49d4/exceptions/incidents/41