Jira not starting any more

[D_ Be_]

Hello,
my instance is not starting any more after a power loss (see screenshot with error message attached), the last running backup is from 2021-01-23, so I better need to restore the current version. Is there any way to get it running again?
Greetings

[Nic Brough -Adaptavist- · Accepted solution]

Lower down in the error message, there are a load of references that tell us that your system is using the embedded h2 database.

This thing is for demo/dev/test purposes only - throwaway instances that you don't mind losing and having to rebuild if needed, they're not fit for production because the h2 database can fail catastrophically without warning.

I would guess that this has happened here - power loss can cause a complete h2 failure quite easily.

Sometimes, you can rescue them, but the error you have here is not one I have seen rescued before.

So, yes, you probably should recover from the latest backup.  The easiest way to do this would be to install a new copy of Jira, of exactly the same version, get it running ok (to a point where the admin can log into an empty system), and then tell it to do a full import from the xml in the 2021-01-23 backup.

I would have a look in the <jira home>/export directory first, in case there are more recent xml backups in there.

Finally, when you set up the new instance, I'd plan to do it with a supported database - if you're importing from XML, that will do all the data migration for you automatically, and leave you with a stable system (if the power dies on a supported database, the worst case is a couple of bad writes into the database which won't break much, if anything)

[D_ Be_]

Hi Nic,

thanks a lot for your detailed answer. It was a good advice to look in the <jira home>/export directory, as I found there a backup instance from exactly before the power loss (2021-Mär-16--1127.zip) in the remainings of the broken system.

I could restore the whole thing as follows:

- I imported the *.ova VirtualBox Appliance with the last working Jira VM Instance from 2021-01-23

- After that, I imported 2021-Mär-16--1127.zip via Web Interface

- Finally, I extracted the "data" dir (containing attachments and avatars) from the broken system and scp'ed it to the restored system

- After taking care of restoring the rights (chown, chgrp, chmod) for jira dir, everything is working fine again now :)

But anyway, I am now thinking about getting a more stable database solution: is there any link to a tutorial for this task, or can you explain me in a nutshell how to easily switch to a more stable database solution?

Kind regards

David

[Nic Brough -Adaptavist-]

Switching databases isn't too complex fortunately.

Install or find a database server, set up an empty database configured for Jira, get an xml export of your current Jira, repoint it so the empty one starts up ok, then import the xml.

The longer version (worth a look as the bit where you commission a database is dependent on which one and "repoint it" is a bit more fiddly than I breezed over there) - https://confluence.atlassian.com/adminjiraserver/switching-databases-938846867.html

[D_ Be_]

Hello,

please note that I use a server instance, not the cloud version.

Greetings

[John Funk]

Hi David - it looks like there is an active incident being worked. You can follow along here:

https://jira-software.status.atlassian.com/