Details
-
Bug
-
Resolution: Fixed
-
Highest
-
6.1.6, 6.2-OD-3, 6.3.9
-
6.01
-
Description
NOTE: This bug report is for JIRA Server. Using JIRA Cloud? See the corresponding bug report.
Steps to reproduce
- Start with JIRA < 6.2-OD-3/icebat-85.0.
- Create a custom issue status, which is created with an ID of 10000.
- Upgrade to JIRA 6.2-OD-3/icebat-85.0.
- Try to create another issue status, and you'll receive a stack trace:
com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][id,10000][sequence,12][description,null][name,A New Status][statuscategory,1][iconurl,/images/icons/statuses/generic.png] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_issuestatus")) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:395) at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:219) at com.atlassian.jira.config.AbstractIssueConstantsManager.createConstant(AbstractIssueConstantsManager.java:38) at com.atlassian.jira.config.DefaultStatusManager.createStatus(DefaultStatusManager.java:73) at com.atlassian.jira.bc.config.DefaultStatusService.createStatus(DefaultStatusService.java:75) at com.atlassian.jira.web.action.admin.statuses.ViewStatuses.addConstant(ViewStatuses.java:196) at com.atlassian.jira.web.action.admin.constants.AbstractViewConstants.doAddConstant(AbstractViewConstants.java:42) at com.atlassian.jira.web.action.admin.statuses.ViewStatuses.doAddStatus(ViewStatuses.java:134) 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 webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:70) [...]
Try to create it a second time and it'll work fine, as the new status is then created with an ID of 10001. The more custom issue statuses already exist in an instance, the more times you have to click Add in order to get past the latest ID.
Workaround
If on OnDemand contact support, support will:
- Shutdown JIRA
- Backup the database
- Identify the current maximum value of the issuestatus id
select id::integer from issuestatus order by id desc limit 1;
- Update the sequence_value_item table to define the Status sequence ID as 1 higher than the value identified in the previous step
update sequence_value_item set seq_id = <value from above + 1> where seq_name = 'Status';
- Start JIRA back up.
Attachments
Issue Links
- is duplicated by
-
CLOUD-6938 When the new "state", appears ERROR: duplicate key value violates unique constraint "pk_issuestatus"
- Closed
-
JRACLOUD-66129 Jira error when I try to add a new status.
- Closed
-
JRACLOUD-66320 Unable To Create New Status' in JIRA OnDemand Instance
- Closed
-
CLOUD-6937 505 Error when trying to create a new status
- Closed
-
JRASERVER-35899 Cannot create new statuses
- Closed
-
JRACLOUD-66273 we got error on adding new status
- Closed
-
JRACLOUD-66648 Adding Status Fails
- Closed
-
JRACLOUD-66681 Not possible to add a new status
- Closed
-
JRASERVER-35905 Attempting to add a new Status for a new workflow
- Closed
- is related to
-
JRACLOUD-66115 JRA-35857 applies to mojomaritime.atlassian.net too.
- Closed
- relates to
-
JRACLOUD-35857 JIRA unable to create statuses after upgrade to 6.2-OD-3/icebat-85.0 if there's previously been custom statuses created
- Closed
- was cloned as
-
JRACLOUD-66115 JRA-35857 applies to mojomaritime.atlassian.net too.
- Closed
- mentioned in
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...