Uploaded image for project: 'Jira Software Server and Data Center'
  1. Jira Software Server and Data Center
  2. JSWSERVER-13355

The new Release page in JIRA 7 doesn't perform well on large instances

    XMLWordPrintable

    Details

      Description

      This is the URL in question:

      https://jira/projects/IT?selectedItem=com.atlassian.jira.jira-projects-plugin:release-page

      It's fetching all versions, and if the cache becomes invalidated, it becomes super slow. 154 seconds in our case with 22,000 versions globally:

      "http-nio-8080-exec-4" #131 daemon prio=5 os_prio=0 tid=0x00007f0a88003000 nid=0xf53f runnable [0x00007f09bc56b000]
         java.lang.Thread.State: RUNNABLE
              at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5693)
              at org.apache.commons.dbcp2.DelegatingResultSet.getString(DelegatingResultSet.java:199)
              at org.apache.commons.dbcp2.DelegatingResultSet.getString(DelegatingResultSet.java:199)
              at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.getValue(SqlJdbcUtil.java:616)
              at org.ofbiz.core.entity.EntityListIterator.currentGenericValue(EntityListIterator.java:169)
              at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:246)
              at org.ofbiz.core.entity.EntityListIterator.getCompleteList(EntityListIterator.java:308)
              at org.ofbiz.core.entity.GenericDAO.selectByCondition(GenericDAO.java:800)
              at org.ofbiz.core.entity.GenericDAO.selectByCondition(GenericDAO.java:777)
              at org.ofbiz.core.entity.GenericHelperDAO.findByCondition(GenericHelperDAO.java:178)
              at org.ofbiz.core.entity.GenericDelegator.findByCondition(GenericDelegator.java:1085)
              at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:154)
              at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.findByCondition(WrappingOfBizDelegator.java:235)
              at com.atlassian.jira.entity.EntityEngineImpl$AbstractWhereContext.list(EntityEngineImpl.java:200)
              at com.atlassian.jira.project.version.OfBizVersionStore.getAllVersions(OfBizVersionStore.java:27)
              at com.atlassian.jira.project.version.OfBizVersionStore.getVersionsByName(OfBizVersionStore.java:33)
              at com.atlassian.jira.project.version.CachingVersionStore.lambda$new$2(CachingVersionStore.java:37)
      
      • Possibly related to JRA-62666
        • if does, then in fixed in 7.1.2

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                24 Vote for this issue
                Watchers:
                31 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Last commented:
                  7 weeks, 5 days ago