Skip to content

Duplicate key value violates unique constraint #1155

Description

@nicosammito
{"severity":"ERROR","time":"2026-07-23T08:09:06.732Z","message":"PG::UniqueViolation: ERROR:  duplicate key value violates unique constraint \"index_namespaces_on_parent_id_and_parent_type\"\nDETAIL:  Key (parent_id, parent_type)=(1, User) already exists.\n","backtrace":["/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:167:in 'PG::Connection#exec'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:167:in 'ActiveRecord::ConnectionAdapters::PostgreSQL::DatabaseStatements#perform_query'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/abstract/database_statements.rb:571:in 'block (2 levels) in ActiveRecord::ConnectionAdapters::DatabaseStatements#raw_execute'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/abstract_adapter.rb:1086:in 'block in ActiveRecord::ConnectionAdapters::AbstractAdapter#with_raw_connection'","/usr/local/bundle/ruby/3.4.0/gems/activesupport-8.1.3/lib/active_support/concurrency/null_lock.rb:9:in 'ActiveSupport::Concurrency::NullLock#synchronize'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/abstract_adapter.rb:1055:in 'ActiveRecord::ConnectionAdapters::AbstractAdapter#with_raw_connection'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/abstract/database_statements.rb:570:in 'block in ActiveRecord::ConnectionAdapters::DatabaseStatements#raw_execute'","/usr/local/bundle/ruby/3.4.0/gems/activesupport-8.1.3/lib/active_support/notifications/instrumenter.rb:58:in 'ActiveSupport::Notifications::Instrumenter#instrument'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/abstract_adapter.rb:1206:in 'ActiveRecord::ConnectionAdapters::AbstractAdapter#log'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/abstract/database_statements.rb:569:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#raw_execute'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/abstract/database_statements.rb:613:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#internal_execute'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/abstract/database_statements.rb:555:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#internal_exec_query'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/abstract/database_statements.rb:162:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#exec_insert'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:47:in 'ActiveRecord::ConnectionAdapters::PostgreSQL::DatabaseStatements#exec_insert'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/abstract/database_statements.rb:200:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#insert'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/abstract/query_cache.rb:25:in 'ActiveRecord::ConnectionAdapters::AbstractAdapter#insert'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/persistence.rb:257:in 'ActiveRecord::Persistence::ClassMethods#_insert_record'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/persistence.rb:957:in 'block in ActiveRecord::Persistence#_create_record'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:457:in 'ActiveRecord::ConnectionAdapters::ConnectionPool#with_connection'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_handling.rb:313:in 'ActiveRecord::ConnectionHandling#with_connection'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/persistence.rb:954:in 'ActiveRecord::Persistence#_create_record'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/counter_cache.rb:226:in 'ActiveRecord::CounterCache#_create_record'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/locking/optimistic.rb:84:in 'ActiveRecord::Locking::Optimistic#_create_record'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/encryption/encryptable_record.rb:184:in 'ActiveRecord::Encryption::EncryptableRecord#_create_record'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/attribute_methods/dirty.rb:240:in 'ActiveRecord::AttributeMethods::Dirty#_create_record'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/callbacks.rb:445:in 'block in ActiveRecord::Callbacks#_create_record'","/usr/local/bundle/ruby/3.4.0/gems/activesupport-8.1.3/lib/active_support/callbacks.rb:110:in 'ActiveSupport::Callbacks#run_callbacks'","/usr/local/bundle/ruby/3.4.0/gems/activesupport-8.1.3/lib/active_support/callbacks.rb:916:in 'Namespace#_run_create_callbacks!'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/callbacks.rb:445:in 'ActiveRecord::Callbacks#_create_record'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/timestamp.rb:116:in 'ActiveRecord::Timestamp#_create_record'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/persistence.rb:925:in 'ActiveRecord::Persistence#create_or_update'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/callbacks.rb:441:in 'block in ActiveRecord::Callbacks#create_or_update'","/usr/local/bundle/ruby/3.4.0/gems/activesupport-8.1.3/lib/active_support/callbacks.rb:121:in 'block in ActiveSupport::Callbacks#run_callbacks'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/autosave_association.rb:406:in 'ActiveRecord::AutosaveAssociation#around_save_collection_association'","/usr/local/bundle/ruby/3.4.0/gems/activesupport-8.1.3/lib/active_support/callbacks.rb:130:in 'block in ActiveSupport::Callbacks#run_callbacks'","/usr/local/bundle/ruby/3.4.0/gems/activesupport-8.1.3/lib/active_support/callbacks.rb:141:in 'ActiveSupport::Callbacks#run_callbacks'","/usr/local/bundle/ruby/3.4.0/gems/activesupport-8.1.3/lib/active_support/callbacks.rb:916:in 'Namespace#_run_save_callbacks!'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/callbacks.rb:441:in 'ActiveRecord::Callbacks#create_or_update'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/timestamp.rb:127:in 'ActiveRecord::Timestamp#create_or_update'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/persistence.rb:391:in 'ActiveRecord::Persistence#save'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/validations.rb:48:in 'ActiveRecord::Validations#save'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/transactions.rb:381:in 'block in ActiveRecord::Transactions#save'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/transactions.rb:438:in 'block (3 levels) in ActiveRecord::Transactions#with_transaction_returning_status'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/abstract/transaction.rb:648:in 'block in ActiveRecord::ConnectionAdapters::TransactionManager#within_new_transaction'","/usr/local/bundle/ruby/3.4.0/gems/activesupport-8.1.3/lib/active_support/concurrency/null_lock.rb:9:in 'ActiveSupport::Concurrency::NullLock#synchronize'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/abstract/transaction.rb:645:in 'ActiveRecord::ConnectionAdapters::TransactionManager#within_new_transaction'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/abstract/database_statements.rb:386:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#within_new_transaction'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/abstract/database_statements.rb:378:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#transaction'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/transactions.rb:434:in 'block (2 levels) in ActiveRecord::Transactions#with_transaction_returning_status'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:485:in 'ActiveRecord::ConnectionAdapters::ConnectionPool#with_pool_transaction_isolation_level'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/transactions.rb:430:in 'block in ActiveRecord::Transactions#with_transaction_returning_status'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:463:in 'ActiveRecord::ConnectionAdapters::ConnectionPool#with_connection'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/connection_handling.rb:313:in 'ActiveRecord::ConnectionHandling#with_connection'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/transactions.rb:429:in 'ActiveRecord::Transactions#with_transaction_returning_status'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/transactions.rb:381:in 'ActiveRecord::Transactions#save'","/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.1.3/lib/active_record/suppressor.rb:52:in 'ActiveRecord::Suppressor#save'","/sagittarius/app/models/concerns/namespace_parent.rb:15:in 'NamespaceParent#ensure_namespace'","/usr/local/bundle/ruby/3.4.0/gems/graphql-2.6.5/lib/graphql/schema/field.rb:784:in 'Kernel#public_send'","/usr/local/bundle/ruby/3.4.0/gems/graphql-2.6.5/lib/graphql/schema/field.rb:784:in 'block (2 levels) in GraphQL::Schema::Field#resolve'","/usr/local/bundle/ruby/3.4.0/gems/graphql-2.6.5/lib/graphql/schema/field.rb:896:in 'GraphQL::Schema::Field#with_extensions'","/usr/local/bundle/ruby/3.4.0/gems/graphql-2.6.5/lib/graphql/schema/field.rb:733:in 'block in GraphQL::Schema::Field#resolve'","/usr/local/bundle/ruby/3.4.0/gems/graphql-2.6.5/lib/graphql/execution/interpreter/runtime.rb:898:in 'GraphQL::Execution::Interpreter::Runtime#minimal_after_lazy'","/usr/local/bundle/ruby/3.4.0/gems/graphql-2.6.5/lib/graphql/query.rb:28:in 'GraphQL::Query::Runnable#after_lazy'","/usr/local/bundle/ruby/3.4.0/gems/graphql-2.6.5/lib/graphql/schema/field.rb:731:in 'GraphQL::Schema::Field#resolve'","/usr/local/bundle/ruby/3.4.0/gems/graphql-2.6.5/lib/graphql/execution/interpreter/runtime.rb:468:in 'block (2 levels) in GraphQL::Execution::Interpreter::Runtime#evaluate_selection_with_resolved_keyword_args'","/usr/local/bundle/ruby/3.4.0/gems/graphql-2.6.5/lib/graphql/tracing/trace.rb:90:in 'GraphQL::Tracing::Trace#execute_field'","/usr/local/bundle/ruby/3.4.0/gems/graphql-2.6.5/lib/graphql/execution/interpreter/runtime.rb:467:in 'block in GraphQL::Execution::Interpreter::Runtime#evaluate_selection_with_resolved_keyword_args'","/usr/local/bundle/ruby/3.4.0/gems/graphql-2.6.5/lib/graphql/execution/interpreter/runtime.rb:816:in 'GraphQL::Execution::Interpreter::Runtime#call_method_on_directives'","/usr/local/bundle/ruby/3.4.0/gems/graphql-2.6.5/lib/graphql/execution/interpreter/runtime.rb:455:in 'GraphQL::Execution::Interpreter::Runtime#evaluate_selection_with_resolved_keyword_args'","/usr/local/bundle/ruby/3.4.0/gems/graphql-2.6.5/lib/graphql/execution/interpreter/runtime.rb:359:in 'GraphQL::Execution::Interpreter::Runtime#evaluate_selection'","/usr/local/bundle/ruby/3.4.0/gems/graphql-2.6.5/lib/graphql/execution/interpreter/runtime.rb:315:in 'block (3 levels) in GraphQL::Execution::Interpreter::Runtime#evaluate_selections'","/usr/local/bundle/ruby/3.4.0/gems/graphql-2.6.5/lib/graphql/dataloader.rb:352:in 'block in GraphQL::Dataloader#spawn_job_fiber'","/usr/local/bundle/ruby/3.4.0/gems/graphql-2.6.5/lib/graphql/dataloader.rb:254:in 'block in GraphQL::Dataloader#spawn_fiber'"],"exception_class":"ActiveRecord::RecordNotUnique","correlation_id":"0475f7eb-90c3-4a86-b11c-cb945fc7d828","meta.application":"puma","meta.ip_address":"192.168.65.1","meta.user":{"id":2,"username":"root"},"meta.class":"GraphqlController"}

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    Fields

    System

    IDE

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions