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

Jira - New installation, "old" Database

Fab Aug 10, 2014

Hey folks,

i am supposed to migrate my companies Jira installation from one server to another, keeping the old Database, which is running on yet another server.

what i did so far is:

i have set up a new installation of Jira (same version as before, 6.1.5) and after installation, i used the setup wizard to import the .xml backup of the productive db.

Now i should switch the DB to our production one. I figured out the following procedure to do so and it would be nice if someone could tell me, if it will work in that way and if not, what am i supposed to do to make it work:

  1. shut down jira (old and new)
  2. get a backup of the home directory
  3. copy the backup into the "new" jira home folder
  4. make the new connection by using the jira configuration tool / delete or rename the "dbconfig.xml" and use the setup wizard again

greetings from germany

fabian

9 answers

1 accepted

0 votes
Answer accepted
Mehmet Kazgan Aug 10, 2014

Sounds like you got it right, Fabian.Make sure you get a backup of the .XML and the database .bak just in case.

Fab Aug 11, 2014

ok my problem is now, that i can access at least jira using browser, but i get this message, which is pretty frustrating aswell

We have detected that JIRA is configured to connect to a database from a previous version of JIRA. If you have just upgraded JIRA, you may need to consult the 3.7 Upgrade Guide.

the end of the logfile is attached to this post

i am desperate, i am at work for 18 hours now and my brain is fried... i hope someone of you guys has a solution for our problem. i will check in 8 hours again, when i will be here at work again

have a good night guys

0 votes
Fab Aug 10, 2014

hi mehmet, hi guys

i just told jira, by using the configtool, what is the database (tested successfully) and what is the home-path.

now jira is redirecting to http://jiralockederroror something similar... i am close to desperation. :(

someone familiar with this issue?

0 votes
Mehmet Kazgan Aug 11, 2014

Bruna got the answer for deadlock.

0 votes
Fab Aug 11, 2014


********************************************************************************************************************************************************************************************************
We have detected that JIRA is configured to connect to a database from a previous version of JIRA. If you have just upgraded JIRA, you may need to consult <a href="http://confluence.atlassian.com/display/JIRA/JIRA+3.7+Upgrade+Guide">the 3.7 Upgrade Guide</a>.
********************************************************************************************************************************************************************************************************

2014-08-11 22:47:28,125 localhost-startStop-1 FATAL [atlassian.jira.startup.DatabaseChecklistLauncher] Build178SchemaCheck failed: We have detected that JIRA is configured to connect to a database from a previous version of JIRA. If you have just upgraded JIRA, you may need to consult <a href="http://confluence.atlassian.com/display/JIRA/JIRA+3.7+Upgrade+Guide">the 3.7 Upgrade Guide</a>.
2014-08-11 22:47:28,125 localhost-startStop-1 FATAL [atlassian.jira.startup.DatabaseChecklistLauncher] Database startup check failed.
2014-08-11 22:47:28,144 localhost-startStop-1 INFO [jira.config.database.DatabaseConfigurationManagerImpl] Now running Post database-configuration launchers
2014-08-11 22:47:28,459 localhost-startStop-1 INFO [core.entity.jdbc.DatabaseUtil] Database Product Name is PostgreSQL
2014-08-11 22:47:28,460 localhost-startStop-1 INFO [core.entity.jdbc.DatabaseUtil] Database Product Version is 8.3.13
2014-08-11 22:47:28,460 localhost-startStop-1 INFO [core.entity.jdbc.DatabaseUtil] Database Driver Name is PostgreSQL Native Driver
2014-08-11 22:47:28,460 localhost-startStop-1 INFO [core.entity.jdbc.DatabaseUtil] Database Driver Version is PostgreSQL 9.0 JDBC4 (build 801)

0 votes
Mehmet Kazgan Aug 11, 2014

The database scheme changes between two versions cause these type or errors. What I would do is to:

1. Use an empty database and set JIRA up with that.

2. Import XML you backed up from earlier version

See if that works. Sometimes little things frustrate too much, been there done that. Hang in there.

Fab Aug 11, 2014

good morning guys,

now i was finally able to make jira work now, it was an issue in the dbconfig.xml.

I can login, the profile pictures and probably also attachments are available, but i cannot see a single issue...

greetings

0 votes
Fab Aug 11, 2014

so re-indexing solved the problem of the missing issues :)

now i have just to switch to ssl and i am done ... i cannot believe it

thanks alot guys!!!

0 votes
Fab Aug 11, 2014

so everything is working now!

do i have to close this issue?

greetings

0 votes
Giuliano de Campos Atlassian Team Aug 12, 2014

Glad about it, Fab!

Since this is a Forum, there's no need to close the case. I just suggest you to click on the "Accept" button to have the the answer accepter. Right below the vote/downvote options for the answers. :)

Cheers,

Giu

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,989 views 46 44
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