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
4,295,550
Community Members
 
Community Events
165
Community Groups

Upgrade to Jira 9.0 Errors

Edited

I upgraded Jira using the latest Docker image to Jira version 9.0

Three issues have occurred:

1. Jira complains that the db and table collations are not compatible. Both are set to UTFMB8_BIN on a MySQL 8 database, which is expressly what is required by Jira.

Obviously, the system still works, but why is it throwing this error?

2. When I view a Jira board, I get the following error:

SELECT ID, PROJECT, cname, description, URL, `LEAD`, ASSIGNEETYPE, ARCHIVED, DELETED FROM component WHERE PROJECT=? ORDER BY cname (Unknown column 'DELETED' in 'field list')

In the database schema for version 8.20, there is no DELETED column, so I can only assume that this has been introduced by version 9.0. Since there is no published schema for version 9.0, I can't update it manually (could be boolean, could be decimal, could be varchar).

Again, the system still works, but I would expect any upgrade to apply schema changes itself.

3. Navigating to the Components screen, I get the following error:

Jira's base URL is set to https://{url} but you are accessing Jira from https://{url}undefined.

Come on Atlassian, surely these are the first things you check when publishing an upgrade?

1 answer

0 votes

Are all three collation settings correct on your database?

How did you perform the upgrade on your data?

Yes, all three collations are correct on the database. Version 8.22.3 doesn't complain about the collation at all.

I use the Docker Hub instance of Jira-Software:latest, so it just replaces the entire container, and restarts automatically. I've read the release notes, and there is no indication that I need to run anything else to complete the upgrade.

Yeah, replacing an install is not an upgrade.

You'll need to run an upgrade.

Running an upgrade involves installing the new version. The instructions for an upgrade is to basically copy over the new files and run Jira (slightly more detail here: https://confluence.atlassian.com/adminjiraserver/upgrading-jira-manual-938846939.html)

Updating the Docker container from 8.22.3 to 9.0 is doing exactly the same thing. If you had to run an upgrade on your data using a non-dockerised install, and then replace it with the latest Docker container, that would completely abrograte the point of Docker containers.

Note the warning on that page under the summary to-do list.

For the jump for 8 to 9, that absolutely applies - you can NOT just smack a new release over the top of the old one.

You need to run the upgrader in full.

The docker containers are for clean installations.

I must respectfully disagree with your statement that the docker containers are for clean installations: Docker containers are designed expressly for in-place upgrades, removing the downtime and effort required for a manual install.

Furthermore, it is expressly stated on the page for Jira that you can do the upgrade (https://hub.docker.com/r/atlassian/jira-software):

Upgrades

To upgrade to a more recent version of Jira you can simply stop the jira container and start a new one based on a more recent image:

docker stop jira
docker rm jira
docker run ... (See above)

As your data is stored in the data volume directory on the host it will still be available after the upgrade.

 

If this is not the case, then this needs to be made clear to end users, and the steps provided to upgrade the database. Suggesting that you must run a full manual install to upgrade your database, before then upgrading the docker container is not a solution.

It's clearly not for upgrades - the upgrade process changes the shape of the database, and that's not happening when you swap 9 in over 8.

You're right that Atlassian have not accurately documented this failure.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
9.0
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,459 views 37 44
Read article

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