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

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

XMLWordPrintable

      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

              Unassigned Unassigned
              a38518e05741 David Yu
              Votes:
              34 Vote for this issue
              Watchers:
              42 Start watching this issue

                Created:
                Updated:
                Resolved: