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; } } }

Upgrade JIRA

ajeesh.kannan

Right now I am using :

Versions and licenses

JIRA Software 7.1.10

JIRA Core 7.1.1

I have received the following warning in my JIRA.

WarningEnd of Life.

What does this check do?

Checks if the running version of JIRA is approaching, or has reached End of Life.

Result

JIRA version 7.1.x is approaching End Of Life. Please plan to upgrade JIRA within 184 days.

In my setup IRA is using the H2 embedded database.

From my investigation the message is showing I need to upgrade my JIRA version.
Can you please provide the step by step procedure to upgrade my JIRA version. Which version i need to upgrade. Since the JIRA version is playing an important role in our infrastucture. I am running JIRA,bitbucket and conflunece all in one server.

Accepted answers

All comments

Lars Olav Velle

Atlassian end of life policy:

https://confluence.atlassian.com/support/atlassian-support-end-of-life-policy-201851003.html

Get rid of H2 database. It`s not ment for production at all!

Atlassian has pretty good documentatation regarding upgrades.

https://confluence.atlassian.com/adminjiraserver071/upgrading-jira-applications-802592251.html

-Lars

Nic Brough -Adaptavist-

This check really is just to warn you that you are going to be unsupported in a few months. It does nothing else and nothing will stop working if you let it expire. If you wish to retain full support, start planning an upgrade. Probably to 7.4, but the exact choice is up to you (read the release notes first). Docs are at https://confluence.atlassian.com/adminjiraserver074/upgrading-jira-applications-881683260.html

However. You have a much bigger problem. You should NEVER use the H2 database in a production system. It can fail, catastrophically and completely, at random, without warning. (It happened to my dev system on Monday).

Forget upgrades for now. Check you are getting good backups immediately and drop all your other projects so you can move JIRA to a supported database as soon as possible.

ajeesh.kannan

Is that possible to convert my h2 to a stable database ?

Lars Olav Velle

Yes,

Follow this guide:

https://confluence.atlassian.com/conf57/migrating-from-hsqldb-to-mysql-701435638.html

-Lars

ajeesh.kannan

I am running my applcation in a centos 7 with

bitbucket
confluence
jira

Also I would like to know the latest version 7.4 support H2 embedded database ?

Just a note that i believe the link here should be https://confluence.atlassian.com/adminjiraserver073/upgrading-jira-applications-861253088.html.

Lars, the link you gave is throwing a 404 for me.

ajeesh.kannan

While changing the database from H2 embeded to Postgresql I am getting the following message.

bin]# sh config.sh
No JRE_HOME or JAVA_HOME environment variable is set - attempting to just run java command
*** Wrong JVM version! You are running with java version "1.7.0_101" but JIRA requires at least 1.8 to run.

my Java version is

lib]# java -version
java version "1.7.0_101"

I have upgraded my Jira version JIRA 7.4.2. I have converted my H2 embeded db to Postgrsql in my test postgrsql server.

Can I do the following steps to migrate the db.

1. create postgresql user

2. new database.

using the step mentioned here : https://confluence.atlassian.com/adminjiraserver071/connecting-jira-applications-to-postgresql-802592176.html

3. stop jira server

4. delete dbconfig.xml

5. start Jira server

6. access the jira like and use the postgrsql connection and complete the installation step.

7. FInally restore the converted Postgresql db to to the database.

Please help me on this.

Thank you.

Nic Brough -Adaptavist-

That's just the installation. You have not converted anything yet.

Go back to your old h2 installation, and back it up using the xml export.

Import the resulting file into the new postgres based installation

ajeesh.kannan

Hi,

I have run the config.sh file and update the PostgreSQL db connections (Where I have restored the migrated database from H2), But now I am getting the following error messages:

2017-09-20 20:41:32,969 JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "ID" of table "jiraaction" of entity "Action" is of type "INT8(19)" in the database, but is defined as type "NUMERIC(18,0)" in the entity definition.

lots of like this error as well as

Error was: org.postgresql.util.PSQLException: ERROR: must be owner of relation clusternode

Ihave created the database using the following command.

CREATE DATABASE jiradb WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;

I already granted the user permission to database:

This seems to be an issue with my JIRA postgresql database creation and its permission. Can you please provide some light on this.

ajeesh.kannan

Or it is my conversion time issue(H2 to Postgrsql migration)

Welcome!

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

Quick Links

Find more posts tagged with

jira-software