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

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

XMLWordPrintable

      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.

              afb6234f8e80 Mark Patterson (Inactive)
              rtandon@atlassian.com Ruchi Tandon (Inactive)
              Votes:
              127 Vote for this issue
              Watchers:
              139 Start watching this issue

                Created:
                Updated:
                Resolved: