nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JIRA does not connect to database after reboot

Jan Hendrik Kühnemund

After rebooting the Container Jira is running in due to a scheduled reboot of the underlying server the web interface shows me the following error:

Database: JIRA couldn't connect to your database

The database I am using is postgres 11.7 running on a containerised ubuntu 19.10, which is the same container jira is running on. I'm using the Jira Self Hosted Starter Package. (Not the Cloud Product which it says on the right side of this page)

I did took a look at the open ports with netstat and the port is up and the database is running well (according to systemctl). I also connected to the database with pgAdmin4 and did have no problems connecting.

Also I did not find any errors in the atlassian-jira.log file which I just tried to add a redacted version if which is still not possible to to the char limit.

Accepted answers

Brant Schroeder

Jan,

It is odd that there is no information in the log. I am wondering if the DB was just not fully up when Jira was ready to connect. If you restart the Jira service does it connect to the DB?

All comments

Brant Schroeder

Jan,

It is odd that there is no information in the log. I am wondering if the DB was just not fully up when Jira was ready to connect. If you restart the Jira service does it connect to the DB?

Jan Hendrik Kühnemund

I just tried it but it sadly did not work.. However I found something:

2020-08-15 16:07:06,905+0000 JIRA-Bootstrap INFO [c.a.j.config.database.DatabaseConfigHandler] Trying to get encrypted password from xml and decrypt it
2020-08-15 16:07:06,905+0000 JIRA-Bootstrap INFO [c.a.j.config.database.DatabaseConfigHandler] Database password decryption not performed.
2020-08-15 16:07:11,986+0000 JIRA-Bootstrap INFO [c.a.j.config.database.DatabaseConfigurationManagerImpl] The database is configured. Now running Database Checklist Launcher
2020-08-15 16:07:11,987+0000 JIRA-Bootstrap INFO [c.a.jira.startup.DatabaseChecklistLauncher] JIRA database startup checks completed successfully.

It did say the database was not decrypted, buit it also said that the database startup checks were performed successfully. It also did not throw an error. Is this normal?

Brant Schroeder

Do you know the DB Password? If you do I would suggest going through the encryption process again and ensuring the the proper encrypted password is in place in the DBconfig.xml.

Jan Hendrik Kühnemund

I'm sorry, there was a misunderstanding on my side. I did not encrypt the database but thought that maybe Jira did that on its own. So that cannot be the error.
Is there a way I can upload a log file here? I just can't seem to find which parts are relevant, given I can't find an error in the catalina log.

Also I can now see I raised this question the wrong way. I'll edit the top post for more details.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software