com.atlassian.jira.exception.DataAccessException: Failed to remove priority '6'

Atlassian JIRA | Andromeda Sain [Atlassian] | 5 years ago
  1. 0

    # _Administration >> Issues >> Issues Attributes >> Priorities >> Add 'New Priority' >> Add_ # _Create Issue >> Set Issue Priority >> 'New Priority' >> Create_ # _Administration >> Issues >> Priorities >> Delete 'New Priority' >> Set New Priority for Matching Issues >> Delete >> *System Error*_ {noformat} com.atlassian.jira.exception.DataAccessException: Failed to remove priority '6' at com.atlassian.jira.config.DefaultPriorityManager.removePriority(DefaultPriorityManager.java:134) at com.atlassian.jira.web.action.admin.priorities.DeletePriority.doExecute(DeletePriority.java:69) at webwork.action.ActionSupport.execute(ActionSupport.java:165) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:82) 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:205) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:143) at com.atlassian.jira.web.dispatcher.JiraWebworkActionDispatcher.service(JiraWebworkActionDispatcher.java:152) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) {noformat} All issues which have priority going to be deleted should be moved to the intended priority but it is not working. h4. Workaround: Do bulk edit to all the issues with the priority level that need to be deleted. Change all of them to another priority level, and then delete the intended priority level.

    Atlassian JIRA | 5 years ago | Andromeda Sain [Atlassian]
    com.atlassian.jira.exception.DataAccessException: Failed to remove priority '6'
  2. 0

    # _Administration >> Issues >> Issues Attributes >> Priorities >> Add 'New Priority' >> Add_ # _Create Issue >> Set Issue Priority >> 'New Priority' >> Create_ # _Administration >> Issues >> Priorities >> Delete 'New Priority' >> Set New Priority for Matching Issues >> Delete >> *System Error*_ {noformat} com.atlassian.jira.exception.DataAccessException: Failed to remove priority '6' at com.atlassian.jira.config.DefaultPriorityManager.removePriority(DefaultPriorityManager.java:134) at com.atlassian.jira.web.action.admin.priorities.DeletePriority.doExecute(DeletePriority.java:69) at webwork.action.ActionSupport.execute(ActionSupport.java:165) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:82) 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:205) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:143) at com.atlassian.jira.web.dispatcher.JiraWebworkActionDispatcher.service(JiraWebworkActionDispatcher.java:152) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) {noformat} All issues which have priority going to be deleted should be moved to the intended priority but it is not working. h4. Workaround: Do bulk edit to all the issues with the priority level that need to be deleted. Change all of them to another priority level, and then delete the intended priority level.

    Atlassian JIRA | 5 years ago | Andromeda Sain [Atlassian]
    com.atlassian.jira.exception.DataAccessException: Failed to remove priority '6'
  3. 0

    Version name: "this is not a version" Stack trace: 2011-11-07 16:52:30,110 http-8080-13 INFO admin 1012x1084x2 1mhke8u 172.20.9.85 /rest/greenhopper/1.0/release [greenhopper.service.version.ReleaseServiceImpl] creating versions in projects: [Project: ARA, Project: BULK, Project: XSS] 2011-11-07 16:52:30,126 http-8080-13 ERROR admin 1012x1084x2 1mhke8u 172.20.9.85 /rest/greenhopper/1.0/release [greenhopper.service.version.ReleaseServiceImpl] org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Version][id,10040][project,10031 ][description,URGHH][sequence,6][name,this is not a version][releasedate,2011-11-07 00:00:00.0] (SQL Exception while executing the following:INSERT INTO public.projectversion (ID, PROJECT, vname, DESCRIPTION, SEQUENCE, RELEASED, ARCHIVED, URL, RELEASEDATE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_projectversion")) com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Version][id,10040][project,10031][description,URGHH][sequence,6][name,this is not a version][releasedate,2011-11-07 00:00:00.0] (SQL Exception while executing the following:INSERT INTO public.projectversion (ID, PROJECT, vname, DESCRIPTION, SEQUENCE, RELEASED, ARCHIVED, URL, RELEASEDATE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_projectversion")) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:365) at com.atlassian.jira.project.version.OfBizVersionStore.createVersion(OfBizVersionStore.java:35) at com.atlassian.jira.project.version.CachingVersionStore.createVersion(CachingVersionStore.java:79) at com.atlassian.jira.project.version.DefaultVersionManager.createVersion(DefaultVersionManager.java:118) at com.atlassian.jira.bc.project.version.DefaultVersionService.createVersion(DefaultVersionService.java:528) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.atlassian.multitenant.impl.MultiTenantComponentFactoryImpl$AbstractMultiTenantAwareInvocationHandler.invokeInternal(MultiTenantComponentFactoryImpl.java:181) at com.atlassian.multitenant.impl.MultiTenantComponentFactoryImpl$MultiTenantAwareInvocationHandler.invoke(MultiTenantComponentFactoryImpl.java:211) at $Proxy185.createVersion(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129) at $Proxy185.createVersion(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:154) at $Proxy185.createVersion(Unknown Source) at com.atlassian.greenhopper.service.version.VersionServiceImpl.createVersions(VersionServiceImpl.java:79)

    Atlassian JIRA | 5 years ago | Kara Hatherly
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Version][id,10040][project,10031][description,URGHH][sequence,6][name,this is not a version][releasedate,2011-11-07 00:00:00.0] (SQL Exception while executing the following:INSERT INTO public.projectversion (ID, PROJECT, vname, DESCRIPTION, SEQUENCE, RELEASED, ARCHIVED, URL, RELEASEDATE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_projectversion"))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    There is a spelling mistake of *esablish* which suppose to be *establish* in bq. Unable to esablish a connection with the database. Also, when we are at it, is it possible to further improve the error thrown to sent more clearer message? h4. Steps to reproduce: # Start JIRA that is connected to external database (eg. MySQL) # Go to Issue Navigator # Stop MySQL service # Click on one of the issue in the Issue Navigator h4. Error thrown: !esablish.PNG|thumbnail! {noformat} Cause: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a connection with the database. (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.) Stack Trace: [hide] com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a connection with the database. (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByAnd(DefaultOfBizDelegator.java:94) at com.atlassian.jira.issue.managers.DefaultIssueManager.getIssue(DefaultIssueManager.java:114) at com.atlassian.jira.issue.managers.DefaultIssueManager.getIssueObject(DefaultIssueManager.java:306) at com.atlassian.jira.servlet.QuickLinkServlet.linkToIssue(QuickLinkServlet.java:139) at com.atlassian.jira.servlet.QuickLinkServlet.service(QuickLinkServlet.java:46) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:78) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243){noformat}

    Atlassian JIRA | 4 years ago | Zulfadli Noor Sazali [Atlassian]
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a connection with the database. (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
  6. 0

    Hi Bob, We are using atlassian-cli-3.9.0 and JIRA version 5.4.12. We are using following command to delete some projects: jira --action deleteProject --project "prokjectKey" The above command is working fine for most of the projects but in some cases this fails to delete projects. We have experienced following error in JIRA log: ------------------- 2016-05-08 10:54:44,476 http-bio-8080-exec-118 ERROR anonymous 638x278692x1 - 172.18.16.166,172.18.13.241,172.18.14.165 /rpc/soap/jirasoapservice-v2 [atlassian.jira.project.DefaultProjectManager] Exception removing issues com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM moved_issue_key WHERE ISSUE_ID=? (Deadlock found when trying to get lock; try restarting transaction)) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.removeByAnd(DefaultOfBizDelegator.java:311) ---------------------- On command line interface we are getting below error message: --------------------- Remote error: ; nested exception is: java.net.SocketException: Connection reset Sun May 8 10:43:36 GMT 2016 Could not deleted Project with key: AU --------------------- Once we checked the database, then we found that some of the projects are not deleted but some of them were deleted in spite of these errors. So my question is that can you please confirm that whether these deleted projects are deleted successfully along with their related data or only partial data were removed of deleted projects as during deletion we were getting above error. Can you please suggest any solution in order to prevent these errors, as we have so many projects (about 1600) to delete. Thanks, Reetesh

    JIRA | 7 months ago | Reetesh Kumar
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM moved_issue_key WHERE ISSUE_ID=? (Deadlock found when trying to get lock; try restarting transaction))

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.atlassian.jira.exception.DataAccessException

      Failed to remove priority '6'

      at com.atlassian.jira.config.DefaultPriorityManager.removePriority()
    2. com.atlassian.jira
      DeletePriority.doExecute
      1. com.atlassian.jira.config.DefaultPriorityManager.removePriority(DefaultPriorityManager.java:134)
      2. com.atlassian.jira.web.action.admin.priorities.DeletePriority.doExecute(DeletePriority.java:69)
      2 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:82)
      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:205)
      2. webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:143)
      2 frames
    7. com.atlassian.jira
      JiraWebworkActionDispatcher.service
      1. com.atlassian.jira.web.dispatcher.JiraWebworkActionDispatcher.service(JiraWebworkActionDispatcher.java:152)
      1 frame
    8. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      1 frame