com.atlassian.jira.issue.search.ClauseTooComplexSearchException: A the following query was too complex to generate a query from: {comment ~ "Unable to retrieve gadget xml. HTTP error 404"}

Atlassian JIRA | Andrew Myers [Atlassian] | 7 years ago
  1. 0

    If i run a JQL search that is too general, then try to click on the "file attachments" link on an issue it dumps a stack trace {noformat} com.atlassian.jira.issue.search.ClauseTooComplexSearchException: A the following query was too complex to generate a query from: {comment ~ "Unable to retrieve gadget xml. HTTP error 404"} at com.atlassian.jira.jql.query.DefaultLuceneQueryBuilder.createLuceneQuery(DefaultLuceneQueryBuilder.java:38) at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.getHits(LuceneSearchProvider.java:151) at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.searchAndSort(LuceneSearchProvider.java:276) at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.searchAndSort(LuceneSearchProvider.java:110) at com.atlassian.jira.issue.pager.NextPreviousPager.populateDocIdsAndGetCurrentKeyPosition(NextPreviousPager.java:233) at com.atlassian.jira.issue.pager.NextPreviousPager.update(NextPreviousPager.java:162) at com.atlassian.jira.web.action.issue.ManageAttachments.doExecute(ManageAttachments.java:88) at webwork.action.ActionSupport.execute(ActionSupport.java:153) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:59) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:141) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:181) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) {noformat} *Screenshot*: User might encounter this, if he has watched a huge number of issues (> 200000) !watched.PNG!

    Atlassian JIRA | 7 years ago | Andrew Myers [Atlassian]
    com.atlassian.jira.issue.search.ClauseTooComplexSearchException: A the following query was too complex to generate a query from: {comment ~ "Unable to retrieve gadget xml. HTTP error 404"}
  2. 0

    If i run a JQL search that is too general, then try to click on the "file attachments" link on an issue it dumps a stack trace {noformat} com.atlassian.jira.issue.search.ClauseTooComplexSearchException: A the following query was too complex to generate a query from: {comment ~ "Unable to retrieve gadget xml. HTTP error 404"} at com.atlassian.jira.jql.query.DefaultLuceneQueryBuilder.createLuceneQuery(DefaultLuceneQueryBuilder.java:38) at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.getHits(LuceneSearchProvider.java:151) at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.searchAndSort(LuceneSearchProvider.java:276) at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.searchAndSort(LuceneSearchProvider.java:110) at com.atlassian.jira.issue.pager.NextPreviousPager.populateDocIdsAndGetCurrentKeyPosition(NextPreviousPager.java:233) at com.atlassian.jira.issue.pager.NextPreviousPager.update(NextPreviousPager.java:162) at com.atlassian.jira.web.action.issue.ManageAttachments.doExecute(ManageAttachments.java:88) at webwork.action.ActionSupport.execute(ActionSupport.java:153) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:59) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:141) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:181) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) {noformat} *Screenshot*: User might encounter this, if he has watched a huge number of issues (> 200000) !watched.PNG!

    Atlassian JIRA | 7 years ago | Andrew Myers [Atlassian]
    com.atlassian.jira.issue.search.ClauseTooComplexSearchException: A the following query was too complex to generate a query from: {comment ~ "Unable to retrieve gadget xml. HTTP error 404"}
  3. 0

    Currently, JIRA's default setting for jira.search.maxclauses is 65000. If JIRA has more than this amount in *Unrelased Versions*, boards will break with this error in the logs: {code} 2014-03-16 20:03:11,778 http-bio-8080-exec-4 ERROR admin 1263x121x1 1b1c4rs 1.1.1.1.1 /rest/greenhopper/1.0/xboard/work/allData.json [greenhopper.service.issue.IssueDataServiceImpl] A the following query was too complex to generate a query from: {fixVersion in unreleasedVersions()} com.atlassian.jira.issue.search.ClauseTooComplexSearchException: A the following query was too complex to generate a query from: {fixVersion in unreleasedVersions()} at com.atlassian.jira.jql.query.DefaultLuceneQueryBuilder.createLuceneQuery(DefaultLuceneQueryBuilder.java:43) at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.search(LuceneSearchProvider.java:309) at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.search(LuceneSearchProvider.java:153) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129) at com.sun.proxy.$Proxy228.search(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:154) at com.sun.proxy.$Proxy228.search(Unknown Source) at com.atlassian.greenhopper.service.issue.IssueDataServiceImpl.findImpl(IssueDataServiceImpl.java:166) at com.atlassian.greenhopper.service.issue.IssueDataServiceImpl.findWithServiceOutcome(IssueDataServiceImpl.java:48) at com.atlassian.greenhopper.web.rapid.work.WorkDataFactory.getWorkDataIssueCountAndLastUpdated(WorkDataFactory.java:234) at com.atlassian.greenhopper.web.rapid.work.WorkDataFactory.getAllData(WorkDataFactory.java:141) at com.atlassian.greenhopper.web.rapid.work.WorkResource$1.call(WorkResource.java:70) at com.atlassian.greenhopper.web.rapid.work.WorkResource$1.call(WorkResource.java:59) at com.atlassian.greenhopper.web.util.RestCall.response(RestCall.java:48) at com.atlassian.greenhopper.web.AbstractResource.response(AbstractResource.java:60) at com.atlassian.greenhopper.web.rapid.work.WorkResource.getPoolData(WorkResource.java:58) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ... {code} h4. Workaround * Release/archive versions until the system is under the 65000 limit or * Increase the default limit of 65000, but it is not known how this will affect future performance of the system. {code} jira.search.maxclauses = 65000 {code}

    Atlassian JIRA | 3 years ago | David Chan [Atlassian]
    com.atlassian.jira.issue.search.ClauseTooComplexSearchException: A the following query was too complex to generate a query from: {fixVersion in unreleasedVersions()}
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Currently, JIRA's default setting for jira.search.maxclauses is 65000. If JIRA has more than this amount in *Unrelased Versions*, boards will break with this error in the logs: {code} 2014-03-16 20:03:11,778 http-bio-8080-exec-4 ERROR admin 1263x121x1 1b1c4rs 1.1.1.1.1 /rest/greenhopper/1.0/xboard/work/allData.json [greenhopper.service.issue.IssueDataServiceImpl] A the following query was too complex to generate a query from: {fixVersion in unreleasedVersions()} com.atlassian.jira.issue.search.ClauseTooComplexSearchException: A the following query was too complex to generate a query from: {fixVersion in unreleasedVersions()} at com.atlassian.jira.jql.query.DefaultLuceneQueryBuilder.createLuceneQuery(DefaultLuceneQueryBuilder.java:43) at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.search(LuceneSearchProvider.java:309) at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.search(LuceneSearchProvider.java:153) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129) at com.sun.proxy.$Proxy228.search(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:154) at com.sun.proxy.$Proxy228.search(Unknown Source) at com.atlassian.greenhopper.service.issue.IssueDataServiceImpl.findImpl(IssueDataServiceImpl.java:166) at com.atlassian.greenhopper.service.issue.IssueDataServiceImpl.findWithServiceOutcome(IssueDataServiceImpl.java:48) at com.atlassian.greenhopper.web.rapid.work.WorkDataFactory.getWorkDataIssueCountAndLastUpdated(WorkDataFactory.java:234) at com.atlassian.greenhopper.web.rapid.work.WorkDataFactory.getAllData(WorkDataFactory.java:141) at com.atlassian.greenhopper.web.rapid.work.WorkResource$1.call(WorkResource.java:70) at com.atlassian.greenhopper.web.rapid.work.WorkResource$1.call(WorkResource.java:59) at com.atlassian.greenhopper.web.util.RestCall.response(RestCall.java:48) at com.atlassian.greenhopper.web.AbstractResource.response(AbstractResource.java:60) at com.atlassian.greenhopper.web.rapid.work.WorkResource.getPoolData(WorkResource.java:58) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ... {code} h4. Workaround * Release/archive versions until the system is under the 65000 limit or * Increase the default limit of 65000, but it is not known how this will affect future performance of the system. {code} jira.search.maxclauses = 65000 {code}

    Atlassian JIRA | 3 years ago | David Chan [Atlassian]
    com.atlassian.jira.issue.search.ClauseTooComplexSearchException: A the following query was too complex to generate a query from: {fixVersion in unreleasedVersions()}

    Root Cause Analysis

    1. com.atlassian.jira.issue.search.ClauseTooComplexSearchException

      A the following query was too complex to generate a query from: {comment ~ "Unable to retrieve gadget xml. HTTP error 404"}

      at com.atlassian.jira.jql.query.DefaultLuceneQueryBuilder.createLuceneQuery()
    2. com.atlassian.jira
      ManageAttachments.doExecute
      1. com.atlassian.jira.jql.query.DefaultLuceneQueryBuilder.createLuceneQuery(DefaultLuceneQueryBuilder.java:38)
      2. com.atlassian.jira.issue.search.providers.LuceneSearchProvider.getHits(LuceneSearchProvider.java:151)
      3. com.atlassian.jira.issue.search.providers.LuceneSearchProvider.searchAndSort(LuceneSearchProvider.java:276)
      4. com.atlassian.jira.issue.search.providers.LuceneSearchProvider.searchAndSort(LuceneSearchProvider.java:110)
      5. com.atlassian.jira.issue.pager.NextPreviousPager.populateDocIdsAndGetCurrentKeyPosition(NextPreviousPager.java:233)
      6. com.atlassian.jira.issue.pager.NextPreviousPager.update(NextPreviousPager.java:162)
      7. com.atlassian.jira.web.action.issue.ManageAttachments.doExecute(ManageAttachments.java:88)
      7 frames
    3. webwork.action
      ActionSupport.execute
      1. webwork.action.ActionSupport.execute(ActionSupport.java:153)
      1 frame
    4. com.atlassian.jira
      JiraActionSupport.execute
      1. com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:59)
      1 frame
    5. webwork.dispatcher
      GenericDispatcher.executeAction
      1. webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:141)
      1 frame
    6. com.atlassian.jira
      JiraServletDispatcher.service
      1. com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:181)
      1 frame
    7. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      1 frame