JIRA upgradation from 8.13 to 8.21.0 was successful but JIRA unable to start

Question

Hi Team,

I am using trial version of JIRA 8.13 and trying to upgrade it to 8.21.0. I have set up JIRA 8.13 with default embedded database ( express installation), now I am trying to upgrade to higher version. Before start my upgradation I have taken back up of only JIRA home and installation directories but not database because I have installed JIRA with default database.

After upgradation successful, my JIRA is giving error like....

Jira had problems starting up...

Please help me to resolve this error.

Ravi Sagar _Sparxsys_ · Answer

Hi @Devendar Gangapuram

Check if your Jira has taken some scheduled xml backups in the export directory. If you can find the xml then install fresh Jira 8.13 and restore the latest xml.

Also it is worth checking the permissions on dbconfig.xml, check if the user running Jira has permissions to this file.

Most importantly as @Nic Brough -Adaptavist- mentioned don't use embedded database for your production instance. Setup MySQL or PostgreSQL and use that instead.

I hope it helps.

Ravi

Nic Brough -Adaptavist- · Answer

Ok, so you chose the h2 embedded database when you installed this Jira.

The usual problem with h2 when you get a "can't connect" is that it has simply failed.  It's rarely worth the effort of trying to debug this, you have to faff around with installing ways to read the database and check its data and content, and almost every time you do this, you'll find it has crashed out and lost a large chunk of your data.

I strongly recommend you revert to a backup to start with, you'll probably have to anyway.

Nic Brough -Adaptavist- · Answer

I am afraid that tells us nothing.  You'll need to debug why it can't connect to the database.