6 answers

I don't think you're going to get a correct answer based on the information in your question.

But, if you install the java melody plugin, it will show you all the database connections, along with stacktraces from what created the connection. Using this, you can find out which plugin (it probably is a plugin) is creating them.

With java melody you should see two thread dumps for every connection, one is from when the connection was created, and one is what it is currently doing. The one that created it is the interesting one.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

2.a) you need to look in your thread dump for the string: locked 0x000000059a5bf828 (same address as above). Please show us that thread, this is the one that is blocking everything2.b) you need to look a bit over the configuration of the DBCP datasource. Are you using validation? testWhileIdle ? Would be helpful to show us the configuration, too2.c) Disable any 3rd party plugins before doing these tests.

That's a good point... I found using a validation query made things massively slower (on oracle at any rate). The validation query is run before every single normal query. As Radu says 300 connections seems way too much... I manage a jira site with 10k users and the connection pool is 30.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Hi Jamie, We redced the pool size to 50 and also handled some other http session attributes. But in the melody plugin the used jdbc connections is observed like below. Maximum it is showing is 9 and Mean is 8. Will that impact in peak hours and what does it means?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

1) 300 connections are way too much. You may have messages on ORCL side that it is in a kind of limbo.

2) Remove abandoned has something to do with your deadlock (remove abandoned is called AFAIK from another thread that the one that aquired the connection). The ORCL drivers are sensitive to these kinds of manipulation.

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...