Database Connection Settings healthcheck fails in Jira server
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
About the Health Check
This health check reviews the current database connection settings in use. The check reviews the settings to confirm that an optimal configuration is set. An optimal configuration will improve stability and protect against problems relating to Database Connection Pools when using an External Database (Such as MS SQL, MySQL, Oracle or PostgreSQL). Only JDBC Datasource connections are checked. Embedded Databases (Such as H2) and database configurations relying on a JNDI configuration are not checked.
Understanding the Results
Depending on your database you will see different results:
Impact
In most cases, a configuration that does cause the Health Check to report a warning will likely result in a potential database communication error in the future or slower interaction with the database. A database communication problem may result in JIRA becoming unavailable to users, while slow communications might result in timeouts being experienced within JIRA. Ideally the documented database configuration should be used. Very limited situations may still warrant an alternative configuration to the one prescribed.
Why is this not set by default for new installs?
It is, as of JIRA 7.1.4 and higher. Previous versions of JIRA that execute this health check will experience warnings with the default configuration - any future installs that are configured as a new install will not. If upgrading to 7.1.4 from a previous version, the dbconfig.xml
is not updated automatically so will need to be done manually.
Resolution
Flag Information
Below are the flags that will be reported by this health check, and what checks are made for each flag.