Jira 9.5.1 to 10.3.3 Upgrade – Are There Any Database Schema Changes?

Question

Hi Atlassian Community,

We are planning an upgrade from Jira 9.5.1 to 10.3.3 and need to confirm if there are any database schema changes introduced between these versions.

So far, we have identified the timestamp precision enhancement in Jira 10.0.x, where the created column in jiraissue, jiraaction, and changegroup tables were updated to millisecond precision (impacting Oracle & MySQL databases).

However, we want to ensure we are not missing any other schema changes across versions 9.5.1 to 10.3.3

unknown · Answer

But I also expect that the DC upgrade process handles all this for you.

Exactly. The schema needs to be what it needs to be, and that change MUST AND WILL HAPPEN during the upgrade, whether you like it or.

Matt Doar _Adaptavist_ · Answer

You can look at the definition of the core product database tables with a command such as

diff atlassian-jira-software-10.0.0-standalone/atlassian-jira/WEB-INF/classes/entitydefs/entitymodel.xml  atlassian-jira-software-10.4.1-standalone/atlassian-jira/WEB-INF/classes/entitydefs/entitymodel.xml

There are also some *Upgrade*.java files that are run for each upgrade that will tell you how the data in the existing tables may have been changed.

I would expect that there are some schema changes between versions. But I also expect that the DC upgrade process handles all this for you.

Jairus Holson · Answer

Hello @[deleted]

We are upgrading Jira Data Center from version 9.5.1 to 10.3.3 and want to confirm if there are any database schema changes introduced between these versions.

Database Details:

Database Name : Oracle

Database type: Oracle10g

Database Version: Oracle Database 19c Enterprise Edition Release 19.25.0.00

Our requirement for this information is to ensure that we account for any schema modifications that could impact our Jira’s database structure.

So far, we have identified the timestamp precision enhancement in Jira 10.0.x for the created column in jiraissue, jiraaction, and changegroup tables (affecting Oracle & MySQL).

However, we want to verify if there are any other schema changes between Jira 9.5.1 and 10.3.3 to ensure a smooth transition.

If there are any official schema change documentation links for this upgrade path, that would be greatly appreciated.

Thanks in advance for your support!