After update "Database: JIRA couldn't connect to your database"

Question

Hi,

recently we expanded the size of our VM disk and Jira was running well. Now I updated to 8.20.22 and after startup it shows following screen:

Jira had problems starting up

This page is for Jira administrators. If you're seeing this page, your Jira administrator is probably working to restore the service.

Database: JIRA couldn't connect to your database

JIRA failed to establish a connection to your database.
This could be because:

* Your database isn't running
* The configuration of your dbconfig.xml file is incorrect (user, password, or database URL etc.)
* There is a network issue between JIRA and your database (e.g. firewall, database doesn't allow remote access etc.)

-----

I´ve already looked into the logs and was looking for a solution but unfortunately nothing found. The only option I see is a rollback to the previous version - but I guess this would happen again after upgrading it.

Any ideas how to solve this?

---

Just in case some logs attached (don´t know if its the right file "atlassian-jira.log"):

2023-05-11 16:21:16,917+0200 http-nio-8080-exec-23 WARN anonymous 981x244x1 - 10.249.48.13 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.paths' from database. Using default
2023-05-11 16:21:16,917+0200 http-nio-8080-exec-23 WARN anonymous 981x244x1 - 10.249.48.13 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.clauses' from database. Using default
2023-05-11 16:21:18,913+0200 http-nio-8080-exec-24 WARN anonymous 981x245x1 - 10.249.48.13 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default
2023-05-11 16:21:18,913+0200 http-nio-8080-exec-24 WARN anonymous 981x245x1 - 10.249.48.13 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default
2023-05-11 16:21:18,913+0200 http-nio-8080-exec-24 WARN anonymous 981x245x1 - 10.249.48.13 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.paths' from database. Using default
2023-05-11 16:21:18,913+0200 http-nio-8080-exec-24 WARN anonymous 981x245x1 - 10.249.48.13 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.clauses' from database. Using default
2023-05-11 16:21:32,920+0200 http-nio-8080-exec-25 WARN anonymous 981x246x1 - 10.249.48.13 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default
2023-05-11 16:21:32,920+0200 http-nio-8080-exec-25 WARN anonymous 981x246x1 - 10.249.48.13 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default
2023-05-11 16:21:32,920+0200 http-nio-8080-exec-25 WARN anonymous 981x246x1 - 10.249.48.13 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.paths' from database. Using default
2023-05-11 16:21:32,920+0200 http-nio-8080-exec-25 WARN anonymous 981x246x1 - 10.249.48.13 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.clauses' from database. Using default
2023-05-11 16:21:34,919+0200 http-nio-8080-exec-1 WARN anonymous 981x247x1 - 10.249.48.13 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default
2023-05-11 16:21:34,919+0200 http-nio-8080-exec-1 WARN anonymous 981x247x1 - 10.249.48.13 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default
2023-05-11 16:21:34,919+0200 http-nio-8080-exec-1 WARN anonymous 981x247x1 - 10.249.48.13 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.paths' from database. Using default
2023-05-11 16:21:34,919+0200 http-nio-8080-exec-1 WARN anonymous 981x247x1 - 10.249.48.13 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.clauses' from database. Using default

...

Thanks in advance!

Mihai Schwarz · Answer

@Wilhelm - the holy reboot fixeses everything.

I think it was more of a network issue rather than an application issue.

Wilhelm_mjjbht · Answer

Hi @Mihai Schwarz,

thank you for the suggestion! After trying many different possible solutions and restarting the server several times it started working again.

Mihai Schwarz · Answer

Hi @Wilhelm ,

Please check this article https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-a-database-938846850.html based on your DB type select the article from the list.

Additionally try to ping your database from your application server to see if you have a connection between them.

Look at the previous dbconfig.xml file (before the upgrade, if you made a backup) if connection string is the same with the one in your existing dbconfig.xml file.

Hope this helps!