Jira Doesn't start

[HARISH KUMAR SIVAKUMAR]

Jira doesnt startup. I see the below on logs. 

java.lang.IllegalStateException: Reading from cache:nio:/var/atlassian/application-data/jira/database/h2db.mv.db failed; file length 100139008 read length 76
8 at 100198358 [1.4.185/1]

2020-03-23 00:26:58,282 JIRA-Bootstrap ERROR [c.a.config.bootstrap.DefaultAtlassianBootstrapManager] Could not successfully test your database:
org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: Reading from cache:nio:/var/atlassian/application-data/jira/database/h2db.mv.db failed; f
ile length 100139008 read length 768 at 100198358 [1.4.185/1]" [50000-185]

2020-03-23 00:26:58,400 JIRA-Bootstrap ERROR [c.a.jira.health.HealthChecks] JIRA couldn't connect to your database
2020-03-23 00:26:58,400 JIRA-Bootstrap ERROR [c.a.jira.health.HealthChecks] JIRA failed to establish a connection to your database.

2020-03-23 00:26:58,405 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger] Running JIRA startup checks.
2020-03-23 00:26:58,405 JIRA-Bootstrap FATAL [c.a.jira.startup.JiraStartupLogger] Startup check failed. JIRA will be locked.

[Nic Brough -Adaptavist-]

I am really sorry, but this usually means that your h2 database has failed.

h2 is not intended to be used as a real database, it's just for dev/test/play and should never be used for any system you want to keep as a working system (even UAT or longer-term test systems).  It does not scale, and is know to fail catastrophically in some cases.

I would definitely check for a backup and restore that to a supported database (PostGreSQL and MySQL are supported, free, and low enough on resources that you can usually run them locally on the same machine as Jira)

[Petter Gonçalves]

Hello @HARISH KUMAR SIVAKUMAR

Welcome to the Atlassian Community!

Can you please confirm to us if that would be the first time you tried to start Jira? Or has it worked before?

If your Jira application has properly started before, can you confirm if any upgrade or change was performed in the application or in your database?

The errors returned means that your Jira application is not being able to connect to your database, so I suggest you try the following:

1 - Check if you are using one of the supported databases of the documentation below:

Supported Platforms 

2 - Check if any process is locking your database file (h2db.mv.db)

3 - If you have a backup from your Jira installation, try to upload the backup file in a new Jira installation from scratch

For more details, please check the threads below with more information about your error:

JIRA CORE server DOWN!! 

Database: JIRA couldn't connect to your database 

Let us know if you have any questions.

[HARISH KUMAR SIVAKUMAR]

Thanks for the response. 

I Use Jira's embedded Database. 

Yes, the application was up and running for three months. No updates on Jira / DB was done. 

Let me check the option 3

[Petter Gonçalves]

Hello @HARISH KUMAR SIVAKUMAR

Thank you for the details provided.

While you check on option 3, I will keep searching for other possibilities that could be causing the error.