How do I refresh the connection pool in JIRA?

Our JIRA instance is using one of our production Oracle databases, along with other support services. From time to time the DBA's need to restart that database. As a result, the open db connections start throwing broken pipe errors. It appears that JIRA (probably Tomcat) closes these as they throw errors with use and open new connections. As a pro-active measure, we have restarted JIRA to clean these connections out. We would rather leave the JIRA instance alone and only address refreshing the connection pool. I am not seeing anything in JIRA to do this. Also, I am reluctant to go poking around in that Atlassain configured Tomcat install without some Atlassain documentation to back up this approach. (unless someone else has already) Ideally, we are looking for a CLI answer and possibly cron this task.

1 answer

1 accepted

1 vote

If you specify a validation-query, ie "select 1 from dual", it will be tested when it's borrowed from the pool.

See atlassian's docs for exact details.

However I'd recommend you just get the oracle DBAs to stop bouncing the database.

Thanks, I see that now. And I see the same thing for Confluence, and I will use that there too. This feautre lines up with the behaviour we were seeing were the 'bad' connections seem to dissapear over time. With this, the user never sees an error.

It is no fault of the DBA's as they are under the same artifical constructs created by the archetypal obstinance of management as the rest of us.

Hrm, so they say.

There is a cost to this. Indexing on my oracle instance takes 3 hours without the validation query, and 4 hours with. In a 2 hour period during the indexing, the validation query was seen to run 4 billion times. Unless you have very low latency you are going to feel the effects of that.

Anyway, last weekend I moved from oracle to postgres, and now it's all gravy. Annoyingly though, I see Atlassian are just starting to fix some of the oracle-specific bugs.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

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 ...

3,293 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot