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

Accepted Answer
1 vote

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 votes

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 all!

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 18, 2018 in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

21,588 views 2 7
Join discussion

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