Jira had problems starting up

[Momir Cerovina]

Hi Support,

since this morning we are unable to start our Jira. I have tried stoping and starting jira services but I'm getting this errors please see link of our Jira http://148.251.51.174:8000/secure/errors.jsp

Our tim is unable to work can you please help us asp?

[Nic Brough -Adaptavist-]

We can't begin to help if we don't know what the errors you are getting are.

The error you are seeing might tell you something, but for most "it won't serve" errors, it is usually not able to tell you enough, and even if you gave it to us, it's very likely that the next reply will be:

Is Jira actually running at all?  What does the log file say the problem is?  (<jira home>/log/atlassian-jira.log)

[Momir Cerovina]

Hi,

sorry so Jira is running on link I have send already so it is not running when tryin to access to it we are getting above errors.

This is what log file say :

https://symple.ch/prelive/log/atlassian-jira.txt

[Nic Brough -Adaptavist-]

Ok, that log is riddled with SQL errors.  You're using the embedded h2 database for this server, which has probably been corrupted.

This database is susceptible to sudden catastrophic failure with no notice.  Atlassian embed it in systems to get people started - temporary development or test systems, play areas, demos etc, but it is not suitable for real usage and your admins will have been told this repeatedly by the installer and system healthchecks.

Exactly what you do next is down to how you have been taking backups, but:

If you have full file system backups of the data directory, then you should have a copy of a directory called "database" in your backup.  Stop Jira, recover the directory and contents from the backup and restart it.  Then get planning a move to a supported database as a matter of urgency

If you have been using database exports, it's much the same, stop Jira, import from the backup, restart, then plan to migrate to a supported database (although I'd be very surprised if you've gone to the effort of writing a database export process for h2)

If you have been taking regular xml backups, then you'll have files in <jira home>/export.  Install a clean Jira, hooked up to a supported database and then restore from the latest one of the backups in there.