Uploaded image for project: 'Atlassian Cloud'
  1. Atlassian Cloud
  2. CLOUD-2125

JIRA Fisheye plugin Reviews Project Tab performs inefficient queries

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Fix
    • Medium
    • None
    • None

    Description

      The projecttab in JIRA performs this query:

      select revisions where (comment matches 'PROJECTKEY' or p4:jobid =~ '(^|[^a-zA-Z0-9-])PROJECTKEY-[0-9]+($|[^a-zA-Z0-9-])') and date > 2009-11-24T15:43:09Z return reviews 
      

      This can cause fisheye to heap dump OOM...possibly because too many results came back.

      We can use EyeQL to restrict the search to a folder since each project is mapped to a single project folder in Studio. The alternative is to use the limit clause in EyeQL.

      ERROR - Error for /source/api/rest/query
      java.lang.OutOfMemoryError: Java heap space
        at org.apache.lucene.index.FieldsReader.addField(FieldsReader.java:324)
        at org.apache.lucene.index.FieldsReader.doc(FieldsReader.java:166)
        at org.apache.lucene.index.SegmentReader.document(SegmentReader.java:659)
        at org.apache.lucene.index.MultiSegmentReader.document(MultiSegmentReader.java:257)
        at org.apache.lucene.index.IndexReader.document(IndexReader.java:525)
        at com.cenqua.fisheye.lucene.join.DocumentRightJoinEnum.hasNext(DocumentRightJoinEnum.java:43)
        at com.cenqua.fisheye.infinitydb.query3.LuceneJoinQuery3.asItemSpace(LuceneJoinQuery3.java:56)
        at com.cenqua.fisheye.infinitydb.query3.BooleanQuery3.asItemSpace(BooleanQuery3.java:63)
        at com.cenqua.fisheye.infinitydb.query3.BooleanQuery3.asItemSpace(BooleanQuery3.java:63)
        at com.cenqua.fisheye.infinitydb.query3.BooleanQuery3.asItemSpace(BooleanQuery3.java:63)
        at com.cenqua.fisheye.infinitydb.query3.Query3$1.perform(Query3.java:40)
        at com.cenqua.fisheye.lucene.LuceneConnection.withReader(LuceneConnection.java:122)
        at com.cenqua.fisheye.infinitydb.query3.Query3.asItemSpace(Query3.java:38)
        at com.cenqua.fisheye.search.query.BaseQueryEvaluator.performQuery(BaseQueryEvaluator.java:63)
        at com.cenqua.fisheye.search.SearchManager.executeQueryImpl(SearchManager.java:52)
        at com.cenqua.fisheye.search.SearchManager.access$000(SearchManager.java:11)
        at com.cenqua.fisheye.search.SearchManager$1.createValue(SearchManager.java:34)
        at com.cenqua.fisheye.search.SearchManager$1.createValue(SearchManager.java:39)
        at com.cenqua.fisheye.util.LRUCache.createValueForNode(LRUCache.java:156)
        at com.cenqua.fisheye.util.LRUCache.get(LRUCache.java:109)
        at com.cenqua.fisheye.search.SearchManager.getFromCache(SearchManager.java:44)
        at com.cenqua.fisheye.search.SearchManager.runQuery(SearchManager.java:27)
        at com.cenqua.fisheye.api.ApiImplementation.doQuery(ApiImplementation.java:234)
        at com.cenqua.fisheye.api.ApiImplementation.handleCommand(ApiImplementation.java:201)
        at com.cenqua.fisheye.api.ApiImplementation.handle(ApiImplementation.java:181)
        at com.cenqua.fisheye.api.BaseApiServlet.doPost(BaseApiServlet.java:25)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
        at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1144)
        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            703bb962693b Diane Yu
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: