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.

[Brant Schroeder · Accepted solution]

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.

[Brant Schroeder]

You can copy and paste in the log information.  If you reboot the service you can copy the startup which should contain any errors.  The DB is not encrypted only the credentials in the connection string.  Do you know the DB password?  IF you do you can update the connection string and fix the issue.

[Jan Hendrik Kühnemund]

I'm sorry it seems a reboot of the jira application actually did the trick. The error is still shown to me even after emptying the cache but on another browser it works.

Looks like this is not a jira issue.. Thank you for taking the time!