Recommended upgrade path Jira 7.0.2 -> 7.4.2 (?)

Joel Kåberg

We are in the process of upgrading Jira from 7.0.2 to 7.4.2 and at the same time migrate from the built in database to a postgresql database.

As per documentation is simply seems like:

- Export config/issues in admin area

- Stop Jira

- Upgrade Jira

- Remove dbconfig.xml

- Start Jira

- Config new postgresql connection

- Import config/issues in admin area

- Done (?)

However this doesn't work for us. Whenever we try to do it like this we get the following error: https://confluence.atlassian.com/jirakb/error-when-logging-in-or-visiting-dashboards-864653761.html

However none of the issues applies to our setup. We have no application links and we only have one dashboard (default system).

It seems to me when the upgrade takes place, it doesn't alter all tables in the database? 

Note that simply migrating from 7.0.2 builtin database to postgresql (still Jira 7.0.2) doesn't have this problem. 

Nic Brough -Adaptavist-

That is not what the documentation says.

You have two *separate* tasks here.  Upgrading a system, and changing the database.  In terms of time, you might well be doing them in one go, but there are two processes.

Your steps will perform two upgrades.  One of them is redundent and the other not the recommended way to do it, and is probably the cause of the problems you're having.

You should migrate first by exporting and importing the xml.  Then upgrade the migrated system.  You could do it the other way around, but the built-in database is not a production class solution and it's prone to fail during complex actions like upgrades.