com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:UserAssociation][sinkNodeId,164381][created,2013-07-21 23:26:50.249][associationType,WatchIssue][sourceName,cchauvet][sinkNodeEntity,Issue] (SQL Exception while executing the following:INSERT INTO public.userassociation (SOURCE_NAME, SINK_NODE_ID, SINK_NODE_ENTITY, ASSOCIATION_TYPE, SEQUENCE, CREATED) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_userassociation" Detail: Key (source_name, sink_node_id, sink_node_entity, association_type)=(cchauvet, 164381, Issue, WatchIssue) already exists.))

Atlassian JIRA | Eric Dalgliesh | 4 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Clicking on the "Watch Issue" link can give you this stack trace: {noformat} com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:UserAssociation][sinkNodeId,164381][created,2013-07-21 23:26:50.249][associationType,WatchIssue][sourceName,cchauvet][sinkNodeEntity,Issue] (SQL Exception while executing the following:INSERT INTO public.userassociation (SOURCE_NAME, SINK_NODE_ID, SINK_NODE_ENTITY, ASSOCIATION_TYPE, SEQUENCE, CREATED) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_userassociation" Detail: Key (source_name, sink_node_id, sink_node_entity, association_type)=(cchauvet, 164381, Issue, WatchIssue) already exists.)) at com.atlassian.jira.association.UserAssociationStoreImpl.createAssociation(UserAssociationStoreImpl.java:67) at com.atlassian.jira.association.UserAssociationStoreImpl.createAssociation(UserAssociationStoreImpl.java:46) at com.atlassian.jira.issue.watchers.DefaultWatcherManager.updateWatch(DefaultWatcherManager.java:206) at com.atlassian.jira.issue.watchers.DefaultWatcherManager.updateWatch(DefaultWatcherManager.java:193) at com.atlassian.jira.issue.watchers.DefaultWatcherManager.startWatching(DefaultWatcherManager.java:80) at com.atlassian.jira.web.action.issue.VoteOrWatchIssue.doExecute(VoteOrWatchIssue.java:66) at webwork.action.ActionSupport.execute(ActionSupport.java:165) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:83) at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:39) at webwork.interceptor.NestedInterceptorChain.proceed(NestedInterceptorChain.java:31) at webwork.interceptor.ChainedInterceptor.intercept(ChainedInterceptor.java:16) at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:35) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:225) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:154) at com.atlassian.jira.web.dispatcher.JiraWebworkActionDispatcher.service(JiraWebworkActionDispatcher.java:151) {noformat}

    Atlassian JIRA | 4 years ago | Eric Dalgliesh
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:UserAssociation][sinkNodeId,164381][created,2013-07-21 23:26:50.249][associationType,WatchIssue][sourceName,cchauvet][sinkNodeEntity,Issue] (SQL Exception while executing the following:INSERT INTO public.userassociation (SOURCE_NAME, SINK_NODE_ID, SINK_NODE_ENTITY, ASSOCIATION_TYPE, SEQUENCE, CREATED) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_userassociation" Detail: Key (source_name, sink_node_id, sink_node_entity, association_type)=(cchauvet, 164381, Issue, WatchIssue) already exists.))
  2. 0

    Clicking on the "Watch Issue" link can give you this stack trace: {noformat} com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:UserAssociation][sinkNodeId,164381][created,2013-07-21 23:26:50.249][associationType,WatchIssue][sourceName,cchauvet][sinkNodeEntity,Issue] (SQL Exception while executing the following:INSERT INTO public.userassociation (SOURCE_NAME, SINK_NODE_ID, SINK_NODE_ENTITY, ASSOCIATION_TYPE, SEQUENCE, CREATED) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_userassociation" Detail: Key (source_name, sink_node_id, sink_node_entity, association_type)=(cchauvet, 164381, Issue, WatchIssue) already exists.)) at com.atlassian.jira.association.UserAssociationStoreImpl.createAssociation(UserAssociationStoreImpl.java:67) at com.atlassian.jira.association.UserAssociationStoreImpl.createAssociation(UserAssociationStoreImpl.java:46) at com.atlassian.jira.issue.watchers.DefaultWatcherManager.updateWatch(DefaultWatcherManager.java:206) at com.atlassian.jira.issue.watchers.DefaultWatcherManager.updateWatch(DefaultWatcherManager.java:193) at com.atlassian.jira.issue.watchers.DefaultWatcherManager.startWatching(DefaultWatcherManager.java:80) at com.atlassian.jira.web.action.issue.VoteOrWatchIssue.doExecute(VoteOrWatchIssue.java:66) at webwork.action.ActionSupport.execute(ActionSupport.java:165) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:83) at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:39) at webwork.interceptor.NestedInterceptorChain.proceed(NestedInterceptorChain.java:31) at webwork.interceptor.ChainedInterceptor.intercept(ChainedInterceptor.java:16) at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:35) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:225) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:154) at com.atlassian.jira.web.dispatcher.JiraWebworkActionDispatcher.service(JiraWebworkActionDispatcher.java:151) {noformat}

    Atlassian JIRA | 4 years ago | Eric Dalgliesh
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:UserAssociation][sinkNodeId,164381][created,2013-07-21 23:26:50.249][associationType,WatchIssue][sourceName,cchauvet][sinkNodeEntity,Issue] (SQL Exception while executing the following:INSERT INTO public.userassociation (SOURCE_NAME, SINK_NODE_ID, SINK_NODE_ENTITY, ASSOCIATION_TYPE, SEQUENCE, CREATED) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_userassociation" Detail: Key (source_name, sink_node_id, sink_node_entity, association_type)=(cchauvet, 164381, Issue, WatchIssue) already exists.))

    Root Cause Analysis

    1. com.atlassian.jira.exception.DataAccessException

      org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:UserAssociation][sinkNodeId,164381][created,2013-07-21 23:26:50.249][associationType,WatchIssue][sourceName,cchauvet][sinkNodeEntity,Issue] (SQL Exception while executing the following:INSERT INTO public.userassociation (SOURCE_NAME, SINK_NODE_ID, SINK_NODE_ENTITY, ASSOCIATION_TYPE, SEQUENCE, CREATED) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_userassociation" Detail: Key (source_name, sink_node_id, sink_node_entity, association_type)=(cchauvet, 164381, Issue, WatchIssue) already exists.))

      at com.atlassian.jira.association.UserAssociationStoreImpl.createAssociation()
    2. com.atlassian.jira
      VoteOrWatchIssue.doExecute
      1. com.atlassian.jira.association.UserAssociationStoreImpl.createAssociation(UserAssociationStoreImpl.java:67)
      2. com.atlassian.jira.association.UserAssociationStoreImpl.createAssociation(UserAssociationStoreImpl.java:46)
      3. com.atlassian.jira.issue.watchers.DefaultWatcherManager.updateWatch(DefaultWatcherManager.java:206)
      4. com.atlassian.jira.issue.watchers.DefaultWatcherManager.updateWatch(DefaultWatcherManager.java:193)
      5. com.atlassian.jira.issue.watchers.DefaultWatcherManager.startWatching(DefaultWatcherManager.java:80)
      6. com.atlassian.jira.web.action.issue.VoteOrWatchIssue.doExecute(VoteOrWatchIssue.java:66)
      6 frames
    3. webwork.action
      ActionSupport.execute
      1. webwork.action.ActionSupport.execute(ActionSupport.java:165)
      1 frame
    4. com.atlassian.jira
      JiraActionSupport.execute
      1. com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:83)
      1 frame
    5. webwork.interceptor
      DefaultInterceptorChain.proceed
      1. webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:39)
      2. webwork.interceptor.NestedInterceptorChain.proceed(NestedInterceptorChain.java:31)
      3. webwork.interceptor.ChainedInterceptor.intercept(ChainedInterceptor.java:16)
      4. webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:35)
      4 frames
    6. webwork.dispatcher
      GenericDispatcher.executeAction
      1. webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:225)
      2. webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:154)
      2 frames
    7. com.atlassian.jira
      JiraWebworkActionDispatcher.service
      1. com.atlassian.jira.web.dispatcher.JiraWebworkActionDispatcher.service(JiraWebworkActionDispatcher.java:151)
      1 frame