nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How does the JIRA database upgrade process work?

Mike Soultanian

Let's say I have two JIRA servers (A, and their two respective database servers. I have 6.0.6 installed on A and 6.3.13 on B. I then duplicate A's database to B's database and point JIRA B (6.3.13) to it's new database (which contains the 6.0.6 database). When the 6.3.13 instance of JIRA sees the 6.0.6 database on its respective database server, does it just go ahead and upgrade the database?

The reason I ask is because I'm going to install a new version of 6.3.13 on a new instance and test things out on a test database (which well then have been upgraded to 6.3.13). Then when I am ready to migrate to the new version, can I just point JIRA 6.3.13 to a production 6.0.6 replicated database and things will just start working?

Thanks!

Mike

Accepted answers

All comments

Nic Brough -Adaptavist-

>When the 6.3.13 instance of JIRA sees the 6.0.6 database on its respective database server, does it just go ahead and upgrade the database

Yes.

Well, that was easy wink . In reality, that answer has caveats - addons, customisations, and bugs can all break it, and badly. But in theory, you should be able to do exactly that. However, exactly as you say you're going to do, you really need to test it.

Your approach is perfectly valid and it should work, but it's not the recommended approach and it is missing a step.

The recommended approach is to run the 6.3 installer and tell it that you've got a 6.0 to upgrade. Again, I say "in theory" because, although it should cover everything, it needs testing, every time.

The missing step if you're going to go with "install 6.3 and point it at a 6.0 database" is that you need to copy the home directory to the new installation before running it. This is not quite as "recommended" as "run the installer", but it is very close, because the installer pretty much does the same thing in the background.

Mike Soultanian

I've only done an upgrade - never a fresh install. When I do a fresh install, is there a way for me to point it at the 6.0.3 database to tell the fresh install that it's an upgrade?

Unless I'm misunderstanding the documentation, it seems like it states to have a backup (current production) and new instance (to-be new production) and to do a fresh install on the new instance and point it to a copy of the current production database. Then once your happy you take the new instance live and retire the old server. So if I'm installing a fresh copy of JIRA on a new instance, it's not going to know about upgrading because there's nothing on the computer - the only way it'll "know" it's an upgrade is if there's some marker in the database that says the database was being utilized by a 6.0.3 JIRA install and needs updating...

Am I just confused? wink

Thanks!

Nic Brough -Adaptavist-

>When I do a fresh install, is there a way for me to point it at the 6.0.3 database to tell the fresh install that it's an upgrade? The bad news: No, you can't (well, without a huge amount of unnecessary mucking around) The good news: You don't need to. Your idea about the database marker is right - the database contains version data. A new version reads it and goes "Oh, I need to run upgrade-data code" And your interpretation of the documentation is right, except that you've missed the point that you really should still copy over the home directory. (Actually, skip the attachments, as that really is just copy them in order to make them available, the upgrade really doesn't need them. And you can skip the index. The upgrade is going to chuck it away and rebuild a completely new one anyway)

Mike Soultanian

Ok.. I read further in the upgrade instructions and I saw what you said about copying over the home files. I also saw some mention of copying over any other changed files, but then it's difficult to figure out which files have actually been changed. I'm tempted to just do an in-place upgrade on the same box with a prior snapshot so that I can just update the files that the JIRA installer notices to have been changed and be done with it - the whole migrate to another box seems tedious.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-administration