Uploaded image for project: 'Jira Server and Data Center'
  1. Jira Server and Data Center
  2. JRASERVER-59505

JIRA 7.0.9 fails with SQL error when using MySQL Server

    XMLWordPrintable

    Details

      Description

      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:

      1. Go to User Management and find any users whose username begins with "addon_".
      2. Delete these users.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              b0b47ec399e5 Kenneth Hansen
              Votes:
              1 Vote for this issue
              Watchers:
              14 Start watching this issue

                Dates

                Created:
                Updated: