Details
-
Bug
-
Resolution: Fixed
-
Highest
-
None
Description
Summary
When attempting to load projects, access boards or access the Service Desk queue, certain projects return an error code 500 and a duplicate code error.
The errors are different for each instance Duplicate key [14400] , Duplicate key [aparker], Duplicate key [Version].
Investigation Done
Problem seems to happen to instances that have been updated recently and only happen to specific projects.
Instance has issues with the duplicate key when opening specific boards and also when viewing a specific SD project queue.
AJAX error is also seen when the duplicate key error is returned.
ajax[64818760] error : { successful : false, status : 500, statusText : error, hasData : true, readyState : 4, requestId : 64818760, aborted : undefined, }
Even on the same instance, the duplicate key error is different. For example :
When attempting to view Service Desk queues, the error below is returned.
2016-03-29 11:18:15.619514500 2016-03-29 11:18:15,617 http-nio-3006-exec-63 INFO anonymous 678x28085x3 9cx1ua 104.192.142.137 /rest/userprovisioning/1/is-site-admin [c.a.u.client.filters.UserProvisioningAsapAuthenticationFilter] Received request to ASAP protected resource without ASAP authentication 2016-03-29 11:18:17.422935500 2016-03-29 11:18:17,417 http-nio-3006-exec-60 ERROR sysadmin 678x28092x1 9cx1ua 104.192.142.137 /rest/servicedesk/1/servicedesk/ASS/queues/page [c.a.p.r.c.error.jersey.ThrowableExceptionMapper] Uncaught exception thrown by REST service: Duplicate key [10100] 2016-03-29 11:18:17.422938500 java.lang.IllegalStateException: Duplicate key [10100] 2016-03-29 11:18:17.422938500 at java.util.stream.Collectors.lambda$throwingMerger$130(Collectors.java:133) 2016-03-29 11:18:17.422939500 at java.util.stream.Collectors$$Lambda$72/12813389.apply(Unknown Source) 2016-03-29 11:18:17.422980500 at java.util.HashMap.merge(HashMap.java:1245) 2016-03-29 11:18:17.422980500 at java.util.stream.Collectors.lambda$toMap$188(Collectors.java:1320) 2016-03-29 11:18:17.422980500 at java.util.stream.Collectors$$Lambda$74/20421524.accept(Unknown Source) 2016-03-29 11:18:17.422981500 at java.util.stream.ReduceOps$3ReducingSink.accept(ReduceOps.java:169) 2016-03-29 11:18:17.422981500 at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1374) 2016-03-29 11:18:17.422986500 at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:512)
When loading board however.
2016-03-29 14:07:13.591779500 2016-03-29 14:07:13,590 http-nio-3006-exec-166 ERROR sysadmin 847x37958x1 gmoow3 104.192.142.137 /rest/greenhopper/1.0/xboard/work/allData.json [c.a.p.r.c.error.jersey.ThrowableExceptionMapper] Uncaught exception thrown by REST service: Duplicate key [14400] 2016-03-29 14:07:13.591781500 java.lang.IllegalStateException: Duplicate key [14400] 2016-03-29 14:07:13.591781500 at java.util.stream.Collectors.lambda$throwingMerger$130(Collectors.java:133) 2016-03-29 14:07:13.591781500 at java.util.stream.Collectors$$Lambda$72/12813389.apply(Unknown Source) 2016-03-29 14:07:13.591795500 at java.util.HashMap.merge(HashMap.java:1245) 2016-03-29 14:07:13.591795500 at java.util.stream.Collectors.lambda$toMap$188(Collectors.java:1320) 2016-03-29 14:07:13.591795500 at java.util.stream.Collectors$$Lambda$74/20421524.accept(Unknown Source) 2016-03-29 14:07:13.591796500 at java.util.stream.ReduceOps$3ReducingSink.accept(ReduceOps.java:169) 2016-03-29 14:07:13.591796500 at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1374) 2016-03-29 14:07:13.591801500 at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:512) 2016-03-29 14:07:13.591801500 at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:502) 2016-03-29 14:07:13.591801500 at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708) 2016-03-29 14:07:13.591807500 at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) 2016-03-29 14:07:13.591807500 at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:499) 2016-03-29 14:07:13.591808500 at com.atlassian.jira.jql.resolver.IndexInfoResolver.getIndexedStringValues(IndexInfoResolver.java:42) 2016-03-29 14:07:13.591808500 at com.atlassian.jira.jql.query.AbstractOperatorQueryFactory.getIndexValues(AbstractOperatorQueryFactory.java:53) 2016-03-29 14:07:13.591812500 at com.atlassian.jira.jql.query.AbstractEqualityQueryFactory.createQueryForMultipleValues(AbstractEqualityQueryFactory.java:41) 2016-03-29 14:07:13.591813500 at com.atlassian.jira.jql.query.GenericClauseQueryFactory.getQuery(GenericClauseQueryFactory.java:57) 2016-03-29 14:07:13.591813500 at com.atlassian.jira.jql.query.ProjectClauseQueryFactory.getQuery(ProjectClauseQueryFactory.java:31) 2016-03-29 14:07:13.591818500 at com.atlassian.jira.jql.query.ContextAwareQueryVisitor.visit(ContextAwareQueryVisitor.java:97) 2016-03-29 14:07:13.591818500 at com.atlassian.jira.jql.query.ContextAwareQueryVisitor.visit(ContextAwareQueryVisitor.java:25)
Workaround
Some instances of the problem are known to occur when JQL is used that contains duplicate values. For example, issuing the search fixVersion IN (1.0, 1.0) will trigger this problem. This will also impact Boards and Service Desk queues (as they base the issues returned on JQL searches).
A potential workaround (NOTE: unconfirmed) would be to ensure that your Board or Queue does not contain any JQL with duplicate values. Removing the duplicate should have no impact as it is redundant.
Attachments
Issue Links
- is duplicated by
-
JDEV-36733 Loading...
-
JSEV-170 Loading...
- relates to
-
HOT-38923 Loading...