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

I can't migration database from MySQL to PostgreSQL

I can't migration database from MySQL to PostgreSQL.  In the middle of the export process, the start-up setting comes out.

2 answers

1 accepted

0 votes
Answer accepted
Andy Heinzer Atlassian Team Sep 24, 2019

Hi Konstantin,

That log file shows a stuck thread, but that appears to clear and does not clearly show a problem to me.   I would like to gather a more complete set of logs from your environment so we can better understand this problem.  To do that I have created a support case on your behalf in https://getsupport.atlassian.com/servicedesk/customer/portal/20/GHS-165434

Please see the instructions there so we can try to help troubleshoot this further.

Thanks

Andy

0 votes
Andy Heinzer Atlassian Team Sep 12, 2019

Hi Konstantin,

I understand you are trying to migrate databases between MySQL and PostgreSQL, but I am unclear as to exactly what steps you are following to attempt to do this.  In regards to a Jira database, I would suggest trying to follow the steps in Switching databases

This process has you creating an XML backup .zip file in Jira and then creating a new blank database for Jira to use.  This way you can then import that data using Jira's setup wizard to import that backup into this new empty database.  

While it might be possible to use some kind of native database tool to try to convert this data, I don't have any experience in getting this part to work.  I would though recommend checking to make sure that your version of Jira is listed as a supported platform with the specific version of Postgres that you are trying to migrate to.  You can do this by checking against the appropriate Jira Supported Platforms page

Please let me know if this helps.

Andy

Hi Andy,

Yes, I created an XML backup .zip file. Then I created a new database on PostgreSQL.

But I had a issue then I tried exporting .zip file to new database. 

Export window goes to installation window.

Andy Heinzer Atlassian Team Sep 17, 2019

Hi Konstantin,

I'm not sure I follow what you mean.  Specifically the line:

Export window goes to installation window.

I don't know what you mean by this.   Do you mean that in the middle of trying to create the XML backup file that Jira takes you to the installation view?  Or that there are startup logs being generated in the backup itself?

  • Would it be possible for us to take a closer look at the $JIRAHOME/log/altassian-jira.log file at the time this backup is being created?
  • What version of Jira are you using here?

Unfortunately, our community site will not allow you to attach a file here.  So you would need to upload this file first to another service like Google Drive or Dropbox and then share a link to that file here.  I'd be happy to take a closer look at that log to see if we can learn more about the problem here.

Andy

Hi Andy,

I mean that in the middle of importing XML backup file to new database Jira take me to the installation view.

My version of Jira is Atlassian Jira (v8.4.0#804001-sha1:a071452)

 

Thanks.

Andy Heinzer Atlassian Team Sep 19, 2019

I would really like to take a closer look at the $JIRAHOME/log/altassian-jira.log OR the $JIRAINSTALL/logs/catalina.out file at the time of this import.

I'm thinking that something has gone horribly wrong on a SQL level or something else within Jira.  You should not be taken back to the installation wizard page during this import.  Instead when the import is complete, Jira should restart and take you to the login page.   If you are not getting that far, then there is most likely something wrong with the database, or Jira's ability to use that database as expected.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

273 views 1 2
Join discussion

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