It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Database is not empty issue.

Pierre Granzotto Jul 10, 2013

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

1 vote
Answer accepted
Rahul Aich [Nagra] Jul 10, 2013

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!

0 votes
Pierre Granzotto Jul 11, 2013
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
Taiwo Akindele Atlassian Team Jul 11, 2013

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!

0 votes
Pierre Granzotto Jul 11, 2013
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
Taiwo Akindele Atlassian Team Jul 11, 2013

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!

0 votes
Pierre Granzotto Jul 16, 2013
Thank you all!

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Next-gen

Introducing subtasks for breaking down work in next-gen projects

Teams break work down in order to help simplify complex tasks. This is often done iteratively, with tasks being broken down into smaller tasks and so on until the work is accurately captured in well-...

9,374 views 30 42
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you