"Dangerous use of multiple connections" - error reports wrong number of connections

XMLWordPrintable

    • 7.06
    • 129
    • Severity 3 - Minor
    • 1,303

      Summary

      The error message reported in the Jira logs about the connection pool acquired by a thread is not reporting right numbers : 

      2018-11-06 08:17:23,168 ajp-nio-8009-exec-54 WARN xxxxx 497x1787252x1 yyyyyy 10.188.174.111 /secure/CommentAssignIssue.jspa [c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Dangerous use of multiple connections: replaced => count=0; marks=[-1-0]; pool=151/80
2018-11-06 08:17:23,108 ajp-nio-8009-exec-54 WARN xxxxx 497x1787252x1 yyyyyy 10.188.174.111 /secure/CommentAssignIssue.jspa [c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Dangerous use of multiple connections: replaced => count=1; marks=[0-0]; pool=153/80
2018-11-06 08:17:23,107 ajp-nio-8009-exec-54 WARN xxxxx 497x1787252x1 yyyyyy 10.188.174.111 /secure/CommentAssignIssue.jspa [c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Dangerous use of multiple connections: taken => count=2; marks=[1-0]; pool=154/80

      It also can be shown like this:

      2020-12-14 11:14:54,477 Caesium-1-4 WARN anonymous [c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Dangerous use of multiple connections: replaced => count=0; marks=[-1-3]; pool=1/100
2020-12-14 11:14:55,479 Caesium-1-4 WARN anonymous
[c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Dangerous use of multiple connections: taken => count=3; marks=[2-3]; pool=3/100

      Expected Results

      The error above would report the used and available connection pools accurately.

      Actual Results

      The error message reports the wrong number as 154/80 or 1/100 are not comprehensible

      Workaround

      Jira administrators should focus on the Database Monitoring page within Jira Administration console as that should be more accurate than the logs.

            Assignee:
            Mark Patterson (Inactive)
            Reporter:
            Ruchi Tandon (Inactive)
            Votes:
            127 Vote for this issue
            Watchers:
            139 Start watching this issue

              Created:
              Updated:
              Resolved: