Dangerous use of multiple connections

Owned by Andriy Zhdanov
Last updated: May 14, 2021 by Oleksandr Velytchenko (Unlicensed)
1 min read

Problem

We're experiencing loads of these errors in our Jira log... nearly 300k in 2 days :


2018-04-26 11:19:10,495 http-nio-8080-exec-6 WARN <username> 679x59888x11 fnw9cw 127.0.0.1 /rest/timesheet-gadget/1.0/timesheet.json [c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Dangerous use of multiple connections: replaced => count=0; marks=[-1-0]; pool=6/20

This causes the available db connection pool to get exhausted and is causing the entire Jira instance to crash.

Workaround

Please consider using Time Reports for Jira Server instead, it has quite same UI, but different backend, so it does not have such problems. See also Comparison Matrix for feature differences.

Solution

Unfortunately, this problem has no clear solution, however Atlassian has confirmed a bug, see JRASERVER-45794 for workaround suggested by Atlassian.

Otherwise, it may be that problem happens due to dashboard left unattended, when session expires. You may try to remove all add-on gadgets from all dashboards, if it's acceptable. See https://bitbucket.org/tempo-io/servertimesheet/wiki/Usage_Tracking for how to find them.

Stopping JIRA service, rebooting the DB server, then starting JIRA service might help.

See also issue#1066 and contact Atlassian Support for help.