Connection leak when database error occurs causes JIRA to eventually hang

XMLWordPrintable

    • 3.01

      Under certain conditions, connections are leaked:

      • Tomcat (not certain if we need this)
      • Oracle (with tryclob...) or MSSQL
      • Try running quicksearch with a key that isn't found - this will search through the change history
      • Because Oracle (and MSSQL presumably) can't do exact text match queries in CLOBs (though 'like' queries work), and exception is thrown
      • This exception propagates up to JIRA code. However, ofbiz doesn't close the connection.
      • If you do this enough times (more than number of connections in DB pool - 8 in Tomcat's commons-dbcp) then you run out of connections, and JIRA appears to hang.

              Assignee:
              Unassigned
              Reporter:
              Scott Farquhar
              Votes:
              3 Vote for this issue
              Watchers:
              9 Start watching this issue

                Created:
                Updated:
                Resolved: