Recommended upgrade path Jira 7.0.2 -> 7.4.2 (?) Edited

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:

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. 

1 answer

0 vote

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.

Thanks for you reply, Nic. I'm unsure what you're trying to say. Migrating from H2 database to postgresql is OK (documentation I followed is here, - Jira works fine.

When I then proceed to upgrade Jira from 7.0.2 to 7.4.2 I get the issue described in OP. Followed documentation

I've tried doing the task both seperately and combined, same result both times.

The process you posted originally went:

  • Export
  • Upgrade
  • Swap to new database
  • Import the old data, so it would have to upgrade and migrate in one step

Your comment now says you're doing it in the best order now, so that concern has gone away.

What does the SQL in the KB article tell you?

Yes, I noticed I wrote it wrong here so I corrected it.

The SQL query noted in the KB gives 0 results (there is only 1 dashboard - the default one), aswell as there no Application Links in Administration->Application->Application Links.

Interesting, not one I've seen before.  Could you try adding a new dashboard (no need to share it) and see if the error changes?

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Feb 15, 2018 in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

1,196 views 6 19
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot