Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-39769

JIRA leaks DB connections

XMLWordPrintable

      Component: entityengine
      Class: GenericDAO.java
      Method: selectListIteratorByCondition

      Description:
      In case an exception is thrown after the SQLProcessor instance is created, a database connection is leaked because the SQLProcessor instance is not closed.

      Solution:
      The code after the createion of the SQLProcessor instance must be in try-catch block intercepting GenericEntityException and RuntimeException.
      In case of caught exception, the SQLProcessor instance must be closed and the exception re-thrown.

      Affected versions:
      This issue was discovered in our productive JIRA v. 6.1.3, but after looking at the source it is still present in 6.3.4

            [JRASERVER-39769] JIRA leaks DB connections

            Bugfix Automation Bot made changes -
            Minimum Version New: 6.01
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2834117 ] New: JAC Bug Workflow v3 [ 2924346 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v7 - Restricted [ 2581362 ] New: JAC Bug Workflow v2 [ 2834117 ]
            Ignat (Inactive) made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 - Restricted [ 1537908 ] New: JIRA Bug Workflow w Kanban v7 - Restricted [ 2581362 ]
            Confluence Escalation Bot (Inactive) made changes -
            Labels New: affects-server
            Oswaldo Hernandez (Inactive) made changes -
            Component/s New: Infrastructure & Services - Application Lifecycle [ 43324 ]
            Component/s Original: Backend / Domain Model [Deprecated] [ 10121 ]
            Owen made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 [ 725164 ] New: JIRA Bug Workflow w Kanban v6 - Restricted [ 1537908 ]
            Graham (Inactive) made changes -
            Remote Link New: This issue links to "JDEV-31097 (JDOG - JIRA Team Dogfood)" [ 84428 ]
            Peter Obara made changes -
            Remote Link Original: This issue links to "Page (Extranet)" [ 78144 ] New: This issue links to "Page (Extranet)" [ 78144 ]
            Peter Obara made changes -
            Remote Link New: This issue links to "Page (Extranet)" [ 78144 ]

              ohernandez@atlassian.com Oswaldo Hernandez (Inactive)
              aa1cc56303ab Svetlin Zarev
              Affected customers:
              1 This affects my team
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: