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:
Come on Atlassian, surely these are the first things you check when publishing an upgrade?
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.
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):
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.
👋 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...
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