TimeSheet Gadget slows down entire JIRA Dangerous use of multiple connections: replaced

[Cristina Abunei]

Hello,

When using either the TimeSheet Report, or the gadget, our logs fill up with these messages below, and the entire JIRA instance responds very slowly:

2017-02-28 01:45:48,596 http-nio-8080-exec-223 WARN uidq5816 105x4017638x53 16wd7p6 10.217.177.60 /rest/timesheet-gadget/1.0/timesheet.json [c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Dangerous use of multiple connections: replaced => count=1; marks=[0-0]; pool=19/20 2017-02-28 01:45:48,598 http-nio-8080-exec-223 WARN uidq5816 105x4017638x53 16wd7p6 10.217.177.60 /rest/timesheet-gadget/1.0/timesheet.json [c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Dangerous use of multiple connections: taken => count=2; marks=[1-0]; pool=20/20 2017-02-28 01:45:48,607 http-nio-8080-exec-223 WARN uidq5816 105x4017638x53 16wd7p6 10.217.177.60 /rest/timesheet-gadget/1.0/timesheet.json [c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Dangerous use of multiple connections: replaced => count=1; marks=[0-0]; pool=19/20 2017-02-28 01:45:48,611 http-nio-8080-exec-223 WARN uidq5816 105x4017638x53 16wd7p6 10.217.177.60 /rest/timesheet-gadget/1.0/timesheet.json [c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Dangerous use of multiple connections: taken => count=2; marks=[1-0]; pool=20/20 2017-02-28 01:45:48,614 http-nio-8080-exec-223 WARN uidq5816 105x4017638x53 16wd7p6 10.217.177.60 /rest/timesheet-gadget/1.0/timesheet.json [c.a.jira.ofbiz.ConnectionPoolHealthSqlInterc

[Andriy Zhdanov]

Hi Cristina,

Sorry I don't know how plugin may cause it, could you please see JRA-45794 and contact Atlassian Support for help?

Thank you.

[Cristina Abunei]

Hello Andriy,

Thank you for your reply. I will also open an issue to Atlassian Support, but in https://jira.atlassian.com/browse/JRA-45794 the problem seems to be that the mark is -2, in our logs that does not happen, marks are one of: [1,0] [0,0] and [-1,0]. I will also update this ticket with what atlassian support recommends.

[Andriy Zhdanov]

Hi Cristina,

Another customer said:

Stopping JIRA service, rebooting the DB server , then starting JIRA service seemed to help a little though.

Thank you.

[Srikanth M]

Hi @CristinaAbunei Our instance is down too apparently from the timesheet plugin (Atlassian says so from logs). Can you kindly let us know how you resolved it? We don't have mark-2, just [1.0], [0.0] in the logs

"Dangerous use of multiple connections: replaced => count=1; marks=[0-0]; pool=30/30" or "Dangerous use of multiple connections: taken => count=2; marks=[1-0]; pool=31/30"