Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How can I change the database connection pool settings

We are running confluence in an open shift container and cannot modify f. e. the confluence.cfg.xml file, when confluence is running.

We also tried to modify the confluence.cfg.xml, but there is no vi in the image delivered by Atlassian.

We could stop confluence and change the file on the worker node  but this is highly against our policy about managing applications.

Due to the upgrade of confluence from 6.15.10 to 7.4.8 we face the following error message after the installation:

"Database: your database connection pool allows 60 connections, which is not enough to support the 100 HTTP threads in your Tomcat configuration. Either increase the pool size to at least 125 connections or reduce the maximum number of HTTP threads to 48 or fewer."

We configured and mounted a config map with a confluence.cfg.xml file with the correct parameter setting (hibernate.c3p0.max_size ==>125). We figured out, that after the deployment, Confluence tries to generate the confluence.cfg.xml file by itself and to save it into it's home directory. Unfortunately it doesn't work, the bootstrap could not be initialized, even though the rights on the file were 666.

1 answer

0 votes

Confluence only tries to write a confluence.cfg.xml file when it is being installed.  If it is an upgrade, it leaves the file alone, but needs you to update it to include the new pooling requirements (among other things) - this is because the upgrade can not know and hence deal with everything you might have tweaked in there, and it doesn't want to trash anything you might have.

I'm afraid you have to edit that file, vi or no vi.  I thought the image had another editor in it though - nano or something?

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Service Management

Security Advisory for Jira Service Management

On October 20, 2021, Atlassian published a security advisory for Jira Service Management. The full advisory is available at this link.  We've seen a number of questions already asking for...

72 views 0 1
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you