-
Bug
-
Resolution: Duplicate
-
Medium
-
None
-
7.1.1, 6.4.13
-
6.04
-
49
-
Severity 2 - Major
-
19
-
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
- Fixed in
JSWSERVER-16613
- is related to
-
JRASERVER-62666 JIRA method getVersionsByName inefficiently populates the cache
- Closed
- relates to
-
JSWSERVER-16613 Versions view in Project settings can timeout on large instance
- Closed
-
JRASERVER-59939 FixVersion and AffectVersion JQL is slow on large instances
- Closed
- mentioned in
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
- was cloned as
-
RUN-191 Loading...