-
Bug
-
Resolution: Low Engagement
-
Low
-
None
-
7.0.9, 7.0.10
-
7
-
14
-
Severity 3 - Minor
-
0
-
Summary
JIRA appears to upgrade correctly but fails when accessing Administrator functions such as the Applications and add-ons screens.
Environment
- JIRA 7.0.9 or 7.0.10
- Previously migrated from a JIRA Cloud instance
- MySQL database
Expected Results
JIRA will navigate to these pages without error
Actual Results
The below exception is thrown in the atlassian-jira.log file:
Caused by: com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceExce
ption: SQL Exception while executing the following:SELECT lower_parent_name FROM cwd_membership WHERE (directory_id = ? ) AND (lower_child_
name = ? ) AND (membership_type = ? ) (Streaming result set com.mysql.jdbc.RowDataDynamic@695f5925 is still active. No statements may be i
ssued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming
result sets before attempting more queries.)
at com.atlassian.cache.memory.DelegatingCache$DelegatingLoadingCache.get(DelegatingCache.java:330)
at com.atlassian.jira.crowd.embedded.ofbiz.OfBizInternalMembershipDao.getParentsForMemberFromCache(OfBizInternalMembershipDao.java:3
70)
at com.atlassian.jira.crowd.embedded.ofbiz.OfBizInternalMembershipDao.searchCache(OfBizInternalMembershipDao.java:355)
at com.atlassian.jira.crowd.embedded.ofbiz.OfBizInternalMembershipDao.search(OfBizInternalMembershipDao.java:309)...
Workaround
Run the following SQL and see if this applies to your situation
select * from cwd_user where user_name like 'addon%'
If users are returned from the SQL query:
- Go to User Management and find any users whose username begins with "addon_".
- Delete these users.
- relates to
-
-
- Closed
-
