javax.servlet.ServletException: query did not return a unique result: 2

redhat.com | 3 months ago
  1. 0

    RHNS 5.3.1 generates traceback "query did not return a unique result" - Red Hat Customer Portal

    redhat.com | 3 months ago
    javax.servlet.ServletException: query did not return a unique result: 2
  2. 0

    you basically end up with two different stored paths with the same path. stack trace when loading a review with with one of these invalid stored paths: [java] ERROR - Problem getting previous revisions [java] org.hibernate.NonUniqueResultException: query did not return a unique result: 2 [java] at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:820) [java] at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811) [java] at com.cenqua.crucible.model.managers.StoredPathManager.findStoredPath(StoredPathManager.java:29) [java] at com.cenqua.crucible.model.managers.FileRevisionManager.findRevision(FileRevisionManager.java:115) [java] at com.cenqua.crucible.revision.managers.DefaultContentManager.getLazyCrucibleRevision(DefaultContentManager.java:367) [java] at com.cenqua.crucible.revision.managers.DefaultContentManager.getLazyCrucibleRevision(DefaultContentManager.java:363) [java] at com.cenqua.crucible.view.RevInfoDO.annotateFileHistory(RevInfoDO.java:120) [java] at com.cenqua.crucible.view.RevInfoDO.processFileRevisions(RevInfoDO.java:77) [java] at com.cenqua.crucible.view.RevInfoDO.<init>(RevInfoDO.java:58) [java] at com.cenqua.crucible.view.FRXDO$AnnotatedFileHistory.getRevInfoDO(FRXDO.java:108) [java] at com.cenqua.crucible.view.FRXDO.getCanProvideAnnotatedFileHistory(FRXDO.java:1017) [java] at sun.reflect.GeneratedMethodAccessor344.invoke(Unknown Source) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [java] at java.lang.reflect.Method.invoke(Method.java:585) [java] at javax.el.BeanELResolver.getValue(BeanELResolver.java:293) [java] at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:175) [java] at com.sun.el.parser.AstValue.getValue(AstValue.java:138) [java] at com.sun.el.parser.AstAnd.getValue(AstAnd.java:54) [java] at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:206) [java] at org.apache.jasper.runtime.PageContextImpl.evaluateExpression(PageContextImpl.java:1001) [java] at org.apache.jsp.tag.web.review.frxControls_tag._jspx_meth_c_if_4(org.apache.jsp.tag.web.review.frxControls_tag:494) [java] at org.apache.jsp.tag.web.review.frxControls_tag.doTag(org.apache.jsp.tag.web.review.frxControls_tag:175) [java] at org.apache.jsp.tag.web.review.reviewPage_tag._jspx_meth_rev_frxControls_0(org.apache.jsp.tag.web.review.reviewPage_tag:5585) [java] at org.apache.jsp.tag.web.review.reviewPage_tag._jspx_meth_c_forEach_32(org.apache.jsp.tag.web.review.reviewPage_tag:5528) [java] at org.apache.jsp.tag.web.review.reviewPage_tag._jspx_meth_c_when_9(org.apache.jsp.tag.web.review.reviewPage_tag:5495) [java] at org.apache.jsp.tag.web.review.reviewPage_tag._jspx_meth_c_choose_6(org.apache.jsp.tag.web.review.reviewPage_tag:5461) [java] at org.apache.jsp.tag.web.review.reviewPage_tag.doTag(org.apache.jsp.tag.web.review.reviewPage_tag:937) [java] at org.apache.jsp.WEB_002dINF.jsp.crucible.review.monolithic.review_jsp._jspx_meth_rev_reviewPage_0(org.apache.jsp.WEB_002dINF.jsp.crucible.review.monolithic.review_jsp:145) [java] at org.apache.jsp.WEB_002dINF.jsp.crucible.review.monolithic.review_jsp._jspService(org.apache.jsp.WEB_002dINF.jsp.crucible.review.monolithic.review_jsp:118) [java] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109) [java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) [java] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389) [java] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486) [java] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380) [java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) [java] at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1208) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.crucible.filters.CrucibleFilter.doFilter(CrucibleFilter.java:118) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:159) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) [java] at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) [java] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) [java] at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) [java] at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) [java] at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) [java] at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) [java] at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:334) [java] at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126) [java] at com.opensymphony.webwork.dispatcher.ServletDispatcherResult.doExecute(ServletDispatcherResult.java:114) [java] at com.opensymphony.webwork.dispatcher.WebWorkResultSupport.execute(WebWorkResultSupport.java:143) [java] at com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:313) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:208) [java] at com.cenqua.crucible.interceptors.ReviewInterceptor.intercept(ReviewInterceptor.java:49) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.cenqua.crucible.interceptors.CruciblePermissionInterceptor.intercept(CruciblePermissionInterceptor.java:40) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.cenqua.crucible.interceptors.HasCrucibleInterceptor.intercept(HasCrucibleInterceptor.java:27) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:186) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) [java] at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:273) [java] at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:111) [java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) [java] at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1208) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83) [java] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.crucible.filters.CrucibleFilter.doFilter(CrucibleFilter.java:118) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:224) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) [java] at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) [java] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) [java] at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) [java] at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) [java] at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) [java] at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) [java] at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:334) [java] at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126) [java] at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:145) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) [java] at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) [java] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:81) [java] at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:129) [java] at com.cenqua.fisheye.web.filters.CustomIncludableGzipFilter.doFilter(CustomIncludableGzipFilter.java:21) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.fisheye.web.filters.ProductInfoFilter.doFilter(ProductInfoFilter.java:36) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.fisheye.web.filters.UpfrontFilter.doFilter(UpfrontFilter.java:59) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) [java] at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) [java] at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) [java] at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) [java] at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) [java] at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230) [java] at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) [java] at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) [java] at org.mortbay.jetty.Server.handle(Server.java:324) [java] at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535) [java] at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:865) [java] at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:539) [java] at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) [java] at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) [java] at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) [java] at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:451)

    Atlassian JIRA | 7 years ago | Geoff Crain [Atlassian]
    org.hibernate.NonUniqueResultException: query did not return a unique result: 2
  3. 0

    One particular user gets following error in UI (as seen in attachment). Seems that this error does not affect other users but there are also errors in the logs with similar text but without reference to any particular user. Server log about error: ERROR - /cru/CRLBO-648/edit-changelog/~author=ildar/Product/ javax.el.ELException: org.hibernate.NonUniqueResultException: query did not return a unique result: 2 at javax.el.BeanELResolver.getValue(BeanELResolver.java:298) at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:175) at com.sun.el.parser.AstValue.getValue(AstValue.java:138) at com.sun.el.parser.AstEmpty.getValue(AstEmpty.java:62) at com.sun.el.parser.AstNot.getValue(AstNot.java:59) at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:206) at org.apache.jasper.runtime.PageContextImpl.evaluateExpression(PageContextImpl.java:1001) at org.apache.jsp.WEB_002dINF.jsp.crucible.create.edit_005fselectRevisions_jsp._jspx_meth_c_when_5(edit_005fselectRevisions_jsp.java:2869) at org.apache.jsp.WEB_002dINF.jsp.crucible.create.edit_005fselectRevisions_jsp._jspx_meth_c_choose_3(edit_005fselectRevisions_jsp.java:2842) at org.apache.jsp.WEB_002dINF.jsp.crucible.create.edit_005fselectRevisions_jsp._jspx_meth_c_when_4(edit_005fselectRevisions_jsp.java:2780) at org.apache.jsp.WEB_002dINF.jsp.crucible.create.edit_005fselectRevisions_jsp._jspx_meth_c_choose_2(edit_005fselectRevisions_jsp.java:2744) at org.apache.jsp.WEB_002dINF.jsp.crucible.create.edit_005fselectRevisions_jsp._jspx_meth_c_when_3(edit_005fselectRevisions_jsp.java:2715) at org.apache.jsp.WEB_002dINF.jsp.crucible.create.edit_005fselectRevisions_jsp._jspService(edit_005fselectRevisions_jsp.java:544) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1208) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.cenqua.crucible.filters.CrucibleFilter.doFilter(CrucibleFilter.java:118) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:159) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:334) at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126) at com.opensymphony.webwork.dispatcher.ServletDispatcherResult.doExecute(ServletDispatcherResult.java:114) at com.opensymphony.webwork.dispatcher.WebWorkResultSupport.execute(WebWorkResultSupport.java:143) at com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:313) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:208) at com.cenqua.crucible.interceptors.ReviewInterceptor.intercept(ReviewInterceptor.java:49) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.cenqua.crucible.interceptors.CruciblePermissionInterceptor.intercept(CruciblePermissionInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.cenqua.crucible.interceptors.HasCrucibleInterceptor.intercept(HasCrucibleInterceptor.java:27) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:186) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:273) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:111) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1208) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.cenqua.crucible.filters.CrucibleFilter.doFilter(CrucibleFilter.java:118) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:224) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:334) at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126) at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:145) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:81) at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:129) at com.cenqua.fisheye.web.filters.CustomIncludableGzipFilter.doFilter(CustomIncludableGzipFilter.java:21) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.cenqua.fisheye.web.filters.ProductInfoFilter.doFilter(ProductInfoFilter.java:36) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.cenqua.fisheye.web.filters.UpfrontFilter.doFilter(UpfrontFilter.java:59) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:324) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:865) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:539) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:451) Caused by: org.hibernate.NonUniqueResultException: query did not return a unique result: 2 at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:820) at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811) at com.cenqua.crucible.model.managers.StoredPathManager.findStoredPath(StoredPathManager.java:29) at com.cenqua.crucible.model.managers.FileRevisionManager.findRevision(FileRevisionManager.java:88) at com.cenqua.crucible.model.managers.FileRevisionManager.createRevision(FileRevisionManager.java:37) at com.cenqua.crucible.revision.managers.DefaultContentManager.makeCrucibleRevision(DefaultContentManager.java:414) at com.cenqua.crucible.explorers.RepositoryChangelogExplorer.buildChangeSetDO(RepositoryChangelogExplorer.java:63) at com.cenqua.crucible.explorers.RepositoryChangelogExplorer.getChangesets(RepositoryChangelogExplorer.java:42) at com.cenqua.crucible.actions.create.EditChangelogAction.initChangesets(EditChangelogAction.java:95) at com.cenqua.crucible.actions.create.EditChangelogAction.getExplorer(EditChangelogAction.java:58) 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:585) at javax.el.BeanELResolver.getValue(BeanELResolver.java:293) ... 143 more

    Atlassian JIRA | 7 years ago | Paavo Nugin
    javax.el.ELException: org.hibernate.NonUniqueResultException: query did not return a unique result: 2
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    WS & CancelProcess Bots Configurations.

    runawfe | 6 years ago | erickv
    org.hibernate.NonUniqueResultException: query did not return a unique result: 2
  6. 0

    you basically end up with two different stored paths with the same path. stack trace when loading a review with with one of these invalid stored paths: [java] ERROR - Problem getting previous revisions [java] org.hibernate.NonUniqueResultException: query did not return a unique result: 2 [java] at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:820) [java] at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811) [java] at com.cenqua.crucible.model.managers.StoredPathManager.findStoredPath(StoredPathManager.java:29) [java] at com.cenqua.crucible.model.managers.FileRevisionManager.findRevision(FileRevisionManager.java:115) [java] at com.cenqua.crucible.revision.managers.DefaultContentManager.getLazyCrucibleRevision(DefaultContentManager.java:367) [java] at com.cenqua.crucible.revision.managers.DefaultContentManager.getLazyCrucibleRevision(DefaultContentManager.java:363) [java] at com.cenqua.crucible.view.RevInfoDO.annotateFileHistory(RevInfoDO.java:120) [java] at com.cenqua.crucible.view.RevInfoDO.processFileRevisions(RevInfoDO.java:77) [java] at com.cenqua.crucible.view.RevInfoDO.<init>(RevInfoDO.java:58) [java] at com.cenqua.crucible.view.FRXDO$AnnotatedFileHistory.getRevInfoDO(FRXDO.java:108) [java] at com.cenqua.crucible.view.FRXDO.getCanProvideAnnotatedFileHistory(FRXDO.java:1017) [java] at sun.reflect.GeneratedMethodAccessor344.invoke(Unknown Source) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [java] at java.lang.reflect.Method.invoke(Method.java:585) [java] at javax.el.BeanELResolver.getValue(BeanELResolver.java:293) [java] at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:175) [java] at com.sun.el.parser.AstValue.getValue(AstValue.java:138) [java] at com.sun.el.parser.AstAnd.getValue(AstAnd.java:54) [java] at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:206) [java] at org.apache.jasper.runtime.PageContextImpl.evaluateExpression(PageContextImpl.java:1001) [java] at org.apache.jsp.tag.web.review.frxControls_tag._jspx_meth_c_if_4(org.apache.jsp.tag.web.review.frxControls_tag:494) [java] at org.apache.jsp.tag.web.review.frxControls_tag.doTag(org.apache.jsp.tag.web.review.frxControls_tag:175) [java] at org.apache.jsp.tag.web.review.reviewPage_tag._jspx_meth_rev_frxControls_0(org.apache.jsp.tag.web.review.reviewPage_tag:5585) [java] at org.apache.jsp.tag.web.review.reviewPage_tag._jspx_meth_c_forEach_32(org.apache.jsp.tag.web.review.reviewPage_tag:5528) [java] at org.apache.jsp.tag.web.review.reviewPage_tag._jspx_meth_c_when_9(org.apache.jsp.tag.web.review.reviewPage_tag:5495) [java] at org.apache.jsp.tag.web.review.reviewPage_tag._jspx_meth_c_choose_6(org.apache.jsp.tag.web.review.reviewPage_tag:5461) [java] at org.apache.jsp.tag.web.review.reviewPage_tag.doTag(org.apache.jsp.tag.web.review.reviewPage_tag:937) [java] at org.apache.jsp.WEB_002dINF.jsp.crucible.review.monolithic.review_jsp._jspx_meth_rev_reviewPage_0(org.apache.jsp.WEB_002dINF.jsp.crucible.review.monolithic.review_jsp:145) [java] at org.apache.jsp.WEB_002dINF.jsp.crucible.review.monolithic.review_jsp._jspService(org.apache.jsp.WEB_002dINF.jsp.crucible.review.monolithic.review_jsp:118) [java] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109) [java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) [java] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389) [java] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486) [java] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380) [java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) [java] at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1208) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.crucible.filters.CrucibleFilter.doFilter(CrucibleFilter.java:118) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:159) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) [java] at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) [java] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) [java] at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) [java] at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) [java] at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) [java] at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) [java] at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:334) [java] at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126) [java] at com.opensymphony.webwork.dispatcher.ServletDispatcherResult.doExecute(ServletDispatcherResult.java:114) [java] at com.opensymphony.webwork.dispatcher.WebWorkResultSupport.execute(WebWorkResultSupport.java:143) [java] at com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:313) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:208) [java] at com.cenqua.crucible.interceptors.ReviewInterceptor.intercept(ReviewInterceptor.java:49) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.cenqua.crucible.interceptors.CruciblePermissionInterceptor.intercept(CruciblePermissionInterceptor.java:40) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.cenqua.crucible.interceptors.HasCrucibleInterceptor.intercept(HasCrucibleInterceptor.java:27) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:186) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) [java] at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:273) [java] at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:111) [java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) [java] at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1208) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83) [java] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.crucible.filters.CrucibleFilter.doFilter(CrucibleFilter.java:118) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:224) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) [java] at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) [java] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) [java] at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) [java] at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) [java] at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) [java] at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) [java] at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:334) [java] at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126) [java] at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:145) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) [java] at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) [java] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:81) [java] at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:129) [java] at com.cenqua.fisheye.web.filters.CustomIncludableGzipFilter.doFilter(CustomIncludableGzipFilter.java:21) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.fisheye.web.filters.ProductInfoFilter.doFilter(ProductInfoFilter.java:36) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.fisheye.web.filters.UpfrontFilter.doFilter(UpfrontFilter.java:59) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) [java] at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) [java] at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) [java] at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) [java] at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) [java] at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230) [java] at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) [java] at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) [java] at org.mortbay.jetty.Server.handle(Server.java:324) [java] at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535) [java] at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:865) [java] at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:539) [java] at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) [java] at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) [java] at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) [java] at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:451)

    Atlassian JIRA | 7 years ago | Geoff Crain [Atlassian]
    org.hibernate.NonUniqueResultException: query did not return a unique result: 2

    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. org.hibernate.NonUniqueResultException

      query did not return a unique result: 2

      at org.hibernate.impl.AbstractQueryImpl.uniqueElement()
    2. Hibernate
      AbstractQueryImpl.uniqueResult
      1. org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:820)
      2. org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
      2 frames
    3. com.redhat.rhn
      DownloadFile.execute
      1. com.redhat.rhn.domain.kickstart.KickstartFactory.lookupKickstartTreeByLabel(KickstartFactory.java:522)
      2. com.redhat.rhn.frontend.action.common.DownloadFile.handleKickstartDownload(DownloadFile.java:220)
      3. com.redhat.rhn.frontend.action.common.DownloadFile.execute(DownloadFile.java:100)
      3 frames
    4. struts
      RequestProcessor.process
      1. org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
      2. org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:237)
      2 frames
    5. com.redhat.rhn
      RhnRequestProcessor.process
      1. com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:82)
      1 frame
    6. struts
      ActionServlet.doGet
      1. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
      2. org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
      2 frames
    7. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      2 frames
    8. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    9. com.redhat.rhn
      AuthFilter.doFilter
      1. com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:73)
      1 frame
    10. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    11. Sitemesh
      PageFilter.doFilter
      1. com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142)
      2. com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58)
      2 frames
    12. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    13. com.redhat.rhn
      LocalizedEnvironmentFilter.doFilter
      1. com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)
      1 frame
    14. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    15. com.redhat.rhn
      EnvironmentFilter.doFilter
      1. com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108)
      1 frame
    16. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    17. com.redhat.rhn
      SessionFilter.doFilter
      1. com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55)
      1 frame
    18. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    19. com.redhat.rhn
      SetCharacterEncodingFilter.doFilter
      1. com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)
      1 frame
    20. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
      5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      6. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      7. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
      8. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
      8 frames
    21. Embedded GlassFish Web
      ChannelSocket$SocketConnection.runIt
      1. org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
      2. org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
      3. org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
      4. org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)
      5. org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)
      5 frames
    22. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
      1 frame
    23. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:736)
      1 frame