DB Connection Pool spikes suddenly and slowdown jira

Question

Hi Guys,

Need you help to fix the DB connection pool suddenly spikes from its normal level which is below 20. Today it suddenly reached it max level. Kindly suggest as JIRA Admin what i need to do in order this issue . So that come back to it normal performance. Please help ..

Is any issue from DB side, then what DB team needs to check ?

Getting this in logs :- c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Dangerous use of multiple connections

/rest/scriptrunner/behaviours/latest/validators.json [c.o.jira.behaviours.BehaviourManagerImpl] Script function failed on issue

[c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Dangerous use of multiple connections: replaced => count=1; marks=[0-0]; pool=39/40

[c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Further stacktraces of this type are temporarily suppressed.

[c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Dangerous use of multiple connections: taken => count=2; marks=[1-0]; pool=40/40

Thanks

Vikrant Yadav · Answer

Hi @Ram Kumar Aravindakshan _Adaptavist_  Yes, i checked this article and checked

atlassian-jira.log using built in script and found the same logs which mentioned in article :-

/rest/scriptrunner/behaviours/latest/validators.json [c.o.jira.behaviours.BehaviourManagerImpl] Script function failed on issue

[c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Dangerous use of multiple connections: replaced => count=1; marks=[0-0]; pool=39/40

[c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Further stacktraces of this type are temporarily suppressed.

Is it due to any scriptrunner behaviour or scripted post function, how can i check which behaviour or post function causing issue yerterday. Today DB pool is back to normal .

Thanks

V.Y

Ram Kumar Aravindakshan _Adaptavist_ · Answer

Hi @Vikrant Yadav

Have you already referred to this Jira KB Article?

Any idea which behaviour is causing it? Could you please share the code if possible?

Thank you and Kind Regards,

Ram