• Type: Bug
• Resolution: Duplicate
• Priority: Medium (View bug fix roadmap)
• Fix Version/s: None
• Affects Version/s: 7.1.1, 6.4.13
• Component/s: Release Hub
• Labels:

  • affects-server
  • fixme
  • l1l2
  • pse-rank
  • pse-request
  • triaged

[JSWSERVER-13355] The new Release page in JIRA 7 doesn't perform well on large instances

Conny Postma made changes - 17/Jan/2025 12:36 PM

Remote Link

Original: This issue links to "Page (Atlassian Documentation)" [ 237223 ]

Andriy Yakovlev [Atlassian] made changes - 12/May/2020 4:02 PM

Description

Original: 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: {code} "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) {code} * Possibly related to JRA-62666 ** if does, then in fixed in 7.1.2

New: 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: {code} "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) {code} * Possibly related to JRA-62666 ** if does, then in fixed in 7.1.2 * Fixed in JSWSERVER-16613

Andriy Yakovlev [Atlassian] made changes - 12/May/2020 4:02 PM

Resolution		New: Duplicate [ 3 ]
Status	Original: Short Term Backlog [ 12074 ]	New: Closed [ 6 ]

Andriy Yakovlev [Atlassian] made changes - 12/May/2020 4:01 PM

Status

Original: Gathering Impact [ 12072 ]

New: Short Term Backlog [ 12074 ]

SET Analytics Bot made changes - 12/May/2020 12:34 AM

UIS

Original: 39

New: 19

SET Analytics Bot made changes - 10/May/2020 12:31 AM

UIS

Original: 38

New: 39

SET Analytics Bot made changes - 28/Apr/2020 12:32 AM

UIS

Original: 58

New: 38

SET Analytics Bot made changes - 24/Apr/2020 12:44 AM

UIS

Original: 77

New: 58

SET Analytics Bot made changes - 23/Apr/2020 1:04 AM

UIS

Original: 96

New: 77

SET Analytics Bot made changes - 18/Apr/2020 1:26 AM

UIS

Original: 135

New: 96

Load more older events