Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

jira core8. 9 failed to connect to the database after upgrading to 8.20

Did JIRA core upgrade the built-in H2 database version to 1.4.200 when it was version 8.18? H2 database versions before 8.18 are 1.4.185? Dbconfig. After upgrading H2 database Does the XML file need to be modified?

2 answers

0 votes

Yes h2 changes version in some releases of Jira.  You should not need to modify anything to make it work during an upgrade.

But you shouldn't care about it. 

You should not be using h2 for anything other than development, test or demonstrations.  You certainly shouldn't be using it to test upgrades, nor upgrading h2 outside Jira

0 votes

Hi @周慧华 .
I hope you are well.

This change is detailed on the upgrade notes: Jira Software 8.18.x upgrade notes .

H2 database upgrade

In this release we've upgraded the embedded H2 database, which is often used when evaluating Jira. This is a significant upgrade which contains some breaking changes. 

If you attempt to upgrade Jira running on the embedded H2 database, follow this procedure:

  1. Create XML backup from the instance to be upgraded.
  2. Remove file (from ${jira_home}/database).
  3. Run the new Jira instance.
  4. Restore XML backup

Migrate your data to a supported database

If you are using H2 in production, you will need to migrate to a supported external database before upgrading your instance. 

See Switching databases for a step by step guide.


Kind regards,
Thiago Masutti

OK,Thank you very much!

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira Service Management

Jira Service Management Documentation Opportunities

Hello everyone, Hope everyone is safe! A few months ago we posted an article sharing all the new articles and documentation that we, the AMER Jira Service Management team created. As mentioned ...

304 views 0 9
Join discussion

Community Events

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

Events near you