Database is not empty issue.

I'm upgrading Jira from 4.0.1 to 6.1 WAR .

I've tried to follow all the instructions here:

https://confluence.atlassian.com/display/JIRA060/Upgrading+JIRA+with+a+Fallback+Method

I thought I'd done everything right,

but yhen i start JIRA, I get the JIRA Setup Database Configuration screen. When I enter all the info about the database, it says,

"The database specified is not empty. Please specify an empty database for your JIRA installation."

What do I need to do to stop getting the Setup and instead get the login page?

Thanks.

6 answers

1 accepted

Firstly, I do not think you should be using this document to upgrade since if you read the first line it says This page describes how to upgrade JIRA 4.4.x or later in a way that allows......

and you are on 4.0.1.

So, i would recommend

1. since you are on a very old version, i would recommend you to upgrade to an intermediate version using xml export and import.

2. Once you reach to a version 4.4 or higher then use the database pointing method to upgrade.

Rahul

I agree with @Rahul's suggestion, maybe except the idea of pointing to the database. Upgrading a WAR is different than upgrading using a standard JIRA installation mechanism. The best way around this is to connect the new JIRA WAR to use a new database, and then import the XML data into it. I believe this documentation on how to upgrade JIRA manually should be helpful for you.

This method allows the current JIRA to be still up and running, plus the risk of losing data is very minimal; since you are installing a new version of JIRA on a different path than the original.

Good luck!

Thank you both! I did with an empty database and xml import. Therefore, I ve got an issue with connecting to the new jira: my user (from my old installation) is not found by Jira. Did I miss an upgrading step? Thank you, Pierre

Hi Pierre,

have you been able to upgrade JIRA and restore your backup successfully? I assume you mean that you're unable to login, but I'm not sure what error you are having?

You can look up all the existing user account in your database, using the following query:

SELECT * FROM cwd_user;

then you can see if your username is listed there.

Generally you can look at this documentation page:https://confluence.atlassian.com/display/JIRA/Retrieving+the+JIRA+Administrator for other possible database actions you can take to troubleshoot why JIRA can't find your user account or to add a user account from the database.

Remember to be careful when making modifications to JIRA directly from the database, and be sure you understand what you're doing.

All the best!

Thank you both! I did with an empty database and xml import. Therefore, I ve got an issue with connecting to the new jira: my user (from my old installation) is not found by Jira. Did I miss an upgrading step? Thank you, Pierre
0 vote

Hi Pierre,

have you been able to upgrade JIRA and restore your backup successfully? I assume you mean that you're unable to login, but I'm not sure what error you are having?

You can look up all the existing user account in your database, using the following query:

SELECT * FROM cwd_user;

then you can see if your username is listed there.

Generally you can look at this documentation page: https://confluence.atlassian.com/display/JIRA/Retrieving+the+JIRA+Administrator for other possible database actions you can take to troubleshoot why JIRA can't find your user account or to add a user account from the database.

Remember to be careful when making modifications to JIRA directly from the database, and be sure you understand what you're doing.

All the best!

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

70 views 0 5
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you