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

[Jairus Holson]

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

[Matt Doar (Adaptavist)]

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.

[Sunny Ape]

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.

[Sunny Ape]

Hello @Jairus Holson 

we want to ensure we are not missing any other schema changes

Which database are you currently using with Jira DC v9.5?

What is your requirement for this information? IE, if there are other changes to the schema in v10.3 compared to v9.5, how or why will 'missing' those changes affect your database / organisation / applications?

[Jairus Holson]

Hello @Sunny Ape 

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!