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?

[Nic Brough -Adaptavist-]

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

[Thiago Masutti]

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 h2db.mv.db 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!