Jira database driver updated jira isn't releasing connections

Leonard Smith

Hi,

 

We've completed an upgrade for Jira 7.1 to 7.5.1 and during the upgrade the database driver has changed

from:net.sourceforge.jtds.jdbc.Driver

to: com.microsoft.sqlserver.jdbc.SQLServerDriver

 

Now were seeing issues are transition slower, reindex slower and also that Jira is using more connecting, we had a case where it used all available db connections. We had a look at the connections on the db and all connections had been executing and the db was waiting for jira to tell it what do next.

Looks like Jira isnt releasing connections, is there anything we can do to fix?

 

 

Jeff Curry

Grab some thread dumps while issues are slow to transition, slow reindex, etc and you should be able to see what's taking so long:

https://confluence.atlassian.com/jirakb/troubleshooting-performance-issues-with-thread-dumps-644874457.html

 

If in doubt raise a support request at https://getsupport.atlassian.com and we can review further