When we are restarting the Atlassian JIRA We are unable to get the JIRA Service Desk to be started due to the below exception.
Unable to start JIRA.
Caused by: java.lang.ClassNotFoundException: com.atlassian.jira.health.checks.database.MySqlJdbcUrlHealthCheck
... 10 more
This means that either your Jira installation is damaged (missing/corrupt deployed files), you can't access the installation files (permissions on the file system?) or you are running with an unsupported version of Java.
In the first case, it might also be just a missing mysql driver, but there's not enough of the error message here to say that with any confidence.
Could you check:
1. JIRA Version is 8.2.2.
2. Java Version is 1.8.0_121.
3. Our JIRA Service Desk is deployed on H2 Embedded Database and not on MySql database.Please send us that particular Jar file which it is looking for.
4. JIRA Installation Directory as well as JIRA Data directory has access to the User running it.
Ah, there's another case that I suspect is happening here.
If you read further through the error, I suspect you'll find that there's a preceding error in it trying to look at your h2 database. If it fails to do that, it then goes looking for healthchecks on other databases (such as mysql) and can then trigger errors such as this one.
I strongly suspect that your h2 database is corrupted and unreadable.
Could you read back through the log to where the errors first started to occur as it starts up and check to see if the first mention not being able to read the h2 database?
If it is that, then you'll need to get a clean install of Jira (ideally hook it up to a supported database) and restore from the last backup
Getting this exception while trying to read the database which is in the dbconfig.xml.
The Database configured is H2Embeeded database.
Please see the exception which is occurring while connecting to the same database from the DBeaver Client.The size of the DB file is 24GB...
I am not able to track anywhere that it is trying to read the database file of H2, but while stopping the JIRA Service it is trying to read.
Pattern is it is checking the MYSQL Database file and stopping to start the JIRA since no database is available.But we have the H2 DB Configuration in the dbconfig.xml file.
We need the JIRA download for the 8.2.2 Version which we will cross check any jars are missing.
You are "barking up the wrong tree" here.
When you say "Pattern is it is checking the MYSQL Database file and stopping to start the JIRA since no database is available.But we have the H2 DB Configuration in the dbconfig.xml file."
That is not quite what it is doing. As I said before, what it is doing it trying to read the H2 database, failing, and then moving on to do a general database health check, which is throwing the error about a missing mysql driver.
>We need the JIRA download for the 8.2.2 Version which we will cross check any jars are missing.
While you are missing the mysql driver jar, that is not the problem here. You are missing it because you have to install it manually due to licence restrictions if you want to use MySQL for the database. You didn't install it becuase you went with h2. But you don't need it, and all it will do is remove the mysql driver error from the logs.
The rest of your errors will still happen, and your Jira will still fail to work. Just installing that driver is not going to fix your problem, you've got a broken h2 database and you need to fix that.
Your next steps are:
1. Add the mysql driver (please see the Jira installation documents for your version on how to do that).
There's a 99.99% chance this will do nothing more useful than get rid of one error in the logs, your Jira is still going to fail because of the actual problem
2. Fix your H2 database, as it is damaged and that damage is making Jira fail
Hello Community members! We’re wrapping up the end of JSM June with an Ask Me Anything (AMA) with the Jira Service Management product team. This is your chance to ask all your ITSM questions to o...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events